Xiaoyi Deng Email & Phone Number

Plano, Texas, Us

• Developed SQL scripts to streamline the batch ETL process for daily processing of 4M+ electricity usage records, improving data cleanliness for analysis• Implemented electricity usage fraud detection using rule-based criteria and linear regression model, identifying abnormal patterns• Defined key metrics and established thresholds to quantify abnormal usage, improving the false negative rate in detection• Collaborated with cross-functional teams to build a Tableau dashboard for monitoring electricity usage per account, preventing a 5% predicted revenue loss through fraud detection

• Developed a scoring and ranking system to evaluate top snack and beverage products using 20+ features, including sales, price, brand, and localization, across 2M+ SKUs in Python• Conducted surveys, focus groups, and user persona analyses for audience selection and promotion strategies, achieving over 1 million impressions during semi-annual sales• Performed clustering analysis using K-means to segment seven cohort groups, creating pricing strategies based on price sensitivity and demographics to optimize revenue• Built a Tableau dashboard to track and analyze campaign performance, including CTR, CVR, and CPM, and conducted attribution analysis to assess the effectiveness of each channel

Shanghai, Cn

• Analyzed and cleaned 100+ attributes of 9M+ Alibaba consumers with billions of transaction records using SQL• Collaborated with clients to define five key metrics of the consumer lifecycle using the AARRR framework• Performed market basket analysis to understand product associations, providing product recommendations to clients• Analyzed industry trends and growth rates across product categories, identifying profitable opportunities and suggesting product selections and promotions to clients• Conducted persona analysis with clients, understanding target customers’ age, browsing behavior, and preferences, resulting in a 4.3% increase in sales through co-branding and creative design suggestions

Bachelor'S Degree, Statistics

Bachelor'S Degree, Clinical Psychology