R, Tableau,Statistical Analysis, Predictive analysis

Sonal Deshmukh

****, **** ********** *****, *** # 3059, Tempe, Arizona 85281 480-***-**** *****.********@***.*** in.linkedin.com/in/sonalgdeshmukh

SUMMARY

2+ years of professional experience in Business Intelligence domain

Proficient in data management and analysis: ETL (Extract-Transform-Load) data technique with large data sets (SAP – BI and R)

Experience in Data Modeling: machine learning (regression, classification, clustering), time series analysis, ANOVA analysis, categorical data analysis

Proficient with languages: SQL, PL/SQL, R, SAS, Python

Proficient in data visualization and dash boarding tools using Tableau

Expertise in requirement gathering, data reconciliation, cleansing and root cause analysis and reporting EDUCATION

Master of Science in Business Analytics May 2016

W. P. Carey School of Business at Arizona State University, Tempe, Arizona, USA GPA 3.7/4.0 Bachelor of Engineering in Information Technology May 2012 Vidyalankar Institute of Technology, Mumbai, India GPA 3.5/4.0 PROFESSIONAL EXPERIENCE

Data Scientist Intern, Nebraska Book Company, Lincoln, Nebraska July 2016 – Present

Forecasted demand and acquisition for products with time series model in R for business development

Performed Extract-Transform-Load (ETL) as per business rules using SQL server management studio and R

Carried out data visualization of time series for exploratory data analysis to identify trends and seasonality SAP Business Intelligence Consultant, Capgemini India Pvt Ltd, Mumbai, Indi May 2013 – July 2015

Developed data models using SAP Business Intelligence and Solution Manager tool and facilitating effective communication among team members which addressed ad-hoc data related business requirements

Engaged with clients to gather requirements and converted them into technical specification documents for business solutions

Maintained knowledge error database and monthly metrics by serving Project Quality Lead which helped identify key performance indicators (KPI’s)

ANALYTICS PROJECT

ASU Applicant Pipeline Analysis- Capstone project

Effectively communicated with stakeholders to identify market segments, key features and metrics to optimize the number of prospective students for admission

Segmented data into clusters by analysing historical trends in student enrollment across various market segments in Tableau

Developed predictive model for identifying likelihood of a student getting an admit and enrollment at ASU using R with an accuracy of 81%

Say Yes to the Dress

Forecasted predictability of selling an appropriate dress for a particular season using R.

Predicted customer churn for various dress styles using random forest and Naïve Bayes classifier method Process improvement for Delhi Palace-an Indian cuisine restaurant

Collaborated with a team to determine root causes in customer fallout using Six Sigma DMAIC methodology

Performed statistical analysis using control charts which helped determine root causes

Visualized the results at every stage using Excel/Tableau and recommended ways in which the process can be improved Kaggle Competition – San Francisco Crime Classification

Utilized SPSS Modeller to implement unsupervised algorithms such as K- Nearest Neighbour to perform classification and knowledge discovery

COMMUNITY INVOLVEMENT

Student Ambassador, W.P Carey School of Business, Tempe, Arizona July 2011 – May 2013

Facilitated the university admission process by evaluating existing admission system and addressing groups of 10-30 students helping them understand admission and enrollment procedures

Contact this candidate