Category: erwin

Accenture AI, Data Architect Innovation Principal

Agile Methodology, Asana, AWS Cloud Practitioner Cert, Big Tech Data Center Ops, Business Glossary/Data Governance, Collibra, Consumer Products, Data Governance Council, Data Governance Strategy, Data Mesh, Data Profiling/Data Quality, Delivery Lead, ER/Studio, erwin, Facets, GCP BigQuery, GCP DataStudio, GCP Plx, GitHub, Google Cloud Platform, Health Care Payer, Jira, Metadata Management, MS Azure, MS Project, Practice Leadership, Snowflake, SQL, Technical Advisor, Teradata

July 2020 – Present

Data Architect Offshore Team Lead for a large healthcare health plan provider. Lead and coach 5-member team on Teradata and Snowflake data modeling assignments and process using ER Studio. Establishing Jira format in conjunction with the Data Engineering teams to provide improvements in workload forecasting and assignments. Assess and define modeling requirements during project intake process.

Technical Architect and Advisor to well-known big tech services provider to implement data management capabilities in their new platform development. Grew implementation team from 4 to 13 as the technical architect and delivery lead from November 2020 to December 2022. Crafted SOWs for 3 extensions and followed approval processes, pricing, project staffing selection and client invoice management.

Data Governance and Collibra architect for large national retail chain to provide initial population of business metadata and data governance strategy.

Continuing participation in the AI Data Governance & Data Management Center of Excellence, managing intellectual property publication for the team.

AWS Certified Cloud Practitioner

GCP Professional Data Engineer Cert (projected November 2023)

Clarity Insights Data Governance Specialist, Principal

Agile Methodology, Asana, Business Glossary/Data Governance, Claims, Collibra, Data Governance Council, Data Governance Strategy, Data Profiling/Data Quality, Delivery Lead, Enrollment/Member, ER/Studio, erwin, Health Care Payer, Metadata Management, MS Azure, MS Project, Provider, Snowflake, SQL

July, 2019 to June, 2020

Redesigned development documentation templates for health plan analytics prototyping effort resulting in a streamlined process and faster turnaround time.  

Provided/assembled content for 10 Data Governance training courses for the new Data Governance Council members for a health plan customer.

Internal data governance projects include 

  • Led the stand-up, standards and registration process for the Collibra sandbox, including automation of the registration forms and form tracking.
  • Led the reorganization of the Clarity Data Governance IP documents and creation of standards for project documentation and curated Clarity methodology uploads.  This included automation of the registration forms and form tracking.
  • Led the integration of Clarity’s Modern Data Architecture Ingestion Framework with Collibra Data Governance Center. Became certified as a Level 2 Collibra Expert.
  • Created a logical data governance metamodel, which will form the basis of a data governance accelerator to assist customers implementing Clarity’s Data Governance Strategy.
  • Presented an assessment strategy for Data Governance tools to enhance consultants’ accessibility to information for use in making recommendations to customers.  Identified 50+ vendors as leaders in metadata management, data quality, privacy compliance and master data management to be included in the assessment. Interviewed and documented 8 tools vendors in the assessment matrix, as part of an ongoing effort. Arranged product demos for internal data governance team.

Data and Integration Architect – HighPoint Solutions – US (Multiple Sites)

Agile Methodology, Business Glossary/Data Governance, Claims, Data Profiling/Data Quality, Delivery Lead, Enrollment/Member, ER/Studio, erwin, Facets, Health Care Payer, Hospital Quality Measures, Informatica Administration, Informatica/Axon, Informatica/EDC, Informatica/IDQ, Informatica/PowerCenter, InformationBuilders, iWay Data Quality Suite, Jira, Metadata Management, MS Project, Oracle, Pharmaceuticals, Practice Leadership, Provider, SQL, SQL Server, Tableau, Talend, Teradata, Toad Data Modeler

November, 2015 to June 2019

Informatics Architect for consulting company with healthcare, pharmaceutical and life sciences focus areas. Role included DW/BI architecture design, project technical oversight to multiple concurrent teams, data governance best practices in healthcare data management and business intelligence projects.

Designed and managed implementation of reporting prototype for data quality history and trending in IDQ 10.1 environment.

Established data architecture practice, modeled existing sources and created member/enrollment and provider logical data models in ER/Studio for a Massachusetts ACO. Screened candidates to assume lead role in the ACO organization. Trained analysts in ER/Studio and data architecture best practices. Participated in screening of implementation partners for data warehouse and master data management in a Talend/SQL Server environment.

Provided design and oversight to 3-person team to implement Informatica Business Glossary and Metadata Manager (v 10) proof of concept in the 4th largest BCBS organization. Project included 4 use cases using both PowerCenter and SQL-based ETL with rule-based lineage. Held daily sessions with internal team leaders to provide education, knowledge transfer and best practices. Team provided design and Informatica configuration documentation.

