Andrew Coleman Email & Phone Number

New Plymouth

Key Activities:Financial Reporting • Preparation and review of Monthly Management reports when required • Preparation and review of Annual and Interim Statutory Accounts • Preparation and review of Electricity and Gas Regulatory Disclosure Financial Statements • Preparation and review of Annual Budget and Quarterly Forecasts Audits• Operational lead with auditors dealing with queries and resolving issuesProvide technical accounting and regulatory reporting expertise• Understanding of the Information Methodologies (IM’s) thereby assist in providing accounting and regulatory support to business• Provide advice for accounting treatment in relation to the applicable International Financial Reporting Standards (IFRS)• Provide advice to Internal Stakeholders (including EMT)• Provide financial analysis as requested• Understand the key information requirements of the Regulator and apply judgement to obtain optimal outcomesRegulatory Asset Base (RAB)• Management and monitoring of key information systems that support the RAB• Ensuring that the Regulatory Asset Base (RAB) is accurate, by engaging in continuous improvement activities• Minimising the manual processes to gain efficiencies and improve data quality and accuracy• Ensure documentation is maintained to support production of annual RAB disclosures

Taranaki, Wanganui & Manawatu, New Zealand

Key Activities• Preparation of annual budgets, forecasts and reports to support the Business Plan (at both the Powerco Group and PNZHL Group level).• Preparation of regulatory financial reports, including Information Disclosure reports (in conjunction with the Group Corporate Accountant) and internal regulatory reports (in conjunction with Regulatory Department).• In conjunction with the Group Corporate Accountant, preparation of monthly financial results.• In conjunction with the Group Corporate Accountant, preparation of annual and interim financial statements

New Plymouth

Key Activities:• Provide Oracle financial system support and guidance to Finance Department, Material Management Unit and other dependent operating managers • Be the liaison between TDHB staff and the Oracle financial management system host to resolve problems, and investigate potential improvements• Maintain accurate monthly financial reports• Assist in forecasting and budgeting• Analyse business opportunities and weaknesses• Prepare costings for capital expenditure and business case analysis as may be required• Impromptu report writing and generation• Provide backup support to fixed asset accounting• Investigate and respond to ad hoc inquiries• Maintenance and updating of the Asset Management Plan

New Plymouth

Key Achievements:• Fully reconciled two previously un-reconciled goods receipted but not invoiced accounts (13 years of data) and closed out old open purchase orders• Implemented an automated multi period accounting application for prepayments • Utilised the Oracle financial system to pay international invoices

New Plymouth

Key Activities:• Designed, developed and supported 300 financial and non-financial reports for senior and middle management (in the areas of maintenance, finance, procurement, inventory, contracts, engineering etc.) that have streamlined and automated processes, reduced report generation time and provided greater transparency to the business allowing for enhanced and timely decision making• Continual review and assessment of the information provided by Oracle to ensure that it continued to meet the changing needs of management and the business• Co-ordinating and resolving Oracle related technical issues between the business and Group Financial Services and the Oracle Solution Centre in Adelaide, Australia• Utilising data loaders to load large amounts of data into Oracle in a timely, efficient and accurate manner• Manager of the Accounts Payable team (2 – 3 employees)• Supported and streamlined the statutory account process for the three years to 30 June 2015Key Achievements:• Implemented an invoicing process where costs could be recharged to the Australian operations• Increased the on-time payment of invoices by 60 percentage points to around 90% by implementing a new system (SharePoint based Invoice Tracker) & redefining business processes• Documented, analysed and understood all the related party transactions between the various NZ subsidiaries & the Australian Parent companies• Successfully implemented a maintenance based contractor time keeping software package (internet based Daily Work Requests - Microsoft Silverlight technology)• Designed and implemented a finance rulebook after consultation with the business• Project managed for the NZ business during 2008/09, the implementation of a new R12 Oracle operating unit. This included functional / technical support and co-ordination, training co-ordination and data mapping and migration• Project managed (2008) for NZ the integration of the Swift assets into Origin’s existing Oracle eBusiness Suite

New Plymouth

Key Achievements:• Month end and year end reporting, budgeting and forecasting activities• Implemented Oracle Financials into the NZ subsidiary. 15 months fulltime (2007/08) with approximately seven months spent in the Houston head office• Established the NZD ledger in the prior accounting system to Oracle and reconciled the amounts used on prior year tax returns as the functional currency was USD• Development of a USD average cost inventory system to run parallel with the existing NZD based inventory system (Maximo), in conjunction with IT• Development of internal control Sarbanes-Oxley (SOX) procedures

Eltham, Taranaki

Key Achievements:• Prepare monthly financial accounts• Supervise four direct reports (review work, distribute work and solve problems)• FY03 & FY04 Budget model• Prepare year-end audit file• Billing errors and discrepancies• Non-conforming & mouldy product• Develop CSUVAR & SOCIP report• Develop fixed/variable overhead report• Develop site summary report• Develop a budget/actual volume mix report• Review cost roll, BOM (bill of material) changes & new product costings• Standardise general ledger accounts to “Inform” & alter folio reports• Taxation considerations• Estimated month end result• Combining the Mainland Eltham & Pastoral Foods operation• Miscellaneous reports and requests

Eltham, Taranaki

Key Achievements:• Maintain and regularly update the Company’s costing model• Assist with the annual budget round• Maintaining the New Zealand Dairy Board GPR system• Assist others in preparing indicative costings• Answering costing queries from local and overseas in-market companies in addition to those from the category team• Assist in the preparation of month end accounts and liaising with the team leaders over its implications• Maintaining the fixed asset register

New Plymouth

Key Achievements:• Completion of year end and interim accounts• Completion of GST returns and cash flow reports• Budgets• Resident Withholding Tax reconciliation’s• FBT returns• School Accounts

Chartered Accountant (Ca)

Bachelor In Business Studies (Accountancy), Accountancy

Postgraduate Diploma In Professional Accounting

Education record