Conference - Conference Day 1

CONFERENCE - DAY 1 TUESDAY 30 October 2007
08:00–09:00		Registration
08:00–8:45		A joint meeting of IAIDQ's British and Irish Communities of Practice for members and prospective members Daragh O Brien and Keith Underdown
09:00–09:30		Joint Chair Introduction: Rick van der Lans, R20 Consultancy Larry P English, President, INFORMATION IMPACT International John Schley, DAMA International
09:30–10:30		DAMA KEYNOTE: DATABASE GRAFFITI: Scribbles from the Askew Wall C. J. Date
10:30–11:00		Break & Exhibits
11:00–12:00	META DATA	What Banks Need to Know-Using Metadata Management for Basel II Compliance David Plotkin, Data Quality Manager, Wells Fargo Bank
11:00–12:00	Information Quality Track 1	Scorecarding—Data Quality in a Business Context Paul O’Keeffe, Information Management Analyst, Marks and Spencer Money
11:00–12:00	Information Quality Track 2	Your Web Data Collection Form—Achieving Higher Data Quality Graham Rhind, Owner, GRC Database Information
11:00–12:00	DW/BI	The Active Data Warehouse – A Case Study Mike Schmitz, Data Warehouse Architect, Business Knowledge Professionals
11:00–12:00	DAMA Track 1	How to Perform Information Stewardship within Business Process Redesign Jim Goetsch, Data Architect, Schneider National
11:00–12:00	DAMA Track 2	Developing Business Rules in a Pharmaceutical Research Environment Liz Calder, Business Architect, Discovery Information, AstraZeneca
11:00–12:00	DAMA Track 3	Establishing Data Modelling as a Service in a Multinational Energy Company Christopher M. Bradley, Head of Information Management, IPL Donna Burbank, Embarcadero
12:00– 13:30		Lunch & Exhibits
12:50–13:20	Perspective Session	Track 1 - DataFlux: Data Quality Drivers 2007, Luke Thompson, DataFlux
12:50–13:20	Perspective Session	Track 2 - Business Objects: Tame Information Chaos with Metadata Management: discover best practices and future trends in delivering trusted metadata, Richard Neale, Product Marketing Manager – Enterprise Information Management, Business Objects
13:30–14:30		META DATA KEYNOTE: Milestones on the MDM Road Map for 2008-09 Aaron Zornes, Chief Research Officer, The CDI-MDM Institute
14:35–15:35	META DATA	Master Data versus Reference Data Malcolm Chisholm, President, AskGet.com
14:35–15:35	Information Quality Track 1	Strategies for Data Quality Management: Survey findings from UK Utilities and Transport Gordon Brown, Principal Consultant, AMT-SYBEX
14:35–15:35	Information Quality Track 2	Data Quality Framework at Nestlé Dr. Walid el Abed, BTC - Data Standardization / Data Management, Nestec – GLOBE
14:35–15:35	DW/BI	Using Data Services and a Data Warehouse to Enable Real-Time Customer Analytics Sükrü Haciyanli, SI Meteksan
14:35–15:35	DAMA Track 1	What Makes A Good Data Model? Data Model Quality Criteria Graham Witt, Consulting Manager, Ajilon Consulting
14:35–15:35	DAMA Track 2	Semantic Enterprise Information Integration at Orange France Telecom – A Success Story Antoine Proult, Enterprise IT Architect Associates at ACP Conseil
14:35–15:35	DAMA Track 3	Enterprise Architecture: Straight From the Shoulder John A. Zachman, President, Zachman International
15:35–16:05		Break & Exhibits
16:05–17:05	META DATA	A Complete Data Architecture Development to Support EAI and BI Implementation Arthur Haynes, Data Architect, Siemens IT Solutions and Services Ltd (SIS)
16:05–17:05	Information Quality Track 1	Information Quality within Belgacom Paul Gysemans and Annick Andries, Belgacom
16:05–17:05	Information Quality Track 2	A Practical Approach and Tool For Data Quality Assessment Dr. Thoa Pham, Lecturer & Postdoctoral Researcher, Dublin City University
16:05–17:05	DW/BI	Leveraging Enterprise Information Integration (EII) in Data Warehousing Mike Ferguson, Managing Director, Intelligent Business Strategies
16:05–17:05	DAMA Track 1	Practical Data Governance at Reuters Helen Townsend & Toni McDerment, Enterprise Data Architects, Reuters
16:05–17:05	DAMA Track 2	Gaining Maximum Value from Data Driven Projects Ron MacDonald, Elsevier Luke Thompson, DataFlux
16:05–17:05	DAMA Track 3	"The Inmates Taking Over the Asylum? … Web 2.0 and Data Management” Sam Lowe, Sector CTO, Capgemini
17:05–18:45		Drinks Reception Hosted by DAMA UK & Exhibits
17:15–17:45	Perspective Session	Track 1 - Trillium Software: Mastering Master Data - A Journey of Discovery, Ed Wrazen, Trillium Software
17:15–17:45	Perspective Session	Track 2 - ETL Solutions: Data Integration: Giving You Choices, Greg Larsen and Karl Glenn, Business Development Director, ETL Solutions
17:55–18:25	Perspective Session	Track 1 - Triton Consulting: Dynamic Warehousing: The Next Generation, Julian Stuhler, Triton Consulting
17:55–18:25	Perspective Session	Track 2 - To Be Confirmed

