Anne Marie Smith, PhD. Director of Education Principal Consultant EWSolutions, Inc.

1. How to Develop the Data Role in Government:  Creating the Individual Development Plan (IDP) for Data Management Anne Marie Smith, PhD. Director of Education Principal Consultant EWSolutions, Inc. AMSmith@Ewsolutions.com Strategic Partner & Systems Integrator Intelligent Business Intelligencesm

2. Anne Marie Smith Background • Anne Marie Smith – AMSmith@ewsolutions.com • Internationally recognized expert and speaker in the fields of enterprise information management, data modeling, meta data management and data warehousing, one of the top industry experts in data governance and information management strategy and planning • Over 20 years experience in delivering solutions in enterprise information management for numerous companies / clients across varied industries • Published over 50 articles that have been featured in some of the industry’s most prestigious magazines and newsletters • Contributing author to the DAMA Data Management Body of Knowledge (DMBOK) • Has taught at several institutions of higher learning including LaSalle University • Holds certifications in PMP, CDPM and has earned a PhD in Management Information Systems • Editor-in-Chief, Real World Decision Support journal: http://www.realworlddecisionsupport.com

3. The Data Management profession has members who are entrusted with the information of major organizations. Many, if not most, of these professionals work for large organizations and are charged with definition, development, and management of the mission-critical information stores of significant organizations of the world. Most of these professionals have been out of college for 15 to 20 years – this is not an entry-level profession Not an Entry Level Profession

4. A Plethora of Job Titles Data Analyst Database Analyst Data Modeler Data Management Specialist Information Analyst Data Architect Meta Data Specialist Business Analyst Enterprise Data Manager Etc……………. Data Management suffers from a lack of standard job titles:

5. What’s my Career? • Career goals change over course of professional life • Develop a career path with flexibility • Decide on your specialities • Identify the skills you need to acquire mastery of your chosen data management specialities • The DAMA Curriculum Framework can help

6. OPM Job Classification IT Classification: 2200 – Data Management is part of this general classification Skills listed in 2210 are mostly physical database administration, little acknowledgement of conceptual or logical data management skills Development of all data management skills is essential for all data management professionals in government – conceptual and logical as well as physical

