Category: Data Profiling/Data Quality

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 Technical Lead — Anthem — Cincinnati, OH

ABT Project Workbench, Claims, ClearCase, CMMI Methodology, Crystal Reports, Data Governance Council, Data Profiling/Data Quality, Delivery Lead, Enrollment/Member, Facets, Health Care Payer, MS Project, Provider, SQL, Sybase/T-SQL, Unix Scripting, Visual Basic

October, 1998 – February, 2003

Served as a project manager and technical team advisor for several large outbound eligibility data interface projects (as many as 27 sub-projects/teams) and most recently was project manager for a data quality project for data to vendors and internal data warehouse.

Accountable for leading a team of Programmer/Business Analysts responsible for the design, development, implementation, and support of Health Insurance Actuarial and Decision Support applications.

Utilized formal Project Management and SDLC Methodologies (i.e., ABT Project Work Bench and Anthem’s Application Development Methodology) and ClearCase for version management

Designed and developed Decision Support/Data Warehouse components.

Managed 2 small teams of developers during the build cycle, delivering code, and documentation while participating on the infrastructure team which defined/implemented new standard processes and maintained in-house software utilities.

Maintained and enhanced a test scripting (in-house) VBA utility and provided training and documentation while on infrastructure team.

Worked as a VB programmer on the CoMPLi project to automate documents processing for health insurance certificates.

Sr. Research Associate — Procter & Gamble — Cincinnati, OH

Clinical Trials, Data Governance Council, Data Profiling/Data Quality, Delivery Lead, Good Clinical Practice, MS Project, Oracle, SAS, SQL, Unix Scripting, VAX, Visual Basic

September, 1994 – December, 1997

Project Manager (1995 – 1997)

Managed the enhancement and maintenance of an automated Tables Generation project, including periodic roll-out, training and user support.  Project was migrated from DECVAX to HP9000, and upgraded from Visual Basic 3.0 to version 6.0.

Collaborated with project managers from Medical Surveillance and Clinical Data Management on the Data Standards Review Board to determine and deliver useful tables and monitor data standards and database modeling.

Clinical Data Manager (1994 – 1995)

Responsible for clinical data management for 7 studies adhering to Good Clinical Practices for the OTC/Oral Care focus area, including on-and off-site support and training for direct data entry systems.

Projects included implementing code for new duties assumed by data management operations to provide summary datasets for biostatistical operations.  This required an active role in the development of standard processes to facilitate the acceptance of these systems, with emphasis on meeting cycle times.

 

Statistician/Data Analyst/System Architect — Wright State University School of Medicine– Dayton, OH

4th Dimension, Clinical Trials, Data Profiling/Data Quality, Delivery Lead, JCL, Macintosh OS, MVS/TSO, SAS, SQL, Technical Advisor, VAX

August, 1989 – December, 1993

WSU School of Medicine —  Fels Institute

Designed and developed SAS Biostatistics and lifestyle healthcare applications for Fels Institute which provides clinical human growth and development studies for various health care institutes and providers internationally.

Designed, analyzed, programmed, and tested database applications, as well as utilized various SAS statistical functions to conduct statistical analysis and regression.

Created library of SAS reporting functions and macros to develop flexible reporting.