Data Analyst Customer

VINAY BANPEL

*** **** ******, *** #*, Brooklyn, NY – 11209 347-***-**** ******@***.***

EDUCATION

New York University, New York, NY Dec, 2017

Master of Science in Management of Technology (GPA- 3.71) Coursework - Business Analytics, Data Visualization, Technology Strategy and Management Science Mumbai University, Mumbai, India May, 2014

Bachelor of Engineering; Information Technology (GPA– 3.73) Coursework - Data Mining and Business Intelligence, Database Technologies, Software Testing and Quality Assurance WORK EXPERIENCE

Data Analyst, VVPatchouli E-Commerce Fashion Company, NYC (R, SQL, Python, Tableau) May 2017 – Dec 2017

Worked on customer analytics project to transform raw data into insights using various statistical techniques and data mining tools such as R, Python (SciKit, Pandas, NumPy), SQL, and Tableau (Clustering, Regression, ANOVA)

Implemented Logistics Regression with an accuracy of 0.79 (Confusion Matrix) to predict the customer who are more likely to buy the product based on age, area income, browsing pattern, city, temporal effect, gender, purchase history

Performed A/B testing and developed adhoc dashboards to identify KPIs (sell through rate, average customer spends, stock turnover rate) using Tableau calculated field function which increased the customer satisfaction by 17%

Performed end to end Social Media PPC campaign to analyze CTR, CPC, Lead CVR%, identified lead to customers KPIs (CPA, CLV, retention rate, customer acquisition cost) and evaluated post completion survey results through Net Promoter Score Data Analyst, NYU Office of Graduate Admissions (Excel, Tableau, Python) Jan, 2016 – April, 2017

Analyzed 6 years of student enrollment data using advanced excel(Pivot) and Tableau to identify trends for the incoming batch

Elicited and gathered requirements from faculty and senior management through open-ended discussions and brainstorming sessions

Identified percentage of students in focus area, graduation rate, student to faculty ratio, student attendance rate using data analysis methods Data Analyst, Capgemini Consulting, Mumbai (SQL, SAP BO, Excel functions) Aug, 2014 – Nov, 2015

Worked with UK based postal service client to support shipment and delivery operations by leveraging data from multiple SQL databases aimed at identifying KPIs (order accuracy, delivery time, transportation cost)

Supported data and analytics requests throughout the initial development cycle including gathering data requirement, validating data, synthesizing insights using SQL and SAP Web Intelligence reporting

Designed and developed the (Dimensions, Facts, Aggregations) with integrity constraints into data foundation layer using connection pool, developing multiple dimensions and facts/ Measures objects in semantic layer to empower business users with autonomy to analyze sales Data Analyst Intern, Master Bridge, Mumbai Jan, 2014 - July, 2014

Worked on developing reports for client monthly reviews on SBI (Sales Business Intelligence system) an internal tool which captures information on New and Recon automobile parts.

Used cluster analysis for identifying customer segments, decision trees used for profitable and non-profitable customers and market basket analysis for customer purchasing behavior and product association TECHNICAL SKILLS

Programming Languages: R, Python

Database Technologies: MySQL, SQL Server Management Studio, Oracle DB, MS Access, Apache, Tomcat, Glassfish

Business Process Techniques and Methodologies: UML, Flowchart, Gantt Charts, Waterfall, Agile SCRUM

Tools: MS Office, MS Excel, Business Objects, SPSS, SAS, Tableau, PowerBI, JIRA, MS Visio CERTIFICATION

International Institute of Business Analysis – ECBA 49798 Sept, 2017 ACADEMIC PROJECTS

Business Analytics: Healthcare Performance Prediction ( R, Tableau)

Extracted, transformed, and cleaned 53 csv files from data.healthcare.gov to conduct feature analysis using regression models

Developed supervised learning models aimed towards predicting factors affecting hospital performance by evaluating accuracy through Ridge, Lasso and Polynomial regression with computed R-square of 0.72 and minimized sum of square errors (regularization) Business Analytics: Default prediction on peer-to-peer loans (Python, Tableau)

Implemented kernelized support vector machines (RBF) model to classify and predict the customers that are likely to default loans

Created interactive dual location heat maps dashboards using Tableau to show types of loan distribution across various regions Data Analytics: Analysis of Citi bike using R and Tableau (R, Tableau, Microsoft Excel)

Analyzed the data and formed summary statistics for formulating segmentation strategy to allocate the marketing budget

Developed multivariate regression and evaluated accuracy using 5-fold cross-validation method to forecast revenue for 2016

Profiled Citi bikes based on inventory levels at any given time during the day and visualized it on a dashboard using tableau Management Science: Decision Making Technique (Excel Solver – QM Package)

Implemented multi-criteria mathematics decision-making models, Linear/Integer programming (Total, 0-1, Mixed Integer models) and Sensitivity Analysis to develop optimization solution for maximize profits EXTRACURRICULARS

Graduate Student Union: Unit President at GSOC UAW in STEM to facilitate the growth and progression of international students

Contact this candidate