SUMMARY:

• 15+ years Hands - on, quality practiced Conceptual, Logical, and Physical Data Modeling
• 15+ years Hands-on with ERwin, BPwin, MS Office Suite (Outlook, Word, Excel, PowerPoint, Access)
• 15+ years 3NF Relational Modeling, Entity-Relationship Modeling
• 15+ years ANSI SPARC Three-Schema Architecture
• 15+ years Continual Quality Improvement (CQI)
• 15+ years Data Warehousing: Relational, Dimensional, Temporal, Bi-temporal, Business Intelligence (BI)
• 15+ years Databases: SQL Server, Greenplum, Teradata, DB2, Oracle, Sybase, Focus, SAS, Datacom
• 15+ years Enterprise Data Modeling, Project Data Modeling
• 15+ years Enterprise Process Modeling, Project Process Modeling
• 15+ years IDEF0 (US DoD, NIST FIPS, IEEE)
• 15+ years IDEF1X (US DoD, NIST FIPS, IEEE)
• 15+ years other Hands-on: T-SQL, SQL, Power Designer, ER/Studio, Web Focus, SAS
• 15+ years Statistical Process Control (SPC) guiding Root Cause Analyses
• 15+ years Systems Thinking
• 15+ years Zachman System Architecture Framework

PROFESSIONAL EXPERIENCE:

PRESIDENT AND PRINCIPAL CONSULTANT

Confidential, Atlanta, GA

Responsibilities:

• Quality requires commitment to a way of life
• Information connects people for the betterment of life, work, and play
• Solutions require paradigms for managing enterprise structures and behaviors both holistically and analytically
• MISSION
• To help clients realize Quality Leadership, Management, Operations, and Sustainment ( Confidential ™) through pragmatic modeling of enterprise structure as data and enterprise behaviors as processes

Confidential, Columbus, GA

SENIOR CONSULTANT/DATA MODELER/BI

Responsibilities:

• Took initiative to research and become informed by Synovus Annual Report and Basel Committee on Banking Supervision ( Confidential ), in particular Confidential 239 and Confidential 268; proposed adopting them as BI touchstones
• Took initiative to build and present in PowerPoint a BI strategy spanning from data intake from various source systems, to data quality assessment and improvement, to data integration into Enterprise Data Warehouse EDW, and to servicing BI demand from Data Marts
• Hands-on mapping and modeling intake of existing independent Data Mart tables into EDW based on the IBM Banking and Financial Markets Data Warehouse Model (BFMDWM, BDW)
• Advised that business rules hidden and implied in de-normalized Data Mart tables will and must become explicit in the normalized relational IBM BFMDWM, BDW
• Extend IBM BFMDWM, BDW data model as necessary without compromising its structure
• Introduce and advise offshore ETL technicians on data modeling methods and semantics
• Advised, conceived, and hands-on designed and developed relational Time Series Data Store in SQL Server 2012 RDBMS and automated data pivot connectivity to automated construction of presentation-ready Executive Level Business Report graphics in Microsoft Excel
• Took initiative to author and propose the beginnings of an extensible Third Normal Form (3NF) Synovus Enterprise Data Model (EDM) that effectively rivals the IBM BFMDWM data model in normalization quality of Synovus business rules
• Exercised prescience from Systems Thinking knowledge to counsel BI Director that creating IT-driven BI demand on the business side to justify pursuing “quick hits” and “low hanging fruit” absent sufficiently developed BI capability to service the demand will drive BI capability down to a low-level stasis of economic value-add; prescience has been greatly realized

Confidential, Atlanta, GA

CONSULTANT/DATA MODELER/BI

Responsibilities:

• Hands-on authored and advised Enterprise Business Architecture covering from Data Sources, to source data ingestion quality, to holistic Enterprise Data Architecture, to Enterprise Applications Architecture, to data products & sales, to Data Customers
• Advised senior management and architects in adopting disciplined data management practice to result in a Commercial Enterprise Data Repository based on a Conceptual Enterprise Data Model
• Hands-on authored Data Model Reading 101 presentation; instructed Senior IT Architects and non-technical business people in reading and critiquing a data model
• Hands-on developed, kept, promoted ERwin data naming standards
• Successfully reverse-engineered and exposed US Commercial Database (Greenplum DDL) as a physical data model; innovated to impose a fully integrated view of extremely disparate, semantically ambiguous, un-relatable physical tables
• Successfully reverse-engineered and exposed Commercial Database (AS/400 DDS) as fully integrated physical and logical data models in 3NF and better.
• By invitation, lead Canada IT to recognize various data model value propositions for business beyond database design
• Hands-on authored a SWOT (Strengths, Weaknesses, Opportunities, Treats) analysis of both US Commercial Database and Canada Commercial Database for assessing and comparing data management practices that produced the databases
• Conducted data profiling, data quality assessments via SQL queries; devised temporal join technique from data discovery

