Data Analyst

• Jun 2022 - Present

Data Analyst Intern

• Apr 2021 - Jul 2021

• Analyzed the advertising, negative news, publicity effects and consumer characteristics of Dyson and its competing companies in various types of media by SQL and Tableau, then completed Dyson’s monthly report alone. • Investigated and analyzed the industry background of the security industry and commercial real estate industry. • Participated in the completion of the public relation analysis report of EZVIZ and Swire Group, mainly focusing on advertising on popular social media platforms, the demands of customers and the real time monitoring the negative news. Show less

Data Research Analyst Intern

• Jul 2020 - Sep 2020

• Analyzed US stock price fluctuation in last 10 days and built Gaussian Naive Bayes model in Python/Quantopian to predict future forward return with 53% accuracy in back testing. • Designed and implemented a ticker match machine using regular expression and Jinjia2 for various financial products to pair with the corresponding price model. • Estimated the hypothetical interest swap price using QuantLib-Python. • Analyzed US stock price fluctuation in last 10 days and built Gaussian Naive Bayes model in Python/Quantopian to predict future forward return with 53% accuracy in back testing. • Designed and implemented a ticker match machine using regular expression and Jinjia2 for various financial products to pair with the corresponding price model. • Estimated the hypothetical interest swap price using QuantLib-Python.

Business Analyst Intern

• Jun 2019 - Aug 2019

• Compiled statistics on the overall development of the Chinese pork market over the past five years using Python; mainly studied the decline in supply due to African swine fever in 2018. • Investigated the cost of free-range domestic pig farming in China by Excel. • Gathered and visualized statistics of pork import tariffs, logistics and storage costs using Python (Seaborn) and SQL Server. • Made a story on the income of Muyuan Foods (SZ 002714) over the past five years by Power BI to support the analysis of the company's A shares. Show less

Market Analyst Intern

• Jul 2018 - Aug 2018

• Investigated the development of 20 real estate projects around Shanghai over the past five years using Excel and Minitab. • Compiled statistics on several representative real estate projects around Shanghai with high profits, good sales and fast return of funds using R (Tidyverse and ggplot2). • Measured and evaluated customer and employee satisfaction to identify areas in need of improvement. • Investigated the development of 20 real estate projects around Shanghai over the past five years using Excel and Minitab. • Compiled statistics on several representative real estate projects around Shanghai with high profits, good sales and fast return of funds using R (Tidyverse and ggplot2). • Measured and evaluated customer and employee satisfaction to identify areas in need of improvement.