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)