Live system · Golden Record RAG Pipeline

Fragmented customer data, resolved into one trusted record.

A production-deployed customer-data platform for fintech compliance — entity resolution, survivorship, attribute lineage, vector RAG and GDPR tooling, running end-to-end on 89,198 real-scale records. Open the live app, the animated architecture and the guided playbook without leaving this page.

89,198Source records
20,502Golden records
51.9%Multi-source customers
35,000RAG chunks indexed

Open the live app inside this page.

The full Lovable front end — dashboard, compliance chat, customer portal and GDPR tooling — loads in a window over this page. No new tab required. Backed by a FastAPI service on Railway with a dual-persona API.

Living architecture

How fragmented data becomes one Golden Record.

A guided, auto-playing walkthrough of the real pipeline — ingest, data quality, entity resolution, survivorship, the Golden Record, and grounded compliance AI.

golden-record · living-architecture ⤢ Fullscreen

Why it matters

Governed AI, not a slideware demo.

Proves

I design and ship governed data + AI systems end-to-end — MDM-grade entity resolution and survivorship, lineage on every field, and a vector-RAG layer that answers compliance questions from trusted records, not raw text.

Why it matters to enterprises

In regulated BFSI, a "single customer view" is only useful if every value is explainable and every AI answer is grounded. This shows that discipline as working software a CDO, steward or auditor can click through.

Governance controls

DQ scoring & quarantine Entity resolution (fuzzy + ML clustering) Survivorship trust rules Regulatory lock (KYC / PEP / sanctions) Attribute lineage Human stewardship gate Grounded RAG (pgvector) Dual-persona API GDPR tooling

Pipeline

01

Ingest

Load all sources, parse, normalise — keep every record traceable.

02

Data Quality

Score completeness, format, consistency; quarantine weak records.

03

Entity Resolution

Fuzzy + Soundex/Metaphone + ML clustering group identities.

04

Survivorship

Trust weights, recency & regulatory lock pick winning values.

05

Golden Record

One authoritative profile with confidence and full lineage.

06

RAG Index

35k chunks in pgvector for grounded compliance queries.

07

Dual-persona API

Compliance (full) vs customer (filtered) self-service.

Guided demo playbook

Follow one customer, end to end.

A 12-step, self-guided walkthrough that follows one customer — Rachel — from four conflicting source records to a safe, explainable customer experience, in plain English. Click through it, or open it fullscreen.

golden-record · demo-playbook ⤢ Fullscreen

Live stats

Real scale, real evidence.

150,000Transactions linked
0.637Avg confidence score
99PEP customers flagged
20Sanctioned customers

Stack

FastAPI + uvicorn PostgreSQL 16 + pgvector SQLAlchemy 2.0 sentence-transformers (MiniLM, 384-dim) Railway (API) Lovable (front end)