SUMMARY:

• Over Six years of IT experience with over six years of strong technical experience in design, implementation, and customization of Oracle Applications 11i (GL, AP, PO, AR, TCA, FA, OM, INV, AOL).
• Oracle Certified Professional
• Experience with oracle Developer 2000 (Forms 10g/6i and Reports 10g/6i), Discoverer and Workflow builder.
• Expertise in design and development of Interface Programs.
• Experienced in Developing Technical Specification and Design Documents.
• Excellent understanding of the AOL and System Administration module.
• Extensive experience in customization of standard forms using forms personalization and CUSTOM.pll, customization of reports, defining concurrent programs, defining value sets, defining form functions and functional setups.
• Monitored queries with high response time and high disk read per execution and tuning the same using SQL tuning advisor.
• Experience in design and development of conversion & interface programs in PO, AR, AP, OM & INV modules.
• Expertise to build Web applications using Oracle ADF.
• Experience in purchase order, receiving, supplier invoice and customer invoice interface programs.
• Knowledge in various states of System Development Life Cycle (SDLC). Like System Analysis, Applications Design, Development, Integration & System Testing Support of Oracle 9i, Oracle 10g and Oracle 11g in Production, Staging, and Development environments.
• Strong programming experience in creating Tables, Procedures, Packages, Cursors, Functions, Triggers and Data Migration using SQL and PL/SQL. Proficient in writing and tuning complex SQL statements.
• Creating user defined Menus, Function and follows ups of TAR and Applications of Patches as and when required.
• Extensively worked on creating web pages using APEX and also Java script and JQuery.
• Extensive experience in design and implementation of Oracle Alerts.
• Extensive implementation experience in Oracle Applications Multi - Org Environment.
• Experience using project management tools such as AIM Methodology, Microsoft Project, Visio, etc.
• Strong Analytical, Problem solving and communication skills. Strong communication and inter-personal skills at the technical level and end user level.

TECHNICAL SKILLS:

ERP: Oracle Applications Release 11.5.10, 11.5.8, 11.5.3, 11.0.3(AP, PO, GL, FA, AR, CM, OM, INV, WSH, SYSADMIN, AOL)

Languages: SQL, PL/SQL, C, C++, JAVA, HTML, XML

RDBMS: Oracle 8i/9i/10g, MS Access

GUI Tools: Reports 2.5/6i/10g, Forms 4.5/6i/10g

Other Tools: SQL*Plus,SQL*loader, Discoverer 4i, 10g, APEX,TOAD, XMLPublisher

Operating Systems: UNIX, Linux, Windows 2000/NT/XP, Ms-DOS

Packages: MS-Office, EXCEL

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Oracle Applications Technical Consultant

Responsibilities:

• Involved in the development of the (Electronic Invoice Presentment and Payment) EIPP system .
• Developed customer conversion and sales invoice conversion programs.
• Developed custom program to load the descriptive flexfields stored at the party level to store at the customer account level using the TCA API.
• Experience in Developing the web based applications with Oracle ADF using JDeveloper 10g.
• Developed the outbound interface for invoice information to be used in the EIPP system.
• Developed a program to get the receipt file from the External system (invoice payment processing system) and send an email notification to the user about the remittance.
• Worked on Authentication Schemes, Authorization Schemes, Application Computation Application items, List of Values (LOV), Tabs, and Lists Etc
• Installed and configured APEX 4.0 in-order to migrate the application from 3.2 to 4.0
• Developed Item Conversion using Open Item Interface in the inventory module.
• Developed Sales Order Conversion using the Order Import Program.
• Developed automated receipt control for specific items using the ROI process in Purchasing Module.
• Developed Shell Scripts to automate the process of transmission of files between the Oracle Applications and External system
• Modified Custom forms for the EIPP system maintenance.
• Developed Purchase Order Interface program using PDOI process in Purchasing Module.
• Developed Sales Invoice Conversion programs in payables module.
• Developed expense report import program to import all the expense reports in payables module using Payable Open Interface program.
• Developed Sales Order interface program using the OM API to integrate an existing legacy application.
• Created new business areas and workbooks in Discoverer 10g.
• Customized the Customer interface report and invoice report in AR
• Developed supporting Functional and Technical documentation using the AIM Methodology.
• Maintained all the documentation and code using Rational Clear Case tool.

Environment: Oracle Applications Release 11.5.10 (AR, AP,PO,OM,INV), Oracle 10g, SQL, PL/SQL, Forms 6i, Reports 6i, TOAD, UNIX Shell Scripting, Solaris, Work Flow 2.6.2, Rational Clear Case, XML SPY.

