PROFESSIONAL SUMMARY:

A senior 'Enterprise Level' Data Modeler/Architect. Extensive knowledge base of Database Design Methodologies and Tools. I possess the formal training, Large and Small Corporate Business Analysis experience required to manage and support complex projects. In recent years I’ve concentrated on Relational Data Modeling (both Logical and Physical), Dimensional Data Modeling (STAR), OLTP, Data Integration/Consolidation, Meta Data Definition/Management, and Data Mart/Decision Support Systems.

SPECIALIZED EXPERIENCE:

MODELING TOOLS/ METHODOLOGY: Power Designer, CA Erwin (all versions)/Model Mart, E/R Studio Suite, Popkins System Architect, Oracle Designer, and Visio. Kimball Data Warehousing Methodology and Inmon (Information Factory). Silverston Universal Models, NCR Teradata FS - LDM and IBM IAA and IIA (Insurance Application Architecture).

DATABASES: Teradata, Netezza, Confidential, Oracle, SQL Server, MYSQL, Sybase, DB2 UDB.

EXPERIENCE:

Confidential, CHICAGO, IL

Data Architect/Data Modeler

Responsibilities:

• Design/Extend an existing ADM (Analytical Data Mart) for the Confidential Point Program to include new subject area data.
• Create ETL Source to Target Mapping Document and all other relevant deliverables/artifacts.
• Reverse Engineer the multiple sources from Netezza with the new design modeled for Confidential .
• Includes Erwin Scripts to automatically generate DDL and VB Scripts to automatically import and create the data model from an MS Excel spreadsheet. Work with the Business Analysts to create the spreadsheet that includes all tables, fields, lengths, data types, and definitions.
• These automated processes save considerable amounts of time and cost.

Confidential, NYC, NY

Data Architect/Data Modeler

Responsibilities:

• Created Campaign Management Data Model designs for both Consumer and Healthcare Provider Promotional Marketing Systems.
• Provide an Enterprise Marketing Platform to service all Global markets.
• Created and Managed ODS (Operational Data Store) and Reporting Data Models, DDL and execute DDL on both Netezza and Confidential databases.

Confidential, NY, NY

Data Modeler

Responsibilities:

• Design an ADM (Analytical Data Mart) for Campaign Management, Customer Management and Reporting.
• Included data profiling, source to target mapping and business requirements gathering in support of the project life-cycle.
• Create and Manage DDL and Data Models and run DDL on Confidential platform.

Confidential, ATLANTA, GA

Data Architect

Responsibilities:

• Design an ADM (Analytical Data Mart) for the Confidential Point Program.
• Designed an extensible reporting mart to easily report on all metrics across the rewards program (points earned and spent by Site, Member, Segment, Programs and Awards).
• Create ETL Source to Target Mapping Document and all other relevant deliverables/artifacts.
• Utilized Netezza for the reporting mart with Oracle source data.

Confidential, NYC, NY

Data Architect

Responsibilities:

• Extensive Data Model Designs to support BI for Healthcare Customer Relationship Management Systems, Campaign Management Systems, and Sales and Marketing Reporting Systems (Analytical Data Marts).
• Designed a Relational 3rd Normal Form ODS (Operational Data Store) and a Dimensional Data Model design at multiple grains to support various reporting capabilities.
• Included Data Profiling, Data Analysis, Source-to-Target ETL mapping and requirements gathering/Definition. Erwin 7.3 and Oracle/Netezza for both the ODS (Operational Data Store) and ADM (Analytical Data Mart).

Confidential, King of Prussia, PA

Data Architect/Data Modeler

Responsibilities:

• Designed a 3rd normal form ODS (Operational Data Store) and a Dimensional ADM (Analytical Data Mart) to load 3rd Party Vendor Data and Confidential Data in support of Campaign Management, Customer Management and Reporting.
• Work with multiple Vendors, create source-to-target ETL specs.
• Erwin 7.3 and Oracle/Netezza for both the ODS (Operational Data Store) and ADM (Analytical Data Mart).

Confidential, Collegeville, PA

Data Architect

Responsibilities:

