Re-usable Patterns and Universal Data Models For Financial Data Course Outline

3 Day Course (can be customized for your organization’s specific needs.)

DAY 1

  1. Introduction to Universal Data Models(UDM)
    • What are Universal Data Models?
    • What is UDM not?
    • What are the benefits?
    • Examples of how other organizations have used UDM
    • How to apply Universal Data Models

  2. The following sections include modeling techniques, pitfalls, “war stories” of incorrect modeling, and “best practice” techniques. Each section also includes a workshop in which you customize models for your organization.

  3. Patterns within Universal Data Models
    • Roles
    • Statuses
    • Categorizations
    • Hierarchies/recursions
    • Type versus instance
    • Rules
    • Applying each of the patterns to your organization (after each pattern there will be an exercise applying the pattern)
  4. Financial Services Related People and Organization Data Models
    • Parties in the financial services industry
    • Organizations
    • People
    • Parties
    • Roles
    • Relationships between parties
    • Addresses and other contact management information
    • Data modeling exercise – applying the models to your organization

DAY 2

  1. Financial Services Objectives, Needs and Plans
    • Financial services objectives
    • Financial services needs
    • >
    • Financial services plans
    • Data modeling exercise – applying the models to your organization
  2. Financial Services Product Data Models
    • Product definition
    • Financial services products and categories
    • Financial services product features
    • Financial services product rules
    • Data modeling exercise – applying the models to your organization
  3. Financial Services Product Regulations
    • Product rules and regulations
    • Data modeling exercise – applying the models to your organization
  4. Financial Services Agreements
    • Loan agreements
    • Terms
    • Buy outs of loans
    • Payment schedules
    • Data modeling exercise – applying the models to your organization
  5. Financial Services Accounts
    • Accounts
    • Accounts types and statuses
    • Account roles
    • Data modeling exercise – applying the models to your organization

DAY 3

  1. Financial Services Account Notifications, Invoices and Payments (1 hour)
    • Statements and account notifications
    • Invoices
    • Payments
    • Data modeling exercise – applying the models to your organization
  2. Financial Services Account Risk Analysis
    • Assessing loan risks
    • Parameters and measures
    • Data modeling exercise – applying the models to your organization
  3. Progressing from the UDM to Physical design and to the Data Warehouse and Data Marts
    • Data warehouse architecture considerations
    • Physical database design considerations
    • Transformation steps to converting the UDM to a data warehouse design
    • Workshop Exercise Enhancing an Existing Data Warehouse Designs
    • Data mart method—a practical approach to designing data marts
    • Examples data mart designs using universal data models
  4. Course conclusion (1/2 hour)
    • Possible objections to UDMs and responses
    • Universal principles in effectively integrated data
  5.