Data Analyst

Ashi Tapadia

****.*******@*****.*** 203-***-**** www.linkedin.com/in/ashi-tapadia

Well-organized and talented data analytics professional seeking summer internship as a Data Analyst. Adept at collecting, analyzing, authenticating, and modeling data set to improve business operational productivity, conduct market research and pinpoint patterns and trends. Commands deep familiarity in SQL, Excel, R, Python, Tableau, SAS. EDUCATION

University of Connecticut, School of Business Aug 2019 – May 2021 Master of Science in Business Analytics and Project Management CGPA 4/4.3 Coursework: Statistics, SQL, Predictive Modeling, Data Mining, Data Visualization/Reporting, Business Intelligence Rajiv Gandhi Proudyogiki Vishwavidyalaya Aug 2015 – May 2019 Bachelor of Engineering in Computer Science CGPA 3.7/4 TECHNICAL SKILLS

Programming Languages & Databases: R(ggplot2, dplyr, Lubridate, tidyverse),Python (NumPy, Pandas, Scikit-Learn), Oracle 11g, SQL Tools: Jupyter Notebook, Tableau, Microsoft Excel (VLOOKUP, Macros, VBA, Pivot tables), MS Visio (Business Process Modeling), SAS JMP, MS Project (Gantt Charts, WBS), PowerPoint, Prezi, MS Office Tools, SAS Enterprise Miner, Google Analytics Data Modelling & Statistical Analysis: Data Cleaning, Data Mining, Dimension Reduction, ETL, PCA, Hypothesis Testing, Linear Regression, Logistic Regression, Clustering, K-NN, Random Forests, Gradient Boosting, Neural Networks, Segmentation, Customer Analytics, A/B testing, Financial Forecasting, Text Analysis, Time Series Forecasting, MapReduce, Market Basket Analysis EXPERIENCE

Experiential Learning Collaborative, University of Connecticut/UConn Health (Marketing Analytics Consultant) Jan 2020 – present

• Developed plans and proposed actions of go to market strategy for startup by understanding customer segmentation and need; created interactive Tableau dashboards to make NSCLC data visually appealing

• Designed financial analysis models using Macros that help define opportunities for two exit strategies to enter the marketplace UConn Graduate Consulting, Connecticut (Vice President and Data Analytics Consultant) Oct 2019 – Dec 2019

• Aggregated data from various sources to construct streamlined data pipelines and integrate data in SQL to create a single consolidated file to assess the credibility of all the non-profit organizations for future engagements

• Evaluated non-profit organization by building selection models in MS Excel by assigning weights to different KPI’s based on readiness assessment framework proposed by the client and external consultants; improved the engagement efficiency by 27% ACADEMIC PROJECTS

Predictive and Prescriptive Analytics : NBA Draft Salary Prediction

• Identified key business levers, performed analyses to facilitate data driven decision-making to determine the age of an NBA player when he receives his highest salary of his career; and processed information for 5000 NBA players using Excel (VBA, VLOOKUP)

• Implemented EDA, PCA; developed predictive models like neural nets, decision trees and KNN and assessed the models using R square Statistics : World Happiness Record

• Analyzed the world happiness score and proposed solutions for industries to understand the impact of their product, sales, and marketing initiatives on customer happiness and future behavior

• Performed feature selection on the parameters using filter method; provided data insights using OLS, Lasso & ridge linear regression models; selected the best models using AIC and BIC criterion Sales Forecasting : Superstore Data

• Explored, modified, and indexed 3-year historical data and then performed a time series forecasting using ARIMA models to predict the sales; identified trends and patterns of different categories of superstore with uncertainty bounds and anomaly detection Database Modelling and Structure : IOT based Startup

• Designed an entity-relationship (ERD) model in MS Visio for IOT based company to keep track of inventory, billing, users and licensing

• Created SQL scripts in Oracle 11g to generate reports for 15+ most frequent business queries used by the company on a daily basis ACHIEVEMENTS

• Section Leader, MSBAPM Student Council, University of Connecticut Oct 2019 - present

• Vice President, UGC Leadership Team, University of Connecticut Sep 2019 – present

Contact this candidate