About Ignacio
I’m a Data & Business Analyst with experience translating complex data into actionable business decisions across global organizations.
At Coty, I support global demand planning and supply analytics for large scale seasonal campaigns, developing end to end analytical solutions using SQL, Python, and Power BI. My work has contributed to double digit reductions in Value at Risk through earlier visibility, scenario analysis, and data driven allocation decisions.
My experience includes:
• Building automated data workflows and reporting solutions in Python and SQL
• Designing executive level dashboards and KPI frameworks in Power BI
• Applying statistical analysis to forecasting, planning, and business performance
• Partnering with Supply, Finance, Marketing, and commercial stakeholders to support strategic decisions
Previously at Panasonic, I supported forecasting and commercial reporting for Iberia, improving reporting efficiency and delivering analytical insights for business teams.
I also hold a Bachelor of Medicine, which strengthened my analytical thinking, structured problem solving, and ability to operate effectively in complex and uncertain environments.
Spanish
Native or bilingual
English
Fluent
Can work on-site
Barcelona (up to 10km)
Experience
- COTYData Analyst ForecastingMay 2024 - Today (2 years and 2 months)Barcelona, Spain• • Owned end-to-end analytics for global giftset campaigns (multi-million units), driving allocation, launch readiness, and risk mitigation decisions across dozens of markets and senior stakeholders• • Established and led a structured forecast challenge framework, stress-testing market assumptions against historical performance and in-season signals, improving forecast quality and downstream supply decisions• • Designed and scaled a Quota vs Forecast decision system (Power BI + SQL + Python) used by Supply, Finance, and Commercial teams as a primary decision tool, enabling earlier interventions and reducing Value at Risk (VAR) by double digits• • Led advanced demand analysis under uncertainty, applying statistical techniques (trend decomposition, correlation analysis, anomaly detection) to support scenario planning and campaign phasing• • Built and productionized automated data pipelines consolidating multi-source inputs, reducing manual effort by ~80% and accelerating executive decision-making cycles• • Acted as a strategic partner to cross-functional stakeholders, translating ambiguous business questions into structured analytical approaches and clear, actionable recommendationsTech stack: MS Excel, Power BI, Python (pandas, NumPy, matplotlib, seaborn, scikit-learn), SQL, SAP S/4HANA, o9 Solutions, JDA / BlueYonder
- PANASONICData Analyst Forecasting & ReportingAugust 2021 - April 2024 (2 years and 8 months)Barcelona, Spain• • Owned data extraction, validation, and transformation workflows from SAP BW and POS systems to support forecasting and commercial decision-making across Iberia• • Designed and maintained KPI dashboards (Excel & Power BI) to track sell-in/sell-out performance and forecast accuracy, improving visibility and decision speed for Sales and Marketing teams• • Automated recurring data processes using Python and VBA, reducing manual workload by ~40% and improving reporting reliability• • Partnered cross-functionally with Sales, Marketing, and Finance to analyze forecast deviations, identify demand gaps, and drive data-informed corrective actions• • Developed and optimized SQL queries for large-scale data extraction and ad-hoc analysis, enabling faster access to critical business insights• • Led initiatives to improve data quality and standardize reporting, increasing consistency and trust in analytics outputs across the planning function
- Administrative & Teaching RolesVarious CompaniesJanuary 2010 - January 2021 (11 years)Buenos Aires, ArgentinaVarious positions focused on operations, administration, coordination, and stakeholder communication.
Recommendations
Be the first to recommend Ignacio
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
- Medicine Bachelor of MedicineUNIVERSIDAD DEL SALVADOR2019Medicine Bachelor of Medicine
Certifications
- Google Advanced Data Analytics SpecializationGoogle2024
- IBM Data AnalystIBM2026