Senior Information Architect

• Sep 2019 - Present

Data Architect, Community Health Plan of Washington • Primary responsibility to create Conceptual and Logical data models for the enterprise to support prioritization of updates to the emerging Enterprise Data Warehouse (EDW) in Snowflake Senior Consultant, ADT • Supported the movement of analytic systems from on-premises to Google Cloud Platform, BigQuery, and Informatica ICS. Designed, developed, tested, and deployed ETL through their GIT process. Senior Solution… Show more Data Architect, Community Health Plan of Washington • Primary responsibility to create Conceptual and Logical data models for the enterprise to support prioritization of updates to the emerging Enterprise Data Warehouse (EDW) in Snowflake Senior Consultant, ADT • Supported the movement of analytic systems from on-premises to Google Cloud Platform, BigQuery, and Informatica ICS. Designed, developed, tested, and deployed ETL through their GIT process. Senior Solution Architect, T-Mobile • Worked for Innovative Data Solutions {IDS) group to determine project impact to IDS data warehouse assets including Teradata, SQL Server, and Azure. Impact analysis, LOEs. Senior Information Architect, Premera • Created the first two versions of the Canonical Data Model for the DataHub team (eRWin). • Provided Physical and Canonical data models for use with technology, business, and DataHub teams. • Created source-to-target mapping documents and data flow diagrams to support DataHub development and Extract/Transfer/Load (ETL). • Established Data Contracts with DataHub Consumers and Systems of Record. • Collaborated with the Information Architecture team with the development of Enterprise Logical/Business Data Models (EDMs) for several core Subject Areas both project and data domains. • Collaborated with the DataHub Architecture and Development teams to support implementation of the Canonical model. • Provided Common-Use data definitions and published to Informatica Axon Data Dictionary. • Collaborated with the Data Governance and Privacy teams on following Premera’s data governance regulations and tagging sensitive data. Senior Data Architect, Amazon • Provided a common-use Financial Data Dictionary for the Tax PMO team at Amazon. • Collaborated across multiple teams to agreement on terms and definitions. Show less Data Architect, Community Health Plan of Washington • Primary responsibility to create Conceptual and Logical data models for the enterprise to support prioritization of updates to the emerging Enterprise Data Warehouse (EDW) in Snowflake Senior Consultant, ADT • Supported the movement of analytic systems from on-premises to Google Cloud Platform, BigQuery, and Informatica ICS. Designed, developed, tested, and deployed ETL through their GIT process. Senior Solution… Show more Data Architect, Community Health Plan of Washington • Primary responsibility to create Conceptual and Logical data models for the enterprise to support prioritization of updates to the emerging Enterprise Data Warehouse (EDW) in Snowflake Senior Consultant, ADT • Supported the movement of analytic systems from on-premises to Google Cloud Platform, BigQuery, and Informatica ICS. Designed, developed, tested, and deployed ETL through their GIT process. Senior Solution Architect, T-Mobile • Worked for Innovative Data Solutions {IDS) group to determine project impact to IDS data warehouse assets including Teradata, SQL Server, and Azure. Impact analysis, LOEs. Senior Information Architect, Premera • Created the first two versions of the Canonical Data Model for the DataHub team (eRWin). • Provided Physical and Canonical data models for use with technology, business, and DataHub teams. • Created source-to-target mapping documents and data flow diagrams to support DataHub development and Extract/Transfer/Load (ETL). • Established Data Contracts with DataHub Consumers and Systems of Record. • Collaborated with the Information Architecture team with the development of Enterprise Logical/Business Data Models (EDMs) for several core Subject Areas both project and data domains. • Collaborated with the DataHub Architecture and Development teams to support implementation of the Canonical model. • Provided Common-Use data definitions and published to Informatica Axon Data Dictionary. • Collaborated with the Data Governance and Privacy teams on following Premera’s data governance regulations and tagging sensitive data. Senior Data Architect, Amazon • Provided a common-use Financial Data Dictionary for the Tax PMO team at Amazon. • Collaborated across multiple teams to agreement on terms and definitions. Show less

Senior Azure Data Architect

• Jun 2018 - Jun 2019

