We built a cedant data analytics pipeline over 18 weeks. (1) Universal cedant data parser: ML-based document understanding for automatically parsing cedant submissions regardless of format. Schema detection: the system analysed each submission, detected the data type (loss data, exposure data, premium data, claims data), identified the schema (column names, data types, coding schemes), and mapped fields to the reinsurer's canonical data model. Format handling: Excel (multiple sheet layouts), CSV (various delimiters and encodings), PDF (both structured tables and narrative text), and structured data files (RMS, AIR formats). Mapping accuracy: 92% of standard fields automatically mapped (validated against historical mappings for known cedants). Remaining fields flagged for analyst review. Time savings: analyst time on data ingestion from 65% to 25% — the parser handled standard submissions automatically, with analysts focusing on exceptions.
(2) Automated data quality: validation rules for each data type — loss triangles (monotonicity checks, development factor reasonableness, incurred/paid consistency), exposure data (aggregation validation, geocoding verification, value reasonableness), premium data (written/earned/unearned consistency, timing alignment), and claims data (reserve adequacy checks, payment pattern analysis). Quality scoring: each cedant assigned a data quality score — tracked over time and factored into underwriting assessments (poor data quality from a cedant was a risk factor). Automated cleansing: common issues (currency normalisation, date format standardisation, code mapping, duplicate removal) handled automatically with audit trail documenting all changes. (3) Historical data migration: 20 years of legacy data migrated into the unified data lake — OCR processing for paper records, database extraction for mainframe data, and file parsing for Excel/Access archives. Historical data linked to current cedant identifiers through entity resolution — enabling complete longitudinal analysis.
(4) Near-real-time portfolio monitoring: streaming pipeline ingesting bound risk data from underwriting systems worldwide — updating aggregate exposure, concentration, and accumulation metrics in near-real-time (from quarterly). Catastrophe model integration: exposure data automatically formatted and submitted to catastrophe models (RMS, AIR) for daily PML calculation (from quarterly). Alert generation: automated alerts when aggregate exposure approached limits or concentration thresholds were breached. (5) Cross-office data harmonisation: canonical data model enforced across all 12 offices — standardised field naming, currency handling (all converted to EUR base with original currency preserved), coding schemes (standardised industry codes, geography codes, peril codes), and quality thresholds.