KPI Data Entry & Data Warehouse Integration

Overview

The Ministry of Health in Kuwait follows its key performance indicators through Qlik dashboards. I worked on the system that feeds them: a custom control panel for KPI data entry, the data warehouse behind the dashboards, and the HL7 integration layer that moves clinical messages between hospitals across Kuwait.

What I did

• Developed a custom ASP.NET control panel for KPI data entry with AI integration (Azure OCR), feeding the Qlik dashboards used by the Ministry of Health
• Contributed to building and maintaining the data warehouse behind the dashboards; created SSIS packages to extract, transform, and load data from multiple sources, including an Oracle database and the KPI control panel
• Designed and scheduled automated SQL Server jobs that refresh data every 15 minutes, keeping dashboards near real-time
• Developed and configured Mirth Connect channels to process, transform, and route HL7 v2 messages for interoperability across all Kuwait hospitals
• Implemented JavaScript transformers to parse HL7 segments (MSH, PID, PV1, AIS, SCH, NTE, OBX) and extract clinical and administrative data, with encryption and decryption inside the channels for secure end-to-end communication