Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Wanxuan He

Wanxuan He

Toronto,ON

Summary

Detail-oriented Business Intelligence Developer with hands-on experience in SQL, Power BI, and Python, delivering end-to-end data solutions from integration and modeling to visualization and reporting. Skilled at transforming complex data into actionable insights that support strategic decision-making, performance monitoring, and digital transformation. Adept at collaborating across departments, managing service requests, and building automated workflows that enhance both internal operations and client outcomes.

Overview

1
1
year of professional experience

Work History

Power BI Developer

Su Property Management Inc.
09.2024 - Current
  • Designed and maintained Power BI dashboards to present KPIs, department trends, and performance maturity, supporting leadership and cross-functional stakeholders.
  • Collaborated with stakeholders to gather reporting requirements and ensure design alignment.
  • Assisted in troubleshooting data discrepancies within Power BI reports and datasets.
  • Developed automated SQL and Python pipelines to extract, clean, and validate operational and financial data for decision-making.
  • Created and maintained data quality checks and validation rules using Power Query and Excel, reducing manual errors by 30%.
  • Participated in data dictionary development and performance monitoring initiatives across business units.
  • Delivered ad hoc and scheduled reports based on evolving business needs and service requests.

Data Analyst Intern

Fintelics Technology Inc.
04.2024 - 09.2024
  • Built relational databases (MSSQL) and engineered queries for risk analysis and segmentation, managing over 100,000 records.
  • Developed machine learning models (Random Forest, XGBoost) to forecast ROI and assess property investment risk.
  • Integrated data from public APIs and web scraping pipelines to support analytics for financial product strategies.
  • Created Power BI dashboards to visualize property trends and risk metrics, supporting investor decision-making.
  • Assisted in updating technical documentation and presenting insights to internal and external stakeholders.
  • Collaborated with cross-functional teams to streamline data collection and reporting procedures.
  • Conducted data validation to ensure accuracy and consistency for ongoing projects.

Education

Master of Science - Data Analytics

Western University
London, ON
09-2024

Bachelor of Science - Statistics

University of Ottawa
Ottawa, ON
05-2023

Skills

  • BI & Reporting Tools: Power BI (DAX, Power Query), Excel Dashboards
  • Databases & Languages: SQL (MSSQL, PostgreSQL, complex joins, CTEs), Python (Pandas, Scikit-learn)
  • ETL & Automation: Power Automate, SSIS, API Integration, Web Scraping
  • Development Practices: Requirements Gathering, Data Modeling, Data Dictionaries, KPI Definition
  • Soft Skills: Cross-functional Collaboration, Technical Documentation, Agile/Scrum, Data Storytelling

Languages

English
French
Chinese (Mandarin)

Timeline

Power BI Developer

Su Property Management Inc.
09.2024 - Current

Data Analyst Intern

Fintelics Technology Inc.
04.2024 - 09.2024

Master of Science - Data Analytics

Western University

Bachelor of Science - Statistics

University of Ottawa

Similar Profiles

CREATE PROFILE
Wanxuan He