Charlie Chen
BCom Finance Graduate | CFA Level I Passed | Experience in Accounting, Credit & Data Analysis
Hire this person
Send a job offer directly to this candidate
About
Detail-oriented Finance Specialist (CFA Level I Passed) with a strong technical foundation in NAV production, cash/holdings reconciliation, and investment accounting. Expert in automating complex financial workflows using VBA Macros and Power Query to ensure 100% data integrity. Proven ability to conduct variance analysis on financial datasets and execute User Acceptance Testing (UAT) for system enhancements under strict daily reporting deadlines.
Experience
Business Analyst Intern at Leonnova (2024-09 – 2024-12)
- Developed and executed automated financial reporting solutions while performing comprehensive variance analysis and data pipeline engineering.
- Automated recurring valuation and performance reporting by developing VBA Macros; executed rigorous User Acceptance Testing (UAT) and bug-fixing to ensure the reliability of automated system outputs before final release
- Performed complex Variance Analysis (Budget vs. Actual & Forecast vs. Run-rate) for 10+ portfolios; investigated and resolved data anomalies by cross-referencing multiple data sources
- Engineered data pipelines via Power Query and developed Power BI dashboards to visualize variance drivers (BVA), supporting strategic budget reallocation
Junior Accountant Intern at Keith Y Wong & Co (2024-05 – 2024-08)
- Executed fund accounting operations including distribution calculations, reconciliations, and financial statement preparation.
- Executed and verified fund distribution calculations, including interest accruals and unitholder payments, ensuring precise record-keeping and adherence to timelines
- Performed complex reconciliations between internal records and external statements, investigating breaks and variances to support seamless monthly closings and NAV accuracy
- Prepared audit-ready workpapers and supported the drafting of financial statements, resolving discrepancies through rigorous data validation and evidence trails
- Coordinated with counterparties and internal teams to resolve processing exceptions, maintaining high service standards for client reporting
Education
Bachelor of Commerce in Finance Specialist – University of Toronto (2025-05)
