Experience

• 

  YepHome.com.au

  • Melbourne, Victoria, Australia

  • Product Intern

    • Jan 2022 - Apr 2022
    • Melbourne, Victoria, Australia

    1. Gathered nearly 800 keyword data from Ahrefs every week, use tableau to produce data visualization reports, and assist the digital marketing department in keyword optimization. 2. Track daily traffic through Google Analytics, analyze user behavior, judge the advantages and disadvantages of different traffic sources, and make optimization suggestions for the website.3. Use python to clean the rental data of almost 10,000 in Melbourne and calculate the median and average price of rental housing in different areas. Analyze the factors affecting rental prices in Melbourne, and use Tableau to make data visualization.

• 

  Qianhai Institute for Innovative Research (QIIR) 前海创新研究院

  • Shenzhen, Guangdong, China

  • Data Analyst Intern

    • Dec 2019 - Feb 2020
    • Shenzhen, Guangdong, China

    1. Use Axure to participate in the functional design of the intelligent data center construction project. Responsible for collecting data from local statistical bureaus and enterprises. In addition to cleansing data using Python, find problems in the filtered outlier data and output documents. And use the API interface to obtain data like road conditions, road networks, and public transportation networks.2. Responsible for collecting data from the intelligent health data management system. Organize data source data in excel, and use SQL statements to count medical data in Longhua District, Shenzhen hospital information, and patient information.