Joseph V. Contardo

*** ***** *****, ********, ** 06410

203-***-**** (Cell)

adwi3v@r.postjobfree.com

Skype: adwi3v@r.postjobfree.com

LinkedIn: www.linkedin.com/in/joseph-contardo-4aa13336

Data Architect/Senior Data Modeler

Data Architecture Agile Project Management Methodology Enterprise Data Modeling

Data Base Administration Infosphere Information Governance Catalog Data Integration

Erwin w/Model Repository Enterprise Data Warehouse Team Lead/Project Management

PowerDesigner w/Model Repository System Integration Data Lake/NoSql/Comn

IBM Infosphere Data Architect Star/Snowflake Dimensional Modeling SQL Development/Tuning

Inman/Kimbal Modeling ER Studio w/Repository Healthcare Payer/Provider Systems

OLTP/OLAP Requirements Gathering/Data Profiling/Mapping Data Dictionary

PROFILE

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.

Hardware Platforms and Databases

Unix – Lynx – IBM Servers - Microsoft

Teradata – Netezza - DB2 – Oracle 12c – SQL Server 2017

Software, Languages and Applications

TOAD – PL/SQL – Datastage – XML – SOA – Cognos - Microsoft Office

Perl – Hadoop – Visio – Lotus Notes - Infosphere Data Studio – SSIS

Professional Experience

Cognizant 07/2016 – Present

Technology Solutions Limited

Senior Data Modeler

Client: JP Morgan Chase & Co., Wilmington, Delaware 19803

Member of the Marketing Analytics Platform (MAP) and AbInitio Semantic teams.

Agile Project Management Methodolgy used to control workflow.

Erwin DM Rel. 2020.R1.SP1 Workgroup Edition used for data modeling tasks.

SQL Server and Teradata SQL Assistant, Version 16.20.0.8 utilized for table and data validation.

Team responsible for the migration of Oracle and Greenplum tables and data to SQL Server and Teradata.

Responsibilities included review of business requirements, physical modeling of tables, generating DDL and Grants. Logical modeling of entities and attributes, including complete definitions for each. Collaboration with the business users needed when creating definitions.

After physical model is complete and artifacts created, an Agile Epic is created to notify DBA to create the table(s).

Joseph V. Contardo

Page Two

Professional Experience Continued

Client: Barclays, Whippany, New Jersey 07981

Development and Planning utilizing Agile Project Management Methodology

Migration of Credit Card data from legecy databases developed in Oracle

oAnalysis legacy data and table structure. Review reports and views to determine user usage and requirements

oReview available Erwin data models for accuracy. Reverse engineer any missing structures

oReview table and data relationships for accuracy

oBuild 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

Client: PenFed Federal Credit Union, Tysons Corner, VA 22102

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

VSPGlobal, Rancho Cordova, CA 95670 02/2016 – 04/2016

Senior Enterprise Data Modeler

Set up of IBM 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 IBM Information Governance Catalog (IGC).

Joseph V. Contardo

Page Three

Professional Experience Continued

The Hartford, Windsor, CT 06095 06/2015 – 2/2016

Senior Enterprise Data Modeler

Team Lead of the ComPAS Data Migration Data Modelers.

Validated that the ODS was being created to mirror the IBM 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.

IBM, Houston, Texas 770**-****-**/2012 – 04/2015

Management Consultant

Client: Exxon/Mobil SpeedPass+ 08/2014 – 04/2015

Data Architect/Data Modeler/DB2 DBA

Tools used were Erwin 8.1, IBM Infosphere Data Architect, and IBM 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

Client: Tenet Health Systems

02/2014 – 07/2014

Data Architect/Senior Data Modeler

Worked with user community to review, compare, and make changes to IBM's Health Care Provider Model (HCPM),

Tool of choice was IBM’s Infosphere Data Architect.

Created and delivered DDL to developers to build and load Netezza database.

Client: WellPoint

08/2012 – 12/2013

Data Architect/Data Modeler

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 Teradata, DB2, and SQL Server as well as developing standards and requirements for Data Governance

Joseph V. Contardo

Page Four

Professional Experience Continued

Pratt & Whitney Engine Services Inc. 08/2011 – 07/2012

East Hartford, Connecticut

Data Architect/Data Modeler

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.

Harvard Pilgrim Health Care 10/2005 – 08/2011

Quincy, MA 02169

Data Analyst/Data Modeler

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 (Teradata).

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.

ING USFS 1/2005 – 6/2005

151 Farmington Ave., Hartford, CT

Data Analyst

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.

Joseph V. Contardo

Page Five

Education

Dataversity

Online NoSQL/Comn Courses

IBM Global Institute

Datastage, Business Intelligence, Business Objects

DAMA

Zachman Framework

Teradata Corporation

SQL, Advanced SQL, and Database Architecture

New Horizons Computer Learning Centers

Microsoft .NET and SQL Sever

Mercy College, Dobbs Ferry, NY

Bachelor of Science – Computer Science

Contact this candidate