OBJECTIVE:

Looking for a position in a Data Management Group where I can fully utilize my years of Data Architecture, Data Modeling, Data Mining, Model Mart Administration, Problem Solving and Requirements Definition skills.

SUMMARY:

• An experienced IT professional (the go to guy for just about everything) with full life cycle project experience working on diverse project teams, with over twenty years of experience in Data Warehousing (OLAP), as well as Third Normal Form Relational database (OLTP) designs as an Architect, Analyst or Data Modeler.
• Influential in defining project scope, gathering requirements from business users, system design (functional and technical specifications), ETL specifications, system testing, integration testing.
• Familiar with both Inmon's 3rd normal form and Kimbal's conformed dimensions approach to data warehousing.

DATABASES AND TOOLS:

Data Modeling Tools: Erwin, Model Mart, Power Designer, ER Studio

Databases: Teradata, Oracle, Sybase, DB2, Netezza

Query tools: Teradata SQL Assistant, TOAD, Oracle SQL Developer

PROFESSIONAL EXPERIENCE:

Data Warehouse Architect/Modeler

Confidential

Responsibilities:

• Consulting Senior Data Architect where I led the design of the Teradata Data Warehouse for the MISACWIS Project dealing with Child Welfare data.
• Trained State Staff modelers.
• Worked with existing team to create standards that work for the organization.
• Database object naming.
• Abbreviations.
• Model names.
• Maintained three models with Erwin Data Modeler, One each for Staging, ODS and Marts.
• Created a Logical/Physical model of the MISACWIS Oracle application model.
• Created a Logical/Physical model for the 3rd Normal Form MISACWIS Teradata Data Warehouse and the Data Mart.
• Work with Reporting Team to create Data Mart tables.
• Data profiling with Toad and Teradata SQL Assistant.
• Participate in Use Case sessions with BAs and Business Owners.
• Introduced and implemented the Party model and other universal modeling methods based on past experience, with Teradata’s FSLDM (Financial Services Logical Data Model).
• Work with ETL team to map data from the Oracle front end database to the Teradata Data Warehouse.
• Create all DDL and DML for changes coming in from the source database and for new Data Mart tables for reporting.
• Acted as the Erwin Model Mart Administrator.
• Handled all Erwin and Model Mart upgrades.
• Publish Models in PDF format for developers to access.
• Metadata - Gathering metadata definitions to create a data dictionary.
• Published Data Dictionaries.
• Published documentation in Sharepoint that helps the end users find information in the Data Warehouse.
• Reverse Engineering existing databases using Erwin.

Data Modeler

Confidential, Miami, FL

Responsibilities:

• Consulting Senior Data Architect where I was heavily involved in the redesign of an AS 400 based OLTP legacy system to a new Service Oriented Architecture (SOA) Oracle based system.
• Worked with existing team to create and implemented modeling standards that work for the organization.
• Created a logical model of the existing system.
• Data profiling using X-Analysis.
• Created Logical and Physical models for the new system.
• Participated in Use Case sessions with BAs and Business owners.
• Introduced and implemented the Party model.
• Worked with ETL team on mapping data from the AS400 to the "New" system in Oracle.

Confidential, Riverview, IL

Data Architect/Modeler

Responsibilities:

• Logical and Physical ODS and Mart data modeling with ERStudio in a Teradata environment.
• Data Mapping for ETL requirements
• Data profiling using Teradata SQL Assistant.
• Model reviews.

Data Architect

Confidential, Danbury, CT

Responsibilities:

• Data Architecture
• Logical and Physical data modeling for the FSLDM and other Reporting projects that pull from the warehouse using ERwin in a Teradata Environment.
• Data mapping for ETL requirements.
• Data profiling using Teradata SQL Assistant.
• Model reviews.

Data Architect/Modeler

Confidential, Ft Lauderdale, FL

Responsibilities:

• Data Architect.
• Logical and Physical data modeling with ERwin in an MS SQL Server environment.
• Data Mapping for ETL requirements
• Model reviews.
• Model Mart Administrator.

Data Architect/Modeler

Confidential

Responsibilities:

• I functioned as the lead data modeler/architect to build marts that would allow reporting on the various information that came in from the ads that were pushed to client websites and to reverse engineer existing databases created in My SQL and redo the structures as needed to go into an Oracle 10G database.
• Logical and Physical data modeling, Reverse Engineering with ERwin in an Oracle/Netezza/My SQL environment.
• Data Mapping for ETL requirements.
• Architected the solution to have a Staging area, ODS and Marts.
• Modeled all environments from requirements.

Data Modeler/Life Cycle Analyst

Confidential

Responsibilities:

• Process Modeling with Websphere Business Integration Modeler.
• Logical data modeling with ERwin in a DB2/Oracle Environment.
• Validate process and logical data models with business subject matter experts.
• Define and enforce standards and conventions (definition, naming, abbreviation and meta data collection).
• Define and document Data Architecture roadmap.

Data Analyst

Confidential, Kansas City, Mo

Responsibilities:

• Consulting Data Analyst III at Confidential on a project to merge three different versions of a customer from three different installations of Siebel, into one enterprise version of Siebel 7.5.
• Data Modeling in an Oracle environment using ERwin.
• Data migration requirements gathering.
• Source to target data mapping.
• Architectural blueprints for documentation.

AVP

Confidential, St. Joseph, MO

Responsibilities:

• Performed data analysis for on customer back up loan processing files.
• Data modeling using Erwin in a MS SQL Server 2000 environment.
• Requirements gathering, both project-related and to gather metadata for the data dictionary.
• ETL transactions using Informatica Powercenter.
• Process Modeling - Modeled existing processes that take SAP data and move it to the Kadiri Total Compensation system using Visio.
• Gap Analysis - Identifying gaps in functional, technical specifications and actual implementations.
• Risk Identification - Identifying possible break points in the processes.
• Data mapping - Map the flow of data between PeopleSoft and various personnel systems.
• Metadata - Gathering metadata definitions to create a data dictionary.
• Modeled current architecture of existing personnel systems and proposing changes based on findings.
• Identified data throughout personnel systems that are prime candidates for centralizing in a data warehouse.

Data Analyst

Confidential, Overland Park, KS

Responsibilities:

• Logical and Physical modeling using PowerDesigner and ERwin for changes to existing projects and reporting.
• Created documentation for metadata repository for business and technical users.
• Risk identification for changes to supported systems.
• Data Mapping and ETL Specifications.
• Reverse engineered vendor supplied databases.
• Work as part of the Standards Team.
• Maintained a Siebel 6.0 Data model for the Sales Force Automation team.