• Designed (Data Modeling in both Relational (3rd normal form) and Dimensional (STAR) Data Modeling of a Master Data Management infrastructure to support relationship management activities related to Health Care Professionals and Retail Consumers.
• Included an ODS and Reporting Data Mart to support Campaign Management, State Regulations, Sales and Marketing.
• Erwin 7.2 and Oracle/Netezza for both the ODS (Operational Data Store) and ADM (Analytical Data Mart).

Confidential, Danbury, CT

Data Modeler

Responsibilities:

• Implementation/Extension of the Teradata FS-LDM (Financial Services Logical Data Model). Model multiple new LOBs (Financial data) into existing Financial Services EDW, with modifications to existing and new entities.
• Analysis, Design, and ETL implementation of BASEL II and other Regulatory Requirements. Work with Business to document ETL Specifications/Transformations and Business Objects Report Developers in designing reports.
• Data Modeling of the UCM (Universal Customer Management Database) extension into the EDW (Enterprise).
• Pull Customer data from multiple Lines of Business in support of Master Data Management.
• Power Designer, Teradata Server V2R. 06.02.01.16 , SQL Assistant 7.2 and Teradata Data Profiler.

Confidential, Dearborn, MI

Data Architect

Responsibilities:

• Evaluated NCR Teradata Manufacturing Logical Data Model (3.0) Reviewed numerous Use Cases, Activity Diagrams, UML Models, and ER Diagrams.
• Create EDW Strategy/Roadmap to include Master Data Management Planning.
• Data Modeling Design of a 'Common Entities' LDM to consolidate Master Data from multiple sources and allow for data sharing across the organization.
• Used Oracle Designer 9i and Rational RequisitePro.

Confidential, Baltimore, MD

Consultant Database Design (Data Team Lead)

Responsibilities:

• Reverse-Engineer numerous existing database schemas, GAP Analysis, and create Informational Data Models explaining the existing business, including processes, Business Rules, Rules/Decision Logic, and ETL and Data Flows.
• Created Visio Diagrams depicting the AS IS and TO BE data architecture for an Enterprise Consolidation/Integration Data Store.
• Completed the OLTP Consolidation and Data Warehouse/Data Mart Designs (Data Modeling).
• Manage all staffing, tasking and liaison between Project Teams.
• Managed a team of 13 Contractors (3 Senior Data Modelers, 2 ETL specialists, 2 Data Analysts, 3 Business Intelligence specialists and 3 Senior Oracle DBAs).
• Erwin r7 version, Sunopsis ELT Tool, Oracle (ODS) and Netezza (ADM).

Confidential, Scottsdale, AZ

Consultant Data Warehouse Design Architect

Responsibilities:

• Designed a Membership Rewards Program (Enrollment).
• Included multiple STAR Schemas at many levels of granularity to support a new system allowing for Provisioning Current.
• SAP Source Data had to be loaded/modeled into various targets.
• Power Designer and Teradata.

Confidential, Tampa, FL

Consultant Data Warehouse Modeler/Architect

Responsibilities:

• Relational and Dimensional Model Design at both the Enterprise Data Warehouse and Data Mart levels.
• Data mapping and ETL design, Data Standardization and Data Modeling rule and procedures development and design.
• Develop procedures and controls for Model Management, manage all changes to the Enterprise Data Model (manage 6 other modelers).
• Developed and managed naming conventions and standards, change control procedures.
• Integration modeling of numerous source system tables into the Enterprise data model. Included mapping source to targets, SME and end-user interviews and meeting facilitation for requirements gathering and attribute definition and documentation.
• Completion of a Visio diagram showing all Legacy File (source) to target (Enterprise Model) mappings and business rules.
• Data analysis/Verification/Testing/View Creation using Teradata Administrator 6.0 and Teradata SQL Assistant (formerly known as Queryman).

Confidential, Richmond, VA

Consultant: Database Design and Development

Responsibilities:

• Design and Model a Fraud Detection Database that allows the creation of Programs and Processes that make up a Defense against Fraud.
• The database was designed in an extensible manner to allow for an unlimited amount of variables used in the detection of Credit Card Fraud. Creates a Logical and Physical Model, DDL and Oracle database, and loaded with sample data using Quest software.
• Created a model design, and assisted with design documents.
• Terradata back-ends.
• Erwin OLTP models and Rational Rose (RUP), RequisitePro and Use Cases.

Confidential, St.Louis, MO

Consultant: Data Architect

Responsibilities:

• Design / Model various OLTP systems using CA Erwin, Model Mart and Terradata.
• Completed a broker Bonus and a Broker Commission System data model design and modeled extensions to the Enrollment Use Cases.
• Facilitated requirements gathering sessions, design databases to 3rd normal form, facilitate model walk-through with clients, create Physical Models and DDL, and assist in Capacity Planning, System test and the move to production. Moved repositories and models from CA Erwin case tool to Sybase Power Designer.
• Created an automated conversion process to compare before and after models.
• Created an abbreviation database to store standard abbreviation naming standards, table prefixes, application prefixes. Teradata and DB2 DBMS.

Confidential, Miami, FL

Consultant: Data Warehouse Design / Informatica Administrator / Business Objects Administration

Responsibilities:

• Create Informatica procedures and controls.
• Change control management, Power Plugs Model procedures and standards for creating Source / Targets, and all documentation.
• Create and automate Session Runs, Migrate mappings, folders, and sessions between Development, Staging and Production.
• Used both NT and UNIX. Mentor Junior Modelers in Dimensional Data Warehouse Design and Relational Design (OLTP).
• Create SAP BW Info cubes. Power Designer, SQL Server 2000 and Oracle 8i. Back-up Business Objects Administration.

Confidential, Tampa, Fl

Data Warehouse Architect Lead

Responsibilities:

• Lead the design of numerous Dimensional (STAR SCHEMA) models, Requirements Gathering / Facilitation, Transfer data between SQL Server and Oracle, using DTS Packages (Data Transformation Services).
• Generate DDL using Erwin 4.1, Version Control using Model Mart.
• Create and manage SQL Databases, design and manage Molap Cubes. Designed a Reporting database to allow customers to view and compare Current Financial Details to Past and Future Budget details.
• Included a relational model for the staging area, and a Dimensional Model to feed the SQL Server based Cubes.
• Created all source to target mapping documents to assist Informatica ETL Team and confirm data was loaded correctly.
• Created multiple STAR Schemas, consisting of Conformed Dimensions to enable Customer Reporting of Demographics, Geographic Locations, Programming / Viewing Selections and other information pertaining to TV Programming / Ratings. Sybase Power Designer.