Responsible for overall supply chain planning for the largest division - Consumer ProductsDemand and Supply Management• Managed the biggest portfolio of the company, L’oreal Make-up involving the complexities of both luxury and mass products. • Managed supplies from multiple L’oreal factories around the world including the US, France, India, and Egypt.• Monthly collaborative forecasting sessions with marketing and commercial followed by sales and operations planning meetings with the senior management.• Handling supplier queries and supply issues with factories• Managed efficient communication and information flow between all stakeholders: Factories, Marketing, Operations, Finance, Distributors, Customer Service, and Management.Supply Chain Analysis• Monthly KPIs: Stock evolution, Forecast Accuracy, Supplier Service Rate, Customer Service Level, SLOB• Decide appropriate measures on provision and near expiry stocks• Managed Stock days while maintaining the desired service rate in line with Supply Chain StrategyProcess Improvement• Revamped the demand planning and order fulfillment for HUB countries • Developed ‘Transmission Simulation’ to minimize the variance in monthly orders to factories.• Developed excel based tool to analyze Sell-in and Sell-out trend at SKU/Brand/Category level.Major Achievements• Reduced HUB planning cycle by 2 weeks by implementing efficient and automated demand planning and order fulfillment tools leading to better reactivity and service to HUB business• Improved forecast accuracy by 6% in 4 months.• Achieved stock availability up to 99.2% by efficient Demand and Supply Management.• Designed and implemented excel simulated reports to enhance end to end visibility of Supply Chain.