Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Wing-Kam Matthew Lam

North York,Canada

Summary

Seasoned FP&A Analyst with expertise in financial planning and analysis. Skilled in strategic budgeting, forecasting, and business model development. Proficient in data visualization, financial modeling, variance analysis, and collaborative leadership. Demonstrated track record of driving revenue growth and cost reduction initiatives.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Business Analyst (FP&A)

A.S Watson
11.2021 - 07.2024
  • Reviewed European business unit (BU) s' submissions of monthly KPI & P&L, quarterly forecasts, 5-year plan, weekly sales reports and slide presentation to Group CFO
  • Reviewed and analyzed 300+ financial models on lease renewals, capex projects/ tendered contracts and relevant assumptions to highlight underlying financial implications and risks to management
  • Performed trend analyses and investigated actual vs budget/forecasted variances in monthly performance schedules with BU Finance Director and analysts to highlight underlying drivers of performance
  • Prepared informative charts and slide presentation with raw Hyperion/ERP inputs to Group CFO on group-wide KPI's
  • Ad hoc spreadsheet modelling with advanced formulas to aid in KPI review and the decision- making of the Group Investment Committee

Achievements

  • Facilitated a breakeven EBIT for FY 22 with closures of loss making stores
  • Maintained a trusted and cordial business partnership with various business functions

Staff Accountant (Assurance)

EY
10.2018 - 10.2021
  • Participated in 1 IPOs and 5 annual audits of listed clients in retail, trading, food, and hospitality industries
  • Performed substantive analytical procedures and tests of details on P&L and balance sheet items, including AR/AP, inventory (NRV testing), revenue, gross profit, selling, and G&A expense items, etc.
  • Performed ratio analyses and trend analyses on SAP and reports with Excel formulas, pivot tables, and VBA
  • Analyzed the fluctuations and identified the patterns of the activity ratios
  • Assisted in sensitivity analyses and monitored the impacts of different scenarios on cash flows

Achievements

  • EXCEED Award in 2020 for exceptional client service in secondment to China
  • Contributed to the listing of Shenzhen Hepalink Pharmaceutical Group Co., Ltd

Education

BBA - Professional Accountancy

City University of Hong Kong
Hong Kong
08.2018

Student Exchange Program -

Concordia University
Montreal, Canada
05.2017

Skills

  • Business Partnering
  • ERP (Oracle Essbase Hyperion)
  • VBA
  • Microsoft Suite

Certification

Certified Practicing Accountant (CPA)

CPA Australia | Oct 2021

Languages

English
Full Professional
Chinese (Cantonese)
Native/ Bilingual
Chinese (Mandarin)
Full Professional

Timeline

Business Analyst (FP&A)

A.S Watson
11.2021 - 07.2024

Staff Accountant (Assurance)

EY
10.2018 - 10.2021

BBA - Professional Accountancy

City University of Hong Kong

Student Exchange Program -

Concordia University
Wing-Kam Matthew Lam