Skip to Main Content
syniti logo
social American Airlines generic 20

American Airlines

Merger-Driven Data Transformation Takes Off

PROJECT BACKGROUND
American Airlines

The merger of American Airlines and US Airways

required a major initiative, called “Project Spring”, to consolidate HR and payroll data across the newly combined airline’s 130,000+ active employees and 500,000+ former employees.

Company Overview

  • Industry

    Travel & Transportation

  • Revenue

    ~$50B

  • Company Size

    Enterprise

Transformation Snapshot

  • Challenge

    Post-merger consolidation of HR data across 130,000+ active and 500,000+ former employees

  • Solution

    Post-merger consolidation of HR data across 130,000+ active and 500,000+ former employees

  • Outcome

    Centralized governance and improved visibility across the enterprise

The Core Issue

The Challenge

Premier SAP Solution Extensions Partner, Syniti partnered with AA to lead data migration and information governance efforts for this program. The project involved migrating employee populations in legacy US Airways and AA systems to SAP SuccessFactors and HANA Enterprise Cloud Platform, a single, cloud-based platform.

As one of AA’s largest post-merger data transformation programs, Project Spring demanded superior data migration and information governance capabilities to effectively migrate comprehensive legacy employee data from SAP HCM, Oracle HR and multiple supporting system into SAP SuccessFactors and HANA Enterprise Cloud Platform. The new cloud-based HR and payroll solution would then serve as a single, cloud-based solution to manage all HR data.

 

The Syniti team has helped us to understand more about the complexities and nuances of our data than we ever knew existed. Now, they’re helping us to build on this foundation as we establish our ongoing data governance capabilities.”

Mark Mitchell
Managing Director, People Shared Services, American Airlines

Implementation Highlights

Approaching data conversion as a project-wide initiative, Syniti worked with AA, SAP, internal audit teams and SI partner Deloitte to ensure a unified “core data team” approach that included all project stakeholders, including downstream consumers of employee data. The core data team designated an AA data quality team, encompassing a broad coalition of corporate HR community stakeholders ranging from payroll and benefits to compensation, 401(k), tax, finance, IT, and talent. Additionally, the process involved defining an accountable data owner for each field in SuccessFactors including mapping rules, data collection and validation. AA utilized SAP Advanced Data Migration by Syniti to navigate through all steps of the data conversion process and validation. The solution – which is powered by Synit’s Knowledge Platform (SKP) – served as a web-based means of collecting and controlling all constructed data, as well as facilitating workflows and manager approvals. Every change was logged and audited for issue traceability and compliance.

Throughout the process, AA used the ADM solution to implement automated industry-leading data quality metrics. Syniti’s technology was able to combine preload error checks, load failures, and open data defects to provide a transparent view of the overall data quality as it related to known business rules and mapping requirements.

 

Goals

  • Execute Post-Merger HR Data Transformation – Successfully assess, harmonize and migrate employee data from multiple systems into a single, cloud-based HR and payroll system
  • Maintain Security and Accuracy of Employee and Payroll Data – Implement automated business rules to ensure proper treatment and cleansing of data across full data transformation
  • Automate Data Quality Processes and Reporting – Deploy a collaborative data quality solution that automatically enforces HR business rules and offers stakeholder visibility into error resolution through ongoing dashboard reporting
  • Implement Proactive Information Governance Across HR Data – Establish forward-looking, sustainable information governance practices that leverage knowledge and reuse of HR data after go-live is complete

 

 

The HR and payroll system integration to new SAP SuccessFactors and HEC platforms was one of the most complex programs we’ve attempted as part of the merger between AA and US Airways. During the journey, our team partnered with Synit’s consultants every step of the way, and we could not have done it without their tools, their leadership and professional expertise.”

Mark Mitchell
Managing Director, People Shared Services, American Airlines

Why Syniti was Selected

American Airlines was faced with significantly complex employee data due to multiple acquisitions and decades of projects and union contracts. The stakes of an implementation of this magnitude were incredibly high, and the security and accuracy of employee and payroll data was paramount. With firsthand knowledge of Syniti’s proven solutions, expertise and reputation, SAP and Deloitte jointly advised AA to utilize Syniti as the gold standard partner for data transformation project success.

 

Results

As a result of the data migration initiative, AA successfully converted data for more than 335,000 current and former employees to SuccessFactors – implementing Talent, Recruiting & Onboarding, and Employee Central modules. It also migrated payroll data for over 35,000 employees to SAP HANA Enterprise Cloud for payroll processing. To accomplish this massive effort, Syniti’s SKP helped American Airlines extract over 690 million records during the cutover period from seven different source and target systems, as well as create nearly 10,000 business rules to properly transform all legacy data. The solution generated over 2,600 reports to support error resolution and validation.

Syniti also advised AA on its information governance strategy for the initiative and developed data quality metrics dashboards to help drive clarity, resolution for open data migration issues, and closed-loop open data remediation for ongoing governance. It also implemented best practices around reuse of data assets and knowledge captured during the migration process.
The final product resulted in higher than 99.9% automation of AA’s employee data transformation, exceeding client and partner expectations along the way.

 

See What Syniti Can Do for You

More Transformations Stories