SUMMARY

• Over 8 years of IT experience as a Oracle Techno Functional Consultant in Oracle Applications Release 12 E - Business Suite
• Involved in implementations & Supporting Projects of Oracle Applications R12 &11i, with hands-on working experience on various RICE Components (Reports, Interfaces & Conversions).
• Expertise in Order to Cash and Procure to Pay Cycle.
• Good Technical and Functional knowledge of the SCM Modules (Order Management, Purchasing, Inventory, Quoting) and Financial Modules (Account Payables, Account Receivables, General Ledger)
• Excellent skills in SQL, PL/SQL
• Expertise in Oracle Forms development using Oracle Form Builder 10g
• Involved in development of BI Publisher reports
• Involved in Development of OAF (Oracle Application Framework) pages.
• Working knowledge on ADF (Application Development Framework)
• Extensive experience in creating Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD
• Expertisein System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.
• Design the Technical DOC. (like MD 070 and TE 040 DOCs) of respective Components, familiar with all Functional documents like MD50
• Experience in working with PVCS version manager, Smart SVN, TRAC and Serena Products
• Expertise in Unix Shell Scripting
• Exposure on Release 12i (R12i).
• Involved in R12 Up gradation Project.
• A highly motivated, energetic individual and a team player with excellent analytical & problem solving skills, communication skills and interpersonal skills

TECHNICAL SKILLS

ERP: Oracle Applications (OM, INV, PO, ASO AR, AP, GL)

Operating Systems: Windows XP and UNIX.

RDBMS: Oracle 8i/9i/10g.

Languages: SQL, PL/SQL and J2SE, JSP.

Tools: Toad, SQL*Plus, SQL*Loader.

Reporting Tools: Reports6i and XML Publisher.

GUI: Forms10g, JDeveloper

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle Applications Techno Functional Consultant

Responsibilities:

• Responsible for converting AR (Account Receivables) invoices from legacy system to Oracle using open interface tables.
• Developed an Interface to create adjustments in AR (Account Receivables) using oracle delivered API’s.
• Developed an Interface in Cash Management to load transactions into the open interface table.
• Developed an interface to create on RMA order in OM from the invoice number provided by the user using the oracle delivered API’s.
• Developed Supplier listing report in Oracle Account Payables using XML publisher.
• Developed Account payables Trail Balance report using XML publisher.
• Worked on the TCA Conversion in Oracle AR
• Development of Custom Forms, Interfaces and XML Reports.
• Modified functional setups involving SCM modules.
• Created new & modified existing Forms Personalization's.
• Developing customizations in Quote to Cash Modules.
• Solving SDRs and migrating objects to higher instances.
• Creating MD70's and updating as per the changes made.
• Worked closely with BPEL team for integration & with QA team for testing.

Confidential

Oracle Applications Consultant

Responsibilities:

• Involved in Implementing Inventory, Account Receivables, and Order Management technical components in 12.1.3 instance.
• Worked on customizing the reports Transaction Register (INVTRREG) to change the layout, add parameters to fit in the client requirements.
• Built a new custom report on Inventory Aging showing transaction date, sub inventory, item number, on-hand quantity and transaction type depending upon aging bucket.
• AR - Worked on the Auto Lock Box process
• Create the receipts and post the data into standard oracle interface tables. Created a report of records created and rejected.
• AR Auto Invoice Interface - Worked on the Auto Invoice interface program to import invoices from an external system into Oracle.
• Worked on building Customer Interface object that uploads the customer, customer ship to address, customer ship to address contact and customer contact relationship data from a flat file through sql loader and the Oracle API hz cust account role v2pub.
• Code, test, debug, document and maintain programs.
• Involved with conversion of data, mapping field values, filtering unwanted data, error handling and tracking.
• Preparation of technical specification from functional specification.
• Responsible for Unit testing and user acceptance testing (UAT).
• Co-Ordinate with offshore team in resolving the issues.

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Solving Production Tickets
• Fixing issues in Forms, Reports, Packages
• Modifying various technical components in OM, INV, AR modules
• Creating and modifying shell scripts.
• Involved in designing new packages for Interfaces.
• Fixing issues pertaining to custom sales order process.
• Quick delivery of production major tickets which doesn’t hinder clients business.
• Day to day interaction with users for requirement gathering on the raised tickets.
• Used Smart SVN to get the latest code from the server and ensuring that no one locked a particular object
• Used Trac to update the status of the tickets and assign back to customer for user testing.
• Created custom process to send PDF output as an email attachment to the users about the rings processed.
• Fixed various issues pertaining to custom sales order process.
• Working closely with DBA to ensure migration to QA and PROD instance happens without any issues.
• Developed various CSV reports from scratch.

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Supporting all the EDI transactions (846,850,856,810,753,754,869 and 870) transactions
• Worked on the technical components in the implementation of Order to Cash and Procure to Pay Modules
• Various customizations in O2C & P2P modules.
• Supporting the custom ship confirm process which is developed using the standard API’s.
• Developed a new Packing routing using the shipping API’s based on the retail chain packing requirements.
• Developed and EDI 850 pre process screen so the end users can review the 850 data before they are loaded as sales orders.
• Developed Out bound extraction-using UTL File. Involved in customizing Shell Scripts for different EDI processes.
• Developed pl/sql package to validate order details before processes to sales order.
• Registration of Concurrent programs, attaching concurrent programs to Request Groups.
• Creation of Value sets, Flex fields for all modules and done Registrations like Reports, PLSQL Stored Procedures and SQL*Loader files.
• Developed & customized several reports and interfaces in modules PO, OM, INV, AP and AR.
• Design the Technical DOC. (like MD 070 and TE 040 DOCs) of respective Components.
• Good understanding of AIM methodology
• Developed and Customized Conversions and Interfaces.
• Involved in the development of Stored Procedures and PL/SQL Packages.
• Involved in Development of plsql scripts using API’s.
• Involved in defining of various functional setups.
• Involved in developing various custom forms (Regal 850 form, Regal Landed Cost, Regal Customer allowance).
• Involved in developing OAF forms (Service Request).
• Involved in client discussions and gathered information directly with client.

Confidential

Technical Consultant

Responsibilities:

• Developed and Customized Reports.
• Designing new reports as per the client requirement using XML publisher.
• Involved in solving tickets in Production Support.
• Created Control Files for SQL Loader to load from Text Files.
• Developed PL/SQL Package to validate Item details and Item Interface.
• Used FND LOAD to get the Concurrent Programs Details and Registering Concurrent Programs in R12.
• Modifying the Packages, Views, Valuesets etc... To meet the new Functionality of R12.
• Developed Value sets for various modules.
• Communicating with Clients.
• Involved in Unit testing.