The Challenge:
The National Health Insurance Authority (“the Authority”) in The Bahamas was undergoing a significant enhancement of its technology assets to take advantage of modern technology solutions.
The Authority is tasked with administering the government funded National Health Insurance scheme in The Bahamas through public and private entities
The Approach:
The Outcome:
Data Catalogue and Metrics:
A full review of the data available within the Authority was combined with discovery exercises to understand the KPIs and information required by the Authority to measure its performance and support decision making.
A Data Catalogue describing the data assets available and the transformations that would be required in order to extract the desired metrics was created, with data quality issues flagged for resolution.
Business Case and Proposed Architecture:
A business case for the benefits of the Global Reporting Platform was prepared, which included a proposed cloud architecture, that made use of Platform-as-a-Service resources. Moreover, a running cost estimate was prepared, presented, and approved.
Implementation:
A tenant was set up for the Authority, following dev-test-prod and security best practices.
Extract, transform, load (“ETL”) processes were designed and built, including the use of external data sources through application programming interfaces (“APIs”) for population and standardized diagnosed data.
- Data validation checks were designed and built, including connections with logs and automated alert systems to facilitate monitoring of the quality of the ETL process.
- A data warehouse was designed and built following the Kimball methodology.
- End-to-End Testing, Documentation, Training:
- A an end-to-end testing plan, with specific test cases, was generated and carried out.
- Documentation was assembled to support the client with maintenance of the system going forward and training given as necessary
