PROFESSIONAL SUMMARY

• Having Ten years of experience in Implementation, Customization and Support of E - Business suite Applications.
• Extensive technical expertise in Oracle ERP modules in Supply Chain Management, Oracle Manufacturing, Distribution and Financials: Purchasing (PO), iProcurement, Order Management (OM), Inventory (INV), Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Fixed Assets (FA), Cash Management, HRMS, Application Object Library (AOL), iSupplier Portal, iReceivables, iPayment, iExpenses, Workflow, Oracle Time and Labour and Oracle System Administration.
• Proficient with the tables and their relations in GL, AR, AP, OM, INV, PO and Sys Admin modules.
• Functional and implementation knowledge of Oracle Applications in financial suite modules.
• Expertise in Customizing and developing new Oracle Applications Framework Pages.
• Experience with customizing Endeca for iProcurement, creating data sources, Endeca UI for Multi language Support.
• Experience in Oracle Supplier Network (OSN).
• Experience in RICE (Reports, Interfaces, Conversions and Enhancements) components.
• Extensive experience in developing Interface/Conversion Programs to import data from legacy systems into Oracle Applications using PL/SQL, SQL*Loader, UTL file etc.
• Possess strong programming experience in SQL, PL/SQL Procedures, Functions, Packages, XML/BI Publisher and Database Triggers.
• Good experience customizing and personalizing approvals using Oracle Approval Management (AME).
• Experience in designing, developing and customizing Oracle Applications Framework (OAF) in Oracle Self Service Modules ( iProcurement, iSupplier Portal, iReceivables, iPayment and iExpenses)
• Highly proficient in translating High Level Design Document (MD50) to Detailed Design Document (MD70).
• Conceptual knowledge in using Workflow components (Workflow definitions loader, Workflow Builder, Workflow Engine, Notification System and Workflow Monitor).
• Experience in Workflow Customization according to business needs.
• Experience in developing forms using Oracle forms and Customizing oracle seeded forms using Template.fmb and Custom.pll. Experience in developing Reports using Oracle Reports and Customizing Oracle Seeded Reports.
• Strong experience in Unix Shell Scripting.
• Ability to interact effectively with clients, Understanding their requirements and providing optimum solution.

TECHNICAL SKILLS

Oracle Applications E-Business Suite: 11i, 12.0.6,12.1.3

Oracle Applications Modules: General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management, Inventory (INV), Purchasing (PO), Order Management (OM), OTL, Service Contracts, HRMS, Manufacturing.

Self Service Modules: IProcurement, iSupplier Portal, iReceivables, iPayment and iExpenses.

Products / Architectures: Oracle Applications Framework (OAF), Oracle Endeca Information Discovery, Oracle Supplier Network (OSN)

RDBMS: Oracle 9i/10g, 8.x/7.x, MS-Access8, MS SQL Server

Languages: SQL, PL/SQL, C, C++, JAVA, Visual Basic, HTML, XML, UNIX Shell scripts

Oracle Tools: Reports 6i/9i/ 10.1.2.0.2, Forms 6i/9i/ 10.1.2.0.2, SQL* Plus, SQL*Loader, SQL Developer, JDeveloper, TOAD, Workflow Builder, XML/BI Publisher, Discoverer.

Operating System: Windows XP/NT/2000/98/95, UNIX, LINUX.

WORK EXPERIENCE:

Confidential, Tampa. FL

Lead Technical Oracle Applications Consultant / Manager IT-Projects

Responsibilities:

