Job highlights

- Excess obsolete inventory management. Power BI - preferred. Critical spare identification. SAP / Microsoft Dynamics - preferred. Inter-location stock transfer planning. Dashboard / reporting automation - preferred

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 rapid-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.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 NOIDA- SPARE PARTS PLANNER
🏢 General Energy Management Systems
📍 Noida