SUMMARY:

• Confidential has implemented and supported Oracle Applications from small to large businesses including; public sector, manufacturing, internet - telecom, utilities, health care, banking, telecommunications, higher education, pharmaceuticals in both local and multinational setting.
• With 18 years of experience in Oracle EBS; Confidential specializes in the delivery of business processes as a technical consultant for Financials, Supply Chain, Manufacturing, Logistics and HRMS and also as a functional consultant for Oracle Public Sector Budgeting (PSB) application.
• Confidential has participated in numerous project implementations in all phases of SDLC; business requirement analysis, gap analysis, design, prototyping, solution assessment and validation, development, testing, CRPs, implementation and support.
• Extensive experience in setups and implementing Oracle Apps 11i Public Sector Budgeting (PSB).
• Setup for PSB; Budget Calendar, Account Sets, Position Flexfield, Position Attributes,Elements, Budget Items, Parameter Sets, Period Allocation Rules, GL Budget Setcustom responsibilities for worksheet security and Budget Group Hierarchy.
• Defined and run Data Extracts to derived salary distribution from both Labor Distribution and HRMS Salary Cost Allocation.
• Defined and run expenses and position worksheets.
• Validated results of Create GL Budget Journals and Upload Worksheet to Position Control. Conducted user training for the important functionalities of PSB.
• Setup account security rules for accounting sets tied up to responsibilities. Setup three way match for PO, AP and Receiving. Setup Item to Buyer sourcing rules and PO approval hierarchy.
• Setup employee, supervisor, user account, default expense account and expense report templates for Confidential .
• Fit gap analysis, interacting with both management and users to come up with functional, technical design and working prototypes.
• Industry experience includes; Public Sector, Internet-Telecom, Health Care, Telecom, Banking, Utilities, Manufacturing, Insurance, Higher Education and Pharmaceuticals.
• Extensive experience providing custom development and technical support of Oracle Apps 11i (PSB, Confidential, PO/iProcurement, AP, OM, AR, Inv, GMS, PA, FA, GL, BOM, HRMS, WIP, Self-Service Web Apps, Quality and Service).
• Workflow customizations; Internet Expenses, PO and Requisition Approval, PO and Requisitions Account Generators, AP Project Supplier Invoices, FA Account Generator, PSB Account Generator, and Order Line Transactions.
• Developed interfaces using both open interfaces and API's using PL/SQL and Unix for; Order Management’s Process Order API and Open Orders Interface, TCA Customer Accounts, WIP’s Component Issue, Open Resource Transaction Interface and Work Orders, Bill of Materials, BOM Standard Operations, BOM Routings, PA Costing API and Transaction Import, FND Attached Documents, Confidential Extension and Credit Card Processing, receipts and return to vendor return receipts using Receiving Open Interface, HRMS to ADP Payroll Interface, AR’s Open Invoice Interface and Adjustments API, Receipts Lockbox, Tax Vertex, and Customers, AP’s Invoices and Vendors, Requisitions and Purchase Orders, Inventory’s Item Serialization, Transaction Cost Average Costing and On Hand Quantity, and FA’s Assets conversion.
• Form personalizations.
• Customized forms using Forms 6i.
• Customized reports using XML Publisher, Discoverer, and Reports versions (9i, 6i).
• Performance tuning / optimization of long running SQL queries.

TECHNICAL SKILLS:

Software: Oracle Apps 11.5.10.2, 11.5.9, 11.5.8, 11.5.7, 11.5.4,11.5.3, 11.03, 11.02,10.7 GUI, 10.5, 10.4 and 9 Char Financials/Supply Chain/Manufacturing/HRMS -(Public Sector Budgeting (PSB), Internet Expenses, AR, TCA, PO/iProcurement, HRMS, AP, GL, GMS, Labor Distribution, FA, BOM, OE/OM, Inv., Self-Service Web Apps, Project Accounting Billing and Costing, WIP, Service, Quality, Engineering, Alerts, AOL, AK Developer, SA, Workflow Administrator, Account Generator, Flexfields, Flexbuilder, Value Sets); Oracle (RDBMS 10G, 9i, 8i, 7 & 6, sqlplus, PL/SQL, SQL Developer, Workflow Builder 2.6.3.5/2.6.1.5 , & 2.5, Developer 2000 Reports 9i/6i/ 2.5, Forms6i, Pro*C, Oracle Business Intelligence (OBIEE) 10.1.3.4, (Administrator, Presentation Services, Publisher), Manugistics Supply Chain 4.7 Distribution Planning, Demand Planning and Extended Edition, sqltrace-TKPROF, sqlloader); Discoverer 4.1.45/05, FSGs, ADP Payroll 5.10-7, BPA Bar Code System; C, Unix (K, Bourne and C Shells), Linux, SunOS, Windows NT, PVCS Version Control, Sablime Source code control, Microsoft Projects, Oracle AIM Methodology

