SUMMARY:

• Oracle eBusiness P2P, O2C RICE Developer with experience in the following areas:
• Oracle WorkFlow 2.5.3.4, BPEL, JDeveloper development experience with customized workflows and business events.
• Oracle RICE Developer, with extensive experience in legacy conversion to ERP P2P, OTC, Item Master and Interface development and product support.
• Oracle ERP RICE migrations and conversions, custom development coding, and Global Oracle Applications (10.7 thru 12.06).
• Extensive use of Oracle APIs, and open interfaces for legacy to Oracle ERP conversions.
• Developed Oracle conversions include custom conversions from Legacy applications to Oracle P2P (Purchase Orders, Internal/Purchase Requisitions), AP (Suppliers, GL), OM (Sales Orders), INV (Item master, Item Org assignments, UDAs, BOMs, FSCs), Conversion of suppliers includes CCR (Central Contractor Registary/Federal Financials) Suppliers into Oracle Federal Applications, AP (Suppliers), QA (Quality Plans), Trading Community Architecture (TCA) conversion/Implmentation.
• Experience with Item Master conversions, Item Attributes, Item Org Assignment Conversions.
• Custom Oracle API development for conversion, private API or Concurent Manager programs.
• Extensive experience with multiple mult - year US Government ERP Implmentation projects, Oracle ERP and SAP.
• Oracle AIM Funcational/Technical documentation (BR100's, MD50s, MD60s, MD70s).
• Experience with Oracle Modules, QA, AR, AP, GL, FA, PO, HR, OM, INV, ASCP, Customized Workflow (Workflow builder), Vertex Tax Software
• Experience as Oracle DBA with Manugusitics v7.0 (Defense Logistics Agency, Washington, DC).
• Experience as an Oracle Applications DBA, including releases (10.7,11.0,11.5.7), Oracle core DBA (version 6.0 thru 10g) experience .
• Oracle Applications DBA with experience in installs, cloning (DB and MT Tiers), RMAN backups, and performance tuning, Database, Sql,Concurrent Managers, and Middle Tier processes.
• Exensive U.S. Government ERP project experience with the Defense Logistics Agency (DLA), United States Air Force (ECSS project in Dayton, Ohio) and the U.S. State Department (Top Secret).
• Worked on numerous private sector companies (U.S. and Canada) on implementations, upgrades, production support of existing implementations, functional and other technical support issues.
• ETL experience - Integrator, Data Insight, MetaData Manager, Composer (Legacy to ERP mapping), and Data Quality.
• Data Quality Readiness Recommendations (DRRs) experience with Legacy Data for ERP Conversions.
• Oracle Apps Module & Programming Experience:
• RICE (Interface) development with knowledge of Quality Module, Purchasing, Order Management, Accounts
• Payable, General Ledger and Inventory
• Custom API development/Oracle APIs, development experience writing custom APIs and using Oracle’s published
• APIs for data migrations and conversions
• Item Master Migrations, conversion experience of Master Items, Inventory Organziation Items, Item User defined
• Attributes (UDAs), Manufactures, Manufacture Part Numbers, BOM Costing and other Item related masgter data.
• Federal Financials, Conversion experience with Central Contractor Registery (CCR) loading/migration, bulk loads, daily updates to the Fed Admin CCR repository and Supplier Master in Oracle Federal Financials..
• Procurement, loaded Conversion/data migration data for Purchase Orders, Blanket Purchase
• Agreements, Releases, Contract Purchase Agreement for data migration./conversion process.
• Internal/External Sales Orders, conversion experience loading Internal Requisitions/Internal Sales Ordersexternal Sales orders for data migration/conversion process and continued production support for Sales Orders.
• Sourcing Rules/Approved Suppliers, conversion experience loading sourcing rules and approved supplier list for a large scale mirgration/Conversion and continued production support.
• Wireless, Mobile Web (MWA), Material Requirement Planning (MRP), Advanced Planning and Scheduling(APS).
• Oracle Workflow Builder, Custom Module Development, customizations and configurations, experience with
• Oracle Work Flow builder for development and production support, developed custom modules/code and experience with oracle customizations and configuration setups.
• Oracle Apps DBA experience, extensive experience on previous releases or Oracle Apps with installation of the database tier, application tiers, load balancing, application and data tier cloning, data base backups with RMAN, \ concurrent manager setup, customizations, troubleshooting and tuning.

TECHNICAL SKILLS:

Oracle Financials: Oracle Applications 12.0.6 and previous releases dating back to Oracle Apps 10.1Modules, Oracle Federal Financials, HR, AP, AR, PO, OM, WorkFlow, ASCP, INV

Operation Systems/Hardware: Sun-Solaris v10, IBM-AIX, Sun Fujitsu, HP-9000 (Superdome) with Precise & ServiceGuard, Sun Solaris (420R, E6500, E4500, E10K), IBM RISC/6000, VAX, IBM Mainframe (4381), Sequent, Dec Alpha

Other: Toad v10. Oracle Designer/2000, Erwin, Visio2000, SQLNavigator, Kitana, Remedy BLT 4.0, OEM, AdhawkSqlStudio, Erwin, Desktop DBA, BMC Patrol, Q, Precise, OuterBay, Vertex Tax SoftwareWinRunner Appworx, Manugistics v7.1/7.2, MSProject, PCVS, Harvest v4.10/v5.11, Mercury Load Runner v8.1SAP Basis R3 v6.20, OEM 10g GridControl, Oracle Workflow Developer, Patrol, PL/SqlDeveloper, Benthic Golden, IBM Clearcase/ClearQuest, Business Objects Composer v11.7.1

PROFESSIONAL EXPERIENCE:

Confidential, Quantico, VA

Oracle 11i Techincal/Functional Oracle Apps RICE Developer

Responsibilities:

• RICE Developer for the GCSSMC Oracle ERP Implementation. Worked on new and exisiting Change Requests (CRs) for P2P and O2C to the exisiting Interfaces (PL/SQL Packages) for R1.1/R1.2 Implmentation.
• Worked on POAPPRV workflow, built custom workflows for Material Return Processing (MRP)
• Developed custom PL/SQL Package for MRP custorm workflows.
• Worked with BPEL, JDeveloper, Business Events on the customized GCSSMC customized workflows.
• Worked with the Test Team on Funcationally and Techincally testing CR Changes before being migrated to Production.

Confidential, Washington, DC

Oracle 12.0.6 Functional/Techincal Oracle Apps RICE Developer

Responsibilities:

• Performed Data loading, profiling, mapping and QA via the Business Object Tools (ETL tool Data Integrator, Data Insight, MetaData Manager, Composer, and Data Quality).
• RICE ERP Developer on the Quality Module (QA) for interfacing to AFEMS (Air Force Management System)
• RICE Developer (Conversion) for P2P (Purchase Orders, Interrnal Requisitions) from Legacy systems,
• RICE Developer (Conversion) for OTC (Internal/External Sales Orders) from Legacy systems
• AP, GL Account code setups for P2P Modules (Purchase Orders, Internal Requisitions).
• RICE Developer (Conversion) Loading of Location and Customer data assoication to Locations.
• Item Master Loads, User Defined Attributes (UDAs), use of public API’s, Open Interface (concurrent manager), and custom written private APIs.
• RICE Developer (Conversion) developer for Oracle Federal Financials, CCR Suppliers, Federal Suppliers, loading via Central Contractor Registry (CCR) Interface and Open Interface (concurrent managers). Loaded over 34,000 CCR Suppliers
• Sourcing Rules/Approved Supplier list data migration loading via Open Interface (concurrent managers and custom written private APIs).
• Data mapping of Legacy systems to Oracle custom and Open Interface tables via Business Objects Composer v11.7.01.
• Writting of CV40s and CV60s (AIM Stardard documentation, renamed for purpose of CSC standards)
• Legacy Data Quality Readiness Recommendations (DRRs) Review process with U.S. Air Force/US Government,.
• MockLoading of data conversions for Solution Development Labs with the U.S. Air Force.
• Support of various testing environments (FIT, JIT, and PreProd)
• Analysis of conversion data fall-outs and error reporting summary to the US Government
• Worked with encrypted PII data (Supplier Tax Payer Ids, Social Security Numbers, Bank Account information) for loading CCR Suppliers (Commercial Suppliers). De-encrypted as data was loaded into the ERP.

Confidential, San Antonio, TX

Oracle Apps DBA, Oracle Production Support, Technical/Functional Oracle Applications Consultant

Responsibilities:

• Provided production 7x24 support for Oracle Apps/Oracle DBA and Functional Support for modules: PO, Inventory, WIP, BOM, workflow, workflow builder, forms and DBA/Apps DBA support for the Zachry’s contract with the US Department of State (Top Secret) and also for Zachry’s private sector Oracle Apps production Support. Performed normal DBA actives, database clones and App Tier clones, database backup/recovery - cold/hotbackps, database performance tuning (utlestat/utlbstat), patch application, application performance tuning, concurrent manager setup/tuning PL/SQL package programming/development and tuning, functional setups - new inventory organizations, jobs setups, troubleshooted workflow issues/programming, functional testing of customized code and bug tracking and reporting.

Confidential

Oracle Configuration Manager (CM) Project Lead

Responsibilities:

• Oracle Funcational/Technical Resource for a TCA 11.5.7 (11i) TCA Implemenation Consultant and Oracle Configuration (CM) support - TCA Implmentation consultant for re-Implementation of an earlier version of Oracle (v11) to v11.5.7 Trading Community Architecture. Also responsible for the analyst of the current Configuration Management processes, review and recommendations of new CM processes, extensive use of IBM Clearcase for software CM Control, Oracle Security, Oracle Instance management, Oracle DBA/Apps DBA support/guidance and mentoring of junior DBAs and funcational support for TCA re-implementation.

Confidential, North Sioux City, SD

Oracle Functional/Technical Oracle Consultant

Responsibilities:

• Oracle Functional/Technical Resource - Engaged for pre-implementation functional testing project for go-live with Apps 11i (ERP Modules) for Gateway Computers Corp. Functional testing of core modules (AP/GL/AR/PA/PO) and interfaces and bolt-on applications (Helix, Vestra and Agile). Using Load Runner v8.1 to generate scripts, and evaluate performance of the application,evaluate integrity of data in the modules being tested, testing interfaces, application extensions/modifications and Bolt-on applications.
• Worked with the other functional users gathering testing requirements and used Oracle AIM for all product documentation and deliverables to client.

Confidential, Denver, CO

Sr Oracle DBA/Production Support DBA

Responsibilities:

• Sr. Oracle DBA performing standard DBA duties, database Clones (non-RAC), paths, backup/recovery, setup of RMAN v9backups for production running 9207 and installation of 10g RAC, EMC/BCV splits, performance tuning issues using statspack (utlbstat/utlestat), database re-configuration changes,
• Provided 7x24 on-call production support.

Confidential, Washington, DC

Sr. Oracle DBA/ Project Mgmt/Oracle SAP BasisR3

Responsibilities:

• Sr. Oracle DBA/Lead DBA supporting development and deployment of a customized procurement system, DPACS (Defense Procurement Contract System), for the US Department of Defense, supporting SAP/Basis R3 CRM application, and Manugistics v7.1/v7.2 application.
• Secret Security Clearance held w/10SCBI completed, duties include project management, normal daily DBA activities (creating new instances, backup and recovery - RMAN and BCV splits, performance tuning, upgrades, etc) for the procurement system, data replication with materialized views (created for Manugistics issues/tuning), DBA support and functions for SAP/Basis R3 application, database and performance tuning of Manugistics/Collaborate queries and database support.
• Performed Oracle RDBMS 9i installations, upgrades from 8.1.7.4 to 9.2.0.1 and to 9.2.0.4/9.2.0.5/9.2.0.6/9.2.0.7 tuning issues with Oracle 9i and responsible for supporting multiple Oracle environments for dev, system test, staging and both for the government procurement application, SAP/Basis R3 app/database and Manugistics v7.1/v7.2 application.

Confidential, Denver, CO

Sr. Oracle DBA/Apps DBA

Responsibilities:

• Sr. Oracle DBA/Apps DBA engaged for a short technical evaluation/review of an Oracle 8.1.7.4/Apps 11.5.9 implementation at Confidential ( Confidential ) in Denver, CO and Omaha, NE.
• Project scope was to look at the Oracle install, database setup, backup/recovery method, backup and recovery reliability, Oracle Financials implementation of core financial modules, sizing for future company growth, IT Department resources (DBA’s), policies and standards, hardware evaluation for future growth of instance s and business and to make a formal review of the findings and present them to Confidential ’s top level management.
• Extensive use of Oracle Implementation Methodology (AIM) was used on the project implementation/evaluation.

Confidential, Palo Alto, CA

Sr. Oracle DBA/Apps DBA/Production Support DBA

Responsibilities:

• Sr. Oracle Financials/Applications implementation and production support DBA providing 7x24 onsite customer support for a 850GB+ world wide production oracle Financials 11i ERP implementation (OLTP) supporting financial, ADI, FSG’s, inventory, purchasing, manufacturing (OM), Procurement, iprocurement, ipayment, istore, ipurchasing, Advanced Planning and Scheduling (APS), Mobile Web Application (MWA), Express Server, Discover 4.1, Oracle 9iAS (9i Application Server), Oracle Demand Planning, SSWA, Workflow modules and concurrent manager setup and tuning, application and database environment cloning and refreshing (both using AdClone utility and manual cloning with scripts), backup and recovery with RMAN, troubleshooting problems and issues, on-site customizations to forms and reports and Java scripts/programming, programming with Unix Shell scripts and perl and performance issues for US, Asia and European operations with 5000+ global users.
• Provided 7x24 on site customer support for the other production and non-production company oracle application environments, twice daily reporting instance refresh from the production OLTP instance, a patch instance, several test application instances, an Archiving/OLTP instance, a production planning instance, and several development application environments and a EDW (Enterprise Data Warehouse) instance.
• System architecture: HP Superdome with ServiceGuard, ten middle tiers with CISCO load balancing (Apache, Forms, Oracle Configurator) for the OTLP and production reporting instance, BCV refreshes for the twice daily reporting refreshes from the production OLTP instance.

Confidential, Seattle, WA

Sr. Oracle DBA/Apps DBA/Production DBA

Responsibilities:

• Sr. Oracle Financials/Applications Implementation DBA responsible for the installation of the rdbms and implementation of Oracle applications 11.5.3 w/modules (AR, GL, FA, AP, PA, PO), ADI, FSG’s.
• Responsible for the implementation of the Oracle ERP App database and environment and all setup and implementation of the supporting environments test, development, QA, and patch instances, installation and configuration of Oracle 9iAS and Oracle Discover 4i for OTLP reporting, performance/load balance testing utilizing WinRunner.
• Wrote and supported the cloning scripts for cloning of production OTLP database and application tiers for refreshes of test, QA, and environments, and for the maintenance and application of patches to the production OLTP environment and all other environments.
• Wrote and assisted developers with PL/SQL packages/procs for the mainframe legency data migirations and for custom application packages/modules.
• Provided on-call 7x24 support, performance tuning and problem diagnosis of application code and database problems and implementation of Distributed Concurrent Processing (DCP) of the concurrent manager tiers.
• System architecture: Single database tier (E6500), with a single Admin Tier (E4500) and three DCP concurrent manager tiers (420R) with EMC disk and OEM for alert monitoring.

Confidential, Seattle, WA

Oracle DBA/Apps DBA/Implementation/Production Support DBA

Responsibilities:

• Sr. Oracle Financials/Applications Implementation DBA responsible for the configuration of the SUN hardware and installation of the Oracle rdbms and implementation of Oracle Applications 11.0.3 w/modules (AR, AP, GL, CE, INV, OE, PO w/multi-Org and workflow configuration), and installation of Quantum VERTEX Tax Engine and OSSWA.
• Worked closely with the development team on writing and implementing PL/SQL packages for data migrations and for customized application code.
• Cloned the financials databases and middle tiers to other database instances and environments for the project development.
• Database tuning, application tuning and troubleshooting, patch installation, application/Database Upgrades, Installation and configuration of VERTEX Tax Package and Tax View configuration.

Confidential, Portland, OR

Sr. Oracle DBA/Apps Production Support DBA

Responsibilities:

• Sr. Oracle Financials/Applications support DBA and database/application upgrade DBA responsible for a 250GB+ Oracle Applications 10.7 database and a migration from 10.7 to 11.0 Oracle Applications with Smart Client and NCA middle tiers.
• There were multiple applications databases, both production and test databases for the financials application. Investigated and supported performance problem issues and resolutions, applying financial patches, and normal production DBA monitoring and activities (backup and reports with RMAN, etc).
• Oracle RDBMS/Apps migration was from HP Unix 10.20, Oracle 8.05, Apps 10.7 to HP Unix 11.0, Oracle 8.1.5.0, Apps 11.0.3 for the existing OTLP Applications database/environment

Confidential, Seattle, WA

Oracle production DBA

Responsibilities:

• Production Oracle DBA for vendor developed insurance application, and DBA monitoring.
• DBA support included backup and recovery planning, database installation, and performance tuning.
• SQLServer 7.0/6.5 DBA support for HR’s OLTP databases, backup and recovery, performance tuning, and monitoring other DBAs.

Confidential, Seattle, WA

Responsibilities:

• Performed performance tuning on various OLTP databases, developed backup and recovery procedures, support of an Oracle Parallel Server (OPS)/RAC in Oracle v9i, data warehouse system (DWS), database defragmentation, applications support DBA, DBA monitoring, and Y2K support.
• SQLServer 7.0/6.5 DBA support for various OLTP databases, Performance tuning, trouble shooting, and database recovery.

Confidential, Seattle, WA, Phoenix, AZ

Responsibilities:

• Oracle production DBA for multiple databases, a production database, a job scheduler database, a test database, and a VRU (Voice Response Unit) database.
• Responsible for maintaining 7x24x365 production database availability, database maintenance, upgrades, kernel, SQL tuning, SqlNet installs/upgrades, Oracle Case Installation, database backup/recovery, growth and object sizing, maintaining a test database which is refreshed nightly with production data, maintenance of the test database, performance tuning, database upgrades, space utilization, tablespace sizing, rollback segments, SqlNet installs/upgrades, SGA tuning, Multi-Threaded Server tuning), production software Iinstalls, production software scheduling and System Administration for an IBM RISC/6000.

Confidential, Seattle, WA

Responsibilities:

• Oracle v7.x DBA, assisted on-site DBA group, and application developer for a data conversion application.
• Developed a conversion application using Oracle*Case. The conversion Application was for an electrical System schematic database, Oracle v7.0, for the 777 aircraft production.