SUMMARY

• Around 11 Years of extensive experience in Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of Oracle Applications 11i and R12.
• Experience in SCM Modules Purchase Order (PO), Order Management (OM), Inventory (Inv), Shipping, WIP, BOM and Order to Cash (O2C) cycles.
• Extensive experience as a Techno - Functional consultant in Oracle EBS with major focus on Financial modules General Ledger(GL), Accounts Payables(AP), Account Receivables(AR), Cash Management(CM), Project Accounting(PA), Fixed Assets(FA), iProcurement, iExpenses, iSupplier and Core HRMS and Procure to Pay (P2P) cycle.
• Extensive experience in RICEW components, UNIX, Oracle SQL/PLSQL, Workflow, Forms and reports 6i/10g and SQL Loader, Project assignments include Implementation, upgrade, conversion and support of Oracle Apps systems.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design), TE25 documents using AIM Methodologies/OUM.
• Developed Reports, Interfaces, and Customizations & Extensions (RICE) in PO, OM, INV, WIP, BOM, AP, AR and GL modules.
• Very strong experience in understanding the business, requirements, GAP analysis & Mapping and led the POC for several complex business processes and RICEW/BI/OBIEE/OBIA.
• Extensive experience in creating XML Publisher(BI Publisher) reports and OBIEE/OBIA using various templates to publish the reports as per user requirements
• Production Support and Development for Global Confidential in PO/AP/AR/GL Module.
• Good experience in requirements gathering, Design, Development of custom applications in Oracle application framework (OAF).
• Having the good experience in all the Conversion/Interfacing activities using the API’s and open interfaces in R12 with the core subject of Trading Community Architecture (TCA).
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs).
• Extensive experience in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development.
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, XML/BI Publisher, Workflow Builder and Oracle Discoverer.

TECHNICAL SKILLS

ERP: Oracle Applications 11.5.10.2 and R12 (AOL, SYSADMIN, INV, PO, AP, AR, GL, OM, EDI (e-Commerce Gateway), WIP, BOM and HRMS).

RDBMS: Oracle 11G/10g/9i/8i/SQLServer7.0.

Operating Systems: UNIX, WINDOWS-XP/NT, Windows 7, Window 8.1, MS-DOS.

Application Tools: Developer 2000 (Forms 6i&10g/Reports 6i&10g), Discoverer 9i, XML/BI Publisher, SQL*Loader, Jdeveloper, OAF (Oracle Application Framework), ADF (Application Development Framework).

Tools: SQL* Plus, TOAD 7.5/9.5, SQL Developer Tools, XML/BI Publisher, Workflow Builder, Developer, OBIEE, Apex, Remedy5/Remedy 7 and Appworx.

Languages: SQL, PL/SQL, XML, C, C++, Java,HTML, Pro*C.

Utility Tools: WS FTP, Putty.

Configuration Management Tools: Clear Case, SharePoint, PVCS Tracker and PVCS Version Manager.

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Sr. Oracle APPS Techno Functional Consultant

Responsibilities:

• Worked on the Requisitions Interafce to create the Purchase Requisitions.
• Worked on Requisitions VO Extentions to show the Item Number in the Requisition Details Page and Order Page.
• Implemented iProcurement Punchout to buy the Items from Internal Stores.
• Worked on the PO Receipts to load into Interface tables and processing those receipts through Open Receipts Interface.
• Worked on the Interface to Process cXML PO Data and Updating the PO Details by calling Oracle Standard API’s
• Interact, analyze and understand the requirements thoroughly with the Client.
• Worked on the Personalizatios to show the customized message on the iProcurement Home Page.
• Created Custom Objects to store the PO Data, cXML Data and Created Editioned Views as per 12.2.5 Oracle Standards.
• Developed the XML report to show the PO Receipts Details with Requested Quantity and Accepted Quantity Details.
• Worked on the XML Bursting and Custom e-mail notification programs.
• Worked on the Defects created in different Phases of testing.
• Generating of customprod.jar and signing of java classes to access all the objects by weblogic server.
• Prepared Technical design documents for conversions, extensions, interfaces, and reports.

