Vaishali Kelkar

Contact: 469-***-**** ac4f8f@r.postjobfree.com ac4f8f@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/vaishali-kelkar/ Website: http://www.utdallas.edu/~vaishali.kelkar/

Summary

Efficient and passionate with productive Data analyst skills and 4 years of experience in analyzing, interpreting data and reporting. Proficient and committed to business expansion by capturing insights and providing a growth advantage.

Work Authorization

Work Authorization for any employer in the U.S. (No Sponsorship required)

Education

University of Texas at Dallas December 2017

M.S., Business Analytics, Minor in Data Science G.P.A 3.4 Banasthali University 2010

Master’s in Biotechnology G.P.A 4.0

Technical Skills

• Language Skills: Base SAS, R, SQL, Python- Pandas, Numpy, Java (Beginner)

• Data Analysis tools: SAS Enterprise Miner, RStudio, SPSS, PowerBI, STATA, Google Analytics, Abode Analytics,

• Data Visualization & Reporting: Tableau, R, Rattle, QlikView, MS Business Intelligence Studio (SSAS, SSIS, SSRS)

• Databases: MS SQL Server, PostgreSQL, SQLite, RDBMS, Data Warehousing,

• Big Data, Hadoop, MapReduce, HDFS, Pig, Hive, MS Excel, Outlook, Access, Visio, Visual Studio, SharePoint

• Data extraction, Data cleaning, Transformation and Data Visualization, Reporting and Dashboards

• Regression, Prescriptive & Predictive Analytics, Machine Learning Algorithms

Work Experience

BizClouds Experts, Lewisville TX

Data Analyst Intern June 2017- September 2017

• Worked on the Amazon Web Services interface to monitor service logs of the client.

• Collecting logs calls from the AWS S3 buckets and streaming to AWS kinesis using AWS Firehose.

• Build SQL and AWS CLI queries for data extraction and cleaning and transferring for dashboard development.

• Provided business KPIs and dashboard using Kibana and Tableau.

• Assisted in troubleshooting, document preparation, client meeting and project coordination

University of Delhi, India

Senior Research Analyst & Junior Research Analyst January 2010 – September 2014

• Build customized SQL and SAS scripts and performed data extraction and cleaning

• Provided exploratory reports and build statistical models using SPSS and Advanced Excel

• Developed predictive regression model, correlation analysis, and analysis of variance using STATA and SPSS.

• Created reports and provided KPIs using VLOOKUPs, Pivot tables, and Macros

• Performed data manipulation, transformation, and cleaning and provided weekly performance updates

Project Experience

Healthcare Data Analysis, UT Dallas August 2017 - December 2017

• Performed detailed descriptive report on top 100 hospitals and their ranking, for each state in the US.

• Build python program, for downloading Medicare data and transferring to SQLite database tables.

• Performed multiple data cleaning and transformation step for providing structure to data.

• Utilized Dataframes and Pandas to perform data modification and data analysis using Python in Jupyter.

• Performed statistical analysis of data attributes and build a concise report on hospital performance and rank.

Marketing Data Analysis, UT Dallas January 2017-May 2017

• Analysed bank marketing data to identify customers likely to subscribe term product using R programming

• Implemented statistical analysis with Neural Networks, Clustering, SVM models and Random forest predictive model with 89% accuracy that could save $117 per customer, for each correct prediction.

• Determined 35 -50 age group range for target customer marketing to improve product subscription.

• Presented the customer targeted marketing strategy to improve product subscription and sales

Statistical Analysis using STATA, UT Dallas January 2017-May 2017

• Using STATA, determined a 1% reduction in alcohol consumption could decrease car fatalities by 21%

• Performed exploratory analysis and build predictive models using hypothesis-driven approach

• Determined $1 increase in beer tax could reduce vehicle fatality rate by 13% per 10,000 population.

• Build three predictive models and narrowed down 5-6 quantitative factors related to the drunk driving.

• Performed descriptive analysis on factors influencing drinking and driving for each state in the U.S.

Customer Sales Data Analysis, ShopKo August 2016-December 2016

• Amongst top 3 groups to perform in-depth analysis of customer retail data for a retail client, ShopKo using SAS.

• Build marketing strategy to improve business revenue by $45000 by 1% increase in the price.

• Developed customer segmentation using Latent Gold and identified customer purchasing behavior.

• Performed Market basket analysis, to derive sales and discount guidelines for improving business revenue.

Medicare Data Analysis, UT Dallas August 2016-December 2016

• Integrated data by compiling financial and geographical data for top 5 chronic diseases in the US

• Determined 8 critical quantitative factors, for Hospital Readmission rates causing loss of $41B annually

• Build Decision tree predictive model with 97% accuracy and could save $832 per patient using R and Rattle.

• Suggest measure to reduce Hospital Readmissions by 76% by increasing the In-Patient cost per capita by 50%.

Certifications

• Advanced Google Analytics, Google Academy January 2018

• Google Analytics for Beginners, Google Academy August 2017

• Python Summer Workshop, UT Dallas May-August 2017

• Data Science Foundations - Level 1- IBM- DS0101EN August 2017

Contact this candidate