Data Assistant

Prachi Dasharath Bhopatrao

****,******** *****,******** ***** 469-***-**** *******@*****.*** https://www.linkedin.com/in/prachi-bhopatrao-351111a5/ Education:

• University of Michigan, Dearborn 2019 to Present Master of Science in Data Science (graduating April 2021) GPA: 3.66/4

• Vidyalankar Institute of Technology (VIT), Mumbai University 2012 – 2015 Bachelor of Engineering in Electronics & Telecommunication GPA: 3.56/4 Graduate Courses: Database Systems, Applied Regression Analysis, Intelligent System, Big Data Analytics & Visualization, Data mining for Business Applications, Introduction to Big Data, Data Security, Models of Operation Research, Enterprise information Systems.

Technical Skills:

• Data Analysis Tools and Languages: SQL, SSIS, Tableau,PowerBI, Python, R, Jupyter Notebook, RStudio, JMP

• Databases: SQL, PostgreSQL

• Python Libraries: Pandas, NumPy, scikit-learn, matplotlib

• R Libraries: dplyr, rpart, ggplot2, pysch, randomForest, tidyverse

• Machine Learning: Data Processing, Regression, Classification, Decision Tree Professional Experience:

Graduate Research Assistant at University of Michigan Dearborn Feb 2020 to Present

• Data gathering, cleaning, making it Analysis ready using python, R and PostgreSQL.

• Create visualization using tableau to know the owners with more properties and blight violation tickets.

• Build prediction models to get insight of Detroit blight ticket data to understand the reason for blight ticket compliance being low.

TATA Consultancy Services Limited, India

IT Analyst July 2015 – July 2019

• Worked closely with the stakeholder to translate business requirements into technical solutions as reports, KPIs, and scorecards using Microsoft SSIS and Tableau.

• Coordinated with client database team for data cleaning and variables selection to ensure data is meaningful and analyzable.

• Designed and developed ETL packages in SQL Server Integration Services (SSIS) to extract, transform and load data from structured and unstructured data sources into data warehouse.

• Automated daily/weekly reports and optimized of complex queries.

• Worked on store procedures, joins and complex SQL queries to create custom SQL solutions as per client requirements.

• Built quarterly and yearly reports and dashboards on company financials and various portal sections using Tableau.

• Ensured data accuracy through the creation and implementation of data integrity queries.

• Formatted and inserted the data into staging table, performed data cleansing and data type conversion and loading into the destination table.

Academic Projects:

• Life Expectancy Analysis: Developed various statistical models in R to predict the Life Expectancy of 193 countries based on various factors, Implemented Linear Regression, Logistic Regression, Decision Tree.

• Car Price Prediction: Implemented classification, Regression, Machine learning methods to predict the price of car based on various factors such as wheel -base, engine size, fuel system etc. and to find how risky/safe a car is based on the car attributes available in the dataset.

• Sentiment Analysis using the Amazon product review dataset -Implemented Naïve Bayes, VADAR and Support Vector Machine Algorithm to predict sentiments of product reviews. Evaluated a system by calculating accuracy and precision.

• Worked on flaws and enhancement on IEEE paper by Shokri- Membership Inference attack. Implemented few enhancements using machine learning concepts such as black box, shadow models. Honors & Achievements:

• Awarded as the best team player and achieved the highest performance rating for all four financial years i.e. Band A.

• Active member of Graduate Indian Student Association, Women in Business and Data Science Organization at UM Dearborn.

Contact this candidate