Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Di Lu, CPA

Strathfield,NSW

Summary

A finance professional with 10-year accounting experience working in commercial environments ranging from Australian local, ASX listed and large global corporations. I have a strong background in financial and management accounting. My strength is that I combine excellent organizational and analytical skills with a "can do" attitude and commitment to achieving goals.

Overview

9
9
years of professional experience

Work History

SENIOR FINANCIAL ACCOUNTANT

Laing O'Rourke
06.2023 - Current

Manage 5 cost centres' overheads review, analysis and forecasting, work with functional and SPV leaders for monthly forecasting, report Risk and Opportunities, and prepare AEC deck for quarterly reporting

  • Monthly Corporate overhead analysis – investigation and commentary on actual versus budgeted expenditure and liaison with Functional Heads
  • Run scenario analysis, what-if analysis, trend analysis, staff utilisation or rechargeable ratio analysis for any cost centres with issues in aligning with Budget, find out problems, work out feasible options, monitor implementation of agreed recovery plan
  • Prepare Management Accounts (adjustments, P&L, Balance Sheet, Cash Flow statement, Notes) and commentary for 8 entities on a monthly basis
  • Prepare annual solvency review for various companies
  • Have successfully prepared financial information for 6 tender submissions

SENIOR ACCOUNTANT

Datto Asiapac Pty Ltd
04.2019 - 06.2023

Datto is a world’s leading provider of cloud-based software and security solutions to Managed Service
Providers (MSPs), employing around 2,000 people across 10 countries worldwide.

  • Lead and manage Month End / Quarter End / Year End Close, and lead the team on closing the monthly financials for four entities on time, and ensuring the integrity and accuracy of financial outputs
  • Lead the production of monthly consolidated group management report that contains consolidated income statement, balance sheet, cash flow statement and sales report
  • Prepare Annual Report including Notes, and play a key role in annual audit meetings, and complete audit inquiries lists and samples, etc.,
  • Review month end results, prepare P&L variance analysis and commentary
  • Perform weekly cash flow forecasting, administer cash management, and initiate cash transfer requests and approval if needed
  • Assist in Budget preparation for APAC region, consolidate CAPEX Plan, work out Depreciations for both new and existing Fixed Assets, and analysing Net Book Value of existing Fixed Assets to remind Department Managers for any potential Fixed Assets replacement needs
  • Perform Budget evaluation on variance analysis for Actual CM vs. Budget CM, Actual YTD vs. Budget YTD and Year To Go (YTG) analysis, discover the reason for the variance and identify the upcoming problems
  • Manage month end journals and perform Balance Sheet reconciliations via Blackline
  • Implement Budget Control process, build up models to transform approved annual budget into weekly budget if needed, deliver annual/monthly/weekly budget to each APAC department, and assist in response plans for any budget warnings
  • Business partnering with APAC functional leads to effectively deliver business reporting and analysis on a timely basis
  • Lead internal software capitalization project, build up software capitalization process and template, and manage key accounting inputs including the methodology, data inputs and postings
  • Prepare payroll journals and vacation accruals for four APAC payroll entities
  • Develop, maintain and drive appropriate documentations for APAC Finance processes, and implement Information Produced by the Entity (IPE) for internal control and auditing purposes
  • Lead audit process for APAC entities and coordinate with other departments to get audit inquiries sorted out on time
  • Assist Global Tax team in any local tax matters
  • Oversea AP, AR, Junior Accountant work and provide coaching if needed

FINANCIAL ACCOUNTANT

Look Corporate Pty Ltd
11.2016 - 04.2019
  • Ran eliminations and prepared monthly consolidated financial statements – profit and loss, balance sheet, and statement of cash flow
  • Performed monthly analysis on corporate department financial position and reviewed with each responsible director
  • Assisted in budget variance analysis, reported budget warnings to Financial Manager Monitored and controlled data entries and general ledgers
  • Maintained Fixed Asset Register including assets capitalization and disposal, GL reconciliation and assets useful life review
  • Reconciled balance sheet accounts and sales revenue
  • Prepared for year-end close and assisted in audit
  • Managed month end process & prepare month end journals including releasing prepayment amortizations and depreciations, accruals, and intercompany journals
  • Prepared for lodgements including quarterly BAS and annual FBT return
  • Assisted in payroll tax lodgement, workers compensation and public liability insurance renewal
  • Manage credit card coding and reconciliations
  • Liaised with key stakeholders and responded to any internal/external inquiries as required

ACCOUNTANT

Hill-Rom Australia
09.2016 - 11.2016
  • Owned Horizontal analysis, Common-Size analysis, and Sales analysis as part of monthly reporting on the financial performance.
  • Worked with finance manager on building sales volume forecasting model
  • Monitored AP & AR, and managed general ledger account reconciliations and monthly close for the newly acquired subsidiary
  • Maintained Fixed Asset Register and Leases
  • Processed staff expense claim approvals on Concur and accruedunsubmitted expenses at the month end
  • Performed Stock take and assist in inventory management

