Senior data migration and transformation lead architect/developer
Request a quote with no obligation
Senior data migration and transformation lead architect/developer with 20+ years driving complex SAP S/4HANA, enterprise data integration, and large-scale modernisation across FTSE/global organisations. Proven record architecting and delivering selective data transition programs, consolidating multi-source landscapes, and standing up robust data quality/governance, with deep expertise in SAP Data Services (BODS), S/4HANA Migration Cockpit, IDocs, Salesforce integration, and cloud/hybrid data platforms. Known for converting intricate, high-risk data estates into stable, auditable, business-ready platforms that accelerate order-to-cash, finance, and customer operations while reducing cost, risk, and cycle times.
Led global/onshore–offshore teams, established BAU/MDM controls, and built hundreds of production-grade pipelines and reconciliation frameworks for audit-grade confidence. Delivered SAP S/4HANA migration and enterprise data transformation programs valued at multi-million-pound scale across retail, utilities, manufacturing, media and financial services sectors. Proven ability to reduce migration risk, improve data quality, accelerate cutovers and establish sustainable governance models.
Data Migration Lead Developer - News UK - London
(2024-08 - 2025-12)
Architected end-to-end data extraction methodology from ECC and transformation pipelines in SAP BODS for multi-domain migration to S/4HANA (Fixed Assets, GL, AP, Sales Orders/Contracts, Materials, Classification, Inventory, Scheduling Agreements, Visit Plans, Press PE, Vendors). Loaded via S/4HANA Migration Cockpit; implemented pre/post load reconciliations to eliminate load errors and ensure data integrity. Centralized mapping knowledge on a maintained wiki, accelerating cross-functional alignment and reducing rework.
Senior OTC Data Migration Architect - Calor Gas - Warwick
(2021-10 - 2024-02)
Owned customer/OTC migration to S/4HANA using SAP Selective Data Transition; scope included Sales Orders/History, Texts, Tax (classification, numbers, licenses), BP roles, Bank, Person/Company, Unloading Points, Telemetry, Contract Account, Billing Blocks, Sales BOM, CPR/BDPR, Pricing. Engineered partner family hierarchies and full OTC history (Sales/Delivery/Billing) pipelines in BODS; developed IDoc-based high-volume loads, complemented with Migration Cockpit and Winshuttle. Built bidirectional Salesforce-ERP synchronisation processes, reducing customer master data discrepancies and supporting a single customer view across 2,000,000+ records. Delivered address cleansing/standardisation and entity matching across VAT, bank, phone, email to enable clean Business Partner conversion and reduced duplicates. Produced HMRC audit extracts (Climate Change Levy, Fuel Duty) and GL transaction views (SKA1/KSAT/SKB1/BKPF/BSEG/BSIM/VBRK).
Established a BAU/MDM control plane: 80+ jobs publishing Excel reports to SharePoint with problem/impact/solution narratives; implemented server-side BODS administration, upgrades, repository/user management.
Data Migration Staging Lead - McKesson - Coventry
(2017-12 - 2021-07)
Defined and documented the data migration strategy from extraction through staging to S/4 load. Designed staging architecture and source extraction in SAP BODS and ADM; profiled data, authored rules to enforce S/4 conformity, and mapped source-to-target at scale. Built business-facing ADM construction pages enabling targeted manual enrichment with traceability. Architected multi-system matching (seven sources) in BODS; presented match groups via ADM websites for approve/reject workflows; integrated address/attribute standardisation with side-by-side "proposed vs original" review User Interface. Developed IDocs and load jobs to S/4HANA (BODS, Winshuttle); authored reconciliation/exception-cleansing reports.
SharePoint document versioning for program governance; led security design for data/web access in ADM. Administered BODS on Linux (troubleshooting, upgrades, repository/user admin).
ETL Architect - Express Gifts
(2017-07 - 2017-10)
Delivered PPI remediation solution; built 28 SAP BODS jobs for historical customer refund calculations with audit ability.
ETL Architect - Trac365 - Guildford
(2017-06 - 2017-07)
Deployed RHEL servers; implemented Oracle 12c; migrated data warehouse from SQL Server to Oracle via BODS. Set up RabbitMQ to ingest real-time messages from Lora WAN services.
Global ETL Architect and Lead Developer - Burberry - London
(2013-04 - 2017-05)
Defined and implemented information server design on SAP Cloud (HEC); built/maintained SAP BODS on Linux; administered Information Steward/Metadata Manager and CMC security. Delivered big data loads to Hadoop on AWS; implemented address cleansing and customer de-duplication for Salesforce master data. Delivered 93 CDC and 15 real-time integrations, reducing latency from batch processing to near real-time operations from Salesforce to SAP HANA with robust recovery; integrated BW OpenHub extracts for Finance/Retail analytics.
Implemented real-time MQ for web orders (payment, cancel, dispatch, inventory/ledger updates). Developed PLM, JSON-to-XML pipelines into Apache Cassandra; migrated ECC to S/4HANA with strong OTC focus. Built SDI and HCI-DS integrations to/from HANA and C4C; migrated data from six legacy SQL Server/Oracle systems.
Delivered 310+ additional BODS jobs and multiple HANA models; co-led one-year migration of Burberry servers to SAP Cloud. Managed a global team of 12 developers and analysts delivering over 400 production integration jobs supporting £multi-billion global retail operations.
ETL and BO Reports Developer - IATA - Geneva
(2012-11 - 2013-03)
Built data mart from IRIS Remittance/Settlement using BODS v4; authored universes (IDT) and financial reports (BO v4).
BI Solutions Architect/Developer - Kiln Insurance - London
(2011-11 - 2012-07)
Built actuarial data mart for forecasting at DURG/Risk/Trust levels. Led upgrade architecture for BODS v4 and BO Enterprise v4; developed catastrophe cost analytics for Solvency II.
BI Architect/Developer - Manchester City Council - Manchester
(2010-06 - 2011-10)
Implemented secure data architecture (FTPS, alerts) compliant with EU Data Protection frameworks. Built address master from LLPG; delivered CRM data loads and de-duplication; automated delta detection and FTPS XML distribution. Migrated BODS jobs from MySQL/SQL Server to Oracle; implemented email/SMS job-failure alerts. Built attendance extracts from One Schools; supported 2011 Census data jobs; developed XI v3 universes.
Degree in Information Management plus multiple diplomas
