Shuyun Zhang: in Sunnyvale, CA
Shuyun Zhang
Sunnyvale | United States
Skills
No information
Interests
No information
Industries
No information
Summary
No information
Activity
Projects
No information
Work experience
Smith Master Student Association, UMD Smith School of Business
Ambassador and Vice President of External Relations | 09/2018 - 12/2019
? Planned and Managed 20 events for 1k+ master students at a budget of $80,000 with 6 other board members.
? Led a team of 6 first year ambassadors to organize field trips and workshops.
? Supported master program office to keep and develop alumni relations by organizing webinars.
AARP
Marketing Services and Analysis Intern | 06/2019 - 08/2019
? Imported employer pledger data and 200k prospect employee scores from raw Excel to Tableau, merged them in Tableau and visualized as a dual-axis heatmap at zipcode granularity, helping the internal client examine current and potential employer singers of AARP non-discrimination pledge.
? Created and analyzed webinar registrant profiles based on audience segmentation by topics using statistical indices in Excel, and made recommendations for future marketing campaign design and targeting for clients.
? Automated the dashboard of marketing campaign results and model performance using Unica and Vlookup. The team no longer need to manually log in 1k+ data points, saving 80% of their monthly reporting time.
Pentair Water Purification Company
Marketing Intern | 06/2018 - 08/2018
? Planned the content and managed the official social media account (WeChat), resulting in a 3x increase in total numbers of promotion articles and 2x increase in numbers of reading of each article.
? Analyzed customer data and WeChat follower data using Excel and gained insights of potential improvement of the account to increase brand awareness, e.g. the most effective contents for promotion articles.
? Managed official website by writing articles; examined wording of advertising to avoid legal issues successfully.
Education history
University of Maryland, Robert H. Smith School of Business
Master of Science | 2018 - 2019
University of Shanghai for Science and Technology, Sino-British College
Bachelor of Management | 2014 - 2018
University of Sheffield, Management School
Bachelor of Arts | 2016 - 2018
Connections
Companies (0)
No information