Summer Internship Office Data

Yitong (Serena) Qian

812-***-**** ***********@*****.*** 2133 Norwood St, Los Angeles, CA 90007 linkedin.com/in/yitong-qian-a8896123b Seek 2023 Summer Internship

EDUCATION

University of Southern California Los Angeles, CA

Master of Science in Communication Data Science August 2022-May 2024 GPA: 4.0/4.0

Relevant Coursework: SQL for Data Science, Principles of Programming for Data Science, Python for Data Science and Machine Learning Bootcamp, Machine Learning, Foundations of Data Management Boston University Boston, MA

College of Communication January 2021

Bachelor of Science in Film and Television

Minor: Business Administration

Honors: Dean’s List, Cum Laude Latin Honor

SKILLS

Technical: SQL, Python, R, Pandas, Tableau, A/B Test, Natural Language Processing, Microsoft Office, AWS, Spark, Hadoop

Languages: English (Fluent), Chinese (Fluent), Cantonese (Conversational) EXPERIENCE

T&B Media Global Beijing, China

Product Analyst (Full-time) June 2021-May 2022

Led virtual human influencer product by collecting market data by Python, building up a demand list and production plan, and establishing team with technicians and artists which led to final product launch and 300,000 US dollars investment.

Researched Chinese and international television and film market, reviewed over 3000+ international box office data, applied data cleaning, normalized data, built prediction models for entertainment market trending, designed data visualization, and facilitated company to finance film and television projects.

Produced a 45s trailer for animation series, “Millennium Fables” led to 5.4 million in US dollars investment from Tencent Pictures.

Television Show Heart Signal 4 Shenzhen, China

Business Intern March 2021-May 2021

Retrieved data from SQL, examined data about domestic reality show market, ratings, views amount, and audience’s preference, clarified product positioning, and improved content quality by 25%.

Executed integrated social media marketing plans on multiple platforms, such as Tiktok, Weibo, YouTube, leading to over 100 million views for one episode, increased 1.5 times compared with last season.

Managed communication with clients and sponsors, provided backup production plans, and solved any emergencies on set. ACADEMIC PROJECTS

Gender Statistics Project Fall 2022

Conducted gender statistics data project for DSCI549 Intro to Data Science, data mining and data cleaning for data set, detect correlation with gender inequality, and apply Python, pandas, and statistical analysis, such as independent t-test, ANOVA, and time series analysis.

USC Data Fest 2022 Fall 2022

Benchmarked sentiments detection tools by observing their classifications accuracy on same data set, compared lexicon-based approaches on emotion-annotated large-scale data set, and processed natural language models.

Processed 20,000+ twitters by applying Vader emotion analysis model and implemented 5 statistical analysis tools to analyze large dataset, such as linear regression and coefficient analysis. LEADERSHIP AND INVOLVEMENT

BU After School Student Organization Boston, MA

Founder and Administrator October 2019-January 2021

Initiated organization establishing plan, managed content and publication team, collected back-office data, deployed linear regression model to access main factors of fan growth, and combined data with current content planning to further promote fans growth, resulting an increase of 5,000 followers within 1.5 years.

Contact this candidate