CSI's Data Migration and Conversion services help companies achieve faster project completion, improve data quality and most importantly, reduce risk and accelerate time to market. CSI has a long history of data conversions expertise. Our initial core competency was performing Platform Migrations (software and data) involving mainframe to midrange and then to client/server platforms. A successful conversion/migration methodology was developed along with a technology toolkit to automate as much of these conversions as possible.
We then expanded our capabilities into data warehousing and data management, which is our key focus today. Our data conversion methodology focuses on data quality by using automated data profiling tools, an inventory of events to define field mapping and an extensive data validation process.
Our Profiling Service helps guide and direct the planning of any information strategy. In conducting this service, CSI has discovered a number of issues important to current production and development projects. Data and table structures in entire systems – operational and data warehouse - are navigated to determine the cleanliness in the main areas of data quality challenges including referential integrity, uniqueness, cardinality, subtype/supertype constructs, and domain adherence, conditional data, derivations, and consistency of data. Data audit and profiling can be performed with software programs like IQ Insight from Business Objects or a client’s profiling tool.
CSI understands the importance and complexity of the data acquisition process. That is why we have a proven methodology and best practices approach for implementing Data Transformation/ETL solutions. In addition, we couple the data acquisition process with a proven data preparation process that includes automated data analysis (profiling), source to target mapping, and data cleansing that can reduce ETL timelines by as much as 35-50%