Shanghai, China
- Wrote queries to extract and integrate data from Nielsen databases and built datasets to solve clients’ business questions - Created periodical reports using data visualization, analyzed KPIs, and crosschecked to ensure accurate and proper data interpretation - Automated manual process of creating reports in Excel, saving 30% of working time compared to the previous method on each report - Compiled the Nielsen pitch deck using PowerPoint and assisted in preparing a pitch presentation to a local auto company, BYD Automobile
- Collected weekly and monthly Lipton beverage sales data from distributor partners and prepared sales report and forecasts for the next period - Created purchase orders and supported the payment processing team to ensure all payments were clear and on time - Communicated across departments to respond to vendors in time - Organized files and documents and ensured internal control
• Opened up overseas market of international students and expanded the scope of recruitment. • Translated official website of Global Higher Education(GHE) Master’s Degree Program into Chinese. • Reached out potential partner universities in China, including Peking University, Beijing Normal University, Beijing Institute of Technology, and Beijing University of Technology. • Enhance the influence and popularity of Global Higher Education Master’s Program and UW-Madison in Universities in China.
• Lead a team in event planning, including inviting speakers and reserving room. • Advertised events by distributing posters and noticing on social media. • Attended weekly group meeting and lead post-event reviewing. • Communicated with other student organization and maintain contacts with Professors of UW-Madison.
• Took orders and served customer quickly during busy meal time. • Provided friendly customer service and exercised interpersonal communication skills while meeting needs of 50+ customers daily.