Summary
Overview
Work History
Education
Skills
Timeline
Generic

Justin Yeom

Roselands

Summary


Experience Senior Financial analyst with strong track record in financial reporting, forecasting, budgeting, and data analysis. Proven ability to deliver actionable insights and drive financial performance through collaboration and adaptability. Equipped with expertise in financial modelling, process improvement, strategic planning, and risk management. Known for reliable performance and ability to thrive in dynamic environments.

Overview

10
10
years of professional experience

Work History

Senior Financial Analyst

Qantas
08.2022 - Current
  • Deployed the new consolidated P&L for international regions via Power BI, presented to the International Finance controller, and published to the team.
  • Drove process improvement projects to streamline the reconciliation process impacting 30+ balance sheet accounts in International Commercial team.
  • Worked collaboratively with Finance System team and TCS to test FX cleansing process and successfully cleared the historical FX variances in International Cost centres.
  • Perform monthly and quarterly balance sheet reconciliations for international regions and perform the month-ends tasks.
  • Provide commentaries on monthly P&L movements and prepare the consolidation of the commentaries for GERA on a half yearly basis.
  • Update Power BI dashboard monthly with the refreshed MFR and provide monthly P&L by regions and 5 pillars (Marketing, Sales, Freight, Airport, and Aviation charges).
  • Investigate the FX variances in Offshore stations and suggest the action plans in the fortnightly FX meeting.
  • Report the weekly offshore station bank balances to the HQ Treasury team and ensure the sufficient cash on hand and coordinate transferring the surplus to HQ.
  • Update the budget and the latest forecast in Pacific Island regions.
  • Regularly communicate with the regional management teams to provide accounting & finance supports.
  • Maintain and update the Finance Knowledge Hub for the International Finance Team.
  • Lead continuous improvements projects to streamline the processes in the offshore finance team.

Financial Business Analyst

Pernod Ricard Winemakers
06.2021 - 08.2022
  • Contribute to the global initiative and embed the new Advertising & Promotional reporting tool, Polaris, while working collaboratively with Senior managers in Trade and Brand Team as well as Finance management.
  • Drove Marketing A&P Tracker and Power BI Dashboard roll out to provide visibility on A&P spends for Marketing including Marketing Leadership Team.
  • Monitoring and reporting of Pacific Marketing spends and coordinating the release of funds as approved by the Global Marketing Director.
  • Provide business partners with CAAP model and regular updates on Brand profitability, educating them on critical KPI's and providing general financial support during budgeting and Latest Estimate processes.
  • Perform ROI analysis on key spend initiatives to determine incremental CM delivery with a view to make recommendations as to whether to proceed with future investment.
  • Monthly check in with Marketing/Brand team to identify any financial risks and opportunities in Marketing promotions, prior to the month-end.
  • Report the A&P actuals vs forecast analysis to the management and to HQ in Paris via HFM and Polaris system.
  • Responsible for collation, submission and monitoring of Marketing Capex and understanding of relevant on-premise contracts ensuring financial aspects are captured correctly.
  • Perform month-end tasks including A&P reporting packages, P&L preparation, and Balance Sheet reconciliation.
  • Conduct OCM reviews on Champagne brand as a part of French administration requirements for AU and NZ markets.
  • Build and Maintain Power BI A&P Dashboard and Marketing tools.

Commercial Finance Analyst

British American Tobacco
08.2018 - 06.2021
  • Successfully launched Anaplan to automate Promotion planning, tracking, and settlement, working collaboratively with non-finance colleagues in Trade, Marketing, and IT.
  • Drove the use of Alteryx to automate internal weekly reporting and month-end balance sheet reconciliation, saving 10 hours per month and eliminating human errors.
  • Drove recovery of $1.7m of disputed promotional/pricing claims, engaging with account teams.
  • Cleared $3m worth of pricing claims annually with valid evidence provided.
  • Drove a system integration between Anaplan and MyBAT as well as enhanced functionality from weekly promotion planning to daily promotion planning, as a single point of contact in Commercial Finance.
  • Supervise a direct report, Finance Analyst and assist a Commercial Finance Manager.
  • Ensure all promotions executed in the marketplace entered in the system reconciles to commitment.
  • Ensure all payments are executed accurately (verifying payment requests against supporting documentation) and all governance touch points are adhered to Internal control governance.
  • Work closely with the Trade Marketing team and liaise with national account managers to ensure the appropriate checks and reviews are conducted and signed off prior to commitment being paid.
  • Assist Cash flow management team with Quarterly, Half year, and Year-end assessments.
  • Perform Month-end tasks including accruals, GL balance sheet reconciliations, and reporting to management.
  • Engage with Global Shared Service teams in relation to governance in processes.
  • Prepare weekly reports in compliance with Sarbanes-Oxley Act 2002.
  • Managing pricing claims to ensure timely clearance and recovery of funds through active and effective engagement with Account Managers.
  • Engage with Internal/External auditors for audit assessments.
  • Anaplan Subject Matter Expert and SPOC for Anaplan system usage, improvements, and enhancements.

Accounts Payable / Treasury Assistant Accountant

Fitness First Australia
08.2015 - 08.2018
  • Successfully launched an ERP system transition from Great Plains to Micro Dynamics NAV.
  • Prepare Monthly AU/NZ GST reconciliations and submit a lodgment.
  • Prepare fortnightly vendor payments and purchase orders.
  • Prepare and review weekly supplier aging reports for AU and NZ vendors.
  • Assist with a preparation of monthly P&L reports for management.
  • Reconcile Amex corporate card and Business Travel account.
  • Review and process Employee expense claims.
  • Review Trial balance for New Zealand head office.
  • Prepare AU/NZ quarterly international trade survey papers.
  • Perform a daily bank reconciliation and monitor daily club takings.
  • Perform weekly cash flow reports and daily banking transactions.
  • Prepare a daily bank integration and post general journals, accruals and prepayments.
  • Prepare month-end tasks including General Ledger and balance sheet reconciliations.
  • Review and report Front Desk Revenues to management.
  • Any other ad hoc accounting activities as directed by the Financial Controller.

Education

Fully Qualified CPA -

CPA Australia

Bachelor of commerce - major in accounting

Griffith University

Diploma of Hospitality Management - undefined

Gold Coast Institute of TAFE

Skills

  • Financial planning and analysis
  • People Management
  • Budgeting and forecasting
  • Commercial analysis and insights
  • Promotion planning
  • Process improvements
  • SQL (Power Queries and Power BI)
  • P&L and Financials
  • Cash flow management
  • Management reporting
  • System integration
  • Risk assessment
  • Process documentation
  • Business partnering
  • Variance reporting
  • Annual budgets

Timeline

Senior Financial Analyst

Qantas
08.2022 - Current

Financial Business Analyst

Pernod Ricard Winemakers
06.2021 - 08.2022

Commercial Finance Analyst

British American Tobacco
08.2018 - 06.2021

Accounts Payable / Treasury Assistant Accountant

Fitness First Australia
08.2015 - 08.2018

Bachelor of commerce - major in accounting

Griffith University

Diploma of Hospitality Management - undefined

Gold Coast Institute of TAFE

Fully Qualified CPA -

CPA Australia

Similar Profiles

CREATE PROFILE
Justin Yeom