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.

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
Pharmacy metric -99.4%

Initial data migration

Pharmacy metric -99.1%

EDW processing

Client Success Stories

Water Utility Company

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

Learn More

Insurance & Asset Management Solutions Provider

Developing a modern Agent & Broker Sales Platform with encriched functionality

Learn More

UK Manufacturer of Intelligent Cash Handling Devices

Enhancing operational efficiency through the launch of enhanced middleware, a cloud-native device ...

Learn More

Credit Union Insurance Provider

Revamping underwriting for efficiency, discipline, and cost savings with automation

Learn More

Intelligent Systems Provider

Unleashing the potential of 5G edge computing for deploying a carrier-grade Cloud-Native Platform

Learn More

Administrator in the 340B Drug Pricing Program

Revolutionizing 340B Program Efficiency with advanced Healthcare technology solutions

Learn More

Bakery Franchise

Using seamless data integration and analytics to equip bakeries with a competitive edge

Learn More
More Success Stories

Innovation Acceleration
Headquarters - Scottsdale, AZ 85260
© Encora Digital LLC
letstalk@encora.com

letstalk@encora.com Terms of Use Privacy Policy Cookie Disclosure Policy Disclaimer Sitemap