Rishabh Aggarwal Email & Phone Number

India

Gurugram, Haryana, India

● Revolutionised the creation of Comprehensive Business Review presentations by integrating automated SQL query outputs seamlessly into final presentations for Senior Management using Python● Created a comprehensive order-level report for due diligence in preparation for private equity firm Advent International investment in Apollo Healthco● Demonstrated expertise and earned the role of Single Point of Contact (SPOC) within the organisation for the B2B corporate and partnership business vertical data, proficiently managing complex data queries to consistently deliver precise, actionable insights, and dashboard views for over 500 clients● Led and developed the data pipeline for the largest corporate client, State Bank of India (SBI). Analysed data to identify and rectify discrepancies in discount application● Developed over 15 automation scripts and dashboards across Growth & Marketing, Doctor Consultation, and Product verticals, enabling progress tracking and identifying business bottlenecks effectively● Developed the Phlebo Upsell Tracker to monitor daily upsells for over 400 Phlebotomists facilitating efficient payout management; Optimised Upsell Training strategies by analysing upsell trends city-wise, region-wise, and test-wise.● Conducted financial analysis of logistics costs for courier orders, comparing single shipments versus combined shipments from the same source and destination to reduce COD collection charges and lower logistics costs. Successfully countered the proposal due to negligible cost savings versus high product and technology costs involved.● Conducted detailed analysis of conversion rates, average order value (AOV), bucket types, and relevant metrics to propose discount laddering strategy for split orders, offering customers the option to choose.

Gurugram, Haryana, India

● Enhanced profit margins by developing data-driven cost analysis strategies for over 100 clients, utilizing custom SQL queries to calculate shipment costs accurately; enabled the business development team to negotiate pricing to improve the profit margin● Enhanced 2% volume via real-time excess capacity visibility dashboard for Meesho & Flipkart● Automated the manual process of extracting data & analyzing the cost & revenue per shipment model which reduced 300+ manual works hours for 100+ clients

Gurugram, Haryana, India

● Spearheaded a centralized embargo process, driving INR 30 million revenue growth; encompassed flowchart design, model development and automation, along with collaborative testing involving two team members and communication with ops and BD● Enhanced 15% service level of D2C brands through the strategic implementation of a prioritization strategy, shutting larger clients who dumped volume over smaller D2C brands● Enhanced manpower & vehicle planning for 3500+ centers by providing accurate forecasting numbers using SQL, R-shinny ● Saved 250+ man hours by developing 100+ SQL queries to deliver enriched aggregated data views

Gurugram, Haryana, India

● Created weekly report, worked with 2 colleagues to increase large truck utilization by 15% by identifying & merging idle routes using SQL & Excel; devised a trip cost calculation model using Python & aided fleet team in 10+Mn INR annual vendor savings● Generated network cost forecasting model for surface and airline haul cost for monthly PNL ● Increased last-mile productivity by 2.5% via early loads, center splitting & expanding centers; supported finance with coding SQL queries and analyzing hubs per shipment model for per-shipment infrastructure cost calculation for PNL