SUMMARY:

• OWAM 2.2 interfaces to/from Oracle EBS R12.1.3
• Funcational/Technical Consultant Oracle eBusiness v12.1.3 P2P, OTC, INV, RICE Developer
• Oracle R12.13 to OWAM v1.9.0/v1.9.1.2 Designed and Wrote custome interfaces for Inventory Transacations (ITEMS, Material Issues, Returns) and Vendors
• Oracle R12.1.3 Design/Wrote Conversions from MainFrame Systems to Oracle
• OWAM v1.9.0 Design and Wrote Conversions from MainFrame System to OWAM
• Oracle Time and Labor (OTL) wrote and designed interface for Timesheets from OWAM into OTL
• Oracle Tme and Labor (OTL) worte and designed interface for OTM to OWAM timesheets
• Oracle Work Flow developer, BPEL, JDeveloer and custom work flows and modificaitons
• Extensive use and knowledge of Oracle Apps API’s used for Interfaces
• Developed Oracle conversions included 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 Registry/Federal Financials) Suppliers into Oracle Federal Applications, AP (Suppliers), QA (Quality Plans), Trading Community Architecture (TCA) conversion/Implementation,
• Experience with Item Master conversions, Item Attributes, Item Org Assignment Conversions.
• Extensive experience with multiple mult - years US Government ERP Implementation projects, Oracle ERP and SAP.
• Experience as Oracle DBA with Manugistics v7.0 (Defense Logistics Agency, Washington, DC).
• Oracle AIM Functional/Technical documentation (BR100's, MD50s, MD60s, MD70s).
• ETL experience using SAP Business Objects Integrator, Data Insight, Metadata Manager, Composer (Legacy to ERP mapping), and Data Quality.
• US Government Data Quality Readiness Recommendations (DRRs) experience with Legacy Data for ERP Conversions.
• Interface development with knowledge of Quality Module, Purchasing, Order Management, Accounts Payable, General Ledger and Inventory
• 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.
• 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.
• Sourcing Rules/Approved Suppliers, conversion experience loading sourcing rules and approved supplier list for a large scale migration/Conversion and continued production support.
• Internal/external sales Orders, conversion experience loading Internal Requisitions/Internal Sales Orders, external sales orders for data migration/conversion process and continued production support for Sales Orders.
• Procurement, loaded Conversion/data migration data for Purchase Orders, Blanket PurchaseAgreements, Releases, Contract Purchase Agreement for data migration. /conversion process.
• Federal Financials, Conversion experience with Central Contractor Registry (CCR) loading/migration, bulk loads, daily updates to the Fed Admin CCR repository and Supplier Master in Oracle Federal Financials.
• XML Publisher/Oracle Reports/Oracle Forms
• P2P
• Oracle WorkFlow
• OWAM v2.2 - working with a large Utility on upgrading OWAM v1.9 to OWAM v2.2
• Complete v.1.9.0 Implementation for Water/Sewer Plants and Fleet for a large water utility
• V1.9.0 upgrade to v1.9.1.2, configuration, upgrade and testing
• Designed and wrote custom interfaces for OWAM v1.9.0/v1.9.1.2 into and out of Oracle Apps R12.1.3
• Provided Functional and Technical Production Support for Oracle Utilities Work and Assetment Management (OWAM) v1.9.2 for a large water utility (Fleet, Water and Sewer, Linear and Vertical Assets)
• Conversion of Legency Mainframe system, COMPASS, inventory items, Manufacturers, Suppliers, Benchmark PM’s into OWAM v1.9.1.0
• Oracle R12.1.3 to OWAM v1.9.0/v1.9.1.2 Designed and Wrote custom interfaces for Inventory Transactions (Stock Items, Material Checkouts, Vendors, Inventory Adjustments and Returns)
• End user training and documentation

TECHNICAL SKILLS:

Oracle Apps: Oracle Applications 12.1.3. and previous releases dating back to Oracle Apps 10.1

APPS Modues: Oracle Federal Financials, INV, HR, AP, AR, PO, OM, OTL, WorkFlow, ASCP, Oracle Work Flow

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

ETL Software: SAP Business Objects Data Integrator (BODI)

Software: Toad v10, Oracle Developer, Oracle Designer/2000, Erwin, Visio2000, SQLNavigator, KitanaRemedy BLT 4.0, OEM, Adhawk, SqlStudio, Erwin, Desktop DBA, BMC Patrol, Q, PreciseOuterBay, Vertex Tax Software, WinRunner Appworx, Manugistics v7.1/7.2, MSProjectPCVS, Harvest v4.10/v5.11, Mercury Load Runner v8.1, SAP Basis R3 v6.20, OEM 10g GridControl, Patrol, PL/SqlDeveloper, Benthic Golden, IBM Clearcase/ClearQuest, Business Objects Data Integrator (BODI) and Composer v11.7.1, SVN

DETAILED CONSULTING PROJECT EXPERIENCE:

Confidential, Laurel, MD

Oracle Utilities Work and Asset Management (OWAM) v1.9.1, Func/Tech ConsultantOracle EBS R12.1.3 Func/Tech Consultant

Responsibilities:

• OWAM 2.2 Integration with Oracle EBS R12.1.3 - Interfaces design and development
• OWAM v1.9.1.2 Production Support. Provide both Funcation and Techincal support for Fleet and the Production Plants, all modules (Water and Sewer, Linear and Vertical Assets)
• OWAM v1.9.0 Implementation. Set and configuration of: Account Data, Asset Virtual Hierarchy (Water/Sewer Plants), Routings and Routing List, Inventory (Stock Code Items), Assets, Bills of Material, Code Tables, Fine Grain Access (FGA), Job Manager Jobs, Users/User Profiles, creation, Employees, PMs, PM Routes, PM Forecast, Vendor/Manufactuers, Work Orders, Pay Periods, User Defined Fields (UDF’s), Auditing, Account Segments, Timekeeping, Business Rules, Asset Specification Templates, Storeroom Setup, Deparment, Catalog, Asset Classes, Approval Limits, Stock Checkout Request/Stock Checkout, Purchase Orders, Bench Mark Work Orders, Functions v1.9.1.upgrade of OWAM. Development and executing of Test scripts, retesting custom interfaces to/from Oracle EBS R12 and UAT sign off
• Provided OWAM/Oracle EBS interface production support for OWAM v1.9.1 and Oracle EBS R12.1.3
• R12.1.3 Oracle EBS Implementation of Inventory Modules, AP, and ISupplier and conversions from mainframe and other legency systems into Oracle EBS.
• Deployment of Inventory into Oracle EBS R12.1.3 from OWAM v1.9.1 (Storeroom/Stock Items).
• Wrote custom Interfaces from OWAM v1,.91 to Oracle EBS R12.1.3 for Stock Checkout Request both for Inbound into Oracle R12.1.3 and outbound to OWAM v1.9.1
• Wrote custom interface for Inventory For OWAM v1.91 to Oracle EBS R12.1.3 - all OWAM inventory is maintained in OWAM, Material Issues are in Oracle EBS R12.1.3
• Wrote FNDLOAD load scripts for production migrations and implementations in Oracle R12.1.3
• Supplier Coversion for ISupplier Implementation and from Main Frame and an external Supplier system called CBR (Centralized Bidder Registration) system.
• Item/Supplier conversion code developer for Mainframe Legacy Item Data into Oracle R12 .Created conversion programs via Oracle APIs to create items, create stock locator value set values, assign stock locators and sub-inventories for both serialized and non-serialized items from the mainframe into Oracle R12.1.3
• Wrote custom interfaces for Oracle R12.1.3 to/from Oracle Utilities Work and Asset Manager (OWAM) v1.9.1.2 for Stock Check Out Request/Stock Checkouts in OWAM to interface to Oracle R12.1.3. Inventory Move/Allocate Order Interface. Oracle R12.1.3 to OWAM v1.9.1.2 for Inventory Allocations in EBS to Update Stock Checkout Request with the Inventory Issue. Wrote custom interfaces for Stock Issue/Cancels in EBS to OWAM, and interfaces for Receipts in EBS to OWAM.
• Created interface programs via Oracle API’s and Concurrent Manager Programs to interface item Data into Oracle on a nightly basis from OWAM. Interface code created/updated oracle items Master, created valued set values for stock locators, assigned items to stock locators and sub-inventories for both serialized and non-serialized items.
• Designed and development of conversion code for Mainfram Legacy Supplier/Vendor Data into Oracle R12.1.3. Created supplier conversions for Suppliers, Supplier Contacts, Supplier Sites, Supplier Banks, Supplier Bank Accts/Branches into Oracle R12.1.3 via open interface.
• Supplier interface code developer for Mainframe into Oracle R12.1.3. Created interface program via Oracle API’s and Concurrent Manager Programs to interface Supplier/Vendor Data into Oracle on a nightly basis from Mainframe into Oracle R12.1.3 Interface created/updated Suppliers, Supplier Contacts, Supplier Sites, Supplier Banks, Supplier Bank Accts/Branches into Oracle R12.1.3 via open interface
• Oracle Reports Developer/Oracle R12.1.3 BI Publisher - for custom Forecast Inventory report.
• Item Interface code developer for OWAM v1.9.1.2 to Oracle R12.1.3 - Item Interface Developer (custom interface) to create/update items from 2 Mainframes (MAPS and COMPASS) on a nightly bassis to keep the item master in OWAM upto date with the Mainframe item data. Interface was designed to used only until Mainframe data could be converted into Oracle R12.1.3
• Purchase Order Item code developer for Mainframe Purchase Oracles Oracle R12.1.3. to OWAM v1.9.1.2, Created interface program via OWAM API to load/update PO;s on nightly basiss in OWAM from the Mainframe.
• Supplier Interface code developer for Mainframe to Oracle Utilites and Asset Management (OWAM). Created interface progam vai OWAM API to load/update Suppliers on a nightly basis in OWAM from the Mainframe.
• Interface Code developer for custom Interface for TimeSheets from OWAM into Oracle Time Labor (OTL) R12.1.3. Code pulled timesheet data from OWAM v1.9.1.2 and pushed timesheets into OTL, created Timesheets in OTL vai Oracle API for Payroll Process in OTL.
• Oracle Time Labor (OTL) business rule/event creation and process modification Oracle R12.1.3
• Oracle Utilities And Asset Management (OWAM) General Legal Interface developer for interface from OWAM into MainFrame the GL entries from OWAW. attachments, Preventative Work Orders, Work Orders) for Water Treatment Plants, and Waster Water Treatment Plants from Mainframe (COMPASS) into Oracle Utilities and Asset Management (OWAM).
• Production and implementation of changes to new design to existing OWAM for RIVA.