Designed data and metadata driven integration architecture, providing technical oversight/mentoring to 6-person team implementing a provider master data repository for a health plan and health services organization. Phase 1 moved Vistar data into the repository, providing daily extracts to a third party online provider scheduling application. Project team is extended to include data from Echo and Epic, and include data quality management and integration with Collibra.

Designed data and integration architecture and provided technical oversight to a 4-person team revising data strategy and business process for a healthcare analytics company. This project replaced their home-grown SQL Server application and manual data scrubbing and validation process with an automated solution. Informatica PowerCenter and IDQ were used to move, scrub and validate incoming hospital data applying over 400 scrubbing and validation rules reducing throughput from 2-3 weeks to 1-2 days. Over 40 IDQ profiles, scorecards and human tasks were built for data analysis performed by the operations team.

Architect for two data warehouse projects following a metadata-driven ingestion to staging, with subsequent custom ETL to requirements-driven relational data warehouse. This allowed the customer the flexibility to add or remove source data at schema, table or field level while maintaining changed data capture and history/archiving. One project was implemented in Informatica PowerCenter for a large hospital complex with clinical and patient data, and the other in Talend for a large medical provider/health plan management company. Trained and developed a new data modeler to follow industry standard best practices, who progressed to a data architect level of performance by the second project.

Training included Informatica Axon and Enterprise Information Catalog.

Principal Consultant — Data Intensity — Greater Cincinnati Area

Agile Methodology, Business Glossary/Data Governance, Data Profiling/Data Quality, Data Vault, erwin, Informatica Administration, Informatica/PowerCenter, Jira, Metadata Management, Multimedia, MySQL, Oracle, R, RapidMiner, SQL, Tableau, Technical Advisor, Unix Scripting

November, 2014 to November, 2015

Lead Data Architect/Integration Architect in an Oracle and MySQL environment; Data Vault data architecture; Expert ERwin Data Modeler (workgroup edition);  Informatica PowerCenter/IDQ/Metadata Manager/Business Glossary tools, RapidMiner, R, Tableau, Agile methodology, Jira.

Installed/configured/administered PowerCenter in an Oracle environment.  Designed and modeled data vault architecture for incremental load of Kantar Media data with transaction history.  Designed/built PowerCenter ETL to load/maintain 27 daily feeds. Provided extensive documentation and knowledge transfer.

Enterprise Data Architect — Blue Cross Blue Shield of Louisiana — Baton Rouge, LA

Business Glossary/Data Governance, Claims, Crystal Reports, Data Profiling/Data Quality, Delivery Lead, erwin, Facets, Health Care Payer, HP Quality Center, Informatica Administration, Informatica/PowerCenter, ITIL V3, Metadata Management, MS Project, Planview, Practice Leadership, Provider, SQL, SQL Server, SSIS, SSRS, Technical Advisor, Teradata, Unix Scripting

February, 2012 to October, 2014

Brought on board during Assessment Phase for the enterprise data warehouse solution.  Instrumental in technical and business analysis to determine the direction of the data management and ETL solution in a Facets-centered environment.

Lead data and integration architect for process improvements to mature the Enterprise Data Services practice. Design and implementation of a metadata-driven ingestion to the Enterprise Staging Layer allowing modifications at the schema, table and field level with adjustment of parameters.  This integrated data from multiple sources with supporting processes to include data quality profiles/reports, physical data models, changed data capture, historical data retention strategy and storage of metadata/data lineage into the Informatica Metadata Manager and Business Glossary.

Automated process to import/export vast metadata from spreadsheets to simplify maintenance by business analysts, providing training sessions and documentation.  Designed reporting solution to accompany the Informatica Metadata Manager roll-out to the enterprise.

Built initial data architecture practice, setting modeling standards.  Designed training documentation for the tool and trained 4 business analysts to become data modelers using ERwin model repository.

Completed certification for ITIL V3 Foundations.

Senior Systems Engineer — Evanhoe & Associates — Dayton, OH

Business Objects, CMMI Methodology, erwin, HP Quality Center, Informatica/PowerCenter, MS Project, Oracle, SQL, Teradata, Unix Scripting

GCSS-AF/Global Force Management Data Initiative

April, 2010 – September, 2011  — DoD Secret Clearance

Senior Systems Engineer and Informatica developer on Global Force Management Data Initiative (GFM-DI) overseen by the Vice Chairman of the Joint Chiefs of Staff.  The project involves concurrent facilitation of force structure data sharing, ensuring unique information exchanges between enterprise systems on the Global Information Grid (GIG) and mitigating data collision issues across the DoD Enterprise.  Skills include Teradata, Oracle and ERwin.

Proactively suggested creating a separate integration test strategy and environment for the most recent release slated for August 2011. This resulted in the creation of a separate testing environment and expanded duties to run weekly installation tests and report results to the PMO.