7. The approach taken by DAMAI Data Management curriculum includes all aspects (conceptual, logical and physical perspectives: Model for data management in the real world List of concepts in Data Management List of topics from the ICCP CDMP exams as input Body of Knowledge (BOK) for Data Management as input List of careers and job clusters from the NWET (National Workforce Center for Emerging Technologies)1 List of education delivery channels based on the North American model Clustering of topics for courses Cross reference matrices for the reader to study in the development of a curriculum 1 Building a Foundation for Tomorrow – Skill Standards for Information Technology, National Workforce Center for Emerging Technologies, 1999. Curriculum Approach

8. ICCP – highest level certification for computing professionals http://www.iccp.org/ ICCP Data Management certification (CDMP) designed to test knowledge of IRM/DRM functions – all stages (conceptual, logical, physical) Serves as validation for the DAMA IRM/DRM curriculum – courses and exams based on DAMA curriculum framework ICCP and DAMAI

9. ICCP and DM Certification • CDMP Certified Data Management • Professional Practitioner (pass tests at 50% or higher) • Master Professional (pass tests at 70% or higher) • Required: • Pass three ICCP exams in data management and related fields • Work experience in data field • Recertification – 3 year cycles • Continuing Professional Education • Adopt ICCP Code of Ethics

10. ICCP and DM Certification • CDMP-eligible Exams include: • IT Core • Data Management • Data Warehousing • Database Administration • Integrated Project Management • IT Management • Systems Development • Business Intelligence • Data and Information Quality • ……………

11. Career Ladders for Data Management use skill standards published by the National Workforce Center for Emerging Technologies Career Ladders describe a progression of job titles and skill requirements for a job cluster Career Ladders have three levels Entry (Novice) Proficient (Practitioner) Expert (Master) Curriculum designed to provide foundation knowledge and facility for the chosen track Career Ladders in DM

12. IRM/DRM Career Ladders include: Business or Systems Analysis Data Warehousing Data Analyst / Data Modeling / Architect Data Administration / Management Database Administration Project Management Data Quality Information Security Technical Trainer / Technical Writer Data or Information Architect Data Governance Co-ordinator Career Ladders in DM

13. Career Ladders include paths and roles appropriate to the ladder Example for Database Administrator: Career Paths & Roles Novice Practitioner Master Senior Database Administrator Database Analyst Foundations Associate DBA Database Administrator Required Skills and Knowledge

14. Example for Data Modeler/Architect: Career Paths & Roles Novice Practitioner Master Intermediate Data Architect Senior Data Architect Enterprise Data Modeler Foundations Modeler Required Skills and Knowledge

15. Example for Data Quality Analyst: Career Paths & Roles Novice Practitioner Master Data/ Database Analyst Intermediate Data Analyst Data Quality Analyst Senior Data Quality Administrator Foundations Required Skills and Knowledge

16. Example for Data Governance Coordinator: Career Paths & Roles Novice Practitioner Master Data Governance Coordinator Many routes ! Foundations Required Skills and Knowledge

17. Career Choices: Foundations+ enterprise data modeller data governance co-ordinator Master Practitioner database programmer Novice • Modeling, Database, Ethics, Data processes (CRUD), Interaction of data and business logic

18. Ladders or Tree? Both ! It is important for the data management professional to have some exposure to most areas of data management – tree It is important for the data management professional to choose one or a few areas for progression to mastery - ladder Choosing leaves on the data management tree for exposure and choosing one or a few areas for mastery will create the well-rounded data management professional

19. Topics an area that are explored to some degree within the DAMAI Curriculum; a curriculum and /or course learning unit Topics may relate to one or more courses, and may be combined as appropriate with other topics Topic Cluster: is a highly related set of topics which are typically taught together – courses are developed by assembling a series of topics within a cluster and adding additional materials/topics as necessary Topics and Topic Clusters

20. The Environment for Managing Data as a Resource Types of data and information General file and database processing principles Uses of Data, information, knowledge, wisdom; metadata data and information (by discipline and within DRM) Evolution of database technologies Risks and rewards of data resource management Data Resource Management Overview Information Systems Planning (ISP) concepts Data / Metadata Management Plans Strategic data plan (linked to business plan) Enterprise data / information framework Data portfolio management Relationship management (vendor, customer, employee) Data quality management Metadata management plan Policies / Standards / Legal requirements/ Processes / Procedures Internal to DRM External to DRM External to organization Two Topic Clusters with Topics There are 14 topic clusters in the DAMA Curriculum Framework

21. Planning for Data and Metadata Data Requirements Analysis and Documentation Data Models and Modeling Relational Data Model Data Storage Management Data Access and Database Programming Data Warehousing Data / Metadata Infrastructure Management Information and Data Security Data Quality Management Data Reliability Information Systems Project Management Topic Clusters List

22. Continuing Education Map your continuing education goals to curriculum Become certified as a Data Management Professional, Business Intelligence Professional or other ICCP certification (CDMP, CBIP) Discover courses and seminars to provide Professional Development Units (PDU) and contact hours for re-certification Raise awareness of certification and continuing education to advance the data management profession throughout the US government

23. Generic Roles VP/Director Manager Manager Manager Manager Enterprise Architect Database Architect DW Architect Portfolio Manager Metadata Architect Enterprise Data Administrator Data ResourceAnalyst Database Administrator Data Warehousing Analyst DataAdministrator Enterprise Database Administrator DataAdministrator Database Administrator DW Developer PerformanceAnalyst Performance Management Analyst Operator Operator Storage Analyst Operator

24. Recommended Qualifications • CCP = Certified Computing Professional • DMP = Data Management Professional • ACP = Associate Computing Professional • UG = Undergraduate • CS = Computer Science

25. Recommended Competencies

26. Recommended ICCP Exams

27. Courses for ICCP Exam Prep Some organizations offer courses that are based on ICCP / DAMA curriculum framework Some colleges offer data management education, visit http://www.dama.org / education for list of schools and programs EWSolutions’ courses are certified by ICCP and State of Illinois for professional development and continuing education credits and can serve as foundation for exam preparation http://www.ewsolutions.com/education for complete course list

28. Developing and refining your approach to continuing education in enterprise data management is essential for professional and personal growth DAMA Curriculum Framework can serve as a proper foundation for developing your personal education path Continue to learn about data management and its related fields Become / remain active in DAMA for educational and professional development opportunities http://www.dama.org Conclusion

29. Questions

30. References Building a Foundation for Tomorrow – Skill Standards for Information Technology, National Workforce Center for Emerging Technologies, 1999. http://www.nwcet.org DAMA International Curriculum for Post-Secondary Education http://www.dama.org Institute for Certifying Computing Professionals (ICCP) http://www.iccp.org

31. Additional References EIM Institute: http://www.eiminstitute.com Real World Decision Support Journal: http://www.realworlddecisionsupport.com The Data Administration Newsletter: http://www.tdan.com DAMA-Data Management Body of Knowledge (DAMA-DMBOK): http://www.dama.org

32. Contact EWSolutions, Inc. 15 Spinning Wheel Road, Suite 330 Hinsdale, IL 60521 Office 630.920.0005 Fax 630.920.0008 http://www.EWSolutions.com Dr. Anne Marie Smith Principal Consultant, Director of Education Office 856.468.6194 amsmith@ewsolutions.com