US Based Commercial lines Insurer

US Based Commercial lines Insurer

Claims Migration from Legacy to DC Claim – DC Insights

Project 1 - SQL Server, AC Legacy System, PDS Legacy System, DC Data Insight, Power Bi & AZURE Data Factory

Project 2- SQL Server, Azure function using .NET, Snowflake, Azure Data Factory & manage instance, Duck Creek data Insights (Clarity), Express

• Migrated the Legacy Claim data from two different system to DC claim Data Insight

• Gap Analysis played a critical role in the success of the implementation.

• Mapped the elements between the two system.

• Designed the staging environment to load the claims.

• Designed and developed the ETL to migrate the data.

• Designed and developed a reconcile report to the validate the data purity.

• Post data loaded in to staging configure the DCT CMU was utilised to migrate the data from staging the Data Insight

‍

• Newer Approach helped save cost and improved delivery timelines.

• Migrated the Legacy Claim data from legacy system to DC claim Clarity.

• Two-way gap analysis was done between the legacy system and DC Claim

• Mapped he elements between the two system.

• Designed the Azure Manage Instance staging environment to load the claims.

• Designed and developed the ETL to migrate the data from Legacy system to Staging

• Designed and developed a Clone of Clarity Silver Layer and developed ADF pipe lines to migrate the data from AZURE Manage Instance Staging to Clarity Snowflake

• Post data load in to staging, utilized the azure pipelines to migrate the data from Manage Instance staging to Clarity Non DCT Silver Layer

• Validated Clarity Gold Layer views and Power BI reports

• Compliance & Regulatory adherence
‍
• Market Insights and Competitive Intelligence