Hannover Re - AI Contract Matching and Data Vault DevOps

Modernized reinsurance data operations with AI lookup, Data Vault 2.0 warehousing, and DevOps automation in Azure

Hannover Re partnered with TaylorMade Software to enhance its reinsurance data platform by embedding AI-driven contract identification and automating legacy deployment workflows across SSIS, SSRS, and SQL Server assets.

We developed a proprietary AI Expert System to enable reverse lookups from incomplete underwriting inputs, helping analysts and underwriters find the correct reinsurance contract matches faster. This reduced lookup time and increased accuracy across underwriting workflows.

Our team implemented Data Vault 2.0 architecture in SQL Server using SSIS packages and stored procedures for scalable, auditable warehousing. For deployment, we modernized their DevOps lifecycle with Azure DevOps YAML pipelines, integrating Liquibase, SSDT, RS.exe, ISDeploymentWizard, and SqlPackage.exe to create a repeatable, rollback-capable deployment pipeline.

We also authored PowerShell automation scripts to manage releases for SSIS projects, SSRS reports, and all associated SQL Server components. These efforts improved compliance, traceability, and deployment velocity, cutting manual errors by over 40%.

Related Case Studies