A comprehensive solution for migrating the data platform for legal portfolio of a P&C insurer’s corporate IT to Azure public cloud
A major P&C Insurance company with operations across 18 countries in 900 locations globally wanted to phase out its existing, on-prem tools in use like Teradata, Informatica, Cognos, etc. to a cloud environment leveraging the managed services (PaaS) model for better cost and operations management.
Trianz was engaged to develop a comprehensive solution for migrating the insurer’s data platform for legal portfolio, part of the corporate IT, to Azure public cloud by re-creating the entire ETL process using native Azure services.
Dependency on environment ownership – Currently, Teradata & Informatics are owned by different groups.
Data centralization – No single source of truth & multiple redundant tools, internal administrative dependencies and bottlenecks.
Environment upgrades and patches – Regular environment upgrades, patches and restarts impacting application availability.
Limited scalability and tuning – Scaling the current infrastructure on ad-hoc needs, which is expensive.
Data Factory V2
Visual Studio Team Services
Data & ETL Migration: 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. Perform the data orchestration, leveraging the ADF V2 and load to SQL DW and replacing Teradata and Informatica.
Data Validation: Automate QA with Trianz Data Vision+ to validate data on an on-prem vs. Data Lake Store on Azure.
Data Science: Provide data scientists with the capability of leveraging the Azure Databricks service to perform advanced analytics and ad-hoc querying.
Security: Leverage Azure AD service with Service Principal MFA.
Visualization: Rewrite the canned reports using Power BI and replaced Cognos.
DevOps: Leverage MS VSTS to create a CI/CD pipeline to achieve end-to-end automated build and deployment process.
Monitoring: Use Azure Monitoring service to monitor the service and infrastructure health and availability.
Contact Us Today
Our engagement with Trianz has now exceeded three years, and together we have delivered many significant initiatives in that time. Many of our successes could not have been achieved without our partnership. In many ways, Trianz has already put our products ahead of the curve.
The white glove approach, agility, and flexibility of the team helped us to tap opportunities in the ever-changing business environment.
Trianz team worked side-by-side with us to transform our sales operations. Now, we have complete visibility into everything from our supply chain to sales and pricing. Our partnership with Trianz has been exceptional.
The team at Trianz worked tirelessly to propose a system that overcame our business challenges. Rising to the occasion, they simplified our processes, enhanced the system and increased productivity. There’s no doubt; our ongoing success was enabled by our partnership with Trianz.
Trianz commitment to taking end-to-end ownership of developing the e-commerce web app is exemplary. Their dedicated involvement was key to us garnering the advantages of automated test suite development and manual testing