Workplace Safety Shoe Supplier: Data Migration & Data Integration

Organization

Our client is a global workplace safety company that provides innovative, slip-resistant footwear to help businesses protect employees from workplace injuries. Their products are used in over 15,000 organizations across 100,000+ locations worldwide. As part of their long-term strategy, they set out to modernize their IT infrastructure to improve performance, security, and scalability.

Challenge

When it came to its IT architecture, the company faced significant challenges with their legacy systems:

• Lack of scalability to handle merger and acquisition volumes or adapt to new processes.
• Persistent integration issues with financial, accounting, and partner systems.
• Absence of in-house expertise to manage the systems, resulting in no holistic view of transactions.
• Limited availability of market resources with the necessary legacy skills.

Migrating to a new technology platform (AngularJS, Java, webMethods, and SQL Server) required transferring data from the legacy system to the new solution. Due to data quality issues in the legacy system, redesigning master data and business rules introduced complex data transformations during the migration. Additionally, the new platform needed seamless integration with the existing Data Warehouse.

Solution

XTIVIA, leveraging years of expertise in Data Warehousing and Data Integration, utilized its Data Migration framework to ensure a seamless transition:

• Collaborated with the customer to define the scope and establish success criteria.
• Profiled the source data to identify data quality issues and reviewed findings with the client.
• Developed a comprehensive approach plan, detailing the steps required for the cutover from the legacy system to the target solution.
• Created a staging environment to handle transformations and incremental changes.
• Developed SQL Server and SSIS scripts to cleanse and standardize the data.
• Designed source-to-target mappings (from the legacy system to the new solution and from the new solution to the Data Warehouse) and reviewed them with subject matter experts (SMEs).
• Coded and tested data transformations using T-SQL and SSIS.
• Implemented scheduled ETL processes to transform legacy transactional data into target structures.
• Documented detailed test cases, and performed end-to-end testing of the data flow from legacy source to the target Data Warehouse and new solution to target Data Warehouse. Any exceptions and mismatches had to have a valid reason (Business Rule Change, Data Quality issues in legacy, etc.).
• Developed scripts to extract Pending Orders, Pending Credits, In-flight Transactions, and Master/Reference Data before transitioning to the new solution.
• Implemented scheduled data feeds from the new solution to the Data Warehouse.
• The deliverables of the Data Migration exercise included a Detailed Plan, Source Data Quality Reports, Mapping Specifications, Test Plan, Test Cases, Test Scripts, Data Migration ETL Scripts, Data Integration ETL Scripts, Test Reports, and a Data Initialization Plan.

BUSINESS RESULT

• Data quality issues were fixed before migrating to the new solution.
• Stakeholder confidence in data quality was improved.
• Automated data initialization ensured a smooth transition from legacy systems.
• Seamless integration of the new solution with the target Data Warehouse was achieved.

KEYWORDS
Data Migration, Data Warehousing, Data Integration

SOFTWARE
SQL Server, SSIS, T-SQL, ARev

XTIVIA needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime, read our Privacy Policy here.