Data Analyst at Flipkart Minutes (2025-04 – Present)
- Automated end-to-end supply chain reporting using Python scripting, reducing manual effort by 65–70% and improving data accuracy.
- Built real-time Power BI dashboards tracking IWIT flow, Funnel Analysis, PO Fill Rate (QFR & LFR), RCA, and inventory prioritization.
- Improved in-stock efficiency from 90% to 95% by diagnosing over-creation, capacity constraints, and scheduling delays.
- Developed automated Daily Priority Scheduling Matrix using DOH norms and ATP logic, enhancing replenishment planning and warehouse execution.
- Collaborated with cross-functional stakeholders (planning, procurement, warehouse, dark store) during requirement gathering to align automation tools with business needs.
- Delivered insights aligned with top vertical KPIs, contributing to a 12–18% improvement in PO Fill Rate and enhanced supply chain responsiveness.
- Xtra Saver Plan - PAN India Launch: Tracked in-stock levels and conducted structured RCA for the PAN India Xtra Saver Plan rollout, driving in-stock improvement from 65% to 85%+ through targeted corrective actions.
- Flipkart Grocery-Minutes Merger: Supported integration of Flipkart Grocery with Flipkart Minutes across top cities by tracking warehouse in-stock movement and developing an inventory distribution matrix to ensure smooth operational merging.
- Master Optimization - Top 5000 SKU Matrix: Built a Core 2500 + Next 2500 product tracking matrix to monitor and improve in-stock levels, successfully moving Top 5000 SKU in-stock from 71% to 85%.
- Multi-Polygon Expansion: Initiated in-stock tracking and generated an improvement matrix for the multi-polygon go-live rollout under Flipkart Minutes, enabling data-driven scale-up from launch.
Data Analyst at Flipkart (2023-12 – 2025-04)
- Developed and managed Purchasing Order Reports to identify PO gaps and streamline scheduling processes.
- Monitored Days on Hand (DOH) metrics using SQL and Google Sheets, improving inventory accuracy from 75% to 90%.
- Produced Delivery Speed Reports for national and metro distributions using Excel and Power BI, improving delivery times by 12%.
- Assessed Zonal PO Gaps using daily run rates and SQL-driven analysis in Looker Studio, achieving a 12% decrease in stock-outs.
- Compiled Non-Serviceability Reports identifying regional service gaps, enhancing overall service coverage using SQL and Power BI.
Sales Coordinator – National MIS at Artsana India (Chicco) (2023-08 – 2023-12)
- Developed a management-level Sales Dashboard tracking Daily, Weekly, and Monthly Sales using Excel and Power BI.
- Analysed sales data to uncover trends and improvement opportunities, resulting in a 16% impact on sales strategies.
- Generated regular sales performance reports improving decision-making and contributing to a 12% improvement in overall performance.
- Managed Sales Force Administration (SFA): user creation, hierarchy setup, customer master, retailer master, and route master updates.
- Oversaw Distribution Management (DMS), reducing discrepancies by 12% and improving order fulfilment timelines.
Senior Associate – Data Analyst at Netscribes Data & Insights Pvt Ltd (2019-05 – 2023-05)
Note: May 2016 – May 2019: Working Part-Time
- Analysed annual supplier and contractor work hours, driving a 15% improvement in resource utilization and optimized supplier allocation.
- Generated workplace injury reports categorized by supplier profiles, contributing to a 20% reduction in workplace incidents.
- Created safety screening reports for contractor compliance, resulting in a 25% improvement in contractor reliability.
- Compiled supplier/contractor performance profiles, achieving a 30% improvement in supplier selection processes.
- Led FTE projects for US and Europe clients (Avetta Global / PICS) – managed safety screening, supplier chain audits, and annual portal updates for APAC, EMEA, US, and Canada regions.
