Andrew T.

Data Analyst

Greater Sydney Area

About

Experience

  • Commonwealth Bank (7 yrs 5 mos)
    • Manager, Strategic Project & Systems
      Jun 2021 - Jul 2023 · 2 yrs 2 mos

      Managing and supporting Audit related systems, IT infrastructure and management reports that facilitate effective and efficient execution of the audit plan and strategy. Key Responsibilities: • Collaborate with Users, Business Analyst, System Architects and Engineers to design, customise, and implement fit for purpose IT solutions. • Provide first line system support for the Internal audit team. • Provide User training and weekly drop-in clinic for various audit, collaboration, productivity and reporting tools. • Overseeing and delivering system updates and enhancements. • Establishing best practice over the use of our system and repositories in terms of data storage, sharing and retention. • Act as the Data Management SME to ensure systems are guarded against internal cyber-attacks and data loss. • Develop relationships with the Risk and Cyber Security team to ensure appropriate IT governance is in place.

    • Manager, Assurance Analytics
      Oct 2019 - May 2021 · 1 yr 8 mos

      Work with auditors and stakeholders to support the successful execution and closure of audits. Key Responsibilities: • Deliver high quality audit files and reports within a timely manner. • Provide data analytics to provide insight and identify exceptions and to support findings • Work with auditors to understand how data analytics can be utilised to support the purpose and objective of an audit. • Perform testing to evaluate Controls with associated potential Risks. • Providing data driven recommendations to improve performance and support business decisions. • Build and maintain effective relationships with audit teams and business stakeholders. • Support the delivery of innovative and AI solutions.

    • Manager, Audit IT Projects & Applications
      Mar 2016 - Sep 2019 · 3 yrs 7 mos

      Drive high performance by taking accountability for Group Audit & Assurance (GA&A) IT systems and projects to assist the Group Auditor and GA&A team execute their business objectives and strategy, within budget. Key Responsibilities: • Manage configuration, maintenance and IT strategy for GA&A systems and tools. • Manage development projects and upgrades. • Managing external and internal parties to deliver and optimise GA&A systems and tools. • Provide data analytic solutions that support and delivers insights to Executives and CBA Group stakeholders. • Develop reporting through extraction and analysis of data contained within GA&A and other Bank systems. • Providing first level functional and technical support to Users. • Deliver systems training for new joiners and during times of change.

  • BI Consultant at Satori Group Australia
    Mar 2007 - Jan 2016 · 8 yrs 11 mos

    Delivering Audit management, financial and resourcing solutions to improve business controls, processes and performance. Key Responsibilities: • Gather requirements through workshops and one-on-one sessions • Document client’s requirements using modelling techniques including Workflow and Data Flow Diagrams, Use Cases and Wireframes. • Analysing and validating big data during preparation and staging process using SQL queries • Building ETL processes to source data using SSIS packages and scheduled tasks • Working with IT teams to install and configure audit, financial and resourcing applications • Design and deliver Excel, Word and dashboard reporting solutions • Performing User acceptance testing • Preparing User guides and providing training and support Through the above activities, I was able to hone my project management and communication skills by working and developing relationships with various stakeholders.

  • Assistant Accountant at Swire Shipping
    2005 - 2007 · 2 yrs

    • Processing multi-currency revenue and cost into CODA • Monthly reconciliation of P&L & B/S accounts • Analysing and querying variances in actual cost and revenue, compared to budgeted cost and revenue • Preparing monthly P&L for completed voyages • Processing sales and recovery invoices • Analysing and reviewing tariff rates • Liaison with overseas agents in Australia, Europe, Asia, Pacific Islands and North America • Preparing inter-company and accrual journals