AMS: Metering asset migration

Circini partnered with AMS to support their asset management upgrade from Gentrack to an Oracle ERP system.

AMS runs metering assets on behalf of New Zealand energy retailers. The system upgrade was intended to give AMS an integrated asset management system with improved capability. In particular, they wished to better enable expansion of their smart meter service options. The Circini team worked closely with Fusion 5, the Oracle system implementer, for the programme.

The project involved over 1 million ICP's/sites (unique customers) and over 3 million assets - all generating real-time usage. This high volume of in-flight data, coupled with active service orders from retailers at the time of migration, placed significant challenges on the migration team. If the migration wasn't accurate customers would not have meters installed and AMS would incur penalties from retailers for failing to meet their contractual commitments.

A number of exception cases further complicated the project. In particular, issues with data quality in legacy systems and the requirement for consolidation and rationalisation of legacy data, such as historic tariffs.

The Circini team managed the data migration component of the upgrade which included migration and transition planning, data cleansing, and the data migration itself.

"We built a mapping database and automated a lot of the data cleansing during the actual migration which generated some real efficiencies."Jodie Stewart, Director, Circini

Feedback from AMS was the migration component of the upgrade programme was the cleanest part of the project. The data migration was completed to within an hour of the time projected by Circini and issues with data integrity were a non-event post go-live thanks to in-depth planning and execution.