Tuesday
30 October
08:00–08:45

Back to top

A joint meeting of IAIDQ's British and Irish Communities of Practice for members and prospective members
Daragh O Brien and Keith Underdown

		Daragh O Brien eircom

		Keith Underdown

Tuesday
30 October
09:00–09:30

Back to top

Joint Chair Introduction
Rick F. van der Lans, R20/Consultancy
Larry P. English, President, INFORMATION IMPACT International
John Schley, DAMA International

Featured Speakers:

		Rick F. van der Lans R20/Consultancy

		Larry P English President INFORMATION IMPACT International

		John Schley President DAMA International

Tuesday
30 October
09:30–10:30

Back to top

DAMA Keynote:
DATABASE GRAFFITI: Scribbles from the Askew Wall
C. J. Date

This keynote is based in part on one of Chris Date's regular columns in Database Programming & Design (the tenth anniversary issue), but includes much additional material. It consists of a series of quotations, aphorisms, and anecdotes--seasoned with a fair degree of personal commentary--that are (mostly) relevant to the general subject of database management. The session is not technically deep, but several serious messages do lie not too far below the surface. The aim is partly to edify, partly just to amuse.

The prehistoric era
Objects and objections
Normalization, networks, and nulls
The role of simplicity
The joy of self-reference
Some fundamental principles
Relational misconceptions
Some good quotes
Books and book reviews
Miscellany

Featured Speaker:

C. J. Date

CONCURRENT SESSIONS

Tuesday
30 October
11:00–12:00

META DATA

Back to top

CASE STUDY

What Banks Need to Know-Using Metadata Management for Basel II Compliance
David Plotkin, Data Quality Manager, Wells Fargo Bank

Banks around the world must comply with Basel II, and a large part of doing so involves proving that your data moved through the various system touch points without being corrupted or lost. To be compliant, you must implement a series of tools and perform inspections (both manual and automated) on the data stream. This presentation details what tools you'll need to implement, what front-end and back-end tasks you'll need to perform, and the aspects of metadata and data integrity you'll need to master.

Featured Speaker:

David Plotkin
Wells Fargo Bank

Tuesday
30 October
11:00–12:00

Information
Quality

Track 1

Back to top

CASE STUDY

Scorecarding—Data Quality in a Business Context
Paul O’Keeffe, Information Management Analyst, Marks and Spencer Money

Like all financial services providers, M&S Money had the challenge of readying its’ information environment to comply with the Basel II Capital Accord. They used the opportunity to provide a holistic view of Data Quality across the organization and learned how to communicate data issues in the language of the business.

Defining and Measuring Data Quality
Building a Technical Framework for Data Quality assessment
Illustrating the effect of poor Data Quality in business terms

Featured Speaker:

Paul O’Keeffe
Marks and Spencer Money’s

Tuesday
30 October
11:00–12:00

Information
Quality

Track 2

Back to top

Your Web Data Collection Form—Achieving Higher Data Quality
Graham Rhind, Owner, GRC Database Information

How to achieve higher quality from data collected via web forms through some simple and easily achievable changes.

International addressing
Twelve golden rules for high quality international data collection
Web form examples, with problems and challenges
Practical advice for improving the quality of collected data

Featured Speaker:

Graham Rhind
GRC Database Information

Tuesday
30 October
11:00–12:00

DW/BI

Back to top

CASE STUDY

The Active Data Warehouse – A Case Study
Mike Schmitz, Data Warehouse Architect, Business Knowledge Professionals

