Srishti Siriya

Data Analyst

Delphi Analytics

Jul 2025 - Present

Designed and deployed production BI infrastructure — Apache Superset dashboards (Sales, Marketing, Geo, PG, Coupon), a multi-org Grafana application with per-team access control, and Power BI dashboards with DAX measures and version-controlled PBIX development (unpacked folder pattern) bridging PostgreSQL and ClickHouse via Power BI Gateway — enabling real-time, unified visibility across E-Com, Retail, EBO, and GT channels for executive stakeholders. Reduced manual MIS reporting effort by 80+ hours/month by building automated dashboards, scheduled email/PDF report generation, and alerting systems, while optimizing data models and queries to improve reporting accuracy, dashboard performance, and analytical responsiveness for cross-functional teams. Delivered end-to-end production analytics for an FMCG brand, tracking revenue across thousands of transactions and orders and generating scheduled daily sales, inventory ageing, weekly slow-moving, stockout prediction, ABC classification, cohort retention, and vendor scorecard reports — driving data-informed merchandising decisions. Built an RFM customer segmentation model using scikit-learn KMeans clustering that identified the top 20% of customers generating 70–80% of revenue, enabling targeted retention and upsell strategies. Built a demand forecasting suite with 7-model comparison, reorder point calculation, and safety stock modeling, delivering actionable inventory planning recommendations to operations teams through close collaboration with cross-functional stakeholders.