PROFESSIONAL SUMMARY:

• Over twenty years installation, implementation and customization of Oracle Financials and Oracle Manufacturing in Project Manager, Project Leader and Team Member roles.
• Oracle Financials and Manufacturing Release 12.2.9, 12.2.5,12.2.4, 12.1,11i, 11.03, 10.7 SC, 10.7 Character, 10.5
• Oracle RDBMS Versions 19c,11g, 10g, 9i, 8i, 8.x, 7.x, 6.x,5.x; SQL*PLUS, PLSQL, SQL Loader. WEB ADI
• Application Object Library, Oracle Alerts, EDI Gateway, System Administration, Localization, BI Publisher
• Oracle Purchasing, Order Entry/Order Management, Accounts Payable, Accounts Receivable, Customer Master, Inventory, General Ledger, Project Accounting, Fixed Assets, Bill of Material, Warehouse Management System and HRMS.
• Oracle API’s and open interfaces for conversions and interfacing with legacy systems
• Oracle Forms 6i, 4.5, 3.0, 2.3; Oracle Reports 10g, 6, 6i, 2.5, 2.0 Sql*ReportWriter 1.x, workflow 2.51, 2.53, Oracle Application Developer, System Administration;
• Oracle Application Implementation Methodology (AIM), TOAD, PLSQL Developer, SQL Navigator, STAT, Clear Case and Clear Quest, Agile, GitHub
• UNIX shell scripting (HP/UX, Sun Solaris); Windows NT, Linux (redhat),
• SAP r3, LSMW (data loader tool for SAP), Accounts Payable, Accounts Receivable, General Ledger, Fixed Assets, Purchasing Info Record, Bill Of Materials, Customer Material Information
• Panaya software, Jira software, Citrix, STAT,

PROFESSIONAL EXPERIENCE DETAILS:

Confidential

Oracle PLSQL Developer

Responsibilities:

• Part of an international team upgrading Confidential from 12.1.3 to 12.2.10 worldwide.
• Modifying over 400 objects which included packages, procedures, functions, views, control files, UNIX shell scripts, forms and reports to 12.2 specifications to allow online patching.
• Using Panaya to identify objects requiring modifications and what modifications are needed.
• Using Quest STAT to create CSRs to follow and move the objects that have been modified.
• Tools used were TOAD, Oracle Forms Developer, Oracle Reports Builder and UNIX.

Confidential

Oracle Developer 12.2.9 Fusion/Oracle Cloud

Responsibilities:

• Sustainment of the Oracle Application/Cloud/Fusion for Hormel.
• Working service tickets to improve the EDI 944 and 943 and fix problems that occur.
• Project was cancelled till November due to the purchase of Planters by Hormel.

Confidential, Idaho Falls, ID

Oracle Developer

Responsibilities:

• Modifying and adding revenue events to Projects billing using a PLSQL and the create events API.
• Modifying journal line type conditions to include additional billing events.
• Added and modified auto accounting rules to accommodate the new revenue events
• Added field to AR Receipt that would allow the entry as to whether the new event is being used.
• Creating and modifying BI Publisher reports for Project Accounting, Project Billing and Receivables
• Adding and updating Sub Ledger Accounting rules.
• Create and update Auto Accounting rules.
• Modify Invoice revenue and billing validation report to add new data.
• Modified package to accommodate hours for allocations and expenditures

Confidential, Pittsburgh, PA

Oracle Developer

Responsibilities:

• Modifying the Charge Code/Project Number and cost center to in corporate new requirements.
• Creating PLSQL Package to update project task, project type, classification, cost centers, class codes, programs and subprograms and end date cost centers no longer needed.
• Modifying packages, procedures and views that will be impacted by the changes to the charge codes and cost centers.
• Re - writing interface between Hyperion and Oracle project accounting and costing.
• Modifying how direct and indirect labor is collected.
• Modified accounting rules to in corporate changes to the charge codes, cost centers and organizations.
• Modifying Custom Forms and Reports to in corporate changes requested by the users.
• Modifying Custom PLSQL Packages to comply with changes in charge codes and cost centers.
• Created views to collect data from a single source for matched and unmatched taxable expenses.
• Create materialized view to allow OBIEE report to access data from a single source. The view will refresh on the first of the month.
• Set up a flex field attribute1 for tax location and added a list of values.

Confidential, Illinois

EBS 12.2.4 sustainment group CEMLI/RICE developer

Responsibilities:

• Modify DoD reports to new specifications.
• Created Interface between SDDC and Navy/Pentagon to show new invoices and invoice totals for acceptance.
• Part of end of month and end of year team.
• GitHub was used as the repository for all code and documentation

Confidential, Los Angeles

CEMLI/RICE developer

Responsibilities:

• Working mostly with the financials plus project accounting and purchasing.
• Using MANTIS to track issues during system integration testing.
• FND LOAD was used to upload custom objects in the 12.2.5 environment.
• Created DS-140/MD-070 for all CEMLI objects modified.
• Completed the update of 125 CEMLIs, was asked to return in September after CRP2

