Summary

• Have Experience in Production Support, provide Solution discussions in inventory, Purchasing and Order Management of Oracle Applications 11i and R12 environment. Have good functional knowledge in Oracle Inventory, Purchasing and Order Management modules and knowledge in Bills of Material, Payables, General Ledger and Receivables. Good experience in programs debugging, issues resolution and providing new business solutions. Personalized Oracle Application forms as per the client requirement using Forms personalization functionality in Oracle Applications. Exposure on Oracle Application Framework OAF and SOA. Experience in system cloning activities, providing patch analysis, concurrent manager load balancing and integration between R12 and touch point systems. Good working knowledge in designing technical documents using AIM Methodologies. Excellent communication and interpersonal skills to handle the client meetings and solution discussions. Education
• Professional Summary Over 8 years of IT experience as Oracle Applications Techno Functional consultant, with expertise in analysis, feasibility study, design, coding and testing phase of Oracle 11i and R12 projects. Have multiple project experience involving Implementation, Upgrade, Customizations, Conversions, Solutions and Multi-language development.
• Have Full Life Cycle Implementation Experience on Procure to Pay and Order to Cash
• Hands on experience on development of RICEW Conversions, Reports, Interfaces, Extensions and Menus, Functions, Value Sets, Concurrent Programs, Lookups, Database Objects and Shell scripts.
• Expertise in developing and customizing Reports and Forms in Oracle E-Business Suite R12/11i, Oracle 11g/10g/9i/8i, Oracle Reports/Forms, XML Publisher.
• Bachelor of Engineering JNT University, Hyderabad

Technical Skills:

Professional Experience:

Confidential

Senior Oracle EBS Developer

Role and Responsibilities:

• Worked on Item master data conversion from 11i to Trilogy R12 system.
• PO Requisitions Interface to import approved requisitions.
• Worked on AP Suppliers conversion program to migrate the suppliers from legacy system into oracle applications. All this kind of master data would be migrated before the go-live date of the project.
• Contributed in developing standard purchase orders conversion program from legacy system.
• Written Shell scripts to read, write, rename and transfer the files from oracle server path to other systems.
• Developing interfaces from external systems to Global R12 instance via Fusion Middleware.
• Involving in GAP and Impact Analysis for Customer Requirements.
• Prepared Inventory materials report and registered as concurrent program in oracle.
• Worked on shipping details report based on the given purchase order numbers.
• Involved in code migration activities through Kintana.
• Good experience on the creation of database objects like procedures, functions, tables, views, synonyms, packages to generate the requisition numbers and transaction numbers according to the client's business requirement.
• Developed Common error handling report to capture errors in interface execution and will send mail to users.
• Developed AP Future date Invoice Transactions Report.

Environment

Oracle Applications 12.1.3 INV,PO,OM,AP,AOL ,Report Builder 10g, Oracle Database 10g, SQL Plus, PL/SQL Developer, Toad, WinSCP, Remedy, Putty, SQL Loader and Kintana.

Confidential

Senior Support Analyst

Role and Responsibilities:

• Understanding the Tickets raised by customers and resolving them
• Responding to the user mails
• Involved in Problem Tickets and L3 code fix.
• Prepared SOP standard operating procedure for the repetitive scenario
• Involved in month end process
• Worked on Form and OAF personalization
• Involved in enhancements and used to handle SRT calls.

Environment

Oracle Applications 12.1.1 INV, PO, OM, AP, GL, AR and SYSADMIN ,Remedy Tool, Form Builder 10g, Report Builder 10g, Oracle Database 10g, SQL Plus, PL/SQL Developer, Putty.

Confidential

Senior Technical Developer

Role and Responsibilities:

• Contributed in transferring the data from legacy system to the oracle applications base tables through interfaces using SQL loader.
• Items: Extracted the items from 11.5.9, loaded the data into interface tables and ran items import program for the creation of new items.
• Item Categories: Got the data file with information about category set and the category to be assigned to the items.
• Item Cost: Extracted the item cost data from 11.5.9, loaded the data into interface tables and ran item cost import program.
• Creating Alerts.
• Registering Concurrent Executables and Concurrent Programs.
• Preparation of Technical specifications from the functional specifications received.
• Worked on form personalization for PO form personalization to modify Bill To Location field property as read only.

Environment

