Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

BOHAN GAO

Mississauga,ON

Summary

Data-driven and detail-oriented graduate student pursuing an MSc in Project and Enterprise Management at University College London, with a strong academic foundation in Economics and Statistics from the University of Toronto. Skilled in data cleaning, analysis, and visualization using tools such as Python (Pandas), Excel, and Power BI, with experience applying statistical methods to solve real-world business problems. Demonstrated ability to translate complex datasets into actionable insights through internships at KPMG and TD Bank, achieving measurable results such as a 90% client product adoption rate and data-backed recommendations that led to a successful bid. Adept at cross-functional collaboration and delivering accurate, insight-driven reports to support strategic decisions.

Overview

2
2
years of professional experience

Work History

Tax Intern

KPMG
Beijing, China
02.2024 - 05.2024
  • Collected, cleaned, and analyzed 1,200+ invoice records from client systems, identifying non-compliant reimbursements with 95% accuracy, improving audit efficiency by 15%.
  • Conducted historical data analysis on previous year’s tax filing records to identify high-risk expense categories and transaction amounts, enabling the audit team to prioritize 5 key focus areas in the current year’s sampling process.
  • Utilized Excel (VLOOKUP, filtering, conditional formulas) and Python (Pandas) to merge and process multi-source datasets, reducing manual processing time by 30% and improving reporting accuracy by 20%.
  • Extracted and processed monetary data from court rulings and judgments to determine non-performing credit card debt for China Everbright Bank, applying Excel formulas and data filtering to validate figures and ensure 100% accuracy in annual tax calculations.
  • Conducted a comparative analysis of past bid amounts and outcomes from similar contracts, using Excel to identify optimal pricing ranges; provided data-backed recommendations that guided the bid amount for the current proposal, which resulted in a winning bid.

Customer Experience Associate

TD Bank
Toronto, Canada
03.2022 - 11.2022
  • Processed and verified 500+ daily financial transactions (deposits, bill payments, wire transfers), ensuring 100% accuracy in compliance with banking regulations.
  • Analyzed potential clients’ asset allocation and daily spending patterns using Excel (VLOOKUP, filtering) to recommend tailored investment products, achieving a 90% product adoption rate in subsequent engagements.
  • Mentored 5+ new employees by creating performance tracking sheets and providing data-backed feedback on service quality.
  • Used data analysis tools to clean, filter, and analyze potential client datasets, identifying patterns in spending habits to recommend tailored investment products; in Q3 2022, achieved a potential client conversion volume 400% higher than the average among peers at the same level.

Education

M.D. - Project and Enterprise Management

University College London
London
01-2026

Bachelor of Science - Economics and Statistics

University of Toronto
Toronto
11.2023

Skills

  • Python (Pandas)
  • Power BI
  • Experienced with Microsoft Office applications
  • Advanced Excel proficiency

Languages

Chinese (Mandarin)
First Language
English
Advanced (C1)
C1

Timeline

Tax Intern

KPMG
02.2024 - 05.2024

Customer Experience Associate

TD Bank
03.2022 - 11.2022

M.D. - Project and Enterprise Management

University College London

Bachelor of Science - Economics and Statistics

University of Toronto

Similar Profiles

CREATE PROFILE
BOHAN GAO