Active Data Warehousing is here. Real-time and near real-time requirements are dramatically changing data warehouse architecture and design and this session focuses on the paradigm shift you will have to make. We will look in detail at a prototype developed for a client based on a solid business requirement. The focus will be on the data architecture required to support near-real time, the changed data capture delivery method, and the resource management issues.

What is an Active Data Warehouse
Real-Time, Near Real-Time, or Just In-Time
A Data Architecture for the Active Warehouse
Near Real-Time Changed Data Capture
Resource Management in the Active Warehouse

Featured Speaker:

Michael Schmitz
Business Knowledge Professionals

Tuesday
30 October
11:00–12:00

DAMA

Track 1

Back to top

CASE STUDY

How to Perform Information Stewardship within Business Process Redesign
Jim Goetsch, Data Architect, Schneider National

This presentation describes how Schneider National implemented an 'Information Stewardship' approach to identify and define information within and across business processes being redesigned. Experience how our organization learned that information is the glue that integrates business processes. Our company create an information governance program because of the success of this work.

Where Information Stewardship fits within Business Process Redesign
Five phases (including deliverables) of Information Stewardship
Illustrate accomplishments in a real-life BPR effort

The illustration includes the old and new process, conceptual data model, information policies, required information quality levels, process life-cycle states among others. The business gained the ability to maintain satisfactory value at the entity/attribute level. Real life examples illustrates the redesign of our 'Accept the Transportation Order' and ‘Customer Master’ projects.

Featured Speaker:

Jim Goetsch
Schneider National

Tuesday
30 October
11:00–12:00

DAMA

Track 2

Back to top

CASE STUDY

Developing Business Rules in a Pharmaceutical Research Environment
Liz Calder, Business Architect, Discovery Information, AstraZeneca

Pharmaceutical research is an information driven environment. During the course of a drug discovery project thousands of compounds are tested and any of the results can impact the progress of the project. In the wake of a merger AstraZeneca, a major multinational pharmaceutical company, took the position that "We can't afford to repeat what we've already done ourselves" and initiated a program of information sharing based on globally agreed Business Rules. The presentation outlines the process we followed to:

Develop and implement the Business Rules
Manage the associated business change
Keep the business rules relevant in a changing business environment

Featured Speaker:

Liz Calder
AstraZeneca

Tuesday
30 October
11:00–12:00

DAMA

Track 3

Back to top

CASE STUDY

Establishing Data Modelling as a Service in a Multinational Energy Company
Christopher M. Bradley, Head of Information Management, IPL
Donna Burbank, Embarcadero

As Data Modelling has been around for almost 30 years, however, in many organisations the benefits of data modelling still need to be “sold”. Whether it’s the pressure of regulatory compliance, a focus on data quality or a move to service-oriented architecture, “data” issues are once again coming to the forefront for many IT organizations. A real-world case study will be presented, describing how a major UK oil company established data modelling as a service aiding its data governance initiatives. This will illustrate topics such as:

Making the case for modeling and ‘selling’ it to the corporation
Determining and establishing the “service
Enforcing standards across models and incorporating stewardship
Sustaining an effective communications programme
Measuring the benefits

Featured Speakers:

		Christopher Bradley IPL

		Donna Burbank Embarcadero

Tuesday
30 October
13:30-14:30

META DATA

Back to top

META DATA Keynote:
Milestones on the MDM Road Map for 2008-09
Aaron Zornes, Chief Research Officer, The CDI-MDM Institute

In the past decade, large scale enterprises have added numerous applications and databases to their IT infrastructure as they diversify by adding product lines and customer bases via mergers & acquisitions (M&A). As a result, businesses have an unreliable view of customers, suppliers, products, etc., with no application or system having a "single version of the truth."

In the twenty-first century, market-leading organisations increasingly see the value that can be derived from delivering single or "master" views of enterprise data. Such mission-critical infrastructure no longer need be custom-built as mega vendors such as IBM, Oracle, SAP and Teradata provide commercial off-the-shelf solutions. Enterprise MDM solutions such as customer data integration (CDI) can now be realised via this new generation of master data management capabilities – with solutions ranging from mega vendor MDM applications, systems integrator frameworks, and best-of-breed “data hub” solutions.

An enterprise needs to create a unified and comprehensive customer view from all disparate data sources – including call centres, financial reporting systems, billing subsystems, and external data services. Once integrated, such "unified customer views" provide the entire organization with the ability to drive meaningful business action within and across formerly product-centric business units.

