Summary
Overview
Work history
Education
Skills
References
Hobbies and Interests
Accomplishments
Leadership, Governance, and Delivery Strengths
Custom
Timeline
Generic

David Bruce Stevenson

Colden Common,United Kingdom

Summary

Experienced professional with extensive expertise in SAP Data Services, Information Steward, and Metadata Manager. Proficient in databases including Oracle, SQL Server, MySQL, and SAP HANA. Skilled in SQL, VBScript, Toad, and AQT across various platforms such as Linux and Microsoft Server. Adept in messaging technologies like ActiveMQ, IBM MQ, RabbitMQ, Eclipse Mosquitto, and CDC/real-time BODS. Strong background in BI/Reporting with Business Objects and IDT universes. Knowledgeable in cloud computing and big data solutions including AWS/Hadoop and Cassandra.

Overview

41
41
years of professional experience
3
3
years of post-secondary education

Work history

Data Migration Lead Developer (Contract)

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 (Contract)

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 alignment jobs to keep Salesforce synchronized with ERP changes, reducing master data drift.
  • Delivered address cleansing/standardization and entity matching across VAT, bank, phone, email to enable clean BP conversion and reduce 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 (Contract)

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 standardization with side-by-side “proposed vs original” review UI.
  • Developed IDocs and load jobs to S/4HANA (BODS, Winshuttle); authored reconciliation/exception-cleansing reports.
  • Implemented 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 (Contract)

Express Gifts
Blackburn
2017.07 - 2017.10
  • Delivered PPI remediation solution; built 28 SAP BODS jobs for historical customer refund calculations with audit ability.

ETL Architect (Contract)

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 LoRaWAN services.

Global ETL Architect and Lead Developer (Contract)

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.
  • Built 93 CDC and 15 real-time integrations 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 team of 12 (2 onshore, 10 offshore).

ETL and BO Reports Developer (Contract)

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 (Contract)

Kiln Insurance
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 (Contract)

Manchester City Council
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/reports.

ETL Developer (Contract)

Channel 4
2010.03 - 2010.05
  • Resolved defects in existing BODS ETL jobs, stabilizing nightly loads.

BI Services Manager (Contract)

Verillian Financial
2009.02 - 2010.03
  • Delivered credit/mortgage reporting; migrated SQL Server workloads to Oracle via BODS; developed universes/reports (BOXI v2) on Oracle 10g.

Data Integrator BODS Developer (Contract)

Network Rail
London
2008.10 - 2009.02
  • Developed 110 KPIs via BODS to monitor service levels.

SAP BODS Technical Lead (Contract)

Service Birmingham
2008.03 - 2008.09
  • Delivered 180 KPIs for council housing operations with restartability, error handling, XML export to SAP on Oracle 10g.

Data Integrator BODS Developer (Contract)

Fitness First Group
2007.10 - 2008.02
  • Re-architected DI XIR2 data warehouse with history preservation, error trapping, and resume-from-failure design.

Data Integrator (BODS) Developer (Contract)

GCap Media (Capital Radio)
2006.05 - 2007.06
  • Consolidated financials from legacy estates into a single BODS-driven warehouse; cut load time from 8 hours to 1h30.
  • Built MDM for reference integrity; implemented alerting (email/SMS); reduced BO license footprint via automated report distribution.

Data Integrator (BODS) Developer (Contract)

National Australia Bank
2005.07 - 2006.04
  • Built Experian-aligned credit reporting via AS/400 extraction, Oracle SQL
  • Loader, and DI XIR2 transformations with audit trails.

Financial Migration Manager (Permanent)

Unilever
London
2005.01 - 2005.06
  • Migrated 2005 financial reporting data across Cartesis estates; automated consolidation, currency conversion, reconciliation via BODS.

ETL Development Manager (Permanent)

Unilever
London
2004.07 - 2005.01
  • Led 24-person blended team (UK/India); managed ETL architecture/methodologies; upgraded to BODS 6.5.

ETL Developer (Permanent)

Unilever
London
2001.10 - 2004.06
  • Built global supply chain solution (104 countries) integrating SAP/MFGPRO/4th Shift into Kalido via BODS.
  • Delivered validation/controls versus DW for price/exchange variances; automated DW refresh with BODS scripting; implemented MDM for reference codes.

IT Operations Manager (Permanent)

Anglovaal Industries
1998.01 - 2001.08
  • Led 35-person IT organization; delivered multi-company data warehouse (19 companies); negotiated major vendor contracts; implemented EDI/ecommerce with national retailers.

Technical Architect (DBA) (Permanent)

Anglovaal Industries
1993.08 - 1998.01
  • Mixed DBA/dev role: capacity planning, tuning, upgrades (7.33–8i), hot/cold backup strategies, partitioning, OEM automation, archiving strategies, and DW physical design on EMC.
  • Delivered MFG/ERP data extraction to Oracle warehouse (SQL
  • Loader, OWB, Sagent), reconciling product codes into AVI MDM; built shell-based monitoring.

IT Manager (Permanent)

Pro-Systems
1991.01 - 1993.07
  • Project-managed enterprise solutions; led 5-person team implementing ICL VME mainframe for Telkom SA.

National Service

South African Air Force
1985.01 - 1986.12
  • Completed compulsory service; attained rank of Lieutenant.

Education

BSc - Information Management

University of South Africa
1987.01 - 1990.01

