Data Conversion Strategy, Approach and Timeline Sample Clauses

Data Conversion Strategy, Approach and Timeline. The Contractor will create a Data Migration Plan, logical and physical extract, transform and load (ETL) plan detailing how existing State data will be migrated. This plan will include the tools used for migration and the Contractor’s Acceptance Criteria that will be applied by its Quality Assurance team, subject to State approval. The plan will include: i. Reconciliation process(es) and data checking reports. ii. Data profiling - The process of examining the data as it moves from source(s) to target(s) and collecting statistics and information about that data. This profiling will provide metrics on data quality (e.g. whether the data conforms to particular standards or patterns) and business risk. iii. Data validation checks - The ability to look at each data record to make sure the information is valid and of good quality. iv. Validation mechanisms - The use of web services or other programmatic solutions to ensure codes such as zip codes and other data are valid and de-duplicated. v. Data standardization checks - Ensure that the data transition adheres to predetermined sets of standards set by internal enterprise IT, such as HL7, ICD9/10, CPT® and HPCS codes. The Contractor will ensure data integrity and consistency throughout all phases of the project, and will work with DVHA to identify its transition data. The State will make a formal request on behalf of the Contractor to the data source entity. The data for each transition project will be transmitted via a secure FTP site provided by the Contractor. The Contractor will work closely with those parties identified to get file specifications (format, layout etc.) and mapping to understand all the various types of datasets. Gap analysis will be performed to determine if the transition dataset includes all data elements required to successfully extract, transform, and load (ETL) into the system. Gap issues will be resolved in a logical and physical plan on how the data will be migrated. Included in the plan will be the tools used for migration and the Acceptance Criteria that will apply an execution of the conversion/transition plan with a Acceptance Test. Reconciliation and data checking reports will be run to determine that all quantitative and qualitative metrics are achieved post-migration, and “data fixes” will be limited as much as possible with a thorough design plan.