We provide IT Staff Augmentation Services!

Sr. Data Architect / Data Warehouse Lead Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • An innovative senior - level information technology hands-on leader with a track record of successfully facilitating, directing, managing and improving information architectures utilizing agile / scrum iterative incremental development methodologies.
  • Over 20 years of experience in Enterprise Data Modelling and skilled in Conceptual / Logical / Physical Data modeling (ERDs - Erwin 7.3.11 - 8.2 - 9.6 , ER Studio, Power Designer).
  • Have a solid understanding of business strategy and the ability to conceive and implement the technology roadmap needed to drive that strategy. Over 20 years of utilizing iterative incremental development methodologies.
  • Successfully designed, developed and implemented 8+ full lifecycle subject area data warehouse / business intelligence environments utilizing the Agile, Kimball, Inmon and the Corporate Information Factory development methodologies within various database platforms including significant experience in using agile iterative and incremental development methodology and team building.
  • As an Enterprise Data Architect required me to also define, implement and support Data Governance data driven initiatives due to the nature of data being access by various organizations and entities that included healthcare, banking, financial and education business sectors.
  • Confidential Association: As a leader, Architected and implemented multi-terabyte data warehouse / data hub from legacy sources supporting claims, payment, medical coding, i.e. ICD9, ICD10, CPT, HCPCS, Party, Party Roles, Providers, Membership, Diagnosis, etc. in support of their enterprise DW / BI analytic reporting in support of their MDM initiative.
  • ProxyMed: As a leader (EVP R&D), Pioneered and architected electronic prescription network allowing physician’s scripts to be pushed to receiving pharmacies working with the executive team. Reported to the CEO. Gathered data requirements from executive staff as in developing both AS-IS and To-Be state.
  • Mattel: Architected and implemented multi-terabyte global (45 global companies) data warehouse / data hub supporting order processing, sales, logistics, order fill and accounts receivable in support of enterprise business analytic reporting. Gathered data requirements from VP / director level staff as in developing both AS-IS and Future state in support of their MDM initiative.
  • PMSI (Pharmacy Benefit Management): As a leader, architected and implemented clinical database structures working with Pharm Ds and Physicians to evaluate medication / procedure outcomes supporting USPS, Pharmacy transaction data feeds. Gathered data requirements from PHARM-D executive staff as in developing To-Be state.
  • Regis Corporation: As a leader, Architected and implemented multi-terabyte global (10,000 salons) data warehouse / data hub in support of POS business analytic reporting in support of their MDM initiative. Gathered data requirements from executive staff as in developing both AS-IS and To-Be state in support of their global data repository.
  • Avant Assessment: As a leader, (reported to CEO and Executive Board) Architected a data driven web based multi-language assessment application system for the US Government Agencies and K-16 testing working with the executive team in developing both AS-IS and To-Be state of global language testing. Also, CTO reporting to the CEO establishing both tactical and strategic data management and design policies working with the executive team.
  • Ferguson: As a leader, Architected and implemented their BI (business Intelligence) global solution from their legacy UNI-BASIC legacy system into an Oracle / Netezza / Cognos environment.
  • Workers Comp: As a leader, Architected and implemented their DW / BI (business Intelligence) solution from their legacy systems into a DW / BI Oracle / Business Objects environment.
  • OMRF - Oklahoma Medical Research Foundation - Database / Data Engineer
  • Experienced in architecting and integrating legacy data structures into relational and analytic designs and implementation road maps.
  • Experienced in data warehouse, data mart, BI, data vault design / development methodologies and implementation.
  • Experienced in implementing DLP (Data Loss Prevention) processes and solutions within enterprise data / information architecture design considerations.
  • Experienced in integrating data architecture patterns in support of data governance, security and metadata management.
  • Experienced in integrating and documenting data classification processes in support of data governance that includes data lineage.
  • Experienced in Conceptual / Logical / Physical Data modeling (ERDs - ERWIN, ER Studio, Power Designer).
  • Experienced in creation and maintaining DDL / DML / Views / Procedures / Triggers
  • Experienced in Corporate Information Factory and Kimball data warehouse designs.
  • Advanced knowledge of applying data architecture patterns, including creating OLTP (normalized) and EDW (dimensional) models based on business and technical requirements.
  • Experienced in defining and analyzing data requirements, map legacy data stores and formats, source to target mapping, create new data structures / micro formats and perform architectural alignment with enterprise formats.
  • Experienced with medical codification, i.e. ICD9, ICD10, CPT, HCPCS, ACGs.
  • 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

