Data Management Professional Certification Overview

(1)

Data Management Professional Certification

Overview

Loretta Mahon Smith

President, DAMA-NCR

DAMA International, Board of Directors AVP, T Rowe Price

(2)

Agenda

CDMP Program Overview

The DAMA Guide to the Data Management

Body of Knowledge (DAMA-DMBOK)

(3)

Speaker Information

T. Rowe Price

¾ 1983-Present

Professional Memberships: DAMA, IIBA, MPO, AIIM

Industry Offices:

¾ President, DAMA National Capitol Region.

¾ Board of Directors, DAMA International, VP Communications

¾ ICCP Certification Council Member.

Presentations:

¾ DAMA International Conferences 1998, 1999, 2000, 2003, 2005 2008

http://www.wilshireconferences.com/MD2008/agenda.html

¾ Information Quality Conference: 2001

¾ DebTECH: 2003, 2004

Publications:

¾ ModernAnalyst Journal http://www.modernanalyst.com

¾ The Data Administration Newsletter http://www.tdan.com

Master Level Certifications:

¾ Certified Data Management Professional (DAMA CDMP – Global)

¾ Certified Business Intelligence Professional (TDWI CBIP – Global)

(4)

Presentation Goals

Provide an overview for the CDMP certification

Describe with the certification/recertification process.

Provide Examples of Exam Questions

(5)

About ICCP

Institute for Certification of Computing Professionals (ICCP)

is

¾

Independent certification organization

¾

_{A Consortium of Professional Associations}

¾

Administers the DAMA International certification

examinations and ensures that the certifications are:

– Measurable Validity – Legally Defensible – Job Related

What does ICCP Do?

Establishes recognized professional standards within the

information systems and information technology industry

Tests knowledge of stringent industry fundamentals, not

product-specific awareness

(6)

D

A

M

A

II

I

n

tt

t

e

rr

r

n

a

tt

t

ii

i

o

n

a

ll

l

Certification History

(7)

Context

What ICCP Certification is NOT:

¾

An event

¾

_{A class}

¾

An end-of-course exam

¾

Subjective

“Certification, in itself, is not a

goal, but Professionalism is.”

Dr. Paul M. Pair, ICCP Fellow, 1982

PERFORMANCE PROFILE

Content Number Your Status Percen- 2 5 7 9 Description Of Items Score tile 1 5 0 5 9 Systems Development 100 77 Pass 85 **********************

1. Systems Analysis 39 33 94 ************************ 1.1 General System Theory 4 3

1.2 Preliminary Studies 10 9 1.3 Problem Definition 5 5 1.4 Data Gathering/Analysis10 8 1.5 System Requirements 10 8

2. Systems Design & Imp’n 52 38 80 ********************** 2.1 Alternative Sys. Design 5 5

2.2 Logical Design 10 9 2.3 Detailed System Design17 10 2.4 Privacy/Sec’y/Controls 8 8 2.5 System Implementation 7 1 2.6 System Eval’n and Mtce. 5 5

3. Systems Analyst as Prof’l 9 6 41 ******** 3.1 Organizational Roles 3 2

3.2 Interpersonal Roles 2 2 3.3 Communication Skills 2 0 3.4 Ident. Key Individuals 2 2

(8)

(9)

How can I get a CDMP?

Fill out application (

www.dama.org

or

www.iccp.org

)

Take / pass 3 exams

Meet the Experience & Education qualifications

(10)

Exam Details

90 minutes, 110 multiple choice questions each

Exam content

¾

_{100 experience based randomized multiply choice}

questions (scored)

¾

Plus 10 beta multiply choice randomized

questions (not scored)

Pass Exams at 70% or better for Mastery Level

(11)

11

2009 CDMP Statistics

201 CDMP Exams sold in 2009

68 CDMP certificates awarded in 2009

¾

_{40 were Practitioner}

¾

28 Masters

494 Total CDMP Holders To Date

At Enterprise Data World 2010, more than 40

professionals signed up for the study session and test

seatings. 110 exams were given and 32 attendees

(12)

CDMP Requirements

Experience & Education

¾

48 months experience for Mastery

¾

24 months for Practitioner level

¾

Substitute up to 24 months of the experience

requirement with appropriate undergraduate or

graduate degree

(13)

Specialty Exam Choices

Current ICCP Exams include:

¾

Data Management

¾

Data Warehousing

¾