ACCOUNTS ASSISTANT

Australia Sunny Glass Group Limited (ASX listed)
03.2015 - 08.2016
  • All-rounder accounts duties in day-to-day operation
  • Fulfilled Statutory reporting, tax and audit duties
  • Worked with Finance Manager on Early Bird Discount feasibility analysis
  • Assisted in New Project analysis for the toughened glass production line and provided support in Finance Plan

Education

Certified Practising Accountant ANZ

CPA Qualified (2015)

Monash University - Melbourne

Master of Banking And Finance (2010)

Monash University - Melbourne

Bachelor of Professional Accounting (2009)

Skills

PROFESSIONAL SKILLS

  • Month end close, consolidation, P&L and Balance Sheet review
  • Management Accounts, annual reports and Auditing
  • Documentation and Internal Control
  • Budget and forecasting
  • Data analysis, Business partnering & Stakeholder management
  • Resolve discrepancies and efficient communication
  • Capability of working autonomously

TECHNICAL SKILLS

  • Power BI and Advanced Excel (Modelling, VLOOKUPS, Pivot Tables etc,)
  • ERP System - NETSUITE, SAP, ORACLE, XERO, COINS
  • Workflow automation tool - Alteryx
  • Reconciliation tool: Blackline
  • Budgeting & Forecasting tool: Apliqo
  • Other systems – TM1, Concur, LeaseQuery, Fixed Asset Manager

Accomplishments

    Accomplishments in LAING O'ROURKE AUSTRALIA:

  • Have helped cost center Legal to work out an feasible plan to turn their unfavourable overhead position against budget into break-even. I've re-built up trust with the Legal Heads, re-opened communications between Legal and Finance, and lifted up satisfactory from 10% to 70% via doing historical data review, scenario analysis, overheads forecasting and organised solutions meetings in the first 4 months since I joined the Company.
  • Have built up automated modelling for P&L and Balance Sheet variance analysis from scratch for 8 entities, and designed dynamic dashboard for the management reporting purpose

  • Accomplishments in DATTO:

  • Have been a critical member to build up APAC Finance system from scratch, and have been awarded “APAC All Star” in two consecutive years
  • Have used Alteryx to automate month end journals and reports, including prepaids reclass journals, inventory reclass journals, monthly payroll journals, quarterly vacation accruals, and prepaids analysis reports, etc. Most of the Alteryx process automation and improvements are applied to global entities, and it will have one journal upload file for all entities. This have saved at least 1.5 days in month end close for the team.
  • Have found CNY 3m (~AUD$66k) severance expenses missing per P&L variance analysis for China entity and finally booked this large lump sum expense in and sort out miscommunications between China office and HR.
  • Have spotted wrong payroll information provided by the Global tax team, and therefore have helped the Company avoid penalties for missing ACT and WA payroll tax lodgments and payments.
  • Have leaded the APAC Finance team successfully complete dual month end closes on time at the time of acquisition, especially the dual closes were under a short notice period (1 day before month end) and within a tight timeline (5 days for both closes).
  • Have been a leader in global software capitalization project, collaborate with IT department manager to work out internal and external costs capitalization data inputs, built up capitalization calculation model, and maintain documentation and postings. This have ensured the data integrity and accuracy in the HQ reporting.
  • A driver in developing and implementing the Company Global Prepayment Policy, including
    improving efficiencies in prepaid bills data entry, review, and reconciliation process.
  • Built up an automated and dynamic KPI Summary report that links to the budget model, and it has
    helped APAC CFO to get updated KPIs when drivers are adjusted, and this has improved our
    process to have top-down and bottom- up data reconciled.
  • Automated Sales Budget Control file via Excel, splitting monthly budgeted sales revenue into weekly
    numbers to align with the weekly sales meeting. This has improved sales target delivery
    communications and has reduced their time in manually splitting the target.
  • Used Excel to automate the Budget variance analysis report for APAC region, which saves at least 3
    hours in the month-end workload
  • Spotted GST tax and invoice template issue when the Company transitioned to NetSuite, and
    therefore have helped billing team reduced customer cases and increased customer satisfactory

Timeline

SENIOR FINANCIAL ACCOUNTANT

Laing O'Rourke
06.2023 - Current

SENIOR ACCOUNTANT

Datto Asiapac Pty Ltd
04.2019 - 06.2023

FINANCIAL ACCOUNTANT

Look Corporate Pty Ltd
11.2016 - 04.2019

ACCOUNTANT

Hill-Rom Australia
09.2016 - 11.2016

ACCOUNTS ASSISTANT

Australia Sunny Glass Group Limited (ASX listed)
03.2015 - 08.2016

Certified Practising Accountant ANZ

CPA Qualified (2015)

Monash University - Melbourne

Master of Banking And Finance (2010)

Monash University - Melbourne

Bachelor of Professional Accounting (2009)
Di Lu, CPA