Policy & Claims Data Vault
Consolidates policy, billing, and claims systems into a data vault model (hubs/links/satellites), then exposes star schemas for underwriting, finance, and actuarial reporting. Includes CDC handling and history tracking.
Insurance — Data Engineering & Analytics
Projects across policy, claims, and actuarial domains — from core data platforms to pricing, fraud detection, and regulatory reporting.
Featured Insurance Projects
Pricing & Underwriting Risk Analytics
Builds exposure, premium, and loss marts by line of business, territory, and segment. Supports analytics on loss ratios, rate changes, retention, and new business vs renewals.
Claims FNOL & Severity Prediction Data Pipeline
Curates First Notice of Loss (FNOL) and downstream claim events into an ML-ready feature store for severity and litigation propensity models. Includes text fields, adjuster notes, coverage, and vehicle / property attributes.
Customer 360 & Lapse Propensity Analytics
Combines policies, interactions, payments, and claims into a customer 360 layer, with features for lapse propensity and cross-sell. Enables targeted outreach lists and retention reporting.
Regulatory & Statutory Reporting Data Mart
Defines a controlled data mart for regulatory/statutory reporting (e.g., schedules, solvency ratios), with strong data lineage, reconciliations, and sign-off workflows integrated via dashboards and exports.
What this demonstrates
- Designing insurance-specific data models across policy, billing, claims, and actuarial domains.
- Building Snowflake / Databricks platforms for pricing, fraud, retention, and regulatory analytics.
- Preparing ML-ready feature stores for claims severity, lapse, and cross-sell models.