success/prescription-processing-and-clinical-care-enterprise

U.S. Prescription Processing and Clinical Care Enterprise

U.S. Prescription Processing and Clinical Care Enterprise

Industry: Healthcare & Life Sciences

talk to an expert

U.S. Prescription Processing and Clinical Care Enterprise

Industry: Healthcare & Life Sciences

talk to an expert

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.

PH Industry

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.

PH Challenge

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.

PH Approach

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.
PH  Results

Initial data migration

Pharmacy metric -99.4%

EDW processing

Pharmacy metric -99.1%

Client Success Stories

Discover how our strategic innovation accelerates impact for fast-growing enterprises and digitally-native companies.

More Success Stories

LendKey’s Agile Transformation with AWS

Increasing Deployment Frequency by 200% and Reducing Infrastructure Costs by 30%

Read More

SMB Payment Solutions Provider

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

Read More

Insurance & Asset Management Solutions Provider

Developing a modern Agent & Broker Sales Platform with encriched functionality

Read More
Previous Previous
Next

Accelerate Your Path
to Market Leadership 

Encora logo

+1 (480) 991 3635

letstalk@encora.com

Innovation Acceleration

Encora logo

+1 (480) 991 3635

letstalk@encora.com

Innovation Acceleration