Proactively researched and provided objective evidence to the Evanhoe & Associates leaders to demonstrate that the GFM-DI project conforms to most of the CMMI Level 3 requirements.  This resulted in assignment to organize a focus group across the business to do a preliminary gap analysis with a SCAMPI C planned for the fall of 2011.

Senior Systems Engineer – Qbase/Lockheed Martin — Beavercreek, OH

Business Objects, CMMI Methodology, Delivery Lead, erwin, Informatica/PowerCenter, Logistics and Resource Planning, Oracle, SAS, SQL, SQL Server, SSIS, SubVersion SVN, Teradata, Unix Scripting

GCSS-AF

April 2007 – April 2010 — DoD Secret Clearance

The following are projects accomplished for the USAF Global Combat Support System (GCSS-AF) for the Prime Contractor, Lockheed Martin, while working for Qbase.

Served as Tech Lead/Lead Programmer for the SNTUID (Serial Number Tracking/Unique Identification of tangible items) project for the Air Force Materiel Command. This project was the interface between the machine used to mark parts with a unique identifier and the DoD UID Authority. Led meetings with the customer to manage the project and was the lead Data Architect/Modeler, DBA and ETL programmer on a web-based application and a SQL Server database using SSIS.

Acted as Lead ETL Programmer for the BOBJ Metrics project for Lockheed Martin on behalf of the Air Force. Created ETL using Informatica 7.1 pulling in Oracle 10g Business Objects Repository data regarding usage of the various reports in the Data Services framework and outputting an xml document transmitted by SFTP to the customer on a daily basis. Authored all documentation according to GCSS-AF standards.

Lead Sys Admin and Programmer – Predictive Analysis Pilot (SAS) for the Logistics Directorate (USAF/A4). Worked with SAS sales and support to install and configure SAS. Worked with SAS consultants to construct mathematical models then led the presentation to the GCSS-AF Data Services PMO.

Lead ETL Programmer – Informatica Upgrade/Coding Standards effort for the GCSS-AF Data Services/Operations and Sustainment. Piloted a project converting Informatica 7.1 workflows to Informatica 8.1, and revise coding standards to translate Teradata BTEQ scripts to Informatica mappings.

Lead Architect and Tech Writer for the GCSS-AF Data Services/PMO. This effort published standards documentation on the web application for the GCSS-AF.  Standards documents were received from the Operations and Sustainment group, and uploaded to the existing (but empty) library area of the web application.  Also produced were hierarchical maps of hyperlinks that simplified finding the appropriate standards for any of the tools used by Data Services.

Lead Business Objects Developer – ACES (Automated Civil Engineering) Housing Management/Project Management BOBJ Rework for the USAF/A7. Inherited a project completed by another consulting group to Lockheed Martin that was released from the project.  Tasked with handling the PM side which required modifications to the universe to fit the existing Teradata structure and ERwin data model on the Data Services side and 30 revised reports. Identified serious flaws in the ETL delivered by the previous developers, resulting in continuing work for the customer to layer on the needed changes in a future project. Instrumental in defining the project plan/engineering requirements for the future work on ACES HM/PM.Lead Business Objects Developer – ACES Real Property Data Services application for the USAF/A7. Worked with a data modeler and an ETL developer to receive and load ACES Real Property data into Data Services EDW and create Web Intelligence reports for the customer.  Created Teradata views to support the ad hoc reporting capabilities, as well as developed Webi reports. Authored all project documentation.

Lead Teradata DBA and ETL Developer- ACES PM MILCON application for the USAF/A7. Worked on the Teradata side to create data structures and views to support a calculation-intensive report used by the Pentagon to structure the Presidential Budget.  Created 17 views to support the complex report and optimize performance for an application that held more than 50 calculation operations.

Lead ETL and Reports Architect/Programmer – ACES HM Re-engineering (Performance Optimization) for the USAF/A7. Served as the only developer for all segments of the work (Teradata DBA, Informatica, Business Objects). Redesigned data structures and views which were accessed by the Business Objects HM application to mitigate the poorly performing HM reports previously undertaken in the original ACES HM project. Created Informatica workflows and denormalized tables to support the Unaccompanied Housing and Military Familly Housing reports which were timing out before results could be displayed.  Revised ACES HM Universe to remove old, poorly performing Business Objects derived tables and replacing with a more efficient strategy, cutting display time down to 21 seconds. Created underlying data structures optimized to support a set of calculations based on the time period entered by the user (because of this, no calculations could occur until the user specified the dates, but the strategy compiled denormalized data in such a way to streamline the work done in the Business Objects layer).

Lead Teradata DBA/Business Objects Developer – ACES PM FIM (Facility Investment Metric) application for the USAF/A7. Created Teradata views and reworked the ACES PM Universe and reports to mimic the results formerly delivered from an Access database.  Deconstructed processes in the Access database and refined logic on the Data Services side to replicate all the features and reports. Constructed automated comparisons of output between the two systems.