Shuyun Zhang: in Sunnyvale, CA

? 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.

? 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.

? 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.