Association, Healthcare

National Healthcare Organization Benefits from Improved Data Management Practices

UDig assisted a national healthcare association with replacing a legacy system that allows their program members to understand performance relative to other member organizations and monitor the progress of their organization over time. The modern, user-friendly solution created a secure platform for members to upload their data, an ETL process to cleanse and integrate the uploaded data, a new data warehouse with improved schema to support the integrated data and a metrics process for calculating benchmarking information.

LET'S BE BRIEF

Challenge

Modernize legacy system to reduce likelihood of error and eliminate cumbersome and manual processes in place for uploading and analyzing data.

Objective

Build user-friendly, secure platform allowing for easy upload and integration of data.

Solution

Web-based system with ETL process to cleanse and integrate uploaded data, with new data warehouse to allow for robust benchmarking and analysis.

The web-based platform, ETL process and new data warehouse allow for more advanced benchmarking and analytics capabilities.

THE EXTENDED VERSION

Challenge

A national healthcare association had a legacy system for program members to upload data, allowing the organization to analyze the data and provide benchmarking reports to members. The process to clean and integrate data was very manual and time-intensive. A more streamlined, efficient process was needed to provide better analysis, more timely results, and fewer errors.

Solution

UDig built a user-friendly web-based access point allowing members to easily and securely upload ePHI data to the association. UDig created the web-based platform, an ETL process to cleanse and integrate the uploaded data, and a new data warehouse with an improved schema to support the integrated data which will allow for more advanced benchmarking and analytics capabilities. The streamlined processes will allow the association to provide even more valuable reporting back to member organizations to help them measure and improve organization performance.

How We Did It

API Development
Cloud Selection & Migration
Dashboard UX/UI
Interactive BI Application
Platform Analysis & Selection

Tech Stack

  • Agile Development
  • Amazon Aurora (MySQL)
  • Amazon Web Services
  • Dataverse ETL
  • Elastic Compute Cloud (EC2)
  • Java
  • Lambda
  • Microsoft SQL
  • SSIS