Job Summary
Role Purpose Own centralized, data-driven spare-parts planning for GEMS Pan-India OM service network, covering both national demand and State Office-wise requirements. The role connects Service Operations, State Offices, Warehouses, Procurement, Stores and Vendors to ensure the right part, quantity, location and timing - while balancing service availability with inventory investment and working capital.
Key Accountabilities
- Develop the Pan-India spare-parts demand, replenishment and monthly / quarterly planning cycle.
- Prepare State Office-wise requirements using service demand, historical consumption, installed base, equipment criticality, lead times and inventory position.
- Set and periodically review Minimum Stock, Maximum Stock, Reorder Level and Safety Stock for critical and fast-moving parts.
- Analyse breakdown, preventive-maintenance, warranty / AMC and recurring-failure trends to forecast future spare consumption.
- Monitor stock-outs, excess, slow-moving, non-moving and ageing inventory; recommend inter-State / inter-location transfers.
- Coordinate with Procurement on planned and critical purchases, supplier lead times, open POs and expected deliveries.
- Maintain and monitor a Critical Spare Parts List and contingency plans for long-lead / business-critical components.
- Create management MIS and dashboards covering availability, consumption, forecast vs. actual, inventory health, open POs and service-impact risks.
- Drive planning-process standardisation and improve data quality, planning parameters and reporting through ERP / Excel / Power BI tools.
Technical Functional Competencies
- Spare parts inventory planning
- Data, systems analytics
- Demand forecasting consumption analysis
- Advanced MS Excel
- Reorder / Safety Stock determination
- Pivot Tables, XLOOKUP / INDEX-MATCH, SUMIFS
- ABC / XYZ / FSN analysis
- ERP / Inventory Management Systems
- Inventory ageing stock coverage
- MIS and management reporting
- Excess obsolete inventory management
- Power BI - preferred
- Critical spare identification
- SAP / Microsoft Dynamics - preferred
- Inter-location stock transfer planning
- Dashboard / reporting automation - preferred
Core Competencies
- Analytical Mindset
- Ownership
- Problem Solving
- Cross-functional Collaboration
- Planning Execution
- Communication
- Service Orientation
What Success Looks Like
The successful candidate will establish a predictable, responsive and data-driven spare-parts planning process across the GEMS OM network - balancing high service availability with optimum inventory and working capital.