• Extensively worked on Customizing / Personalizing the iProcurement Pages using Oracle Applications Framework (OAF).
• Developed Custom application using OAF which involves custom workflow and packages.
• Worked on customizing the Endeca for iProcurement.
• Endeca Customizations include developing the Endeca UI for different languages, also creating the data sources for multi-language support.
• Involved in running Endeca Full Load, Incremental Load & Metadata programs.
• Worked on Oracle Supplier Network (OSN) to import punchout catalogs from suppliers directly.
• Worked on Application Object Library (AOL) components like value sets, menus, concurrent programs, request sets and PL/SQL Procedures, Triggers and Reports.
• Involved in converting the PL/SQL Procedures, Triggers, Reports and Oracle Workflow from 12.0.6 to 12.1.3
• Responsible for Full Life Cycle involving Planning, Implementation, Testing and Support for multiple assignments.
• Prepared Technical Specifications documents for all the components developed.
• Developed a secure transaction level application which grants Users with the approval authority they request for after a hierarchy of approvals.
• Developed Interfaces such as PO Change Request Interface.
• Applied various access levels for users and approvers in accessing the OA Framework application from making a new Requisition to Change requests and Reports.
• Developed a SqlLoader script for the data load from flat files into Database tables using Control File (CTL).
• Developed Reports using XML Publisher and XML Bursting and registering it as a concurrent program.
• Involved in rigorous testing of the Application and the Database Components.
• Involved in developing Test Scripts and Status Reports.

Environment: Oracle Applications R12.0.6 & 12.1.3 (iProcurement / PO, GL, AP & FA), OA Framework, Endeca for iProcurement, Oracle Supplier Network (OSN), SQL*Plus, PL/SQL, Java, JSP, TOAD, SQL Developer, JDeveloper 10g, Workflow Builder, UNIX Shell Script, Putty, FileZilla, XML / BI Publisher.

Confidential, Phoenix, AZ

Senior Oracle Applications Consultant - Technical

Responsibilities:

• Responsible for Full Life Cycle involving Planning, Implementation, Testing and Support for the Project.
• Prepared Technical Specifications documents for all the components developed.
• Mostly worked on customizing / personalizing / building custom pages using Oracle Applications Framework.
• Worked on Frontend & backend development and customization OA Framework Components like Pages, Regions, View Objects, List of Values, Entity Objects, Application Module, Workflow Builder, PL/SQL Packages, etc.
• Developed a secure transaction level Order management Application for non-product material shipment, involves validating Users, Customers, Items, Approvers.
• Developed Accounting Interface for this Application.
• Applied various access levels for users and approvers in accessing the OA Framework application from making a new order to Shipment and Invoice Generation.
• Developed a Custom Approval workflow and Approval Rules to fit into the application.
• Developed a Custom Shipment Workflow to fit into application.
• Involved in Set up Oracle Approval Management (AME). Developed approval rules based on invoice amount.
• Developed a Shell Script to migrate & install the database components & SQL Objects using SQLPlus, FNDLOAD for messages, functions, responsibilities, menus and concurrent programs using LDT files, Compilation of OAF Java files using Javac and XML Importer for importing Pages/Regions/Personalizations.
• Developed a SqlLoader script for the data load from flat files into Database tables using Control File (CTL).
• Developed Commercial Invoice Report using XML Publisher and registering it as a concurrent program.
• Involved in rigorous testing of the Application and the Database Components.
• Involved in developing Test Scripts and Status Reports.
• Worked on Application Object Library (AOL) components like value sets, menus, concurrent programs, request sets and PL/SQL Procedures, Triggers and Reports.
• Involved in converting Database Triggers from 11i to R12, which defaults a Payment method whenever a supplier is created and Syncs Payables Bank Account with HR Pay Method.
• Worked on Segregation of Duties (SOD) controls in R12.
• Worked on converting legacy reports into Hyperion views or Reports.
• Prepared Functional Design Document for a Standalone Application which involves Receiving, Processing, Shipping and Settling the Material.

Environment: Oracle Applications R12 (GL, AP, FA, HR), 11i, OA Framework, SQL*Plus, PL/SQL, Java, JSP, TOAD, SQL Developer, JDeveloper 10g, Workflow Builder, UNIX Shell Script, Putty, FileZilla, XML / BI Publisher, Hyperion Reporting.

Confidential, Allendale, NJ

Oracle Applications Consultant - Technical Developer.

