Data Analyst Beijing

Ran (Summer) Peng

206-***-**** *******@*****.*** https://www.linkedin.com/in/rpeng52/ Seattle, WA EDUCATION

Washington University in St. Louis St. Louis, MO

Master of Business Analytics: GPA 3.7/4.0 Expected May 2022 Coursework: Machine Learning, A/B Testing, Data Visualization, Customer Analytics, Marketing Strategy University of Massachusetts at Amherst Amherst, MA Bachelor of Economics: GPA 3.6/4.0 Aug 2015 - May 2019 Coursework: Statistics, Game Theory, Calculus, Algebra, Micro & Macro-economics PROFESSIONAL EXPERIENCE

International Alliance Associates Jul 2021 - Aug 2021 Data Analyst Intern NYC, New York

• Predicted real estate trend with feature extraction based on linear regression and Python.

• Filtered and cleaned real estate data by Python and MapReduce to reduce the number of the independent variables from 26 to 15 due to high collinearity.

• Improved the linear regression model based on Root Mean Squared Error.

• Analyzed return rate of mattress products over time with SQL and R proposed insights and hypotheses on increasing return rates.

Deloitte, Audit & Assurance Department May 2021 - Jun 2021 Data Analyst Intern Beijing, China

• Developed Monetary-unit sampling (MUS) sampling methodology in SQL and Hive, enabling preliminary review process to handle big volume of data in a scalable way.

• Conducted data exploration analysis leveraging confidence interval calculation in R for risk assessment.

• Identified abnormal data points in SQL regularly, allowing auditing processes with clients more effectively. TikTok Oct 2020 - Jan 2021

Marketing Analyst Intern Beijing, China

• Organized, rehearsed, and held the Engine Conference 2021Shanghai with marketing and engineer teams.

• Retrieved participants’ data by API call and SQL automatically for conference DAU report.

• Analyzed the data flow and system architecture, merged 3764 participant’s data from backend server and third-party server by Excel and Hive, preprocessed, and profiled participants and based on converged data.

• Extracted core features of participants that affected DAU of the conference with the data set using A/B Test.

• Generated reports and recommendations for the marketing team, tuning participation rate from 50% to 80%. Intel Corporation May 2020 - Oct 2020

Marketing Intern Beijing, China

• Retrieved and collected dynamic sales records from backend server and quarterly revenue report meeting.

• Preprocessed 13620 sales records, visualized data for marketing strategy decision by Tableau.

• Supported projects extending marketing occupation, monitored and shared projects progress cross-team.

• Collected collaboration records, improving cross-team collaboration efficiency by 27%. Coca-Cola May 2019 - Sep 2019

Marketing Intern Beijing, China

• Collected and organized beverage market records, such as seasonal reports and monthly sales records.

• Supported marketing team improving product reputation and marketing occupation from 65% to 78%.

• Analyzed data collected from monitoring market reaction to proposed dynamic advertising strategy. TECHNICAL SKILLS & TOOLS

Language & Skills: SQL, Python, R, A/B Test, Data Modeling, Map Reduce, Hive Data Modeling, Pandas, NumPy, scikit-learn, Hadoop Techniques & Tools: Tableau, NumberAnalytics, RStudio, Jupyter Notebook, Excel, MySQL workbench, PowerPoint, Word

Contact this candidate