P&C Insurance Legal Platform
The client is a major P&C Insurance company with operations across 18 countries in 900 locations. Trianz helped the company with an analytics platform on Azure, leveraging the native Azure services to achieve similar functionality after replacing many external ETL and BI tools on-prem.
Trianz achieved complete ownership of a cost-effective data platform for a non-revenue generating business unit, Data Centralization as there are multiple versions of redundant data across platforms.
To Transition to a data platform on Azure for a major P&C Insurance company - Technology Strategy & Implementation
Azure Data Lake Store, Azure Data Factory, Azure SQL DW, Azure Analysis Services, Azure Databricks, Azure Data Lake Analytics
Roadmap Phase: Approach
Analyzed current business and IT pain points to prioritize needs
Data centralization
Complete ownership of the platform, limited scalability and tuning of current platform without major hardware upgrades
Implementation Phase:Solution Design and Implementation
Move the data from on-prem using ADF V2 to Azure Data Lake Store and perform the ETL operations using Azure Data Lake Analytics.
Using U-SQL to perform the data orchestration, leveraging the ADF V2 and load to SQL DW. Replace Teradata and Informatica.
Rewrite the canned reports using Power BI and replace Cognos.
Provided data scientists with the capability of leveraging the Azure Databricks service to perform advanced analytics and ad-hoc querying.
Leverage MS VSTS to create a CI/CD pipeline to achieve end-end automated build and deployment process.
Use Azure Monitoring service to monitor the service and infrastructure health and availability.
Automated QA with Trianz Data Vision+ to validate data on-prem vs. Data Lake Store on Azure.
Built prototypes and PoCs to validate the end state and the intended value promise.
Manage the organizational change effectively.
Contact Us Today
Let’s Talk
x