Vipin Dangi 959-***-**** adc819@r.postjobfree.com

New York City Area, 07302 www.linkedin.com/in/vipin-dangi/ EDUCATION

Master of Science - Business Analytics and Project Management Jan 2019 - May 2020 University of Connecticut School of Business, Hartford, CT GPA 3.87/4.00 Bachelor of Technology – Engineering Jul 2011 - May 2015 Malaviya National Institute of Technology, Jaipur, India GPA 3.91/4.00 TECHNICAL SKILLS

• Languages: Python (NumPy, Pandas, scikit-learn, Matplotlib, tensorflow, keras), R (Shiny, ggplot2, dplyr)

• Tools: Jupyter Notebook, Tableau, MS Excel (Advanced), SAS JMP Pro, SAS Enterprise Miner, MS Project, VBA, MS PowerPoint, Javeline Territory Designer (JTD), Power BI, Javeline Incentive Manager, Qualtrics, MS Visio, AWS, Hadoop (Sqoop, Pig)

• Statistical Analysis & Modeling: Linear and Logistic Regression, Decision and Boosted Trees, Random Forests, Naïve Bayes, PCA, SVM, Classification, K-Means, and Hierarchical Clustering, Data Mining, Time Series Forecasting, Hypothesis Testing, Text Mining, Market Basket Analysis, A/B Testing, Neural Networks, Deviation Analysis.

• Data Management Tools: MySQL, HDFS

WORK EXPERIENCE

LIMRA Graduate Data Science Consultant Aug 2019 – Dec 2019

• Customer analytics exercise for Insurance market Policy Attrition Prediction: Identified customer churn using Light Gradient Boost model and achieved a F-1 score of 79%. Built and analyzed customer profiles on 9M rows of life insurance records, and identified influential factors driving the churn. Also, implemented SMOTE to counter class-imbalance and provided recommendations with interactive visualizations to prevent churn. Profiled customers were segmented to enable personalized and focused targeting strategies (R, Python, Tableau, PowerPoint) ZS Associates Data Analyst Jul 2015 – Jun 2018

• Opportunity assessment exercise for products and churning surgeons for an $8B orthopedic device company Machine Learning: Managed onshore and offshore associates to analyze the key drivers responsible for 31% drop in sales for products that had lost their exclusivity by using decision tree algorithms. Churn Analysis: Developed a model to detect the surgeons who’re likely to drop in future. Defined strategies for surgeons based on segments, led to 11% decline in churn rate. Results helped in the acquisition of $1M project with the client. Database Management and Visualization: Designed database with third-party data providers and created an interactive dashboard to show the effectiveness of marketing channels with retrospective analysis.

• Streamlined modeling and forecasting for a global med-tech US client Predictive Modeling and Customer Analytics: Lead a team of two analysts to identify the critical attributes by applying logistic regression and random forest classification on 40 engineered features built on customer purchase data. Executed overlap analysis, frontier analysis, and Alignment for present sales force teams. Sales Forecasting and Sizing: Designed an optimized sales force sizing (FTE) plan using workload build-up and affordable-coverage approach as per the company’s forecast for the new brands. It increased the profits by ~12% while ensuring the continuation and enhancements of services.

• Go-to-market strategy and product recommendation for $4B eye-care company across the US Customer Behavior Analysis: Implemented market basket analysis to define customer segments based on various attributes and association rules to create bundles for sales force personals. It boosted sales volume by 9%. Data Visualization: Designed dashboards to display product and competitor sales trends at various levels, which helped to identify burdened markets and contract with insurance providers. Also, presented resulting dashboards to the clients.

• Conjoint & pricing exercises for a Europe based leading orthopedic device company Product Surveying and Modeling: Created qualitative surveys to assess the opportunity for a Chronic Care Management offering and interviewing leading physicians. Further, analyzed their responses using logistic regression. Product Analytics: Analyzed survey insights and the estimated propensity was 48% to adopt the new product for the interviewed physicians. Discovered the impact of pricing (Van Westendorp method) & offered an optimal price.

(Python, Excel, PowerPoint, MySQL, R, SAS, Tableau, Qualtrics) ACADEMIC PROJECTS Jan 2019 – Present

• Healthcare Analytics: Predicted the re-admission of patients within 30 days of discharge using the Naïve Bayes model with and accuracy of 69% on Diabetes dataset of 1M+ rows to help save hospitals a potential penalty of $34M (SAS JMP, Excel, PowerPoint)

• Price Prediction: Predicted the price of listed Airbnb across the US to create an optimal price for host and guest; used data with 34 variables and 1M records; achieved an R-square value of 71% using Random Forest. (Python, PowerPoint)

• Potoo Data Challenge: Created MySQL database using real Amazon marketplace data and analyzed the behavior of various stock prices of publicly listed companies based on driving factors to design dashboards. ( SAS Enterprise Miner, Python, Tableau)