TECHNICAL SKILLS

Data Modeling Tools: Erwin 7.3.11 - 8.2 - 9.6 , ER Studio, Power Designer, (Both Forward and Reverse Engineering), Aqua Data Studio 5.5.2, Sparx Enterprise Architect, Conceptual, Logical and Physical Data Modeling, MongoDB JSON Modeling

Data Warehouse / ETL Tools: IBM InfoSphere DataStage 8.1, 9.1, 11.x SSIS, PL / SQL, RDBMS / File Management Structures, Netezza Data Warehouse Appliance, Aginity Netezza Workbench, Teradata, Oracle 11g/10g/9i/8.x, MongoDB, MS SQL Server2005, 2008 R2, 2012, 2014 DB2, VSAM, IMS/DB, PostgreSQL., Azure SQL Data Warehouse Objects (Data Factory, SQL Server Integration Services, etc.), Cosmos DB, Azure Big Data Using HDInsight Hadoop

Development Tools: PL/SQL, SQL Navigator, TOAD, T-SQL

Reporting Tools: Power BI, PowerPivot, DAX, Cognos 10.x, Crystal Reports, SSRS, SSAS, Tableau, Business Objects 4.0, xi R2/R3, Spotfire, Power BI, Tableau

Methodologies / Architectures: Experienced in: Relational Design, Dimensional Design, Star schema, Snowflake schema, Logical / Physical modeling, Data Vault 2.0, 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.

Data Hub / ODS Implementation: 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.

ERP: Oracle Financials and Manufacturing, PeopleSoft, JD Edwards

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Architect / Data Warehouse Lead

Responsibilities:

  • Short term assignment to implement change data capture (CDC) from Confidential ’s financial transaction management operational application into their ODS and into their ELZ-Hadoop eco-system including data governance, security and metadata management.
  • Perform data profiling, documenting source data, data flow, documenting load process into both the DB2 ODS and ELZ (Hadoop) environments and managing metadata.

Environment: consists of Erwin Data Modeler, Cognos 11.x, Database systems include Hadoop (Hive, etc), Oracle and DB2 environments.

Confidential

Enterprise Data Modeler / Architect (Data Warehouse)

Responsibilities:

  • Responsible for the creation of the ERD (Conceptual Logical and Physical) designs utilizing both data warehouse and multi-dimensional / start schema modeling
  • Responsible for the staging, data warehouse and data mart designs and mappings
  • Responsible for the architecture, design and implementation of the Business Intelligence project
  • Responsible for DDL creation and applying to the Netezza Data Warehouse Appliance development environment including performance tuning
  • Responsible for MongoDB JSON modeling and mapping

Environment: consists of Cognos 10.x, IBM InfoSphere DataStage 8.1, 9.1, etc., ERwin. Database systems include MongoDB, Netezza 7.x, PureData System / Aginity Workbench, Oracle 11G - 12C, SQL Server 2014, Microsoft Azure SQL Database

Confidential

Sr. Data Warehouse / Enterprise Architect

Responsibilities:

  • Leading and mentoring technical team of DBAs, data modelers, data mappers, ETL developers and daily status meetings using agile / scrum methodologies
  • Supporting the data access integration architecture design effort
  • Defining and recommending approaches to (sql server / SSIS ETL) test, performance and production deployments
  • Defining the ABCs (audit, balance and controls) architecture
  • Creating source to target mappings
  • Creating / modifying enterprise data models (relational, multi-dimensional)
  • Reviewing source to target results via SQL

