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.