Mukul Gupta Email & Phone Number

California, United States

San Jose, Ca, Us

San Jose, Ca, Us

● Built a framework to identify markets along with actions required to improve the engagement of customers● Identified early indicators of dormancy of customers to recommend actions for customer re-engagement

Round Rock, Texas, Us

● Part of the core team to develop a new internal product used for global sales hiring. Was responsible for conducting underlying resume analysis and behavioral traits analysis using Random forest in R, suggesting design features for beta version rollout, leading the analytics features of the product● Developed an excel based product used for reorganization of the company across Europe, Asia and North America● Identified key drivers of time to productivity of new sales reps using logistic regression and random forest in R. Collaborated with regional & global sales operation teams to implement the structural changes in onboarding process & portfolio assignment. Created recurring report to flag new reps at risk of slow ramp● Collaborated with the Talent Acquisition and Sales leadership team on various projects to develop talent strategies for improving productivity and retention of the salesforce

Minneapolis, Mn, Us

• Built fractional logit model in R to identify drivers of market share for an American motorcycle brand; Recommended an optimal promotion mix using linear programming and designed a multivariate test to establish causality• Leveraged k-means clustering in R to identify customer segments having higher losses; Identified opportunities to reduce operating expense and fraudulent claims leading to an improvement of 3% in loss ratio- Winner PwC live case • Built forecasting models using linear regression with ARIMA in R to predict daily ridership for Nickelodeon Universe; Reduced the error by 7% and improved staff allocation by 33%- Runner-up Mall of America live case • Developed music recommender system using collaborative filtering (Spark ML, Pyspark) on ‘1 million songs’ dataset • Evaluated performance of Scrapy and Beautiful Soup library of Python by scraping job postings on Indeed.com

Boston, Ma, Us

• Developed a logistic regression model in R to identify the drivers of employee attrition; Recommended an increase in the use of bench strength to decrease employee workload and improve retention• Analyzed HR data using Hive and R to identify popular and retentive career paths. Optimized timeline for internal job role mobility to improve employee retention and engagement • Scraped 3000+ Glassdoor reviews about Fidelity leveraging Python (beautiful soup library); Used sentiment analysis & topic modeling(LDA) to identify pain points for employees at various office sites • Led the efforts to optimize travel policy for employees by working closely with finance team and analyzing travel expense data in R; Identified opportunity to decrease expense by 6% using anomaly detection and benford’s law

Northbrook, Il, Us

Domain: e-Commerce Retail• Led the digital analytics engagement (team of 3 analysts) with an e-commerce business of world’s largest retailer; Analyzed user behavior on the website to enable digital marketing managers to optimize conversion funnel • Mentored 7 business analysts across multiple projects; Created and implemented knowledge management process for onboarding of new team members• Used time series modeling(ARIMAX) in R to forecast website traffic for product categories across marketing channels, helping marketing managers to plan for the holiday season • Developed linear regression model in R to estimate the effectiveness of offline advertisements on brand awareness of e-commerce business; Recommended pilot study in specific locations for billboard advertisements• Conceptualized and designed a dashboard to analyze customer’s offline and online activity using Postgre SQL, helping marketing managers to identify opportunities to increase omnichannel engagement

Northbrook, Il, Us

Domain: e-commerce Retail• Collaborated with paid search and inventory team to reduce time gap in Adwords and inventory feeds, leading to reduced paid search traffic on out of stock products; Used Site Catalyst for analysis - $1 M opportunity loss identified• Developed an automated process to build marketing campaign performance reports using Postgre SQL and Site Catalyst • Created marketing dashboard using Tableau enabling category and marketing managers to monitor website KPIs; Automated the process using Python

Master'S Degree, Business Analytics

Bachelor Of Engineering (Be), Civil Engineering