Prathamesh Sharma

Data Scientist Intern

Client: US Department of Small Business Administration :
 • Performed quantitative analysis on 10 years of Federal Procurement data using regular expressions.
 • Classified industries where WOSB’s are least represented using statistical methods to evaluate SBA’s program.
 • Predicted the number of jobs created by running regression models over the HUBZone dataset with features such as Dollars Obligated, Economic Impact, No. of years, etc. with 79% accuracy.

Client: US Department of Education, National Center for Education Statistics :
 • Analyzed and built interactive dashboard showing KPI’s to measure real-time impact of COVID-19 on school information mode for entire US from multiple data sources using Tableau, reducing effort to action by 90%.
 • Streamlined the data preprocessing task using feature engineering resulting in more than $100k in savings.

Business Intelligence Intern

• Implemented Google Analytics as a Microservice to find the most important web pages to perform accessibility analytics and integrate into one of Optimal's products using Python & SQL.
• Revamped information retrieval speed by building analytical cubes in SSMS and normalizing the database.
• Developed complex SQL queries to extract large scale data, automated data ingestion process in a data using ETL pipelines, built innovative web-friendly dashboards for the client to evaluate website readability.

Data Analyst Intern

• Constructed SQL queries to retrieve data to analyze player segmentation, forecast ROI and build visualizations.
• Conducted A/B testing to develop hypothesis to measure effectiveness which increased revenue by 11%.
• Explained less participation using statistical analysis resulting in decrease of entry fees and increase in participants.

Visualization and Analysis of Airbnb Listings in NYC and Austin:

• Performed data cleansing for a total of more than 100,000 records with the ETL process using Microsoft Excel.
• Created dashboards, stories, metrics and reports using Tableau, to derive insights for Airbnb listings.
• Analyzed data and performed regression using Python on factors affecting the price of an Airbnb.

Data Modeling, Acquisition and Visualization with SAP:

• Loaded transaction data from a source in the data acquisition layer with the help of SAP BW4/HANA.
• Performed multidimensional modeling using SAP BW resulting in faster financing report.
• Manipulated and visualized the data using SAP Lumira to find insights on bike sales in Germany and the U.S.

Business Analysis using R:

• Gathered real-time data for Southwest Airlines and created train and test data using it.
• Applied statistical concepts like linear regression, exhaustive search, and predictive analysis to draw insights on the fare of Southwest Airlines in RStudio resulting in accurate prediction of high fare in summers.

Sports Management Web Portal using Power BI

• Led a team of 3 to create a web portal for the government using a database of 116,957 students.
• Created visualization, animations and KPIs (Key Performance Indicators) using Power BI.
• Helped the government to handle the tournaments more efficiently, increasing participation by 15%.

Ultrasonic Piano using IOT

Led a team of 3 to create a prototype of Ultrasonic Piano using Raspberry Pie 3 (IOT), self-coded in Python which plays the musical octaves by detecting hand gestures, especially developed for the physically disabled.

ITM Program Mentor

I will be helping the current ITM Students and the incoming students regarding their queries for Information Technology Management Course. As a team,
• We work towards making the ITM program a step better than it was the previous day.
• We help students, prospective and current have a better and wholesome experience while hoping to pursue or pursuing masters in Information Technology and Mangement.