CELESTE LUNA-AREVALO
South Wentworthville,NSW
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
22
22
years of professional experience
Work History
SENIOR BUSINESS ADVISOR
ENERGY AND CLIMATE CHANGE
03.2022 - Current
- Prepares budget control for current and forward years to ensure accurate reporting and mitigate budget limit risks
- Coordinates overall Office of the Deputy Secretary portfolio, monthly and ad hoc reporting requirements and other Treasury requests
- Review and control point of numbers in presentation and budget papers, audit queries, year-end returns, stocktakes, etc
- Collaborates with stakeholders to identify business needs and data sources
- Oversees budget allocation to OECC - 3 areas and reconciliation to PRIME budget
- Lead in educating the business on fundamental knowledge in using MyOutcomes for their financial and reporting needs
- Lead in systems implementation of ECCS own & new company code
- Key contact point for informational requests from little Treasury stakeholders, traditional Treasury Energy support team and DPE Corporate Services team as part of SLA delivery
- Coordinates and consolidates required information from ECCS/EnergyCo/CCF Admin and provides/presents to relevant stakeholders
- Provides consolidated OECC commentary as required
- Oversees preparation and coordination of OECC HFN, Senate Estimates notes
- Creates and provides timetable for key deliverables to the respective OECC teams
- Responsible for coordination of OECC risk register completion.
FINANCIAL ANALYST
DEPARTMENT OF PLANNING AND ENVIRONMENT
04.2018 - 02.2022
- Prepare and update performance reporting and monthly forecasting analytical models for divisions, entities, and cost centres to support an effective review of business performance and ongoing forecast processes
- Identify, provide recommendations, and implement agreed reporting and process enhancements to ensure desired business outcomes for stakeholders are achieved
- Assist with the preparation of the annual budget to facilitate the allocation of funding in line with corporate goals and Government objectives
- Provide other required analytical support services to respond to client requests and support business case development and decision making
- Prepare and finalise accurate and detailed budgets, accounts, and management reports in a timely manner to meet corporate and the internal business customer requirements
- Build the confidence and support of stakeholders, clients, and peers to manage diverse and frequently urgent and competing business requests and demand deadlines in a complex, demanding environment of significant change
- Complete other duties under direction.
SENIOR ANALYST
COCA COLA AMATIL
07.2017 - 01.2018
- Provides effective and insightful financial and operational advice as well as support to senior Australia Beverages Leadership in order to enable timely and valuable decision making
- Support the BP&A manager by assisting with the preparation of financial analysis used in these meetings
- Assists with analysis and reports used for quarterly business reviews with key stakeholders
- Produce value-adding analysis of, and commentary on, monthly and quarterly financials of key stakeholders with a primary focus on the analysis and explanation of variances against budgets and forecasts
- Assists with the completion of ad hoc analysis and projects to support management team.
FINANCE ANALYST
ZURICH FINANCIAL SERVICES AUSTRALIA
06.2016 - 12.2016
- Support the program manager with timely and appropriate financial information to ensure accurate reporting on forecast vs actuals on a monthly basis
- Assists with the creation of cost-benefit analysis and business case for the program
- Work closely with the expense team to understand the BAU expense position, identifying expense overruns and agreeing actions with executives to get back to target
- Responsible for creating, running and checking the team's data extracts out of insurance and financial systems for the program and individual initiatives
- Provide analytics and insights of the data for various initiatives for further investigation to find improvements to drive expense reduction
- The ‘go to' point of reference within the Planning and Performance team for benefit tracking and analytics associated with the project
- Critical thinking of scenarios and sensitivities that will/could impact the benefit realization of the program and its initiatives
- Month-end closing activities such journals and accruals preparation, cost recoveries and allocation to various cost centres.
SENIOR FINANCE ANALYST
CITIBANK SINGAPORE, CPB AP TECHNOLOGY
08.2012 - 05.2016
- Preparation, tracking and review of monthly business performance with analyses as compared to forecast and budget, variance analysis with commentaries to effectively support ongoing forecast for multiple cost centres
- Review of the company's financials and other reports to predict current and future financial performance
- Improves financial status by analyzing results and variances; identifying trends and recommending actions
- Identify cost savings, risks and opportunities to improve financial performance
- Performing various adjustments to the forecasts and reports any material variances to senior management when deemed necessary
- Reconciling of transactions by making data comparisons, adjustments and corrective actions
- Preparation of financial deck for Senior Management with month over month, YTD and FY analyses and commentaries
- Preparation, calculation, submission and monitoring of accruals for Asia and globally managed cost centres with ageing analysis and YTD balances.
ACCOUNTANT
AVIATION & ELECTRONICS SUPPORT PTE LTD
06.2012 - 08.2012
- Regular monitoring of Internet Banking for inward remittances and updating of Cash Book
- Preparation of AR invoices, payment vouchers, cheques and TT remittance applications (outward)
- Monitoring of cash book to ensure there is enough cash for disbursements
- Preparation of debtors aging analysis and SOA
- Preparation of suppliers aging analysis and SOA
- Preparation of monthly GST report for submission to IRAS
- Recording of Petty cash vouchers, payment vouchers, inward/outward TT remittances, suppliers' invoice, journal vouchers to transfer input/output tax to GST Control account in the GL.
ACCOUNTANT FINANCIAL SYSTEMS/AR BILLING
INTTRA PTE LTD
09.2011 - 05.2012
- Preparation of accounts reconciliation and billings (invoices) for non-shareholder carriers and other types of carriers
- Preparation monthly invoices
- Management and recording of billings and cash receipts to MAS500
- Updating of payments into IOL
- Preparation of weekly payment trend reports
- Preparation of A/R schedules, accrual and deferred revenue
- Preparation of monthly revenue recap
- Preparation of journals/accruals for Alliance Partners and computation of payments and commissions
- Runs the SQL to pull out the data needed for month-end closing
- Administers various financial systems such as MAS500, Concur and eRequester
- Performs data import in Prophix during month-end close and/or as required
- Preparation of monthly exchange rates for circulation
- Assists in preparation of audit schedules, documents and reports
- Performs ad hoc requests and reports.
ACCOUNTANT
LLOYDLUNA COMMUNICATIONS
08.2010 - 07.2011
- Preparation of billings to the clients
- Recording of cash receipts and cash disbursements
- Monthly cheque & voucher preparation
- Monitoring of cash book balance
- Preparation of debtors aging analysis and Statement of Account
- Preparation of suppliers aging analysis and Statement of Account
FINANCIAL ANALYST
ACS, A XEROX COMPANY
03.2007 - 07.2010
- Analyzes complex financial data and prepares monthly reports for 3 Divisions comprises of an average of 20 Business Units each division, as a support for effective management and decision-making across the organization
- Provides financial analysis support to the Regional Controllers involving month end closing activities
- Analyzes financial statements and monthly reports, tracking and monitoring expenditures with analysis versus the approved budget, financial and expense comparison, variance analysis and P&L review, responsible for a variety of financial functions such as budgeting, auditing, and forecasting and analysis
- Develops and implements new techniques & templates to expedite financial information analysis
- Consolidates the annual and quarterly budgeting plans
- Provides analysis on business development and monitors business performance by Business Unit
- Performs monthly booking of accruals and deferrals
- Prepares monthly Summary P&L analyses with graphs for 3 Divisions with an average of 20 Business Units each
- Prepares weekly flash report of the 3 Divisions for review of respective LOB Controller as a tool of monitoring and planning each Business Unit's revenue and expenditures
- Prepares monthly adjusting & reclassifying entries
- Performs month end close activities like Journal Entries, Balance Sheet reconciliations, Expense and Telecom Trackers, 10K P&L format, Summary P&Ls and other tasks/reports as needed and requested by the Controllers.
ACCOUNTANT
PILIPINAS SHELL PETROLEUM CORP
08.2006 - 03.2007
- Handles various Human Resources balance sheet accounts reconciliations such as Other Investments accounts, Receivables, Payables, Prepayments, Provisions, Group Hospitalization Plan, and Out-patient benefits for the company's employees.
ACCOUNTANT
PROVOCATEUR WORLDWIDE
02.2006 - 08.2006
- Handles full sets of accounts and accounting cycle functions
- Payroll preparation, product costing and inventory management
- Financial Statements preparation
- Budgeting and forecast preparation
- Various Human Resources and administrative tasks.
ACCOUNTANT (ACCOUNTS RECEIVABLE/ACCOUNTS PAYABLE)
PWC PHILIPPINES
01.2002 - 02.2006
- Ensures the completeness and accuracy of all billings to clients and timely recording of collections
- Reconciles billings and collections of Home Office and Branches
- Ensures accurate and timely recording of Inter-office billings and collections
- Prepares aging of Accounts Receivable
- Monitors clients outstanding accounts and prepares schedule of past due accounts for write-off approval
- Ensures accurate recording of offsetting, credit/debit memo
- Monitors and checks all summary of collections sent by the branches as compared with the updated passbook and deposit slips
- Preparation of monthly Statement of Accounts for clients
- Coordinates with the clients with regard to their outstanding balances and past due accounts
- Ensures appropriate and timely recording of Accounts Payable and Advances to Employees for both Home Office and Branch
- Recording of medical expense and credit card charges of partners and staff, expense report, liquidation, and other related tasks
- Recording of expense reimbursements of partners, managers, and staff
- Preparation & recording of Journal Vouchers/Adjusting & Reclassifying entries.
Education
Part Qualified Accountant (CPA Australia Member ID 10200641) Certified Public Accountant -
Institute of Certified Public Accountants
Public Accountants Reg. No. 137542 -
Bachelor of Science - Accountancy
2000
Timeline
SENIOR BUSINESS ADVISOR
ENERGY AND CLIMATE CHANGE
03.2022 - Current
FINANCIAL ANALYST
DEPARTMENT OF PLANNING AND ENVIRONMENT
04.2018 - 02.2022
SENIOR ANALYST
COCA COLA AMATIL
07.2017 - 01.2018
FINANCE ANALYST
ZURICH FINANCIAL SERVICES AUSTRALIA
06.2016 - 12.2016
SENIOR FINANCE ANALYST
CITIBANK SINGAPORE, CPB AP TECHNOLOGY
08.2012 - 05.2016
ACCOUNTANT
AVIATION & ELECTRONICS SUPPORT PTE LTD
06.2012 - 08.2012
ACCOUNTANT FINANCIAL SYSTEMS/AR BILLING
INTTRA PTE LTD
09.2011 - 05.2012
ACCOUNTANT
LLOYDLUNA COMMUNICATIONS
08.2010 - 07.2011
FINANCIAL ANALYST
ACS, A XEROX COMPANY
03.2007 - 07.2010
ACCOUNTANT
PILIPINAS SHELL PETROLEUM CORP
08.2006 - 03.2007
ACCOUNTANT
PROVOCATEUR WORLDWIDE
02.2006 - 08.2006
ACCOUNTANT (ACCOUNTS RECEIVABLE/ACCOUNTS PAYABLE)
PWC PHILIPPINES
01.2002 - 02.2006
Part Qualified Accountant (CPA Australia Member ID 10200641) Certified Public Accountant -
Institute of Certified Public Accountants
Public Accountants Reg. No. 137542 -
Bachelor of Science - Accountancy
Similar Profiles
DAKSH RAJPALDAKSH RAJPAL
Data Analyst Intern at Vasudha Foundation, NGO (Renewable Energy and Climate Change)Data Analyst Intern at Vasudha Foundation, NGO (Renewable Energy and Climate Change)
MERCELINE OLALAMERCELINE OLALA
Project Manager-WASH at Ministry of Water, Sanitation, Environment, Energy and Climate Change-Homabay CountyProject Manager-WASH at Ministry of Water, Sanitation, Environment, Energy and Climate Change-Homabay County
Sophie Yule-BennettSophie Yule-Bennett
Director of Policy and Governance at Energy UnlockedDirector of Policy and Governance at Energy Unlocked
Gabbriel VillafrancaGabbriel Villafranca
Business Banking Associate at Commonwealth BankBusiness Banking Associate at Commonwealth Bank
NIDHIMA NIDHIMA null
Accounting Intern at 111 Accounting & Taxation Pty LtdAccounting Intern at 111 Accounting & Taxation Pty Ltd