Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Rui Li

Mississauga,Canada

Summary

  • Results-driven professional with 5+ years of experience in business and data analytics.
  • Experienced in developing data marts and ETL processes to extract actionable insights; supports cross-functional teams in the telecom, gaming, and education industries.
  • Proficient in Excel, SQL, Power BI, Python, Tableau, Hive, and cloud computing.
  • Capable of independently producing analytical reports and building BI systems from scratch.

Overview

6
6
years of professional experience

Work History

Senior Business Analyst

Vision Academy
06.2021 - 07.2024
  • Lead the BI team in restructuring the company's metric system and building BI dashboard based on Power BI
  • Collaborate with the finance department to formulate the company budget and construct financial data models
  • Work with the marketing department to conduct specialized analysis and provide data support for market promotions, live broadcasts, and other activities

Data Analyst

Happy Elements
10.2020 - 07.2021
  • Provide data support for game testing and operations, establish relevant metric systems, and configure BI dashboards
  • Conduct exclusive analysis for game events and gameplay, such as the economic system within the game and pricing strategies for buyout games
  • Track and analyze market placement for the game, including analyzing the ROI of marketing efforts

Data Analyst

Bell
07.2018 - 07.2020
  • Track sales data, conduct monthly and quarterly data analysis, and provide reports
  • Establish data models to predict sales trends and market value, combining GIS and offline store information to manage operations and inventory
  • Design and conduct business surveys and market competition analysis, analyze competitors' business actions, and provide response recommendations
  • Collaborate with other departments to complete data retrieval and report writing
  • Perform daily hardware updates and upgrades for the data center

Education

Master's degree - Applied Economics

University of Windsor
01.2018

Bachelor's degree - Archives/Archival Administration

Tianjin Normal University
01.2015

Skills

  • SQL
  • Power BI
  • Python
  • Predictive modeling

Languages

English
Chinese (Mandarin)

Timeline

Senior Business Analyst

Vision Academy
06.2021 - 07.2024

Data Analyst

Happy Elements
10.2020 - 07.2021

Data Analyst

Bell
07.2018 - 07.2020

Bachelor's degree - Archives/Archival Administration

Tianjin Normal University

Master's degree - Applied Economics

University of Windsor
Rui Li