Parag Khandelwal

Business Intelligence Intern

Eileen Fisher•  June 2024 - August 2024•  Irvington, New York

Leveraged ETL processes to extract, transform, and load data from multiple sources into Snowflake, increasing product availability by over 300 units through sales and inventory analysis using SQL. Optimized SQL queries to reduce data retrieval time from 12 minutes to 9 minutes and automated data pulls in Python, cutting manual processing time from 5 hours to 1 hour. Built a demand prediction model in Python using XGBoost, reducing excess stock by 2,000 units, and developed Power BI dashboards, saving over 10 hours monthly while identifying underperforming products. Conducted market research with Google Analytics and Python, driving engagement with an additional 1,000 customers, and presented actionable insights to senior management, aligning inventory strategies with customer demand.

Data Analyst

Technimates Services•  August 2021 - July 2023•  Mumbai, India

Collected and analyzed insurance claims data from multiple sources to ensure comprehensive datasets, improving claims accuracy by 15% and reducing fraudulent claims by 8% through SQL and Python analysis. Identified over 200 fraudulent cases monthly using feature selection machine learning techniques and developed predictive models with Random Forest, saving over $50,000 annually in fraud mitigation costs. Designed interactive Tableau dashboards, streamlining decision-making processes and saving over 300 hours annually.

Data Analyst Intern

Medstry•  January 2021 - June 2021•  Mumbai, India

Contributed to Medstry's initiatives to connect brands with customers in rural areas. Analyzed demographic data to optimize marketing campaigns, resulting in a 20% performance increase. Developed data models for targeted marketing, reaching 5,000+ additional rural customers.

University of Massachusetts at Dartmouth

Data Science, MS•  September 2023 - Present•  GPA: 3.8

Pursuing M.S. in Data Science at the University of Massachusetts Dartmouth, expected completion in December 2024. Coursework includes Machine Learning, Database Design, Statistics, Data Mining, and Numerical Linear Algebra, with a focus on developing expertise in data-driven problem-solving and advanced analytical techniques.

NMIMS University

Mechanical Engineering, B.Tech•  July 2016 - July 2021

Completed B.Tech in Mechanical Engineering from NMIMS University, graduated in July 2021, with a strong foundation in engineering principles and problem-solving techniques.