Responsibilities:

• Involved in developing and testing the above mentioned interface/programs.
• Participated in Full Life Cycle from Planning to Implementation and Support for the Project.
• Prepared Functional Specifications documents (MD 50) for Interface customizations and Framework Personalization’s.
• Prepared Technical Specifications documents (MD 70) for Interface customizations and Framework Personalization’s.
• Involved in developing Project plans, Test Scripts and Status Reports.
• Conversion of existing customer information (customers, addresses, contacts and phones) using Customer Interface in AR.
• Converted the customer information from legacy system into oracle Applications using custom program and API to effect the HZ tables in TCA.
• Developed Expense Check Interface using PL/SQL which extracts all the expenses to be reimbursed to employees based on the date range.
• Developed UNIX Script to Encrypt and transfer to FTP Server for the generated Expense Check Files.
• Developed AMEX Remittance Advice program which generates a remittance file to be sent electronically as a flat file, for payments made by wire or ACH.
• Developed Custom reports like Top Spenders, Expense Report Data Extract, Policy Exception report, etc.
• Worked on Personalizing and Customizing the iExpenses Page according to the business requirements.
• IExpenses OA Framework personalizations include hiding fields & buttons, changing the headers, Personalized Submission Instructions, Sorting Columns.
• IExpenses OA Framework Customizations include adding new fields with custom LOV’s which populates all the HCP’s (Health Care Professional) data in the iExpenses Page.
• Worked on customizing the standard Expenses Workflow according to business requirements.
• Developed Interface Programs using UNIX Shell Scripting.
• Tuned the application (report queries, other SQL queries) to improve the performance.
• Defined value sets, menus, concurrent programs, request sets, registering custom build forms, reports and PL/SQL Procedures, Triggers and Packages and creating executables using Application Object Library (AOL) in the development environment.
• Defined and maintained various Descriptive flex fields (Additional Header Information, Additional Line Information) by defining structures and context and assigning to value sets to the segments.
• Worked on XML / BI Publisher as a Concurrent Program for Reports.
• Worked extensively in production support Issues in Oracle Receivables and Payables.

Environment: Oracle Applications 11.5.10.2(GL, AP, AR, iExpenses, iProcurement and OTL), OA Framework, SQL*Plus, PL/SQL, Java, JSP, TOAD, SQL Developer, Forms 6i, Reports 6i, Discoverer, JDeveloper with OA Extension, Workflow Builder, Unix Shell Script, XML / BI Publisher.

Confidential

Oracle Applications Consultant

Responsibilities:

• Involved in developing Custom Application using OA Framework, which includes Simple search, Advance search, Smart search and Results based search.
• Worked on Designing, Development and Customization of OA Framework Pages each of the custom modules and worked extensively on BC4J and UIX components.
• Worked on designing the Object components according to the Oracle Applications Framework MVC architecture.
• Worked on the iSupplier portal and how suppliers can view their open invoices, POs, and contact information.
• Personalized Supplier Create Page to automatically assign the Supplier Email-id as the Username, when username is not entered by user
• Worked on Partial Page Rendering of OA Framework Pages using SPEL binding.
• Created and Customized UIX components such as Pages, Regions and items.
• Implemented Simple and Results based search on certain pages.
• Created Multi-Step Update page including shared regions using shared train structure.
• Involved in Personalization’s of iExpenses Page like Updating Expense Report for Cash and Other Expenses pages, Moving Details Image, etc.
• Involved in developing LOV’s, Poplist, Regions and items.
• Created custom pages to insert/update rows into custom tables. Added additional functionality like Drop down PPRs. Customized Branding images, icons, buttons, etc
• Developed procedures for custom Approval workflow which is triggered whenever a new user is created.

Environment: Oracle Applications 11.5.9(AR, AP, OM, Purchasing, iProcurement, iSupplier Portal, iExpenses), OA Framework, Workflow Builder, Reports 6i, Forms 6i, Oracle 9i.