Data Analyst

Hongyuan (Alevia) Mao

213-***-**** *********@*****.*** Los Angeles, CA 90018

linkedin.com/in/hongyuan-mao

EDUCATION

University of Southern California Los Angeles, CA

MS, Applied Economics and Econometrics 08/2023 – 05/2025 l GPA: 3.96/4.0, Specialization: Data Science and Big Data Econometrics l Relevant coursework: Predictive Analytics (Viterbi School of Engineering) (Python), Big Data Econometrics (R), Time Series Analysis (R), Microeconomics, Macroeconomics, Econometrics, Market Design, International Trade Shanghai University of International Business and Economics Shanghai BS, Applied Statistics 10/2019 – 06/2023

l GPA: 3.44/4.0, GRE: Quantitative 170 (96%)

l Relevant coursework: SQL Database, Data Mining (R), Programming Fundamentals for Computing (Python), Project Management (SAS), Multivariate Analysis, Case Analysis of Big Data in Business, Market Survey l Honors: Graduate with Honors, Recipient of First-class Scholarship WORK EXPERIENCE

PwC, Management Consulting Intern 07/2022 – 12/2022 l Built and deployed SQL and R-based data models analyzing 50M+ records, identified 10+ key performance drivers, and delivered optimization plans that improved performance tracking accuracy by 20% l Developed 10+ interactive Tableau dashboards and 100+ presentation slides to communicate key insights on cost structure and revenue trends, supporting executive decisions that increased profitability by 12% l Performed organizational analysis and built financial models for a Fortune 500 client, leading to 3 strategic recommendations adopted by senior leadership; participated in 15+ C-suite level meetings l Reviewed 20+ policy documents to map business processes, identifying 5 key inefficiencies that shortened reporting cycles by 30% and reduced cross-team redundancies l Designed a comprehensive KPI system with 500+ metrics using SQL and applied PCA to reduce dimensionality, improving executive reporting precision by 15%

Prada Fashion Commerce, Finance Department Intern 09/2021 – 11/2021 l Collaborated with finance, sales, and operations teams to analyze 2 years of sales and expense data, contributing to corporate forecasting and supporting 2 quarterly planning cycles l Processed and reconciled 200+ financial transactions with 100% SOP compliance, improving accuracy by 15% and reducing reconciliation time by 20% through Excel automation RESEARCH PROJECTS

The Effect of the Gender Wage Gap on Higher Education Attainment 03/2025 – 05/2025 l Preprocessed 2M+ rows of census data in SQL and created Tableau visualizations that revealed regional disparities in higher education attainment

l Implemented Random Forest and Debiased Lasso in R to analyze the impact of the gender wage gap on education decisions, achieving 0.8 R-squared and identifying the top 4 contributing variables l Delivered a 25-slide presentation and summary brief to a 40-person academic audience, translating predictive model results into clear insights to support data-driven discussion Investigation Report on Soon-to-expire Food 10/2021 – 04/2022 l Designed questionnaires and conducted fieldwork, collecting 1000+ valid responses from consumers and grocery stores; cleaned and processed data using SQL to support consumer behavior modeling l Developed 4 customer segments via K-means clustering and presented findings through Tableau dashboards, guiding promotional strategies for reducing food waste TECHNICAL SKILLS

Programming: R, Python, SQL, SAS, Tableau, Microsoft Office (Excel, Word, PowerPoint), Power BI, Stata, SPSS Analysis Skills: A/B Testing, Machine Learning, Causal Inference Soft Skills: Communication, Interpersonal Skills, Project Management, Leadership, Team Player, Collaboration

Contact this candidate