Such master data management (MDM) initiatives provide the enterprise with a comprehensive "system of record" which incorporates analytical (e.g., life-time value, next best offer, etc.), as well as operational (credit rating, last "n" customer service inquiries, etc.). Moreover, business process integration strategies such as customer data integration (CDI) and master product catalogues are increasingly essential to ROI realization of M&A.

The business case for CDI-MDM capabilities is driven primarily by competitive market requirements – e.g., economies of scale promised by M&A, increased cross-selling and up-selling capability, ability to rapidly deploy product “bundles,” reduced back office costs, increased levels of customer service, and enablement of customer-directed self-service.

Research analysts at the CDI-MDM Institute annually produce a set of twelve milestones for their “CDI-MDM Road Map” to help Global 5000 enterprises focus efforts for their own large-scale, mission-critical CDI-MDM projects. This keynote will focus on a set of strategic planning assumptions and present an enlightening view of the key trends and issues facing IT organisations during 2008-09 and beyond by highlighting:

Planning for the juggernaut of CDI-MDM market momentum, maturation, and consolidation
Coping with the skills shortage for data governance, enterprise architecture, et al
Identifying the essential (vs. desirable) features of an enterprise-strength CDI-MDM solution

Featured Speaker:

Aaron Zornes
Chief Research Officer
The CDI-MDM Institute

CONCURRENT SESSIONS

Tuesday
30 October
14:35-15:35

META DATA

Back to top

Master Data versus Reference Data
Malcolm Chisholm, President, AskGet.com

Heightened interest in Master Data Management (MDM) appears to have spawned many projects to address it at an enterprise level. Many of these projects appear to include Reference Data within their scope. However, Master Data and Reference Data are quite different. Each has its own unique management needs. If projects attempt to manage both using the same techniques they are likely to end in failure. This presentation explores the special properties and behaviours of master data and reference data. It examines some important management needs of both, to clearly demonstrate how each of these classes of data must be approached. Participants will learn the following:

What Master Data and Reference Data are, and how they relate to each other and other classes of data
Major unique management needs of Master and Reference Data
Integration of Master and Reference Data

Featured Speaker:

Malcolm Chisholm
AskGet.com

Tuesday
30 October
14:35-15:35

Information
Quality

Track 1

Back to top

Strategies for Data Quality Management: Survey findings from UK Utilities and Transport
Gordon Brown, Principal Consultant, AMT-SYBEX

In March and April 2006 AMT-SYBEX carried out a survey of Data Quality Management practices in the Utilities and Transport sectors in the UK.
The presentation will outline the key findings of this Survey of Senior Managers with responsibility for Data Management. The survey findings cover the importance, the impact, the root causes and the approach to improvement of data quality within these organisations.

The survey highlights the good intentions that often exist but are not matched by execution of high level principles. A best practice group is selected and the common elements of their strategic approach highlighted. The audience will learn:

The root causes of poor data quality in the utilities and transport industries
Characteristics of effective leadership in data management
The importance of measuring the information value chain
Differences in perceptions between IS and Business participants

Featured Speaker:

Gordon Brown
AMT-SYBEX

Tuesday
30 October
14:35-15:35

Information
Quality

Track 2

Back to top

CASE STUDY

Data Quality Framework at Nestlé
Dr. Walid el Abed, BTC - Data Standardization / Data Management, Nestec – GLOBE

Nestlé is beginning to provide worldwide visibility of its data quality and data management performance, and to provide tools to enable markets to take corrective measures and to drive continuous improvement. Through its Data Quality Framework (DQF), Nestlé has established common methods, definitions, tools, processes, and roles and responsibilities to measure the ‘as is’ and monitor the evolution of data quality in the corporation. The DQF will be a key enabler for Nestlé to leverage information for decision support and to facilitate our transition from an implementation focus to a “sustain-and-leverage” organization. Topics addressed include:

• Six data dimensions have been defined within the DQF
Supporting Business rules defined in conjunction with the Functions and Process Teams, and derived from the Data Standards
Data Management Best Practices
How KPIs and anomaly reports on Nestlé’s intranet enable an increase our data governance

Featured Speaker:

Dr Walid El Abed
Nestlé

Tuesday
30 October
14:35-15:35

DW/BI

Back to top

CASE STUDY

