Advanced Excel
Clara Hong
Sr. Financial Analyst
Toronto,Ontario
Summary
Highly motivated and goal-driven Financial Analyst skilled in collecting, monitoring and studying data to analyze financial status and recommend business strategy. Experienced in qualitative and quantitative analysis, contract management and forecasting. Tech-savvy in use of spreadsheets, accounting and financial management software.
Overview
10
10
years of professional experience
2
2
Languages
Work History
Senior Financial Analyst
Ortho Clinical Diagnostics
Markham, ON
08.2020 - Current
- Oversee profitability analysis for key markets
- Create and manage budget reporting workflows
- Publish executive reporting on P&L, trends and risk
- Serve as Canada finance team lead
- Perform intercompany reconciliations, prepare weekly, monthly and quarterly cash flow forecast for treasury
- Perform key month-end activities
- Prepare all monthly sales tax, and annual corporate tax filings
- Liaise with external audit
- Implement process improvements in line with GAAP, SOX and the ICH
Financial Planning Analyst
United Natural Foods Inc
Vaughan, ON
06.2018 - 08.2020
- Issue daily, weekly and monthly sales and margin reports
- Generate weekly sales scorecard and warehouse productivity reports, and analyze variances
- Oversee manufacturer chargebacks process
- Liaise with brand marketing and procurement to provide financial forecasts
- Prepare budget and forecast for assigned cost centers
- Evaluate contribution margins by customers to assist in pricing
Financial Analyst
Estee Lauder Companies
Markham, ON
06.2015 - 06.2018
- Generate productivity reports, trend analysis, and approve staffing requests to meet sales trends
- Oversee departmental expense reporting and related budget updates (CPM)
- Perform opportunity and risk and P&L analysis in support of senior management decisions
- Oversee Month-End activities, accrual and expense journal entries into SAP, Balance Sheet reconciliations, and variance analysis
- Generate monthly and weekly wage expense and FTE and headcount reports for multi-brands
- Direct the company’s outsourcing relationship with an India-based team of accounting specialists, providing guidance, troubleshooting, training, performance review and other support
- Review employee compensation programs and process their payments, ensuring validity, accuracy, and completeness of bonus payouts
Finance Officer (Co-Op)
Ministry Of Environment
Toronto, ON
05.2014 - 08.2014
Pension Assistant (Co-Op)
Financial Service Commission Of Ontario
Toronto, ON
09.2013 - 04.2014
Education
Bachelor of Administrative Studies (BAS) - Accounting
York University
Skills
FP&A
Variance reporting
Financial modeling
Business operations analysis
Financial and operational reporting
Preparing budgets
Data trending
Software
SAP
Power BI
OneStream
BPC
FIC
Timeline
Senior Financial Analyst
Ortho Clinical Diagnostics
08.2020 - Current
Financial Planning Analyst
United Natural Foods Inc
06.2018 - 08.2020
Financial Analyst
Estee Lauder Companies
06.2015 - 06.2018
Finance Officer (Co-Op)
Ministry Of Environment
05.2014 - 08.2014
Pension Assistant (Co-Op)
Financial Service Commission Of Ontario
09.2013 - 04.2014
Bachelor of Administrative Studies (BAS) - Accounting
York University