• Created ER Studio code for going back and forth to Excel Data Dictionary• Created Enterprise Metamodel Repository for Data in Motion and Data Lineage • Created Data Architecture capturing flow of software artifacts• Implemented Data Modeling standards and sign off requirements for Conceptual and Logical DM• Implemented Data Governance Rules with Snowflake Metadata Manager and DataBricks on AWS• Doing impact analysis of modified data models

• Created Data Dictionary and Naming Standards for Master Data• Customized Epic Data Models for consumption• Captured ADT (Admission, Discharge and Transfer) for claims information• Captured metrics for Population Health such as top ED visits, total cost, hospital re-admission.• Created Tableau reports and charts (Value Based Care Analytics) for Business• Created Data Lake and Data Warehouse (ADH) Data Models for Patient Data• Created Solution Architecture for Wipro Facets Claim Data Consumption with Informatica• Implemented Data Governance Rules with Snowflake Metadata Manager and DataBricks

• Created Migration roadmap from On Premise to AWS• Create Migration roadmap from IBM DataStage 11.5 to Cloud Pak• Reviewing business requirements for Salesforce• Viewing and adjusting Conceptual and Logical Salesforce Data Models

• Created Data Architecture capturing flow of software artifacts• Created Operational Data Hubs (ODH) Data Models using ER/Studio• Created Data Quality metrics and dashboards for EPIC data using Tableau• Created Data Governance Rules and Management

• Documented MetaData for IBM Data Catalog for CCPA (California Consumer Protection Act)• Created Conceptual, Logical and Physical Data Models using ER/Studio• Gap analysis of on premise data platform to cloud and selection of cloud based data platform• Updated Warehouse for uplift to AWS Snowflake

• Big Data Architect for AWS RDS Aurora and Atlasian MongoDB• Created Data Models using ER/Studio compatible with ACORD and IAA• POC Collibra Data Dictionary and Business Glossary• Created Data Movement standards for ETL Talend Open Studio with ESB (Enterprise Service Bus)

• Architect for a ETL solution for synchronizing AWS Big Data RedShift to On Premise Oracle platform.• Created DataStage standard platform and templates for junior developers• Created Enterprise Metadata Repository• Created Data Governance Rules and Management• Installed and trained profiling tools to developers (IBM Information Analyzer)

• Leading Architect for a Microsoft MDM data solution for naviHealth.• Analysis of current data stores and understanding of data flows• Reverse engineering of data stores into Entity Relationship Models• Customized Epic Data Models for consumption• Developed Use Cases and Test Plans with Power BI• POC Collibra Data Dictionary and Business Glossary• Used JSON to load data into the MDM target data base from MongoDB

• Managed Onshore/Offshore team implementing a Commercial Lending Solution using Informatica• Created Agile/Scrum Project Plan with continuous DevOps Roll outs.• Integrated Salesforce/nCino to an Oracle ODS and to a Teradata Warehouse

• Created Enterprise Metadata Repository to store Business Terminology and relation to Data Objects• Created Data Governance Agile processes for managing Data Dictionary and Business Glossary

Producing a Master Data Model and integrating SAP with Global Data Repository

Datastage ETL Consultant

Datastage ETL Architect/Manager

ETL and Metadata Architecture

Data Architecture

Designed Data Models for National Cross Claims system.

Data/ETL Architect

Data Architect

Implementing SAP GUI Client at BP/Amoco

Pre-sales, Post-sales and stand up live professional training. I must have taught over a 1000 students in the use of our products.

Designed the first X-Windows interactive based cellular site planning tool for RF propagation.

Designing a tactical interface for the Ground Systems Group and for FAA Advanced Aircraft Control System.