Context
A regional P&C carrier was manually re-keying policy data between three systems - their AMS, a carrier portal, and an internal Excel tracker - consuming 3 full-time staff hours per day.
Insurance
Insurance Carrier Data Integration
Eliminated 15 hours of manual data entry per week. Error rate on policy records dropped from ~4% to under 0.2%.
Solution
Built a .NET 8 integration service that pulls policy data from the carrier API, normalizes it against the AMS schema, and writes reconciled records automatically. Deployed to Azure Container Apps with full audit trail.
Constraints
- • Carrier API rate limits required queued retries and backoff orchestration.
- • Legacy AMS field mismatches required configurable transformation rules.
15 hrsWeekly hours saved
−94%Error rate
Week 1
Discovery & schema mapping
Mapped AMS objects to carrier API payloads and defined exception classes.
Weeks 2-5
Pipeline build
Implemented ingestion, normalization, reconciliation rules, and audit logging.
Weeks 6-7
UAT and go-live
Validated with live policy samples and cut over in staged cohorts.
Timeline
7 weeks
Stack
.NET 8Azure Container AppsAzure SQLCarrier REST API