MK

Mohit Khanna

Data Science Intern · Voya Financial

Hartford, CT

In My Own Words

• A driven problem solver with an ability to work in a new, fast-paced business environment
• Strong organizational skills with the ability to understand, articulate and address business issues, business drivers, and needs
• Ability to articulately present analysis results and drive recommendations with cross-functional teams s

Work Experience

Data Science Intern

Voya Financial

2022 – Present

• Connected Snowflake DB to Tableau; Built and automated quarterly messaging impact dashboards on Tableau; Reported metrics like click rate and action rate using Calculated fields, LOD expression etc. • Constructed ETL jobs using Azure Data Factory by storing data in Blob; Cleaned, filtered & organized data using Python in Azure Databricks and loaded tables onto Snowflake Database for easy access and reporting

Data Science & Analytics Intern

Fitmatch.ai

2022 – 2022

- Fort Lauderdale, FL B2B technology platform that enables apparel brands to match their customers with the best-fitting products. • Build optimized data models to support dashboard requirements, perform data validation, and analyze the performance and health of KPI reporting dashboards. • Automated existing analytics dashboards using SQL queries by connecting Google Sheets and Redash reports to AWS Athena Database. • Executed daily, weekly, and ad-hoc data requests by querying, cleaning, aggregating, analyzing, and visualizing data using Athena SQL(Presto) & Redash. • Navigated, understood, and leveraged existing complex data infrastructure for analysis & reporting; Wrote Python scripts to pull large volumes of data from AWS S3. • Analyzed KPIs like wrong rate, rescan, no. of scans, daily registration, match time, etc. for the Fitmatch platform to monitor customer adoption and drive AI product performance • Key Achievements: Independently executed automation of 5+ dashboards that saved over 2 hours of daily manual effort; Reported insights to operations and AI & Data Science teams that lead to a reduction in monthly wrong rate by 3% and improved the customer scan rate by 6%

Project Member (Graduate Student)

The University of Connecticut

2022 – 2022

(MS Business Analytics & Project Management) EV Charging Station Prediction (Mar 2022-Apr 2022) • Solved classification and regression problems by building 6 Machine Learning models to predict the number of EV charging in each of the ZIP codes in the USA • Enriched training data by merging 5 additional datasets into the master dataset • Implemented a baseline kitchen sink linear regression model; added more complex models and performed hyperparameter tuning to improve accuracy by 6% • Created permutation feature importance and partial dependence plots to identify the top features that drive the presence of EV charging stations • Key Achievements: Built an Elastic Net regression model with an R2 of 83.4% and a random forest classifier with an accuracy of 88%

Analytics Consultant (Senior Data Analyst)

Redseer Management Consulting Pvt. Ltd. (Partners with OC&C Consulting)

2020 – 2021

Technology-focused management consulting firm specializing in strategy and growth consulting for technology corporates and private equity investors. • Leveraged large, complex datasets to develop real-time analyses and drive measurable business impact • Collaborated with business and technology stakeholders to translate business requirements to KPIs, and dashboards that drove business goals. • Partnered with client marketing & product teams to monitor effectiveness of personalized messaging campaigns 3 channels (Email, app & Pweb) using A/B testing • Wrote production level SQL and Python scripts to build, monitor & maintain ETL processes to extract relevant category and operations metrics that supported 10+ BI deliverables • Analyze sales data using EDA techniques in MySQL and communicate findings to business stakeholders via Tableau dashboards • Supervised team of 4 Junior Data Analysts, overseeing data analysis and insight generation; successfully ran and converted the pilot project generating an additional $100K revenue • Key Achievements: Leveraged data of 20,000+ SKUs across 20+ categories; resulted in an overall reduction in order return volume by 8%

Project Member

Pro Bono Consulting

2020 – 2020

• Enhanced marketing bids by analyzing traffic source conversion rates; Understood how bids can be optimized more efficiently for both paid and unpaid traffic. and improved the client's marketing RoI by 10%. • Enhanced client's landing pages by performing conversion funnel tests across category and product pages. • Key Achievements: improved client's marketing ROI by 10%.; Reduced average bounce rate by over 10% potentially increasing the client's revenue by 25%.

Links: • Linkedin • BI Portfolio

Education

MS Business

University of Connecticut

2022

MS Business