Product Tester Data Architect

John A. Murphy

**** ***** ***** *********, ** ***39

Email - ********@**********.***

Skype – jmurphy2997

Linkedin - johnaltonmurphy

Mobil - 303-***-****

Active Secret Clearance, Interim Top Secret

Member Colorado Governors Data Advisory Board

Active Certifications:

Collibra Data Governance Expert 1

ICCP - Data Management (CDMP)

ICCP - Business Intelligence (CBIB)

Data Warehouse 2.0 Practitioner

Data Vault Data Modeling Practitioner

Roles

Enterprise Data Architect

Data Governance and Compliance Implementer

Data Modeler - Conceptual, Logical, Physical, Canonical, 3NF, Multidimensional, Data Vault

OLTP, OLAP, Near Real Time, Unstructured, Big Data implementation

Data Standards Developer, Meta-model and Metadata Management

Master Data Management Specialist

DODAF/TOGAF/DMBOK

Data Quality Implantation Specialist

Project Manager

Methodology

Project Management – Full and partial project lifecycles using the PM, CCPM as well as lighter weight Agile and Extreme. Responsible for resource identification and scheduling, budget estimation and spend / burn rate tracking. Communication Project plan (Gantt and Pert charts), Issues collection and management, specification development and change control.

Business, Systems and Process Analyst – IDEF0, Rational, Zachman Framework – Responsible for Requirements gathering and documentation using Use Case, BPL, ICOMs. Developed project success criteria, measures and metrics.

Data Quality, Cleansing, Profiling and QA based on Metadata and Larry English methods

Data Modeling, Meta Data and Data Repository Development – IDEF1x, DoD 8320, Conceptual, Logical, Physical and Canonical Data Modeling. Third Normal Form (3NF), Data Bus, Star Schema, Aggregate and Summary, Data Vault.

TDWI CIF Data Warehouse Design and Development

DoD Standards for Design and Development- DODAF, DDRS

Corporate Information Factory, Inmon and Kimball Warehousing Principals, Data Vault

Tools

Data Governance – Collibra, ERWin Data Intelligence, Informatica AXON/EDC

Data Modeling – ERWin 9.5, Power Designer v.17, Embarcadero ERStudio 8.0

ETL Tools – Talend, IBM DataSage / InfoSphere, Ab Initio, Informatica, MS-SSIS, Oracle Warehouse Builder

Reporting Tools - Business Objects, Cognos, Qlikview, SSAS/SSRS, Microstrategy

RDBMS – Oracle 11g, DB2, MS SQL/Server 2000/5/8/12, TeraData

“Big Data” Hadoop / Cloudera. AWS, Azure

Process Modeling – BPWin, CaseWise, Requisite Pro

Data Quality – Data Flux, Trillium, First Logic, Quality Manager, Qualitystage

MDM – Initiate, Axiom Abilitec

Summary

30 plus years of enterprise data management related experience in the role of architect, project manager, methodologist and modeler. Over 40 successful deployments in the areas of CRM, Finance, Asset Management, Health Care, DOD, Retail and Insurance. Extensive work in the planning, design, development and deployment of Business Intelligence, Analytic and reporting environments at the Enterprise / Corporate level with over a hundred terabytes of data under management. Beta Product tester for Microsoft CRM, IBM Infosphere and Sybase PowerDesigner. Presentations at major conferences including DAMA, TDWI and Oracle User Groups. Multiple Assessments providing independent analysis of current state development and providing a roadmap to future deployment. Developed mastering process for Provider, Patient and Encounter/Event subject areas. Focus on integration of Medicare Advantage, IMS, NPI, CMS, ICD10, Member/Patent admissions and discharge information.

Data Management Experience –

Independent Contractor / Consultant – John Alton Murphy, INC. 1/1992 to Present.

High Mark Health Care – Pittsburgh PA – 2/4/2022 to 2/9/2022 – Digital Transformation for Medicaid

Data Architect and contractor focusing on Data Architecture and Standardization for multiple state Medicaid programs that would be managed through a single vendor. Activities included assessment of Member, Claims and Provider data from various states to be integrated into centralized as well as regional repositories. The data was to be prepared for meeting regional, state and federal regulatory purposes. Focus was on data transportation, quality and standardization to be used as part of key Medicaid Program measures. Very similar to HPSJ programs for the State of Calif.

