Summary

Overall, fifteen years of Oracle E-Business Suite ERP consulting experience with Oracle Financials, Oracle Manufacturing and Oracle HRMS. I am a high-energy, enthusiastic and dependable individual who consistently excels in a challenging environment.

Skills Highlight

• Oracle Applications Framework OA Framework/OAF
• Forms 6i, Custom Library Custom PLL , Personalization, Application Object Library
• BI Publisher, Reports, Oracle Approvals Management AME , APIs and Workflow
• Oracle E-Business Suite Federal Financials, HRMS and Manufacturing
• Integrated SOA Gateway

Project Experience

Confidential

• Participated in the development of an extension/customization of the Oracle E-Business Suite R12.1.3 for the Department of Treasury Bureau of Engraving and Printing . A custom module was developed from the ground-up using the Oracle Application Framework OAF . The module consisted of 5 functional areas including Operation Management and Material Transfer. Approximately 50 forms were built supported by more than 30 tables.
• Participated in solution design.
• Implemented Master/Detail forms utilizing Association Objects AO /View Links VL .
• Extensively utilized Simplest Possible Expression Language SPEL , Partial Page Rendering PPR ., Hide/Show regions, Tab structures, Switchers, Popups, etc.
• Utilized Oracle Callable Statements.
• Built seamless integration between the custom module and the E-Business Suite Shop Floor Manager and Inventory modules using APIs.
• Responsible for deployment of OAF. Conducted over 100 deployments successfully.
• Utilized Subversion SVN to maintain version control of development objects being developed by multiple developers.

Integrated SOA Gateway Web Service

• Coordinated the installation patches of Integrated SOA Gateway ISG for R12.1.3 with DBAs.
• Setup/Configured ISG to enable its functions and establish connection to the application database schema.
• Created custom PLSQL integration interface/web service. Annotated the PLSQL package adhering to standards.
• Created the Integration Repository loader file to upload to the Integration Repository.
• Enabled, generated and deployed the integration interface.
• Used SOAPUI to test the web service.

Financials Confidential

• Designed and developed new forms using the Oracle Application Framework OAF and the JDeveloper toolset. Master-detail screens were developed using Advanced Tables to maintain Garlock specific invoice approval rules.
• Configured Oracle Approvals Management AME for Payables Invoice Approval to meet Garlock's business requirements for Invoice approval.
• Setup the necessary Attributes, Conditions, Approver Groups and Rules.
• A PL/SQL package was called to dynamically establish the Approval Groups.
• Designed and developed an extension User Interface using Oracle Application Framework for Oracle Order Management. Used Advanced Tables to develop a UI to maintain new promise dates for order lines. Once the transactions were saved, a notification to multiple was sent. A custom Oracle Workflow was developed to send the notifications. A link in the email opened the relevant Sales Order form transaction.
• Designed and developed an extension to send Advance Shipping Notices ASN to non-EDI customers upon deliveries being ship-confirmed. BI Publisher RTF templates and XML Bursting was used to send each individual ASN to customers either via email or fax.

Confidential

• BI Publisher XML Publisher reports that produce the outputs for the MISA Execution processes.
• The creation and submission of journal entries that re-distribute costs via the GL Interface/Journal Import process.
• Programs that calculate MISA costs and their allocations across legal entities.
• Development of new User Interfaces using the Oracle Application Framework OAF J2EE technology and the JDeveloper toolset. Some of the screens were developed using the Forms 6i toolset.
• Following the Oracle Application Implementation Methodology AIM , developed Functional Specification and Technical Design documents for the Master Inter-company Services Agreement MISA Extension. The MISA extension re-distributes operating costs among the various legal entities of Intelsat. The extension included the following:
• Developed OA Framework Extensions. Used Substitutions to extend the business logic of the HRMS module by modifying Terminations View Objects.
• In order to restrict access to sensitive information in HRMS, defined/configured Security Profiles, Functions, Responsibilities, Menus, Task Flows, CustomForms, etc.
• Developed several HRMS and Financials Alerts
• Used Custom.pll to automatically create Assignment Time Information. When a user creates an Employee Record, their Assignment Time Information is automatically created based on their Employee Category. The Assignment Time Information related to each Employee Category was setup/configured using HRMS Table Structure and Table Values functionality.
• Developed an XML AR Customer Invoice report using an XML Template in BI Publisher. The generated invoices were individually emailed to customers utilizing XML Bursting.

