Samiksha G

Senior Business Analyst

Flipkart • Vollzeit

Jun 2024 - Present • 2 yrs 4 mos

Inventory Tracking, Management & Optimization ● Achieved inventory shortages reduction of 5 percentage points and saved 4+ hours/week of manual work, by building a SQL-based attribution framework on large datasets to conduct root-cause analysis and resolution of inventory stockouts. ● Reduced untimely purchase orders by 20%, by designing a KPI dashboard for a new metric, Days on Hand (DoH), to flag over- and under-stocking. Last-Mile Supply Chain RCA Management ● Stabilized delivery breach rates at their 5% baseline, by building and automating a Delivery Hub offender-tracking framework using Excel, LLM and Flipkart's internal tools, which helped in detecting operational anomalies and supporting proactive breach issue resolution. ● Designed a weighted scorecard framework scoring Delivery Hubs across 8 supply chain metrics spanning 4 categories (reliability, losses, customer experience, cost), by presenting findings to supply leadership and directing interventions to the bottom performers. Biker Model Pilot (Partial Shift from Van to Biker Delivery) ● Reduced delivery costs by a projected INR 10M, by identifying locations for biker-model rollout using feature engineering and geospatial analysis. ● Refined these locations by filtering for predicted supply chain productivity (orders/day/rider), calculated by planning optimal routes using the Clarke-Wright Savings, 2-Opt algorithms, and tracking key logistics metrics. Micro-Fulfillment Center (MFC) Pilot for D0 (Same-Day) Delivery ● Recommended MFC sites across 36 cities to enable D0 delivery, by applying K-means clustering and linear programming on demand data. ● Projected a 25% avg improvement in D0 delivery orders over existing infra, based on MFC proximity and order density near delivery locations.

Product Analyst

HealthifyMe • Vollzeit

Aug 2022 - May 2024 • 1 yr 9 mos

Image Food Detection Feature (SNAP) ● Enhanced food-detection accuracy in images from 20% to 60% by collaborating with ML and Product teams to identify and resolve system loopholes and fallbacks using descriptive and inferential analytics. ● Lifted image upload success rate by 20%, by auditing data inconsistencies and optimizing the image-processing funnel, including bug resolution. Premium Services & Coach Connect ● Drove a 10% increase in user engagement, by building KPI tracking dashboard on Metabase for an LLM-personalized coach-messaging feature. ● Supported a phased premium UI rollout to 25% of users, balancing cost & engagement metrics using A/B testing to assess rollout decisions. ● Reduced coach workload by 10%, maintaining consistent user retention through weekly, dashboard-driven recommendation reports. South East Asia & NRI Business ● Improved High-Value Customer-to-Registration ratio by 50% and cut Cost Per Lead (CPL) by 30%, by resolving legacy configuration issues. ● Streamlined INR 3 million/month in revenue-claim processing, by building MS Excel dashboards for an accurate incentive structure, ensuring data accuracy and integrity.