SUMMARY:

• 10 years of experience of Oracle, Designing, Modeling, Developing and Administering databases in a variety of environments (Aerospace/ Defense, Mortgage, Payroll, Retail, Transportation, Medical Research, Cable and Telecommunications).
• DBA Development and Production experience with Oracle (RDBMS, Enterprise Manager, TOAD, PL/SQL).
• Hands on experience with toolsets including: ERwin 7.2/ModelMart, MySQL Workbench 5.2, PowerDesigner, ER/Studio, Oracle Designer, DBArtisan, Informatica 9
• Oracle DBA (Administered physical databases: Tables, Tablespaces, Indexes, Tuning, Stored Procedures, Functions, Installations, Upgrades, Patches, Forms and Reports)
• Tested Shareplex implementation for DR
• Developed, Tested, Implemented backups using RMAN
• Tool/ Methodology/ Standards oriented
• Logical and Physical Modeling for, among others, worldwide freight ( Confidential ), Confidential Force Exchange (AAFES) retail operations and wholesale/retail billing system for Confidential (US/South America/Europe)
• Data warehouse ETL support of raw,staging and production environments (Oracle materialized views, PL/SQL)
• OLTP background in Oracle (9i - 11g)

EXPERIENCE:

Confidential, Denver, CO

ETL/DW ANALYST

Environment: Oracle 11g, Informatica PowerCenter 9, Linux, Windows

Responsibilities:

• Interviewed users and gathered documented requirements for the State of Good Repair warehouse supporting OBIEE
• Interfaced with Confidential client to identify coding and key structures necessary to extract OLTP data to the warehouse
• Created tables and indexes to support transform/load processes
• Supported the Data Warehouse Architect in building warehouse Star Schema (Dimension and Fact tables)
• Developed ETL processes and Informatica transformations to support loading data from Confidential 's OLTP system to the new warehouse.

Confidential, Denver, CO

DATABASE CONSULTANT

Environment: Oracle 10g, ASM, RMAN, RHEL 6, MySQL Workbench 5.2 (Windows)

Responsibilities:

• Administered two Oracle production systems (LINUX OS admin, Oracle DBA/Forms/Reports)
• Implemented database backups (RMAN)
• Configured/maintained roles, grants, tables, indexes, views, tablespaces
• Utilized SQL for ad hoc and reusable queries, PL/SQL for stored procedures and triggers
• Produced data dictionary and ERDs of both Oracle databases
• Assessed & documented functionality of all Forms and Reports
• Provided technical assessment of all prospective vendor products
• Interviewed vendor technical in support of final vendor selection
• Developed ETL processes & formats for data migration to vendor environment
• Executed data extraction and transformation, forwarded data packages to vendor for loading
• Performed data quality analysis of vendor data using contractual acceptance criteria

Confidential, Denver, CO

Data Warehouse MODELER/ETL

Environment: Oracle 10g, RHEL/Windows, Cisco, ERwin 7.3/ ModelMart

Responsibilities:

• Designed and modeled data warehouse tables supporting the TSA's integrated hiring system
• Interfaced with Monster.com team and various governmental agencies to produce ERDs and Master Data Dictionary
• Created datamaps of data sources/target to support ETL development
• Developed PL/SQL and Materialized Views
• Coordinated ETL activities with development DBAs and project management

Confidential, Denver, CO

Oracle DBA/MODELER

Environment: Oracle 10g/ 9i, Windows 2003 Server, DBArtisan, ER Studio, TOAD, SharePlex

Responsibilities:

• Administered Oracle databases in Windows server environments
• Supported OLTP environment for mortgage loan processing
• Supported loan payment processing / portfolio transfers
• Received vendor software upgrades, validated in the test environment and promoted to production
• Tested SharePlex implementation for DR
• Documented configuration changes in configuration management system
• Investigated alternative server environments (AS400) using Application/Oracle configurations
• Modeled Oracle legacy database using ER/Studio

Confidential, Denver, CO

ORACLE DESIGNER/DBA

Environment: Oracle 10g/ 9i, ERwin, RHEL/ DELL

Responsibilities:

• Assessed the database, development, testing and quality control areas for improvement/corrective action
• Configured RMAN backups for production databases
• Administered Oracle production databases supporting web applications
• Created Oracle test environment for developing and testing web applications
• Documented database configurations (physical environment, data dictionary, data models)
• Developed testing/validation plans for new releases of eFit
• Authored disaster recovery, backup schedules and fail-over procedures

Confidential, Orlando, FL

ORACLE Developer/DBA

Environment: Oracle 9i, ERwin, Oracle Forms, Oracle Reports, HP-UX, HP servers, EMC2

Responsibilities:

• Supported application development via models and development database
• Assessed the database and configuration management environment for executive management
• Supported production OLTP environment ordering, inventory, shipping functions
• Interfaced with developers in application design, development and testing
• Developed ERDs and maintained the data dictionary
• Remotely administered production Oracle environment in Boston, MA
• Coordinated configuration changes (application upgrades and database modifications)
• Developed disaster recovery and fail-over plans

Confidential, Maitland, FL

ORACLE DBA

Environment: Oracle 8.1.7, ERwin, Veritas NetBackup, Solaris 2.6, SUN6500 servers, EMC2

Responsibilities:

• Documented existing system as ERDs and data dictionary using ERwin
• Administered Oracle database environments: development (FL), test (MA) and production (CO)
• Configured backups utilizing RMAN
• Administered Oracle database reporting environment (Business Objects)

Confidential, Melbourne, FL

ORACLE DeSIGNER

Environment: Oracle 8.1.7, Oracle Forms, Oracle Designer, Legato, SUN E3500, A5000 Disk Arrays

Responsibilities:

• Developed logical and physical models to support development of an Oracle data warehouse fed by theperational OO/ OLTP database system
• Developed and tested Advanced Queueing for processing transactions (CDC) between OO source and Oracle
• Supported promotion from development to production environment

Confidential, Maitland, FL

DATA MODELER

Environment: Sybase 11, PowerDesigner, UNIX

Responsibilities:

• Reverse-engineered Confidential legacy systems that feed the Chronos system providing corporate management the previous day's world-wide Confidential transactions and revenue at 8AM each morning
• Developed logical models based on the legacy system and design requirements
• Created physical database designs for Sybase derived from system constraints and performance requirements
• Interfaced with the Development DBAs in constructing the Chronos/Sybase environment

Confidential, Orlando, FL

ORACLE DEVELOPER/DBA

Environment: Oracle 7.3, Oracle Enterprise Manager, ERWin, Solaris 2.6, Windows NT

Responsibilities:

• Modeled help desk legacy system into ERDs and data dictionary as foundation for Remedy customizations
• Administered Oracle development / testing database

Confidential, Denver, CO

ORACLE DBA

Environment: Oracle 7.2, AIX

Responsibilities:

• General Oracle database administration supporting Geo-spatial database application

Confidential, Heathrow, FL

ORACLE Developer/DBA

Environment: Oracle 7.3, Oracle Forms, HP-UX, HP9000, PeopleSoft

Responsibilities:

• Performed an assessment of the Oracle/Peoplesoft/Server environment and provided it to management
• Administered Oracle in support of Peoplesoft payroll benefits system

Confidential, Maitland, FL

ORACLE DESIGNER/DBA

Environment: Oracle 7.3, ERWin, PowerBuilder, Silicon Graphics Servers

Responsibilities:

• Controlled the operational Oracle database capturing OLTP transactions from 4,000+ user/UNIX set-top locations in 16 test neighborhoods
• Maintained ERDs and data dictionary in support of continuing application development
• Analyzed daily transaction counts/ by neighborhood/ over time periods (15 minutes) to identify 'broken' Unixprocesses and various network/server issues
• Processed raw data into database structures supporting Marketing query/reporting/analysis

Confidential, Orlando, FL

ORACLE Production DBA

Environment: Oracle 7.3, UNIX

Responsibilities:

• Modeled in-house payroll system in support of developing interface modules to vendor apps
• Implemented and administered Oracle Discoverer to support staff query and reporting

Confidential, Patrick AFB, FL

ORACLE Developer/DBA

Environment: Oracle Forms, Oracle Reports, ERWin, Oracle, NT

Responsibilities:

• Modeled support systems as ERDs and data dictionary then designed new interface tables
• Administered production Oracle database environment

Confidential, Melbourne, FL

DATA MODELER

Environment: Oracle CASE/Designer, HP/UX

Responsibilities:

• Utilized CASE to integrate Oracle Financials with internal Harris systems

Confidential, Heathrow, FL

ORACLE DBA

Environment: Oracle 7, HP/UX, HP9000

Responsibilities:

• Installed, configured and administered Oracle in support of Peoplesoft payroll benefits system

Confidential, Tallahassee, FL

ORACLE DBA

Environment: Oracle 5.0, Oracle CASE, Windows, UNIX

• Designed and developed computer-monitored radio manufacturing production line using CASE

Confidential - Dallas, TX

Senior IT Cconsultant

Environment: Excellerator, AIX, RS6000

Responsibilities:

• Involved in designing and developing AFFEES Store Automation project in response to Confidential
• Satellite linkage of 120 domestic bases to AFFEES headquarter
• Modeled Inventory Control module the nexus of all other modules in Excellerator