Increasing Capability through Cooperation
A large retailer with in-store pharmacy and a patient case-management company decided they could work together to improve retail pharmacy patient care. They implement the Pharmacist Care Plan that contains information on the patient, pharmacist, and care team’s concerns and goals related to medication optimization.
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.
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.
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