About Carmelo
Spanish
Native or bilingual
English
Conversational
Experience
- EQMBI Consultant | RemoteCONSULTING AND AUDITSJanuary 2025 - Today (1 year and 6 months)Sevilla, SpainBusiness Intelligence consulting for various clients, designing tailor-made solutions within the Microsoft ecosystem (Power BI, Azure, D365FO, Business Central, and Power Apps). I accompany each project end-to-end: starting with requirements gathering with the client to understand their business, building data pipelines in Azure Synapse and integrating information from their ERP and other sources, and designing dimensional data models (star/snowflake) optimized to ensure report performance.On this foundation, I develop the analytical layer: complex KPIs in DAX, data transformations in Power Query, custom views, and row-level security (RLS) implementation, ensuring each user accesses only the information relevant to them. I pay special attention to the visual experience of the dashboards — with custom backgrounds and iconography — because a dashboard only adds value if it is clear, actionable, and easy to interpret for decision-makers.My goal in each delivery is for the client to have a robust, maintainable solution aligned with their key indicators, capable of transforming operational data from their ERP into useful information for management, and ready to use without constant support.
- LáserumData Analyst | IberiaHEALTH AND WELLNESSAugust 2023 - November 2024 (1 year and 2 months)Seville, SpainAs an internal (in-house) data analyst, I was the go-to person for data analysis and Business Intelligence solutions for the group. I worked on a Google Cloud architecture, building pipelines that integrated data from multiple sources using Dataflow and Cloud Storage, and I designed and developed the corporate dashboards and panels in Power BI, along with reports in Excel for the different areas of the company.Beyond building reports, I defined and maintained the organization's KPI framework: I analyzed data to propose new indicators and review, modify, or remove existing ones, ensuring that the metrics remained relevant to the business. I was responsible for the optimization and advanced management of models with DAX Studio, Tabular Editor, and ALM Toolkit, and for data governance: creation and management of roles, permissions, and access.A significant part of my role was enabling the organization: I provided support and training to users on using Power BI and correctly interpreting key KPIs, fostering autonomy and a data culture within the company.
- AubayBusiness Intelligence Consultant | RemoteCONSULTING AND AUDITSOctober 2022 - July 2023 (9 months)Sevilla, SpainRegarding contact with the end client, I carried out consulting with the following tasks:- Introductory training on the implementation of BI in the company.- Requirements gathering for that implementation.- Study of the data the client has and the database they work with.- Execution of the necessary ETL process for adequate data preparation to work with them in Power BI, including connecting Power BI to the client's various data sources.- Development of analytical reports/dashboards according to client needs, representing and considering the most relevant metrics or KPIs for the client or their industry.- Conducting consulting/support meetings to resolve any doubts or problems the client may have regarding the above or the use of Power BI Desktop or Power BI Service.Regarding internal management:- Team management of clients and related projects, using tools like: Jira, Microsoft Teams, Sharepoint, Outlook, etc.- Management of client Power BI licenses and users: user creation, license assignment, tenant configuration, etc.
Recommendations
Be the first to recommend Carmelo
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Business Intelligence Coursent:For (Nortempo for Learning)20221. INTELIGENCIA DE NEGOCIOS. 1.1. Introducción. 1.2. La pirámide organizacional. 1.3. Herramientas de inteligencia de negocios. 1.4. Fundamentos del Datawarehouse . 1.5. Características. 1.6. Ventajas. 1.7. Sistemas OLTP. 1.8. Implementación del Datawarehouse. 1.9. Análisis OLAP (Drill Down, Drill Up). 1.10. Servidores OLAP (ROLAP, MOLAP, HOLAP, Minería de Datos, Definiciones de Data Mining). 1.11. Categorías de Data Mining. 1.12. Proceso de Minería de Datos. 1.13. Metodología. 1.14. Reportes. 1.15. Consultas. 1.16. Alertas. 1.17. Análisis. 1.18. Pronósticos. 2. LA GESTIÓN DE PROYECTOS DE BUSSINES INTELLIGENCE. Proyectos: 2.1. Gestión. 2.2. Planificación. 2.3. Riesgos. 3. ARQUITECTURA DE UN PROYECTO DE BUSINESS INTELLIGENCE. 3.1. Procesos de Extracción, Transformación y Carga. 3.2. El almacén de Datos. Herramientas de Visualización y consulta: 3.3. Reportes. 3.4. DashBoards. 3.5. OLAP. 3.6. Data Mining. 3.7. Procesos ETL. 3.8. Cubos multidimensionales.
- Data Mining & Business Intelligence Coursent:For (Nortempo for Learning)20231. MINERÍA DE DATOS. 2. FASE DE SELECCIÓN EN MINERÍA DE DATOS. 3. FASE DE EXPLORACIÓN EN MINERÍA DE DATOS. 4. FASE DE LIMPIEZA Y TRANSFORMACIÓN EN MINERÍA DE DATOS. 5. FASE DE ANÁLISIS DE DATOS. 6. TÉCNICAS DE APLICACIÓN. 7. TÉCNICAS PREDICTIVAS DE MODELIZACIÓN. 8. TÉCNICAS DESCRIPTIVAS Y PREDICTIVAS DE CLASIFICACIÓN. 9. TÉCNICAS DE EVALUACIÓN. 10. TÉCNICAS. 11. CAMPAÑAS: OFERTAS JUST-IN-TIME.
Certifications
- Build a Data Warehouse with BigQueryGoogle Cloud2024
- Power BI: Data Modeling with Power QueryLinkedIn2024