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 projects I’ve concentrated on Relational Data Modeling (both Logical and Physical), Dimensional Data Modeling (STAR), OLTP, Data Integration/Consolidation, Business Intelligence, Meta Data Definition/Management, and Data Mart/Decision Support Systems.

SPECIALIZED EXPERIENCE:

MODELING TOOLS/ METHODOLOGY: Power Designer, CA Erwin (all versions including Work Group Edition/Model Mart), E/R Studio Suite, Popkins System Architect, Oracle Designer, and Visio. Kimball Data Warehousing Methodology and Inmon (Information Factory and Corporate Data Model). Len Silverston Universal Data Models, NCR Teradata FS - LDM and IBM IAA and IIA (Insurance Application Architecture) Industry Data Models. Confidential, DML, XML Creation/Management and UML. Data Visualization Software, SharePoint Team Collaboration set-up.

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

EXPERIENCE:

Confidential

Data Modeler

Responsibilities:

• Create Logical and Physical Data Model to support the reporting for the Dodd/Frank Regulatory Rules.
• Create Data Dictionary and various Data Model reports.
• Map source data to a normalized (3rd normal form) target Data Warehouse -- based on the Teradata FS-LDM. Extend the Universal Data Model where needed, create Source to Target ETL documents, Confidential and test both Confidential and Transformation logic.
• Create and manage physical tables in DEV and move to SIT. Power Designer and Oracle.

Data Modeler

Confidential, Arden Hills, MN

Responsibilities:

• Designed a multi-channel marketing Data Store that allows the client to track rewards program usage (earned and spent).
• Created source-to-target ETL mapping, generate Confidential and run in the development environment.
• Confidential and Confidential and Teradata.

Confidential

Data Modeler

Responsibilities:

• Designed a Data Store and Data Mart ( Confidential and Power Designer) for the Confidential reporting requirements (using the Teradata FSLDM (financial service logical data model)).
• Physicalized per the Oracle target database, ETL source to target mapping and all your typical tasks involved.

Confidential, SAN JOSE, CA

Data Architect/Data Modeler

Responsibilities:

• Designed an Application Database that integrates the People Soft CRM with other transactional data into a Data Warehouse.
• Model targets based on XML and API Data Feeds, analyze and reverse-engineer XML files.
• Confidential Target designs using Confidential Case Tool (Create scripts in Confidential to generate all Confidential, manage Data Models, Data Dictionary and all artifacts).

Confidential, CHICAGO, IL

Data Architect/Data Modeler

Responsibilities:

• Data Warehouse integration of SAP source data with other OLTP data sources.
• 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 Teradata. Includes Confidential Scripts to automatically generate Confidential and VB Scripts to automatically import and create the data model from an MS Excel spreadsheet.
• Create Confidential (File Interface Agreements) using XML. 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 Case Tool, Confidential and Netezza databases.

Confidential, PHILADELPHIA, PA

Data Modeler

Responsibilities:

• Designed a Quality Patient Care ODS and Data Mart to track patient infections for the 3 hospital Confidential State affiliated group.
• Patient Encounters, Locations, Services, Outcomes, Patient - Diagnosis, Procedures and Infection History.
• Used to track and report on Patient Infection History.
• Metadata Management and Data Governance planning. Confidential /Oracle.

Confidential, NYC, NY

Data Architect/Data Modeler

Responsibilities:

• Created Campaign Management Data Model designs ( Confidential ) 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 (Dimensional STAR Schemas), XML, Confidential and execute Confidential on both Netezza and Confidential databases.

Confidential

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 XML, Confidential and Data Models and run Confidential on Confidential platform.

Confidential, ATLANTA, GA

Data Architect

Responsibilities:

• Data integration multiple source data (including Microsoft CRM), SAP into the target Data Warehouse design and create multiple data marts.
• Design an ADM (Analytical Data Mart) for the My Coke Rewards 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 and Confidential for the reporting mart with Oracle source data. Confidential Case Tool.

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 (STAR Schema) design at multiple grains to support various reporting capabilities. Included Data Profiling, Data Analysis, Source-to-Target ETL mapping and requirements gathering/Definition.
• Confidential 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.
• Confidential 7.3 and Oracle/Netezza for both the ODS (Operational Data Store) and ADM (Analytical Data Mart) using Confidential Case Tool.