Data Microsoft

Vivek Singh www.linkedin.com/in/vivekreachesu

**** *. ***** **. *** # 9, Tempe, AZ 85281 714-***-**** *****.*****.*@***.*** Summary

Business Analytics Graduate with 8+ years of experience, actively looking for full time job opportunities in the field of data science / analytics / data warehousing & business intelligence. Education

W. P. Carey School of Business, Arizona State University, Tempe, AZ May 2016 Master of Science in Business Analytics (MSBA) (3.81/4 GPA) Coursework: Enterprise Analytics, Applied Analytics, Data Mining, Data-Driven Quality Management, Analytical Decision Making, Business Analytics Strategy, Marketing Analytics, Optimization, Predictive Analytics, Modeling, Simulation. West Bengal University of Technology, West Bengal, India June 2008 Bachelor of Technology, Computer Science, (3.7/4 GPA) Certifications:

Informatica Certified Developer, Informatica Corporation

R Programming Certified, Coursera

SAS Programming Essentials, SAS

Hadoop Fundamentals, IBM

Pig Fundamentals, Big Data University

Technical Skills

Tools & Frameworks: Hadoop, SAS, IBM SPSS, Microsoft Azure ML, Tableau, Informatica, Advance Query Tool, IBM Clarity, RStudio, Anaconda, MySQL Workbench, IBM Watson, Solver, Stat Tools, Pig, Hive, Beeswax, Precision Trees, Palisades RISK, Minitab, 1010data, Microsoft Office (Microsoft Excel, Microsoft PowerPoint, Microsoft Word). Languages: SQL, R, Python, C, C++, SAS language, UNIX scripting. Database: Oracle 10g, DB2

Platforms: Pig, Hortonworks Data Platform

Operating System: UNIX, Windows XP/7/8

Professional Experience

Senior Business Intelligence Analyst June 2016 - Present Sprouts Farmers Market, Phoenix, Arizona, US

Used SQL to query historical data in order to analyze the impact & effectiveness of advertisements resulting in improved sales.

Worked on market basket analysis and calculated support and confidence for huge number of SKUs

Understood functional requirements and converted them to actionable business metrics & KPIs of Retail industry. Data Engineer / Data Analyst December 2013 – June 2015 IBM / AmerisourceBergen Corporation, Orange, California, US

Analyzed & measured medication adherence data of patients, through Informatica, which increased 15-22% prescription refills.

Used data mining techniques (clustering) for customer segmentation, increasing 18-20% of sales volumes.

Performed ETL to implement Interactive Voice Response (IVR) increasing revenue by $15M per year.

Performed peer to peer comparison to gain analytical & operational insights generating a revenue of $20M per year.

Led data warehouse offshore (India) development team of 10 system engineers from US.

Collaborated with cross functional teams and solved complex business problems.

Extensively used MS Excel & Oracle SQL to dig into big data sets and explored answers to key business questions.

Exceptional ability to use MS PowerPoint for presenting results & proposals to executives and higher management. Data Warehouse Team Lead / Senior System Engineer July 2008 – November 2013 IBM, Kolkata, India

Led a team of 5 to design and develop and executed Online Analytical Processing (OLAP) solutions from end to end.

Developed automated solution for data validation resulting in $5M savings annually by reducing manual work by 80%.

Implemented all phases of Software Development Life Cycle (SDLC), starting from planning, requirement analysis, design, testing, implementation, to maintenance which led to flawless execution of projects.

Performed unit testing, regression testing, and integration testing across different teams. Academic Experience

Influencers in Social Media - Kaggle Competition [SPSS, Microsoft Azure ML, Microsoft Excel] October 2015

Developed a predictive model to compare different attributes of social influencers and predict their influencing power.

Ranked 37 for the model developed in Kaggle.

Business Intelligence & Data Visualization Project for Apple App Store [Tableau] October 2015

Performed analysis on Apple Application Store dataset.

Developed business intelligence and data visualization reports & dashboards on the dataset. Direct Marketing Analytics [ R, SPSS, Microsoft Azure ML ] November 2015

Developed a predictive model to help Portuguese bank in direct targeted marketing of term deposits.

Machine Learning Algorithms used: C&R Tree, Quest, CHAID Fraud Detection in Auto Insurance Company [ Python, SPSS, Microsoft Azure ML ] November 2015

To overcome the frauds in an Auto Insurance company, developed a predictive model to accurately classify the fraud claims.

Machine Learning Algorithms used: Neural Network, K-Nearest Neighbors. Reducing Customer Churn of a Mobile Company [SPSS, Microsoft Azure ML ] November 2015

Developed a model to identify potential churners, helping business to proactively act upon these customers.

Machine Learning Algorithms used: SVM, Ensemble methods. Determining clusters to predict income of individuals [SPSS, Microsoft Azure ML ] November 2015

From census data, created a model to classify individuals based on their income.

Machine Learning Algorithms used: Clustering – K-Means, Kohonen Staffing Optimization in Sun Devil (ASU) bookstore [Minitab, Microsoft Excel, PowerPoint] November 2015

Developed an optimized staffing schedule using Six Sigma methodologies and to predicted the number of transactions in future using regression analysis.

Developed a User-Based Recommendation System [ Python ] January 2016

Used distance based similarity measures (Manhattan, Euclidean, Minkowski) to develop a User Based Recommendation system. Fraud Detection in Prudential Life Insurance [R, Python, Microsoft Azure ML, SPSS] February 2016

Developed multi–class classification predictive models using different data preprocessing techniques and machine learning algorithms to accurately classify Prudential Life Insurance customers based on risk and eligibility of insurance.

Preprocessing Techniques: Feature Creation, Feature Selection, Missing data imputation, Outlier detection, transformation.

Machine Learning Algorithms Compared: Multiclass Neural Network, Decision Jungle, Decision Forest, Logistic Regression Honors & Awards

Received IBM Manager’s Choice Award in 2014 for contributing to account growth by generating original ideas.

Received IBM SPARK Award in 2013 for high performance while fostering an innovative and diverse culture.

Received the distinguished IBM ORION Award in 2012 as a mark of eminence and excellence.

Received ‘Certificate of Appreciation’ in 2009 from IBM for showing enormous sense of responsibility and dedication to team’s success. Identified as best performer, with highest rating, in IBM for 2 years.

Contact this candidate