Confidential

• Developed the Technical Design Document for the DCAS Interface.
• Responsible for the development of the DCAS interface. The interface has 3 major components that encompass the following Oracle modules Project Account, Purchasing, Accounts Receivable, Accounts Payables and General Ledger. It utilizes the Payables Invoice Open Interface Import, the General Ledger Journal Import and the AR Receipt APIs to create the required transactions in Oracle.
• Developed 2 custom Reports 6i 'Acceptance of MIPR' and 'SF1080' to meet the client's requirements. The reports presented data related to Agreements, their respective Project Funding s , and draft Invoice generation in Project Accounting and the corresponding Invoices created in Account Receivables. The Projects account and the GL Account of the Receivables were presented in the reports.
• Modified the PO Account Generator workflow to build the Project centric accounts based on configured Projects/Tasks and other rules.
• Confidential
• NACHA Payment Format: Customized the NACHA Payment Format program to meet FRB requirements. A single NACHA Payment custom program was created to handle tax payments to the governments of Maryland, Virginia and District of Columbia and the Internal Revenue Service IRS .
• BI Publisher XML Publisher : Developed 15 custom reports using Oracle Reports and XML Publisher. The reports contained information extracted from the Payables, Receivables, Purchasing and System Administration modules.
• Application Extension: Developed an extension for the FRB Transportation Subsidy System.
• Oracle Approvals Management AME : Setup FRB specific rules for Invoice Approval Workflow within the Accounts Payables module. Attribute, Conditions, Approval Groups and Rules were configured for the Invoice Approval Workflow.
• Payables Invoice Interface: Developed an interface to import invoices from an external PeopleSoft system into Oracle Payables using the Invoice Open Interface tables.

Confidential

• Technical Team Lead on an 11.5.10 Implementation of Oracle Financials, HRMS and Project Accounting PA :
• Developed the Technical Design Documents for the Interface of Projects and their Tasks from a legacy system to Oracle PA 11.5.10.
• Developed the Interface for Projects and their Tasks from a legacy system to Oracle Projects. Expenditure Types were also interfaced and associated with their corresponding Projects and Tasks to enable the Transaction Controls feature of PA.
• Developed the HRMS Employee Interface to Create, Update, Terminate and Re-Hire employees. The interface used various HRMS APIs to meet the client's business requirements.
• Several Raytheon specific business rules were enforced using the Oracle Application Framework OAF .
• Developed various prototypes to demonstrate to the business users how they would use the 11.5.10 install while at the same time leverage historical data in 11.5.2.

Confidential

• Technical Team Lead responsible for the delivery and sign-off of the following:
• Managed tasks using Microsoft Projects. Developed the Technical Design Documents for customizations implemented via Custom.pll and the following complex extensions: Non-Committed Purchase Orders NCPO , NCPO Invoices, USPS Prompt Payment Act, USPS 1099 Processing, Change Purchase Order Vendors.
• Oracle Custom Library: Implemented approximately 100 Custom USPS Business Rules via Custom.pll and Database Triggers. Among others, implemented Zoom functionality for the AP Invoices Workbench and modification of standard Applications List-of-Values LOV .
• Non-Committed Purchase Orders: Developed an extension to create and maintain Non-Committed Purchase Order headers, their lines, and the distributions for the lines. The extension provided the required USPS specific functionality for Purchase Orders which was included the desired components of the standard Oracle Purchase Order forms.
• NCPO Invoices: Developed an extension that provided the functionality to create an AP Invoice matched to a Non-Committed Purchase Order. Once validated, the NCPO Matched invoice was imported into the Invoice Workbench via the Invoice Gateway.
• USPS Prompt Payment Act PPA : Implemented the USPS PPA requirements through a combination of a custom Form, Database Trigger, Packages and Custom.pll.

