Summary
Overview
Work History
Education
Skills
Websites
Projects
Extracurricular Activities
Timeline
Generic

TIANYU WANG

Toronto,Canada

Summary

Logical data analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with several years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.

Overview

2
2
years of professional experience

Work History

Wealth Management Assistant

ZhongTai Securities CO.,Ltd.
Jinan, China
05.2024 - 08.2024
  • Managed client engagement by introducing three personalized financial products; leveraged CRM data to visualize customer behavior and achieved a 20% boost in retention.
  • Conducted portfolio analysis using Python and Excel, applying quantitative models to assess risk and return, leading to optimized investment strategies.
  • Created clear, interactive visualizations to communicate portfolio performance insights to advisors and clients, enhancing transparency and decision-making efficiency.

Environmental, Social & Governance (ESG) Strategy Coordinator

Royal Bank of Canada
, Canada
05.2023 - 08.2023
  • Led a 5-member team to develop a sustainable investment framework, utilizing Python, R, and visualization tools to monitor over 20 ESG performance indicators.
  • Analyzed 15+ ESG investment opportunities, resulting in a 30% improvement in strategy alignment with sustainability goals across simulated portfolios.
  • Designed and delivered 3 executive-level dashboards that visualized environmental and social impact metrics, enhancing stakeholder engagement and decision-making.

Private Real Estate Investing Assistant

Equiton Capital
, Canada
01.2023 - 03.2023
  • Gained in-depth exposure to Canada's private real estate investment landscape, contributing to targeted outreach efforts that led to a 15% increase in East Asian investor engagement.
  • Developed dynamic dashboards and visualizations in Power BI and Excel, integrating real estate investment data to highlight key trends and performance metrics across asset types.
  • Conducted in-depth data analysis using Python, transforming raw market data into actionable insights and presenting findings through compelling visual reports to guide investor strategy.

Education

Master of Information - Information System Design & Data Science

University of Toronto
Toronto, ON, Canada
05.2026

B.MOS - Honours Specialization in Finance

University of Western Ontario
London, ON, Canada
05.2024

Skills

  • Python
  • JavaScript
  • R
  • C
  • SQL
  • VBA
  • Database Management
  • ERP & CRM Systems
  • UX/UI Design
  • Usability Testing
  • WS
  • Microsoft Azure
  • Google Cloud
  • MySQL
  • PostgreSQL
  • Git
  • Figma
  • Virtualization Tools

Projects

  • Medical Insurance Cost Predictor, Developed a predictive model using R to forecast individual medical claim charges based on demographic and behavioral variables. Conducted EDA and built linear regression models, improving R² from 0.74 to 0.86.
  • Financial Market Simulator, Built a VBA-powered simulation model to visualize the impact of macroeconomic indicators on asset prices.
  • Incorporated real-time inputs and ran sensitivity analysis for investment decision scenarios.
  • Behavioral Insights Dashboard, Applied Python and R to analyze social psychology and consumer behavior datasets from MOS and PSYCH courses. Created visualizations that revealed emotional drivers behind spending decisions.

Extracurricular Activities

Finance VP, Chinese International Volunteer Organization.

  • Secured over CAD 8,000 in sponsorships by establishing partnerships with 10+ organizations across various industries.
  • Managed a team of 12 to expand sponsor outreach, leading to a significant increase in financial support for community projects.

Timeline

Wealth Management Assistant

ZhongTai Securities CO.,Ltd.
05.2024 - 08.2024

Environmental, Social & Governance (ESG) Strategy Coordinator

Royal Bank of Canada
05.2023 - 08.2023

Private Real Estate Investing Assistant

Equiton Capital
01.2023 - 03.2023

Master of Information - Information System Design & Data Science

University of Toronto

B.MOS - Honours Specialization in Finance

University of Western Ontario

Similar Profiles

CREATE PROFILE
TIANYU WANG