Demand Planner | Supply Chain Analyst | Process Improvement

Turning demand variability into planning clarity.

MBA from IIM Bodh Gaya with hands-on work in fulfillment analysis, OTD tracking, vendor performance, and planning-oriented dashboards. I like building systems that help teams anticipate pressure instead of reacting late.

Demand volatility analysis Safety stock modelling Service level planning Tableau + PostgreSQL
0 transactions analysed
0 months of order history examined
0 global markets compared
0 volatile segment-market combinations
Demand volatility mapping Safety stock: 14 units 48 months analysed 95% service level 15 volatile combinations Vendor fill rate tracking Order cycle time analysis Demand trend visibility

Profile

Built for planning decisions, not dashboard decoration.

My work sits between analytics and operations. I look at demand signals, supplier behavior, cycle time, and order execution together so planning conversations are grounded in real constraints instead of isolated reports.

Portrait of Abhijeet Siddappa Kapse
Pune, India Demand Planner
Demand Volatility mapping

Measured monthly variability and coefficient of variation across segment-market combinations to understand planning risk.

Fulfillment OTD and flow gaps

Tracked order cycle time, vendor fill rate, and on-time delivery to surface where execution hurts planning reliability.

Inventory Buffer logic

Calculated safety stock and reorder point from order history to support service-level-based replenishment.

Why Me

What stands out in a planner-facing role.

Analytical foundation

Comfortable moving from SQL and Tableau down to Excel modelling and operational follow-through.

Execution awareness

Understands how vendor performance, workflow gaps, and order closure issues affect planning accuracy.

Immediate readiness

Pune-based, immediate joiner, with SAP S/4HANA MM learning already aligned to supply and materials workflows.

Experience

Program Coordinator, Supply Chain & Operations

Seveillar Clinical Supplies Services Pvt Ltd | Apr 2024 - Jul 2024 | Ranjangaon, Maharashtra

01

Delay pattern analysis

Analysed 3 order-to-dispatch workflows, quantified 15-20% delay rates by order type, and identified 5 root causes used to prioritise 3 process corrections.

02

Supplier performance review

Assessed on-time delivery performance for 10 vendors and highlighted 3 suppliers contributing disproportionately to fulfillment delays.

03

MIS and process standardisation

Built Excel MIS dashboards for OTD, cycle time, and vendor fill rate; also drafted 2 SOPs covering workflows handling 120+ transactions monthly.

Featured Project

Supply Chain Performance Dashboard

Examined 48 months of order data across 9,999 transactions in 5 markets to reveal demand volatility, peak demand windows, regional fulfillment gaps, and planning risk indicators.

01 Demand pattern scan Found a peak of 417 orders in December 2015 versus 69 orders in December 2018.
02 Inventory logic Calculated a 14-unit safety stock buffer at a 95% service level for the highest-revenue category.
03 Portfolio insight All 15 segment-market combinations were volatile with CV between 0.69 and 1.24.
Service Level 95% with 14-unit buffer
Planning story

Demand trend, service level, supply gap, and regional performance stitched into one decision view.

Operating Style

How I typically work through a planning problem.

01 Read the signal

Start with demand shape, service movement, and flow exceptions.

02 Quantify the risk

Use metrics like CV, cycle time, supplier contribution, and service target impact.

03 Translate to action

Convert findings into buffer logic, vendor review, SOP change, or visibility reporting.

Capabilities

Demand planning, analytics, and supply execution skills.

Planning & Supply Chain

Demand Planning, Demand Forecasting, Inventory Management, Materials Planning, Safety Stock Calculation, Vendor Management, Order Fulfillment Tracking

Analytics

Tableau, PostgreSQL, Power BI basics, Moving Average, MAPE Calculation, OTD Tracking, Demand Trend Analysis, Excel Dashboards

Systems & Methods

SAP S/4HANA MM, Procure-to-Pay, GR/IR Clearing, 3-Way Match, Root Cause Analysis, SOP Development, Lean Six Sigma

Coefficient of variation Reorder point Vendor fill rate Order cycle time Dynamic slicers PivotTables INDEX-MATCH Conditional formatting

Education & Certifications

MBA foundation with planning-focused analytics upskilling.

IIM Bodh Gaya logo
MBA Institution Indian Institute of Management Bodh Gaya

Core management training supporting supply chain analytics, business decision-making, and structured problem solving.

MBA

IIM Bodh Gaya

CGPA 6.3/10 | 2023-2025

B.E.

Jaywant College of Engineering, Sangli

Civil Engineering | 78.50% | Rank 2/50

Certifications

SAP MM, Lean Six Sigma, Google PM

Also completed McKinsey Forward Program.

Contact

Open to demand planning, supply chain analytics, and operations roles.