FAY AUBREY

Working in an agile environment in the Business Intelligence team at One New Zealand. Build and develop reports for critical business information to enable data driven decision making.

• Member of the prepay migration squad (migration of prepay customer base from Surepay to Matrixx)
• Collaborate with stakeholders to understand the business requirements and translate this into Power BI dashboards and reports
• Creation of reporting views in Snowflake using DBT for use in Power BI
• Develop Power BI dashboards using DAX and Power Query
• Source to target mapping
• Build new logic and recreate from existing reporting to combine data from various sources
• Create documentation and implement refresh schedules

Support the Finance team by delivering robust end to end data quality across the finance function

• Development of Qlik Sense and Qlik Nprinting reporting / dashboards to support financial decision making, operational efficiency and identifying areas of improvement
• Qlik & Nprinting management – licensing, system upgrades, task scheduling, user administration, certificate renewals
• Produce quality data driven insights and reports – used by leadership team and various internal stakeholders
• Implement and maintain system health checks during key finance periods
• Resolve data and reporting quality issues
• Provide coaching to members of the finance team on Qlik usage
• Project manage automation of large supplier invoice ($13m/month) transfer from FTP into Qlik Sense
• Project manage the migration of the external commission's system from Callidus to Incent and decommission of old system
• Design and create end to end automation for monthly journal processing using Qlik Sense & Nprinting

Leading a team of three to ensure that all payments are made in an accurate and timely manner as well as providing end to end support on the payment process

• Managing the end-to-end payment process
• Provide support to the treasury team regarding daily cash management, cashflow forecasting and hedging
• Ensuring processing of payments follow the relevant policies and control guidelines
• Completion of tasks associated with all aspects of payments including remittance advice checks and resolving payment queries
• Managing internal bank transfers - ensuring Vodafone New Zealand has sufficient funds to make payments from correct accounts
• Implementing new processes and procedures to increase efficiencies within the team

Support the Commissions manager in all aspects of the design and administration of commission plans for Internal Sales professionals aligned to both Consumer and Enterprise segments

• Support sales management with complex queries and driving change when required by performing scenario analysis/UAT and signing off new schemes or changes
• Oversee the payment calculation process to ensure accurate and timely payment of Commissions in compliance with sales commission schemes and business goals
• Develop process improvements and data input automation for robust and consistent calculations
• Provide insightful reporting and analytics to enable sales leaders to monitor and identify themes and better drive sales performance
• Contribute to the governance process for decision making, dispute resolution and scheme change requests
• Attend monthly board meetings with sales management and make recommendations, presenting necessary analysis, cost modelling or other data to support decision making
• Accurate forecasting of commission payments and accruals
• Development of quarterly performance dashboards for all segments

Accountable for ensuring the scheme design delivers the necessary sales results from accurate and timely payments, tight governance controls and providing insightful and meaningful reporting and analytics

• Manage the end-to-end calculation process to ensure accurate and timely payment of sales commission in compliance with retail sales commission schemes and business goals
• Analyse data inputs necessary to perform calculations ensuring all controls and reconciliations have been completed
• Design and develop process improvements and automation wherever possible for robust and consistent calculations
• Establish clear and simple reporting with analysis and insight to facilitate the approvals to be gained from management and to communicate final payments to sales professionals

Daily treasury activities in compliance with Group Treasury policy. Calculating and monitoring member rebate payments and assisting in the management and communication around other member funding arrangements

• Manage debt facilities and daily cash requirements
• Liaise with debt providers to monitor and manage the terms of contractual agreements
• Manage terms loans, interest rate swaps, overnight borrowing and deposits
• FX hedging - ensure cover is in line with FX policy, manage foreign currency accounts, participate in monthly meetings to discuss FX requirements for the business
• Collating and calculating rebates, performing variance analysis to ensure reporting accuracy
• Preparing quarterly statement for members (400+) and arranging annual payout and associated journals
• Single Point of contact for all rebate queries
• Process monthly member loan interest charges and funding
• Hold monthly discussions with retail accounting to ensure charges are in line with expectations
• Prepare full financial accounts for the company pension fund
• Arranging loans, prepare board report for trustees, all journals and payment of expenses
• Regular contact with payroll and external parties to gather employee contribution data and share investment information
• Prepare monthly board reports for FX and debt
• Monthly GL Reconciliations
• Responsible for ensuring the company has adequate funding, interest charges and fees are paid on time
• Assisted building the company weekly cash flow forecast
• Performed mass reconciliation between two systems during merger (warehouse sales data to SAP) to ensure accuracy of sales data for calculating rebates

A contracted member of the University's accounting team specialising in Fixed Asset Reconciliation

• Project planning
• Asset reconciliation across the University group for attractive assets, financial assets and lease register
• Thorough investigation of unmatched items and identification of unrecorded retirements
• Validation of assets book value for audit purposes
• Held meetings with department heads to resolve discrepancies and assist with reconciliation planning
• Ensuring complete accuracy in preparation for external audits
• Delivering full reconciliation on time and within accounting frameworks
• Production of clear and comprehensive workbooks with active links to back up documentation to facilitate and streamline future reconciliations

This role involved capital expenditure reporting and analysis as well as Corporate Support for budgets, forecasting and reporting

• Lead discussions with GMs to assist financial management of business units
• Provide performance analysis and variance reports for Corporate Support
• Complex general ledger reconciliations
• Preparation of annual budgets and capital expenditure
• Held meetings with department heads to work through annual budget preparation
• Worked with various departments to assist with business case preparation for review by leadership team.

Three years of accounting in the private equity industry.

Moving from accounts payable to assistant management accountant

• Reconciliation of balance sheet accounts, month end and general ledger journals
• Sole responsibility of SVG Capital's and the SVG Group subsidiaries accounts payable process including companies in Singapore and Boston
• Preparation of monthly management accounts for SVG group subsidiaries
• Organisation of payments in various currencies via CHAPS, BACs and cheque
• Maintain adequate funds in the current accounts and transfer surplus to deposit
• Organisation and implementation of the entire BACs process from entering invoices into SUN to preparation of documents for authorisation in bankline

Working for this UK company involved everything from transactional coding to accounts payable to obtaining purchasing authorisations

• Entering transactions to the accounting system
• Assisting with weekly cheque and BACS runs
• Receiving supplier statements and reconciling them to accounts payable
• Processing of high volumes of invoices across the entire business

• One-to-one nutrition and wellbeing consultations
• Reception and administrative tasks involved in the operation of a fitness facility
• Customer service - both face to face and over the telephone

• Development and implementation of entire nutrition section of 90 Day Challenge
• One-to-one consultations to develop personal eating plans and strategies for diet
• Utilisation of a food composition database (Foodworks) to analyse meal plans
• Creation and facilitation of regular nutrition seminars to promote healthy eating