RICHARD DONSON

Page *

RICHARD DONSON

*** ******* ***** *****

Naperville, Illinois 60565

630-***-****

acg399@r.postjobfree.com

SUMMARY

Accomplished and resourceful Enterprise Data Architect with expertise in leading

teams in the development of operational, transactional (OLTP), and decision-

enabling systems, specializing in conceptual, logical (3NF) and physical data

modeling, master data management (MDM), Meta-data management, data

governance, data quality, project management, and cross functional joint

application development (JAD) facilitation. Takes on increasing challenges, while

implementing the critical short- and long-term organizational objectives, while

working in a time-sensitive environment.

KEY STRENGTHS

MANAGEMENT: Leadership, team and relationship building, customer and vendor

management

DATA MANAGEMENT TOOLS: ERWin, Power Designer, ER Studio, CA Advantage

Data Repository, ASG Rochade Meta Data Repository, IBM Websphere Information

Integrator, Information Analyzer

DESKTOP TOOLS: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft

Project, Visio, Sharepoint

METHODOLOGIES: Waterfall, Agile, Service-Oriented Architecture (SOA), Object

Oriented, Information Engineering, Structured Analysis and Design, Total Quality

Management

PROFESSIONAL EXPERIENCE

AIM CONSULTING – CLIENT JLL

Chicago, IL

07/14 – present Enterprise Data Architect – Contract

Developing global strategy for Enterprise Data Management, including data

architecture,

Master Data Management, EDW, data modeling standards, meta data

management, and

Data Governance. Facilitating data discovery sessions with key subject matter

experts. Reverse engineered LOB Data Warehouse using Erwin, and updated

data model based upon Workplace Strategy and Property Management business

reporting requirements. Developed model management and publishing process

and introduced model review process with ETL, Reporting and DBA teams

increasing system development productivity.

KNOWLEDGENT – CLIENT JOHN HANCOCK

Toronto, Ontario, Canada

03/14 – 05/14 Master Data Management Business Analyst – Contract

RICHARD DONSON

Page 2

Led analysis of current source data and mapping to target MDM IBM Insurance

Industry database to master customer information transforming from policy centric

data to customer centric. Facilitate business requirements gathering sessions with

BA team and business subject matter experts. Utilizing Information Analyzer data

profiling results to confirm and adjust source to target mappings. Capture and

resolve issues, track and communicate progress and status to project

management.

SAFEBRIDGE SOLUTIONS – CLIENT CUNA MUTUAL

Madison, Wisconsin

09/13 – 02/14 Meta Data, Master Data Management & Data Governance Project Manager –

Contract

Led selection and successful implementation of ASG Rochade Meta Data

repository tool to manage business glossary, data governance workflow, and data

lineage. Project delivered on time and under budget. Created and maintained

project plan, status reports, change control, action items, issues and risks log.

Utilized client PMO methodology to complete project management deliverables

and pass project phase gates. Managed vendor, internal and external resources.

Led Data Governance program development and process implementation, and

Master Data Management tool assessment, RFP, and selection.

TERADATA – CLIENT TARGET

Minneapolis, Minnesota

01/13 – 07/13 Logical Data Modeler – Contract

Maintain and validate Enterprise Guest MDM, Enterprise Data Warehouse, and

Account logical data models from an enterprise perspective in collaboration with

business subject matter experts, data architects and other data modelers. Perform

data mapping between source MDM data model and the target EDW data model.

Utilize ERWin Model Mart to manage data models. Introduced business aligned

model alternatives of concepts previously modeled from a legacy technical

perspective leading to healthy debate on the direction of the logical data model.

Uncovered client requirements and subsequently collaborated with Teradata for

update to Standard Industry Model.

TEKSYSTEMS – CLIENT MILLERCOORS

Chicago, Illinois

03/12 – 01/13 Data Modeler – Contract

Created and maintained logical and physical data models across the staging, MDM

core, semantic layer, and data warehouse database environments to reflect

business requirements for retail sales, distribution, and inventory, and technical

meta data.

Lead the MDM Product logical and physical data model validation and update

process moving the project forward in the completion of Functional Design within

the Product Data Management Program. Collaborated with business SMEs,

business analysts, data analysts, information analysts, functional and technical

RICHARD DONSON

Page 3

designers to ensure the data model supported the business requirements.

Proposed recommendations for and obtained project team consensus on data

model updates. Used ERWin to implement 300 logical and physical data model

updates. Created semantic views used to publish data for data consumption

across the enterprise. Generated DDL for Teradata target DBMS.

TEKSYSTEMS GLOBAL SOLUTIONS – CLIENT NORTHERN TRUST

Chicago, Illinois

01/12 – 02/12 BI Project Manager

Led the development and delivery of Business Intelligence Competency Center

using agile methodology. Created and maintained project plans, project tracking

log of changes, issues, action items, and decisions. Facilitated daily scrum

sessions and status updates to client management. Managed dependencies

between business analysts, laboratory development, and operational development

teams.

ENTERPRISE WAREHOUSING SOLUTIONS – CLIENT MCDONALDS

Oak Brook, Illinois

11/11 – 01/12 Principal Consultant

Led the development and delivery of data requirements for a Managed Meta Data

Environment in support of the Master Data Management program and related Data

Governance. Developed and maintained project plans and weekly status report.

