Data Analyst

Rishabh Sabharwal

San Jose, CA ***** Mobile: 714-***-**** *******.**********@*****.***

EDUCATION

Master of Science in Information Systems, San Diego State University, CA GPA 3.79 Dec 2019 Coursework: Machine Learning, Big Data, Python, Enterprise Data Management, SQL Post Graduate Diploma in Financial Management, IMT Ghaziabad, India GPA 3.5 Jan 2015 Bachelor of Commerce (Honors), University of Delhi, India GPA 3.5 May 2012 TECHNICAL SKILLS

• Python, R, SQL, IBM SPSS

• Tableau, MicroStrategy, Power BI, SAS Analytics, Google Analytics

• Data Visualization, Data Mining, Data Structures, Data Management, Data Pre-Processing, Predictive Data Modelling: Forecasting, Regression Analysis, Classification, Clustering, Financial Modelling

• Requirements Gathering & Analysis, Campaign Analysis, A/B testing, Software Development Life Cycle

(SDLC), Software Testing Life Cycle (STLC), Agile Methodology, Scrum, JIRA PROFESSIONAL EXPERIENCE

MI Technologies, Inc. June 2018- Dec 2019

Business Data Analyst

• Extracted data from structured data warehouse using SQL to ensure the accuracy of financial data

• Reduced reporting time by 60 per cent by improving reporting processes and designing Tableau Dashboards to track material from manufacturing unit

• Helped business units achieve their goals through informed decision-making

• Identified potential opportunities for business improvement through analysis of underlying data

• Created interactive data visualizations that allow business leaders to make data-driven decisions to adjust quickly to performance and market trends

• Developed existing metrics to assess the performance of the business and investigate changes PricewaterhouseCoopers Private Limited (PwC) Nov 2012- April 2017 Senior Business Analyst

• Developed business architecture with cross-functional teams using client’s business requirements such as scope, budget, limitations, and risks

• Revamped risk management process and reduced project completion time by two days, saving $25K for firm

• Used SQL to check grievance & service request handling, quality of resolutions provided and close looping of calls, reducing customer churn out by 15%

• Presented data and conclusions to team in order to improve strategies and operations

• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables

• Uncovered fraudulent activities happening at a center which would have put client's brand name at risk ACADEMIC PROJECTS

Airbnb Price Prediction (R- ISLR, caret, chron, broom, maps, ggmap, mice, dplyr, naniar, VIM)

• Created prediction model which predicted the price with 80% accuracy, increased the revenue by 15%. Models used: Linear Regression, Ridge and Lasso, Principal Component Regression, Decision Tree, Random Forest, Bagging and Boosting. Caret, ggplot2, mice to do pre-processing, visualizing, and imputing missing values in data

Analysis on Accidents Data (R- ISLR, caret, ggplot, corrgram, mice, dplyr, snow, DMwR)

• Created model that predicted accident severity with 75% accuracy. Models used: Naïve Bayes, Decision Tree, Random Forest, Bagging and Boosting. Insult Detection using Text Analysis

• Built a binary classifier for Sentimental Analysis with 87% accuracy using Python, NLP, Logistic Regression and Random Forest

Database Design for Oil change Company

• Developed relational database to address the business problem; designed use cases, UML diagrams, schema notations, data dictionaries, query dictionary, and SQL queries. Increased the profits by 20% by increased customer satisfaction, and improved payment process by eliminating compensation errors by 100%

Contact this candidate