Data Analytics Work
• SQL and python scripts to extract control and treatment customers and executed about 50+ marketing campaigns to perform A/B testing. (TheMathCompany- Automated Retail Client - AWS Redshift)
• 20+ business intelligence reports for financial transactional data through SQL scripts (PwC - Financial Services Client)
• Oracle visual builder studio dashboard to track and trace product shipment and deliveries between farmers, distribution centers and restaurants for inventory management. (PwC- Popular Quick Service Restaurant Client)
• 10+ functional specification documents by gathering business requirements and architecting the supplier management cloud system. (PwC - Dairy Products Manufacturing Client)
• Analyzed revenue and growth of Carlson’s custom courses in Salesforce, Python, Tableau and built financial reports, executive decks, developed LinkedIn lead targeting strategy for the Assistant Dean of Carlson School of Management
(UMN, Carlson)
About me
I'm Abhay Subramanian, a Master's in Business Analytics candidate at Carlson School of Management, University of Minnesota.
My passion for analytics started 3 years back when I was doing my undergrad in computer science engineering. I've always known AI revolution was imminent and since then I wanted to be at the frontline of this disruptive innovation using data science.
Actions speak louder than words so here's how I've delivered business value using data science. I've worked on -
• Multiple Linear Regression to predict donation amount from specific media channels to better prioritize allocation of resources
• GMM Clustering and Random Forest Regression to identify resource effectiveness in increasing test scores for 450K+ candidates and tests taken over 2 years.
• K-means Clustering to identify farmers with poor fulifllment rates and developed a new metric called 'missed opportunity cost' to improve demand planning.
• Contextual Multi-Arm Bandit model to predict customer worth based on behaviour and reactions to promotions and reduced customer churn.
• Ensembling model with LightGBM to forecast product sales for the next 28 days.
• SARIMAX time series model to forecast gross gaming revenue and tableau built dashboard to tune factors and improve revenue.
Education
Master of Science in Business Analytics
Bachelor of Engineering, Computer Science
Work Experience
Data Science Student Consultant
Graduate Assistant
Business Analyst - Associate
Data Analyst
Intern
“Without data you're just an another person with an opinion."
- Overheard at a Washington, D.C. bar
Carlson Live Case
Optimized Marketing Costs
Reduced Candidate Performance Disparity
Optimized Resource Allocation
MSBA Courses Taken
Certifications
Full Stack Analytics Professional
Issued June 2022
FAER McAfee Scholar Award, 2019 - 2020
Issued June 2021
Oracle Procurement Cloud 2021 Certified Implementation Specialist
Issued February 2021
The Web Developer Bootcamp
Issued December 2020
Google Analytics for Beginners
Issued May 2020
The Deep Learning Masterclass: Classify Images with Keras
Issued September 2019
An Entire MBA in 1 Course
Issued April 2021