Pacific regional bank · ISO 20022 address remediation
Automated data cleansing and validation for 50,000+ records
Problem
Payment interfaces and core platforms across two countries held unstructured customer address data that would not meet mandatory SWIFT ISO 20022 structured and hybrid address standards.
What I did
Ran workshops with business, technology and vendor teams to agree requirements and remediation options. Profiled and mapped more than 50,000 remitter and payee records, defined the business rules, and built Python (Pandas) scripts to automate cleansing, address validation and output generation.
Artefacts
- Business requirements documents
- Structured address recommendation paper and technical memo
- Case management options paper
- Data mapping and business rules
Outcome
Remediated data published in a compliant structure, with a repeatable automated process that improved consistency and throughput for regulatory reporting.
Applies to: any large data migration or clean-up, such as logistics, insurance, retail or government records.