← All work

SEC-registered RIA — confidential

Advisory Firm Data Assessment

Finding out what the AI project actually was, before building it

1,953 records checked, nothing altered
9.5% had an advisor assigned
4 fields recording "advisor"
Illustration of a review screen: a browser window holding two columns of checklist items, most ticked and two flagged, beside a summary card and a small bar chart.

The firm wanted AI-assisted client summaries. Before writing anything we went through every contact record in their CRM — read-only, nothing changed, no client data stored — and found the real problem: an advisor was assigned on 9.5% of client records, and "advisor" was recorded across four different fields depending on who had entered it. Any automation built on that would have produced confident, wrong output. What we delivered was a plan the firm could act on, in the order that made each next fix possible. The Wealthbox-to-Outlook sync that came out of it was a byproduct, not the point.

Stack & scope

AssessmentArchitectureRoadmapAzureWealthboxMicrosoft 365