Oracle Applications 12.1.1 INV,PO , Form Builder 9i, Report Builder 9i, Oracle Database 9i, SQL Plus, PL/SQL Developer, Toad, WinSCP, Putty, SQL Loader

Confidential

Senior ERP Developer

Role and Responsibilities:

• Contributed in developing a interface program for customer master data from oracle 11i system to R12
• Extracted the data and developed report to show the Receivables Transactions based on distribution accounts.
• Developed and Registered the AR Receipt Balances Report in Oracle Applications.
• Customized Intercompany Auto Match Reconciliation Report to accommodate the new batch source invoices.
• Designed and developed the AP Paid Invoices Report for the users to get the details of the invoices paid between the particular date ranges.
• Transferred the open balance customer's data from receivables to legacy system GetPaid by extracting the data from oracle applications base tables and prepared the data file using UTL File utility.
• Developed XML publisher reports.
• Migrated oracle payables invoices data from 11.5.10 to 12.0.4 of oracle applications.
• Developed GL Balances for PTD and YTD for balance sheet report. This report will provide the PTD and YTD balances across all set of books worldwide for account range entered by the user as the parameter.

Environment

Oracle Applications 12.0.4 OM, AP, AR,GL , Form Builder 10g, Report Builder 10g, Oracle Database 10g, SQL Plus, PL/SQL Developer, Toad, WinSCP, Putty, SQL Loader

Confidential

Technical Developer

Role and Responsibilities:

• Contributed in developing a program to fulfill the functional requirement of bringing the OM holds data from the feeder system into the current application that is being implemented.
• Worked on Standard purchase orders conversion. Conversion of standard purchase orders to Oracle Applications using Import Standard purchase orders program
• Developed Update Price List Program to calculate the corresponding price list with the latest work rate.
• Create Event alerts like whenever the event takes place i.e., the receipt is reversed the alert should be triggered.
• Create an event on insert alert that sends a message to the buyer indicating that items received in the inventory according to the purchase order raised in Purchasing by the buyer.
• Developed XML Report to show all the Unpaid Invoices Matched with Receipts sorted by Supplier Name
• XML Report: Develop a report to compare PO Invoice between this year's quarter and the previous year's same quarter. This report is group by Supplier.
• Developed an XML Report to show all the Payables Invoices against which receipts were made but returned in full or partial.
• Develop a Report Orders Scheduled to Ship Report

Environment

Oracle Applications 11.5.10 PO,OM, AP, AR, GL , Form Builder, Report Builder 6i, Oracle Database 6i, SQL Plus, PL/SQL Developer, Toad, WinSCP, Putty, SQL Loader

Confidential

Technical Developer

Role and Responsibilities:

• Developed custom report to show the details of sales orders raised and successfully transferred from the external systems into oracle and scheduled the report to run on a daily basis in application.
• Developed AP Payments Preview Report.
• Preparation of Technical specifications from the functional specifications received.
• Designing and development of customized object/programs in Oracle Database/Applications as per the business requirements.
• Developed a report to display PO details with supplier, org, dates, total amount, matched with Invoice amount, yet to be matched amount, etc . For a range of PO-s by operating unit.
• Developed 'Return to Vendor Report' is basically a report that is developed to list out the items that were returned to the vendors based on the organization that has made the returns and the buyers involved in each of these organizations.
• Contributed in development of outbound interface of Drop Ship PO's.
• AP invoices distribution form customization to view matched PO form.

Environment

Oracle Applications 11.5.10 INV,PO,OM, AP, AR, GL , Form Builder, Report Builder 6i, Oracle Database 6i, SQL Plus, PL/SQL Developer, Toad, WinSCP, Putty, SQL Loader

Confidential

Technical Developer

Technical Activities:

• Writing packages, developing conversion and interface programs, reports and registering them as Concurrent Programs in AOL. Developing PL/SQL code to obtain the required functionality.
• Registering Concurrent Executables and Concurrent Programs.
• Worked on development of Jobs Management Software for the workshops located at all retail outlets of the company.
• Worked on developing several programs that include development of forms, reports, PL/SQL packages, SQL reports, triggers, tables, indexes, sequences using Oracle 8i.
• Was involved in design, development and testing of the programs.
• Documenting the user help guides.

Environment

• Oracle Applications 11.5.10 INV,PO,OM, AP, AR, GL , Form Builder, Report Builder 6i, Oracle Database 6i, SQL Plus, PL/SQL Developer, Toad, WinSCP, Putty, SQL Loader