Data Analytics

• Mar 2023 - Present

Data Scientist (Intern)

• May 2022 - Aug 2022

• Designed full data pipeline, ML model, and framework optimized to find high-potential neighborhoods for investment o Modular & scalable build integrating several data sources (Google Maps APIs, Yelp API, BigQuery, etc.) with automated tuning per market (currently 4) and per stakeholder (4 teams) built using scikit-learn, Clustering, Regression, Time-Series & Spatial analysis (presentation available at mehika.upandup.co) o Facilitates expedited and successful investing in new real estate markets, and customer acquisition by providing optimal real estate options, with little-to-no local knowledge o Feature engineered location “diversity metric” for model using Kullback-Leibler divergence • Collaborated on building company global dashboard with construction team’s 6 identified key performance metrics o Reduced dashboard run costs & time by aiding transition to standard data modeling ETL practices using dbt • Built route optimization algorithm to cut property managers’ travel time between work sites Show less

Computer Science Intern

• Jan 2022 - May 2022

• Created data visualization tool for R&D team to facilitate efforts to develop PCR-quality at home COVID-19 tests • Developed tool saves researchers ~20 minutes per test, with additional time costs for team saved by removing technical hurdles of manual coding analysis, visualization, and technical malfunctions • Created data visualization tool for R&D team to facilitate efforts to develop PCR-quality at home COVID-19 tests • Developed tool saves researchers ~20 minutes per test, with additional time costs for team saved by removing technical hurdles of manual coding analysis, visualization, and technical malfunctions

Data Systems Architect

• Jun 2020 - Mar 2022

• Automated reporting infrastructure inside dashboard with features such as survey management, data analysis, and up-to-date report generation on client feedback and outcomes for 500+ clients (GCP APIs, cloud functions, JS, React) • Analyzed efficiency of business services, suggesting improvements on product deficiencies and new marketing decisions in client communities • Automated reporting infrastructure inside dashboard with features such as survey management, data analysis, and up-to-date report generation on client feedback and outcomes for 500+ clients (GCP APIs, cloud functions, JS, React) • Analyzed efficiency of business services, suggesting improvements on product deficiencies and new marketing decisions in client communities

Data Science Fellow

• Jul 2021 - Aug 2021

• Delivered data collection solution by identifying quantifiable key performance metrics for stakeholders in 8 weeks used for informed operational decision making • Developed web-based interactive data visualization using D3.js used for fundraising in local community • Designed and created web-based interactive data visualization to present urgent need for funding using D3.js • Delivered data collection solution by identifying quantifiable key performance metrics for stakeholders in 8 weeks used for informed operational decision making • Developed web-based interactive data visualization using D3.js used for fundraising in local community • Designed and created web-based interactive data visualization to present urgent need for funding using D3.js

Metis Data Science & Machine Learning Bootcamp

• Mar 2021 - Jun 2021

Metis is an intensive 14 week ACCET-accredited Data Science full time course focused on data wrangling, statistical modeling, supervised and unsupervised machine learning, deep learning, NLP, and data visualization. Project highlights include (GitHub: mehiks11): *Stargazing Recommender Web Application: Uses a data pipeline to pull suggestions about when and where to go stargazing. *Plant Neural Network Classifier: Leveraged power of neural networks to create an app the takes an image of a plant leaf and returns the type of plant! * Universal Healthcare NLP: Topic Modeling & Sentiment Analysis done on tweets discussing universal healthcare with the aim of identifying core subtopics related to discussions surrounding universal healthcare. * Predicting Flight Delays: Classification Models built to predict flight delays given flight information * Havenly Report: Initial Business Report conducted on local nonprofit restaurant sales data * NYC Covid Transit: Finding optimal times/stations for travel for at-risk transit riders * Music Hits: Predicting the peak of a song on Billboard 100 Show less

VITA Co-Director Of Operations; Site Coordinator; Volunteer

• Oct 2019 - May 2021

Establish and maintain new virtual platform for tax preparation volunteering. Manage operations and logistics of Yale University VITA Chapter. Maintain relations with Connecticut VITA chapters. File taxes for New Haven locals and oversee volunteer shifts.

Research Assistant

• Jan 2020 - Sep 2020

Conduct sociological data and analysis work on research focused on philanthropic actions taken by the conservative party since the 1970s to catalyze the growth of broader political and social movements. Run data and social network modeling analysis efforts on grant databases.

Research Assistant

• Aug 2019 - Dec 2019

Conduct liability waiver research for John Witt at the Yale Law School. Compile and sort liability waivers and other legal documents. Created navigable resource map on official project website. Conduct liability waiver research for John Witt at the Yale Law School. Compile and sort liability waivers and other legal documents. Created navigable resource map on official project website.