SKILL SUMMARY

Enterprise Architecture

• Zachman Framework
• DoDAF , TEAF, FEA
• Enterprise Architecture Planning
• Systems migration, Refurbishment and Replacement includes systems and database redesign as needed
• Database consolidation
• Information Flows
• EA Repository
• Metadata Repositories

Data Architecture

• Implementing a data architecture
• Data Modeling both enterprise wide and project specific
• Business conceptual data modeling

• Logical data modeling
• Physical data modeling
• Temporal modeling techniques
• Model Management
• Canonical Data Models
• Data Warehouse Data Marts
• Data Quality
• Data discovery
• Data quality assessment and improvement
• SPC for Data Quality
• Metadata
• Master Data
• Types of databases
• Transactional
• Data Warehouse
• Data Mart
• Operational data store
• Document Management
• Use of Universal Data Models and Data Model Patterns
• DB2, Oracle, SQL-Server

Systems Architecture

• Systems Migration
• Business Workflow
• Business Rules
• Process Modeling
• Metadata
• Situation Analysis

General

• JAD Facilitation
• Requirements Gathering /Analysis
• Project planning
• Presentations to executives, and technical staff
• Presentations at Professional society meetings and conferences
• Coaching and mentoring both management and technical staff
• Training
• Conceptual and Logical Data Modeling
• Time Varying Temporal Database Design Implementation
• SPC for Data Quality
• Information Flows
• Dimensional Modeling
• Tools and Languages
• IBM Rational System Architect
• ERwin / BPwin
• ER Studio
• Over 10 programming languages

PROFESSIONAL EXPERIENCE

Senior Data Modeler For FDA, Imports project, assisting with the development of data models for the agile sprints, and developing a to be data model that harmonizes imports and exports.

Principal Data Architecture Enterprise Architecture Consultant

• For Ace Group Insurance, creating enterprise data architecture policies, guidelines and standards, maintaining and enhancing insurance common data model including master reference data, migration of the Workers Compensation Policy System from mainframe/DB2 to servers/SQL Server, and work with the international group on an underwriting portal.
• For SSA Lockheed , developing data architecture for DCPS Disability Claims Processing System . The architecture includes transaction processing, data warehousing and Management Information. Assisted business analysts with requirements analysis
• For DISA a DoD component , developed DISA data strategy, business requirements for an Enterprise Architecture Repository, and Enterprise architecture for IT Asset Management
• For Schneider National, a major trucking and logistics company developed target state data architecture, identifying and preparing for master data management updated data modeling standards, and helped build the enterprise data model
• Reviewed US Army Data Transformation Plan AIM for net-centric data integration
• Wrote the Enterprise Architecture and Data Architecture sections of several RFPs
• For Aetna STA Group , consulted with Enterprise Information Architecture on their Blueprinting process developed the Information Architecture for the Quoting and Rating.
• For a NOAA/Fisheries AIM , provided IV V for their enterprise architecture
• Reviewer for book proposal on data quality for a publisher
• For CareFirst SM Consulting lead solution architect for the Medicare Advantage product including Pharmacy . Responsible for reviewing and harmonizing all the architectural functions and project cost estimates across 9 teams.
• Assist RRB in writing an RFP for data optimization. Responsibilities include analyzing and building the business function model, vendor scoring, and review of conceptual data model.
• For IBI, Insurance Reporting Foundation
• Responsible for data architecture and data quality for the insurance consulting practice. Business Intelligence system for property casualty, Health, Workers Compensation, Disability Insurance, and Reinsurance for direct insurers, pooling insurers and reinsurers. Platforms supported include DB2, Oracle, and SQL Server.
• Sales support, determining data requirements, and customization
• Reviewed of logical and physical database design for a major financial institution.
• Advised the SSA Lockheed on system and database improvements for a case management system under development. Designed an operational data store to maintain detail and summary information for data from 47 data exchanges for SSA.
• JAD facilitation and participation in the development of the Federal Enterprise Architecture Data Reference Model FEA-DRM Strategy volume
• Worked on the Enterprise Data Modeling integration team for the DoD Business Modernization Management Project, Member of the Data Strategy Working Group/Data Management Board, Developed policies and procedures for master data. Member of the data standardization group for integration of terrorist data, Peer review participant for all DoDAF artifacts
• Developed a methodology for consulting practices in Data Quality, and Information Exchanges How data is exchanged between systems for Pinkerton Consulting
• Developed an enterprise Business Data Model for SEC based on the data collected from over the corporate filings to meet the SEC regulations. The model was based on approximately 36,000 detail data elements that have been grouped into approximately 1100 business information groups.

