Comprehensive Health Case Management
Case Study
Increasing Capability through Cooperation
The Problem
Allow pharmacists to exchange real-time information with the entire patient-care team focusing on improving health outcomes, engaging patients, and reducing costs.
Building this solution required large volumes of data to be moved from the retail pharmacy to the case management software. This introduced complexity and performance challenges.
The Goal
Strategic Data Systems was tasked to design and test a solution to move large volumes of pharmacy data from several disparate retail pharmacy systems into a centralized case-management software solution.
The data needed to move quickly to the destination system with multiple transformations from the origination system format.
Solution Summary
Strategic Data Systems provided a team of 7 developers to assist in the data integration of these two companies and systems. Data from over 2,000 retail pharmacies and medical clinics was collected in near, real-time for ingestion into a case management tool that allowed patients and prescribers to view their records.
SDS used SQL Server Integration Services (SSIS) to develop autoate ETL process to pull data from pharmacy system APIs, transform that data into useable format, and load it into the case management software. SDS institued new processes for managing and testing SSIS packages, and pushed for parity of test and development environments that allow testing of changes in sanitized systems that protected HIPAA data, but was more representative of the scenarios deployed in production.
SDS developed an automated testing process for SSIS packages that increased testing accuracy and scale by an order of magnitude. SDS was capable of testing with 5 people what previous took 80 people. This test architecture was deployed into other organizations increasing worker productivity.
#SQL Server 2012
#SSIS
#Azure DevOps
#Remote Teams
