Skip to content
Try free
MUFG logoFinancial Services & Banking

KYC standardised across 19 countries, and a week of Excel became 20 minutes

Each country submitted KYC data in its own conventions, and the rules deciding when a customer's KYC should be re-initiated were complex enough that the outcome was negotiable rather than automatic. Both were handled by hand in Excel, across 19 countries, by a centralised team that could not scale that way.

19
countries on one standard
15–20 min
per run, replacing manual Excel
1
transparent rule engine, editable as rules change

The workflow

What replaced the manual work

  • KYC data from 19 countries, each in its own conventions
One pipeline
  • Connect
  • Clean
  • Automate
  • Share

Recorded once, re-run on a schedule.

  • One standardised KYC dataset
  • Re-initiation recommendations, with the rule that produced each

Outcomes

What changed

  • Country-specific KYC conventions standardised into one format across 19 countries
  • Manual Excel reconciliation replaced by automated runs of 15 to 20 minutes
  • Re-initiation rules prototyped and revised quickly, as a visible pipeline rather than a spreadsheet
  • Writing the rules down surfaced assumptions the team had been carrying implicitly
  • Enough transparency in how each rule was applied to satisfy compliance and audit review

What they used

The parts of Mammoth involved

  • Data Engine
  • Automated validation
  • Scheduled refresh
  • Activity log

More case studies

Starbucks · 20 days → hours20 days of report assembly, down to hours — across 17 countriesRethinkFirst · 10x50+ hours a month saved, and new analysts productive in under two weeksBacardí · 70%Reporting time cut by 70% across 170+ countries

Start with one source and one question.

That's how this deployment began too. Twenty minutes on the free plan is a fair test.

Try freeBook a demo
  • 21-day Pro trial
  • No credit card
  • Viewers always free