Business Context
In today’s value-driven business landscape, Enterprise Performance Management (EPM) is a critical force that aligns and integrates strategic goals with day-to-day operational, financial, and risk management activities. It provides the framework that enables organizations to accurately measure and analyze performance for improved decision-making – ultimately leading to accelerated and profitable growth, and enhanced reputation.
For a market leader in benefits funding and payments solutions, Mastek transformed the legacy on-prem source data to a modern data warehouse with a scalable data lakehouse architecture using Databricks – enhancing their performance and agility with significant cost saving.
The Client
Our client is a US-based market leader in SaaS-based benefit funding and payment solutions in consumer-directed healthcare (CDH). Partnering with health plans, TPAs, and financial services providers, they deliver scalable, customizable solutions that integrate health and wealth management. A pioneer of innovative solutions (such as the first FSA debit card), and single-source platforms for account and card administration, our client leverages advanced technology to improve consumer healthcare engagement and outcomes. It processes more than USD 6 billion in healthcare transactions annually, and has consistently outperformed competitors by significant margins.
The Challenge
With its committed customer-centric approach, our client wanted to further improve its strong ability to respond swiftly and effectively to the requirements and demands of its business- and end-users. Agility and scale were critical as they looked to develop and implement a transformation strategy with a flexible cloud architecture, automated processes and modernized front-end.
To this end, the following challenges needed to be addressed and overcome:
- Inability to support data growth with a simple, cost-effective solution
- Absence of self-service reporting capabilities
- Lack of multi-tenant architecture
- Managing multiple databases
- High maintenance cost
Mastek enabled the client to decomplex the digital transformation of its legacy on-prem source data, implement a lakehouse architecture, and bring aggregates and mart data into the data warehouse for downstream reporting and consumption.
Solution
Mastek was selected for this transformation exercise based on our proven expertise in
- Migration to Databricks
- Modernization of reporting solution models to achieve speed in application and significant reduction of maintenance cost
- Effective proof-of-concept to establish the right architecture and environment to implement this transformation
- Designed scalable workflows and ETL jobs in Databricks
Demonstrating high capability in its understanding of the client’s challenges, Mastek swiftly identified the need to upgrade and modernize its on-premises solution to the Databricks Lakehouse architecture.
With its vast experience and expertise in modernizing and implementation of data warehouse and Lakehouse, the Mastek team
- Implemented a medallion architecture by bringing data from various source systems into the bronze layer
- Developed dimensional data modelling and its tables using business transformation into the silver layer and gold layer with aggregates and facts table consumed by downstream reporting application
- Prepared new logical data models by defining entities, attributes, relationships and keys for new paginated report requirements in coordination with business teams
- Modified the existing logical data model to incorporate changes occurred in the source system to keep it up to date
This resulted in a centralized and modern data warehouse platform, which enabled the client to significantly enhance performance, accelerate query response times and achieve high-cost efficiency. Additionally, Mastek provided distinct value-additions through its re-usable framework and secure self-service reporting capability with modern tools.
The Outcome
Mastek’s transformational solution achieved a host of positive outcomes to enable the client outperform on its goals of performance efficiency, speed, scalability, agility, and cost efficiency, as follows:
- 3x improvement in ad hoc query response times
- An 80TB to 1PB scalability with high data availability in handling consumer data growth
- 16% reduction in annual OPEX for high-cost efficiency
- Workflow adjustments in data lake made in minutes
- Seamless and uniform reporting
- Re-usable framework and modern tools with secure self-service reporting capability
