Resume | Linkedin | Tableau | Github

What makes me a Potential Candidate!

Introduction

I am an Analytics professional with 4+ years of working experience in this field. Having worked with top billion $ homegrown startups in India. I have had the opportunity of being part of the team responsible for shaping the product in its nascent stages by making analytical insights as the backbone of the product.

I have a diversified analytical experience which includes Supply Chain Management, Consumer, Operations and Marketing Analytics. I have driven teams for carrying out projects end-to-end, leading to some phenomenal changes in the product.

I’m currently working with Walmart’s Product Analytics for Sam’s Club. My role involves churning millions of rows of transactions to provide insights for product and merchandising team to help them provide analytical solutions.

Skills

Analytical Tools : R, SQL, SAS, Power BI, Python, Hive, Azure Databricks

Visualization : Tableau, Power BI

Modeling : Supervised Learning Methods (Linear Regression, Logistic Regression, Lasso, Decision trees, Random Forests, SVM); Unsupervised Learning Methods (kmeans, Hierarchical Clustering)

Optimization : FICO Xpress; Linear Models, Simplex Algorithm, Network Models, Goal Programming, Transportation Assignment, Integer Programming, Mixed Integer Programming

Certification : Data Scientist with R Track, Data Analyst with R Track, Sentimental Analysis in R Course

Specialization : SCM Analytics, Growth and Marketing Analytics, Operations Analytics

Recommendations

Anant Kanoria, Cluster Head at Ola Relationship: Directly reported to him

Anupreet was a key resource at for Ola to monitor, analyze and grow its Pune operations. His analysis was always well thought through and presented systematically. Working as a Business analyst, he not only managed his own KPIs judiciously but also supported other team members to understand the overall business and came up with innovative solutions to solve business problems succinctly. All the best Anupreet!

Sagar Pardesi, Program Manager at OlaRelationship: Worked together in multiple projects

Anupreet has shown extreme dedication towards his work and has proven excellence. He takes end to end ownership of tasks assigned and has built significant trust in the team. He has exceptional analytical skills and possesses expertise across horizontal. I have learned a lot from Anupreet while working with him on different projects at Ola.

Bharti Prasad, Associate Director - Analytics at ShopcluesRelationship: Directly reported to her

Anupreet is one of the smartest guys, I have worked with. He is extremely good in taking ownership and completing the projects with perfection. He is very comfortable with numbers and has excellent data interpretation skills. Many a times, in the firm, his analysis was the basis of strategic and policy changes which brought performance improvement in system. Undoubtedly, he will be an indispensable asset for any team and organization.

Pilla Vamsi Krishna, Manager at CleanMax SolarRelationship: Grewup together from primary to high school

Humility. period! That’s the one complete sentence which describes Anupreet. The only mentor I ever had in my life is Anupreet. He is extremely talented and determined to achieve his goal and he does all this without ever losing his cool. No matter what life throws at him, he takes it with a smile and turns it to his advantage. The most distinguishing quality of his is “humility”. In my experience, I have seen many people with his caliber, but none so down to the earth and that’s the reason I feel that he has the potential to become a great leader. I wish him All The Best for all his future endeavors.

Academics and Learnings

Education

University of Cincinnati, Carl H. Lindner College of Business, Cincinnati, OH August 2019

Master of Science in Business Analytics GPA: 3.86/4

Major courses: Probability Models, Statistical Modeling, Data Mining, Optimization Models, Data Viz., Data Wrangling in R, Simulation Modeling.

Indian Institute of Technology (IIT), Indore, India May 2015

Bachelor of Technology, Electrical Engineering CGPA: 7.82/10

Research Internship and Publications

During the seniors years of Bachelors, I had the opportunity to be supervised under the guidance of Dr.Santosh K Vishvakarma, Associate Professor at IIT Indore. During my term as an Undergraduate Research Assistant, I had gained in-depth knowledge about the SRAM and FLASH Memory technologies while at the same learned and simulated models using Cadence and Silvaco. The challenges were not only limited to getting expert in the subject matter but also pushed me into critical thinking and lastly developed patience. I could convert my project research work into two international level papers at IEEE conference and presented them.

