About the Client
The client is a telemedicine provider company that simplifies access to everyday, non-controlled medications through a seamless telehealth and pharmacy model. Through their platform, independent providers can connect with patients via telehealth, prescribe suitable medications, and have them delivered directly to patients’ homes. Collaborating with doctors, veterinarians, practice groups, and other licensed prescribers, the client empowers healthcare providers to offer a personalized, patient-first pharmacy experience that increases engagement, satisfaction, and continuity of care.
Business Challenges
The client faced data integration and accessibility challenges that affected decision-making across teams. Their data was scattered across two different sources, Amazon RDS (MySQL) and FreshPaint, each storing sensitive customer and business information in different formats. This data fragmentation made it difficult for operations, marketing, and care teams to get a consolidated view of the data. Generating reports or deriving insights requires manual data extraction and reconciliation, leading to delays, inconsistencies, and limited visibility into patient behavior and service performance.
The client needed a centralized data warehouse that could seamlessly consolidate data from both MySQL and FreshPaint into a single, consistent format. This would enable real-time analytics, eliminate silos, and empower cross-functional teams to make faster and data-driven decisions.
Kasmo’s Solution
To overcome these challenges, Kasmo implemented a comprehensive data migration process to help the telemedicine provider unify and optimize their healthcare data infrastructure. The key steps involved were:
Data Migration from FreshPaint to Snowflake
Our experts designed data ingestion pipelines for data sharing between Freshpaint and Snowflake. Create Snowflake tables to store and manage the ingested data efficiently. Using data ingestion capabilities, data from FreshPaint was continuously loaded into Snowflake, capturing updates in near real time.
MariaDB to Snowflake Migration
To consolidate clinical and operational data, our team used Fivetran to extract and migrate data from MariaDB into Snowflake. All existing procedures, views, and scripts were translated into Snowflake-compatible syntax with query optimization for performance enhancement. Post-migration, row-level, and summary validation were performed to ensure data accuracy. Power BI dashboards were re-pointed to Snowflake to ensure uninterrupted visualization and analytics.
Validation and Reconciliation
A detailed validation and reconciliation process was carried out to ensure complete data integrity between the source systems and Snowflake. Automated checks compare record counts, key metrics, and data accuracy across both systems.
Built Harmonization Layer
Our experts implemented a data harmonization and quality layer to standardize and clean the ingested data. This process includes data quality checks, cleansing, and preprocessing to make the data reliable and analysis-ready.
Key Results Achieved
Kasmo helped the client to eliminate these challenges by establishing a unified and governed data foundation. The key results achieved include:
Automated Data Pipelines: Established end-to-end automated data pipelines from all legacy systems. This helped with seamless data flow and real-time insights across departments.
Enhanced Data Governance: Implemented robust data governance with role-based access, data masking, and security controls to ensure compliance with healthcare data regulations and protect sensitive information.
Actionable Business Insights: Delivered integrated dashboards and reports, empowering teams with data-driven insights for faster decision-making.
Data Access: Optimized data infrastructure and processes led to 3X faster data access, accelerating analytics and operational workflows.
Reduced Manual Processes: Automated ingestion and validation process reduced 80% of manual efforts, minimizing errors and improving productivity.
Reporting Efficiency: Enhanced reporting processes by 70% for quicker insights generation and improved visibility across business functions.
