Yuejia Zeng

McGill MMA '27 · Data & Business Analytics · SQL · Python · Power BI

LinkedIn GitHub
Yuejia Zeng

I am a Master of Management in Analytics (MMA) student at McGill University, Class of 2027, with more than five years of experience in data and business analytics. Before joining McGill, I progressed from Business Analyst to Manager within OCBC Bank's Group Data Office, where I supported analytical modeling, customer insights, management reporting, and dashboard development. I am passionate about translating complex data into practical insights that support better business decisions.

SQL Python Power BI SAS Tableau Power Query

Certifications & Exams

CFA Program Level I Exam Passed FRM Exam Part I Passed

Languages

Mandarin Chinese Native English Professional Proficiency French Beginner

Professional Snapshot

5+ Years in Analytics
2 Career Promotions
3 Featured Projects
2 Finance Exams Passed

Education & Career Journey

A chronological view of my academic background and professional growth.

Education

  • 2026 - 2027

    McGill University

    Master of Management in Analytics (MMA)

  • 2019 - 2020

    Purdue University

    Master of Science in Marketing

  • 2015 - 2019

    Hefei University of Technology

    Bachelor of Economics

Professional Experience

  • 2020 - 2026

    OCBC Bank

    Progressive career growth within the Group Data Office

    Apr 2024 - May 2026 Manager, Group Data Office
    Apr 2022 - Mar 2024 Assistant Manager, Group Data Office
    Nov 2020 - Mar 2022 Business Analyst, Group Data Office
  • 2020

    Product Marketing Intern

    Lenovo US

  • 2018

    Financial Department Intern

    Agricultural Bank of China

  • 2018

    Trainee

    Manulife Financial Group

Excel & Power Query

BCM Inspection Analytics Model

Jul 2025 - Oct 2025
  • Developed an Excel Power Query-based BCM inspection analytics model.
  • Structured and analyzed 16 business continuity inspection items.
  • Reviewed emergency drill plans and reports for regulatory compliance.
  • Assessed vendors' disaster recovery plans for the 2025 audit year.
Python Analytics

Digital Marketing Analytics

Sep 2019 - Oct 2019
  • Used Python and social media analytics tools to analyze audience data.
  • Developed a digital marketing strategy for a beverage chain in Indianapolis.
  • Created short-form video advertisements for Facebook and Instagram.
  • Used multiple social media channels to support online audience growth.
Financial Modeling

Quantitative Investment Analysis

Jan 2018 - Apr 2018
  • Evaluated companies in China's domestic semiconductor industry.
  • Analyzed solvency, operating efficiency, growth, and profitability.
  • Applied PE, PEG, and PSR metrics for relative valuation.
  • Examined technical indicators including Bollinger Bands and the Williams Index.