Open to opportunities

Yiyi Sun

@yiyisun

Message

Data Analyst Intern with expertise in data visualization and analysis.

United States

Message

What I'm looking for

I am looking for a role that fosters growth, encourages innovation, and values data-driven decision-making.

I am a dedicated Data Analyst Intern with over a year of experience in designing impactful dashboards and conducting thorough data analysis. My academic background includes a Master of Science in Applied Data Science from the University of Chicago, where I achieved a perfect GPA of 4.0. I have honed my skills in Python, SQL, and data visualization tools like Tableau and Power BI, which I have effectively utilized in various internships to drive business insights and enhance decision-making processes.

During my time at McDonald's, I developed a recommendation system that significantly boosted user engagement and sales by 50%. My experience at TikTok involved creating ETL pipelines that reduced data processing latency by 40% and building dashboards that improved advertising performance metrics. I am passionate about leveraging data to solve complex business challenges and am committed to continuous learning and improvement in the field of data science.

Experience

Work history, roles, and key accomplishments

Strategic Data Analyst Intern

Tiktok

May 2024 - Jun 2024 (1 month)

Developed ETL pipelines in Python, reducing data processing latency by 40%. Conducted A/B testing for advertising performance across 150+ campaigns, achieving a 12% cost reduction. Built Power BI dashboards for real-time tracking of campaign performance.

Python ETL A B Testing Power BI Data Visualization

Business Analytics Intern

The Ohio State University - Office of Financial Services

Jan 2023 - Jan 2024 (1 year)

Designed Tableau dashboards to track bond yield changes and improved data accuracy by 25% using SQL and Excel. Streamlined reconciliation processes and investigated variances in portfolio returns, enhancing financial model reliability.

Tableau SQL Excel Data Analysis Financial Modeling

Data Analyst Intern

Schindler Elevator

Jan 2024 - Dec 2023 (-1 years 11 months)

Conducted KPI analysis for branch offices using Python and developed automated data-processing models in Excel VBA, reducing processing time by 50%. Created Power BI dashboards to visualize installation performance data for decision-making.

Python VBA KPI Analysis Power BI Data Processing

UChicago Student Data Analyst

McDonald's

Oct 2023 - Oct 2023 (0 months)

Developed a recommendation system for the McDonald's app, boosting user engagement and sales by 50%. Analyzed large-scale data in AWS S3 and projected a 15% revenue increase through a new recommendation system. Built Tableau dashboards to analyze system performance across regions.

AWS S3 Tableau K Nearest Neighbors Data Analysis

Education

Degrees, certifications, and relevant coursework

University of Chicago

Master of Science, Applied Data Science

2024 - 2025

Grade: 4.0

Pursuing a Master of Science in Applied Data Science, focusing on advanced data analysis techniques and tools. Courses include Python in Data Science, Big Data & Cloud Computing, Machine Learning, and Data Structures.

The Ohio State University

Bachelor of Science, Quantitative Economics

2019 - 2023

Grade: 4.0

Completed a Bachelor of Science in Quantitative Economics, emphasizing data analytics and management. Courses included Data Analytics I & II and Data Management in SQL.