Experience

Beijing Tsinghua Tongheng Planning and Design Institute Limited

• China
• Software Development
• 1 - 100 Employee

• Researcher

  • May 2020 - Present



JLL

• United States
• Real Estate
• 700 & Above Employee

• Research Analyst

  • Sep 2019 - Apr 2020

  • Managed to monitor the residential and industrial real estate market of major cities in Northern China by collecting and cleaning monthly data from various online and off-line sources. Ensured validity and representativeness of several large databases in Excel.• Provided quarterly updates of the market situation, policy interpretations and forecast to investors, property owners, and other customers around the globe with digests, articles, and reports. • Actively expanded the current sources of data by acting as an information broker and exchanging market information with property managers; established information sharing relationships on a regular basis with over 20 landlords of major logistics projects and serviced apartment projects in the local market.• Proactively used Python to perform a GIS analysis using online mapping APIs, generating potential commuting routes for over 1 thousand home addresses of employees to help find the best potential new office location for a client.



University of Toronto

• Canada
• Higher Education
• 700 & Above Employee

• Research Assistant in Economic Development

  • Sep 2018 - Jun 2019

  • To support an ongoing research investigating the impact of foreign exports on manufacturing industry in Germany, independently being responsible for constructing a 20-year longitudinal data series of Germany’s import/export data by each industry sector. Resolved the discontinuity issues in data by building intermediate mapping tables.• Extracted relevant data from previously constructed Excel panels using commands and pivot tables. Streamlined the data extraction processes for colleagues allowing for easier interpretation of the data and saving time. • Translated economic-related terms in the data sources from German to English.

• Teaching Assistant

  • Sep 2018 - Apr 2019

  • Professionally conducted weekly tutorials to around 300 students with excellent feedback.• Played an active role in ensuring students’ success by providing course-related resources and advice. Mentored first-year students, helping them to navigate in their academics • Organized office hours to tackle students’ questions on an individual basis.

• Research Assistant in Political Economy

  • May 2017 - Apr 2019

  • Contributed to a research project investigating how people strategically switch their voices at work to cater for different scenarios. Developed an automated method of aggregating scattered public data online which are unavailable in conventional databases adaptively using Python and Chrome Plug-ins.• Generated 120,000 acoustic samples by building an automated program in Praat, a linguistics software. Built a dynamic accessible storage system to house the data.• Constructed a database containing the movement trajectories of over 60,000 lawyers by merging datasets of various formats from distinct sources. Reconciled discrepancy issues in data using Stata.