Working with a private bank to develop an enterprise level CRM architecture which supports users wishing to up-sell and cross-sell a wider range of products and services to new and existing customers.
The background to this project was the need to simplify, expand and automate the bank?s ability to carry out effective CRM campaigns, and this was achieved by creating an integrated business and technical data architecture based on shared metadata standards and protocols. The result was a ?seamless? platform which covers all aspects of CRM work from identifying data sources and potential prospects through to defining and monitoring campaigns, with all tasks and activities being defined in terms of the same metadata protocols, thus enabling a high degree of process automation and allowing users to collaborate much more easily on specific CRM initiatives.
Defining a comprehensive data strategy and data governance framework for the bank?s IT division.
I joined Barclays as the first ever chief data architect in a division that was run by technologists, most of whom believed that having to worry about data would just get in the way of the ?real work? of managing the bank?s IT infrastructure; in order to overcome this scepticism I had to devise a data strategy which would support BAU while at the same time laying the foundations for long-term digital transformation.
My solution to this challenge was based on the realisation that by creating parallel data architectures ? i.e. one reflecting data as defined by business users, another reflecting physical data sources ? it would be possible to gradually build an integrated data architecture without affecting BAU: GDPR for example could be documented and validated in business terms before it was put into practice incrementally, thus greatly simplifying what otherwise would have been a very complex task; and migrating legacy data sources to the cloud (specifically AWS) could be handled in the same, controlled way.
As well as designing and implementing this solution, I was also responsible for ensuring that all stakeholders understood how this new data architecture was intended to work, and how their data would ultimately be integrated into the overall logical and physical data architecture.
Define and implement a data and technical strategy for enterprise level real-time BI.
The background to this project was the need to provide UK police forces with a new BI platform which would provide
the ability to securely share data between police forces
the ability for police forces to customise their KPI?s as and when needed
support for mobile devices?
the ability to reflect and respond to changes in legislation
As the project?s solutions architect I was responsible for designing and implementing the first version of this platform and then organising a series of workshops and seminars to demonstrate how this new platform differed from the data warehouses which police forces had used in the past.
My work at DB involved creating a metadata driven hub for all market risk related data, both to meet BCBS 239 requirements and to provide asset management teams with more flexible market risk metrics. As the project?s data and solutions architect I was responsible for creating the logical and physical data models for all components of the new data hub, as well as implementing the system?s metadata layer.
This assignment involved migrating three legacy data warehouses into a new BI platform which could provide a 360 degree view of all credit and market risk data. As the project?s technical architect I was responsible for all data modelling and database design work as well as for defining the ETL roadmap which was used to migrate legacy data into the new BI architecture.
The goal of this project was to create an integrated data hub which allowed the FSA to analyse credit and market risk patterns in the trading of financial instruments on the London Stock Exchange. As the lead data and technical architect I was responsible for: (1) creating the logical and physical data models for all components of the project?s ODS and data warehouse; (2) analysing source data; (3) defining the data quality standards which underpinned the system?s ETL processes.
Matrix Data is an IT consultancy which specialises in data quality issues and I was engaged to work on a number of Oracle related projects for clients wishing to improve the quality and usability of their data.
This project involved refactoring an existing BI system in order to improve its performance and usability.
The goal of this project was to create a new database which could provide a single view of product data for all Warner Bros offices worldwide. Within the project I was responsible for creating the required ETL architecture and for defining the data transformations in business and technical terms.
Studium - Informatik
University of Salford, England
Abschluss: Master of Science
Studium - Germanistik
University of Manchester, England
Abschluss: Bachelor of Arts (hons)
SOA-Architekt bzw. Entwickler
Analyse von Geschäftsprozessen
Datenbankdesign und -administration
Enterprise data architecture and data governance
Data solutions architect (MDM/BI/MI/ETL/ODS)
Data modelling (logical/physical/dimensional/network)
Technical PM/Development DBA (Oracle)
Creating metadata driven corporate data hubs
Data profiling, data quality management
Mentoring/training users and developers in data best practices
Devising data strategies to enable digital transformation initiatives
Technischer Architekt (Oracle)
Architekt für Datenqualität
Datawarehousing (DWH), Business-Intelligence, Finanzhandel, Bilanzen, CRM
Erstellung von integrierten, unternehmensweiten Datenbanken (ODS, Data Hubs)
Master Data Management (MDM), Datenqualitätsanalyse
Datenmigration, Implementierung von ETL-Systemen auf Basis von SOA
Risikokontrolle im Finanzbereich (Basel II, Sarbanes Oxley)
Analyse von Daten und Geschäftsprozessen
Produktionssteuerung und Materialverwaltung für Fertigungsunternehmen
Wholesale financial markets: credit/market risk, KYC
Regulatory reporting: Sarbanes/Oxley, BCBS 239
Corporate data governance, data security, GDPR
Asset management: securities, commercial real estate, investment portfolios
Sales and marketing: retail sector, CRM, KYC
Travel and tourism: airlines, railways
Data/ Business Analysis
Data modelling (logical/physical)
DWH modelling (reporting/OLAP)
Data gap analysis
Data quality profiling
Data dictionary creation
Master data management (MDM)
Enterprise data architecture
SOA project methodology
Development / ETL Tools
Oracle Designer (6.0, 6i, 9i)
Erwin/EA Studio/ PowerDesigner
1995-05 - 2017-06
Position: Freelance IT consultant
2017-07 - 2019-08
Firma: Barclays Bank
Position: Chief Data Architect
2019-09 - heute
Position: Enterprise Data Architect
Banking and Finance
Wholesale and retail trade
Consumer goods manufacturing