SQL, R, Tableau, Excel,Python, SAS

Shivani Shekhavat

+1-682-***-**** *****************@*****.*** LinkedIn GitHub

EDUCATION

The University of Texas at Dallas December 2018

M.S., Business Analytics GPA 3.56

Uttarakhand Technical University June 2014

MBA (Finance & HR) GPA 3.5

SKILLS

• Certifications: Programming for Data Science with R, MySQL for Data analysis

• Machine Learning & Algorithms: Regression, Logistic Regression, Decision Trees, Random Forests, Clustering, Principal component Analysis

• Skills/ Tools: Jupyter Notebook, pandas, NumPy, scikit-learn, dplyr, tidyr, R-ggplot2, MS Excel, Seaborn, matplotlib, Tableau, Power BI, QlikView, Data Mining, Data Analysis, Business Analysis

• Data Mining / Databases: R, Python, SQL, SAS, STATA, Advanced Excel, Google Analytics

• Database: MS SQL Server, MySQL, Oracle, MongoDB, MS Access, A/B Testing ACADEMIC PROJECTS

Austin Animal Shelter using Python

• Developed a model to reduced number of deaths of animals in shelter

• Predicted a model for transfer and adoption for animals using PCA also calculated model accuracy and cross validation score

• Performed exploratory analysis and data visualization using different packages like NumPy, Pandas, Seaborn, Requests, matplotlib

Olympic Data Analysis using R

• Performed data cleaning and summarized data, created word cloud of games which were played in Olympics over the years

• Explored the historical data for summer and winter Olympic, including analyses of top team, sports and

• athletes, P sex ratio of athletes, and age distribution of athletes Turo Car model (Visualization in Tableau)

• Analysed the car renting website, created database design using MySQL. Loaded the data in batches

• Designed semantic layer in IDT and UDT, created dashboards and visualized the same in Tableau

• Created reports of sales data for clients using web intelligence Titanic Survival Prediction

• Imputed missing values using Mice Package and then analysed it using various packages

• Created decision tree for survival of people using random forest algorithm

• Predicted a model of survival using feature Engineering to gain insights from the existing data which includes inference from Age, Gender, Family size on percentage of survivability. EXPERIENCE:

The University of Texas at Dallas, Graduate Teaching Assistant, Dallas, TX August 2018 – December 2018

• Assisted 150+ students with concepts like Data Management, Python, database design, SQL

• Developed study materials for students to cut down their study time and to improve their skills Aqme Automation and Packaging, Product Analyst, Delhi, India April 2014- April 2017

• Performed in-depth analysis and provided recommendations into key performance metrics and goals

• Designed Dashboards using calculations, parameters in Tableau to cost determination and to identify the trends

• Made effective presentations to multiple levels for key stakeholders and senior management team to provide actionable data driven insights through visualization of quantitative information

• Used advanced Microsoft Excel to create pivot table and pivot report

• Assessed client requirements, prepared business cases and reviewed requirement documents

• Managed cross-functional projects by providing project leadership and daily management throughout the project from inception to delivery

• Performed root cause analysis to formulate and implement effective business processes and decisions

Contact this candidate