Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
TMX Group Analyst, Market Strategy & Insights
Sep. 2022 - Nov. 2022Montreal, Quebec, CanadaDeveloped scripts for automating data extraction, cleaning, transformation, reporting, and identification of significant insights
AADM LLCData Analyst
Jul. 2019 - Aug. 2021New York- Maintained customer info database using SQL & conduct customer insights analysis w. marketing team
- Conducted quantitative analysis on customer acquisition & retention to improve marketing effectiveness
- Built predictive models to interpret & analyze ETF, MF & other economic data scraped from web
- Conducted data regression analysis of relationship between ETF prices and industry trends in Python
- Developed visualizations to provide ETF & MF ratings & reports for investors using Tableau Dashboard
Jones Lang LaSalleData Analyst Intern
Jul. 2018 - Aug. 2018Beijing, China- Constructed models’ comparison for Analysis Report of Relic Protection Project in Beijing using Python
- Cleansed geographical data in ArcGIS system using Python that accelerated the analysis process
- Evaluated projects of infrastructure constructions using Spark for group presentation and discussion
中国科学院Data Analyst Intern
Jun. 2018 - Jul. 2018Beijing, China- Converted semi-structured XML files of Medical Patent Application Information to Excel using Java
- Discovered relationships between Residential & Commercial Information in ArcGIS using PostgreSQL
- Generated visualizations in Climate Report for Beijing Municipal Bureau of Agriculture using PowerBI
Capital Market Statistics and Monitoring CenterData Analyst Intern
Jun. 2017 - Aug. 2017China, Beijing- Co-authored multiple reports on data masking, including regulatory guidelines and operational standards.
- Developed Java-based tools for index calendaring and stock information masking.
- Constructed predictive models for assessing residential reviews.
Electric Power Research Institute (EPRI)Research Assistant
Jun. 2015 - Aug. 2015Beijing, China- Completed part of the paper Technological Analysis of DC&AC Power Distribution Network
- Collected the papers on DC distribution and collated the key viewpoints
- Assisted in statistical review work of paper and project application materials writing
- Translated papers and summed up pros and cons of distributed power connection
Intch is a Professional Networking App for the Future of WorkSee more people like Hongyi on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
453430 people
27
Software engineer @ GFT Canada
13
Apple @ Apple
15
Consultant @ Deloitte
69955 people
15
Consultant @ Deloitte
19
Business Systems Analyst @ TD Bank Group
30
Senior Data Engineer @ PontClickCare