SUMMARY

• Over 15 years of professional experience in Enterprise Data Warehouse architecture, Enterprise Business Intelligence architecture, design and deployment experience using industry best practices and a broad knowledge of Database Systems, and Master data management.
• Experience working with MS SQL Server, Oracle 11g, Teradata, Netezza.
• 15 years of experience in building OLTP, ODS, Enterprise Data Warehouses and Data Marts.
• Comprehensive scalable Data Architecture definitions utilizing, Kimball, Inmon and hybrid methodologies
• 15 years of IT experience in Requirements Gathering, Data Mining and Analysis, Data Modelling, Business Analysis, Technical Designing, Software Development, Testing Components, Implementation activities, Support activities and mentoring team members.

TECHNICAL SKILLS

Design: Enterprise Data Warehouse Design, Operational Data Store Design, Data Mart Design, Metadata Management

Databases: Oracle, MS SQL Server, IBM DB2, ADABAS, MySQL, Sybase, Teradata, Netezza, Cassandra

Modeling Tools: Erwin v1.0 through r9/Model Manager, ERStudio Data Architect v17, Infosphere Data Architect, Rational Rose, PowerDesigner v16.6, Hackolade v2.5.2

MDM Tools: IBM Infosphere Suite of tools, Informatica Metadata Manager

ETL Tools: Informatica, Datastage (I am not a programmer although I do have programming skills)

BI Tools: Cognos 10 & 11, Microstrategy, Business Objects

Query Tools: QMF, SQL Server Management Studio, Aquadata, Aginity Workbench, Toad

Languages/Methodologies: C++, C#, UML, Kimball, Inmon, Hybrid, Hub and Spoke Architecture

General/Platform & Server: Windows, Macintosh, Keenen, Daleen, Peoplesoft HR, CISCO Contact Manager, ARTS v5.0, Oracle Financials, IBM Unified Data Model for Healthcare v9.1

Data Governance: Infosphere Information Governance Catalog (IGC)

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Analyzed current state architecture which included all systems (31) within the Community Care product line including cloud - based systems and sub-product lines, as well as, their component/subsystems
• Analyzed system interfaces and High-Level Integration Diagrams (HLIDs)
• Created data flow diagrams based on the HLIDs while communicating with the stake holders about Gap analysis findings
• Created Data Management artifacts such as: Data Lifecycle Diagrams, Data Migration Diagrams and Data Flow Diagrams/Information while working on the Data Governance Framework
• Investigated, designed and created documents including Operating Framework, Data Governance (DG) Communications Plan, DG Readiness Plan, Data Quality Policy, Data Security Policy, Disaster Recovery Policy, Data Retention Policy and the creation of a Master Data Glossary
• Ensured that policies and framework were in alignment with the VA, VHA, Federal and State Mandates, and best practices
• Created a GAP Analysis of systems that were missing information
• Created a Metadata Analysis to show which systems were missing the ‘Metadata/Data Dictionary’
• Socialized the Data Governance framework and policies to the business

Confidential, Southlake, TX

Enterprise Data Architect

Responsibilities:

• Used Agile process to deploy three websites
• Designed the OLTP database for each website
• Created complete documentation for production support for each websites
• Coordinated design requirements with developers
• Provided traceability from requirements through implementation
• Utilized a home grown ticketing system to repair defects found in each website
• Design tasks included Data Modeling and DDL generation (Erwin) for MySQL
• Some PHP development to include members of the websites to view each other’s profile data
• Search Engine Optimization (SEO) including identification of keywords and creating back links to the websites.

Confidential, Ft. Worth, TX

Enterprise Data Architect

Responsibilities:

• Used the Agile process to deploy Program Management Application systems
• Met with development teams to understand and document requirements
• Translated business requirements into technical design specifications
• Provided traceability from user requirement to deployment task
• Utilized the Remedy Ticket system for data base Trouble Ticketing
• Design tasks including Data Modeling and DDL generation for DB2 Mid-Tier, DB2 Mainframe, Teradata and SQL Server databases
• Modeled XML Events, Kafka Topics & Events and generated .XSD event files
• Utilized and modeled JSON Draft version4 NoSQL Schema and Events
• Responsible for OLTP Modeling of Rail Yard Entry/Exit NoSQL Events including:
• Switching Events
• Derail Event
• Route Configuration
• Signaling
• Device Management
• UI (User Interface) Events
• Responsible for Data Governance including:
• Naming Standards
• Name Definitions
• Domain Categorization
• Name and Domain Publishing to IGC (Infosphere Governance Catalog)