Confidential, Philadelphia, PA

Oracle Applications Technical Consultant

Responsibilities:

• Developed Customer Conversion in Receivables Module.
• Developed the item conversion to import all the inventory items present in legacy system to Oracle 11i system.
• Experience in deploying the web applications that use ADF to Oracle Applcation Server and Tomcat.
• Developed customer interface program using the TCA API.
• Involved in Conversion of the existing sales transactions in the AR module of legacy system to AR module in the instance.
• Worked on AR setups to accommodate the existing business process on the legacy instance in to the current UPS system with minimal impact to both business processes.
• Involved in design and development of conversion and Interface program for importing Sales orders from legacy Order Management system.
• Developed program to create accrual extract file to be used for creating journal entries in the GL interface tables.
• Developed supplier invoice interface program & Conversion program using the Payables Open Interface program.
• Designed and developed Workbooks & Worksheets in Discoverer 9i to display Purchase order details like order number and legacy service order number.
• Created various Categories of forms and reports using Oracle APEX
• Created interactive reports and forms in a page for data entry and register application
• Developed custom account code combination generator to accommodate the difference in the accounting structures in legacy system instance to Oracle applications 11i system.
• Developed on PO interface to create purchase orders for the sales orders that are created in the legacy Order Management System.
• Developed PO Conversion program which converts the existing open purchase orders in to the UPS Oracle 11i instance.
• Customized the Confirm Receipts Workflow as per the business requirements in purchasing module.
• Customized PO Requisition Approval Workflow as per the requirement.
• Created New approval groups and new supervisor hierarchies that reflect the ones existing in the 11.0.3 instance, in the 11.5.10 instance.
• Developed Vendor Conversion program to import vendor information from 11.0.3 instance to the 11.5.10 instance.
• Developed Receiving Interface to import receipts transactions for the purchase orders created by the interface program specifically for the purchase orders created for the sales orders in the legacy Order Management System.
• Handling the enhancements due to change in business rules.
• Working on issues related to sales transactions created in the legacy Order Management System.
• Designed CV60, MD70, MD120 and UTP Documentations
• Developed supporting Functional and Technical documentation using the AIM Methodology.
• Maintained documentation and source code control using PVCS.

Environment: Oracle Applications Release 11.5.10 (GL, AR, TCA, AP, PO, INV), Oracle 10g, SQL, PL/SQL, Forms 10g/6i, Reports 6i, SQL * Loader, PL/SQL Developer, UNIX Shell Scripting, HP-UX, Oracle Discoverer 9i, XML Publisher, PVCS.

Confidential, Carson City, NV

Oracle Applications Technical Consultant

Responsibilities:

• Designed and developed Customer and Sales Invoice Data Conversion programs.
• Worked on Trading Community Architecture, developed interface program to load data into Parties, Customer, Addresses, Contact, Telephone details from legacy systems.
• Created business areas from End User layers to Oracle Discoverer 9i Reports as per requirements.
• Worked on PO Conversion program which converts the existing open purchase orders.
• Developed Vendor Conversion program to import vendor information.
• Sales Order Import program coming from external feeder systems through OM Open Interface.
• Developed Invoice Import program in AP to import the invoices from external feeder system.
• Created work books & Worksheets from the business areas in Discoverer 9i for displaying the sales invoice history and payment history for customers.
• Created XML Publisher reports and using various templates to publish the Sales Invoice in various output formats based each customer requirement.
• Wrote test scripts to perform Unit Testing.
• Used FND LOAD utility to migrate concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc.
• Developed an automated build wrapper script to automatically compile custom objects, and load .ldt files using FND LOAD utility in all target test instances. This build wrapper script was very useful to deploy custom programs from Development instance to Test Instances.
• Developed technical documentations of work done complying with AIM Methodology.
• Developed item conversion program using the Item Open Interface program.
• Performed various setups in the Purchasing module.
• Modified the Receipt Confirmation workflow process to suit the business requirements in the purchasing module.
• Created documentation using AIM methodology
• Maintained documentation and source code control using Clear Case tool.

Environment: Oracle Applications Release 11.5.9 (AP, GL, AR, TCA, OM, INV), Oracle 10g, SQL, PL/SQL, Forms 10g/6i, Reports 6i, SQL * Loader, TOAD, UNIX Shell Scripting, AIX UNIX, XML Publisher, Rational Clear Case.