Data Analytics & AI Product Analyst
Resume:
Fan Yang
***********@*****.*** (***) *** - ****
EDUCATION
Carnegie Mellon University Pittsburgh, PA
Master of Artificial Intelligence System Management GPA: 4.0/4.0 Aug 2025 - Aug 2026
● Awards: MSAISM, Heinz College Strategic Partner Scholarship Fall 2025
● Courses: ML for Problem Solving, NLP, Deep Learning, AI Model Development, Into to Artificial Intelligence University of California, Santa Barbara Santa Barbara, CA Bachelor of Science in in Statistics and Data Science GPA: 3.6/4.0 Sep 2021 - Dec 2024
● Awards: Dean’s List Spring 2022, Winter 2023, Spring 2024
● Courses: Regression Analysis, Machine Learning, Design of Experiment, Time Series, Probability and Statistic PROFESSIONAL EXPERIENCE
Firstrade July 2025 - Aug 2025
Data Analyst & Product Intern Shenzhen, China
● Collected and analyzed over 300k+ quote and trade data on Wind, integrating YTM, trade time, and quantity data to identify top-performing traders and strategies.
● Extracted, cleaned, and aggregated influencer performance data using SQL; Performed quality checks to identify anomalies, null values, and duplicates; Utilized advanced SQL window functions to calculate business KPIs.
● Built interactive Tableau dashboards to visualize performance trends, enabling cross-team access to real-time KPIs and improving reporting efficiency by 40%.
● Use Python to write an automated program to determine whether the Bid-Ofr quotation has reached the boundary, and conduct joint quotation decision analysis.
BT-Miners Feb 2025 – Apr 2025
SEO & Data Analytics Consultant Shenzhen, China
● Leveraged SEMrush, Ahrefs, and Google Search Console to extract keyword trends, search volume, and Google ranking metrics for high-intent queries related to the business.
● Built automated Python scripts to monitor index status, detect broken links, and flag toxic backlinks for disavowal, enhancing website health and crawlability.
● Designed and implemented A/B testing strategies for metadata, product descriptions, and ad formats —achieved a 120% increase in organic search ranking, resulting in a 15% increase in page views per day.
● Created interactive Tableau dashboards to visualize traffic trends, user behavior, and campaign ROI, enabling executive stakeholders to make data-informed marketing decisions. CreatoRev Jan 2024 - June 2024
Data Analyst Intern Santa Barbara, CA
● Collected and analyzed over 1000+ influencers’ performance data on Tiktok, integrating viewership, click-throughs, and sales data to identify top-performing content types and delivery times.
● Extracted, cleaned, and aggregated influencer performance data using SQL; Performed quality checks to identify anomalies, null values, and duplicates; Utilized advanced SQL window functions to calculate business KPIs.
● Delivered weekly insights aligning influencer performance and audience data, improving client-influencer matching. PROJECTS
E-commerce Customer Segmentation with RFM and K-Means
● Utilized SQL for robust data extraction and processing; engineered RFM (Recency, Frequency, Monetary) features to evaluate individual customer value and behavior.
● Conducted exploratory data analysis (EDA) using Matplotlib and Seaborn, identifying behavioral patterns, outliers, and key customer segments.
● Applied K-Means clustering on RFM scores in Python, validating clusters using inertia, silhouette score, Dunn index, and Davies-Bouldin index to ensure segmentation quality.
● Segmented customers into actionable groups such as 'VIP', 'Frequent Shoppers', and 'At Risk', enabling targeted marketing interventions.
Comprehensive Data Analysis of Yelp Dataset
● Integrated and structured data from six diverse sources into a scalable MySQL database, enabling seamless analysis of 1.32M users, reviews, and business data.
● Designed and developed root cause reports, decomposed into three dimensions to identify underlying issues affecting elite user retention, empowering businesses to optimize strategies effectively, catering to elite user needs. SKILLS
● Programming: SQL, Python (Pandas, Scikit-Learn, Numpy, Matplotlib, Seaborn, PyTorch), R, SAS, Matlab
● Analytics Technique: Machine Learning (Random Forest, XGBoost, KNN, Logistic Regression), A/B testing, NLP, Time Series Analysis, Database Management, Data Visualization (Tableau)
Contact this candidate