State of Florida, Department of Health
Health Management System (HMS)
GeekSI along with other staffed partners implemented the Health Management System (HMS) for this Florida (FL) Department of Health (DOH) project approved through the FL Legislature. HMS is a web based public health clinic and case management system used daily by over 15,000 users statewide in the provision of health services. It replaced an existing Health Clinic Management System (HCM), a legacy character based system implemented in MUMPS deployed within each County Health Department (CHD) within the State of Florida. It is a web application that was implemented in Intersystems Cache, an Objected Oriented (OO) framework and database that is the next generation of MUMPS technology, deployed to each CHD. We verified its 508 compliance to meet ADA requirements. Facilitation of requirements and Analysis was conducted with a wide span of Subject Matter Experts (SME) statewide represented and organized with Special Interest Groups (SIG) for each HMS component. The requirements for both system and business processes were captured using UML and Use cases within the Rational Tool Suite. HIPAA compliance was maintained, as well as ensuring security measures taken to protect patient data.
HMS components include:
• Patient Registration
• Clinic and Medical Scheduling
• Billing for private Insurance, Medicare, Medicaid, special grants, and other funding sources, including electronic X12 Electronic Data Interchange (EDI)/XML interfaces to clearinghouses
• Case Management for programs ranging from diseases such as Tuberculosis (TB) and HIV to preventative care such as Healthy Start, Dental and Immunizations.
• Lab Ordering with public and private laboratories, including electronic Health Level 7 (HL7)/XML interfaces with LabCorp and Quest Diagnostics encompasses automatic lab results posting
• Radiological Exams Order and Exam results for X-Rays, CT-scans, MRIs, ultrasounds
• Prescription and medication disbursement and tracking
• Provider Management, with NPI
HMS has multiple integration points to a diverse set of health registries, including those for disease surveillance interface via PHIN to meet CDC reporting requirements. These registries included STD, HIV and TB. Other non-disease related registries integrated with HMS were Breast and Cervical Cancer, Blood Lead, and Immunizations and Healthy Start/Prenatal registries. We understand the necessities and complexities of interfacing health data and the importance of sharing health data across the enterprise. Integration is not just a technology problem but an incongruence of medical language and structure problem, requiring coordination at the enterprise level to overcome. Where necessarily, we reviewed implemented and integrated taxonomies for ICD9/10, CPT, CDT, HCPCS, SNOMED, and LOINC. We are familiar with the standard health interchange formats such as HL7, X12 EDI, NCPDP, and also are experts and the health technical architecture. We evolved the DOH integration strategy by viewing maturing the Integration Broker form data file management to an Enterprise Service Bus, brokering web services to share data modeled upon SOA. We supported the effort to incorporate a Master Person Index (EMPI) of all clients of the State of Florida. .
For this Business Intelligence (BI) project, GeekSI provided the project management, analysis and technical architecture services to replace the disparate and incongruent set of multiple MS Access databases comprising the State Trauma Registry (STR) to the targeted next generation trauma registry. The new trauma data warehouse necessitated the standardization of over 500 files of 180 data fields in varying file formats, submitted each quarter from every hospital with an approved trauma center.
GeekSI developed the business architecture, performing analysis of as-is business processes and developed to-be (target) business processes for the re-engineering of the STR We worked closely with stakeholders, which included Trauma Surgeons, Trauma Medical Center Directors, EMS nurses and staff. We created an STR roadmap to include an interim solution for the STR as part of the Business Intelligence solution (data warehouse) in SQL Server 2008 to support integration, analysis, reporting services, that included the technical architecture. The interim solution was necessary to mitigate the continued risks involved in the use of the unstable MS Access database files used to import data files containing extensive amounts of data and file format errors from each hospital. We transitioned the project from ad-hoc development to agile, with daily scrum meetings. During the interim solution phase, we spearheaded the creation of a new data standard interface, creating a new FL Trauma Data Dictionary standard, designed with an XML schema and modeled the BI schema that addressed issues with current trauma Data Standard.
For the final solution, we composed the business case, developed scope and performed gap analysis for a buy vs. build solution, including a Request for Information (RFI), adhering to the DOH IT governance and EA processes.
Trauma Registry IT Services
U.S. Department of Veteran Affairs
Multiple Sclerosis Surveillance Registry (MSSR) Enhancements
The causes of Multiple Sclerosis (MS) are still relatively unknown. The Multiple Sclerosis Surveillance System (MSSR) enhancements project extended the existing data points used to research causes, diagnosis and treatments for MS. The enhancements requested as part of this project were also needed to provide further insight into the utilization, cost and morbidity of Veterans with MS to improve treatment, identify funding and oversight needs for the entire MS program at the VA.
MSSR is a Business Intelligence (BI) project, interfacing with the VA’s health-related Corporate Data Warehouse (CDW), an Oracle DB, to export and import MS specific data including medications prescribed, laboratory results, and demographics. The original data sources feeding the CDW are primarily decentralized and customized instances of VistA across the VA provide a disparate, non-centralized source of clinical MS data that makes reporting and analytics difficult. The CDW addresses some of the issues, but has data quality issues and holes with respect to MS.
GeekSI began the MSSR enhancements project by reviewing and confirming existing requirements, development and testing artifacts, including user stories and acceptance criteria. We then held Joint Application Development (JAD) sessions with SMEs and data source SMEs to verify the current data workflows from a business process perspective by performing the initial analysis of the state of the data sources targeted for the enhancements. This included examining interfaces to CDW, existing Extract Transform and Load (ETL) code, availability of data, expected accuracy of the data, timing of data transfers and their frequency. The SMEs included clinicians and epidemiologists, statisticians, epidemiologists to review existing data models and schema within the CDW to identify potential tables and fields as sources for the data enhancements. Once the fields were confirmed, we then reviewed sample data to determine the quality of the data prior to targeting the information for export. We then developed the ETLs to export and import the data into MSSR’s MS SqlServer database from CDW. We developed Master Test Plans, Test Cases and Scripts to verify the data imported.
541511 Custom Computer Programming Services
541512 Computer System Design Services
541519 Other Computer Related Services
541611 Administrative Management and General Management Consulting Services
Florida Women Owned Small Business
Socially Disadvantaged Business
Economically Disadvantaged Women Owned Small Business