Certifications

1. Data Scientist with R Track

An extensive course track offered by Datacamp, comprising of 23 comprehensive courses on R, right from covering the basic R programming to having to implement the Machine Learning techniques on datasets as a part of the course track.

2. Data Analyst with R Track

A course track offered by Datacamp to build upon the arsenal of skills required to understanding data and providing hands on experience to practice data wrangling. Important aspects of tidyverse and ggplot2 were covered in a series of 10 courses covered as part of the track.

3. Sentimental Analysis in R Course

As a part of the skill tracks at Datacamp, the series of 4 courses enables the user to master the package stringr and implement the learning to carrying out Sentimental Analysis.

4. Operations Analytics Course by University of Pennsylvania

Work Experience / Projects

Professional Work Experience

Walmart May 2020 Present

Quantitative Analyst, Strategy and Portfolio Analytics

  • Collaborated with product owners and engineering team to built analytical solutions and measure impact

  • Standardized repeat purchase rate metric using cohort-based approach and implemented it across company

  • Performed sentiment analysis on reviews data to highlight issues related to product and customer’s concerns

Fifth Third Bank May 2019 May 2020

Quantitative Analyst, Strategy and Portfolio Analytics

  • Gained in-depth knowledge about consumer lending and payments related products in the banking sector

  • Prepared forecasting model for consumer payment products to support operational planning and strategy

  • Identified potential accounts, using decision trees for Hardship-Enrollment program to improve collections

  • Estimated a potential savings of ~ 200k $ from delinquent reward card holding accounts to improve profitability

Ola (cab-aggregator platform) Oct 2017 Jul 2018

Business Analyst, Growth-Marketing Analytics

  • Headed team of 5 to draft marketing plans to grow exponentially and improving customer retention rate by 5%

  • Scheduled jobs for reporting of metrics critical to weekly planning of marketing campaigns and monitored it

  • Systemized and shaped existing supply by understanding customer ride patterns over time to meet the growing demand and doubling the revenue over 6 months

  • Proposed changes to CRM cycle particularly for new customers to onboard them on platform with reduced CAC

  • Analyzed historical data to identify seasonal trends in customer demand to effectively curb marketing budget by 20% while keeping supply financials at sustainable level

  • Researched, developed and led to launch Premier category to meet demands of valuable customers in city

  • Forecasted operational and financial metrics week-on-week with 95% confidence to take necessary measures

Snapdeal (e-commerce platform) Jul 2015 Jul 2017
Business Analyst, Supply Chain Management (SCM) Analytics

  • Leveraged data science techniques to provide business insights for sales and operational planning of SCM

  • Automation of reports and dashboards to provide end-to-end visibility of metrics showcasing SCM health

  • Re-Modeled Network Optimization for minimizing shipment costs by 5% while keeping crucial metrics checked

  • Devised a plan to reduce Return to Origin (RTO) rate by 10 % by performing root cause analysis with major emphasis on customer profiling and courier fraud identification Prepared monthly

  • Prepared PnL for each category to identify margin and sales effectiveness to prioritize inventory at warehouse

Always seeking Challenges!

Continuing my journey in the field of Analytics, I’m excited upon applying the learning from my Master’s at Business Analytics program into solving real-life problems with companies. I seek roles with challenging tasks and which allows me to continue to learn and explore different Analytical techniques and master the tools.

My field of Expertise includes:

Strategy and Portfolio Analytics

Supply Chain Management Analytics

Growth and Marketing Analytics

Operations Analytics

Contact details:

Primary Email ID: gupta2a8@mail.uc.edu

Secondary Email ID: guptaanupreet@gmail.com

Mobile No.: +1(513)-405-5629

Resume | Linkedin | Tableau | Github

Thankyou for the consideration. I appreciate your time devoted to my candidature. I look forward to hearing from you. Any feedback are most welcome! I would certainly want to know on how can I continue to improve my profile and build a career in the field of Analytics.

P.S: This webpage is constantly under development and is built using RMarkdown. Please download the Resume file as a PDF