Saswat David

With 6.5 years in analytics, I specialize in E-Commerce, Supply Chain, Growth Strategy and Customer Experience. Currently leading Reverse & Last Mile Logistics at Walmart-owned Flipkart - India’s top e-comm site, I’m skilled in SQL, Python & R, and team management. A graduate of NIT Rourkela, my career spans roles in prominent Indian product companies and Fortune 500 clients across US and Europe. With an understanding of global markets, I aim to leverage analytics for market expansion, enhance operational efficiency, and improve customer experience.

Projects

Flipkart

I am a Senior Business Analyst at Flipkart, leading Reverse & Last Mile Logistics. In the past, I worked in Flipkart's Service (Jeeves) and Wholesale B2B (Flipkart Wholesale) divisions, where I streamlined operations and optimized processes. My role involves leveraging data to drive efficiency, enhance customer experience, and deliver impactful solutions.

Recognitions: Chandrayaan 2 Team Award 2023 — BBD Spot Award 2023 — Instant Karma Award 2022

Spare Part Forecasting

Inventory write-off 35% ↓ — $1 million impact
Created forecasting model for 2K+ appliance spare parts leveraging policy claim rates, part failure rates, SKU categorization by volume & demand variability pattern.

Customer Pain Analysis from Social Media

NPS 6 pts ↑
Conducted sentiment analysis and topic modeling on web-scraped social media data from 5 platforms to identify key customer issues and recurring pain areas.

Gibberish Address Detection

Last-mile cost $600K ↓
Classified addresses into high, medium, and low categories based on text attributes, blocking low quality entries daily during order placement and aiding last mile delivery

Delivery Attempt Conversion Improvement

Last-mile cost $9 million ↓
Optimized delivery efficiency by identifying low-intent customers and implementing strategy to halt attempts after a threshold and prioritizing high-success orders.

Reverse Network Improvement

Pickup failure losses $1 million ↓ — Speed 6% ↑ — RES 4 pts ↑
Used process mining to identify and address operational bottlenecks to reduce costs and improve customer experience.

PharmEasy

Worked in the Supply Chain team at PharmEasy – India’s largest E-Pharmaceutical firm – during a high-growth phase that saw its valuation surge 600% in 14 months. Gained extensive experience in scaling operations, process optimization, and data-driven decision-making in a fast-paced environment.

Recognitions: Rising Star Award 2021

Warehouse Design

Created blueprints for inbound, storage, and dispatch layouts, rack placement for 100,000 sqft warehouses and express DCs using models based on volume flows, sales trends, and demand forecasts.

Packing Box Recommendation

Packaging density 8% ↑ — Packaging cost $120K ↓
Developed algorithm to determine optimal box/bag size for customer orders based on contents, implemented real-time via API for 10 million annual orders

Delivery Charge Calculation

Margin 0.2% ↑ — $500K impact
Created an algorithm to determine delivery charges based on source - destination, courier rates, and business constraints, optimizing cost while preserving SLA and conversion.

Dynamic Racking

Picking TAT & walking distance 13% ↓
Engineered a methodology to optimize product placement within warehouses based on sales trends, expiration dates, and warehouse-specific constraints

Bin Inventory Replenishment & Audit

Expired inventory cost $350K ↓ — Picking TAT 7% ↓
Automated real-time inventory monitoring, bin replenishment task creation and audits, ensuring inventory sanity and physical-digital sync.

Tredence Consulting

My responsibilities included creating Business Solution Plan, handling client interactions and managing Business Analysts. I have worked on Machine Learning modeling and Optimization projects, extensively in the domains of Supply Chain, E-Commerce and Retail for major US based clients in a spectrum of varied projects.

Recognitions: Pursue Excellence Award 2020

Customer Segmentation

$50 million sales ↑
Segmented world’s largest e-comm customer base of 250 million+ based on transactional and demographics data, leveraging survey responses using a Random Forest model.

Weather Driven Order Cancellation Prediction

$5 million cost ↓
Built a machine learning model for a Swiss multinational to predict order cancellations using weather forecasts, streamlining labour planning and raw materials

Delivery Network Design

Split factor 28% ↓ — $15 million impact
Network design for America’s largest Arts & Crafts company, using demand clustering, network optimization, SKU categorization on COGS and MBA, inventory profiling.

Market Basket Analysis

Developed Normal, Synthetic and Sequential Affinity models on R to identify product combinations that have higher likelihood to be purchased together to promote cross-selling online and plan in-store rack product placements

Business Review Dashboards

For the purpose of reviewing monthly performance of the world’s largest retailer with monthly sales upwards of $25 billion, formulated back-end on Google Cloud Platform (GCP) and front-end on Metabase of a series of dashboards; which are used by store managers and executive management of the company alike to make decisions cumulatively impacting billions of dollars.

Competitor Analysis

Analysed the behavior of customers of retailer A in competitor retailer B and vice versa for 40 retailers by comparing KPIs like Spend per Customer, Orders per Customer and Retention at a weekly/monthly, cumulative and yearly aggregated level.

Holiday Sales Live Tracker

Built hourly updated dashboard showing latest trends across 21 dimensions (department, demographics, device type, shipment type etc) during Black Friday - Cyber Monday for quick strategy building.

Page updated

Google Sites

Report abuse