Unified Platform for Pharmacy Operations
Client Overview
A leading healthcare service provider, specializing in pharmacy and infusion services, wanted to streamline medication management. The project focuses on automating patient eligibility identification and management by providing strong reporting capabilities.
Business Challenge
The client faced challenges that impacted patient care and IT operations:
- Slow Patient Eligibility: Manual verifications caused delays and errors in patient onboarding.
- Complex Vendor Data: Divided and complex file formats from various vendors lead to data silos and inconsistencies.
- Limited Scalability: Faced challenges in rapidly onboarding new vendor eligibility data.
- Reactive Data Quality: Mistakes in vendor data often went undetected leading to downstream issues.
- Inefficient Python Code Management: The existing Python scripts lacked version control, used manual deployment, and had limited monitoring.
- Lack of Reporting: Lack of insights for patient eligibility status and historical changes.
JRD System’s Solution
The client partnered with JRD Systems to provide a Qlik talend cloud-based solution:
- Automated Patient Eligibility: Implementation of Qlik talend cloud jobs for automatically processing the diverse and complex eligibility files from all vendors.
- Flexible Vendor Data Onboarding: Developing a framework in Qlik talend cloud for a quick and automated integration for new vendor data.
-
Python to Qlik talend cloud Migration:
- Re-platforming an existing Python data processing logic into Qlik talend cloud jobs.
- Centralizing code management and version control inside Qlik talend cloud.
- Improved monitoring and orchestration capabilities for all data flows.
- Enabling automated deployment pipelines for integrating jobs.
- Advanced Data Validation: Integrating validation rules within the Qlik talend cloud for identifying data abnormalities and errors.
- Proactive Notifications: Configuring automated alerts for data abnormalities and processing mistakes to relevant teams.
- Comprehensive Operational Reporting: Developing a reporting module and providing granular insights into historical eligibility changes and trends.
- Scalable Cloud Infrastructure: Using Qlik talend cloud's managed services for high resilience.
Key Benefits
The implementation delivered significant improvements across operations :
-
Improved Patient Eligibility Efficiency:
- Decrease in manual hours spent on eligibility verification.
- Reduced average patient onboarding time.
- Minimized eligibility-related data entry mistakes.
-
Automatic On-boarding of New Vendor Data:
- Easier and quicker onboarding of new vendor data streams.
- Improved scalability for growth.
-
Improved Code Management and Deployment:
- Faster deployment cycles for data integration jobs.
- Centralized monitoring which improves operational visibility.
- High developer productivity.
-
Proactive Notifications and Alerts:
- Minimized reactive eligibility data issue at resolution time.
- Overall data quality is improved.
-
Comprehensive Operational Reporting:
- Improved decision-making for risk mitigation.
- Optimized resource allocation based on eligibility trends.
Tools and Technology
