APA

National Enterprise Asset Management (EAM)

Multiple legacy systems and processes were aggregated into a single, national Maximo platform, integrated with core business systems and providing consistency in data models and asset management processes.

$ 0 M
Project
TOP 0
ASX COMPANY
0 yrs
duration
Photo Credit: APA Group

|

SHARE

The Enterprise Asset Management (EAM) project was a multi-divisional business transformation program to deliver a single enterprise wide Asset Management platform interfacing with the relevant systems (including Oracle CC&B, Smallworld GIS and a website used by external contractors) and supported by nationally standardised processes and roles and responsibilities.

Technical Situation

APA had stand-alone instances of ageing and unsupported versions of Maximo and other asset management systems across the regions, and Networks and Transmission divisions. There were also numerous Geospatial Information Systems, multiple Oracle Customer Care 8k Billing systems, the Australian Energy Market Operator (AEMO) Full Retail Contestability Hubs, and the “Envestra Make The Connection” web site for builder gas connection requests.

In addition to this were various home-grown solutions managing data related to mission critical asset management activities, one example being the Cathodic Protection (CP) Access database that helped minimise pipeline corrosion. Data was exchanged between systems utilising batch processing run by Control-M as well as market integration via SoftwareAG WebMethods.

Solution

IBM Maximo was selected as the core technology for the EAM solution.  Maximo Asset Management is a comprehensive solution for managing physical assets on a common platform in asset-intensive industries. It offers “built-in” mobile access, out-of-the box mapping, crew management and analytical insight.

To align all parts of the business, gather requirements, design an appropriate asset hierarchy, integrate with other business systems, migrate data from, legacy systems and manage the substantial change to business process was a massive undertaking, the largest in APA’s history.

The EAM project team of internal subject matter experts, software vendors, application specialists, testers, analysts and change managers distributed across Australia peaked at around 50 during the 2+ year project.

GTS joined the project team for the final 18 months to:

  • Work with key business stakeholders to define and refine asset management processes
  • Help to define the asset hierarchy and asset data models
  • Construct an asset hierarchy from legacy systems using Extract Transform Load (ETL) tools
  • Test, validate and reconcile the data prior to and as part of the implementation
  • Work with internal solution architects to validate the design against the business requirements
  • Fulfill leadership roles in both the integration and data management streams as part of the largest Maximo implementation transformation project ever undertaken in Australia

Our data specialists performed key roles in the development of Extract Transform Load (ETL) processes using Oracle database development tools.

Data was combined from various legacy sources and structures into a common data model to be used in the EAM hence significant work was done in order to fully understand, document and transform the data in order for consistency to be realised.

The data stream led by GTS was the largest and most critical stream responsible for the design of data models in Maximo, mapping multiple legacy data sources to the new model and migrating and validating all of the legacy data (amounting to many millions of records) into the new Maximo system.

GTS also led the integration stream to design interfaces between multiple systems each of which held data required for the EAM solution including:

  • IBM Maximo Asset Management
  • Oracle Customer Care & Billing (CC&B) – SA, VIC and QLD instances;
  • AEMO FRC systems via the Oracle CC&B systems;
  • GE SmallWorld Geospatial Information System – SA and VIC instances; and
  • A customer website for builders to request gas connection services

Project Outcomes & Benefits

  • With a team of up to 10 specialists’ consultants, GTS ensured that the critical data and integration tasks were delivered on schedule and importantly had quality processes around planning, reporting, issue resolution, validation and implementation.
  • A single enterprise EAM system for all of APA
  • Integrated with core business CC&B and GIS systems
  • Standardising asset management processes
Andrew Todd
Andrew Todd

Chief Executive Officer

GTS was proud to bring our data management and integration capability to APA’s largest ever digital transformation project.

Andrew Todd

Chief Executive Officer at GTS Group

Other case studies