Confidential, Arlington, TX

Data Warehouse Data Architect

Responsibilities:

• Leveraged the Agile process to deploy Program Management Portal reporting system and releases
• Met with business stakeholders to understand and document requirements
• Translated business requirements into technical design specifications
• Provided traceability from user requirement to deployment task
• Evaluated, debugged and optimized Cognos SQL for developers
• Projected scoping for multiple projects
• Nursing Dashboard: which brings together several Datamarts including Survey data, Industry Comparative Data and Reliability Learning Data (i.e. Injury and accident tracking system)
• PressGany Survey Datamart
• Hospital Operations Innovation Datamart
• Peoplesoft Employee Datamart
• Development tasks including the Data Model, design, DDL table definition
• Development of DML to Support a variety of maintenance tables
• Data Migration tasks and script development for table migration through all environments
• Aquadata Studio
• IBM Data Architect
• IBM Designer Client (Datastage)
• IBM Director Client (Datastage)
• IBM FastTrack: Source to Target Data Mapping for ETL Development
• Netezza (Data Warehouse and IBM industry Standard Healthcare Model)
• SQL Server (EPSi, RL Database, Peoplesoft, PeopleFluent, General Ledger)
• IBM industry standard Healthcare Model (3rd Normal Form)
• Inmon and Kimball hybrid design
• Experience in Requirements Gathering, Data Mining, Profiling, Data Modeling, Business Analysis, Technical Design, Software Development, Testing Components, Implementation activities, and Support activities
• Lead multiple projects on all phases of database and data warehouse development and BI reporting, from gathering business requirements, data model design and implementation, application testing and support, enterprise reporting solutions
• Performed Proof of Concept on replacing Infosphere Data Architect to provide a more strategic direction of THR

Confidential, Westlake, TX

Data Architect

Responsibilities:

• Designed stage environments on DB2, Oracle, SQL Server, MySQL and Teradata.
• Designed ETL logic for data aggregation and performed source to target mapping for the various stage environments.
• Provided code review for existing ETL/BI applications architecture, ETL process, SLA requirements & data integration issues.
• Review EDW architecture for various business Data Marts and corresponding EDW applications.
• Technical lead for migrating DB2 EDW data warehouse into Teradata. Review Logical Data Model and Physical Data Model.
• Identify various modeling issues and provided fixes on the Physical Data Model layer. Worked with the ETL team to fork-lift all DB2 EDW data into Teradata.
• Designed and delivered an Oracle OLTP Single Source of Truth Order Management system used in the calculation of tax included closing costs.
• Re-engineered production modeling standards and data archiving strategies

Confidential, Ft. Worth, TX

Senior Data Architect

Responsibilities:

• This included the creation of data naming, and modeling standards, metadata maintenance and reporting.
• This project utilized the Kimball methodology of star schema, dimensional modeling to represent credit card insurance transactions.

Confidential, Dallas, TX

Senior Data Architect

Responsibilities:

• Re-Engineered Confidential ’s Enterprise Information Flow by system into a more organized and understandable representation of the company.
• Designed and implemented a Master Data Management (MDM) system for enterprise vendor suppliers.
• The MDM project was based on the integration of corporate vendor data into an industry standard retail data model known as ARTS (Association for Retail Technology Standards).

Confidential, Dallas, TX

Senior Data Architect

Responsibilities:

• This architecture incorporated 4 Operational Data Sources.
• Data Modeling included conceptual, logical, and physical design, the design and implementation of an efficient surrogate key cross reference schema supporting slowly changing dimensions; the development of pseudo code for all ETL processing, the creation of multiple OLAP cubes for utilization by the various Claims and Premium processing departments, and the bid subject area whereby business is won.
• The ARS Data Warehouse consisted of 36 entities, 11 Fact Tables and 25 Dimensions 3 of which were Snow Flaked.

Confidential, Lewisville, TX

Director of Information Systems / Data Architect / Data Modeler

Responsibilities:

• Responsible for six Operational Data Sources.
• Models included conceptual, logical and physical data architecture, customer event correlation and data capture, identification of cross-functional dependencies in billing, CRM, Order Management, Middle-ware publish/subscribe data identification, Reporting, and Data Warehousing.