Jan 2024 - April 2024

Business Analysis Intern

• Gathered and cleaned the raw dataset (100k+ cases) using Excel and Python, conducted EDA to define project scope, conducted cost analysis on redundant inspections, exposing limitations in the current algorithm for identifying at-risk properties. • Developed and maintained SCD2 tables, constructed dashboards to visualize data distribution relative to predefined thresholds. • Employed data binning, categorical variable encoding, and feature engineering to pinpoint the top ten most influential variables. • Implemented machine learning tools including logistic regression, XGBoost and random forest to forecast house condition, optimized current algorithms by reducing 80% of redundant inspection cases, predicted to save about $421k per year.

June 2022 – May 2023

Customer Profile Analyst

• Collected, cleaned, and managed company's customer database to look for patterns and arranged customers into different categories, processed 10k+ customer records. • Utilized Python to create a customer sorting automation function auto-generates weekly customer distribution for sales team, tracked and presented findings to sales team and shareholders, facilitating strategic modifications to sales approaches and market exploration. • Strategized customized media content and promotional materials based on customers' age groups, IP addresses, and product preferences, which contributed to reaching a broader audience, resulting in an increase of 30k+ reviews.