Using Data Services and a Data Warehouse to Enable Real-Time Customer Analytics
Sükrü Haciyanli, SI Meteksan

How can you provide real-time business insight in an environment of complex data sources, massive volumes, and ever-changing business reporting needs? In this presentation we will show how the third largest provider of mobile communication services in Europe uses SOA data services to integrate Siebel CRM with an Oracle data warehouse out to their Cognos analytics. Serving nearly 40 million customers and 1 million new CRM activities a day, the company has architected a high performance, flexible solution to the customer insight challenge.

How to effectively architect a data integration and data warehouse strategy using an SOA data services approach to accelerate deployment, reduce risks, and lower costs
What are the data warehouse and integration best practices and lessons learned when building reusable, high-performance data services?

Featured Speaker:

Sükrü Haciyanli
Meteksan

Tuesday
30 October
14:35-15:35

DAMA

Track 1

Back to top

What Makes A Good Data Model? Data Model Quality Criteria
Graham Witt, Consulting Manager, Ajilon Consulting

The answer to the question “What Makes a Good Data Model?” is complex. This presentation provides a checklist for reviewers of data models or data modellers wanting to produce better models, and covers:

Model documentation and presentation
Support for requirements
Alignment with other models
Compliance with standards, including naming standards
Data structures and data types
Business rules
Assumptions

Featured Speaker:

Graham Witt
Ajilon Consulting

Tuesday
30 October
14:35-15:35

DAMA

Track 2

Back to top

CASE STUDY

Semantic Enterprise Information Integration at Orange France Telecom – A Success Story
Antoine Proult, Enterprise IT Architect Associates at ACP Conseil

This presentation will focus on how Orange France improved productivity and positively impacted data enterprise practices related to project management, support and monitoring activities, regulatory compliance related to privacy, and information life cycle and data strategy.
Topics discussed include:

The creation of a metadata repository
Enterprise data associated with critical applications
Semantic integration principles
The implementation of a data virtualization layer, based on an EII platform

Featured Speaker:

Antoine Proult
ACP Conseil

Tuesday
30 October
14:35-15:35

DAMA

Track 3

Back to top

Enterprise Architecture: Straight From the Shoulder
John A. Zachman, President, Zachman International

John Zachman has been searching for the Enterprise Architecture “silver bullet” for 30 years and still has not found it. He has given up and says “there is no such thing as an Architecture silver bullet!” In this presentation he makes the case that architecture is foundational for managing modern enterprises. This presentation is not for anyone looking for a “quick-fix” or “easy-out”. This is Enterprise Architecture. See how John develops the engineering logic for:

Integration
Usability
Reusability
Flexibility
Interoperability
Quality

Featured Speaker:

John Zachman
Zachman International

CONCURRENT SESSIONS

Tuesday
30 October
16:05-17:05

META DATA

Back to top

A Complete Data Architecture Development to Support EAI and BI Implementation
Arthur Haynes, Data Architect, Siemens IT Solutions and Services Ltd (SIS)

The session explains the data architecture approach that has been taken within a major media industry organisation. The approach is pragmatic and based upon the fundamental philosophies of many standard architectural frameworks, e.g. TOGAF, Zachman. It specifically sets out an integrated implementation that can be applied for the data stream in any of these frameworks. Having set out the principles underlying the method, examples are described explaining how it works from project inception through to application operation.

The approach to be presented is shown in terms of its meta model basis (explaining the principles being followed), and examples of its application on projects at different development stages will be given. Finally the direct path through to XML and XSLT implementation within a middleware environment will be shown with specific reference to an implementation project. The approach shows a simple, manageable way to develop a Data Architecture within an Enterprise Application Integration that will also service corporate Business Intelligence ambitions. It is presented here as an easy-to-use strategy that other organisations may consider using.

Featured Speaker:

Arthur Haynes
Siemens

Tuesday
30 October
16:05-17:05

Information
Quality

Track 1

Back to top

CASE STUDY

Information Quality within Belgacom
Paul Gysemans and Annick Andries, Belgacom

This presentation briefly presents the company BELGACOM and situates the "Information Quality Team" in the enterprise. The mission, vision, roles and responsibilities of the team will be clarified. During the exposition a focus will be put on the covered domains, the several methodologies applied to guarantee producing reliable and useful audits and scorecards, and the used tool set. In addition the different actions like cleansing and root cause analysis, which arise out of the scorecards, are discussed. At the end the lessons learned are highlighted.

Featured Speakers: