Automated Data Migration: @SpiceWorks

Healthcare Consortium of Illinois – Created and implemented several Extract Transform Load processes for various program projects.

Primary Care Case Management (PCCM) ETL Automation:
Created a scheduled automated ETL (Extract Transform Load) process to extract data from SQL Server 2012, transform the data into external clients specified format to an exported file and load file to external ftp site. After the external client processed the data a reply response file is generated and loaded to their ftp site. Created a secondary scheduled procedure to retrieve the response file (placing into the internal server) transform it into internal clients format, cleanse file for errors and load into SQL Server 2012. Utilizing FTP, T-SQL, SSIS, SSMS and Visual Studio.

Care Coordination Claims Data (CCCD) Files Data Migration & Load:
Created automated process to extract data files (GDG datasets) from Illinois HFS’ IBM MVS mainframe, cleanse the data removing duplications and errors and upload into internal instance of SQL Server 2012. Utilizing FTP, T-SQL, SSIS, SSMS,Visual Studio and Generation Data Groups (GDG).

Care Coordination Provider Panel Roster Migration & Processing:
Created automated process to extract data files (csv files) from website interface data repository (IL-HFS MEDI website to Illinois Health Connect web link), cleanse the data removing duplications and errors and upload into internal instance of SQL Server 2012. Created SSIS packages to process the for internal enrollment process. Utilizing HTTP, PHP, T-SQL, SSIS, SSMS and Visual Studio.

6 Months Duration
100-249 Users
100-249 Devices
10 GB Data