📊 Operations Efficiency & Process Bottleneck Analysis
Developed by Rahul Kumar Malik | Interactive Portfolio Demonstration
Control Panel:⚠️ Baseline State: Resources evenly distributed. High delays.
Overall SLA Adherence
82%
Avg Order-to-Ship Lag
3.6 Days
Critical Stockouts
1,240
Top Process Bottlenecks: Order-to-Ship Lag by Category
🧠 Project Methodology
Database Modeling: 80,000+ mock records simulated across a 6-table normalized schema in MySQL.
Bottleneck Identification: SQL Window functions used to measure order-to-ship lag and warehouse dwell time.
Capacity Planning: Extrapolated historical throughput in Excel to mathematically justify a 15% labor shift to peak-demand SKUs, resolving the delays shown above.