Hardware: Sun Solaris, HP-UX, IBM-AIX, Pyramid, Sun SPARCstation, Unisys U6000, NCR, Unisys-PTX, Sequent S/27, AT&T 3B2, Window’s PCs.

EXPERIENCE:

Confidential, Morristown, NJ

Oracle EBS Manufacturing Technical Consultant

Responsibilities:

• Developed conversion programs for Items (inserts and updates), Work Orders, BOM, BOM Routings using the interface tables.
• Developed Item On Hand Quantity loading and reversal programs, WIP Component Issues and Returns using the material transaction interface table.
• Developed ABC Codes update assignment program.
• Tested scripts for adding ECOs.
• Developed a mass upload program for, additions, changes and cancellations to order lines using the Process Order API.
• Developed customer creation interface program using TCA APIs for; Create Organization, Create Person, Create Group, Create Location, Create Party Site, Create Party Site Use, Create Contact Point, Create Customer Account and Relationships, and Create Customer Profile.
• Developed Assets to Projects assignment load by using the Project Costing APIs and loading transactions using the Transaction Import Interface.
• Developed the purchase order load from an external source using the PO Open Interface. Developed workflow customizations for Requisitions and PO approval using roles and parallel approvers.
• Developed monetary violation notification messages for Confidential categories; airfare, car rental, meals and lodging making modifications to the approval workflow. Setup employee, supervisor, user account, default expense account and expense report templates.
• Developed external payables invoice load using the AP Invoices Interface.
• Developed forms personalization on the Items form to facilitate queries.
• Developed and implemented reports for BOM and Inventory applications using Oracle Reports 6i and XML Publisher.
• Developed a custom Time Entry form that interfaces with the WIP Resource Transaction Interface. Developed alerts for missing and unapproved timecards. Defined a form personalization on the Discrete Workstation, Create Resource Transactions form to default the employee to the currently logged application user and validate the record before inserts.

Environment: Oracle Apps11i (11.5.10.2) Financials/Manufacturing - BOM, WIP, Order Management, Receivables, TCA, PA, Inventory, Engineering, PO, AP, Confidential, HRMS, Alerts, Forms Personalization, Oracle Database 10GEE, Oracle Reports 6i, XML Publisher, Workflow 2.6.3.5, Forms 6i, sqldeveloper, Toad, PL/SQL, sqlloader, Unix, SunOS

Confidential, Philadelphia, PA

Oracle Receivables Lead Consultant

Responsibilities:

• Gathered requirements from the functional business groups the desired changes.
• Designed and develop inserts and updates to customers using TCA APIs; Create Organization, Create Person, Create Group, Create Group, Create Location, Create Part Site, Create Part Site Uses, Create Customer Account, and Create Customer Profile.
• Designed changes to a custom receivables form to accommodate other lines of business invoice entry that revolves around the use of the autoinvoice functionality and use of the invoice creation and adjustments APIs.

Environment: Oracle Apps11i (11.5.10.2) Financials - Receivables, TCA, Oracle JServer - 10.2.0.3Forms6i, PQL/SQL, Oracle AIM Methodology, HP-UX

Confidential, Lansdale, PA

Oracle Apps Technical Consultant

Responsibilities:

• Developed and implemented interfaces for; Bill of Materials, BOM Standard Operations, BOM Routings, Purchase Order, On Hand Quantity and FND
• Attached Documents using the APIs.
• Loaded Project transactions using the Transaction Import Interface.

Environment: Oracle Apps11i (11.5.10.2) Manufacturing/Supply Chain - BOM, PO, PA, InventoryOracle JServer - 10.2.0.3, PQL/SQL

Confidential, Chattanooga, TN

Oracle PSB Consultant

Responsibilities:

• Gathered requirements from users/gap analysis, setup of the application and training users/developers with the use of application functionalities, working with other functional applications lead with regards setup/patching issues and also working with the DBA and developers to identify and address custom needs of the client.
• Setup Public Sector Budgeting for position and non position budgeting. Worked with the GL functional consultant in defining a Budget in GL and with the HR functional consultant in defining setups for Position Control in HRMS.
• Setup budget calendar, account sets, position attribute mapping, position attributes, budget sets, budget group hierarchy and custom responsibilities.
• Defined PSB Data extracts to map to HRMS Employee Salary and Cost Distribution.
• Defined, run, modified worksheets for both operations and personnel.
• Designed an add on to Position Control customization to meet the City’s need.
• Uploaded budgets for both GL and HRMS Positions.
• Designed and presented an encumbrance model, from PSB to GL posting to PO encumbrance charging.
• Developed custom views to map position attributes, custom Discoverer reports for both salary and expenses worksheets. Developed custom concurrent programs.
• Implemented numerous patches from Oracle’s Metalink TAR for PSB.
• Trained users in running HR Data Extracts, defining elements and default rules, position and non position worksheets. Trained users with using local parameters to revise worksheet projection and importing budgets to GL and HR.
• Trained users in validating results of Create GL Budget Journals and Upload Worksheet to position control.
• Customized FA Account Generator using Workflow.