Confidential, Charlotte, NC

EDW DATA ARCHITECT/LEAD DATA MODELER

Responsibilities:

• Hands-on authored in MS PowerPoint a temporal Enterprise Data Warehouse (EDW) Architecture Recommendation congruent with Confidential manufacturing process, from raw materials to finished goods by control of manufacturing business rules
• Hands-on authored in ERwin an IT-agnostic Conceptual Data Model (CDM) of the business to encompass material cost analyses requirements expressed in data modeling sessions with business subject matter expert (SME)
• Analyze data architecture and data values in two different manufacturing plant-specific MAPICS ERP installations running on MS SQL Server RDBMS, facilitated by using WebFocus via Open Database Connectivity (ODBC)
• Hands-on authored mappings from MAPICS ERP data tables to EDW Staging tables for ETL source-to-staging implementation
• Convert IT department’s manually applied logical-to-physical naming standards to an ERwin Naming Standards File for automatic application of logical-to-physical naming standards from the file
• Advise on limitations and unintended consequences from quick-fix, non-business oriented, OLTP-styled EDW architecture

Confidential, Cincinnati, OH

CONSULTANT, SENIOR DATA MODELER

Responsibilities:

• Facilitate adopting enterprise data modeling practices to gain optimal quality-time-cost utilization of Teradata RDBMS
• Discover, advise, advocate closing significant model Quality gaps between logical data models and physical data models
• Advise senior IT management on benefits of Aviation Enterprise Data Warehouse (AEDW) in Teradata being enterprise-level
• Reverse-engineer project-level AEDW Master (MDM) to propose holistic enterprise-level design to improve data quality
• Propose conducting business-oriented data modeling to improve responsiveness to business’ information demands
• Advise on use of Teradata Manufacturing Logical Data Model (MLDM) vis-à-vis Enterprise Conceptual Data Model (CDM)
• Discover, advise, advocate adoption of aviation industry standard taxonomies for aircraft and aircraft engines

Confidential, Alpharetta, GA

DATA ARCHITECT

Responsibilities:

• Devise project-specific design solution data models for implementation in an Object-Oriented (OO) style
• Plan, coordinate, and engage globally dispersed business subject matter experts (SMEs) in authoring a unified Services Obligation logical data model

Confidential, Dublin, OH

CONSULTANT, ENTERPRISE DATA MODELER

Responsibilities:

• Leader conducting front-office authoring of a rigorous, well-defined, fully integrated, holistic, extensible Enterprise Conceptual Data Model ( Confidential ) for Medical Business Transformation (MBT) to serve strategic and tactical business process improvement planning including to drive Data Warehousing
• Established “Zachman Framework” with IT top management for bounding Confidential to business semantics modeling
• Leveraged Teradata M-LDM (MLDM) to hands-on author initial, quick-start Confidential
• Hands-on authored Data Model Reading 101 presentation; instructed business executives and others in reading and critiquing the Confidential
• Engaged MBT executive and senior business process leaders in dialogue to continually evolve the Confidential, holistically
• Presented Confidential to Information Advisory Council, gaining buy-in
• Presented Confidential to CIO and CIO’s leadership team, gaining buy-in and direction beyond that originally envisioned
• Socialized Confidential as a “Business Model” as opposed to any manner of IT “Enterprise Architecture” design or model
• Lead senior IT staff in mapping Confidential Business Entities and Rules to MBT future-state applications to facilitate discovering data entity gaps, inter-application data relationships, data redundancies, and other data Quality improvement opportunities
• Identified root causes of poor quality information delivery from implementations of Dimensional Models and Star Schemas

Confidential, OH

CONSULTANT, DATA MODELING

Responsibilities:

• Logistics, Installations, and Mission Support - Enterprise View (LIMS-EV)
• Performs Enterprise Data Warehouse (EDW) architecture data modeling for various LIMS-EV initiatives
• Authors Third Normal Form (3NF) LDM and PDM for higher Quality data management using Teradata RDBMS for EDW
• Proactive to architect ETL into 3NF base layer then to ETL into Dimensional data mart layer for presentation layer
• Coached Data Modeling Team member on presenting and reviewing data models with non-technical business audience
• Created a concordance to help correct, expand, and improve data naming standards Quality
• Finds, researches, and brings into play various USAF business and technical sources that define enterprise semantics and architecture (e.g., The United States Air Force Dictionary, DoDAF, AFMAN 23-110, AFEMS, SBSS, DoDD 8320.1-M, others)
• Incites critical review of data modeling standards to advance effective data modeling practice over rote usage of tools
• Re-model certain EDW “flat file” tables to expose core business rules and semantics in Third Normal Form (3NF)
• Reverse-engineer Teradata EDW DDL to expose current PDM, LDM, and to create “Concept” Data Model
• Surfaces and brings ambiguity about RDBMS practice into alignment with business reality

Confidential, Cleveland, OH

CONSULTANT, DATA MODELING

Responsibilities:

• Incite IT culture change supportive of improved data modeling Quality and enterprise data warehouse (EDW) Quality
• Introduced IDEF1X (in ERwin) compared to IE (in Power Designer) for authoring higher Quality data models
• Hands-on authored Credit Risk entity-relationship model extendable to Enterprise Risk Management (ERM)
• Vetted and advised on IBM Banking Data Warehouse (BDW) Model Quality as to business clarity and normalization
• Prompted due diligence by instigating a Teradata Financial Services Logical Data Model (FS-LDM) review
• Advised on disparate data silos to arise from changing IBM BDW Model to fit ETL “scattershot” mappings
• Advised on poor information Quality to arise from ETL snapshot architecture that includes temporal credit score data

Confidential

CONSULTANT, DATA MODELING

Responsibilities:

• Engaged short-term to conduct Discovery-phase data modeling for Incentive Commission Program
• Facilitated source data definition sessions with both business and technical subject matter experts
• Synthesized data semantics and structures from disparate data definitions in mainframe Focus and DB2
• Mapped data discovery findings to the Teradata Travel Hospitality Logical Data Model (T-LDM, TLDM)
• Collaborated with business analyst conducting process requirements discovery
• Level set both business and technical staffs on reading and reviewing data models for business-centric semantics
• Delivered conceptual data model and lesser concept diagram reflecting data and process requirements findings
• Advised on Quality improvement opportunities regarding TLDM normalization and airline industry representations

Confidential, Auburn Hills, MI

CONSULTANT, DATA GOVERNANCE

Responsibilities:

• Delivered essential data principles and guidance to Enterprise Data Warehouse (EDW) project
• Exposed top IS executives to the key reality of Enterprise Data Warehouse being “a component of Enterprise Memory”
• Delivered to executive management, project management, and a Big X-involved technology firm a DG definition aligned to corporate vision with balanced focus on “data as a corporate asset,” data Quality, and data security
• Proposed Servant-Leadership, Appreciative Inquiry, and Continual Quality Improvement as essential to DG practice for highly effective management of social system dynamics generally irreducible to mechanistic project plan tasks
• Surfaced and advised on project course correction needed to align with corporate information protection policy and standards applicable to HR, Finance, and all other lines of business and functional areas
• Repositioned staff understanding of types of metadata in reality terms rather than in arbitrary technical terms

Confidential, Columbus, GA

CONSULTANT, DATA QUALITY

Responsibilities:

• Letter of Recommendation (unsolicited)
• Presented to senior and executive management progressive thought leadership on establishing Data Governance (DG) in the style of Continual Quality Improvement (CQI) to support the customer information strategy
• Hands-on authored DG purpose statement, manifesto, and information architecture aligned to Aflac mission statement
• Facilitated and rationalized a DG process definition, and repositioned the DG process a Big X consultancy misrepresented
• Applied statistical process control to profile data Quality, to profile data capture process Quality, and to represent to IT a business unit’s project aim to reduce weekly average returned mail volume to 0.25 percent from 2.37 percent
• Initiated collaborative authoring of Aflac Enterprise Glossary of Terms, a data dictionary
• Mentored FTE Senior Business Analysts for transitioning into Data Quality Team member roles
• Derived physical data models from DB2 SQL/DDL scripts to discover data Quality improvement opportunities
• Identified and proposed Quality improvement opportunity to save $3.9 million annually in costs from carrying poor Quality data
• Exposed Senior Data Architect and DBA Senior Manager to fragments of data architecture that better fit Aflac business realities

