HDIP

An in-house IT system for India's iconic pressure cooker brand.

• → SQL ETL pipeline → star-schema SQLite warehouse (192 MB) with 10 indexes, 5 analytical views
• → Three ML modules: SARIMA forecasting, Isolation Forest anomaly detection, K-Means RFM segmentation
• → 7-page Streamlit BI dashboard with pan-India GIS choropleth and warranty defect analysis
• → All orchestrated by a single run_pipeline.py command