Environment: Oracle Apps11i (11.5.10.2) Budgeting/Financials/HRMS/Supply Chain - PSB, GL, PayrollPO, FA, Oracle JServer - 10.2.0.3, PL/SQL, Workflow 2.6.3.5, Discoverer, Oracle AIM Methodology

Confidential, Morristown, NJ

Oracle Apps Technical Consultant

Responsibilities:

• Customized the Expenses Workflow for approval notifications customizations using workflow and credit card extension customization using PL/SQL procedures for Oracle Confidential .
• Developed the Purchasing/Requisitions Approval Workflow using roles, parallel approvers and the Position Hierarchy setup.
• Developed and implemented a custom Forms 6i form for entering Timesheets that mimics the functionality of Timecards of Self-Service Web Applications.
• Developed and implemented a custom Forms 6i form for Customer Service Requests that retains the functionality of the 10.7 version including use of custom DFFs.
• Developed and implemented a custom Forms 6i form for Non Conformance Discrete Jobs with embedded calls to Material Requirements, Operations and View Quality
• Transactions form and used of form attachments functionality.
• Developed interfaces for; WIP Open Resources Transactions, MRP Open Master Schedule, WIP Work Order, MTL Transactions, and QA Collection Import.

Environment: Oracle Apps11i (11.5.10.2) Financials/Manufacturing/Supply Chain - iExpensesWIP, Inventory, Quality, AOL, Forms6i, Workflow 2.6.3.5, PL/SQL, SunOS

Confidential, Northbrook, IL

Oracle Apps Technical Lead Consultant

Responsibilities:

• Coordinated with the Functional Lead on identifying their technical requirements for custom forms interfaces and reports.
• Worked with the technical team members on their share of the development tasks and seeing to it that projects are delivered on time/budget and to the conformity of the client’s needs.
• Developed and implemented a custom Forms 6i form to map PeopleSoft accounts to Oracle accounts and the corresponding PL/SQL code to handle the translation.
• Developed and implemented client extensions for Confidential i.e; developing customizations to the Expenses Workflow and APIs.
• Developed and implemented a GL interface using both single and dual currency for foreign currencies that needs to have a corresponding USD converted amount.
• Developed and implemented a custom Positive Pay file program based from Oracle’s seeded Positive Pay File program using Reports 6i.

Environment: Oracle Apps11i (11.5.10.2) Financials - GL, Internet Expenses, AP, AOL, Oracle JServer - 9.2.0.7.0, Workflow - 2.6.3.5, PL/SQL, Forms 6i, Reports 6i, PeopleSoft Financials 8.9Oracle AIM Methodology

Confidential, Tucson, AZ

Oracle PSB Consultant

Responsibilities:

• Setup Budget Calendar, Account Sets, PSB Position Flexfield, Position Attributes, Elements, Budget Items, Parameter Sets, Period Allocation Rules, GL Budget Set, custom PSB responsibilities for worksheet security and Budget Group Hierarchy.
• Defined and run Data Extracts and line and position worksheets.
• Defined PSB Data extracts mapped to HRMS Salary and Cost Distribution.
• Uploaded budgets in GL and HRMS position control.
• Developed custom program for position worksheet period allocation based on the number of days in a month.
• Enabled PSB to Excel Interface. Developed Discoverer reports for budget worksheets.

Environment: Oracle Apps11i (11.5.9) Budgeting/HRMS/Financials - PSB, Payroll, GL, Oracle JServer - 9.2.0.5.0, Discoverer, PL/SQL, Oracle AIM Methodology

Confidential, West Chester, PA

Oracle Apps Technical Consultant

Responsibilities:

• Developed interfaces for invoice receivable and adjustments, receipts and cost hook.
• Developed and implemented custom Oracle 6i reports.

Environment: Oracle Apps11i (11.5.10) Financials/Supply Chain/HRMS - Inventory, AROracle JServer - 9.2.0.5.0, Report 9i, PL/SQL, Unix

Confidential, Holmdel, NJ

Oracle Applications Consultant

Responsibilities:

• Developed the Oracle HRMS to ADP Payroll Interface.
• Developed custom Report 9i reports.
• Supported the month end closing for AP, AR, PO, GL, and FA.

Environment: Oracle Apps11i (11.5.9) - HRMS Payroll, AP, AR, PO, GL, FA, Oracle JServer – 9.2.0.6.0, ADP PC/Payroll 5.10-07, Report Builder 9i, PL/SQL, UNIX Shell, Oracle AIM Methodology, SunOS

Confidential, Morristown, NJ

Oracle Apps Technical Consultant

Responsibilities:

• Converted external vendors, customers and receivable transactions into Oracle using open interfaces where available.
• Developed a data warehouse application for AP, AR, and FA.

Environment: Oracle Apps11i (11.5.9) Financials/Supply Chain – AP, AR, FA, Oracle JServer – 9.2.0.7.0, PL/SQL, Unix, SunOS