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 one million ICP's / sites (unique customers) and over three 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 challenges on the migration team. If the migration wasn't accurate customers would not get meters installed, and AMS would incur penalties from retailers for failing to meet their contractual commitments.
A number of exception cases, issues with data quality in legacy systems, the requirement for consolidation and rationalisation of legacy data such as historic tariffs further complicated the project.
The Circini team, lead by Jodie Stewart managed the data migration component of the upgrade. Their role included migration and transition planning, data cleansing, and handling the actual migration of data.
"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 that 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. Issues with data integrity were a non-event post go-live thanks to good planning and execution.
