Results-driven Supply Chain Professional with 15 years of experience in supply chain planning, inventory management, and demand forecasting across diverse sectors. Skilled in advanced Excel, Power BI, PostgreSQL, Python, VBA, SAP ECC, Microsoft Dynamics AX, and Oracle RMS. Delivered efficiencies through process automation and improved inventory availability, enabling data-driven decision making.
Overview
1
1
Certification
15
15
years of professional experience
Work History
Senior Manager - Supply Chain
Jaypee Brothers Medical Publisher Pvt Ltd.
05.2024 - Current
Manager- Supply Chain Planning & Analysis
Jaypee Brothers Medical Publishers Pvt. Ltd
New Delhi
05.2022 - 05.2024
Lead end-to-end supply chain planning, demand forecasting, inventory management, and replenishment across pan-India distribution channels to ensure optimal product availability and service levels.
Design and manage supply chain planning systems, data models, and analytical solutions to support strategic decision-making and process improvement.
Drive process automation using Advanced Excel, VBA, PostgreSQL, Python, Power BI, and OneDrive, reducing manual effort, improving accuracy, and accelerating reporting.
Develop automated dashboards and real-time trackers for production planning, purchase orders (POs), RFQs, logistics, vendor performance, inventory, and supply chain KPIs.
Analyse sales trends, historical demand, seasonality, and inventory data to improve forecast accuracy and optimize inventory planning.
Manage demand forecasting and inventory planning for Titles basis ABC Analysis to optimize replenishment, improve inventory turnover, minimize stock-outs and excess inventory, and reduce carrying costs.
Ensure product stock is adequate in all distribution channel locations in
accordance with seasonality, and can cover direct demand from customers.
Review inventory trends, suggest and manage replenishment, and print and
liquidate inventory based on slow, medium, and fast-moving categories.
Monitor stock levels, plan and manage pan-India replenishment, and stock
transfers in accordance with sales trends and inventory levels.
Collaborate with procurement, production, sales, finance, logistics, and warehouse teams to improve service levels and cross-functional coordination.
Review supply chain KPIs, vendor TAT, logistics performance, and inventory metrics to provide actionable insights and support inventory optimization
Assistant Manager- Planning & Replenishment
CP Wholesale India Pvt Ltd (Siam Makro)
Gurugram, Haryana
05.2020 - 04.2022
Conduct analysis on demand and supply trends to drive accurate ordering.
Identify opportunities to enhance business KPI performance, supporting sales through targeted inventory strategies.
Work jointly with Buyers, Stores, and Vendors to understand the market trend and seasonality factors to plan better availability for the category and liquidate high DOH inventories.
Maintain parameters such as lead times, order cycles, service levels, forecasts, and promotional events.
Updated ARS and created min-max for categories in RMS, reviewing weekly to ensure optimal stock levels.
Set up and maintain the distribution requirements by stores, and the corresponding assortment.
Follow up on POs with the vendors for the timely dispatch of stocks to the respective units and warehouse, and ensure they arrive at the warehouse or store on time.
Coordinated with Store/WH for receipt management, sin-bin issues, and invoice resolution to maintain smooth operations.
Work jointly with a cross-functional team for tasks such as manual PO control, store issue resolution, and SKU inventory reduction.
Develop action plans and recommend substitutions on Division SKU issues pertaining to new store openings, best sellers, slow sellers, and aged inventory.
Highlighted concerns to buyers and vendors to facilitate issue resolution.
Analyse and discuss ageing inventory data with category buyers, and develop an action plan for high MOQ vendors.
Assistant Manager- Supply Chain
Coffee Day Global Ltd (Division- Café Coffee Day)
New Delhi, Delhi
08.2017 - 04.2020
Manage and coordinate the material planning (MRP), inventory control, storage, stock shipping, and receiving functions at a high level of accuracy using supply chain management software.
Ensure the availability of all SKUs, including RM and packaging materials, as per forecast/plan, while maintaining the lowest inventory and inventory freshness.
Work with procurement and production to avoid shortages of RM and PM, and ensure purchase orders are complete on time.
Maintain an accurate and organised RM, PM, and finished goods inventory at the DC.
Minimise obsolete, damaged, and ageing inventory in the system.
Monitor proper stock rotation depending on seasonality, and ensure liquidation as per defined SOPs and before TAT.
Developed strong relationships with key suppliers, enhancing reliability and efficiency in supply chain operations.
Monitored vendor performance and ensured timely receipt of correct supplier documents at distribution centre.
Submitted GRN promptly and liaised with accounts to facilitate timely supplier payments.
Performed monthly reconciliation of vendor accounts to ensure accurate payment processing.
Directed daily operations to achieve maximum efficiency and productivity.
Conducted regular performance reviews, identifying areas for improvement and implementing corrective measures.
Assistant Manager- Operations
B9 Beverages Pvt Ltd (Bira 91)
New Delhi, Delhi
07.2015 - 08.2017
Managed and coordinated day-to-day bond operations to ensure compliance and efficiency.
Drive C& F/distributor teams to support Distribution, and Visibility KPIs of the company.
Proactively manage order to meet committed delivery date and any special delivery requirement.
Monitored indents and ensured order fulfilment within permit validity to prevent delivery disruptions.
Play a proactive role in planning and management of adequate stock inventory at the depot level to ensure availability of stocks for timely dispatch helping the company avoid situation of permit expiry/ non-delivery of goods.
Reviewed distributor/C&F policies and procedures, visited operations, and recommended improvements to enhance performance.
Capture and analyze root causes for customer/ distributor issues and trigger initiatives to improve the customer/ distributor experience.
Facilitated operations for imported beer shipments, ensuring compliance with regulations and timely delivery.
Follow up all documents in order to complete customs formalities for inbound process.
Prepare/arrange all documents for Bond to Bond transfer of stocks and thus maintain proper imported beer stock level at distributor place to avoid sale loss.
Coordinate & interact with various departments internally and maintain effective timelines of communication with partners and distributors/C&F and cross-functional teams to resolve customer order related issues.
Executive- Operations
Chemisynth
Gurugram, Haryana
11.2012 - 07.2015
Liaised with customers and suppliers, negotiating terms to strengthen partnerships and enhance service delivery.
Coordinated contract manufacturing activities, ensuring alignment with modern trade and private label requirements.
Ensured prompt collection of payments from customers to support financial stability.
Execution & coordination for all indents with plant & Customers.
Ensure that the right products are delivered to the right location on time and at a good cost.
Participated in operational and functional processes to ensure efficiency.
Maintained production Plans, RM & PM and Finished Goods stock levels for respective clients.
Facilitated suggestions to Technical & Quality team, contributing to product assortment planning, vendor management, and pricing strategies for private label initiatives.
Evaluated product condition to determine acceptance or rejection based on company standards.
Resolving queries related with LCs/DP/ Contracts / Documents / Logistics etc.
Check, Prepare Export related Documents.
Ensure the releasing of B/Ls on time.
Preparing & Updating Cost sheets.
Responding to business queries and strong subsequent follow-ups.
Involvement in all issues/Negotiations related with Payments/Logistic/Shipping Lines/CHA.
Market Developer
Hindustan Coca-Cola Beverages Pvt Ltd
New Delhi, Delhi
04.2011 - 10.2012
Managed sales activities across designated geographical area to drive market growth.
Executed monthly sales planning and activities to achieve sales targets and enhance market presence.
Monthly sales planning, execution & ensuring sales target are achieved.
Achieved planned sales and distribution targets.
To Increase the sales in the currently existing markets by maximizing point of sales.
Maintained availability and visibility of our entire range of products.
Executed various promotional activities smoothly as scheduled.
Ensure Distribution of Product on time in the market.
Executed daily delivery routes to ensure timely product availability.
Maintain Daily MIS Report.
Education
Master of Business Administration - Sales & Marketing
Periyar University
New Delhi, Delhi
07.2010
Bachelor of Science - Physics & Chemistry
Bundelkhand University
Jhansi, Uttar Pradesh
07.2006
Intermediate - Science
Kendriya Vidyalaya
Siliguri, West Bengal
04.2003
High School - Science
Kendriya Vidyalaya
Siliguri, West Bengal
04.2001
Skills
Inventory management
Order processing
Supply chain planning
Vendor management
Process improvement
Process automation
Data analysis
Strategic planning
Cost reduction strategies
Contract manufacturing
Demand forecasting
Performance analysis
Data-driven decision-making
Project management
Technical
MS-Windows
Advanced Excel & VBA/Macros
OneDrive Shared Workbooks.
Dashboards
Power BI •
PostgreSQL •
Python basic
Microsoft Dynamics AX
SAP R/3 ECC 6.0
Oracle RMS
C-Soft•
Certification
Global Association for Planning & Strategy Professional, 2020-01-01
Analyze Problem & Make Decisions, Dale Carnegie Training India, 2020-01-01
Adjust to Change, Dale Carnegie Training India, 2020-01-01
Certificate in Material Management, Welingkar Institute of Management Development & Research, 2020-05-01
Personal Information
Father's Name: Mr. Manbar Singh
Date of birth: 1986-05-31
Gender: Male
Nationality: Indian
Marital status: Married
Languages
Hindi
Advanced
C1
English
Advanced
C1
Declaration
I, Sandeep Singh, hereby declare that the information contained herein is true and correct to the best of my knowledge and belief.
Timeline
Senior Manager - Supply Chain
Jaypee Brothers Medical Publisher Pvt Ltd.
05.2024 - Current
Manager- Supply Chain Planning & Analysis
Jaypee Brothers Medical Publishers Pvt. Ltd
05.2022 - 05.2024
Assistant Manager- Planning & Replenishment
CP Wholesale India Pvt Ltd (Siam Makro)
05.2020 - 04.2022
Assistant Manager- Supply Chain
Coffee Day Global Ltd (Division- Café Coffee Day)
08.2017 - 04.2020
Assistant Manager- Operations
B9 Beverages Pvt Ltd (Bira 91)
07.2015 - 08.2017
Executive- Operations
Chemisynth
11.2012 - 07.2015
Market Developer
Hindustan Coca-Cola Beverages Pvt Ltd
04.2011 - 10.2012
Master of Business Administration - Sales & Marketing
Senior Demand and Supply Chain Manager at Sharaf DG - Consumer Electronic – Part of Sharaf GroupSenior Demand and Supply Chain Manager at Sharaf DG - Consumer Electronic – Part of Sharaf Group