|
Development of a Decision Support System through Data Warehousing for a leading
Pharmaceutical chain in the US
Pharmaceutical company with chain across United States and Canada required a centralized analytical and reporting system
to ensure that prescriptions from doctors were compliant within insurance benefits without compromising on health care
services.
Challenge
Pharmaceutical company needed an analytical and and reporting system to provide enterprise intelligence
Solution
- iGlades developed an integrated medical claim system to store the complete health record of a person, containing all
health care data including all clinical and administrative information including laboratory test results, and
pharmaceutical data it collected from its clients.
- iGlades developed an integrated application for to interface data between various applications and health care providers,
pharmacies and health care management companies to create a central system for business intelligence platform to get
critical information to health care providers.
- Patient centric information is designed to provide physicians of patients current medications and help pharmacies and
doctors meet compliance requirements within the approved benefits available under the health care benefits.
Benefits
- Cost savings to the tune of millions of dollar by utilizing alternative lower cost substitutes approved by prescribing
physicians.
- A central repository of patient prescription and treatment information provides data to companies and helps pharmaceutical
companies to forecast trends more accurately and make better marketing decisions.
- Centralizing and offering access to complex patient and pharmacy data saves lives by proactively identifying problematic
prescribing patterns and helping to prevent dangerous situations.
- The company can perform accurate analysis and forecasts trends leading to cost improvement and effective pricing.
Technologies used:
- Data Warehouse - Amazon Redshift
- Data Integration (ETL): Talend 3.x
- Business Intelligence - Apache Spark 3.x, Hadoop 3.x
|
