1. Utilized MySQL, Python, Tableau to extract, load, clean, visualize and analyze the traffic data and the lead generation data of Mansion Global’s websites2. Implemented machine learning model SVM/NLP to identify the sources of traffic and the causes of lead generation3. Proposed potential improvements and business development strategies for the expansion of Mansion Global in China to efficiently control the budget; helped increase potential lead generation by 30%

1. Utilized SQL, Python to clean and store the historical A-share returns for all Chinese stocks from Chinese Capital Market (CCM) Database, to support the investment group’s trading decision2. Constructed the Fama and French three-factor model to test performance to apply such a model to Chinese A-shares market; constructed a zero-cost portfolio with statistically significant return per month3. Used BeautifulSoup in Python to mine and clean data through URLs; performed dimension… Show more 1. Utilized SQL, Python to clean and store the historical A-share returns for all Chinese stocks from Chinese Capital Market (CCM) Database, to support the investment group’s trading decision2. Constructed the Fama and French three-factor model to test performance to apply such a model to Chinese A-shares market; constructed a zero-cost portfolio with statistically significant return per month3. Used BeautifulSoup in Python to mine and clean data through URLs; performed dimension reduction using PCA for model validation Show less

1. Analyzed the investment project of Innovative World Technology Co., Ltd.; provided insights and advice on how to process the project2. Responsible for due diligence and provided an investment proposal3. Collected and processed the information data from the Chinese Lottery Industry, the Internet Industry, the target companies and comparable companies; assisted the analyst to write reports

1. Products Pricing: supported the work of pricing auto insurance products and employee’s insurance products, data analysis and filing; priced an internship insurance for vocational college students through adjusting the risk premium and loss ratio2. Business Data Analysis: responsible for sorting and analyzing business data of insurance products and using programming to perform pre-processing and diagnosis of different data sources