Confidential, Alexendria, VA

Technical/Functional Oracle Apps RICEW (DCSA SCES ERP) Developer

Responsibilities:

• Wrote MD.070 Extension Technical Design Document for Sales Order Conversion/Interface.
• Wrote Sales Order Conversion and Interface from Federal Logistics Information System (FLIS) to to Oracle ERP database (SCES). Updates were associated with Sales Orders. Purchase orders which contain the National Stock Number (NSN). Interface generated a report (SCES-1090) that details the orders containing the NSN when an item (NSN) has been changed to an “Unapproved” classification.
• Wrote MD.070 Extension Techincal Design Docment for Purchase Order Conversion/Interface.
• Wrote P2P Purchase Order Conversion and Interface from mainframe to Oracle ERP database (SCES).

Confidential, Quantico, VA

Technical/Functional Oracle Apps RICEW (DCSA SCES ERP) R12 Developer

Responsibilities:

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

Confidential, Dayton, OH

Oracle 12.0.6 Functional/Technical Oracle Apps RICE Developer

Responsibilities:

• Performed Data loading, profiling, mapping and QA via the Business Object Tools (ETL via Business Objects 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, Internal 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 association 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.
• Writing of CV40s and CV60s (AIM Standard documentation, renamed for purpose of Confidential standards)
• Legacy Data Quality Readiness Recommendations (DRRs) Review process with Confidential /US Government.
• Mock loading of data conversions for Solution Development Labs with the Confidential .
• 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 Apps Consultant

Responsibilities:

• Provided production 7x24 supports 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 Confidential (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 Functional/Technical Oracle Applications Consultant

Responsibilities:

• Oracle Functional/Technical Resource for a Confidential 11.5.7 (11i) Confidential Implementation Consultant and Oracle Configuration (CM) support - Confidential Implementation 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 functional support for Confidential 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 Confidential .
• 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 supports.

Confidential, Alexandria, VA

Sr. Oracle DBA

Responsibilities:

• Sr. Oracle DBA/Lead DBA supporting development and deployment of a customized procurement system, DPACS (Defense Procurement Award Contract System), for the Confidential, 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 training both for the government procurement application, SAP/Basis R3 app/database and Manugistics v7.1/v7.2 application.

Confidential, Denver, CO & Omaha, NE

Oracle Funcation/Techincal 11i Consultant

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 Corp ( 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.