Confidential

• Technical Team Lead responsible for the delivery and sign-off of the following:
• Developed Technical Design Documents for the highly complex Accrue Finance Charges, AR Transaction Statuses and AR/AP Netting extensions.
• Developed the Accrue Finance Charges extension based on CMS' unique requirements.
• Developed an extension to maintain CMS AR Transaction Statuses and their corresponding interdependencies with TROR statuses, AR/AP Netting and Dunning Letters.
• Assisting in the development of the Functional Specification for an AR/AP Extension to meet CMS' unique netting requirements.
• Developed project plans using Microsoft Projects and ensured that tasks were performed within the specified time frame and with the projected resources.

Confidential

• Converted Open Purchase Order from the legacy system to Oracle PO.
• Converted General Ledger balances from the legacy GL system to Oracle General Ledger.
• Converted Vendors from the legacy system to Oracle.
• Developed an interface between the ERAU student System to Oracle HRMS and Oracle Time Management to create student records and payroll transactions.
• Developed an interface between the legacy GL system and Oracle General Ledger.
• The following were some of the Financials technical efforts undertaken:
• Converted Persons, Contacts, Addresses, Assignments, Salary, Payment Methods, Federal and State Taxes and Elements from the ERAU legacy Human Resource systems to Oracle HRMS.
• The following were some of the HRMS/Payroll technical efforts undertaken:
• Developed several data conversion routines.
• Developed several interfaces between ERAU legacy and external systems and Oracle Applications.
• Developed the system architecture design for ERAU's Production and Development environments.
• Technical Team Lead for the combined ERAU/Oracle team responsible for the following:

Confidential

• Technical Team Lead responsible for the following Accounts Payable AP and Labor Distribution LD extensions:
• Accounts Payables
• Extended the AP Card Profiles form to accept Project related accounting information in addition the GL accounting.
• Extended the AP Expense Distributions form to accept Project related account Information.
• Modified various Packages to support the above customizations.
• Implemented custom security by restricting certain information based on an employee's authorization.
• Labor Distribution
• Extended the Create Effort Reports form and supporting packages and tables to meet UVA requirements.
• Tuned various queries to substantially improve processing time of the Labor Distribution encumbrance processes.
• Extended the Create Enc Lines, Update Enc Lines, Liquidate Enc Lines and Projects Transaction Import Packages to meet the UVA functional requirements.
• Confidential
• Extended the Labor Distribution LD forms and packages to support SUNY's business requirements.
• Extended the out-of-the-box Labor Distribution Packages.
• Implemented modifications using the custom library.
• Tuned various queries to improve performance of several programs.
• Developed AIM deliverables documenting the extension.

Confidential

• As part of the implementation team performed the following:
• Extended Oracle Financials by developing custom forms using Developer/2000.
• Developed a script to convert assets from a legacy system to Oracle Fixed Assets.
• Developed interfaces to import AP invoices and GL journals into Oracle Financials.
• Developed database design and application extension technical design documents using AIM.

Confidential

• Technical Lead responsible for the delivery of the following:
• Developed scripts to convert GPO customer information from legacy systems to Oracle AR through the Customer Interface API.
• Developed interface to load GPO invoices into Oracle AR through the Invoice Interface API.
• Loaded GPO 'Open Invoices' into Oracle AR through the Invoice Interface API.
• Developed interface to load GPO Receipts into Oracle AR through the Receipt API.

Confidential

• Implemented Oracle General Ledger and Accounts Payable modules for the Department of Education's 4 Billion Pell program
• Assisted in the configuration of Oracle General Ledger and Accounts Payable.
• Developed interface to create and update Vendors in AP based on eligible school data received from RFMS.
• Developed a custom Application Program Interface API to convert transactions received from RFMS into AP invoices.
• Extended the Batch Approval of AP invoices based on Pell requirements.
• Extended the Accounts Payable Payment Process to pay Standard invoices by applying them to their corresponding Prepayment invoice.
• Provided functional support and training to Department of Education personnel in understanding and using Oracle AP and GL as configured for the Pell program.