SUMMARY INFORMATION & HANDS-ON EXPERIENCE
- Experienced in architecting and integrating legacy data structures into relational and analytic designs and implementation road maps.
- Experienced in integrating various sources such as flat files, Vsam, etc. into database structure environments such as Oracle, DB2, SQL Server, PostgreSql, MongoDB, Hive, Knowledge GraphQL.
- Experienced in data warehouse, data mart, BI, data vault design / development methodologies and implementation.
- Experienced in Canonical, Conceptual / Logical / Physical Data modeling (ERDs) – ERWIN 20+ years / Power Designer / ER Studio.
- Experienced in leading facilitating JAD sessions.
- Experienced in creation and maintaining DDL / DML / Views / Procedures / Triggers
- Experienced in metadata and business information catalog management.
- Experienced in data profiling and source to target mapping.
- Experienced in developing, updating and documenting data lineage.
- Experienced in updating and maintaining data dictionaries.
- Experienced in Data Vault 2.0 (hub, link, and satellite), Corporate Information Factory, Inmon and Kimball development methodologies.
- Advanced knowledge creating OLTP (normalized 3rd NF) and EDW (normalized 3rd NF (Inmon Centric), dimensional – (Kimball Centric) (Star Schemas, Snowflake designs)) models based on business and technical requirements.
- Experienced in defining and analyzing data requirements, map legacy data stores and formats, source to target mapping, creating.
- Experienced in designing and implementing data access and recording guidelines incorporating PHI and PII HIPAA rules.
- Advanced Privacy-Information Security 503, Records Information Management and General Data Privacy and Information Security Training 502 as related to HIPAA PII – PHI requirements.
- Managed, Designed, developed and implemented 7+ full lifecycle subject area data warehouse / business intelligence environments utilizing the Kimball, Inmon and the Corporate Information Factory methodologies within various database platforms.
- Experienced in implementation multiple change data capture (CDC) approaches depending on the source profile.
METHODOLOGIES / ARCHITECTURES
Experienced in: Relational Design, Dimensional Design, Star schema, Snowflake schema, Logical / Physical modeling, Data Vault 2.0 hub, link, and satellite, Graph Data Modeling, Corporate Information Factory (CIF), Agile and Scrum Methodology, TOGAF, Zachman and RUP framework, Strategic Information Planning Methodology, Service Oriented Architecture (SOA) models.
Experienced in: Relational Design, Dimensional Design, Star schema, Snowflake schema, Logical / Physical modeling, Data Vault 2.0 hub, link, and satellite, Graph Data Modeling, Corporate Information Factory (CIF), Agile and Scrum Methodology, TOGAF, Zachman and RUP framework, Strategic Information Planning Methodology, Service Oriented Architecture (SOA) models.