• Summarized monthly cases and drafted reports for main brands of Pernod Ricard China and their competitors regarding their social performance on key social platforms including WeChat, Weibo, Red and Douyin by analyzing social data trends and peak points • Drafted 2 market research reports for Danone concerning Infant Formula for Special Medical Purposes and Follow-on Formula by analyzing and visualizing yearly social data of key brands and their competitors• Kept track of and evaluated celebrity campaigns of HUGO BOSS during 2Q2024 by analyzing user comments under key BGC and PGC posts• Produced High-Net-Worth Individual (HNWI) monthly reports for Pernod Ricard China by analyzing text of users on main social platforms including Weibo and Red

• Cooperated with management consulting team from KPMG to introduce a new SaaS service to the department by analyzing vendor data including contact information, pricing and payment terms• Maintained and analyzed vendor spending data using Excel to decide whether to keep certain vendors on the new SaaS system based on past spending trends; resulting in continued partnership with key vendors• Conducted daily vendor management procedures through email to validate new vendors and to ensure the quality of current vendors resulting in 100+ new vendor accounts

• Drafted audit working papers for China Universal Asset Management (CUAM) allowing senior management to conduct the interim auditing procedures• Conducted on-site capital verification at various banks to verify the authenticity and accuracy of assets for specific funds• Analyzed the financial data of 3 subsidiaries of CUAM and summarized key insights to describe mid-year changes in in the interim report's notes

• Formulated audit working papers for Shui On Holdings Ltd.'s inventories to conduct interim auditing procedures allowing to verify existence and accuracy of inventories• Led a team of 6 interns to extract data from Shui On Holdings Ltd.’s rent rolls in order to analyze yearly trends of rental fees records

Counter | Transaction Support