McGill University
Master of Management in Analytics · Expected 2027
Business Analytics Portfolio
Vincent Wang
Turning complex data into practical business decisions.
Montreal, Canadashengxiao.wang@mail.mcgill.ca
I am a business analytics professional and incoming Master of Management in Analytics candidate at McGill University. I build automation, forecasting, and reporting solutions that turn manual processes and complex datasets into faster, more reliable decisions.
70%reduction in finance approval processing time
15 hrsof manual reporting work eliminated each week
92%quarterly budget forecasting accuracy achieved
McMaster University
Bachelor of Commerce · GPA 3.74/4.0 · Dean’s Honours List
Technical toolkit
Python · SQL · R · Power Automate · Power Apps · Excel VBA · Tableau · Power BI · SAS · Bloomberg Terminal · JMP
Beyond analytics
Languages
English — Advanced · Mandarin Chinese — Native
Interests & Certifications
Tennis — NTRP 4.0 · Alpine Ski Instructor — CSIA Level 1 · Snowboard Instructor — CASI Level 1
Selected experience
Jun 2024 — Aug 2025
Financial Analyst
Martinrea International · Vaughan, Canada
Automated corporate finance approvals with Microsoft Power Platform, built Excel VBA forecasting models, and developed Python reporting pipelines. Presented Power BI insights to senior leadership and helped drive adoption across three business units.
Jan 2025 — May 2025
Teaching Assistant · Operations Management
McMaster University · Hamilton, Canada
Created instructional content for real-world Power Platform workflows and evaluated AnyLogic queueing simulations through statistical testing and operational performance metrics.
May 2023 — Sep 2023
Research Assistant
McMaster University · Hamilton, Canada
Processed more than six million Google Reviews and collected engagement data across 2,500+ TikTok posts. Applied statistical and time-series analysis to digital commerce and supply-chain research.
Portfolio Risk Analytics & Investment Modeling
Built a Python risk framework for a 25-stock portfolio spanning 21 years. Modeled Value-at-Risk with 10,000 Monte Carlo iterations, evaluated risk-adjusted performance, and created an automated Excel VBA dashboard with efficient-frontier and stress-testing views.
Hospitality Intelligence Platform
Designed a normalized nine-table database and used CTEs and window functions to analyze bookings, customer segments, pricing, occupancy, and lifetime value. Developed a preference-scoring model to support personalized recommendations.