Demand Planner
CurrentKey Result Areas:• Developed and executed demand forecasts by SKU, incorporating the Sales & Marketing Action Plan, in alignment with company policies.• Ensured stock covers were within target levels and facilitated seamless product transfers.• Verified that incoming goods had the necessary purchase orders in advance and investigated discrepancies, reporting variances.• Collaborated with various departments, including Retail, trade, marketing, and B2B, to maintain an accurate and timely activity overview.• Managed portfolio and product life cycle, optimizing inventory levels, and implementing launch and phase-out programs.• Calculated quantities for transfer to retail location (through min-max), coordinating with warehouse team and transport teams.• Monitor expiry date of Coffee and Food items and alert in advance for any potential expiry issues, Manage Inventory write-off process across all locations. Highlight critical SKUs that are overstock or under stock to take necessary actions.Highlights:• Established POWER BI reports which help management to view live information and optimized decision-making capacity. Like Sales Performance Report, Promotion Tracker, Inventory Overview Report.• Developed automated Excel reports using SQL and Power Query which help to work with more efficiently with grate accuracy.• Monthly reports - Sales Dashboard for Retail, Trade, Ecommerce, and B2B channel, Joint Business Plan for Top Management, and NORA reporting (Weekly and Monthly).