Operations Intern
• Took in charge of collecting backend traffic data for marketing department , consolidated data, graphics in Excel• Assisted in classifying data to support different departments for further review: Conducted PivotTable of 815 CEO live-broadcasting for Operations Department, downloaded VIP Fan information to figure out the data such as Fan Channel from January to July, Fan Contribution, seven-day guidance towards the transaction amount, content contribution ratio, and live broadcast contribution ratio• Checked account and verified, translated emails from Chinese into English for the manager