Database Administration

¾

Business Intelligence & Analytics

¾

Data & Information Quality

¾

Systems Development

¾

Systems Security

¾

Zachman Framework

2

(14)

One Specialty Exam

Substitution

These programs are pre-qualified to substitute for

Oracle Database Administrator

Oracle Certified Professional

Teradata Certified

Professional

Microsoft Certified

Master-SQL Server 2008

(replaces Microsoft Certified Database

Administrator)

IBM Certified Solutions Expert

IBM Certified Advanced DBA

IBM Certified Database

Administrator

Certified Insurance Data

Manager (CIDM)

(15)

Recertification

Goals

¾

Maintain professional

competence

¾

Update existing

knowledge and skills

¾

Attain new or

additional knowledge

and skills

Requirements

¾

3 year cycle

¾

_{Earn 120 approved}

contact hours of

continuing education

¾

Pay $75 per year

maintenance fee to ICCP

¾

Receive Annual

(16)

Ways to Earn Professional

Development/Recertification Credits

Depends on exam score: - 70% or higher = 60 credits - 60 - 69% = 30 credits - 50 - 59% = 20 credits Sit for other ICCP examinations

For each activity category, credit limited to 60 recertification credits / 3 year period

Teaching, lecturing, presenting Self-study programs

Published article, book

Count time of education program content Independent organized programs

Professional society meetings, seminars, conferences

1 Quarter Hour = 8 credits 1 Semester Hour = 12 credits

1 Continuing Education Unit (CEU) = 10 Formal educational institutions

Professional Development /

Recertification

(17)

Reasons for Seeking Certification

Source: Prometric (Dataquest Study) Advancement in Profession 41.7% Advancement in Current Job 17.2% Secure Employment 8.1% Job Requirement 8.0% Improve Job Security

4.8% Assess Current Expertise 3.1% Increase Compensation 2.4% Attain Access to Vendor Support 1.8% Other 3.6%

Prepare for New Job 9.4%

(18)

Why CDMP?

Reasons

Results

Other, 11.4 Financial Reward, 0.4 Self-Evaluation, 5.1 Credential, 37.3 Increase in Salary, 11 Solve Problems Quicker, 19 More Credibility with Customers, 24 More Credibility with Organization, 24

(19)

Career Growth

Many consulting firms pay bonuses averaging $5,000 for

those who achieve professional certifications

Large corporations typically reimburse employees for

review course, testing, etc. and many provide bonuses

from $100 to $1,000+

Government agencies pay for training, exams, provide

bonuses, and some give permanent salary increases (up

to 15%)

Surveys consistently show that certified individuals

¾

earn more than their counterparts and

¾

hold more advanced positions

(20)

IS Core Sample Questions

1. A list of the open accounts in a ledger showing their debit and credit balances is known as

A) a trial balance B) a PL statement C) a closing journal D) an account analysis

2. What management function is concerned with the grouping of activities to be performed and the establishment of institutional structures to carry them out?

A) Planning B) Organizing C) Controlling D) Coordinating

(21)

1. A word such as CUSTOMER in a column name should

A) be abbreviated in every column name the same way. B) not be abbreviated.

C) be abbreviated but a different abbreviation may be used in different columns depending upon the additional characters allowed-e.g.-CUST in some

columns, CST in others where additional space needs to be saved. D) be abbreviated only when necessary.

2. A subject area model describes

A) business subjects and the data contained within them. B) data entities and the subjects that they contain.

C) data subjects mapped to legacy systems.

D) business subjects and the relationships among them.

3. A data model in the first normal form has no

A) keys or identifiers. B) relationships.

C) repeating groups. D) data redundancy.

Data Mgmt / Data & Information

Quality Sample Questions

(22)

1. A star-schema is composed of

A) a universe of data warehousing subjects. B) a fact table surrounded by dimension tables. C) a base table surrounded by satellite tables. D) event data surrounded by reference data.

2. Business drivers, goals, and strategies provide __________ for data warehousing activity programs.

A) requirements

B) success measures C) context

D) architecture

3. The two most common data integration architectures are

Data Warehouse / Business Intelligence &

Analytics Sample Questions

(23)

1. Which of the following is NOT a property of the ACID test for transaction processing systems? A) Atomicity B) Consistency C) Isolation D) Disposability

2. A backward database recovery is useful in

A) quickly restoring the systems.

