Data Lake Layer for Pharmacy Integration Service

Opsfuse > Case Studies > Data Lake Layer for Pharmacy Integration Service

DOMAIN: Healthcare

OVERVIEW:

OpsFuse collaborated with a leading USA-based healthcare platform that connects patients, providers, and healthcare companies. The client encountered challenges with legacy SQL databases consisting of a decade of data, leading to delays in delivering patient data to various pharmacy web applications.

SCOPE:

  • Scalable solution to enable real-time data access for seamless integration on new pharmacy websites

  • Robust authentication and authorization mechanisms

  • Seamless integration with new pharmacy websites

SOLUTIONS:

  • Design and Implementation of Data Lake using Azure technologies

  • Scalable and cost-effective storage solution for legacy SQL’s

  • Real-time Data Pipeline and Change Data Capture (CDC) Pipeline capturing and synchronizing updates from the internal data warehouse to the database in real-time

  • Robust API infrastructure for seamless communication between the client’s healthcare platform systems and external applications

  • Design and implementation of RESTful APIs for patient workflows

  • Multi-tenant e-commerce platform supporting seamless onboarding of multiple drug manufacturers

  • Adherence to HIPAA compliance standards

  • Payment gateway Integration with trust commerce

CHALLENGES:

  • Studying complex SQL queries and transforming them into a document format

  • Understand the existing manual workflows, internal processes, and standards

  • Mapping legacy systems with new technology stack in collaboration with multiple stakeholders and teams on client side

  • Complex business logic for Patient workflow implementation

  • Studying existing ETL and rewrite as applicable for faster access

IMPACT:

  • Transformation of traditional healthcare systems into an automated platform, expediting processes and reducing costs.

  • Improved data management practices, leading to enhanced data reliability and accessibility.

  • Streamlined user workflows, resulting in improved efficiency and user satisfaction.

  • Migration of healthcare data to the cloud adhering HIPAA compliance standards

  • Overall improvement in efficiency, affordability, and accessibility of healthcare services.

TECHNOLOGY:

  • Java, Python

  • Scala, Shell Scripting, Golang

  • Keycloak authentication

  • TrustCommerce payment gateway

  • Azure Cloud Platform

  • Cassandra, PostgreSQL

  • Distributed Queues – Kafka-zookeeper, Azure HD insight (Native Kafka support)

  • Analytical Tools – Azure Data Factory, Azure Blob Storage, HADOOP, Hive