Consolidating three systems into one
Property, booking and tenancy data lived across two legacy housing-sector systems plus an assortment of spreadsheets. I designed the migration and data model to bring all of it into a single Salesforce org — including untangling duplicate council records (e.g. a council and its children's-services department that were really the same organisation) into a clean parent/child account hierarchy that still holds up for reporting today.