Summary
Overview
Work History
Education
Skills
Extra Curriculars
Awards
Positions Of Responsibility
Timeline
Generic

MILAN KUMAR SEN

LOWER PAREL

Summary

Experienced planning professional with a strong background in strategic planning and resource optimization. Managed extensive SKU portfolios and streamlined supply chain processes, resulting in improved workflow efficiency and achievement of project milestones. Ability to enhance inventory accuracy, minimize wastage, and maintain high stock availability. Recognized for exceptional organizational skills and a collaborative problem-solving approach.

Overview

3
3
years of professional experience

Work History

Planning Manager- M2

Zepto
08.2022 - Current
  • FMCG Planning – Demand and Distribution planning.
  • Overseeing a portfolio of 12000+ SKUs in the FMCG categories for NCR, Lucknow, SAS Nagar and Jaipur with around 2,77,210 of total OPD.
  • Consistently maintaining availability at DS at 90% levels throughout all sub-categories, except for unanticipated events such as delayed delivery and FR gaps.
  • Developed a comprehensive End-to-End inventory report that provides real-time data of stocks at every stage in the integrated planning process, from the warehouse to the dark stores.
  • Launched 200+ new dark stores at 85% levels through all subcategories at more than 10,000 assortment levels.
  • Implemented crossdock execution successfully across NCR region which led to monthly inventory optimization of 10 lac units across two warehouses saving ~ 8.2 lac (in COGS) monthly from Jan’24 to March ’24 at 0.82 CPU
  • Minimized store congestion by running recirculation of around 4,05,905 units of High DOH and festive inventory in August ’24 keeping down the utilization of stores below 85% consistently.
  • Identified near expiry SKUs and coordinated with the Category, Procurement & Replenishment and City Warehouse teams to bring about a prompt stock liquidation, saving around ~13.5 lac (in COGS).
  • Managed bi-weekly auto purchase planning per inventory norms, ensuring 100% pipeline availability for the food category.
  • Designed a scheduling plan ensuring 90% minimum stock in warehouses and 85% availability at dark stores, improving availability by 300 bps across India through distribution monitoring.
  • Reduced DOH by 20% vs Inventory norms for the top three FMCG companies through optimized replenishment and vendor management.
  • Achieved 75% forecast accuracy for monthly and festive sales of top FMCG food companies, driving a 70% New Year sales surge vs 50% last year.
  • Led seasonal and promotional demand planning, ensuring high availability while minimizing overstock.

Inventory Planning and Control Intern

Zepto
02.2022 - 07.2022
  • Oversaw a portfolio of 300+ SKUs in the Dairy, Breads and Eggs category for Kolkata region.
  • Reduced expiry in Dairy, Breads and Eggs category for Chennai from 3.5 CPO to 0.8 CPO levels by strategically planning lower shelf-life sub-categories and SKUs, thereby lowering overall organizational expiry.
  • Consistently maintaining In stocks (i.e Availability) at DS at 95% levels throughout all sub-categories.
  • Initiated data validation procedures for FMCG and Fresh master data and maintained 99% accuracy rate by regularly reviewing data hygiene to guarantee accurate data ensemble.
  • Improved the forecast accuracy rates to 70-75% by developing key performance indicators like Plan vs Actual, MAPE, Forecast Bias analysis and expediting timely communications to relevant stakeholders.
  • Designed a dashboard that monitors the Minimum stock levels at warehouses (MSL) to improve scheduling at MH and availability levels at dark stores.

Data Analyst Intern

Pantech Solutions Pvt Ltd
01.2022 - 02.2022
  • Carried out sales prediction and Exploratory data analysis (EDA) using applied statistical models.
  • Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
  • Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
  • Achieved 70% forecast accuracy for Retail sales of top FMCG brands.
  • Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.

Education

M.B.A - Marketing Management

NMIMS GASCE
Mumbai
01.2022

B.Sc - Statistics

K.C College
Mumbai
01.2018

Skills

  • Experienced with Thor Framework
  • Vinculum Management
  • Proficient in Superset Workouts
  • Proficient in MS Excel
  • Microsoft Office Proficiency
  • Effective Issue Management
  • Interdepartmental Cooperation
  • Data-Driven Demand Analysis
  • Project Coordination

Extra Curriculars

  • Gold Medal, HSNC football championship, 2017
  • Among 30 players selected for coaching clinic camp conducted by Queens Park Rangers Club of England.

Awards

  • Gold Medal, Big Data Analytics Championship, KC College, 2017
  • Published paper, Sentiment Analysis of Twitter Data, UGC listed multidisciplinary journal ‘GENIUS’ (ISSN 2279 – 0489)
  • Project Presentation, International conferences on Social Sciences and Environmental Concerns, MB Harris College, 2018

Positions Of Responsibility

  • Head: Events, X Static, St. Xaviers College, 2016, 2017, Organised management events being a contingent leader and managed over 120 participants.
  • Vice-captain, University Football Championship, Mumbai University, 2016, 2017, Won the first university championship for KC College by staying unbeaten throughout the tournament.

Timeline

Planning Manager- M2

Zepto
08.2022 - Current

Inventory Planning and Control Intern

Zepto
02.2022 - 07.2022

Data Analyst Intern

Pantech Solutions Pvt Ltd
01.2022 - 02.2022

M.B.A - Marketing Management

NMIMS GASCE

B.Sc - Statistics

K.C College

Similar Profiles

CREATE PROFILE
MILAN KUMAR SEN