Digital Business Transformation of a Major Health Care provider (On Premises DWH To Data Lake House)
Background
Our client is a leading provider of imaging and diagnostics products for healthcare services across the globe, this story is based around our primary service area in NA market.
Key Issue
Despite of any enterprise having ts dedicated and Enterprise IT team, the business team has their own challenges driven by time to delivery, time to support vs time to market. We helped client’s Data team to achieve few major cloud based digital data transformations.
Solution
• We architected and implemented the BI solution constituting of BigData
and OLTP,with Horizontally shared Azure DWH Analytics and DeltaLake
using Databricks and synapse.
• Right from defining the project plan and adoption of AzureDevops we have
been active in setting up right tools and practices automated with Azure
Devops. We integrated DataBricks, DataFactory, Snowflake, ADLSGen2
with Synapse Analytics to build state-of-the-art automated Analytics Based Datawarehouse solution that can process records even with drifting and SCD sources.
• The data and tool migration involved a next gen transformation consisting
of migrating on-premises data warehouse using SSIS, SSAS and SQL server enterprise mixed with AWSRDS and Teradata to state-of-the-art deltalake using DataBricks automating Integration with SAP and Salesforce and salesforce analytic stool such as Einstein to Snowflake and Tableauto PowerBI.