Services

• Business and Technology Consulting
• IT Services
  • SAP
  • Oracle
  • Data & Integration
    • Transformation & technology
    • Capability statement
    • Business intelligence
    • Enterprise portal
    • Enterprise data management
    • Enterprise integration
• IT Outsourcing
• Business Process Outsourcing
• Finance and Accounting Outsourcing
• HR Outsourcing
• On and Offshore Delivery

Enterprise data management

Overview

Xansa has a wealth of experience in complex data discovery, data quality management and data migration strategies. Our clients' specific data requirements range from data quality improvement initiatives to profiling, interpreting and migrating data from legacy systems to new business platforms. The experts of our Enterprise Data Management team resolve these issues through a combination of in-depth data management knowledge and extensive technical experience in the use of industry standard toolsets, and the design of on-going data management processes and procedures

This combination of functional and technical skills allows Xansa to deliver and support robust, efficient and cost effective business-focused data solutions, facilitating both re-use, and a best practice approach. Our solutions are delivered to consistently high quality and with full supporting documentation, whilst dedicated teams are available to support the processes through the full data project lifecycle.

Capability

The EDM team is experienced in developing and implementing a wide range of data solutions - technical, organisational and process based. Technical solutions are based on "off-the-shelf" toolsets, bespoke solutions or an appropriate combination of the two. We have proven capabilities in the following toolsets:

• IBM WebSphere Information Integration Suite (formally Ascential Software)
  
• Informatica
  
• Ab Initio
  
• SQL Server DTS/SSIS
  
• Sunopsis
  
• QAS
  
• SAP - including the R/3 Legacy System Migration Workbench (LSMW)
  
• Oracle

Combining our abilities in these toolsets with our extensive knowledge across vertical client sectors allows us to help our clients to:

• Develop Extract, Transformation and Load (ETL) procedures - to support high volume or complex data migration or integration requirements
  
• Define and capture system metadata - to ensure that data is consistently defined, recognised and maintained throughout the corporate data architecture
  
• Undertake data mining and discovery - discovering hidden issues, themes and/or value in both existing and derived data
  
• Create data discovery dashboards - highlighting the prevalence of issues and/or inconsistencies within datasets, identifying recommendations and quick wins
  
• Implement data quality initiatives - enhance data accuracy, reduce duplication and help clients make best use of their data assets
  
• Move to a more mature data management model through improved governance, ownership, architecture, tools and quality
  
• Track and audit data quality through systems - highlighting any degradation of data due to failing business or system processes, allowing issues to be cured at source
  
• Create a single enhanced view of key business data such as customers and vendors through matching and/or the creation of a data hub

Track record
UK's leading health and beauty retailer - Xansa managed the extensive data discovery and migration required to support the implementation of the world's largest SAP IS-Retail implementation. The scope of involvement was extensive, and involved our onshore and offshore resources in the following:

• Data management strategy and approach
  
• Data discovery, including the facilitation and management of data discovery workshops
  
• Migration solution design and development
  
• Data quality improvement initiatives - articles and the creation of generics and variants
  
• Extract, Transform and Load tools - catering for all master and transactional data
  
• SAP LSMW, BDC & ABAP expertise - load processes for the new SAP ERP system

Leading UK utility organisation - Utilising a bespoke SQL Server SSIS solution, the Xansa EDM team built a fully integrated migration solution capable of handling the migration of 60,000 existing commercial and 750,000 new domestic customers from legacy systems and external 3rd party sources into a new billing system. This solution included a complex data quality improvement process.

Global leader in pallet industry - The Xansa EDM team was responsible for managing the migration of key business data from numerous disparate legacy systems into a highly bespoke and truly global SAP-based movements tracking and billing system that included over 100 million materials movement records.