Environment: Oracle Applications R12.2.5 (PO/iProcurement/OM/AP/AR/iReceivables/OAF/Java), Kintana, SVN, SQL Developer, Oracle 12C, WinSCP, Putty, UNIX, Sharepoint.

Confidential, Boca Raton, FL

Sr. Oracle APPS Techno Functional Consultant

Responsibilities:

• Worked on the new architecture of R12.2.5 and deployment into weblogic environment.
• Worked on upgrade objects and redevelopment objects from R12.1.3 to R12.2.5.
• Involved in customizing and development of OAF pages.
• Extensively worked on implementation of Oracle O2C Cycle.
• Interact, analyze and understand the requirements thoroughly with the Client.
• Worked on Oracle Services Modules OAF Pages Extension and Personalizations.
• Worked with the functional, technical and DBA team to upgrade the system from 12.1.3 to 12.2.5 and to stabilize the system after the upgrade.
• Worked on the java concurrent programs failures and retrofitting as per R12.2.5 standards
• Worked on the Defects created in different Phases of testing.
• Generating of customprod.jar and signing of java classes to access all the objects by weblogic server.
• Raised SR and follow up with Oracle for seeded functionality issues.
• Provided pre-Upgrade and post-Upgrade support for financial modules
• Prepared Technical design documents for conversions, extensions, interfaces, and reports.

Environment: Oracle Applications R12.2.5 (AP/AR/iReceivables/iProcurement/OAF/Java), Kintana, SVN, SQL Developer, Oracle 12C, WinSCP, Putty, UNIX, Sharepoint.

Confidential, Boca Raton, FL

Sr. Oracle APPS Techno Functional Consultant

Responsibilities:

• Interact, analyze and understand the requirements thoroughly with the Client.
• Involved in the customizations to the extend the e-Billing Functionality through OAF Pages.
• Created OAF Pages to Define the Customer specific Documents for e-Billing.
• Created OAF Pages to setup the Customer Specific Configurations based on Customer Document ID
• Created OAF Pages Developed technical documents, migration documents and test scripts for all the developed components.
• Worked on Java Programs to generate the Output files in XLS Format using java poi’s
• Worked on BLOB data types to save the generated XLS files into Oracle Tables by using JAVA.
• Created Custom Billing XML Reports through XML Data Definitions and rtf templates.
• Involved in Building Custom Tables, Procedures, Functions and Packages to support the customizations requested by Business.
• Worked on Extension and Personalization of OAF pages.
• Provide timely status to Client on the components.
• Involved in fixing the Defects and enhancements.
• Followed all the oracle coding standards and migration standards.
• Worked on the outbound programs to send the Customer billing information in eTXT/PDF format based the setup.
• Trasmission of generated files to customer based on transmission types (E-Mail or FTP).
• Created reprint programs to generate the Customer Order Information with Invoice, shipping, billing, Item details.

Environment: Oracle Applications R12.1.3 (INV/OM/AR/PO/WIP/INV/BOM/OAF/Java), Kintana, SVN, SQL Developer, Oracle 11G, WinSCP, Putty, UNIX

Confidential, Rockville, MD

Oracle APPS Techno Functional Consultant

Responsibilities:

• Developed common loader program to load the Items data into staging tables from data files by using SQL Loader
• Developed Concurrent Programs to Assign the Items to Sub-Inventories.
• Developed PL/SQL package to validate the data and then load the validated data into Oracle Base tables using Public APIs
• Done unit testing for all the objects developed.
• Developed technical documents, migration documents and test scripts for all the developed components.
• Involved in Building Custom Tables, Procedures, Functions and Packages.
• Involved in Discussions with Business users.
• Created OAF Pages to make Pick Confirm and Ship Confirm by all the Customer Ordered Items.
• Created OAF Pages to define the Printer/Barcode Mapping to the Items.
• Created XML reports to print the all Ship Confirm and Pick Confirm Reports.

