RESUME

Fidelity Investments, Boston, MA

Data Analyst Intern

May 2023 - August 2023​

• Performed collection and meticulous cleansing of over 1,000 time series financial data points for various cryptocurrencies using SQL and SPARQL. Utilized Python to calculate a robust correlation matrix, aiding in the understanding of crypto price fluctuations

• Conducted exploratory data analysis on cryptocurrency pricing data to identify market patterns and trends. Built and tested Prophet & Linear Regression models, achieving an R-squared value over 90%, to produce accurate and reliable short-term price trend forecasts

• Constructed a comprehensive data pipeline and an automated, interactive Semantic Web dashboard

​

​

CTR Market Research Co., Ltd, Beijing, China

Data Analyst Intern

October 2021 - January 2022

​

• Created project evaluation and data analysis for 5+ Chinese media company made by using Excel pivot tables, chart organization, and data management to assess the effectiveness of their marketing strategies

• Utilized SQL queries on 10+ Chinese electronic car brand to valuate diverse attributes of product listings to discern patterns, enabling the identification of value deals and price benchmarks for potential purchasers 

• Analyzed and presented the business models of the 2022 Beijing Olympic Winter Games, highlighting strategies that led to a 20% increase in audience ratings

​

​

PRLab, Boston, MA

Account Executive

January 2021 - May 2021

 

• Developed corporate news and popular science columns on its official website as well as Twitter and LinkedIn page, and achieved an increase in general traffic by 150% and fan traffic by 200%

• Designed and edited videos for Architectural Health's YouTube channel, increasing the audience by 200%

​

​

Gaosheng Wealth, Beijing, China

Marketing Intern

May 2020 - August 2020

​

• Tracked the competitors' WeChat Official Account for two months and analyzed traffics with statistical methods such as sample means, sample proportion, and T-test

• Interpreted the statistical result to conclude what were the positive feedback from clients and the general audience, and advised the company to produce similar content on social media

• Presented the project in the form of speech in front of the marketing department

 

 

The Hoffman Agency, Beijing, China

Human Resources Intern

​June 2018 - August 2018

​

• Tracked the industry news and updates on social media of the customers' competitors, and collected the daily data to finish the reports

• Wrote articles and blogs on the customers' social media accounts such as WeChat, Sohu, NetEase, Baidu, and made the weekly update

• Translated customers' email and corporation articles from Chinese into English, and vice versa