Advance Excel
Hi, I’m
Uttam Singh
Demand & Supply Planner / Analyst
Kalyan West
Summary
Result driven supply chain professional with experience in Demand Planning for over 4+ years in Supply Chain Department, with a goal to improve initial forecast by applying error analysis techniques to maintain healthy inventory levels and avoid DEQ. Resolution to problems and analysis skills with demonstrated ability to work under pressure.
Overview
2
years of professional experience
6
years of post-secondary education
3
Certifications
Work History
Zepto (Kiranakart Technology Pvt LTD)
Demand Planning Manager
02.2022 - Current
Job overview
- Managed demand and supply planning for 4.98 cr category serving via 350+ Dark stores. Handled diverse FMCG categories like - Munchies, Packed Foods, Biscuits, Sweet Cravings, Pet Care & Breakfast and Sauces.
- Played key role to Coordinate all aspects of Demand Planning related to projects that support growth objectives/events, cost reductions, operational efficiency improvements etc in sync with category, sell-side, MH ops to boost sales and ensure availability of stocks with strategic approach towards capacity management.
- Order to Capacity Check and co-ordination with replenishment team for Critical Purchase order Scheduling to ensure 85% plus availability at MH (Supply Planning)
- Participate in Sales and Operations Planning (S&OP) meetings to review forecasts and make necessary adjustments.
- DEQ Analysis and Keeping check on inventory ageing and align subsequent liquidation support from brands through category and sell-side teams.
- Coordinated cross-functional teams in developing strategies for managing seasonal fluctuations in product demand.
- Improved forecast accuracy with regular reviews of historical sales data, identifying trends and adjusting future projections as needed.
- Co-ordination with category for 0 fills SKU's and handling assortment, achieved overall fill rate of 80%.
- Collected purchasing data and reduced data errors by over 10-15%
- Analyze historical sales trends, research demand drivers, prepare forecast data, and evaluate forecast results of past month to reduce MAPE MoM.
WorkStore Pvt LTD. (A Future Group Company)
Replenishment Executive - Demand Planning and Drop Shipment (B2B, B2C)
Job overview
- Planning & Business Analysis: Working closely with vendors and category managers to come up with an in-stock plan for a particular category
- Maintain the OTB budget (Open to Buy) and improve the inventory turns ratio
- Translates data analysis into decision recommendation to alter the plan as needed
- Strategic & Operational Planning: Watched company inventory to ensure stock levels keeping notice on DOI and nature of product
- Vendor Management: Acted as key point of contact between warehouse and vendors
- Integrated new vendors on operational requirements
- Influenced vendor operational performance management.
Education
Dr. Ambedkar Institute of TechnologyBangalore
Bachelor of Science from Mechanical Engineering
07.2015 - 08.2019
Jindal Vidya MandirBellary, Karnataka
High School Diploma
06.2013 - 06.2015
Skills
Advance Excel
Personal Snippets
DOB: 04/17/97
Gender: Male
language: English, Hindi, Kannada
Marital Status: Single
Nationality: Indian
Certification
Advance Excel
Hobbies
- Singing
- Outdoor sports
- Traveling
Achievements
Zepto Ace Achiever
Declaration
I Uttam Singh, hereby declare that the information held is true and correct to the best of my knowledge and belief.
Software
Power BI
SAP MM 770
Office 2010 and Above
SQL
Languages
English
Advanced (C1)
Hindi
Advanced (C1)
kannada
Elementary (A2)
Timeline
Demand Planning Manager
Zepto (Kiranakart Technology Pvt LTD)
02.2022 - Current
Dr. Ambedkar Institute of Technology
Bachelor of Science from Mechanical Engineering
07.2015 - 08.2019
Jindal Vidya Mandir
High School Diploma
06.2013 - 06.2015
Replenishment Executive - Demand Planning and Drop Shipment (B2B, B2C)
WorkStore Pvt LTD. (A Future Group Company)