Client Profile:

The Illinois Department of Public Health is responsible for protecting the health and welfare of 12.4 million state residents and visitors through the prevention and control of disease and injury. To track vaccines for children, the department employs a secure, voluntary immunization health record repository known as the Illinois Comprehensive Automated Immunization Registry Exchange, or I-CARE.

I-CARE is a unified and integrated electronic immunization information Web Portal requiring ongoing data management, including both legacy DB2 and leading edge Oracle components. Maintaining a compatible bridge between DB2 and Oracle is essential, as is maintaining secure and compliant HL7 data exchange with organizations that send to and receive data from I-CARE.

Solution:

Upp Technology data management personnel onsite have been responsible for all aspects of I-CARE database administration and support, including multi-platform Oracle DEV, TEST, PROD installations and upgrades, configuration, security and user administration, object creation and maintenance, event management, performance monitoring and optimization, reorgs, defragmentation, patch management, backup & recovery, troubleshooting and resolution, etc.

In supporting secure healthcare information exchange, Upp Technology subject matter experts in Oracle and DB2 data management have led departmental staff in the UNIX and Linux deployment of Oracle Data Guard and Oracle Label Security to protect tens of millions EHRs culled from hundreds of medical providers, in addition to coding scripts and stored procedures for data interfacing according to HL7 standards.

Additional I-CARE responsibilities include such data management tasks as scripting to synchronize patient and service provider information between DB2 and Oracle, creating database links for data migration, maintaining Oracle Transparent Gateway, supporting Java DB connectivity, mapping data warehouse  structure and performing periodic data extractions, tracking instance activity and auditing.

Business Value:

In providing back end data management subject matter expertise for the voluntary I-CARE registry program and Web Portal, Upp Technology is helping the Illinois Department of Public Health to achieve its “Healthy People” goal in increasing immunization levels for children statewide with secure, fast, accurate data collection and compliant EHR sharing for correct, timely and cost-effective vaccinations.

Innovative Technology Solutions