Detail-oriented data analyst with a strong background in branding and marketing.
I have a great interest in the health industry.
Location
Los Angeles, CA
Shanghai, People's Republic of China
Education
U
University of Southern California
August 2021 - December 2023
degree
Master's
major
Data Science
S
Shanghai Jiao Tong University
September 2016 - June 2020
Work Experience
K
Keck Medicine of USC
Communication assistant
Los Angeles, CA, United States, 91671
March 2022 - present
company
Keck Medicine of USC
title
Communication assistant
overview
• Pull positive cases from PnC system and clean data with Excel to generate daily Covid Notification Letters for the faculty, employees, and students
• Generate monthly social media KPI reports with Google Sheets
• Analyze five major competitors to create social media analysis and condense potential content topics
• Analyze the social media performance of USC Student Health with SPSS, present the results with Tableau, and conclude strategies to increase exposure, impression, and engagement
• Draft and edit monthly messaging Letters to help international families keep up with current events and new resources
• Update and manage websites using WordPress and Google Sites, including designing layouts and optimizing website performance
U
USC Annenberg Media
Web Producer
Los Angeles, CA, United States, 91671
September 2021 - December 2021
S
Storymaker GmbH
Full-time Account Executive
Shanghai, People's Republic of China
May 2020 - May 2021
C
Cohn & Wolfe
Account Coordinator Intern
Shanghai, People's Republic of China
June 2018 - December 2018
Skills
Languages
Chinese
Technical skills
htmlpythonsql
Skills
Digital MarketingEvent PlanningInDesignMarketing StrategyMedia RelationsMicrosoft Office, Writing, Communication skillsPivot TablesPowerBI TrainedPress ReleasesResearchSEMSocial MediaSPSSTableauVlookup