Gathered and documented requirements and translated into conceptual, logical

and physical data models using Erwin for Meta data subject areas of Data

Structures, Data Lineage, Business Semantics, Business Data, Business Rules,

Data Governance, Data Quality, Security Classification and Systems. Developed

and maintained attribute list to requirements matrix. Created Use Case Diagram

for the Input Layer of the Managed Meta Data Environment and Manage Data

Lineage use case.

HEADSTRONG – CLIENT INFORMA INVESTMENT SOLUTIONS

Durham, North Carolina

07/11 -09/11 Lead Data Architect - Contract

Developed conceptual, logical, and physical data models with ERWin for the MDM

Product Data Hub. Developed data architecture to integrate data from disparate

product systems, manage the data in the hub environment, and to consistently and

predictably publish and distribute the data from the hub. Facilitated workshops to

gather business requirements from business subject matter experts.

NEXT GENERATION INC. – CLIENT JOHNSON CONTROLS

Milwaukee, WI

11/10 – 06/11 MDM Project Manager

Assumed project management responsibility for the Global Supplier Data Master,

an MDM project, automating manual paper workflow process to maintain vendor

data across the across the enterprise, and integrating data from 136 ERP systems

within the Global Supply Chain Program. Entered the project as QA testing phase

began for first production release. Planned and aligned resources for subsequent

releases, in addition to managing the delivery of the current release. Quickly

RICHARD DONSON

Page 4

established productive working relationships with business and technical

management teams, infrastructure, application development, data architecture, QA

and training teams. Managed project resources, both internal and external.

Maintained project timelines and status reports. Facilitate issue and conflict

resolution.

TEKSYSTEMS

Chicago, Illinois

04/10 – 11/10 Lead Data Modeler/Architect - Contract

Leading data modeling process improvement with a specific focus on data modeler

DDL generation and hand-off to DBAs for the enterprise with the goal being 100%

data modeler DDL generation for all databases.

Developed data maps from conceptual data model levels 0 and 1 to physical data

models, while working with other data modeler to develop logical data model for

the EDW-CRM data warehouse using ER Studio.

Led the development of the conceptual and logical data model for the Regulatory

Evaluation and Validation business application from scratch. Facilitated data

modeling sessions with subject matter experts to gather data requirements and

meta-data. Utilized advanced functions of PowerDesigner to import and use the

enterprise lexicon eliminating the time needed to enter table and column

abbreviated names into the model.

TRANSUNION LLC

Chicago, Illinois

06/95 -01/10 Manager, Data Resource Management

Led and managed an enterprise-wide shared service data architecture team of

data modelers, Master Data Management developer, and meta-data repository

administrator. Established and continuously improved processes to manage

5000+ tables for operational and business intelligence applications across the

organization at the enterprise, business unit, and application area levels.

Collaborated with business and technical leaders to maintain resource alignment

that reflected corporate priorities, goals, and objectives. Worked with Project

Managers, Business Analysts, DBAs, developers, QA testers, vendors, and

business users throughout the System Development Life Cycle to ensure on-time

and within-budget system delivery.

• Developed logical data model using PowerDesigner transforming

OLTP credit reporting database to a relational DB2 database with 24 x 7

availability, reduced database update cycle time to 1 day from 7 days, and

provided capability for rapid enhancements to the database with new kinds

of data allowing the business to offer new products and enhanced credit

reporting services for additional revenue.

• Facilitated workshops to design data warehouse for the Mexican

Credit Bureau within the International Division for customer, product, and

sales data over time.

• Designed data warehouse model to track trends of credit attributes

over time by various geographic areas.

• Developed and implemented department vision and strategic and

tactical plans for attaining vision.

RICHARD DONSON

Page 5

• Assumed responsibility for 4 Master Data Management system

applications.

• Implemented 5 MDM solutions to improve efficiency, improve data

quality, and reduce business risk.

• Transformed Enterprise Reference Data updates to a predictable

process, while providing flexibility to update data in response to unplanned

business needs, and application-specific release schedules.

• Led implementation of data distribution technology for, IBM WebSphere

Information Integrator, for the MDM practice. Results were predictable

updates to over 200 master reference tables and distribution of data updates

across the enterprise, across DB2, Oracle and Sybase databases on

mainframe and open systems environments, and elimination of redundant and

inefficient ETL.

• Developed, implemented and managed data governance processes.

AMERITECH

Hoffman Estates, Illinois

01/95 – 06/95 Joint Application Development Facilitator (Contract)

Held responsibility for the facilitation of 1- to 4-day sessions for various business

units delivering project plans, business process models, business requirements,

screen and GUI designs, problem analysis, test planning, and alternative

prioritization.

ADDITIONAL EXPERIENCE

FIRST CARD, Elgin, Illinois, Business Systems Specialist, 1994.

AMERICAN AIRLINES, SABRE COMPUTER SERVICES, Fort Worth, Texas,

Senior Business Analyst, 1989 - 1994.

KEANE INCORPORATED, Westchester, Illinois, Programmer/Analyst

Consultant, 1988.

GENERAL DYNAMICS, Fort Worth, Texas, Programmer/Analyst, 1985 - 1988.

EDUCATION AND TRAINING

INDIANA STATE UNIVERSITY

Terre Haute, Indiana

Bachelor of Arts in Computer Science, 1984

Contact this candidate