Chetan Solanki
Analytics Professional with 3 yrs of experience in Consulting and Product firms.
5 yrs 10 mos
Business Analyst
Swiggy
1 month
IET DAVV Indore
Summary
I love weaving stories around numbers, validating hypothesis and coming up with actionable insights. I am looking for a profile where I can see the impact of my analysis and would contribute in achieving company goals directly.
... See More
Skills
1 - 3 yrs
Hypothesis Testing
k-Means
PowerBI
Python
R
Snowflake
SQL
Career Journey (5 yrs 10 mos)
Business Analyst
Swiggy
May 2019 - Present
1 yr 11 mos
Projects (1)
Description: 
Working in Operations Analytics Team of this leading Food Delivery Startup in India
Skills
Python
Hypothesis Testing
R
k-Means
SQL
PowerBI
Snowflake
Company Location
Bengaluru, Karnātaka, India
B2B/B2C
Internal
Sector Learning
Consumer Services
PROJECTS (1)
Projects at Swiggy
May 2019 - Present
1 yr 11 mos
Problem/Context
Operational Problems
Solution/What you did
  • Recently worked on COVID critical projects, designed and ran experiments to decrease crowding of delivery boys at restaurants. Reduced wait time of Delivery boys at the restaurant by 2 mins/order and decreased crowding (more than 4 DEs at a time) by ~30%.
  • Identified opportunities to increase batching of 2 orders together, to save Cost per Delivery. Conducted different analyses to set parameters like distance between the customers, prep time difference between the orders etc which are used for batching 2 orders. Impact: Increase in batching coverage by 40%, saving Rs. 1.2 in delivery cost per order (Saved ~Rs. 4 Cr per month).
  • Helped in mitigating bad batches that affected CX. Analysed and reset default parameters of Batching Algorithm like avg. order value, item count, distance between the customers etc. to achieve better Compliance and NPS for batched orders. Impact: Decrease in NPS Delta between Batched and Non-Batched Order by 3 percentage points.
  • Ran AB tests on Order Tracking Screen variants in App and closed in on variant with better CX. Monitored metrics like Interactions Per Order, NPS etc. and tested them for statistical significance. - Automated queries and Created Power BI Dashboards used by Leadership to track critical metrics (Batching %, O2D time, SLA etc.) on daily basis.
Business Impact
Increased Batching % keeping CX guardrails in check
... See More
Decision Scientist
Mu Sigma Inc.
Jul 2017 - May 2019
1 yr 10 mos
Projects (1)
Description: 
Worked for the Search Advertising Business of one of the largest Tech Companies in the world
Company Location
Bengaluru, Karnātaka, India
PROJECTS (1)
Analytics at Mu Sigma for Microsoft
Jul 2017 - Apr 2019
1 yr 9 mos
Problem/Context
Data Ingestion along with AB Testing
Solution/What you did
  • Ran AB test on users based on ad exposure to test the effect of nonbrand queries on brand consideration and awareness. Performed Lift Analysis to analyse user visits and conversion on both advertiser and partner domains. Impact: Advertiser, for which the analysis was done, increased the Budget for non-brand queries. -
  • Integrated data from various sources, created a data repository on Azure Server, build a Tabular Data Model and a Power BI Report so that the end users can easily track KPIs at whatever levels they want and generate actionable insights. Impact: This data Cube had a daily Service Level Agreement and has the highest user interaction (~1000 users per day).
  • Created a Vertical Affiliation Methodology to map verticals at Advertiser level which was based on Revenue Weightage. Fully automated this process of vertical affiliation which had a bimonthly cadence.
  • Created an end to end data pipeline, using ETL tools like Microsoft SQL Server Integration Services (SSIS) which transformed an unstructured data into a desirable format saving a significant amount of man hours for the organization.
Business Impact
Created an end to end data pipeline to meeting data requirements for product managers at Microsoft
... See More
Analyst
TSS Electricals
Jun 2015 - Jul 2017
2 yrs 1 mo
Company Location
Indore, Madhya Pradesh, India
... See More
IET DAVV Indore
Bachelor of Engineering
Jul 2013 - May 2017
3 yrs 9 mos

Specialization
Degree: Bachelor of Engineering
Category: Computer Science
... See More
More
Nothing specified
Personality
Nothing specified