Environment: consists of SAS, Cognos 10.x, ClickView, Tableau, DB2, Oracle 11g / 12c, VSAM, SQL Server 2012 / 2014, Datastage, Erwin, including multiple disparate data sources and SharePoint.

Confidential

Sr. Architect / Lead Consultant (Data Warehouse)

Responsibilities:

  • Leading and mentoring technical team of DBAs, data modelers, data mappers, ETL developers and daily status meetings using agile / scrum methodologies
  • Creating, maintaining, administering project plan and status in MS Project and Planner
  • Leading the data access integration architecture design effort
  • Defining and recommending approaches to (sql server / SSIS ETL) test, performance and production deployments
  • Defining the ABCs (audit, balance and controls) architecture
  • Reviewing source to target mappings
  • Reviewing data models
  • Reviewing source to target results via SQL
  • DW Functional Requirements Document,
  • DW Functional Design Document
  • DW Integration Architecture Design
  • DW Technical Design Documents

Environment: consists of Cognos 10.x, ClickView, Power BI, Oracle 11g, SQL Server 2012 / 2014, SAP Power Designer, SSIS, SSRS, multiple disparate data sources and SharePoint.

Confidential

Data Modeler /Architect / (Data Warehouse)

Responsibilities:

  • Leading review sessions to determine data rules and data model reviews with stake holders. Extensive architecture and design experience with complex systems working in an Enterprise Environment as a Data / Business Intelligence Architect.
  • Responsible for the creation of the ERD (Conceptual Logical and Physical) designs utilizing both data warehouse and multi-dimensional / start schema modeling
  • Responsible for the staging, data warehouse and data mart designs and mappings
  • Responsible for the architecture, design and implementation of the Business Intelligence project
  • Responsible for the DDL creation and applying to the Netezza Data Warehouse Appliance development environment including performance tuning
  • Responsible for: Data architecture, data development and design, data quality management, reference and master data management, data integration, data governance.
  • Also: Data architecture, data workflow logical models, physical source data models, data profiling reports and data audits, data definitions, data taxonomy, data metrics, meta-data, data lineage, data cleansing services.
  • Environment consists of Cognos 10.x, IBM InfoSphere DataStage 8.1, 9.1, etc., ERwin. Database systems include MongoDB, Netezza 7.x, PureData System / Aginity Workbench, Oracle 11G - 12C, SQL Server 2014, Microsoft Azure SQL Database

Confidential

Sr. Data Warehouse Information Architect, Lead

Responsibilities:

  • Create cutting-edge data architecture and data model solutions for multiple data platforms utilizing agile / scrum iterative development methodologies.
  • Collaborate with business subject matter experts in healthcare industries,
  • Establish and drive data architecture and data modeling thought leadership.
  • The focus of this position is defining and promoting best practices in ETL/Data architecture and data modeling by collaborating with data intake team, DBA and developers to provide sound data framework for applications, easy data access for analysts on multiple data platforms SPARX / EA and (Cognos, Oracle 11G, DB2, SQL Server, Hadoop (HortonWorks).
  • Developed subject area data warehouse / data mart in support of capturing BCBS plan web services and API usage utilizing ERWIN / Oracle.
  • Developed subject area data warehouse / data mart in support of capturing BCBS plan router communication and usage between BCBS plans for plan billing utilizing ERWIN / SQL Server.
  • Developing architecture to archive (over 40 months of history) / restore claim, provider, members, etc. from DB2 into a Hadoop data lake reducing DB2 licensing cost of DB2.
  • Maintain and publish metadata.
  • Responsible for: Data architecture, data development and design, data quality management, reference and master data management, data integration, data governance.
  • Also: Data architecture, data workflow logical models, physical source data models, data profiling reports and data audits, data definitions, data taxonomy, data metrics, meta-data, data lineage, data cleansing services.

We'd love your feedback!