• Active member and officer of two chapters since 1992.
• Founder, President and VP of Programs - DAMA-Philadelphia
• President, VP of Programs, and VP Membership - DAMA-NCR Washington DC
• Programs Chairman for DAMA International Conference 2000, Metatopia 2004, Metatopia 2006, and program committee member for DAMA International 2005
• Developed and presented seminars on Design and Implementation of Time Varying Databases ' Information Flows as a Tool for Migration to an Enterprise Architecture , Statistical Process Control for Data Quality , Dimensional Modeling , Business and Logical Data Modeling , Business Value of Enterprise Architecture , and Data Retention

• Principal Consultant For FEMA-NPD, advised the directorate on Enterprise and Data Architecture, Member of Data Management Working Group, NIEM Blue Team and Modeling Standards Working Group. For the Dept of Education/FSA Advised the agency on Enterprise Data Management Policy. Data Governance, Data Modeling Standards, Data Classification, Data Quality and data integration projects Completed the development of the Enterprise Conceptual Data Model Developing the Enterprise Logical Data Model Developed a half day seminar on Enterprise Architecture
• Developed and delivered a half day seminar on Enterprise Architecture, 2 hour seminar on the Business Value of Enterprise Architecture and a 1 hour talk on Data Retention
• Developed response to RFPs

Principal Technologist

For HUD, developed information flows between all their systems. performed a data quality assessment of a major system. presented Statistical Process Control for Data Quality. developed a vision for the major components of the data management practice based on Zachman Framework

Principal Enterprise Architect

• For US Customs, developed the Modernization Enterprise Architecture Framework MEAF an extension of the TEAF. Member of the Business Rules Data Quality Working Groups. Developed a methodology and metamodel for using the architectural framework
• For Independence Blue Cross, outside expert for selecting tools for data discovery.
• For Esoterix: plan to migrate a clinical laboratory information system to Oracle
• For Metagenix, member of technical advisory board for data discovery and data quality
• For C S Capital, assessment of companies for venture capital investments

Principal Enterprise Architect

For NJ Medicaid, analyzed the data structures and processes for the existing VSAM based system and developed conversation plan to DB2. Designed the logical data model and physical database, trained and mentored the programmers and DBAs. Developed the strategy and logical data model for the Data Warehouse.

Principal Enterprise Architect

• Designed a data warehouse/data marts for Adelphia Cable and Adelphia Business Systems. Developed policies and procedures for Data Quality, Software Change Management and Data Management. Advisor to senior management.
• Developed user requirements and analyzed data sources for data marts for Bank One. Assessment of match between enterprise data model and data in data warehouse
• Authored business, systems and technology sections for several RFPs.

Vice President Information Technology Services

• For the New York Stock Exchange designed an Operational Data Store to track all trades.
• For Devereaux Foundation. Built the data architecture, workflow and business rules for managing contracts, billing and accounts receivable for a system with over 1500 funding sources. Developed a data model for sentinel events. Developed a Strategic Information Resource Plan to re architect and rebuild data architecture, systems architecture, and technology infrastructure
• Reviewed data architecture, logical data model, and data warehouse design for Zurich/Fidelity and Deposit. Reviewed the design for their CRM to be used by all the companies in their insurance group .

Data Architect

Architectural review of projects including logical data model and physical database designs. Developed plans and implemented Document databases, data quality programs, geographic information systems and work flow systems. Designed and implemented Business Rules engines for underwriting. Developed architectures for Data Warehouses and Data Marts. Worked with IRM to develop an Enterprise Data Model

Principal Architect

• Founding member of the Business Rules Group
• Design review of logical data model and physical database design, enterprise wide
• Developed business data models and logical data models
• Enterprise Architecture Planning
• Work with and presentations to senior and middle management
• Developed and taught courses in Data Modeling , Relational Database Design , Logical and Physical Database Design , Sybase System 10 and SQL Server , and Oracle 7 Application Development .

Senior Consultant

• Developed logical data models and physical database design
• Developed IS Plan for a regional utility company
• Taught courses: Database Design for Oracle Developers , Systems Administration and Transact-SQL for SQL-Server , Logical Database Modeling , Data Process Modeling

Senior Consultant

• Design review of logical data models and physical database design
• Developed conceptual data models, logical data models and physical database design
• Developed data management standards, including data modeling standards
• Technical feasibility study for database migration
• Responsible for developing and teaching public and on-site course DB2: Logical and Physical Database Design . Also taught Chris Date on Relational Database , DB2: Application Design and Development for Performance , and Relational Database Design: The Codd and Date Methodology . Database Design: Relational, Distributed, and Object-Oriented Concepts .