Major Airline Carrier Sheds Old Baggage to Modernize Data Privacy and Test Data Management Practices

single image
         :  Major Airline Carrier

Industry       :  Airlines/Aviation

Practice Area :  Information Lifecycle Governance & Security



The client together with its partner regional airlines, serves more than 100 cities through an expansive network in the United States, Canada, Costa Rica and Mexico. The airline has been ranked by J. D. Power and Associates as having the highest customer satisfaction of the traditional airlines for nine consecutive years. The airline plays a major role in air transportation in the state.

Business Challenge:

The client was a long-standing customer of IBM, having adopted IBM Optim’s Data Privacy and Test Data Management Solutions.  In 2016, the IT, Operations, and Executive teams decided to modernize this vital component of the company's IT infrastructure. While there would be clear benefits from an upgrade to IBM Optim version, the key decision drivers were the necessity to move away from an outdated platform. Upgrading the prevailing solution to setup test data from PeopleSoft Oracle database was a high priority.

The top challenges were to:

  • Safeguard data utilized in development and testing and prevent data exposure.
  • Mask sensitive Personally Identifiable Information (PII) in accordance with the security policies prior to new production data is imported into testing environments.
  • Mask production data used for testing based on specific regulatory requirements.

The Estuate Solution:

Estuate’s IBM Optim implementation and upgrade solution addressed the client's needs. As part of the solution, Estuate identified sensitive PII data across its PeopleSoft Oracle databases, and masked them with meaningful data effectively. Moreover, the current version of IBM Optim provides extensive test data management capabilities that support an iterative, repeatable process of creating, maintaining, and protecting data in non-production environments to precisely reflect end-to-end business processes. This presented an opportunity to improve their processes.

The Estuate Solution:

  • Upgraded the existing Optim environment to the current Optim version--
  • Detected and located hidden instances of confidential data so that they could be fully protected.
  • Masked confidential data easily using predefined transformations and site-specific routines for the PeopleSoft Oracle database.

Business Impact:

Estuate’s solution helped the client fulfill their corporate compliance requirements, protect data privacy across nonproduction environments, improve application development and testing processes, reduce the time needed to set up test data, improve test validation tasks, and increase test coverage to speed the delivery of reliable applications. Additional benefits include:

  • Improved security and confidentiality levels, and reduced data exposure in non-production environments.
  • Compliance with industry/regulatory data privacy laws and regulations.
  • Usage of predefined masking techniques to speed time to delivery.
  • Preservation of referential integrity of the data, while protecting data privacy.

        We knew that an upgrade to IBM Optim 11.3.04 would be a tremendous undertaking, but we also knew we had to upgrade to use advanced capabilities in the new version. After all the rehearsals and contingency planning, the actual upgrade went just like a dream. Estuate’s knowledge and extensive experience with the Optim solution suite has been an exceptional boost to our effort. They made all the difference to the success of this complex and challenging effort.

Optim Specialist
Major Airline Carrier