SUMMARY

• Data Architect experienced in all phases of Data Management and Data Warehousing.
• From the development and implementation of Data Marts and Operational Data Stores through full Enterprise Data
• Warehouse designs. Data model development from Conceptual to Logical and finally to Physical and DDL creation.
• Exceptional analytic and troubleshooting skills. Knowledgeable in financial, medical, and manufacturing environments.
• Team leader adept at coaching and mentoring.
• Equally comfortable working with ETL developers as with the user community.
• Strong communication and interpersonal skills which contribute to the successful and on time delivery of projects.

TECHNICAL SKILLS

Hardware Platforms and Databases: Unix - Lynx - Confidential Servers - Confidential, Confidential - Netezza - DB2 - Oracle 12c - SQL Server 2017

Software, Languages and Applications: TOAD - PL/SQL - Datastage - XML - SOA - Cognos - Confidential Office, Perl - Hadoop - Visio - Lotus Notes - Infosphere Data Studio - SSIS - Talend

PROFESSIONAL EXPERIENCE

Senior Architect

Confidential, Whippany, New Jersey

Responsibilities:

• Development and Planning utilizing Agile Project Management Methodology
• Migration of Credit Card data from legecy databases developed in Oracle
• Analysis legacy data and table structure.
• Review reports and views to determine user usage and requirements
• Review available Erwin data models for accuracy.
• Reverse engineer any missing structures
• Review table and data relationships for accuracy
• Build initial Source to Target mapping document.
• Convert Erwin 9+ models to Erstudio 17.
• Review User requirements for the migration to Hadoop and update the Source to Target mapping document
• Create model for the new Hadoop tables residing in HDFS.
• Generate DDL and create tables using Hive.
• Complete the Source to Target mapping document to include any data transformations

Confidential, Tysons Corner, VA

Responsibilities:

• All Development utilizing Agile Project Management Methodology
• Maintenance and enhancement of the Legacy Data Warehouse
• Data integration of merged Credit Union data into the Enterprise Data Warehouse.
• Process included analysis of source data and creation of ‘Source to Target’ mapping documents.
• Building of Serviced Loan Datamart to hold report data received from various other banking institutions servicing the loans.
• Access to and analysis of the Fiserv database to map and retrieve data to load into the EDW. Included were building the data model, creating DDL scripts and building the physical tables.
• Review of XML database scripts from FICO to model and create a Data Lake to hold the credit data. NoSQL/Comn used for modeling and developing the lake in preparation for state of the art access tools.
• Team DBA supporting Development and QA environments. Work with other DBAs to update production.
• Database design and modeling using Embarcadero ER/Studio Data Architect 2016

Confidential, Rancho Cordova, CA

Senior Enterprise Data Modeler

Responsibilities:

• Set up of Confidential Infosphere Data Architect and Data Studio.
• Development of Best Practice steps for model development in IDA.
• Creation of initial Logical Data Model (LDM) through analysis of existing DB2 database tables and relationship.
• Work with Data Governance team to load the LDM into Confidential Information Governance Catalog (IGC).

Confidential, Windsor, CT

Senior Enterprise Data Modeler

Responsibilities:

• Team Lead of the ComPAS Data Migration Data Modelers.
• Validated that the ODS was being created to mirror the Confidential Insurance Application Architecture Model (IAA).
• Created source to target documents to load the ODS and Enterprise Data Warehouse.
• Worked with Guidewire’s Policy Center application and database to develop requirements to implement the system to a Data Lake environment utilizing HaDoop. The modeling tool was Erwin 9.3 w/Model Repository and data analysis was done using Trillium, Toad and Excel.

Confidential, Houston, Texas

Management Consultant

Responsibilities:

• Tools used were Erwin 8.1, Confidential Infosphere Data Architect, and Confidential Data Studio.
• Normalize and enhance an existing data model using industry standard 3NF concepts.
• Developed a Dimensional Model utilizing star schema constructs.
• Analyzed the data being received from and transmitted to various processing sites through XML transmissions.
• As DBA, I would create and load DB2 tables, as well as, controlling user access to various environments

Confidential

Data Architect

Responsibilities:

• Worked with user community to review, compare, and make changes to Confidential 's Health Care Provider Model (HCPM),
• Tool of choice was Confidential ’s Infosphere Data Architect.
• Created and delivered DDL to developers to build and load Netezza database.

WellPoint

Data Architect/Data Modeler

Responsibilities:

• Supplemental Employee on the Data Administration team,
• Modeling techniques included Dimensional Modeling, Semantic View Layer, and Metadata.
• Created join reports for the DBA, as well as, alter and create DDL for new/existing table/view updates.
• Involved in all aspects of the SDLC to develop the best solution for a project.
• Reverse engineered multiple DDL solutions into the modeling tool of choice, PowerDesigner 16.1 w/Model Repository.
• Developing data modeling standards for Confidential, DB2, and SQL Server as well as developing standards and requirements for Data Governance

Confidential, East Hartford

Data Architect/Data Modeler

Responsibilities:

• Data analysis of Advanced Diagnostics and Engine Management (ADEM) Oracle Transactional Application. Modeling of the Oracle database, using Erwin 8.1, containing a mixture of commercial and military engine performance data, to determine data structures and relationships.
• Develop normalized model to integrate the application into the Enterprise Data Warehouse.
• Participate on the Data Governance committee, to develop enterprise level data standards
• Assist in developing a user defined Semantic layer including user specific views.
• Work with the Military Engines area to integrate USAF Comprehensive Engine Management System (CEMS) data and various other Foreign Military engine usage and utilization data into the Enterprise Data model.

Confidential, Quincy, MA

Data Analyst/Data Modeler

Responsibilities:

• Data Analysis to determine Source-to-Target requirements, data transformation rules, and initial development effort determination.
• Data Model development/updating using ERwin. Data relationships determinated and added to model. Build indices, primary, alternate, foreign and secondary ( Confidential ).
• ETL spec developed using Source-to-Target documents and data transformation rules.
• Generate and test DDL to CREATE/ALTER tables.
• Build and test all macros and views before turning them over to the DBA group.
• Work with developers to insure proper creation and promotion of tables, views, and procedures.

Data Analyst

Hartford, CT

Responsibilities:

• Analysis of multiple “Source System” data sources developing POP (Population) Specs,
• Develop Process Flow diagrams using Visio and Source System Data Analysis documents using Excel and Word.
• Model changes (using ERwin) as needed for new attributes added to existing entities in both the ODS and the Warehouse.
• Creating Powerpoint presentations of models for team walkthroughs.
• Data Analysis was done using UDB, Evoke, Excel, and Access.