Experienced Analyst specializing in extensive analysis, pilot project testing, and operational process optimization. Played a crucial role in improving efficiency and reducing project timelines significantly.
SQL(MYSQL, Microsoft SQL Server)
Big Bag Optimization
• Analyzed data to optimize the assignment of larger bags to delivery partners for bulk order deliveries, enhancing operational efficiency.
• Investigated partner delivery times from the Pickup Location (PL) to Drop Locations (DLs), identifying bottlenecks and improving efficiency by 18%.
• Conducted a comprehensive analysis of partner challenges during orders, leading to a 13% reduction in order-related issues.
Order Acceptance and Returns RCA
• Conducted Root Cause Analysis (RCA) on order data to enhance understanding of customer behavior regarding order acceptance and returns.
• Assessed customer behavior to determine acceptance rates, revealing a 9% increase in orders accepted after implementing insights.
• Investigated and categorized reasons for order rejections, leading to a 12% reduction in rejected orders through targeted improvements.