Data Architect

PROFILE

All-around hands-on data professional with years of experience in all phases of system development life cycle with an emphasis on data architecture, data modeling (conceptual, logical, physical, transactional/relational, dimensional, star and snowflake) and data analysis. Strong experience in analyzing user requirements and turning them into production data models and DDL code. Strong experience in data profiling using SQL, in schema reverse-engineering, data migration, testing procedures specification, and in building tests. Strong experience in creating data models top-down and in inferring conceptual/logical data models bottom up from physical data schemas, from legacy documentation, and from users' interviews. Experience in metadata management and process modeling.

EDUCATION

M.S. Information Systems Technology, Major in Business Technologies, George Washington University.

B.S. Computer and Information Sciences, University of Maryland, University College.

PROFESSIONAL EXPERIENCE

October 2019

March 2020 Data Modeler with xScion Solutions

USP – (United States Pharmacopeia)

Developed a number of logical data models to the level of 3NF (third normal form) for the assigned areas of the USP enterprise process model. Utilized current enterprise model, available documentation, data entry forms, standard operating procedures, and interviews with Subject Matter Experts.

Data Modeling tool: BizzDesign Enterprise Studio 4

September 2018

June 2019 Data Architect/Data Modeler with Octo Consulting Group

USPTO - various projects

Supported the Enterprise Data Architecture Division team as follows:

Led assessment effort of Idera (former ER/Studio) Data Architect Data Lineage functionality.

Synchronized enterprise data architecture models with physical production data models.

Trouble-shot and fixed corrupted physical data models.

Supported enhancement of the data base development standards manual to include MySQL database specifics.

Data Modeling tool: Idera (ER/Studio) Data Architect 17.0

June 2017

August 2018 Data Architect/Data Modeler with BRMi

ABA (American Bankers Association)

Performed as Data Architect/Data Modeler on various aspects of the data governance effort:

Reverse-engineered ABA production transactional system and created and annotated logical data models consisting of some 450 entities in 40 subject areas.

Created entity level enterprise data model.

In collaboration with corporate SME created data dictionaries for existing systems.

Using SQL, profiled production data, identified and presented to the management data quality related problems.

Trained DBA in data modeling basics and in use of Erwin data modeler..

Data Modeling tool: Erwin 9.7.00.2293

August 2015

February 2017 Data Architect with NuWave Solutions, LLC

U.S. Export-Import (EXIM) Bank

Created the following metadata artifacts for the nascent Data Governance program:

.

Assessed data modeling tools (functionality and cost) for potential use in EXIM and submitted report and recommendations to the management.

Generated physical data dictionaries for a number of EXIM bank systems.

Identified and documented implicit primary/foreign keys relationships in EXIM data warehouse.

Standardized columns' abbreviations to be used across various systems

Identified high level EXIM bank data entities and created high level ER diagrams.

Worked with SMEs on system interfaces diagrams for data lineage tracking.

Developed SQL scripts for on-demand data analysis and data profiling tasks.

November 2012

July 2015 Data Architect/Data Modeler with IBM

IRS

Performed as Data Architect/Data modeler on ACA CDR (Affordable Care Act Customer Data Repository) project and supported three medium size data models.

Performed as data architect/data modeler on IRS RRP (Revenue Review Program) TS1 effort:

Maintained RRP physical data model consisting of over 1300 tables and over 58,000 columns.

Maintained synchronization between IDA physical data model and Greenplum database.

Standardized data names’ abbreviations.

Ensured that new data structures aligned with IRS corporate data standards.

Data Modeling tool: IDA 7.6 (IBM Infosphere Data Architect)

Developed and tested conversion scripts to move data from Oracle to PostgreSQL utilizing PL/pgSQL.

Development tool: pgAdmin III 1.16.1

Target database: GreenPlum based on 8.2 15 PostgreSQL server.

May 2009

May 2012 Senior Engineer with Guident Technologies on the following projects:

U.S. Export-Import (EXIM) Bank

Performed as a member of a Master Data Management (MDM) software evaluation team.

Data Modeling tool: IBM Rational System Architect 11.4.1.1

D.C. Courts Data Warehouse Data Modeler

Analyzed requirements and developed logical and physical dimensional data models for various

subject areas.

Data Modeling tool: Embarcadero ER/Studio Data Architect 8.5

Administrative Office of U.S. Courts - Data Warehouse Data Architect/Data Modeler

Laid out the groundwork for an integrated data warehouse from three legacy stove-piped data marts.

Identified conforming dimensions and tables.