Environment: Oracle Applications R12.1.3 (INV/OM/AR/GL/OAF/Java modules), Toad, PVCS, Oracle 11G, UNIX

Confidential

Oracle APPS Techno-Functional Consultant

Responsibilities:

• Worked on AutoBOM Creation Project.
• Developed New Programs to automate Creation of Items, BOM, BOM Routing.
• Developed New Programs to read data received from EDI systems and importing into Oracle EBS System.
• Effectively used Inventory Item Creation API.
• Effectively Used BOM Creation and BOM Routing API’s.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item
• Interface program. Developed Item conversion program for assigning Items to Item category set and Categories
• Creation of new custom OAF Search page to show Paceline/Special Projects Data.
• Created Custom OAF Pages to send the Assembly Items Information to Oracle Inventory by calling Oracle Item Interface API.
• Implemented business logic to calculate profit and loss made by finished good and by customer by calling pl/sql packages in OAF Pages.
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application.
• Developed New Programs to automate Creation of Items, BOM, BOM Routing.
• Developed New Programs to read data received from EDI systems and importing into Oracle EBS System.
• Created AOL Objects for development work.
• Creation of Custom Forms to capture DADC Artwork/Special Projects Quotes.
• Implementing the Workflow system for Approvals.
• Created new forms to show Quotes Summary.
• Implemented business logic to calculate profit and loss made by finished good and by customer by writing pl/sql packages.
• Created XML Reports to show Artwork/Special Projects Quotation Information.
• Created AOL Objects for development work.
• Created migrated files using FNDLOAD and preparing migration list.
• Involved in Technical Design.
• Post production support as per Change Request.
• Creation of new custom OAF Page search page to show Paceline/Special Projects Data.
• Custom OAF Search page to show Assembly/Distributed Information.
• Created XML reports to show Artwork Headers information (Summary Report).
• Created XML reports to show Artwork/Special Projects detail information.

Environment: Oracle applications EBS R12, PL/SQL, Developer 2000(Reports 9i/10g and Forms 9i/10g), SQL Developer, SQL*Plus, TOAD, XML/BI Publisher, SQL*Loader, AP, AR, GL, PO, WIP, INV, BOM, iProcurement, iExpenses.

Confidential

Oracle APPS Technical Consultant

Responsibilities:

• Form Personalization on Receipts Creation Form.
• Gathered the requirements from through meetings with business users.
• Worked with the functional team while extracting non-Oracle data and Converting to Oracle with validations
• Developed PO Detail and PO Summary category Report
• Design and Development of Critical Financial reports using XML Publisher.
• Design and Development of Payables and General Ledger reports using Reports 10g.
• Worked on Customizations Involved in Requisition Approval Notification workflow.
• Involved in Implementing AME Approval hierarchy.
• Defined the Approval Groups in the Purchase Order (PO) AME Approval hierarchy.
• Worked on the Open Invoices Import Programs.
• Worked on Supplier API to update the supplier site level data.
• System Administration tasks related to Menus/ Functions, Responsibilities, Users.
• Responsible for Technical documentation.
• Worked on Apex Reports.
• Developed PL/SQL conversion programs from feeder systems for OM (Order Management) module.
• Worked on Intercompany transactions reports for AP/AR.
• Worked on Bank Reconciliation Report in Cash Management (CM).
• Developed GL/AP Interface Programs to import Journals data into Oracle EBS System.
• Customization on “Pay on Receipt” Programs to update invoice number as per receipt.
• Developed XML Publisher reports to General Ledger (GL) Encumbrance Balances.
• Created Interfaces to send the Purchasing (PO) data from Oracle ERP system to OBIEE Database.
• Developed Fixed Assets (FA) Detail and Summary reports using XML/BI Publisher.
• Created Custom Forms to support Business Specific Quotes Creation Functionality.
• Implementing the Workflow system for Approvals
• Created XML Publisher reports to show Artwork/Special Projects with Quotation Header, Line detail information and Summary Reports.
• Importing sales orders from Legacy System to Order Management (OM) seeded tables.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories
• Responsible for end to end implementation of iExpenses Approval Workflow using Approvals Management Engine (AME).
• Responsible for end to end implementation of Requisition Approval Workflow using Approvals Management Engine (AME).

