Andrew Cooke

Experience

• 

  Smith Hancock

  Feb 2005 - May 2006

  Intermediate Accountant

  • Preparing GST returns• Bookkeeping; bank reconciliations, general journal entries, tracking sales & purchases• Australian Securities and Investment Commission (“ASIC”) form lodgments• Convening meetings of company creditors/members (incl. drafting minutes)• Prepare investigation reports to ASIC pursuant to the Corporations Act• Preparation of Cash flow forecasts & budgets (voluntary administrations)• Assist in the preparation of various contracts• Liaise with Solicitors, Banks, Lease/Finance Companies, Insurance Companies, Company Creditors, Federal and State government departments Show less

• 

  Pitcher Partners

  May 2006 - Jul 2007

  Intermediate Accountant

  • Preparing GST returns• Bookkeeping; bank reconciliations, general journal entries, tracking sales & purchases • Australian Securities and Investment Commission (“ASIC”) form lodgments• Convening meetings of company creditors/members (incl. drafting minutes)• Prepare investigation reports to ASIC pursuant to the Corporations Act• Preparation of Cash flow forecasts & budgets (voluntary administrations)• Assist in the preparation of various contracts• Liaise with Solicitors, Banks, Lease/Finance Companies, Insurance Companies, Company Creditors, Federal and State government departments Show less

• 

  BNP Paribas

  Jul 2007 - Apr 2012

  Duties /Tasks performed include:Design, documentation and implementation for • General accounting processes • Bank ledger system (MIDAS) • Regulatory reporting model to Australian Prudential Regulatory Authority (SAP Business objects and Excel modeling) • Client profitability modeling (Excel) • Financial & Management reporting (SAP Business objects, Hyperion Essbase, Excel) • Forecast/budget models (Excel)Additional tasks • Provide ad hoc support & training to local business partners for reporting (SAP Business objects, Excel) Show less Recurring monthly tasks • Calculating revenue and expense accruals• Reconciling closing account balances• Converting and loading base accounting data into global financial and management reporting systems• Prepare, analyse and distribute revenue and expense reports to managers • Preparing GST returns (VAT equivalent)• Providing adhoc support and information to operations staff (sales team, risk management, operations teams)Other tasks• Short term and long term cash flow projections• Preparing budgets and forecasts• Ad hoc reports as requested from management• Local annual statutory statements• Local regulatory reporting to government departments Show less

  • Accountant & Project Manager, Management Reporting

    Jun 2011 - Apr 2012

  • Accountant, Management Reporting

    Jul 2007 - Jun 2011
• 

  The Linde Group

  Aug 2012 - Dec 2016

  Financial Analyst

  Reporting & planning analysis including advice, training and support for • Americas geography• Merchant & Packaged gases business segmentMethodology, processes & tools and training support for • “High Performance Organisation" measurement (Productivity and Pricing management concepts)• Mid-term modeling of KPIs of Linde Group for communication to capital markets (Sales, EBITDA, Cashflow, ROCE, S&P/Moody’s rating estimates)• Global Sales reporting• FX Modelling conceptsProvide support as a technical expert on processes and tools (Excel, VBA, PowerQuery et al) supporting/defining global standard tool sets and processesAdvice and training support for global financial systems (SAP based systems) Show less

• 

  Lincare Holdings, Inc

  Dec 2016 - Jan 2020

  Senior Analyst Finance Projects and Investments

  > Various project development, implementation and support including: • Financial Data warehouse implementation (incl. training & development of team individuals) • Price/Volume modeling • Savings tracking model • Budgeting model • Scenario and Profitability modelling for Medicare Competitive Bid> Implementation of Tableau BI software for finance (data structure and reporting)> Providing support to Finance teams with tool/process automation for specific topics > Training, support and advice for advanced use of Microsoft office tools (Excel, VBA, PowerQuery) Show less

• 

  Linde

  Jan 2020 - Dec 2022

  Manager Reporting & Analytics

  Project development, implementation and support including: • Cylinder Delivery Data Lake + Reporting (Production, Scheduling, Transport, Stock, DIFOT, Cost to Serve) • Bulk Delivery Data Lake + Reporting (Transport, Cost to Serve) • FTE Data Lake + Reporting • Customer Profitability modelling + Reporting • Production Energy Cost modelling (incl. Forecasting) • Master Data (incl. Automated Hierarchies and Row Level User Access methodology) Show less

• 

  Winc Australia

  Feb 2023 - now

  Commercial Analytics Manager