Alex Manning

Experience

• 

  TowersPerrin

  Mar 1996 - Aug 2001

  Data Analyst

  Managing data for Australia's largest and most complex Superannuation funds. From producing and reconciling data for Member's Benefit Statements, to data migration from fund acquisitions, and day-to-day data monitoring and financial reconciliation. Although the experience is old, the discipline learned due to the need for the data to be as close to faultless as possible, with limited technology and bandwidth, is experience I value and apply even today.

• 

  Aon

  Dec 2002 - Dec 2003

  Data and Process Analyst

  Responsible for the data migration and setup for Aon branches to go-live on their new brokerage platform. Data acquisition from legacy systems, cleansing and data set creation ready for upload, using Oracle 8i and VBA. Data dictionaries and catalogues created to support the rollout. Detailed data reconciliation activities.

• 

  Fish4

  Jan 2004 - Jul 2005

  BI Analyst/Programmer

  Extracting data from the website Oracle database using PL/SQL to create detailed shareholder charging reports using Excel VBA, and BusinessObjects.

• 

  Credit Suisse

  Sept 2005 - Oct 2007

  BI Analyst/Programmer

  Reporting on the Global Technology Actuals vs Budgets, gathering requirements, aggregating data into consumable data sets, creating reports for Senior Management to monitor and manage the Global IT portfolio.

• 

  Blueprint Management Systems

  Nov 2007 - Nov 2010

  BI Analyst/Programmer

  I worked with Blueprint for a number of leading financial institutions in the UK, in addition to a diverse range of other clients from leading international Legal firms, to all levels of Government organisations. I was involved in end-to-end data warehousing and reporting solutions using Oracle, SQL Server, and Business Objects toolsets, with Kimball methodology data warehouses. Blueprint Management Systems was acquired by NTT Data. Clients included: Barclays CapitalUBS Private BankUBS Investment BankDeutsche Bank Show less

• 

  Trafigura

  Dec 2010 - Apr 2011

  BI Analyst/Programmer

  Created advanced data and reporting solutions to support commodity trading activities. User requirements gathering and analysis, data gathering and ETL, advance BusinessObjects reporting, security, and production support.

• 

  Vantage Performance Solutions Ltd

  May 2011 - Oct 2012

  Principal Consultant

  Worked as lead Data Services developer for the Lloyds Banking Group financial consolidation project. Using SAP Financial Integration Management (FIM) with Data Services to transform data from the SAP ECC GL to load to the financial consolidation system, SAP Business Financial Consolidation. Clients:* Lloyds Banking Group* WPP Group

• 

  ASG Group

  Nov 2012 - Feb 2014

  Principal Consultant

  Practice lead for data projects from SAP Client: Transfield Services (now Broadspectrum)• SAP Data Migration – data migration work for acquired companies to be brought onto the strategic SAP ERP• Executive dashboards – delivery of data from SAP ERP and CRM, and other corporate systems, to support dashboards required by the C-level executives

• 

  Icon Integration, part of Accenture

  Feb 2014 - Feb 2020

  Principal Consultant

  AGILE BI Project methodology:Requirement gathering - Iteration 0, backlog formation and estimationProject Managemet - Execution and management of AGILE BI projectsDatabase design:Data vault certifiedNumerous Kimball / Star Schema designs Database and ETL:Lead developer - ETL and reporting (Data Services, SSIS)BusinessObjects and Data Services and Information Steward software installation and configurationMassively Parrallel Database programming (Microsoft APS (now Azure SQL Data Warehouse)) SQL Server up to and including 2016Oracle up to and including 12BusinessObjects:Universe design and implementation (Advanced)BusinessObjects Web Intelligence (Advancded)BusinessObjects installation, upgrade, migration, configurationAdministation, security and maintenanceClients: Australian HearingBillabongCancer Institute NSWCCACourt Services VictoriaCSRCentral Healthcare ServicesDuluxDownerLionPillar AdministrationPenguin Random HouseToyota Financial Services Show less

• 

  Accenture

  Feb 2020 - Feb 2022

  Senior Manager

  Delivered a real-time reporting system from SAP Hana to PostegreSQL with data presented through a custom Web front-end, providing time critical data to support the operations of a major Federal Government Agency. Delivered data architecture components for another Federal Department's future-state systems to support upcoming legislative changes.

• 

  VNEXT

  Mar 2022 - Dec 2022

  Lead Consultant
• 

  Transport for NSW

  Dec 2022 - Dec 2024

  Senior Solution Architect

  Architecting a greenfield Azure Data Lake solution for unstructured and structured data sets. Azure Databricks implementaiton for Data Engineering, with Unity Catalog. Creating standard solution patterns. Implementing data governance.

• 

  Australian Prudential Regulation Authority

  Dec 2024 - now

  Technical Lead