Project Details

Cleansing over 300,000 records in our client’s legacy database system.

Client: New Mexico Department of Health


The New Mexico Department of Health (NM DOH) was in the process of moving to a new modernized system to manage their breast and cervical cancer program. As part of this modernization, the Department took on the task of cleansing their over 300,000 records in their legacy database system. The Program had struggled to complete this work with internal DOH IT staff for over a year.  With looming deadlines to have all the public health data ready to import into their newly modernized system, the Program contracted with RESPEC to carry out this data cleansing and migration function.

Working closely with the client in an iterative fashion, RESPEC was responsible for all the planning, analysis, design, coding, testing and implementation. We carried out the data cleansing and migration ETL processes to cleanse and move the public health data from the legacy system into the new SQL Server solution.  RESPEC worked closely with DOH staff to analyze the data and develop the business rules and resulting conversion scripts to migrate the data.  RESPEC was able to meet the schedule and successfully complete this work in just a few short months.