Data migration services

Three kinds of people call me.

Firms that acquire practices, firms moving to Financial Services Cloud, and Salesforce partners who need someone to own the data. Pick the one that sounds like you. Each opens in a new tab.

Not one of the three? I also do standalone migrations into Salesforce and FSC from any source: legacy orgs, org-to-org consolidations, SQL and Access databases, spreadsheets. Book a call →

The methodology

Seven steps, in this order, every time — and each one hands you a document.

This is the part that took years. Not a project plan on a slide: a sequence where every step produces a real artifact your team reviews and keeps, and where nothing moves forward until the step before it reconciles. It runs the same way whether you’re absorbing an acquired book, moving to FSC, or handing me the data workstream on your own implementation.

01

Source analysis

Every table, every column, every record count in the source system, mapped before anyone talks about Salesforce fields. This is where we find out what the export actually contains, rather than what the vendor’s brochure says it contains.

You getA Source Data Analysis workbook: table counts, key map, full schema. Structure only, no client records in it.
02

Contact mapping

People split from businesses, trusts and entities identified, every lookup code resolved to the thing it actually means. Get this wrong and every household, relationship and rollup built on top of it is wrong too.

You getA Contacts Map workbook with a diagnostics tab showing exactly how the split was decided.
03
When your org already holds records

Cross-match against your org

Before anything loads, every incoming contact is matched against what you already have and given a disposition: new, match, possible match, type mismatch. Your team adjudicates the ambiguous ones. This is the step that prevents the thousands of duplicates that make people distrust a new org.

You getA CrossMatch Analysis workbook plus the migration key — the per-record decision file every later step reads.
04

Deduplication

Duplicates inside the source itself, clustered and scored, with the survivor logic applied consistently instead of advisor by advisor. You review the clusters; I don’t merge anything you haven’t seen.

You getA Dedupe Analysis workbook: merge clusters, review pairs, and the counts behind each decision.
05

Field mapping matrix

Every source field to a target field, or a documented decision not to migrate it. Picklist mismatches surfaced and resolved before load, not discovered during it. This is the document your admin inherits and the one that makes the org explainable a year later.

You getThe Field Mapping Matrix workbook, built for your team to review and sign off.
06

Load files and documents

Load-ready files generated in strict dependency order — parents before children, batched to avoid row locks — and client documents and attachments prepared to land on the right record rather than in a folder called “Old CRM.”

You getLoad-ready CSVs and a documents load sheet, both traceable back to the migration key.
07

Load, validate, reconcile

Sandbox first, then production. Record counts matched, spot checks run, and a delta load for anything that changed while the migration was in flight. Then I stay on through the first week, because the real bugs show up when advisors start clicking.

You getA reconciliation report written so it can go straight into your compliance file.
Non-negotiable

Three rules I don’t break, on any engagement.

Your client data stays in your environment

The work is done by deterministic scripts that run locally against your extract, read-only, making no network calls. Client records are never pasted into a chatbot, never uploaded to an AI vendor, and never leave your machine or your org. Anything that does travel carries masked identifiers. Your CCO can be told exactly where the data went, because the answer is “nowhere.”

Every count reconciles before the next step runs

“3,412 in, 3,412 out, 0 duplicates, 0 dropped.” Every file that later steps depend on gets checked before and after it changes, and a check that doesn’t balance stops the migration rather than quietly passing a broken file downstream. You see that line, not just the finished workbook.

Every decision is written down as it’s made

Which export was authoritative, how type mismatches were adjudicated, which target data model we chose and why — recorded in a decision register with the numbers that justified each one. It’s what makes the project resumable weeks later, and it means the migration isn’t living only in my head.

For firms that acquire practices

Acquisition Data Migration

One fixed-fee engagement that takes an acquired practice from “here’s their Redtail export” to “their clients are in our Salesforce and the advisors are using it.”

Most firms handle each acquisition like it’s the first one: a scramble, a spreadsheet, a consultant billing by the hour, and a quiet decision three months later to just not migrate the notes. I’ve done this enough times that it’s a repeatable process with reusable tooling, which is why I can scope it, price it once, and finish it faster than an hourly engagement would.

What’s included

  • Source audit of the acquired firm’s CRM (Redtail, Wealthbox, Salesforce, Excel, whatever they had)
  • AI-optimized household and relationship reconstruction so FSC gets households, not a pile of contacts
  • Field and schema mapping into your org’s existing data model, not a bolt-on
  • Notes, activities, documents and email history migrated and cleaned, including the HTML junk Redtail leaves behind
  • Financial accounts, roles and relationship groups modeled for FSC
  • Deduplication against clients you already have
  • An AI-readiness pass: consistent structure, deduplicated records, and notes sorted into fields that mean something, so Agentforce, Claude or whatever you adopt next has data it can trust
  • Validation down to the record count, with a reconciliation report your compliance team can keep
  • Go-live support and a delta load for anything that changed during the migration

What you get

  • A single accountable person who has done this before, not a rotating team
  • A fixed scope and a fixed fee agreed up front; I don’t bill overtime and I don’t bill surprises
  • A playbook you keep, so the next acquisition is faster and cheaper than this one
  • Data that’s ready for AI, not just ready for Salesforce
  • Advisors who can find their clients on day one, which is the whole point of the deal

Fixed fee, scoped after a 30-minute call.

Got a migration coming?

Thirty minutes and I’ll tell you what it’ll take.

What it’ll take, what it’ll cost, and whether you even need me. Sometimes you don’t.