Counterparty Data Reconciliation at Scale: A 350,000-Record Case Study - E133

Most counterparty data reconciliation projects fail at the same assumption: that one identifier — usually a tax ID — can resolve who you're actually doing business with. In Episode 133 of What Counts, Maura Dunn walks through a real two-year project to reconcile 350,000 counterparty records across eight systems at a company built through acquisition: four contract management platforms, one ERP carrying both customer and supplier masters, and three trading systems, each with its own naming conventions, character limits, and overflow fields. She unpacks the 18 months of unproductive matching that came first, the rule-precedence approach that finally worked once Snowflake and Elasticsearch replaced the spreadsheet attempts, and the 10-to-1 collapse from 350K records down to 35K true entities. She also makes the case for where AI fits this kind of work today — and the one thing it still can't do unless you put deep institutional knowledge into the prompt. If you want to see what's hidi...