Environment: Oracle Applications EBS R12 (GL/AR/AP/FA/PO/INV/OM/HRMS modules), SQL Developer, PVCS, Apex, Oracle 10G, UNIX

Confidential

Oracle APPS Technical Consultant

Responsibilities:

• Design and Development of HRMS, Payroll reports using BI Publisher.
• Worked on Special Information Types (SIT) Interface Program.
• New BI report to show current payroll run and previous month payroll run results.
• Design and Development of Payables and General Ledger reports using Reports 10g.
• Worked on Customizations Involved in iRecruitment Notification workflow, Employee Termination workflow.
• Design and Development of Appraisal Summary OAF Page which display all performance rating factors.
• Created OAF search pages for Employee Appraisals Ratings, Manager View page, Admin page for tracking appraisal status.
• Design and Development of HRMS, Payroll, OLM reports using Reports 10g, BI Publisher.
• Changed the company logo in all the BI reports.
• Worked on Forms Personalization to disable deletion option to user in Assignments Process Results Form.
• Developed new report for employee’s hire or termination notifications.
• Customized Invoice report to show invoice created by and creation date.
• Created new report for GL Encumbrance Balances.
• Created new report for GL Voucher reports with Sub Ledger Information.

Environment: Oracle Applications EBS R12 (HRMS/Payroll/FA/GL modules), SQL Developer, Toad, PVCS, Oracle 11G, UNIX, BI Publisher and OAF.

Confidential

Oracle APPS Technical Consultant

Responsibilities:

• Developed Reports, Interfaces, and Customizations & Extensions (RICE) in AP, AR and GL modules.
• Involved in Major support of Receipt Open Interface logic in AR, AP.
• Migrated AP Custom Interfaces and reports from 11i to R12.
• Worked on Remedy AP/AR/GL Support Issues.
• Production Support and Development for Global Confidential in PO/AP/AR/GL Module.
• Responsible for development of Purchase Order (PO) Report, Request for Quote (RFQ), Request For Bid (RFB) using BI Publisher.
• Developed Interfaces to load Supplier, Invoices Information from Legacy Systems
• Involved in Developing the Receivables Invoice Prints Using Oracle XML Publisher
• Implementing the Workflow system for Approvals
• Personalization and Extension of Oracle applications in Oracle Payables Module using OA Framework (OAF). Created CUSTOM JAVA TOP on server for customized OAF pages.
• Developed Interface to Import Orders from Legacy System to Order Management (OM) seeded tables
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories
• Worked in Roll-in team to implement the existing supplier/invoice/receipt/Purchase Order interfaces and conversion.
• Involved in Production Support of the interfaces.
• Appworx Job modifications/Changes depending on requirement.

Environment: Oracle Applications EBS 11i/R12 (AP/AR/GL/FA/PO/OM/INV/iExpenses/iSupplier), Toad, SQL Developer, Forms 6i/10G and Reports 6i/10G, OAF, Clear Case, Appworx, Oracle 9i/10g, UNIX

Confidential

Oracle Product Development Engineer

Responsibilities:

• Implementing Oracle Apps Standards to the Product.
• New Form Development
• New Report Development
• Testing the Application.
• Developing Key Database objects and Forms Functions.
• Analyzing the code of all the forms in order to reduce redundancy in code.
• Involved in tuning the form in order to increase the performance and decrease the size.
• Tuning of Sql Statements and Pl/Sql Procedures, functions and packages
• Involved in development of Pl/Sql packages and database triggers.

Environment: Custom ERP Application, SQL Developer, Oracle 9i, Forms 6i/Reports 6i, UNIX