Hired as a contractor for an on-prem to Azure project for our Bellevue customer. The Data Architect is responsible to collaborate with the engineering and development teams to design solutions for migrating data from on-prem systems and migrate them to Azure. Design includes a source-to-target mapping document and a solutions architect document. Other design documents include data flow diagrams and logical and physical data models. In addition to design tasks is working in the Azure… Show more Hired as a contractor for an on-prem to Azure project for our Bellevue customer. The Data Architect is responsible to collaborate with the engineering and development teams to design solutions for migrating data from on-prem systems and migrate them to Azure. Design includes a source-to-target mapping document and a solutions architect document. Other design documents include data flow diagrams and logical and physical data models. In addition to design tasks is working in the Azure environment setting up any objects needed to support the data migration. This includes Azure Blob Storage, Azure Data Factory, Azure Data Warehouse, Azure SQL Db, and other Azure resources. The Architect also codes ETL pipelines, SQL load stored procedures, with other tools to demonstrate capability. The architect works closely with the project team to make sure that the design is implemented in a correct and sustainable manner. The Architect defines best practices for all aspects of the Azure environment and ETL activities. One specific product area was designing the migration of Avaya from on-prem to Azure and the transition from Avaya to UCCE. Additional tasks were: 1) Utilize PowerBI to access an Azure dataset to demonstrate capability and support for existing metrics. 2) Developed a method to manage data in the Dev environment. Used PowerBI to view reports and statistics 3) Utilized PowerApps to access the tables used to manage data in the Dev environement allowing commenting. Show less Hired as a contractor for an on-prem to Azure project for our Bellevue customer. The Data Architect is responsible to collaborate with the engineering and development teams to design solutions for migrating data from on-prem systems and migrate them to Azure. Design includes a source-to-target mapping document and a solutions architect document. Other design documents include data flow diagrams and logical and physical data models. In addition to design tasks is working in the Azure… Show more Hired as a contractor for an on-prem to Azure project for our Bellevue customer. The Data Architect is responsible to collaborate with the engineering and development teams to design solutions for migrating data from on-prem systems and migrate them to Azure. Design includes a source-to-target mapping document and a solutions architect document. Other design documents include data flow diagrams and logical and physical data models. In addition to design tasks is working in the Azure environment setting up any objects needed to support the data migration. This includes Azure Blob Storage, Azure Data Factory, Azure Data Warehouse, Azure SQL Db, and other Azure resources. The Architect also codes ETL pipelines, SQL load stored procedures, with other tools to demonstrate capability. The architect works closely with the project team to make sure that the design is implemented in a correct and sustainable manner. The Architect defines best practices for all aspects of the Azure environment and ETL activities. One specific product area was designing the migration of Avaya from on-prem to Azure and the transition from Avaya to UCCE. Additional tasks were: 1) Utilize PowerBI to access an Azure dataset to demonstrate capability and support for existing metrics. 2) Developed a method to manage data in the Dev environment. Used PowerBI to view reports and statistics 3) Utilized PowerApps to access the tables used to manage data in the Dev environement allowing commenting. Show less

Project Manager

• Jan 2018 - Mar 2018

Managing projects for Pactera. One is creating/updating a data strategy for a large organization. Managing projects for Pactera. One is creating/updating a data strategy for a large organization.

Data Architect / Program Manager

• Nov 2015 - Oct 2017

Working as an Enterprise Data Architect. Designing a data warehouse including writing the RFP. Proof of Concept between PowerBI and Tableau and determining data requirements. Working as an Enterprise Data Architect. Designing a data warehouse including writing the RFP. Proof of Concept between PowerBI and Tableau and determining data requirements.

Senior Data Architect

• Sep 2014 - Jun 2015

Supporting the Army’s CTO in identifying, evaluation, and recommending software to help consolidate or bring up to current standards for all of their network applications. This ranges from patch management, vulnerability analysis, and enterprise architecture as a means to ensure the end results are integrated within the Army suite. Supporting the Army’s CTO in identifying, evaluation, and recommending software to help consolidate or bring up to current standards for all of their network applications. This ranges from patch management, vulnerability analysis, and enterprise architecture as a means to ensure the end results are integrated within the Army suite.

Technical Program Manager

• Jun 2014 - Sep 2014

Utilizing a hybrid SDLC/Agile approach we initiated a data modernization task for the educational branch of the VA. Utilizing a hybrid SDLC/Agile approach we initiated a data modernization task for the educational branch of the VA.

Senior It Architect / Program Manager

• Jan 2009 - Jun 2014

Consolidating or inter-relating corporate databases so that executive management would have much more coherent reports to manage the business with. Consolidating or inter-relating corporate databases so that executive management would have much more coherent reports to manage the business with.

Director of Engineering

• 2007 - Apr 2010

Project Manager

• May 2007 - Jan 2008