Elicited requirements from the business users.

Using SQL, profiled production data and reverse-engineered business systems processes.

Collaborated with users and business analysts to validate and verify new requirements.

Analyzed legacy documents.

Supported business analysts to gain understanding of the legacy systems processes.

Created a logical and physical data model and DDL for Criminal Proceedings Program data mart.

Created a logical and physical data model and DDL for Adversary Proceedings Program data mart which was successfully implemented.

Created data dictionaries.

Created ETL outline and workflow diagrams to load the above mentioned data marts.

Defined reference tables, dimension tables, fact tables, various bridge tables and ETL tables.

Defined and created star schemas.

Created data tables and scripts to test ETL implementation and assessed tests results.

Data Modeling tool: Embarcadero ER/Studio Data Architect 8.5

Data Analysis and Profiling tools: AGS ER Studio 6.5.

Business Objects Data Integrator 11.7.

U.S. Export-Import (EXIM) Bank - Data Architect

Analyzed legacy source systems for the data warehouse modernization project:

Reverse-engineered and documented EXIM AS-IS data architecture utilizing OMB FEAF DRM reference models

Inferred and built logical data models from legacy documents and diagrams.

Created conceptual level data models.

Identified, created, and maintained DRM (Data Reference Model) subject areas.

Identified logical primary/foreign key relationships in source legacy systems.

Mapped business processes to subject areas.

Gleaned available metadata in legacy Adabas Natural documentation (about 10,000 attributes’ definitions), developed VBA Excel scripts to restructure metadata, and imported restructured metadata into Enterprise Architecture DRM.

Documented business processes in BPMN 1.1 format.

Customized, maintained, and trouble-shot Enterprise Architecture metadata repository by developing and utilizing USRPROP file scripts.

Enterprise Repository: IBM Rational System Architect 11.3 (Now UNICOM System Architect).

October 2006

April 2009 Webworld Technologies

NRC (Nuclear Regulatory Commission) – Data Architect/Data Modeler/Process Modeler

Documented NRC AS-IS enterprise architecture utilizing OMB FEAF reference models:

Created enterprise data and process models from the existing legacy documentation.

Defined database naming standards for logical and physical schemas.

Created context diagrams and data dictionaries for selected baseline systems.

Customized Telelogic System Architect encyclopedias to NRC Enterprise Architecture specifications utilizing USRPROP scripting.

Maintained various metadata in Telelogic System Architect.

Enterprise Repository and Modeling Tool: Telelogic System Architect 10.4. (Now

UNICOM System Architect).

Data Modeling tool: ERwin 7.2.

October 2002

May 2006 Consultant with Spherion on the following projects:

IFC (International Finance Corporation, the World Bank Group) - Data Architect/

Data Modeler/Process Modeler

Provided support for a number of new development and modernization efforts.

Gathered user requirements and wrote use cases.

Conceptualized, designed and developed data models.

Using SQL, profiled production data for various anomalies.

Created and maintained data dictionaries.

Created SQL DDL to generate new database schemas and enhanced existing ones.

Designed database views.

Created plans to migrate/convert legacy data into the new schemas.

Designed parts of ODS (Operational Data Store) for the data warehouse and normalized the data model to the 3NF (Third Normal Form).

Provided data modeling support for various post-implementation activities.

Worked with off-shore developers in India on database schema related issues.

Additionally, developed the following corporate artifacts:

Corporate Process Model

Created corporate-wide systems diagrams, data flow diagrams, and supporting

documentation.

Corporate Data Model

Created assigned areas of the conceptual Corporate Data Model (CDM):

Created entity level CDM for assigned subject areas.

Created Primary Key level CDM for assigned subject areas.

Mapped CDM entities to their respective source systems and user systems.

Mapped conceptual CDM to logical and physical data models.

Maintained assigned CDM subject areas to reflect ongoing changes in underlying systems under development.

Data Modeling tool: ERwin 4.1.

Process Modeling tool: MS Visio.

Data Analysis tool: Toad

Between 1985 – 2002 performed as Mainframe COBOL programmer, analyst, and data modeler on a number of projects in the greater Washington DC - Baltimore metropolitan area.

SUMMARY OF TOOLS EXPERIENCE

Erwin, Embarcadero E/R Studio, BizzDesign 4, IDA (IBM Infosphere Data Architect), IBM System Architect (UNICOM today), SQL, Oracle SQL Developer Data Modeler, SQL/PL, MS Office, some familiarity with Power BI.

Contact this candidate