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
London01-2026
Bachelor of Science - Economics and Statistics
University of Toronto
Toronto11.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
APOORVA KABRAAPOORVA KABRA
Associate Director - Governance Risk & Compliance at KPMGAssociate Director - Governance Risk & Compliance at KPMG
Anudeep ChokkarapuAnudeep Chokkarapu
Microsoft Dynamics 365 Developer at KPMGMicrosoft Dynamics 365 Developer at KPMG
SAKINA ADRASAKINA ADRA
Consultant at KPMGConsultant at KPMG
Shivangi SrivastavaShivangi Srivastava
Assistant Manager at KPMGAssistant Manager at KPMG
Olivia MasztalerzOlivia Masztalerz
Deli-Grocery Clerk at Fruit MarketDeli-Grocery Clerk at Fruit Market