Case Study

OptusPtyLtd(SingtelGroup)

Solution Designer · Data Migration

Project Timeline

June 2015

Solution Designer Role

Joined Optus as Solution Designer for Data Migration, focusing on large-scale telecommunications data migration.

September 2015

Project Spring Planning

Began requirement gathering and analysis for migration of 12 legacy systems to Amdocs platform.

January 2016

Data Profiling & Quality Assessment

Profiled data and assessed quality across systems, preparing reports for business stakeholders.

April 2016

Staging Environment Design

Designed and implemented staging environments and error handling procedures for legacy data extraction.

August 2016

Informatica Flow Development

Developed Informatica flows to integrate multiple systems using PowerCentre 9.5.1 HF 2.

January 2017

Data Masking Implementation

Created data masking flows to distribute data to off-shore teams without privacy risks.

May 2017

Migration Completion

Successfully migrated 10 million subscribers across mobile, fixed line, and enterprise customers to Amdocs platform.

Project Overview

At Optus, I served as a Solution Designer for Data Migration, focusing on Project Spring — a large-scale initiative to consolidate 12 legacy systems into a single integrated platform provided by Amdocs. This ambitious project targeted the migration of 10 million subscribers across mobile (prepaid and post-paid), fixed line telephony, and enterprise customers.

My role involved designing and developing comprehensive data migration solutions, from requirement gathering and analysis to implementation and quality assurance, ensuring seamless transition with minimal disruption to business operations.

Key Achievements

  • Successfully migrated 10 million subscribers from legacy systems to the Amdocs billing platform
  • Designed and implemented staging environments and error handling procedures for legacy data extraction
  • Developed Informatica flows to integrate multiple systems using PowerCentre 9.5.1 HF 2
  • Created data masking flows to distribute data to off-shore teams without privacy risks
  • Improved data quality and consistency across systems through comprehensive profiling and assessment

Technologies Used

Informatica PowerCenterData profiling and quality assessment toolsData masking and privacy protection solutionsAmdocs Billing and Customer Care (BCC) platformNet-cracker OSS platformStaging environment design and management tools

Results & Impact

The successful migration of customer data from legacy systems to the Amdocs billing platform streamlined Optus's billing operations by consolidating multiple legacy systems. This transformation improved data quality and consistency across systems, enhanced data security through proper masking and privacy controls, and provided a more integrated view of customer information.

Want to Discuss This Further?

Happy to walk through the 10-million-subscriber migration, data masking approach, and Informatica architecture used in Project Spring.

Shivendra Singh — Head of Data, Information & AI