ANUBHAV GUPTA
Data Scientist
Gurgaon
Summary
Over 6 years of experience in providing analytical solutions to fortune 500 companies spanning across diverse business verticals such as Credit Card, Retail, and Online Search Advertising.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
Work History
Senior Consultant
EXL Service
04.2021 - Current
- Created an automated Eligibility Tracker, simplifying the process of collating over 40 separate reports in a single Excel dashboard and reducing the refresh process by five times
- Developed a framework to attribute the impact of volume suppression across different channels for 12 corporate cards, leading to a precise estimation of the targetable eligible customers from 360 thousand to 10 thousand for the US Market
- Collaborated with the marketing team to design over 25 customer triggers by creating user-defined rules, observing a Lift of 18% compared with the campaigns launched last year
- Designed a merchant recommendation framework for 5 International Markets (Japan, Mexico, Hong Kong, Singapore, and India) by building a model around the spending correlation between merchant and customer industries
- Proposed a new campaign measuring methodology to the Director at American Express, measuring the impact of more than 200 campaigns across more than 10 countries and reducing the time from 3 weeks to 2 days
- Volunteered for the hiring committee to screen candidates for technical rounds for on-campus placements and lateral hiring for the organisation and mentored more than 10 candidates, taking responsibility for their overall development.
Apprentice Leader
Mu-Sigma
10.2017 - 04.2021
- Led a 12-member team driving regular business review calls with clients and becoming the primary POC of the engagement, leading to an increase in the quality of deliverables and eventually resulting in an increase in billing by 30%
- Created a user-friendly tool for Home Depot to carry out a bi-annual planning process with optimised retail targets for store managers across 1,980 stores and 250 product categories, reducing a 3-month planning window to a 2-week process
- Developed a forecasting tool using ARIMA and Prophet modelling for Bing Ads to predict revenue and volume on multiple publishers, increasing quarterly projections’ accuracy by 20%
- Quantified the impact of seasonality on variance to forecast (VTF) by creating a model measuring the impact of a defined query pool for more than 10 primary seasonal events in Germany, France, Canada, and the UK
- Collaborated with the Product Intelligence manager at Microsoft to define a new business metric, advertiser mover, capturing user behaviour, and built an intuitive Power BI dashboard enabling better market diagnosis and decision-making
- Led several business development projects by pitching strategic projects to key clients and eventually bringing the firm an overall engagement business of nearly USD 1 million.
Education
Bachelor of Engineering in Computer Science - undefined
04.2013 - 05.2017
Relevant Coursework: Data Structures, Analysis of Data Algorithms, Object-Oriented Programming, Artificial Intelligence
Skills
R
Python
Power BI
MS Excel
Tableau
Forecasting
Clustering
Regression
Story Boarding
MS PowerPoint
SAS
SQL
Certification
Introduction to Generative AI (Coursera, 2023)
Extracurricular Activities
- Spearheaded the organisation of high-profile guests, managing logistics for international singing artist Falak Shabir and Deputy Chief Minister of Panjab, Sukhbir Badal, at the 2016 College Cultural Annual with an 8,000+ footfall.
- Contested and won in the Student Council elections in 2015, securing a record-breaking 5,000+ votes and leading initiatives that contributed to the rollback of fee hikes for students with poor economic backgrounds.
- Organized a successful blood donation camp in 2014, promoting awareness about its critical importance among 2,000+ freshers by collaborating with a Government Hospital.
- Excelled as the goalkeeper for the CSE Branch Football Team from 2013 to 2016, serving for three consecutive years and leading to the team to championship as captain in the final year.
- Managed hostel activities as the Hostel Secretary in the final year of college, handling a budget of USD 1 thousand for inter-hostel sporting activities, coordinating the Freshers' Party, and organising the Inter-Hostel Annual Champions event.
- Participated in the university's annual chess competition, securing a top 10 position among 100+ participants.
Timeline
Senior Consultant - EXL Service
04.2021 - Current
Apprentice Leader - Mu-Sigma
10.2017 - 04.2021
UIET, Panjab University - Bachelor of Engineering in Computer Science,
04.2013 - 05.2017