Responsibilities include (thus far)-

• Helping Network loss charter for India Transport – Analytics operations team improve customer experience and minimze losses borne by the company.
• Handling Customer and seller Concessions , Secured delivery and reject compliance , fulfillment centre’s Xray, retina Machine Compliance analysis and reporting.
• Help create peak deck as single source of truth for network losses for reporting to senior leadership on amazon prime day sales.
• Collaborated with Operations team and Program Managers to help create VPM logics to minimize losses in the network (In transit / in facility losses) using advanced analytics .
• Helped Program manager with RCA’s , deep dives and provided relevant data to help drive ideation of data driven frameworks/ products.
• Collaborated and guided other analyst help create similar frameworks and reports for eccf markets like Brazil , Australia .

Responsibilities include -

• Helping the Growth and product analytics charter of Instamart (swiggy’s quick ecom vertical).
• Working in collaboration with Product managers & Business managers to leverage swiggy’s food platform to help Scale Instamart to multiple cities (from 7 to 21 cities in India ) .
  

  Projects -

1. Product : Auto Suggestion on Global Search (search optimization) .

Autosuggestions from Instamart on Swiggy global search when a user types his/her query .Primary Objective was to increase the visibility of e-store / business vertical to users of main platform.

• Performed Impact Sizing pre- launch of the product’s new feature to understand the viability and business value of the feature.
• Helped product manager with top business serving keywords for the Search suggestions.
• Dealt with complex unstructured text data and helped the product Managers & Data Scientist understand its complexities.
• Created Product ARD and Collaborated with software engineers to help ensure proper capture and flow of data .
• Helped set up A/B test for the new feature roll out and helped the central SEARCH team with post test Analysis and tracking in a form of Power BI Dashboard .
2. Product : Swiggy One subscription for Instamart .

Its marked the inclusion of Instamart on Swiggy’s premium subscription service . Primary Objective being increasing Instamart’s adoption across exisitng food customers .

• Collaborated with team of Product Managers to Brain storm the list of KPI’s and automated the KPI Tracking for product mgmt. in form on Power BI dashboard, by relying on expert SQL , Power BI and DAX skills .
• Single handedly served as the POC of the project from Instamart’s analytics
• Helped set up A/B test for a new in app banner for marketing and performed post test analysis .
• Helped central Swiggy One Team with multiple reports and adhoc data and queries and simplified data querying process by creating a single data base to serve as source of truth .
• Helped business growth managers with creation of weekly presentation to senior leadership and central ONE team on performance tracking .
3. Product : Gamification on Instamart

It’s a discounting program on Instamart post order , to help increase customer’s transaction frequency / Repeat rate .

• Collaborated with team of Product Managers to Brain storm the list of KPI’s.
• Collaborated with team of software engineers to create a product ARD and ensured the correct flow and capturing of the Data .
• Automated the KPI Tracking for product mgmt. in form on Power BI dashboard , by relying on expert SQL , Power BI and DAX skills .
• Performed a pre/post analysis across multiple segments of customers after 45 days of launch of the product .
4. Marketing based : Billboards , in app marketing analysis .

Performed True/actual impact of billboard marketing analysis by segregating it from other feature changes and inapp marketing initiatives .

5. Other Growth driven Projects :
• Profiling of visitors : Analysing visitors behavior and time to convert on instamart estore platform wrt acquisiton sources and customer segments.
• In App marketing :Leveraging Swiggy main page to target customers who are done ordering food , to show ads of Instamart.The ad was shown after x min of orderding on food , and shown till y amount of time .Task was to predict x,y time using data driven methodogies .
• Orders loss prediction : Predicting the loss in order faced due to store closing early ,closure due to tech issues and items going OOS.
• New Store order prediction : Predicting first 7 days orders from new store launch leveraging customer data , and using them as goals to drive our growth initiatives.
• Payment Partner Alliance : Estimating the impact brought upon collaboration with multiple payment partner on platform like slice,paytm . Used pre/post analysis methodology on look –a- likes.

Responsibilities include -

• Performed descriptive analysis and provide self-service analytical solutions to strategy global heads of pharma section of a Fortune 10 animal health company.
• Implemented Initial EDA deck and Visualization Dashboard to understand data behavior.
• Performed Advanced analytics,& querying to Derive insights from data.
• Served various on-site adhoc analytical requests , hypothesis testing .
• Developed fully automated reports from concept to product in form of Dashboard (creation, maintenance and story telling with Tableau.)
• Identified KPI for waterfall analysis for bulk purchasing potential of customers.
• Segregated Customers into Loyal ,Switch & new category & Performed Repeat purchase analysis to identify potential loyal customers to improve sales..
• Developed requirements and create requirements documents and process flows.
• Automated tasks using R sripts .

Data Science Initiative :(Clustering & analysis for target marketing)

• Collaborated with different domain experts to ideate & derive initial KPI's .
• Aggregated Transactional level data to perform in detailed exploratory analysis.
• Derived insights & Performed dimensionality reduction using factor analysis.
• Used K-means ++ for Clustering & identified 4 clusters in data.
• Visualized Clusters using PCA & performed cluster analysis to generate insights.

Responsibilities include -

• Created a Blogging Site from scratch where users can follow people, see posts from them ,
• write ,edit, delete their own posts.
• Worked on Bug tracking web app , to assign ,track a Bug Handling job to a particular Member.
• Used the development learning and knowledge on creating a portfolio site for self .