Sr. Executive Forecasting & Planning

Modicare; India; On-site; INR 700,000 - 1,100,000; Full time

Job summary

Modicare is seeking an Executive/Sr. Executive Forecasting & Planning in India to lead demand forecasting for a portfolio of 900+ SKUs. The role blends statistical forecasting, Python analytics, ERP-based insights and cross-functional collaboration to drive forecast accuracy and inventory optimization.

You will develop SKU-level forecasts, monitor accuracy, and participate in S&OP cycles, while leveraging MISHA-based planning tools and BI dashboards to inform strategic decisions.

Qualifications

• Bachelor's degree in Management, Business, Supply Chain or related field.
• 2–5 years of experience in demand planning, forecasting or supply chain analytics.
• Certification in Supply Chain Management preferred.
• Certification/coursework in Data Analytics or applied Gen AI preferred.

Responsibilities

• Develop and maintain SKU-level demand forecasts using statistical methods and Python-based analytics.
• Monitor forecast accuracy metrics (MAPE, forecast bias) and correct systemic errors.
• Apply ABC/XYZ segmentation to prioritize forecasting effort and inventory policy.
• Collaborate with supply planning, logistics and production to balance demand with capacity.
• Flag demand-supply gaps and support scenario planning for high-variability SKUs.
• Conduct inventory and replenishment analysis to optimize stock availability.
• Support replenishment and transportation planning across distribution centers to improve turnover.
• Build and maintain automated dashboards (Power BI, Excel) for KPIs and reporting.
• Ensure data integrity across ERP-integrated planning workflows (MISHA).
• Perform root cause analysis on demand fluctuations and exceptions.
• Present findings and corrective actions to cross-functional stakeholders.
• Participate in monthly S&OP cycles and communicate forecast insights and risks.

Job description

Job Description for:

Executive/Sr. Executive Forecasting & Planning

1.0 Reporting line

The position will report to the AGM – Forecasting & Planning.

2.0 Position Summary:

The Demand Planner & Forecasting Person is responsible for developing, maintaining, and continuously improving demand forecasts across a large SKU portfolio (900+ SKUs) to support supply-demand alignment, inventory optimization, and operational efficiency. The role combines statistical forecasting, ERP-based analytics, and cross-functional coordination to ensure forecast accuracy, minimize inventory imbalances, and support data-driven S&OP decision-making

3.0 JOB RESPONSIBILITIES:

Demand Forecasting & Statistical Modelling

• Develop and maintain SKU-level demand forecasts using statistical methods (exponential smoothing, Delphi method, time-series analysis) combined with Python-based analytics.
• Monitor and report forecast accuracy metrics (MAPE, forecast bias) on a recurring cadence; investigate and correct systemic forecasting errors.
• Apply ABC/XYZ segmentation to prioritize forecasting effort and inventory policy by SKU criticality and demand variability.

Supply-Demand Alignment

• Collaborate with supply planning, logistics, and production teams to balance forecasted demand against operational and manufacturing capacity.
• Flag demand-supply gaps proactively and support scenario planning for high-variability or promotional SKUs.

Inventory & Replenishment Analysis

• Conduct inventory and replenishment analysis to optimize stock availability while minimizing excess and obsolete inventory.
• Support replenishment and transportation planning across distribution centers (MLCs/MSCs) to improve inventory turnover.

Reporting & Analytics Automation

• Build and maintain automated dashboards (Power BI, Excel) for forecast accuracy, inventory movement, service levels, and other planning KPIs.
• Ensure data integrity and reporting consistency across ERP-integrated planning workflows.
• Utilize the organization's AI-driven ERP system (MISHA) for planning visibility and process efficiency.

Root Cause Analysis & Exception Management

• Perform root cause analysis on demand fluctuations, stock imbalances, and supply planning exceptions.
• Present findings and corrective action recommendations to cross-functional stakeholders.

S&OP Participation

• Participate in monthly/periodic S&OP cycles, presenting forecast insights, risks, and recommendations to support business decisions.
• Coordinate with zonal/regional teams to validate causal hypotheses behind demand deviations (e.g., MTD sales variance analysis).

4.0 Qualification Requirements

• Bachelor's degree in Management, Business, Supply Chain, or a related field.
• 2–5 years of experience in demand planning, forecasting, or supply chain analytics (FMCG industry preferred).
• Certification in Supply Chain Management preferred.
• Certification/coursework in Data Analytics or applied Gen AI preferred.

5.0 Core Competencies

• Forecast accuracy (target: sustained high accuracy, tracked via MAPE)
• Forecast bias reduction
• Inventory turnover and excess/obsolete stock reduction
• On-time reporting and dashboard reliability
• S&OP contribution quality (actionable insights, timely escalation)