|
Medical Complex
|
|
CLIENT SITUATION
|
|
|
Specialized 150 bed hospital, one of seven hospitals and four specialty centers in multi-billion dollar medical complex.
|
|
|
Patient medical and financial data stored in corporate (mainframe) and local hospital (AS400) systems.
|
|
|
“Black hole” scenario -- data entered into system in complex, labeled structures, yet nearly impossible to get meaningful data back out on reasonable schedule.
|
|
|
Data access required specialized systems knowledge and significant programming; all integration had to be manually performed.
|
|
|
Simple analytical and reporting available only monthly and after substantial manual data consolidations.
|
|
|
Custom reports took months to prepare and required significant specialized skills and coding.
|
|
|
|
|
|
PROJECT RESULTS
|
|
|
In under 2 weeks, created logical, "layman readable" representation of all disparate system sources of data.
|
|
|
Warehoused all data. Intelligently tagged, indexed and integrated 2.5 million financial records and 100,000 patient medical records.
|
|
|
Ad hoc querying across the integrated data pool instantly exposed patterns and inconsistencies in medical information captured in separate hospital system processes.
|
|
|
Immediately integrated hospital information with externally acquired demographic data to provide additional business analyses.
|
 |
|
|
|
898 kb .pdf
|
|
