Business Analyst

– Supported the Sales & Operations Planning (S&OP) process through data preparation and consolidation.
– Assisted in building top-down and bottom-up plans across categories and SKUs.
– Conducted sales analysis to identify trends, dynamics, and irregularities.
– Worked with large datasets using SAP, Excel, Power Query, and SAS.
– Helped develop dynamic analytical tools to support recurring reporting.
– Prepared monthly reports on shipments and sales by client and assortment.
– Performed ad-hoc research and data monitoring using open sources.
– Supported senior team members in preparing presentations and analytical materials.
– Gained hands-on experience in a structured corporate environment with cross-functional collaboration.

– Contributed to an international transformation project “Simplifying Demand Planning”, implementing a custom digital platform developed specifically for LEGO.
– Worked with a machine learning–based forecasting module, analyzing model logic, testing parameters, and collaborating with developers to improve performance and usability.
– Initiated and validated a new model parameter — number of distribution points, assessing its impact on forecast accuracy and business relevance.
– Designed an analytical approach for new product forecasting in categories with a high share of new SKUs (up to 50% annually).
– Achieved measurable impact through model and logic improvements:
+15% forecast accuracy (sell-out)
+10% forecast accuracy (sell-in).
– Built interactive dashboards and reports (Tableau, Power BI, Power Query) to support data-driven decisions.
– Actively collaborated with business, marketing, supply chain, and development teams, translating business needs into analytical solutions and improvements.
– Conducted user training sessions and supported adoption of the new platform.

– Prepared short-term demand forecasts on a weekly basis using historical sales data, seasonality, and business inputs.
– Adjusted forecasts across regions, distribution centers, and production plants while accounting for operational constraints.
– Analyzed inventory levels and shelf-life limitations to support availability and reduce operational risks.
– Worked closely with sales teams to understand client situations, promotional plans, and demand drivers.
– Actively participated in weekly forecast review meetings, providing structured explanations for changes and deviations.
– Supported new product launches and annual operational planning cycles.
– Prepared reports and presentations summarizing planning outcomes and insights.

– Participated in the early-stage implementation of the IBP cycle for the Makeup category during a company-wide transformation.
– Worked with FM Bloom, an internal digital planning platform: modeling forecasts for new launches and product phase-outs, validating logic and assumptions.
– Translated business inputs (sell-out trends, promotions, client forecasts, supply constraints) into structured forecast updates and scenarios.
– Prepared analytical materials and presented insights at key management meetings (PMR, Brand Forecast, DMR).
– Developed risk and opportunity scenarios to support decision-making in a highly volatile demand environment.
– Collaborated cross-functionally with Marketing, Business Planning, Supply, Finance, and Commercial teams to align data, assumptions, and decisions.

Impact
– OTFR: 92% on average, exceeding target by +2 p.p.
– SLOB provision kept within target, with zero product write-offs.
– Delivered regular analytical reporting, root-cause analysis, and action plans; conducted ABC analysis and supported SKU rationalization decisions.