Gavin Lim Email & Phone Number

Melbourne, Victoria, Australia

Melbourne, Australia

• Responsible for end-to-end SAP payroll functions for the organisation – generating fortnightly payroll, rectifying time evaluation, payroll accounting errors and STP errors, creating bank files, generating payroll.
• Hands-on experience with system enhancements in SAP payroll systems to meet legislative, superannuation, Police EBA and VPS EBA changes. Duties include interpreting new requirements, preparing business request.
• Reconciling EOFY STP and PAYG, including ATO lodgement and answering tax queries
• Answering to emails via the PBEA inbox, including end of service tax, superannuation, allowances, absences, deductions, salary sacrifice (novated lease, superannuation and remote area benefits), costing analysis, cost.
• Preparing audit data for internal auditors, external auditors and VAGO
• Supporting leave liability provisioning solutions, including preparation of monthly Recreation Leave and Long Service Leave liability reports for Finance

London, United Kingdom

• Reported to Hospital Concession Financial Controller, working closely together with Hospital Concession Financial Analyst
• Updated six hospitals’ budget files for the Hospital Concession
• Helped Financial Analyst to produce end of month financials for 2 hospitals – P&L, Balance Sheet and Cash Flow reports
• Performed variance analysis and commentary on the above end of month financials against budget/forecast and liaised with the Hospital Accountants on any discrepancies
• Prepared monthly IFRS P&L and Balance Sheet for the Group Financial Analyst, including variance analysis and commentary

London, United Kingdom

• Populated all monthly reporting excel databases using SAP queries and data received from various sources, e.g. M&S Money
• Prepared monthly reporting packs, including variance analysis and investigation of anomalies
• Generated monthly KPIs, including collection of data from different sources
• Helped regional managers to prepare detailed quarterly retail reporting pack
• Handled day-to-day queries from the Group Retail Finance team, regional financial controllers and store managers
• Performed ongoing maintenance of all reporting databases

Melbourne Area, Australia

• Generated variance analysis and commentary of end-of-month financials and monthly forecasts to the Directors
• Prepared the annual budget using Excel models with macros
• Liaised with the banks on investment of daily surplus cash
• Prepared and lodged BAS/GST, FBT returns, Income tax returns, monthly & annual payroll tax returns
• Other administrative duties included annual insurance renewal, maintenance of supplier & customer databases, completion of surveys conducted by ABS

Melbourne Area, Australia

• Prepared end-of-month financials, Quarterly P&L, Balance Sheet review pack, including variance analysis and commentary, for the US headquarters (from expense accruals to upload of final results to Oracle) in accordance.
• Prepared quarterly forecasting and annual planning processes in AUD and USD with detailed variance analysis
• Developed and streamlined financial models, including financial uploading models and budgeting models
• Generated internal management reporting, weekly sales reporting, and monthly management packs, with trend analysis and waterfall sales charts
• Processed weekly and monthly payroll, prepared annual payment summaries
• As the primary contact for external audits and internal audits

Singapore

• Reported monthly financials to Pharma headquarter in Basel
• Prepared monthly management reports for Pharma headquarter and Business Unit Managers
• Performed sales, volume and margin analysis using COGNOS Powerplay
• Prepared quarterly forecasts for the regional office
• Ran monthly payroll for Pharma and Asia Pacific office (about 80 FTEs) and lodged statutory returns
• Performed Actual vs. Budget variance analysis for Asia Pacific Regional Office

Singapore

• Solely responsible for bookkeeping, account reconciliations, and GST returns
• Compiled annual budgeting and presented management reports to Directors
• Developed and implemented accounting policies and procedures
• Liaised with external auditors for year-end audit
• Calculated job costing of sub-contracted works