Freelancer profile translated to English.

Description

Business Intelligence consultant with experience in designing and developing analytical solutions for commercial and financial areas. Specialized in creating data models, dashboards, and KPIs using Power BI and SQL, transforming complex data into useful information for decision-making.

My previous experience as a Business Controller allows me to combine technical knowledge with a solid business vision, collaborating closely with management, finance, and commercial teams to improve performance and facilitate strategic planning.

Languages

Catalan
Native or bilingual
Spanish
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Barcelona (up to 50km)

DERMOFARM
BUSINESS CONTROLLER & POWER BI DEVELOPER
January 2025 - Today (1 year and 7 months)
Comprehensive development of dashboards in Power BI for Management, Administration, and Sales Network.
Design and maintenance of data models oriented towards commercial and financial analysis.
Preparation and monitoring of budgets and forecasts. Definition and monitoring of strategic KPIs.
Analysis of sales, profitability, and deviations to support decision-making.
Automation of periodic reports, reducing manual reporting work.
Collaboration with the Finance, Commercial, and Management departments.
Microsoft Power BI Power BI DAX SQL Microsoft Excel Controlling
MARTIDERM
COMMERCIAL CONTROLLER
January 2022 - January 2025 (3 years)
Development of commercial reports using Power BI and Excel, utilizing information from SAP and CRM.
Monitoring of sales, profitability, objective achievement, and commercial indicator evolution.
Calculation of incentives and settlements for the sales network.
Analysis of results by channel, region, client, and product.
Participation in monthly closing and commercial planning processes.
MARTIDERM
ADMINISTRATIVE ASSISTANT
January 2020 - January 2022 (2 years)
Commercial administrative management, invoicing, orders, collections, and support to the commercial department.
Monthly and annual accounting closings.