Sales Data

Vaibhav Kumar

Phone: 860-***-****) *** Asylum Ave, #709, Hartford, CT, 06105

LinkedIn: https://www.linkedin.com/in/vaibhav-kumar93/ Email: *******.*****@*****.*** Analytics professional experienced in delivering data driven solutions for fortune 500 companies in Healthcare and Consulting, looking for summer internships starting May/June 2020. Proficient in Python, SAS, SQL, VBA, Excel, R, Tableau EDUCATION

University of Connecticut School of Business (GPA: 3.67/4.00) Hartford, CT

• Master of Science, Business Analytics & Project Management Aug 2019 – Present SRM University (GPA: 3.82/4.00) Chennai, India

• Bachelor of Technology, Electronics and Communication Engineering Aug 2011 – May 2015

• Graduated in Top 1% of Class, First class with distinction TECHNICAL SKILLS

Language and Tools: SAS, SQL, R, Python (Matplotlib, Pandas, NumPy, Scikit-Learn, Keras), VBA, Tableau, Alteryx, SAS EG, SAS JMP, Microsoft Office, Visio, Jupyter Notebook, Advanced Excel (VLookup, Index), PowerPoint, GitHub Databases: Oracle 11g, Hadoop, Cloudera, Impala, Microsoft SQL Server Statistical and Analytical Skills: Exploratory Data Analysis, Regression Analysis, PCA, Clustering, Probability Distributions, Hypothesis Testing, Decision Trees, Random Forest, Dimension Reduction, A/B Testing, Neural Networks, Naïve Bayes, Time Series Forecasting, Data Mining, Predictive Modelling, Customer Churn Analysis, Data Warehousing, Machine learning Algorithms, Big Data Analytics, Business Intelligence, Healthcare Analytics Sales Analytics: Sales Force Effectiveness, Pricing, Call Planning, Targeting, Customer Segmentation, Managed Markets EXPERIENCE

University of Connecticut – Business Intelligence Analyst (Student Employee) Sep 2019 – Present, Storrs, CT

• Building warehousing solutions to support both analytical applications and business intelligence geared towards planning, institutional effectiveness, and decision making at UConn

• Integrating data in SAS, performed HR Analytics to create a comprehensive Fact Sheet posted in university website Novartis – Analyst, Advanced Analytics Dec 2017 – Aug 2019, Hyderabad, India

• Developed marketing mix models to evaluate impact of various promotional channels to measure contributions and return on investment, further optimizing spends across portfolio

• Led data strategy team for smooth migration of database from Oracle to Hadoop based Big Data platform

• Determined market access, formulary and payer analytics KPIs to track situational analysis of key oncology drugs

• Analyzed and performed churn analysis on patient level insurance claims dataset to measure drivers of retention

• Designed metrics such as Contract Sales and Rebates % in Excel and VBA to assess the ROIs on payer contracts

• Automated report generation process using macros written in SAS and VBA resulting in ~70%-time reduction ZS Associates – Business Operations Associate Apr 2016 – Dec 2017, Pune, India

• Built end-to-end big data pipelines from data ingestion to insight generation for multiple teams

• Managed a team delivering analytical solutions for top pharma client with turnover of $22.05 Billion

• Streamlined operational reports using SAS, SQL and VBA resulting in reducing manual efforts by ~ 67 %

• Created KPIs to track Sales Reps activity such as Calls per day, Calls Attainment to assess Sales Force Effectiveness

• Extensively developed dashboards across multiple work streams (Field Reporting, Brand Insights, Managed Markets) and clients’ Senior Management at regular cadence within defined SLAs Cognizant Technology Solutions – Programmer Analyst Aug 2015 – Mar 2016, Hyderabad, India

• Optimized ETL and created SQL queries for Media and Entertainment client on royalty pay accounting system ACADEMIC PROJECTS University of Connecticut Aug 2019 – Dec 2019

• Predicted Reviews of Restaurants listed in TripAdvisor to advise restaurants to improve ratings. Models used: Neural Networks, Decision Trees, Logistic Regression, KNN and Naïve Bayes (chosen with accuracy ~78%)

• Fraud Analytics: Identified potential fraud claims and key drivers of fraudulence by predicting subrogation flag and developing classification models with an accuracy of 73%

• E-Commerce Segmentation: Created high level KPIs and performed customer segmentation to increase revenue

• Performed gap analysis on UConn’s course enrollment system, implemented a database through SQL queries AWARDS & HONORS

• Received Project Champions Award for two years in a row at ZS for driving exceptional client impact

• Above & Beyond prize for ‘Process Excellence and optimization’ at Novartis

Contact this candidate