SUMMARY:

To obtain a Senior Database Designer/Architect/DBA position with a progressive organization that might benefit from my combined Data Design and DBA experience.

TECHNOLOGIES:

• Oracle 8i, 9i
• Sun Solaris
• Windows NT
• Visual Basic
• PL/SQL
• Transact - SQL
• UNIX
• UNIX Shells
• Erwin/ModelMart
• ER/Studio
• SSMS
• DBArtisan
• DBA Studio
• Enterprise Manager
• Toad
• MVS Mainframe
• COBOL
• IDMS

WORK EXPERIENCE:

Confidential, Philadelphia, PA

Data Architect

Responsibilities:

• Responsible for the development of a Dimensional Data Warehouse sourced from the existing 'Data Lake' - a vendor supplied structure consisting of OLTP and quai-dimension structures.
• Major goals established with the new EDW were 'BI-readiness' meaning ease of use for adhoc reporting for Business Analysts as well as Developers; better performance for Aggregation type queries; adherence to Confidential naming and other database standards; and clear business definitions of database objects.

Confidential, Philadelphia, PA

Data Architect

Responsibilities:

• Responsible for development of an Operational Data Store for Claims as a replacement to the current datastore and sourced from the HIPAA 837 transactions for Professional, Institutional, and Dental Claims.
• Lead the facilitation of requirements meetings, prepared attribute definitions, developed the source-to-target mapping for all elements.
• Another major task was the development of Database Standards and Guidelines as well as a new workflow for developers so that all structure changes go through Data Architecture.
• Made use of Erwin 9.6 in conjunction with SSMS (Sql/Server Management Studio) to design and implement schema.

Confidential, Philadelphia, PA

Data Architect

Responsibilities:

• Responsible for development of a new source into the CORE Active Data Warehouse ( Confidential ) for the Member, Enrollment, and Product Domains based on a feed from Confidential Administrators ( Confidential ).
• Lead the facilitation of requirements meetings, prepared attribute definitions, developed the source-to-target mapping for all elements, and added new entities to the Confidential Data Model using Erwin 9.6 as well as SQL/Server Management Studio.

Confidential, Philadelphia, PA

Data Architect

Responsibilities:

• Responsible for creation of an Enterprise Data Model (Logical and Physical) of the Account, Party, and Product Domains.
• Design and development of a SQL/Server SSIS package to load data from a vendor product into the Enterprise Account Database.
• Enhancement and enforcement of Database Standards and Best Practices via formal reviews of requests for new structures and structure changes in Oracle and SQL/Server databases under control of BGIM.
• Application DBA for deployment of structure changes in the Development Databases as well as SQL and database tuning of Application Code.
• Made use of Sybase PowerDesigner for modeling as well as PL/SQL Developer for Oracle implementation and SSMS (SQL/Server Management Studiio) for Sql Implentation.

Confidential, Philadelphia, PA

Data Modeler

Responsibilities:

• Responsible for a conversion and partial re-design of a DB2/LUW Document Workflow database supporting the Underwriting Confidential Project including development of some new structure, creation of logical subject areas, filtering of retired tables, and corrections/enhancements to the model such as missing FK constraints, FK Indexes, and performance indexes.

Confidential, Philadelphia, PA

Data Modeler

Responsibilities:

• Responsible for enhancements as part of the Biv2 Project and SQL/Server 2008 Data Warehouse including source-to-target mapping, and the reconciliation of the existing mapping documents of source-to-stage and stage-to-target, which were found to have major discrepancies.
• This entire Biv2 project was originally scheduled for 6-8 months but was truncated due to cancelation of funding.

Confidential, Malvern, PA

Data Modeler

Responsibilities:

• Responsible for analysis, design, and development of various OLTP Physical Data Models for implementation on DB2, Oracle, and SQL/Server platforms.
• Also contributed to refinement and development of existing Physical Design Standards and Guidelines.
• Scope includes minor changes to several dozen existing databases as well as brand new structures for new Applications, and precise DDL generation of changes for a DBA to execute.
• MetaData Management in the form of Business Term and DataSet creation and maintenance in EMM (Enterprise MetaData Manager) with close interaction with BSAs and other Business Reps.

Software Summary: Erwin 8..2/ModelMart, SQL/Server 2005, PL/SQL Developer, SQL/Server Management Studio

Confidential, Wilmington, Delaware

Data Modeler

Responsibilities:

• Solely responsible for creation and maintenance of all Transactional (OLTP) Data Models working directly with Scrum Teams in Sprint Planning and Story Grooming sessions.
• One of several Data Warehouse Modelers responsible for defining Dimensional Models for DW inclusion and developing the ETL Source System Mapping and Transformation for loading.
• Also work with the DBA team on Query Performance Tuning methods including Materialized Views, Indexes, and SQL Rewrites.
• Dimensional Models were designed with Erwin/ModelMart as simple Star Schemas based on Data Profiling of Source Systems where measures were isolated as Facts and Classifications isolated as Slowly Changing Dimensions.
• ETL Maps were then used to detail Transfomations.

Software Summary: Erwin 7.2/ModelMart, Oracle 10g, PL/SQL Developer.

Confidential, Malvern, Pennsylvania

Data Modeler

Responsibilities:

• Responsible for creating all of the Physical Data Models for the SOARIAN Data Alignment project which is an ongoing project over several years whose purpose is to ‘align’ or create a common Enterprise Data Model of all of the structures that make up the SOARIAN sweet of medical software.
• The Physical models are developed using Erwin/ModelMart and are based on Analysis Class Models created by the business analysts on the team.

Software Summary: Erwin 7.2/ModelMart, SQL/Server 2005.

Confidential, West Chester, Pennsylvania

Data Modeler/DBA

Responsibilities:

• Ongoing logical development of the Enterprise Product data model that supports all of the live Show Products and their dynamic Pricing over time.
• Complete responsibility for the Development and QA SQL/Server databases including logical model maintenance and schema development and support.
• Performance tuning for the Production SQL/Server instances including Stored Procedure rewrites as well as Optimizer Plan Analysis to enable optimal index coverage for all frequently used queries of large tables.
• Logical Data Model support for change requests to all Enterprise and Legacy data models including DDL scripting for Oracle, DB2, and SQL/Server.

Confidential, Mount Laurel, New Jersey

Contract Oracle DBA

Responsibilities:

• Working with IT Analysts, responsible for the enhancement and development of numerous PL/SQL packages and procedures to enable the replication of Production Mortgage Accounts to
• Development and to allow the full life-cycle testing of a Mortgage Account.