Confidential

Technical Lead

Responsibilities:

• Lead a team of technical consultants.
• Managed CEMLI/RICE objects from functional spec to testing
• Managed data cleansing working with Sparton employees to accomplish this plus creating data files.
• Working with project manager to status CEMLI/RICE objects for client updates.
• Working with client to define and update the SOW (statement of work) and determine the hours needed and the complexity of each new object.
• Lead weekly meetings to update client on the status of all CEMLI objects and all problems or successes encountered during that week.
• Worked with project manager to identify scope creep.
• Worked with the technical team to create MD70s for CEMLI objects,
• Created the interface from legacy system to AR using SQL Loader and a PL/SQL package
• Created an interface from legacy banking to Oracle lock box.
• Implementing Oracle Time and Labor.

Confidential

Oracle Developer

Responsibilities:

• Revised the Chart of Accounts and added a sixth segment. Charge code and cost centers were added to track college grants.
• Remediate all objects (Packages, Procedures, Reports, Views and Forms) where the Chart of Accounts will be encountered. This will include projects, tasks, awards, project accounting and project costing.
• Unit test all objects modified
• Creating packaged functions and procedures to cross reference the original Chart of Accounts.
• Shell scripts using fnd load were used to install and update all objects modified.
• This revision will impact fixed assets, purchasing, account payables, receivables and project costing and accounting.
• Populating and using GMS Grants Management System for projects/tasks/awards for University Grants that will be part of project cost allocation flex fields segments.
• Modifying the first 6 segments to in corporate the new values.
• Modifying custom personalizations

Confidential, Illinois

CEMLI/RICE Developer (Oracle Developer)

Responsibilities:

• Working with project accounting and purchasing which would include blanket purchase orders, releases against blanket purchase orders, suppliers, payables andinvoicing to bring equipment back from Middle East using container ships to ports worldwide. Since there was equipment from other countries, the purchasing of containers, shipments, project accounting, project costing and invoicing were used.
• Creating MD070s for new objects and remediation of custom objects from 11.5.10.2 to R12.2.4
• Working mostly with the financials interfacing to legacy systems.
• Modules used were Accounts Payable, Receivables, Projects and Purchasing.
• Created packaged interface between Oracle Purchasing and IPP (Invoice Processing Platform) in an XML format using SFTP to move the files
• Created packaged interface between Oracle Accounts Receivable and an Air Force billing process (DEAMS Component Billing System) in an ASCII format using SFTP to move files.
• Creating UNIX install scripts and MD120s (Install Instructions) to compile packages, move UNIX and SQL scripts, FND LOAD to create concurrent processes and request sets in new instances.

Confidential, Bowling Green, KY

Oracle PLSQL Developer

Responsibilities:

• Reimplementation of the Oracle apps from version 11. .2.3/11g
• Remediation of 23 custom CEMLI Objects for AR, AP, INV, GL, OM and PA to ensure R12 compliance.
• Create custom MD70 documents for all custom objects.
• Performed Unit testing for all those custom objects.
• Creating UNIX scripts using FNDLOAD and SQL to compile and migrate over 300 custom objects.
• Modifying custom personalizations

Confidential, CT

CEMLI/RICE Developer (Oracle Developer)

Responsibilities:

• Created conversion for Fixed Assets Tax Book using WEB ADI and the FA TAX INTERFACE to create a custom template to convert data from their legacy systems.
• Created conversion for Fixed Assets Replacement values using WEB ADI and the FA Insurance API to convert data from their legacy systems.
• Created the technical documentation for both.
• Wrote the custom PLSQL package for the conversion of General Ledger for EB/GD
• Final week was tasked with writing the TE040 Unit testing documents, writing the install documents and teaching the Confidential consultant replacement how to create WEB ADI custom templates and how to unit test.

Confidential, Orlando, FL

RICE Developer (Oracle Developer)

Responsibilities:

• Rewrite PLSQL package for Sales Order Polling Process to use the Order Management APIs and not the base tables to bulk load orders.
• Rewrite PLSQL package to create customers using TCA APIs instead of the base tables.
• Update documentations to include the modifications to the Order Polling process and customer creation.
• Part of the R12 upgrade team dealing with Order Management, Accounts Receivable and Inventory.

Confidential, Virginia Beach, VA

Oracle Developer

Responsibilities:

• Created a PLSQL package to modify sales order, purchasing and shipping information to allow Confidential to receive a drop ship internally. This was needed to accommodate the purchasing department.
• Created PLSQL package to modify sales order, purchasing and requisition information to change an internal sales order to a drop ship. This was needed to accommodate the purchasing department.
• Created a PLSQL trigger to alert purchasing if a second requisition is created for a drop ship sales order line or a new sales order line is created or a new requisition line is created. A specific email is sent to the buyer assigned to the item and copied to the general buyers group.
• Created a modified MD50 and MD70 for each process.
• Data warehousing project using 11g,
• Created a conversion package to move data from one legacy system to Oracle tables using Golden Gate.
• Created a real time PLSQL package to insert or update Oracle tables using Golden Gate to execute the package and various procedures.

