U.S. Prescription Processing and
Clinical Care Enterprise

Industry: Healthcare & Life Sciences

U.S. Prescription Processing and Clinical Care Enterprise

Posted by Encora on May 24, 2023 8:57:41 AM

Encora’s approach drove significant improvements across the client’s eCommerce KPI dashboard.

Topics: Product Engineering & Development, Digital Experience, Quality Engineering, Product management, Cloud Services, Snowflake, DevSecOps, Healthcare & Life Sciences, Data & Analytics

Industry Context

The client, serving both individual and chain pharmacies throughout the United States, offers solutions for prescription processing, strategic decision-making, patient-focused clinical care, and wellness programs. They were among the pioneers to adopt Snowflake when it debuted in 2014. This early adoption allowed them to harness its evolving features and even request that new elements be added.

Client Challenge

Our client aimed to enhance its business intelligence by collecting information on all their pharmacies and presenting the analysis to them via a SaaS platform.
The existing data warehouse hosted on-premises could not analyze data from multiple pharmacies or an entire chain of pharmacies.
The company also needed the system to perform ad hoc queries.
They also struggled to process large volumes of data; acquiring additional hardware was quite expensive.

Approach

Product Management, utilized JIRA for effective maintenance of epics and user stories.
Cloud Services, advanced data visualization, bulk data ingestion, and continuous data ingestion used snow pipes.
Platform Modernization, incorporated a modern data stack with SnapLogic for ingestion, Snowflake for the data warehouse, and Looker for reporting.
Product Engineering & Development, homed in on ETL process design, development, and testing, with the added support of QA automation.
DevOps, streamlined operations to achieve single-click deployment that covered everything from provisioning the server with VMware to deploying application artifacts.
Data Modernization & Engineering, harnessed the power of SnapLogic to assist clients in ingesting data from various sources into their data warehouses.
Quality Engineering, revolved around the design and execution of a robust infrastructure, leveraging tools like SnapLogic and the Looker API for consistent automated testing results.
Digital Experience, helped craft intuitive design, agility, safety, ease of use, and a flexible architecture.

Results

Pharmacies can now understand their operations, finances, and clinical decisions that prioritize patients.
Due to Snowflake's seamless integration with Looker, optimized usage of SQL, and minimized joins, the client could attain the targeted query performance using a warehouse that was half the size of its competitors.
Users can utilize a unified interface to perform various tasks, such as logging into accounts, creating new databases and warehouses, and managing permissions.
Our client can now identify the top-performing technicians in a pharmacy with the lowest rates of errors and subsequently improve their utilization rates.
Initial data migration decreased from 1800 minutes to 12 minutes.
EDW processing decreased from 780 minutes to 7 minutes.

Initial data migration

EDW processing

Client Success Stories

Digital Health Insurance Provider in Telemedicine

Elevating telehealth efficiency with a robust, centralized ticketing application

Learn More

SMB Payment Solutions Provider

Transforming the SMB Payment Solution Provider's Infrastructure, Driving Growth and Efficiency.

Learn More

Manufacturer and Supplier of Contact Lenses

Developing a customized software solution to streamline workflow and enhance efficiency for the ...

Learn More

PLM Solutions Provider in Retail & CPG

Enabling the client to reduce costs, drive innovation faster, and provide a future-proof platform ...

Learn More

A Global Leader in Consumer Intelligence

Driving innovation for improved team velocity, transformed operations and customer service, and ...

Learn More

Mental Wellness Application

Fostering a collaborative partnership for migration of meditation training program to a mobile app

Learn More

Water Utility Company

Addressing the water company’s critical challenges with application modernization, transforming the ...

Learn More