
Enterprise IT Data / Information Services Architect
Northampton, United Kingdom

Enterprise IT Data / Information Services Architect
Northampton, United Kingdom
Adrian is an experienced Enterprise Data Architect and Business Analyst specialising in Distributed Data Architectures and large-scale data management with over 25 years in-depth experience across a wide number of business sectors including both commercial and government programmes.
Adrian has been responsible for architecting numerous data processing environments based around a range of technologies and, as such, has acquired a deep understanding of the various design patterns for delivering "fit-for-purpose" data environments. He has been responsible for deploying, a wide range of solutions ranging from Departmental Management systems through to Enterprise-Wide Corporate Data environments and over the course of his engagements he has gained a significant reputation for providing innovative solutions to meet the requirements and having a very positive, "will-do" attitude to reaching successful delivery.
As a former Management Accountant he also has a long standing appreciation of working accurately to tight deadlines and the importance of delivering solutions within budgetary constraints. As a consequence he focuses on being "just good enough" to meet the on-going business requirements rather trying to be technologically perfect (which generally costs much more and is rarely sustainable over time).
Adrian is also the author of many articles and papers dealing with Distributed Data Architecture (and any related issues that he finds interesting) and he currently writes a quarterly column for TDAN (The Data Administrators Newsletter) titled "Architecture Is Objective, Design Is Subjective" discussing how to impose an objective view onto the Enterprise IT Architecture activities.
In summary, Adrian puts in the effort to establish solid foundations for his ideas and then turns them into a sustainable reality.
Database Design, Data Processing Architecture, Business Analysis, Data and Information Modelling, Service Oriented Architectures, Message Modelling
(Information Technology and Services industry)
February 2008 — Present (1 year 6 months)
A start-up company that develops and markets Taxonomy Management software for creation and management of Classification Schemes including Ontologies, Taxonomies and Data Dictionaries.
This is an enterprise level, multi-user application built to meet requirements of global organisations and features a number of unique capabilities for creating and manipulating Classification Schemes.
(Information Technology and Services industry)
January 2008 — Present (1 year 7 months)
Provision of consultancy services relating to Residential & Commercial EPC Register to support European directive for energy performance assessments of commercial buildings. Specific responsibilities were:
• Requirements analysis and business process definitions
• Specification of Property & Addressing Database and strategic position for commercialisation in the future.
• Advice on capability of prospective regulatory bodies to meet technical requirements.
• Design of software for carrying out site inspections for producing Energy Performance Certificate and Air Conditioning reports.
(Partnership; Information Technology and Services industry)
May 2005 — Present (4 years 3 months)
Co-founder and Director at Miley Watts & Associates Ltd - a full service IT consultancy specialising in Enterprise Information & Data Architecture solutions and development of data management frameworks to govern the management, definition and distribution of data within a Federated Data Environment.
(Investment Banking industry)
April 2007 — October 2008 (1 year 7 months)
Engaged by Barclays Global Investors to produce Corporate Data Model as part of Model Driven Architecture across the whole of BGI. Specific responsibilities were:
• Production of Corporate Data Model (CDM) covering front, middle and back-office data requirements as central platform independent data model from which other models are generated. Reference material for this included:- MDDL, FpML, FIDM, MODM, Reuters, Bloomberg, gXML and various ISO standards.
• Define data modelling standards and conventions used within CDM and transformation rules for how UML is to be interpreted in specific target domains.
• Provide advice on aspects of the service oriented environment and how those requirements could be met via the Corporate Data Model.
Much of this advice was based on the Content Forms Framework, previously developed by Miley Watts LLP, as a conceptual data framework describing the different forms that data can take and formalising the principles that apply.
(Government Administration industry)
June 2005 — April 2007 (1 year 11 months)
Engaged by Department of Communities & Local Government on implementation of the Home Information Pack (HIP) legislation with specific ownership of:
• A Technical Framework, based around a highly-distributed Service Oriented Environment, to standardise participation by industry stakeholders in the HIP market.
• Technical Specifications (including Business Process definitions, Business Data Model and Message specifications) for interactions within the HIP marketplace.
• Preparation of “Invitation to Tender” and “Requirements Definition” procurement of archival Home Condition Report Register.
• Providing advice on technical requirements across the industry and carrying out technical appraisals of prospective regulatory bodies.
• Leadership of Stakeholder Working Groups and interaction with key industry bodies, such as Council of Mortgage Lenders, Law Society and National Association of Estate Agents, to ensure understanding of the Technical Framework and legislative requirements.
(Public Company; 10,001 or more employees; RTR.L; Information Services industry)
July 2001 — May 2005 (3 years 11 months)
The Reuters FRD Domain encompasses the historic Financial Markets data capability of Reuters all information regarding Organisations, Financial Instruments, Pricing and Derived Analytics data.
.
As Sub-Domain Architect I was a member of the core team defining the overall architecture and providing guidance and governance for this business area. As well as maintaining the overall vision I was responsible for defining the architecture for many aspects of the FRD environment, including:
• Defining the Reuters Data Model describing the full client-facing data present within the FRD domain.
• Metadata Services to manage the metadata that defines the structure and characteristics of data.
• Architecture for a Federated Data Server to enable a service oriented environment with model driven metadata identifying points of update and business rules controlling distribution of updates.
• Unified Data Entry environment integrating data entry activities into a single point of maintenance.
(Information Technology and Services industry)
January 1999 — March 2001 (2 years 3 months)
Database Architect for Envision project, the replacement Television Licensing system developed on behalf of the BBC for managing TV Licensing Automated Fee Collection, Prosecutions, Visiting and Call Centre Contacts.
In addition to the database architecture, specific responsibilities were:
• Producing the Business, Conceptual and Logical Data Models data constraints and domains definitions
• Design of high volume batch processes and data feeds in particular the mission critical processes such as Licence Renewals, Generating BACS claims and Payments processing, utilising advanced techniques, such as streamed / concurrent processing and parallel data loading, to maximise data throughput
• Design of ETL processes for extraction and loading into Data Warehouse
• Design of all server-side (PL/SQL) code including database Triggers, Packages, Functions and Procedures
• Designing software level Auditing layer (Oracle Auditing proved unsuitable) to implement legislative requirements
(Public Company; 10,001 or more employees; Airlines/Aviation industry)
1995 — December 1999 (4 years)
Database Designer for an OLTP and DSS application for forecasting and optimising seat availability on future departing flights.
Responsible for database / application design involved me in many of aspects of the project and resulting in producing numerous solutions to the on-going problems of large volume high-performance complex data processing, such as
• Specification and design of large-scale data feeds using parallel and streamed processing techniques.
• Developing statistical methods for calculating potential importance of new O+D Routes as a means to reducing workload and increasing application focus on key data.
• Feasibility studies on various database architectures and defining final database architecture rolled out into production application.
• Many proposals for summarising and re-organising data for high performance retrieval including use of Partitioned Views and Tables and use of Oracle ROWID’s as record ID’s for fast navigation between tables.
(Government Agency; 10,001 or more employees; Information Technology and Services industry)
March 1989 — May 1994 (5 years 3 months)
Design and development of Oracle based Highways Management and Inventory System (HMIS) - the core database for all Highways applications subsequently developed by NCC. This application had a number of groundbreaking features (for 1990) such as a Street Gazetteer, to identify locations, and a GIS (MapInfo) to display locations and query details of Highway Inventory.
Subsequent developments, building on the capabilities of HMIS, were Street-lighting Maintenance, Traffic Accidents (interfaced to Northamptonshire Police) and Highways Inspection.
In addition to the above, I also undertook responsibility for:
• Oracle technical consultant to projects within other NCC departments such as Social Services and Education.
• Supervision and training of programmers during their six month initial induction period prior to being placed within other projects.
• Production of BS5750 development standards relating to aspects of analysis, design and programming languages.