Confidential, Atlanta, GA

HUMAN RESOURCES MANAGEMENT PROCESS MODELER

Responsibilities:

• Hands-on authored enterprise-wide business process model ( Confidential ) of Confidential Human Resources Management (HRM) function Hands-on authored model top-down, from corporate strategy; bottom-up, from techno-centric artifacts
• Exposed HR causal value chain that delivers corporate strategy execution in the retail stores and throughout Confidential
• Influenced techno-centric initiatives involving PeopleSoft, SAP, and Confidential to improve customer satisfaction, business planning, project management, data modeling, process simulation, others

Confidential, Atlanta, GA

DATA WAREHOUSE FUNCTIONAL ARCHITECT

Responsibilities:

• Interacted with LOB to gather and hands-on authored functional reporting requirements for Enterprise Data Warehouse
• Hands-on authored functional requirements for development by technical architects using MicroStrategy and Informatica
• Remodeled the Sybase Master Customer Database physical data model to expose semantic strengths and weaknesses and to correlate with Master Customer Database Data Dictionary
• Assessed Siebel Data Model for Industry Applications for compatibility with Master Customer Database data model. Planned and facilitated peer reviews in the style of IDEF practice
• Resulting functional requirements quality earned “Ed gets it ”—LOB praise that had previously escaped Confidential
• Earned trust enough to represent LOB’s voice vis-à-vis defect-free application producing useless output, as the state of practice was that defect free Quality obviates fitness-for-use Quality
• Interacted with BellSouth CIO Prime Integrator to hands-on author project functional requirements for Confidential ’s Enterprise Data Warehouse Operations Migration to the EDS environment that innovatively included an SPC data analysis of Confidential ’s Enterprise Data Warehouse Operations vis-à-vis job failures

Confidential, St. Louis, MO

SENIOR CONSULTANT-METADATA ARCHITECTURE

Responsibilities:

• As peer subcontractor with both Confidential and a metadata tool vendor, participated in project to demonstrate value-add from enterprise information integration (EII) at the metadata level
• Conducted discussion with customer to draw out and articulate overarching requirements for the sake of clarity of project vision and improved alignment with customer’s expectations
• Synthesized customer expectations and all overarching requirements into a Unified Metadata Architecture
• Studied vendor’s metadata tool’s suitability for building the Unified Metadata Architecture
• Hands-on authored guiding principles for building the Unified Metadata Architecture using the vendor’s metadata tool versus using a relational database management system (RDBMS)
• Responsible for influencing metadata tool vendor’s senior technical lead to address all customer requirements
• Responsible for an Confidential staffer’s Quality of documentation authorship

Confidential, Chattanooga, TN

ENTERPRISE ARCHITECTURE CONSULTANT

Responsibilities:

• With Corporate Human Resources executive leadership and senior managers as reviewers and 20 HR Assistants as subject matter experts, Hands-on authored model of HR enterprise process architecture for hiring employees (Quality of model prompted powerful insight, unanticipated, and HR executive leadership to implement a "New Employee" hiring process)
• Presented often to senior non-IT managers to influence acceptance of IDEFs for modeling enterprise architecture
• Reverse-engineered and vetted the business normalization Quality of a vendor’s application data model deemed potentially suitable to meet asset configuration management requirements for restarting a nuclear power generator
• Developed and gave numerous IDEF for Enterprise Architecture modeling presentations to non-IT managers, especially ones in Human Resources, Organization Development, River System Operations, Power Generation, and serving on the TVA-wide Business Process Analysis Peer Team
• Mentored new IS Methods and Tools team to firstly adopt standard methods, IDEF0 and IDEF1X, and secondly adopt tools that implement the methods, BPwin and ERwin. Advised on data flow diagrams, Unified Modeling Language (UML), Use Cases, and Visio vis-à-vis The Zachman Framework for Enterprise Architecture
• Coached Senior Data Architects and Senior Business Analysts in modeling Enterprise Business Architecture by using IDEF0, in BPwin, and IDEF1X, in ERwin, and converting data flow diagrams to business process models
• Advocated for and mentored developers of "model Quality checklists"
• Re-architected extremely complex Enterprise Maintenance Planning and Control (EMPAC) Oracle database to conceptual architecture models researchable through a user-friendly HTML portal