top of page

TECHNICAL CURRICULA:
Metadata management

noun-sustainable-1624692.png

METADATA MANAGEMENT:
ERWIN DATA INTELLIGENCE SUITE

Work samples showcased below were developed for the Federal Government and are proprietary. 

Wrote, designed, and developed an end-to-end training curriculum that provided Centers for Medicare & Medicaid Services Application Data Stewards in Erwin Data Intelligence Suite and Business User Portal metadata management and data catalog software.

 

Training consisted of a series of 5 webinars accompanied by an in-depth PowerPoint Lesson. Additional support documentation included User Quick Start Guides and recommendations on best practices for flagging metadata with Sensitive Data Indicators and classifications.

 

Application Data Stewards are responsible for tracking Medicare and Medicare fraud. There are ten Application Systems that include Fraud Prevention System (FPS) and National Plan and Provider Enumeration System (NPPES).

Applications Data Stewards are data analysts specializing in using metadata analytics to track Medicare fraud, waste, and abuse. Their findings are used to prosecute offenders.

 

ACCOMPLISHMENTS

Acquired product expertise on Erwin Data Intelligence Metadata Management workflow through experimentation (applying use cases and testing the functionalities), and interactions with Subject Matter Expert to develop training curriculum from scratch.

Erwin Data Governance tool is a Relational Database model that links metadata objects, Tables, and Columns, according to tuples:
 https://www.erwin.com/products/erwin-data-intelligence/

ROLE

Lesson design, writing, and editing, project coordination (training enrollment, tracking, scheduling, and follow-up). Content Management, maintained and managed training artifacts, recordings, and related technical documentation published and maintained on CMS Enterprise Confluence.

BUSINESS GOAL

  • Product adoption

  • Change Management

CHALLENGE

Erwin Software developer's end-user documentation was slim. No training documentation exists as a reference. I developed end-user knowledge of concepts and workflow through self-teaching and collaboration with Subject Matter Experts. 

 

Webinars created with minimal resources (without authoring tools) and recorded on-the-fly in Zoom Gov.

Developed and delivered a scaffolded training series concurrent to the DevOps engineers stabilizing the environments (Validation and Production). 

TRAINING DELIVERY

Live interactive Webinar sessions conducted in the CMS Zoom video conferencing tool https://zoomgov.com/

ABOUT THE TRAINING

Training curriculum targets Centers for Medicare & Medicaid Services Data Stewards, Business Owners, and stakeholders in the use of Erwin Data Intelligence Suite. 

Target Audience

Gathering and updating network connectivity details to establish connectivity from an application to the DMDG Erwin Tool. Once established, the DMDG DevOps Engineers defined the Erwin DI environment and coordinated the metadata scan.

Stakeholders
 

Division of Investigative Systems Management (DISM)
Data Analytics and Systems Group (DASG)
Center for Program Integrity (CPI)
Centers for Medicare & Medicaid Services (CMS)

Business Goals

The Center for Program Integrity (CPI) Data Analytics and Systems Group (DASG) manages and utilizes many kinds of data assets, including operational data stores, data warehouses, data marts, data extract files, and Business Intelligence (BI) reports.

Erwin Data Intelligence Suite was elected as the data governance and Metadata
Management tool to standardize metadata management processes and policies, specifically data definitions, terms, and reference values. The outcomes included:
Stakeholder accountability, compliance, and support of Data Stewards with satisfying their data management contractual obligations.

There are 10 CMS System Applications that Erwin will monitor. Each System
has assigned two Data Stewards responsible for overseeing change
management, including the scanning, augmenting, and mapping of metadata.

Erwin DI Demo

 

Start to finish workflow

The video walks through a sample application data steward workflow in Erwin Data Intelligence Suite. Starting with a metadata scan in Erwin's Metadata Manager module, the demonstration walks through how to access the Data Dictionary and flag it with Sensitive Data Classifications. The demo then moves to the Mapping Manager module to demonstrate mappings and lineage.​ Demo created on the fly without ‌an authoring tool.

90-second excerpt of an hour and half live webinar sessions delivered through CMS Zoom https://zoomgov.com

LESSONS 1 & 2

Metadata Manager: Environments, Schemas, Tables, Columns

I'm a paragraph. Click here to add your own text and edit me. It’s easy. Just click “Edit Text” or double click me to add your own content and make changes to the font. Feel free to drag and drop me anywhere you like on your page. I’m a great place for you to tell a story and let your users know a little more about you.

This is a great space to write long text about your company and your services. You can use this space to go into a little more detail about your company. Talk about your team and what services you provide. Tell your visitors the story of how you came up with the idea for your business and what makes you different from your competitors. Make your company stand out and show your visitors who you are.

Webinar sessions contain proprietary information and PHI and not available for viewing.

Business Objective:
The primary interface for metadata entry (ingestion) and management includes metadata repositories (the data catalog), running a data lineage and mind map, and reference values.
.

Learning Objective:

Understand System-level, Environment-Level, and Table/Column-level User Interfaces and where to access key functionalities.

Conduct a metadata scan into the correct System Environment, augment Tables and Columns with Sensitive Data Indicators at the Environment-level.
 

Erwin Functionalities:
Scan metadata, import/export Data Catalog, configure and flag Tables with Sensitive Data Indicators and Classifications, run a data lineage.

Lesson 1 deck contained 125 slides
Lesson 2 deck contained 140 slides

Cover page of 157 slide deck. CMS-standard style

I'm a paragraph. Click here to add your own text and edit me. It’s easy. Just click “Edit Text” or double click me to add your own content and make changes to the font. I’m a great place for you to tell a story and let your users know a little more about you.

Metadata Manager User Interface

Screenshot 2024-02-07 at 11.57_edited.jp

Sensitive Data functionalities and topics

L1 SDI_edited.jpg

Excerpt for step-by-step instructions: how to run lineage 

L1 Lineage2_edited.jpg

Comprehensive list of Lesson 2 Functionalities and features

L2_0_edited_edited.jpg

Excerpt from step-by-step instructions: how to generate mind map

image_edited.jpg

LESSONS 3

Mapping Manager

Webinar sessions contain proprietary information and PHI and not available for viewing.

Business Objective:
Allow CMS to implement process changes that lower risk and increased data quality, perform system migrations and ETLs with higher confidence, perform data discovery with a comprehensive view of metadata across Application Systems.
 

Learning Objective:
Create manual and automated maps to understand, record, and visualizing data as it flows from data sources to consumption. This includes all transformations the data underwent along the way—how the data was transformed, what changed, and why. Understand Data Relationships within and between CMS System Application.
 

Erwin Functionalities:
Use manual and automap features to map metadata (Tables, Columns, Views) within your Application, perform data lineage, and impact analysis.

Cover page of 157 slide deck. CMS-standard style

I'm a paragraph. Click here to add your own text and edit me. It’s easy. Just click “Edit Text” or double click me to add your own content and make changes to the font. I’m a great place for you to tell a story and let your users know a little more about you.

image.png

High-level lesson roadmap

image.png

Software Heirarchy

image.png

Diagram provides visual of the mapping manager outputs when metadata flows between CMS Systems

Diagram illustrates a manual mapping output from a source Table and Columns

Map2.png

Diagram illustrates a manual mapping output from the source Table and Columns to Target

Map1.png

TRAINING PLAN
 

Train Plan 1.png
Train Plan 2.png
Train Plan 3.png

Training Plan Excerpts

Excerpt

Excerpt

Online Training Library
 

A comprehensive library of recorded webinar training and supplemental slide decks was published to The Centers for Medicaid & Medicare Services Enterprise Confluence portal for 24/7 end user access. 

bottom of page