Python, SQL, R, HQL, Tableau, Excel, Statistical Analysis, Regression

PARTH GABANI

New York ***** *******@********.*** +1-347-***-****

EDUCATION

Columbia University New York, NY

MS in Operations Research, Concentration in Analytics Oct 2020 – May 2022 Coursework: Optimization Models (Currently Graduate Course Assistant), Business Analytics, Probability & Statistics, Industry Projects in Analytics, Machine Learning in Data Science, Stochastic Models, Visualization & Storytelling with Data. University of Mumbai, Mumbai, India Mumbai, IN

B. Tech in Mechanical Engineering, (GPA: 3.61/4.0) May 2019 Coursework: Database & Information Retrieval Systems, Project Management, Industrial Engineering and Management. PROFESSIONAL EXPERIENCE

WealthTechs Inc., New York, NY

Part-time Data Science Consultant Jan 2021 – Present

• Leveraging machine learning (NLP) for standardization of custodian and wealth account datasets and identify patterns of anomalies using python.

• Performed data analytics and queried data to extract important features to accurately predict security-types. Columbia SIPA HR & Finance Department, New York, NY Student Assistant Nov 2020 – Feb 2021

• Supported in data management on Excel and presented data analysis by manipulating & analyzing employee data. National Institute of Industrial Engineering, Mumbai, IN Supply Chain Research Intern Nov 2019 – Apr 2020

• Wrote a research paper on developing a novel approach of drone-delivery system concept for populated urban cities.

• Conducted extensive literature reviews and proposed research solutions for concept to implement at scale. Team Onyx India (SAE Aero Design Texas), Mumbai, IN Project Manager Aug 2017 – Jul 2019

• Spearheaded a team of 30 members for first international participation after five years and achieved best ever rankings in team’s nine-year history.

• Devised marketing strategies after analyzing market research data that increased revenue generation by 226%.

• Presented and communicated project idea and won 1st Prize in the Best Technical Presentation and 3rd Prize in the Best Design Report Awards nationally.

ANALYTICS PROJECTS

IMDB: TV Shows Recommendation System

• Building a TV shows recommendations system based on viewers content interests and past watch history.

• Web scrapped and extracted social data from IMDB, formulated and applied mathematical modeling to interpret key content performance and engagement metrics and translate it into a scalable mathematical model. Instacart: Personalized Grocery Product Recommendation based on past Customer Behaviour

• Developing personalized recommendation engine by prioritizing and advertising products for their next purchase.

• Merged and queried data to extract, join and filter large multiple large datasets (3M+ orders), and performed exploratory data analysis to provide effective strategies leading to increased sales. Foursquare: Location Analytics for Opening Restaurant Business in NY

• Identified best location and food category for a restaurant business by formulating mathematical and simulation models, and identifying numerical parameters to determine specific customer density and preferences.

• Collected and cleaned data by web scrapping from Foursquare Location API, visualized data, generated insights, built statistical models and performed significance testing and regression analysis for accurate food category suggestions. Airport and Airlines Data Analysis using Tableau Dashboard

• Created a visually impactful Tableau Dashboard for data reporting to identify and visualize airline routes, and highlighting the busiest and most lengthy routes from the airport. TECHNICAL SKILLS and CERTIFICATIONS

• Skills: Python, R, SQL, HQL, Tableau, PowerPoint, Word, Excel.

• Online Certifications: IBM Data Science Professional Specialization, SQL for Data Science, Excel Skills for Business.

Contact this candidate