Alistair Macdonald Email & Phone Number

Auckland, Nz

Auckland, New Zealand

Auckland, New Zealand

Christchurch, Canterbury, New Zealand

Having just implemented SAP HANA, there was a need to access information faster. Accessed data sources in SAP HANA, SAP BW and online then architected a data cube. Worked collaboratively with Finance to understand financial pressure points and designed reporting that gave insights from the margin and inventory. To ensure smooth integration, led training sessions, giving super users insight into PBI, sources of report data, and critical SAP transactions. Followed up with Power BI tips and tricks to make reporting much easier. Finance teams were enabled to uncover business performance problens and build on reconciled BW data.

Auckland

There was an urgent need to retire SAP BW. Development of USA packhouse reporting was needed to calculate commissions. Worked with Snowflake developers and USA business managers to get accurate data. Was then asked to help with NZ gross margin reporting. Re-development was successfully used nationally.

Melbourne, Victoria, Australia

With difficulty understanding business performance, work was undertaken alongside IT to identify SAP data sources, and a reporting cube was established for Finance team covering margin, inventory, capex, pricing, and cost centre reporting. Ensured adherence to Finance currency reporting policy for reconciliation of data to month end packs. Produced training material and rolled out in Australasia and SE Asia. PBI reports improved business performance and understanding of month end, alongside faster, more detailed construction of leadership and board packs. Success was measured by report usage and presented to Steering Committee meetings.

Auckland, New Zealand

Inventory reporting, development of margin reporting and other useful leasing reporting

Auckland, New Zealand

- Pulling together branch/head office transfer pricing on Power BI at transactional level.

East Tamaki

All reporting needed using Power BI from Dynamics 365 BYOD including:- Profit and Loss reporting - drill down customer/product to voucher level- Fixed assets reporting - breaking down all fixed assets into build specifications- Inventory reporting - breaking inventory down to understand cost of equipment build- Warranty reporting - enabling repairs and claims to be controlled- Clearing accounts - understanding uncleared amounts and giving a process and tools to better control accounts

Auckland

- Debtor reporting - using data from old and new systems to understand debtor profile.Building app to enable reconciliation and control of clearing account. Built on Dynamics 365 Cloud BYOD using Power BI and using inventory settlement process.- Warranty app to help control warranty claims. Could easily identify approximately $2M in missing claims.

East Tamaki

• Developed a performance reporting framework (Power BI/Data warehouse) for the business by breaking down the business (revenue to EBIT) to be reported to Haier. Prior to arriving FPA had spent several years trying to put thi in place. Within 6 months of arriving, had developed an Excel prototype and implemented a Power BI data warehouse solution.• Development of a gross margin base for the monthly forecast and actual by customer and product for North America, NZ and Australian business. The forecasting system gave the business the ability to communicate how it had performed against its plan.• Using the data warehouse, trained on how analysts can communicate business performance issues by pulling apart margin performance. Gave decision makers a clear guide on what needed to be done to improve business performance.

Parnell Auckland

• Setting of credible Gross Margin target - monthly and weekly. Forecasting daily demand, sales and gross margin by catalogue, channel and market. Both gained agreement, and provided transparency on, forecasted sales to the Owners (Woolworths) Executive Team, Demand Planning, Call Centre and Marketing Insights.• Forecasting and reporting of Commercial Investment - giving the business a better understanding of marketing spend and where it can improve its performance. • Provide commercial insight on sales performance to gross margin (by product and customer). Giving the business a simple to use tool to understand margin performance.• Give the business a better understanding on inventory performance. How new current stock is, its sell through, quantity per sku, and when it was last advertised.

Auckland

Manager Analytics and Reporting Solutions 01/2014-06/2014Manager Reporting Standards Solutions FACT project 03/2013-12/2013 Business Specialist Finance and Data VSO Project 11/2011-02/2013Performance Systems Manager 01/2010-10/2011Core Systems Reporting Manager 09/2007-11/2009Contribution Margin Manager 05/2005-08-2007Contribution Margin Business Lead 04/2004-04/2005Business Process Analyst 05/2003-03/2004 COMMERCIAL LEADERSHIP• Led development of transfer pricing methodology for NZD12 billion revenue business. • Fonterra’s ability to report inventory values, customer and product margins and milk prices were continued with few disruptions. BUSINESS IMPROVEMENT• Business improvement with a reduction of reporting by two thirds and removed confusion from a business user base of 300+. • Migrated 300 + users from SAP BW to Business Object 4.0. Worked with change management and finance departments to ensure change was clearly communicated.• Reduced Global inventory reporting team from 4 to 1. Led the development of a Global Inventory reporting (revaluation, NRV, stock profit) system. CHANGE MANAGEMENT• International BW/BO4 training moving from Excel based reporting. Managed the development of international training material for margin analysis and trained on location in Singapore, Germany, USA, Mexico, Japan, China and New Zealand. PROJECT MANAGEMENT• Project managed the contribution margin reporting system. - sales >NZD10b.• Project managed reduced financial forecasts from 3 months to 1 day. • Project management of KPI dashboard for leadership team was used for monthly meetings for 3 years.

• Accounts receivable and payable. • Worked through tax and legal requirements for setting up companies to operate offshore.• Produce financial plan and forecasts.• Produce financial reporting to Board - profit and loss, balance sheet and cashflow.

• Commercial business plan for advertising and website hosting functions of Fencepost.com.