Confidential

Oracle Developer

Responsibilities:

• Functional testing of new and modified extensions to the Oracle Purchasing, Order Management, Inventory and WMS modules.
• Creating and modifying TE54 - Hybrid Oracle AIM Unit Testing Procedure documents.
• Creating serialized and install base items for use in new and modified extensions.
• Using Oracle Bee Hive for document storage and revision history.
• Creating a modified MD 65which is a combination Functional/Technical document.

Confidential, Washington, DC

Oracle Developer

Responsibilities:

• Requirements gathering for inventory, sales orders and purchasing.
• Creating the functional and technical documents for all interfaces
• Creating the PLSQL code and unit testing the interfaces
• Creating PLSQL packages to execute using the concurrent process to interface between Oracle, Venda and warehouse management.

Confidential, Seattle, WA

Technical Manager/RICE Developer

Responsibilities:

• Managed the cutover plan to Oracle.
• Managed the SRs in Metalink.
• Managed 10 instances for cloning and refresh.
• Assisted the technical consultants in the coding for the conversions and interfaces to the Oracle financials.
• Managed the setup and assignment of standard and custom concurrent programs and request sets and created the job schedule template
• Modified the expenditure and awards packages for Project Accounting conversion.
• I was tasked with finding solutions for problems with the invoicing and costing side.
• Working with the functional team to determine why invoicing in Project Accounting was not being created. Ran tests creating invoices manually.
• Working help desk tickets for the financial modules.
• Using Clear Case and Clear Quest to log defects and fixes to the instance.
• Using XML Publisher to create and modify existing reports for AR and FA.

Confidential

Oracle Developer

Responsibilities:

• Part of the SOA RICE team developing outbound and inbound interfaces for the Air Force legacy systems and Oracle for Accounts Receivables, Order Management, Payables and Project Accounting.
• Modified or Created reports necessary to accommodate the needs of the Air Force and other Branches.
• Created or Modified the MD70 for all work completed on extensions and interfaces and worked with the functional consultants to modify MD50 to match the latest MD70.
• Created the Unit Test Plans and Installation instructions for the testing team.
• Working with Project Accounting and Accounts Payable to trouble shoot problems with the interface to AP to invoice the US Government for food and housing of Air Force personnel on Military exercises.
• Created interfaces between Payables, Receivables and Project Accounting to cost, receive and invoice different branches of the Military for either goods sold or services rendered.
• XML publisher was used to create a dunning letter for internal receivables since the standard dunning letter was not to government standards.

Confidential, Fremont, CA

R12-10g Oracle RICE Developer (Oracle Developer)

Responsibilities:

• Confidential planned to enter data into the R12 application manually but due to the amount of data and the time constraints I was tasked with creating the conversion PLSQL packages for purchasing, customers, vendors and items.
• This included setting up TCA or Trading Community Architecture.
• Modified AR reports using 6i/10g for customer letters and dunning letters to in corporate the company logo and localization to print the letters in both German and English
• Created the PLSQL package to convert assets from People Soft to Oracle Fixed Assets using Mass Additions.
• Created a PLSQL package to interface Oracle Fixed Assets to Remedy using a concurrent process with four parameters which will run each month and include all assets that are not retired.

Confidential, Jacksonville, FL

Techno/Functional Consultant

Responsibilities:

• Wrote the PLSQL packages and procedures for interfaces to Accounts Receivables and Accounts Payables from an AS 400 legacy system using Oracle open interfaces and API’s
• Wrote the PLSQL package to bring new purchases using Mass Additions into Fixed Assets.
• Was part of the help desk for problems with the Oracle Financials (AR, AP, PO and GL) and legacy system feeding data into Oracle
• Wrote the conversion PLSQL packages for Accounts Receivable, Accounts Payables, Vendors and Fix Assets bringing data from a legacy application to Oracle.
• Create extensions in Accounts Receivable and Order Management for Peru to make both “country specific”.
• Create financial cash and bank report for Peru using the GL, AR and AP in Developer 10g.

Confidential, TN

Technical Consultant

Responsibilities:

• Creating PLSQL packages using the API’s for the HRMS conversion from BANNER to Oracle.
• Creating the interface for the weekly time entry to Oracle.
• Creating PLSQL package to load payroll using API’s.
• Creating a procedure to load benefits and a package to interface with Blue Cross Blue Shield to send a weekly flat file of all employee and dependent elements, not just the changes.
• Modifying Payroll Check format in include additional information using reports 10g.
• Modify third party checks using reports 10g.
• Interface payroll to legacy systems for financials.

Confidential

Technical Consultant

Responsibilities:

• Part of the RICE team creating conversions and interfaces.
• Created the conversion package using the API’s for HR employees and tested using the Government’s 32 bit encryption code.
• Created the interface package using the API’s for the insert or update of existing employees in HR.
• Created the conversion package for Fixed Assets