B) rebuilding the database in an unstable environment. C) preserving the structure of the data.

D) restoring the database to a state known to be correct after some failure.

3. A composite key is

A) a primary key that is made of several attributes.

B) required before a two-phase commit can be completed. C) a group of measures.

D) a combination of a personal and system administrator password.

DBA / Systems Development /

System Security Sample Questions

(24)

What does the CDMP

cost?

2009

IS Core $285

First Data Specialty

$285

Second Specialty

$285

Total

USD

$855

Beta Exams are Free. You must fill out an application. If you pass the exam and

want to apply it towards the DAMA Certified Data Management Professional (CDMP) designation, there will be a conversion charge of $195.

(25)

CDMP

Specialty

Exams

Mapped to

DAMA-DMBOK

Database Management Data Security Management Data Architecture, Analysis & Design Data Quality Management Data Warehousing & Business Intelligence Reference & Master Data Management Meta Data Management Document, Record & Content Management Data Governance (Exam Planned) Exams: Data Mgmt; Zachman Enterprise Architecture Framework2 E x_a m : D B A Ex am s: DB A; Sy ste m S ecu rity Ex am : D ata M gm t Exam s: D ata & Info rmat ion Qua lity; Data Mgm t Exam s: D ata W arehou sing_; Bus_ine ss Int ellig ence & A naly tics; Bus_ine ss P roce_{ss M} anag_em ent N o E x_a m P la_n n e_d Data Quality

Management Data _Development

Database Operations Management Data Security Management Reference & Master Data Management Data Warehousing & Business Intelligence Management Document & Content Management Data Governance Exams: Data Mgmt;

Data & Info Quality Meta Data Management Exam : Data Mgmt Data Architecture Management Ex am s: D ata_M gm t; Sy ste_m s De_ve lop_m en_t

(26)

BETA EXAM OFFERINGS

CHANGES IN 2010: 4 New Beta exams that align to the DAMA-DMBOK.

¾ Data Management Core new mandatory test to CDMP instead of first specialty.

¾ Data Development

¾ Data Operations and Security

¾ Data Warehousing

DAMA members may take beta exams for free until June 30, 2010. Exam taker Information regarding the new beta exams:

¾ If you pass the exam and want to apply it towards the Certified Data Management Professional (CDMP) designation, there will be a conversion charge of $195 USD (the regular exam price is $285 USD) payable to the ICCP.

¾ The beta test is FREE. You will have to fill out an application, but no payment is expected unless you are taking other exams, applying this exam towards the CDMP, or applying this exam towards recertification credit.

(27)

Exam Prep & Study

Materials

ICCP offers Sponsored Review Courses through chapters or

companies

Study materials and exam review course available through

ICCP office (

[email protected]

)

¾

DAMA study materials are part of Data Management and Data

Warehousing self-study packages sold by ICCP

• DAMA Data Management Exam Study Guide

• DAMA Data Warehousing Exam Study Guide

¾

Sample exams are available at

http://www.iccp.org/iccpnew/sampletests.html

¾

Exam outlines at

http://www.iccp.org/iccpnew/outlines.html

DAMA-DMBOK

(28)

Questions?

For CDMP Program Information:

Patricia Cupoli,

ICCP [email protected]

or

Eva Smith,

ICCP [email protected]

The DAMA website is

www.dama.org

For ICCP Exam Administration:

ICCP office at:

[email protected]

The ICCP website is

www.iccp.org

CDMP Social Networking:

(29)

Presentation Goals

9 Provided an overview for the CDMP certification

9 Described with the certification/recertification process.

9 Provided Examples of Exam Questions

9 Introduced changes resulting from the introduction of the DAMA Guide

to the Data Management Body of Knowledge

(30)

Answers for Sample

Questions

DBA 3.1 A 3 DW 2.1 A 3 DM 3.2 C 3 3.2 D 3 DBA 4.4 D 2 DW 1.1 C 2 DM 3.2 D 2 2.2 B 2 DBA 4.3 D 1 DW 3.2 B 1 DM 4.1 A 1 2.2 A 1 DBA/ SYS/SEC Outline # DBA / SYS/SEC Answers DBA/SY S SEC# DW/BIA Outline # DW/BIA Answers DW/BIA # DM/DIQ Outline # DM/DIQ Answers DM/ DIQ# IS Core Outline # IS Core Answers IS Core #

Data Management Professional Certification Overview