linda mozewsky, information resource manager mark o’gorman ... and it collaboration... · 12 cfos...

Business and IT Collaboration through Data Stewardship at Canadian Tire

Business and IT Collaboration through Data Stewardship at Canadian Tire

Linda Mozewsky, Information Resource ManagerMark O’Gorman, Enterprise Data Architect

CTC Enterprise IT

Linda Mozewsky, Information Resource ManagerMark O’Gorman, Enterprise Data Architect

CTC Enterprise ITDecember 2006

2

AgendaAgenda

• Canadian Tire Story• Data Stewardship• Data Ownership• Data Architecture• Data Principles• Information Management Context• Success Stories and Lessons Learned

3

Canadian Tire TodayCanadian Tire Today

465 stores 4MM+ accounts 61 stores

328 stores 262 gas bars

4

We are Unique in the MarketplaceWe are Unique in the Marketplace

Brand recognition and trust

Reach and scale

Real estate

Unique formats, products and services

Canadian Tire ‘Money’loyalty program

Unique business platform of inter-related businesses

5

Drivers for Data StewardshipDrivers for Data Stewardship

• External DriversPIPED Act (Applies to retail organizations January 2004)CEO and CFO Certification (Bill 198)

• Internal DriversEnsure decisions are based on accurate facts (single version of the truth)Optimize employee productivityMinimize potential for inconsistencies in dataReduce system development and maintenance costs

6

Structure of Data StewardshipStructure of Data Stewardship

7

Mission StatementMission Statement

• Data Stewardship is a business-enabling team that directs and advises data owners and information consumers on the most appropriate and effective use of enterprise data assets in order to maximize enterprise business and shareholder value.

8

ResponsibilitiesResponsibilities

• Data Stewards’ Responsibilities include:Maintain a focus on continuous improvement of data quality, integrity and consistencyCreate awareness of current data quality issues and impacts within the functional area from an enterprise perspectiveMaintain an understanding of, advocate and communicate data management principles and standardsAct as liaison for their respective business areaEnsure appropriate data access and useAct as the single point of contact for information needs and issues

9

Value of Data StewardsValue of Data Stewards

• The value Data Stewards bring to the organization include:

Provide expertise, guidance, methodologies and models to cultivate a common understanding of enterprise data assetsSupport CTC policies related to data and information managementImprove decision-making and reporting Improve data quality by advising on definitions and standardsAssist customers in the business and IT in defining data content, specifications, and understanding information risksProtect the privacy and confidentiality of data

10

Focus for First YearFocus for First Year

• Established governance structuresData Advisory CommitteeEscalation Procedures

• Established the identity of Data StewardsLogoMission StatementRole and Responsibilities

• CommunicationSpreading the Word

• Increased complement of Data Stewards• Developed data issue log and process

11

Focus for Second Year & BeyondFocus for Second Year & Beyond

• Promote Data QualityDefinitionsMeasurement MethodologyCommunication

• Increased Involvement in Projects• Establish Communication Vehicles

Quarterly Bulletins• Strengthen processes & procedures• Continue to increase the complement of Data

Stewards

12

CFOs / CIOsCFOs / CIOs

Generally VP Level

CFOs / CIOs

Generally VP Level

Generally Director Level

CFOs / CIOs

Generally VP Level

Generally Director Level

Delegation from BusinessData Owner

Generally Manager Level

`

Addressing the Ownership QuestionAddressing the Ownership QuestionPILOT Business Data Management Framework

Who is allowed to make which decisions?

VisionEnterprise Executive Owner

Enterprise


Enterprise

StrategyExecutive Data Owner

Division Subject Area


Enterprise



DesignBusiness Data Owner

Process Entities


Enterprise



DesignBusiness Data Owner

Process Entities

OperateBusiness Data Manager

Major Function Data

Set Enterprise information framework:•Vision / mission / values•Policies & Guiding Principles•Strategies like BI, Meta Data. Master Data Mgmt


Set subject area:•Enterprise-wide view•Strategy, Objectives, Priorities, Resources



Define/maintain Entity process and usage:•Data Lifecycle (create, maintain, purge)•Data definitions and validity rules•Security (access, usage, legal, privacy)•Quality



Define/maintain Entity process and usage:•Data Lifecycle (create, maintain, purge)•Data definitions and validity rules•Security (access, usage, legal, privacy)•Quality

Execute according to design•Maintain quality•Approve security access

13

Data Architecture ServicesData Architecture Services

• Strategy and Program Planning • Information Needs Analysis• Business Data Knowledge Capture• Data Designs• Data and Information Management

15

Purpose of Data PrinciplesPurpose of Data Principles

• Data Principles are a framework for decision-making and guide behaviours related to information management

• Data Principles are applied:to the use and deployment of all resourcesacross the enterprise to bring a business point-of-view to IT decisionsto provide a common vocabulary for guiding project teams

16

How Data Principles were DevelopedHow Data Principles were Developed

• Based on research of industry best practices

• Updated or augmented to CTC culture, environment and needs by Data Architecture

• Refined through Enterprise Architecture review

• Validated and updated based on CTC experience by Data Stewards

• Supported by Data Stewards

• Reviewed and aligned with Security efforts through Security and Risk Management groups

• Shared with CTFS and MWW

17

How Data Principles are UsedHow Data Principles are Used

Architects: as a framework for standards development

Projects: to understand value and data management effort

Policy Makers: to provide best practice support and alignment to standards

Review Boards: to raise visibility to value, costs and risks of decisions

Data Stewards: to assist with resolving data issues

Principles often require striking an appropriate balance among

principles

Principles must be considered in the

context of "all other things being

equal."

Principles are interrelated and

need to be applied as a set

18

Information Management ContextInformation Management Context

19

Success StoriesSuccess Stories

• Embracing data quality measurement methodology• Developed Business Data Management

Framework to define levels of ownership• Contributing to a meta data repository• Developed Data Principles• Establishing common definitions• Examples of Data Issue Resolutions

Establishing a single sourceHandling a group of data issues that are similar and involve the same stakeholders to identify root causes of problems and work together for remediationResolving reconciliation issues

20

Wins, Challenges, Lessons LearnedWins, Challenges, Lessons Learned

• Collaboration of Business and IT• Organizational Change Management• Commitment needed at all levels• Walk before you run• Manage by collaboration, not by mandate

Limited decision-making and enforcement authority• Never underestimate the time required to reach

consensus• Continually advertise the value Data Stewards

have brought to the organization

22

Contact InformationContact Information

• Linda Mozewsky, Information Resource [email protected]

• Mark O’Gorman, Enterprise Data [email protected]

mailto:[email protected]

linda mozewsky, information resource manager mark o’gorman ... and it collaboration... · 12 cfos...

Documents