Data Warehouse Architecture Handbook

A Guide to Building and Maintaining Data Warehouse Architectures

About Us

 

Home Course Details Place Order Contact Information

About Ocean Software International, Inc.

Ocean Software International, Inc. is a company that provides high-level expertise in ODS, data warehouse consulting and specific information technology software applications. Ocean Software International, Inc. is a privately held, S-Corporation, founded in 1995 and headquartered in Henderson, Nevada.
 
Ocean Software specializes in providing Information Reporting Expertise by offering products and services that substantially reduce “IT Development" costs. It does this through a combination of data warehousing and Internet techniques. Our collective experience in building custom business applications has led to the development of our first commercial software application product and service.
 
Our expertise is integrating disparate information sources from a wide variety of enterprise-wide data processing systems into our proprietary information repository that is easily accessible with analysis and analytical reporting capabilities.

About the Instructor - Donald R Sallot

Owner of Ocean Software International, Inc., Senior Data Architect / Data Warehouse Information Architect / Designer and developer with diverse experience in IT Management, pre and post sales support, product marketing, customer relationship management, project planning, business analysis, requirements analysis, data analysis, system development life cycle (SDLC), data warehouse, data modeling (relational and dimensional), database design, data acquisition and data integration experience.

Synopsis 

Mr. Sallot has been consulting within the Mortgage Banking, Banking, Savings & Loans, Healthcare, Automotive Manufacturing, Aerospace Manufacturing, Petroleum Exploration and Refining, Retail, Consumer Goods, Distribution, Automotive, Electronics Manufacturing, Communication Services, Government, Entertainment, Food Processing and Utilities arenas for over 20 years.

Short List of Organizations Consulted With

  1. Art Center College of Design - Fine Arts College

  2. EMC – Technology and Mass Storage Device Company

  3. Jennie_O Turkey Store (a Hormel Company) Food Processing and Distribution

  4. Mattel Corporation – Consumer / Entertainment / Manufacturing

  5. Hallmark Cards – Consumer / Entertainment / Manufacturing

  6. BMG – Consumer / Entertainment / Manufacturing

  7. Yellow Trucking - Trucking

  8. Regis Corporation – Consumer / Beauty Products and Services

  9. Price WaterhouseCoopers -  Management Consulting

  10. ProxyMed – Healthcare / Technology and Services

  11. Ryder Systems – Trucking

  12. DEA – Law Enforcement

  13. Florida Power and Light – Utility

  14. Aramco – Saudi Arabia – Petroleum / Manufacturing

  15. MCI – Communications

  16. Security Pacific – Commercial and Consumer Loans / Financial

  17. First Wisconsin National Bank – Retail / Commercial and Consumer Loans / Financial

  18. Puget Sound National Bank – Commercial and Consumer Loans / Financial

  19. First Union National Bank – Commercial and Consumer Loans / Financial

  20. Citibank – Commercial and Consumer Loans / Financial

  21. Home Mortgage – Commercial and Consumer Loans / Financial

Specific domestic and global data warehouse project experience includes:

  1. Sales Analysis and Analytics

  2. POS & Same Store Sales Analysis and Analytics

  3. Cost of Sales Analysis and Analytics

  4. CRM Analysis and Analytics

  5. Order Management Analysis and Analytics

  6. Financial Management Analysis and Analytics

  7. Inventory Management Analysis and Analytics

  8. Procurement & Spend Analysis and Analytics

  9. Receivable and Collections Analysis and Analytics

  10. Forecasting and Planning Analysis and Analytics

  11. WEB Site Traffic Analysis

  12. DEA Drug Seizure Analysis and Analytics

  13. Pharmaceutical Drug Utilization Analysis and Analytics

  14. Utility Utilization Analysis and Analytics

  15. Construction Lending Analysis and Analytics

Specific experience includes:

  1. Defined best practices and coordinating the activities of the various project leads within the Enterprise Data Warehouse projects.
  2. Designed, developed and implemented Data Warehouse Development Methodologies that included step by step activities, milestones, deliverables, guidelines and templates.
  3. Designed, implemented and performed source to target mapping (Source to Stage, Stage to Data Warehouse and Data Warehouse to Data Mart).
  4. Overall project management of various IT and data warehouse development initiatives.
  5. Developed and implemented Global currency and data sourcing timing architectures.
  6. Established and managed Scoping and Business Requirements gathering methodologies and deliverables.
  7. Designed and implemented multiple data marts (independent data marts) into consolidated data warehouse.
  8. Architected, designed and implemented multiple Global Data Warehouses.
  9. Developed and implemented overall ETL data acquisition and data delivery strategies.
  10. Developed and implemented data warehouse and data mart modeling methods and practices.
  11. Defined data sourcing architectures for FTP receipts, XML files, flat files, DB2, Redbrick, Teradata, AS400 UDB, SQL Server and Oracle.
  12. Established and implemented data staging architectures to handle like subject areas from different sources, multiple days, dirty data and reconciliation.
  13. Established and implemented data warehousing loading methodologies.
  14. Designed and implemented multiple incremental data warehouse techniques and methods.

Modeling Related Information

  1. Over 20 years of both logical and physical data modeling utilizing ADW, ERWIN, and ER Studio. Significant experience using ERWIN 3.5.2 / Model Mart and ER Studio / Repository.
  2. Highly experienced in utilizing Unified Modeling Language (UML).
  3. Significant logical / physical relational / multi-dimensional design (star schema) and modeling experience within Oracle 8i – 9i – 10g, SQL Server, DB2, AS400 DBU and Teradata environments. Experience includes using SQL within the related database platform.
  4. Excellent knowledge of Oracle Financials 11i (GL, AR, AP, PO, FA, Project, HR, etc) modules and metadata.
  5. Heavy involvement in data administration and metadata capture and documentation.
  6. Significant experience in analyzing data quality and communicating areas of concern.
  7. Significant experience in developing source to stage, stage to DW, DW to DM mapping for ETL development.