Data Analyst

Pragati Koladiya

adjoh5@r.postjobfree.com j 415-***-**** j LinkedIn j GitHub j Tableau Public

SUMMARY

Passionate about extracting data insights and leveraging them to drive strategic business decisions EDUCATION

MS, Data Analytics (Major: Statistical Modelling) Jan 2020 - Present Northeastern University, San Jose, CA GPA: 3.88/4.00 BTech, Computer Engineering Aug 2015 - May 2018

Nirma University, India GPA: 7.06/10.00

TECHNICAL SKILLS

Python, Scikit Learn, SciPy, Pandas, NumPy, Seaborn, Matplotlib, R, SQL, Microsoft Excel, Tableau COURSEWORK

Predictive Analytics, Data Warehousing, Data Mining, Data Visualization, Probability Theory and Statistics, Enterprise Analytics, Business Intelligence, Data Driven Decision Making, Machine Learning PROFESSIONAL EXPERIENCE

Data Analyst Intern - Gestalt Group, USA April 2021 - July 2021

• Parsed HTML (using Python) to harvest insights from the various real estate websites

• Developed data pipelines(in Python) to load insights into the company’s MySQL Database and query data to grab meaningful insights for business decision support.

• Generated reports using tableau for daily data summary and created front-end applications using glide. Summer Intern - Wolf Soft Pvt. Ltd, India May 2017 - Jul 2017

• Analyzed data and built dashboards to monitor KPIs for a food recommendation app

• Designed and developed data storage models for backend APIs Software Intern - Softweb Technologies, India May 2014 - Aug 2014

• Created user interfaces and image processing modules to lter, resize and edit images ACADEMIC/PERSONAL PROJECTS

Hotel Booking Cancellation Prediction May 2020 - Jun 2020

• Implemented Logistic regression, KNN classi er and Random Forest Classi er to predict booking cance- lations and utilized Lasso Regularization Model (for feature selection)

• Achieved the highest accuracy of 83% with random forest model Data Warehouse Design for Yelp Dataset Sep 2020 - Oct 2020

• Designed a data warehouse solution for storing restaurants, customer reviews, and advertisements data

• Implemented SQL queries and built a dashboard in Tableau to analyze restaurant performance, customer satisfaction and advertisement revenue

Footwear Sales Modelling Oct 2020 - Nov 2020

• Forecasted the sales for next two years with decomposition additive, ARIMA, Exponential Smoothing, and Naive forecasting

• Developed a solution in R to predict if a new product will be a valuable addition to the catalog using Naive Bayes

Asthma Patient Dashboard Sponsored by NEU/Keva Healthcare Jan 2021 - April 2021

• Analyzed the number of asthma patient and examined the frequency usage of di erent app features using analytical queries in MySQL Workbench.

• Created an interactive dashboard in Tableau to understand patient and physician usage of application. LEADERSHIP EXPERIENCE

Event Coordinator Unity of Youngistan (NGO), Ahmedabad, India May 2016 - June 2017

• Organized numerous events including essential computer skills workshops for elderly

• Responsible for seeking funds from sponsors and utilized optimally to maximize event impact

Contact this candidate