IT Support Technician Diploma - undefined

Pretoria Technikon

MCSE -

Microsoft

Skills

  • SAP: SAP Data Services (BODS) 12–14, 40/41/42; Information Steward/Metadata Manager 41/42; SAP HANA; S/4HANA; SAP R/3; Migration Cockpit; IDocs; SDI; HCI-DS; C4C
  • Databases: Oracle 7x–19c; SQL Server 2000–2017; MySQL 55; SAP HANA
  • Languages/Tools: SQL, VBScript, Toad, AQT
  • Platforms/Infra: Linux (RHEL 6–9, SLES 11), Microsoft Server 2000–2021, Apache/Samba
  • Messaging/Realtime: ActiveMQ, IBM MQ, RabbitMQ, Eclipse Mosquitto, CDC/real-time BODS
  • BI/Reporting: Business Objects 65/XIR2/XIR3/BOE v41/42; IDT universes
  • Cloud/Big Data: AWS/Hadoop; Cassandra (via JSON→XML ingestion)

References

References Available on request

Hobbies and Interests

Recreational Interests Golf, Chess, 4x4 Adventures

Accomplishments

  • Led multi-object S/4HANA migrations for global enterprises, delivering clean, reconciled loads for Fixed Assets, GL balances, OTC customer/sales, and vendor/material domains with zero critical post-cutover defects and audit-ready reconciliations.
  • Built enterprise-grade reconciliation frameworks (pre/post-load, GL-to-billing traces) improving data confidence and cutting defect resolution time by 50%+ across multiple programs.
  • Designed and delivered address and customer standardization/matching engines that de-duplicated large customer estates (match on addresses, VAT, bank, email, phone), enabling clean Business Partner conversion and improved DSO/credit risk posture.
  • Scaled SAP BODS estates to hundreds of robust jobs (CDC, real-time, batch), with restart ability, error trapping, and monitoring—supporting high-volume migrations and BAU analytics.
  • Managed hybrid onshore/offshore teams (10–12 FTE) to deliver global ETL and integration portfolios, reducing run costs while improving SLA attainment.
  • Stood up post-program BAU/MDM environments (80+ proactive data quality jobs) that surfaced user errors, automated Excel/SharePoint publishing, and drove continuous data hygiene.

Leadership, Governance, and Delivery Strengths

  • Program governance: migration strategy, documentation/versioning, security and access models, and auditable controls.
  • Risk management: pre/post-load reconciliations, exception handling, restartability, and defect triage.
  • Stakeholder alignment: business-led enrichment, mapping transparency, and executive reporting with impact narratives.
  • Team leadership: onshore/offshore coordination, coaching, standards, and code quality.

Custom

  • Notes for tailoring
  • For S/4HANA/OTC leadership roles: move Calor Gas and News UK above as “spotlight projects,” add brief metrics (e.g., objects migrated, records/volumes, % duplicates removed, days-to-close impact).
  • For architecture/Head of Data roles: elevate Governance/BAU/MDM and “Leadership, Governance, and Delivery Strengths” near the top; keep technical stack concise.
  • Keep to 2–3 pages for applications; place legacy roles in a condensed “Earlier Experience” section if needed; maintain this master as a full version.

Timeline

Data Migration Lead Developer (Contract)

News UK
2024.08 - 2025.12

Senior OTC Data Migration Architect (Contract)

Calor Gas
2021.10 - 2024.02

Data Migration Staging Lead (Contract)

McKesson
2017.12 - 2021.07

ETL Architect (Contract)

Express Gifts
2017.07 - 2017.10

ETL Architect (Contract)

Trac365
2017.06 - 2017.07

Global ETL Architect and Lead Developer (Contract)

Burberry
2013.04 - 2017.05

ETL and BO Reports Developer (Contract)

IATA
2012.11 - 2013.03

BI Solutions Architect/Developer (Contract)

Kiln Insurance
2011.11 - 2012.07

BI Architect/Developer (Contract)

Manchester City Council
2010.06 - 2011.10

ETL Developer (Contract)

Channel 4
2010.03 - 2010.05

BI Services Manager (Contract)

Verillian Financial
2009.02 - 2010.03

Data Integrator BODS Developer (Contract)

Network Rail
2008.10 - 2009.02

SAP BODS Technical Lead (Contract)

Service Birmingham
2008.03 - 2008.09

Data Integrator BODS Developer (Contract)

Fitness First Group
2007.10 - 2008.02

Data Integrator (BODS) Developer (Contract)

GCap Media (Capital Radio)
2006.05 - 2007.06

Data Integrator (BODS) Developer (Contract)

National Australia Bank
2005.07 - 2006.04

Financial Migration Manager (Permanent)

Unilever
2005.01 - 2005.06

ETL Development Manager (Permanent)

Unilever
2004.07 - 2005.01

ETL Developer (Permanent)

Unilever
2001.10 - 2004.06

IT Operations Manager (Permanent)

Anglovaal Industries
1998.01 - 2001.08

Technical Architect (DBA) (Permanent)

Anglovaal Industries
1993.08 - 1998.01

IT Manager (Permanent)

Pro-Systems
1991.01 - 1993.07

BSc - Information Management

University of South Africa
1987.01 - 1990.01

National Service

South African Air Force
1985.01 - 1986.12

IT Support Technician Diploma - undefined

Pretoria Technikon

MCSE -

Microsoft

David Bruce Stevenson