About the Client
Our client is a leading specialty pharmaceutical and medical device company dedicated to advancing targeted therapies for liver and cancer patients. The client is primarily focused on improving patient outcomes with primary and metastatic liver cancers by using innovative and minimally invasive solutions. Their treatment enables targeted delivery of therapy and minimizes drug-related side effects. They combine pharmaceutical innovation with advanced medical technology to enhance clinical efficacy and improve patient safety in the oncology sector.
Business Challenges Faced by the Client
The client faced major challenges in managing and utilizing its diverse data ecosystem. The client’s sales team struggled with fragmented and disconnected healthcare data across multiple sources. This made it difficult to get claims data to reach the right HCPs (Healthcare Professionals) and HCOs (Healthcare Organizations) effectively. Due to a lack of an integrated data foundation, sales representatives had limited access to accurate, timely, and actionable intelligence, leading to inefficiencies in targeting, slower decision-making, and missed engagement opportunities.
To overcome these challenges, the client needed a unified data platform to support seamless healthcare data integration, advanced analytics capabilities, and optimize commercial strategies.
Kasmo’s Solution
Symphony Healthcare Data Integration
Integrated Symphony Health’s patient-level claims datasets, consisting of doctor information, patient medical condition, and hospital records, into Snowflake. Using secure data-sharing mechanisms, the team established continuous synchronization of claims data, creating a single source of truth for analytics and downstream systems.
MedPro Integration to Snowflake
Our team enabled seamless connectivity with MedPro Systems to enrich provider data. Also, standardization and enrichment rules were applied to unify HCP (Health Care Professional) and HCO (Health Care Organization) information across systems. This created a consistent and accurate provider profile database for the sales team.
HubSpot Integration to Snowflake
Integrated HubSpot CRM with Snowflake to consolidate patient claims and provider data, Openflow framework. Created a Patient Journey (PTJ) custom object in HubSpot to capture patient touchpoints, and mapped it across to HCPs, HCOs, and claims data.
Event Data Model Consolidation
Developed a harmonized Silver Layer data model in Snowflake, integrating data from Symphony Health, MedPro, and HubSpot. Standardized business entities and relationships were validated for consistency and accuracy.
Analytics and Reporting
Our team created Tableau dashboards to provide event-based analytics and insights into sales performance and HCP engagement.
Data Governance
Our team established a robust and compliant Snowflake data environment, designed to meet HIPAA and healthcare data privacy requirements. Comprehensive data governance policies were implemented, like access control, data encryption, and key management. Defined clear governance of workflows, user roles, and operational processes for better management and compliance.
Key Results Achieved
Kasmo implemented a unified Snowflake-based data platform that helped the client’s sales team with actionable insights and improved data-driven decision-making. The outcomes included:
Enhanced Patient Targeting: Achieved a 60% increase in patient data visibility, enabling the sales team to identify and engage the right HCPs and HCOs more effectively. This helped in gaining clearer insights into revenue potential.
Optimized Sales Performance: Streamlined sales processes and workflows led to a 30% increase in conversion rates, helping the team focus on high-value opportunities.
Accelerated Decision-Making: Real-time analytics and integrated data sources resulted in a 65% faster conversion rate, shortening the time from lead identification to engagement.
Business Expansion: The client could also extend into additional oncology lines and expand into new regions, improving market reach and commercial strategy.
