• Designed and implemented real-time hourly performance reports across India, focusing on critical KPIs such as-Customers order on time (COT)Stores order on time (SOT)Last Mile order on time (LOT)SLAInstant Handover (IH)and AOV.• Conducted comprehensive root cause analysis to address operational disruptions, mitigating order losses during workforce strikes.• Collaborated with cross-functional teams to streamline daily operations in a dynamic and fast-paced Quick… Show more • Designed and implemented real-time hourly performance reports across India, focusing on critical KPIs such as-Customers order on time (COT)Stores order on time (SOT)Last Mile order on time (LOT)SLAInstant Handover (IH)and AOV.• Conducted comprehensive root cause analysis to address operational disruptions, mitigating order losses during workforce strikes.• Collaborated with cross-functional teams to streamline daily operations in a dynamic and fast-paced Quick Commerce environment.• Enhanced inventory accuracy by analyzing short pick reports, leading to targeted supply chain adjustments and improved stock management.• Maintained and updated an hourly dashboard tracking KPIs such as COT%, SOT%, LOT%, Deep Pain%, 90th Percentile, and Order Metrics, facilitating real-time performance monitoring and data-driven decision-making. Show less

Key Highlights:✅ Project Understanding✅ Data Cleaning & Modelling✅ Data Visualization & Storytelling

• Visualized customer service metrics using Excel, including average FRT and ART, resulting in a 15% reduction in response time through process optimization. • Developed comprehensive Excel dashboards to track key performance indicators such as quality score and productivity, ensuring real-time performance monitoring and improvement.• Tracked and analyzed client escalations with Excel, identifying patterns and root causes, leading to a 20% decrease in escalations through targeted… Show more • Visualized customer service metrics using Excel, including average FRT and ART, resulting in a 15% reduction in response time through process optimization. • Developed comprehensive Excel dashboards to track key performance indicators such as quality score and productivity, ensuring real-time performance monitoring and improvement.• Tracked and analyzed client escalations with Excel, identifying patterns and root causes, leading to a 20% decrease in escalations through targeted improvements.• Achieved a 10% increase in average productivity by implementing data-driven strategies based on thorough analysis of support metrics in Excel and SQL. Show less