Overview
Work History
Education
Skills
Certification
Timeline
Generic

John Pan

Mississauga,ON

Overview

6
6
years of professional experience
1
1
Certification

Work History

Senior Financial Analyst - Capital Markets Finance

CIBC
Toronto, ON
10.2022 - Current
  • Performed comprehensive accounting for US GIC, structured rates trading and ASG books ensuring accurate month end closings
  • Responsible for the accounting treatment for various ASG initiatives, leading E2E testing to ensure the effective execution of new projects
  • Responded promptly and accurately to ad-hoc requests from business stakeholders and CFO partners
  • Prepared month-end balance sheet substantiations and conducted analytical reviews for US GIC and ASG books, with a focus on identifying and addressing concerning trends
  • Interact and collaborate with various banking groups to support initiatives and investigate complex problems
  • Responsible for reviewing and adjusting regulatory statutory reports and financial reports to meeting monthly and quarterly reporting deadlines
  • Implemented various process enhancements through the utilization of tools such as Alteryx, PowerBI and Powerquery, effectively automating tasks and enhancing overall team efficiency

Senior Financial Analyst - Syndicate Accounting

CIBC
Toronto, ON
05.2021 - 10.2022
  • Performed profit distribution calculations and provided explanations for any differences between actual and estimated profit for Syndicate Equity & Debt Capital Market Underwriting deals
  • Prepared all Management/Interim/Final Statements for Lead Equity deals
  • Prepared Daily Financial Estimates and daily P&L accounting entries for the Syndicate Accounting team
  • Prepare month-end accounting entries to the G/L and perform reconciliations to ensure daily reported P&L statement reconciles to the General Ledger
  • Responsible for calculating and preparing wires for IIROC as well as monthly payments to brokers within the Syndicate
  • Responsible for preparing adjustment entries to ensure accurate month-end book closings

Senior Fund Accountant

CIBC Mellon
Mississauga, ON
05.2018 - 05.2021
  • Report the daily net asset value of funds to clients including Pier 21, Vertex One, CC&L, etc
  • Prepare financial statements, audit and year end valuation packages, financial reports, fund distributions and preparation of T3 income distribution factors
  • Responsible for providing the NAV for the team's most complicated funds that included complex corporate actions
  • Review processing of complex Corporate Actions such as Spin-Offs, Mergers & Acquisitions
  • Review interest rate swaps, credit default swaps, total return swaps, FX forwards, listed & OTC options, futures, and other non-standard derivative transactions to ensure correct valuation

Education

Bachelor of Arts - Economics And Accounting

Wilfrid Laurier University
Waterloo
2018

Skills

  • Technical: Proficient in Excel, Alteryx, VBA, SQL, Queries, Power Pivot and other analytical/visualization tools
  • Languages: English (Native), Mandarin (Fluent)

Certification

  • Chartered Professional Accountant (CPA), Ontario, 2023
  • CFA Level II

Timeline

Senior Financial Analyst - Capital Markets Finance

CIBC
10.2022 - Current

Senior Financial Analyst - Syndicate Accounting

CIBC
05.2021 - 10.2022

Senior Fund Accountant

CIBC Mellon
05.2018 - 05.2021

Bachelor of Arts - Economics And Accounting

Wilfrid Laurier University

Similar Profiles

CREATE PROFILE
John Pan