Shivangi

- Led production and revamped 12+ monthly sell-in and sell-out reports across skincare, makeup, and fragrance; expanded coverage to 4 priority markets (FR, DE, IT, ES) and reduced turnaround time by 50% (2 days → 1 day), enabling faster decision-making for 17 affiliates.
- Analysed 18+ product launches annually, influencing demand forecasting and pricing strategies; insights supported launches generating €3M+ in incremental sales across EMEA.
- Conducted annual pricing analysis across 17 affiliates for all categories (skincare, makeup, fragrance); established pricing guidelines for 100+ SKUs, improving profitability margins by an estimated 3–5%.
- Led product assortment reviews for two pricing cycles, evaluating 900+ SKUs per cycle and recommending 10–15% SKU rationalization, streamlining assortments and boosting portfolio efficiency across affiliates.
- Built and updated innovation calendars tracking 15–20 launches annually, projecting €50M+ gross retail sales and ~25% contribution to total business; delivered monthly updates to track launch alignment with business goals.
- Partnered with demand planning to forecast units for 10+ pipeline launches, ensuring accurate allocation across multiple affiliates and reducing forecast error rates by an estimated 10%.
- Delivered competitive intelligence reports benchmarking 50+ competitor launches annually on pricing, claims, and innovation, enhancing transparency and supporting positioning strategy.
- Supported virtual merchandising strategy across 130–190 Sephora doors in France, Italy, and Spain, optimizing product visibility and consumer journey, with an estimated +5–10% sales uplift in participating doors.
- Researched and shaped sets strategy (Spring & Christmas FY25/26), analyzing competitor assortment/pricing; insights influenced strategy for 20+ seasonal SKUs.
- Delivered 20+ ad hoc analytics requests for cross-category performance, affiliate events, and retailer activations, improving agility in campaign execution.

• Led 80+ client calls with senior stakeholders and provided dynamic solutions to questions related to team’s area of expertise and created strategic process flows to identify future problems.
• Modelled a new methodology based on the foundations of previous methodology resulting in more dynamic and 12% more accurate (96% total) sales goal forecasting.
• Developed potential customer-base identification tool that enables targeting customer-rich geographical areas to launch more than 4 products (7+ indications) and used data analytics to measure key performance metrics for product launches.
• Onboarded 7+ senior stakeholders (client side) and 3 senior management members to the team during transitions within team by providing knowledge transfer in all areas of team’s expertise.
• Mentored 3 new associates in the team by helping them produce key reporting deliverables with 0% error and improving their technical expertise in SQL and Excel.
• Collaborated with more than 3 companies externally and 10 teams internally to deliver 100+ regular and adhoc reports with 100% quality assurance on a regular cadence.