US Air Force/KPMG – Washington, DC – 12/2020 to 2/1/2022 – TMDE/HRM Data Architect

Contractor focusing on data architecture and design for the Talent Management Support for Digital Transformation (TMDE). The TMDE supports an implementation of SFDC for applications and leverages off the Air Force Vault implementation. TMDE also supports a data warehouse and analytic and reporting services. TMDE will support all U.S. Air Force active forces, reservists, National Guard and Civilians as part of the Human Resource Management. My role was to provide data architecture and data governance support for TMDE development along with Data Quality standards and practices as well. Responsible for the overall TMDE requirements development including delivery and presentation of the BRD. Responsible for the developed the Detailed Requirements documentation based on TOGAF defined deliverables. Worked closely with A1XM project management and individual AF workgroups. Data Governance support through Informatica AXON and EDC. Developed a data quality strategy focused on both data remediation/rehabilitation as well as preventative diagnostic practices and procedures. Th main focus of the program is to provide a one stop authoritative source of data integrated from over 300 data sources. System is contained in an AWS environment and leverages Informatica for data integration and Tableau for reporting and basic analytics services.

P3 Analytics – Las Vegas, NV – 11/2019 to 11/2020 – Data Architect / Data Modeler

P3 provides Cohort Analytics services to major Healthcare Insurers including Aetna, United and multiple BCBS. My role was providing analysis, redesign and data modeling to their data warehousing environment. Created data models to all major Domain and Subject Areas (Member, Provider, Plan, Claim etc. along with data modeling for Analytics including Member Month, Risk, HEDIS/Quality Medicare Risk Assessment and Census. Worked with the business to develop naming standards, business Rules, Data Validation and Reporting requirements. Generated C/L/PDM ERDs along with the supporting Data Dictionary and Lineage reports. Work performed onsite and remote. Tools included ERWin 2019, SSMS, AZURE DB/DW Target Environment.

Mayo Clinics – Rochester MN – 6/2019 to 2/2020 - Data Governance Specialist

Provided assistance in implementing Enterprise Analytics, Reporting, Vital Signs subject areas for for data Governance at the Mayo Clinics headquarters using Collibra, Designed integration of Physical and Logical assets to support cross functional understanding of the data. Assisted in developing data quality reviews with result sets retained in Collibra. Developed a standard conceptual data model to relate assets, relationships and assignments to organization, subject area, physical and logical mapped assets. Responsible for interviews, assessments, presentations to various levels of leadership.

State of Colorado OIT – Denver, CO – 1/1/2019 to 8/2021 – Data Architect and Governance Specialist

Developed Data Governance Charter and Organization Framework. Hired DG Lead. Developed Pilot program using 4 major applications in Health and Human Services. Data Architect for the Joint Application Integration Initiative. Implement Technical Data Governance strategy based on ERWIN Data Modeling, Mapping Manager and Data Governance tools. Installed tool set and reverse engineer metadata from multiple operational source systems. Provided user roles, access and authority for user reporting services in the repository. Provided Data Governance Charter including organization outline and implementation Roadmap. On going engagement.

Price Waterhouse Cooper / Lockheed Martin – Ft. Worth, TX – 5/2018 to 1/1/2019 – Data Architect

Review, Verification and Validation of the analytics and reporting services associated with the LMA F-35 JSF Sustainment. Detailed review of the bed down, flight operations, materials management, Repair and Maintenance information data supporting the sustainment analytic models. Determination of data and analytic quality in support of sustainment performance metrics. Provided strategy to determine confidence measure in data acquired and integrated from over 250 sources . The measures were then used in tuning system, component and part reliability measures for overall sustainment costs.

NaviHealth / Cardinal Health / EMIDS – Brentwood, TN – 11/2017 to 5/2018 – Data Governance and Master Data Management Assessment

Review, design assessment and guidance for a product and analytic suite focused on Post-Acute Care (PAC/SNF) service provisioning. Provided Master Data Management (MDM) options, recommendations and guidelines for implementing a strategy to resolve integration with multiple acquired companies and customer data sets. Provided guidance on implementation of a Data Governance strategy through the Master Data Management needs. Developed mastering process for Provider, Patient and Encounter/Event subject areas. Focus on integration of Medicare Advantage, IMS, NPI, CMS, ICD10, Member/Patent admissions and discharge information. Provided roadmap for implementation of the MDM strategy. SQL Server, Oracle and MongoDB.

Southern California Edison (SCE) – Rosemead / Pomona CA – 3/2017 to 11/2017- Data Governance and Data Quality Specialist

Provided guidance for the creation of a data governance platform supporting data quality, data standardization and data integration for Asset and landbase data used with Map3d, ESRI Mapping and GE Smallworld. Data originates in SAP and is propagated to various analytic and mapping services for the creation and electrical network segments and assets. Directing the establishment of a data governance process based on DAMA principles. Creation of Data Quality initiatives focused on data standardization and cleanup using TDQM measures. Working with inhouse and offshore staff for implementation. Use of SAP Information Steward for data Profiling and Data Services for data quality.

Missile Defense Agency/MDA/Space Force – Colorado Springs CO – 3/2015 to 3/2017 Lead Solution and Data Architect

Provided Data Architecture leadership in developing an integrated analytic and reporting service for support of Asset Management, Financials, Event Management, Program Portfolio, Artifact Management and Cyber utilization and security subject areas. Developed Conceptual, Logical and Physical data models for Hive / HDFS data systems based on highly denormalized data structures. Developed meta-model supporting that included security and integration services. ERWin 9.5 as data modeling tool with domain attributes and User defined parameters Implemented in a ULAN/CLAN CDS environment on a Cloudera r5.4 implementation of an Hadoop cluster with Talend DI and Microstrategy reporting services. Talend was used to generate Scoop and Flume scripts for the data integration services. System acts as the historical repository for various network messaging, audit and event management. This is a multi-petabyte multi node fault tolerant / high availability system. Architected and Developed within a DODAF framework. Also architect the Data Governance process and data quality services as part of the engagement.

Health Plan of San Joaquin - Stockton, CA – 7/2014 to 4/2015 – Lead Data Architect/Data Modeler

Provided data architecture related services for specialty healthcare insurer. Provided data modeling services for Pharmacy, Authorization and Member Month Subject areas. Responsible for Conceptual, Logical and Physical data models for Base tables as well as Aggregate and Summery / Data Mart environment. Providing source to target mappings, integration architecture. SQL Server and DB2 source systems with SQL Server 2012 target Consolidating Data Governance practice for supporting HIPPA, PHI and PCI regulations. Data supported analytics and reporting services used through standard KPIs, measures and metrics. Reports generated in Tableau as standard reports and user generated reports.

SCANA Electric Utilities, Columbia South Carolina – 5/2014 to 7/2014 – Data Architect

Provided data modeling and architectural services supporting an Implementation of Asset Management and service scheduling activities. Source environment of DB2/SQL Server with a Target warehouse in Teradata. Data modeling in ERWin9. Use of the ADRM canonical / Logical utilities model. Very similar activity to work performed with Idaho Power.

United States Department of the Army – Alexandria, VA – 7/2013 to 4/2014 – Data Architect

Part of a 12 member Red Team review and assessment of a large personnel management and payment system for the Department of the Army. Managed ETL remediation team schedule and deliverables. Responsible for the review, assessment and Project Assurance of data integration (Datastage) and data quality services. Identified deficiencies in process, design and implementation. Developed remediation strategies for data integration services implemented through the IBM Infosphere - Datastage product suite. Managed remediation team schedule and deliverables. Responsible for review and assessment of overall Data Architecture (Data Integration, Modeling and Quality) documentation, SLAs, ERDs, DI Jobs and coding. Contributor to final presentation. Evaluated System Integrators and various vendor deliverable as part of my Project Assurance role. Retained following the initial assessment to assist in development of the Critical Design Review documentation and presentation. Ongoing assistance to senior management for data quality, change control and development of deployment strategy.

State of California Franchise Tax Board – Sacramento, CA – 5/2012 to 6/2013 - Lead Data Architect

Lead Data Architect for design and implementation to revamp Operational and Data Warehouse data model, data acquisition, analytic and reporting services for the revenue arm of the state. Supervised the design and development staff for Data Modeling and Data Integration. Responsible for Project Assurance in all data architecture domains as well as data governance. Responsible for the design of the data sourcing strategy using IBM’s Datastage suite including Datastage, Qualitystage, Information Analyzer and MDM services supported through Initiate. Responsible for the Initial and incremental load architecture along with scheduling, event notification and exception management. Responsible for ETL operational reporting services based on Datastage generated log data. Implemented, configured and populated metadata workbench for supporting ETL as well as analytic and reporting services. Responsible for data reconciliation, outlier management, source to target mapping documentation. Responsible for the population of the EDW and ODS with Legacy and current state initial load data using Datastage jobs and services. Supervised and assisted the development of the conceptual, logical(3NF) and physical data modeling for the complete data warehousing environment supporting 300Tb+ foundation and data marts. Responsible for coordinating the data modeling activities of three major solution provider organization along with state resources. Responsible for identifying and driving enterprise level data solutions. Responsible for developing and implanting Program and Enterprise level data governance. Assisted in the architecting of the states MDM Solution for identification de-duping, merging and splitting individual and organization entities. Responsible for the development and management of the program level metadata repository including full lifecycle data development. Identified and implemented enterprise level information standards including access and authority, retention and integration. Identification of a standard CIF architecture framework. Developed standard (canonical) data models as well as structural design patterns for reference data management. Developed strategy for inclusion of structured (e-file) as well as unstructured data (scanned filing and document) Environment developed with IBM Infosphere (DB2, Metadata Workbench, Initiate, Business Objects, Information Analyzer). Modeling in Powerdesigner 16.1.

Idaho Power (IPC) – Boise, ID – 2/2012 to 5/2012 – Data Architect/Data Modeler

Developed EDW architecture and data model for regional electric utility. Supported IPC transition from CIS+ to SAP for customer management. Supplied guidance in developing an Enterprise Data Warehouse. Supervised requirement gathering for analytic and reporting requirements and design, data integration design and development. Warehouse data included above sources and IEE for meter reading. Incorporated third party utilities data model (ADRM). Developed Canonical, conceptual, logical (3NF) and physical data model models in ERWin 8. Architected ETL strategy to integrate existing legacy source data with SAP incremental loads using standardized templates in Datastage. Provided design and supervised the data integration scheduling, exception management, event notification and ETL operational reporting and audit services.

Dish Network / Echostar - Denver, CO – 9/2011 to 2/2012 – Enterprise Data Architect/Data Modeler

Developed multiple Enterprise Data Warehouse (EDW) and Data Mart conceptual, logical and physical data models to support Order Management, Organization and Technician Performance Metrics. Supervised data modeling team for standards and development of data models (Canonical, Conceptual, Logical (3NF) and Physical) and integration team for ETL services. Work performed in ERStudio 8.53 for both Teradata 13.10 and Netezza 6 environments. Dish uses Teradata for EDW and publication reporting services (OBIEE and Micro Strategy) while using Netezza for true analytics. Designed target Teradata and Netezza data structures to support migration of executive DSS / Dashboards from SQL Server. Target reporting based on OBIEE. Export / Import data formats for Oracle EBS 12.1.2. Developed STM for CSG source structures to new DSS. Engagement designed as a short term contract to resolve and accelerate end of year analytics, data sourcing and reporting needs. Use of Aginity, Golden Gate. Assisted in development of pilot projects using Ab Initio for integration and scheduling services.

Catholic Healthcare West – Phoenix, AZ – 9/2010 to 9/2011– EDW Architect and Data Modeler

Designed and developed clinical data warehouse to support Meaningful Use Reporting, Missing Charges Reporting and Provider Task Reporting for a large West Coast Healthcare provider. Information is extracted daily to support physicians and healthcare providers in California, Nevada and Arizona. Primary focus on provider performance analytics for ambulatory clinical care. Responsibilities included the design of a target IDS / data warehouse and data marts sourced from IDX, Allscripts and Facets. Responsible for Project Assurance in all Data Architecture Domains including Data Quality. Negotiation of SLAs with 12 separate data providers. Developed refresh, transformation and sourcing logic, capacity planning model, security model incorporating HIPAA compliance. Performed data modeling (Conceptual, Canonical, Logical (3NF) and Physical with ERWin 7.3. Managed team of 2 ETL contractors and 2 BI report developers. Supervised Data Integration and ETL development services with SSIS. Reporting and analytic services provided with SSRS. Developed data profiling and statistics reports using SSRS. Coordinated with DELL Professional services to design and implement infrastructure around DL580/380 Dev, Test and Production environments with separate data marts utilizing SQL Server 2008. Initial capacity is 7Tb. This project represents CHWs first data warehousing initiative and supports retirement of two existing third party data warehouses (McKesson and GE) and will be used in supporting their Meaningful Use certification.

Travelport – London, UK /Denver, CO – 10/2009 to 9/2010 – EDW Architect /Data Modeler / MDM Strategist

Performed Audit and Assessment of the Enterprise Data Warehouse for Tavelport, the parent company of Orbitz and Hotel.com, a multinational travel and reservations service. Duties included a review of the current EDW and data architecture focusing on how currently defined Key Performance Indicators, Measures and Metrics have been implemented in the EDW 3nf base tables as well as in Stars designed to support specific analytics. Also identifying and constructing SLAs for multiple data and service sources. Supported development of data standards and enterprise governance process. Supervised on and offshore teams developing ETL services for schedule and deliverables. Continued participation in the second phase of the project supporting development of the data integration services using IBM Infosphere platform with IBM DB2 9.7, Informatica ETL services, X-88 / Pandora Data Profiling services and Cognos Analytic and Reporting services. Participated in MDM product evaluation (Oracle and IBM) and POC focusing on development of governance and compliance issues. Developed a standard Reference data repository and shared entities used by the EDW and subsequently several other projects. Data modeling (Conceptual, Logical (3NF) and Physical) using Embarcadero ER-Studio 8. Established Data governance with Data Architect Group including the establishment of Data Stewards and Subject Area Functional Proponents. Developed Data propagation services based on Websphere MQ services using a subscription model. The Subscription uses a Q replication strategy (Q Capture/Q Apply) to propagate transaction log events to the target staging area for load to the EDW.

National Grid – Westboro, MA 2/2009 to 10/2009 – Data Warehouse Data Architect /Data Modeler

National Grid is the primary electrical transmission and distribution utility for New York State and New England. My responsibilities included designing an Asset Management subject area of the EDW to support Adhoc and standard reports for circuit and critical asset health. Integrates multiple data sources including Cascade, ESRI, Maximo, Computa Pole and Power On. Based on the ESRI Transmission / Miner and Miner Canonical Logical data model. Responsible for Data Warehouse Data Model (conceptual, Logical (3NF) Physical), Data Mart Data Model, Source to Target Mappings ETL Service schedules, Exception management and event notification using Datastage for ETL services, and Qualitystage for address standardization. Developed Business Objects Universe specifications. Developed standard reference data and shared entities for warehouse and GIS services. Worked with and helped identify Data stewardship responsibilities for Asset Management. Provided governance and compliance data for TSA and regional utility boards. Work performed in Erwin, Oracle 10g and ESRI. Target OBIEE reporting services. Imported data and structures used in existing Netezza decision support system.

TransFirst – Louisville, CO 10/2008 to 2/2009 – Data Warehouse Data Architect / Data Modeler

TransFirst is a tier 1 provider of merchant payment systems / credit card processing. My responsibilities included the identification of the system architecture for supporting a new Data Warehousing / Business Intelligence environment. Was retained by senior management to translate business requirements into data management processes to support corporate analytics and reporting services specifically around sales force efficacy. Developed data content standardization process to improve Merchant Boarding process and Data Quality. Worked with data stewards and SMEs to identify various sensitive or regulated (PCI) information and appropriate management techniques. Developed performance metrics reports in SQL SERVER 2008 with SSRS reports. Established data governance policies as part of the data management practices. Developed Conceptual and Logical Data Model (ERWin). Dell Blades with MS-SQL Server 2005/8. SSIS/SSRS/SSAS.

United Health Care / Ingenix – Minneapolis, MN 6/2008 to 10/2008 – Enterprise Data Architect / Data Modeler

Supported the Medicare Part B analytic and reporting data warehouse architecture and design through the identification of source systems in claims, billing and member to support a prescribed set a member management, sales and finance executive reports and analysis. Identified initial MDM strategy for reference model standards around billing codes, member and product. Financials sourced in part from SAP. Responsible for Project Assurance in all data Domains including Source System relationships, Data Quality and remediation. Worked with management and business to identify rules associated with data access and roles as well as development of KPIs to report against. Worked with SMEs to identify sensitive and regulated data (HIPPA) used in analytics. Developed meta model and metadata management strategy. Developed sourcing strategy based on DataStage suite including Datastage ETL services, Qualitystage for address standardization and Information Analyzer. Multiple sources including FACETS. Supervised ETL on and off shore development teams. Developed scheduling model, exception management and recovery strategy. Developed conceptual and high level logical data model (3NF). Developed overall capacity planning model. Environment consisted of a mixed Oracle 10g / IBM DB2 with Datastage, Qlikview EAI Reporting and Dashboard. ERWin 7.2 Data Modeling

Webtrends – Portland, OR 7/2008 to 10/2008 – Enterprise Data Architect /MDM Strategist/Data Modeler

Webtrends is a leading web traffic analytics product and service company. Worked with the senior management, systems and development staff to architect and redesign web trends analytics and abstraction data model. This included the redesign of key event tables supporting multiple billions of rows of detailed web traffic data. Responsible for Project Assurance and effectiveness for all data management strategy. Developed a meta model for supporting third party and client data. Developed improved detail in the campaign view visit relationship along with standardized structures for contact event and event management. Provided senior management a “read out” on risk associated with current Data Management practices. Developed client segmentation strategy for product and infrastructure assignment. Developed prototype analytics in MS-SQLSERVER 2008 with SSRS. Webtrends client base includes volume users such as Microsoft and Orbitz. Developed data integration and centralization strategy for corporate financial and performance model. Environment consisted of a generic “wintel” server farm with SQL Server 2005. Assisted in conversion of ETL services from SSIS services to Datastage due to performance constraints. Supervised on and offshore ETL developers responsible for the SSIS to Datastage conversion. Architected initial and incremental load strategies for multi 10’s on millions of daily load, transformation and data recovery. Embarcadero ERStudio Data Modeling tool used to re-architect data models. Evaluated third party DW appliances including Netezza and Balanced Warehouse for use in internal facing decision support system.

US Department of Labor - Golden, CO 5/2008 to 7/2008 – Data Architect / Data Modeler

Supported the migration of an analytic and reporting data mart containing roughly 360 tables and 100+ views from Teradata to an Oracle 10g environment using Oracle Warehouse Builder (OWB) 10g R2. Responsible for migration of structures, tables and views along with data type recasting as needed. Developed meta-model and updated ERWin metamodel to support data quality and integration. Worked with DOL Subject Area Functional Proponents to populate operational and business metadata. Constructed mappings with the OWB Data Mapping tool as well as TCL based scripts accessing the OWB API. Reviewed and tuned PL/SQL. Data Integration with Ab Initio with date based partitioning. Developed a tiered scheduling process for handling initial, incremental and on demand refresh processes. Documented existing and target models (3NF) with ERWIN physical model.

Microsoft Corporation, Redmond, WA 1/2008 to 5/2008 – Enterprise Data Modeler / Meta Model Developer

Lead Data Architect and Modeler for development of the Canonical Conceptual and Logical (3NF) data model to support the relationship management subject areas of the Microsoft Enterprise Data Warehouse (EDW). Working very closely with marketing specialists to codify data management processes and information resources required to develop, execute, monitor and evaluate various types of global marketing initiatives. Also worked with the business to identify sensitive and regulated information used in a campaign. Implemented modeling, metadata and naming standards along with Enterprise data development standards. Developed information for standard Campaign Lifecycle, Prospect Lifecycle and Campaign Efficacy in ePiphany. Developed semantic layer to assist in identification of a data integration strategy. Other subject areas include License management and market segmentation. Worked with MS data design team in construction of the MS Data Development Lifecycle and a standard Meta model to support the canonical models. Developed initial multidimensional models for customer, partner and product scoring. Integrated newly developed components with existing EDW Subject areas for Sales and Finance. Demonstrated data integration from ePiphany and Siebel CRM. Developed Data profiling and statistics reports / analysis using SQL Server Reporting Services (SSRS) and SQL Server Analytical Services (SSAS) This

Contact this candidate