Oracle Applications EBS Techno-Functional Consultant

• 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.
• 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. Technical Skills:

Confidential Professional Experience:

Senior Oracle EBS Developer

Client Description:

Motorola Solutions has most of its ERP applications running on SAP, Oracle Apps 11i versions for different regions. All legacy application interfacing with Motorola ERP should be pointed to Oracle Applications R12. The project involves developing interfaces and converting master and transactional data from multiple regional instances of Oracle Applications and SAP to a single Global Oracle R12 instance, developing WRICE components using Oracle Developer Suite 10g and PL/SQL scripting.

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

Client Description:

Motorola is known around the world for innovation and leadership in wireless and broadband communications. The project scope is to support business users while executing the business and support L2/L3 tickets.

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

Client Description:

• BT is a global provider of communications solutions and IT services, It has significant local operations in Northern Ireland and the Republic of Ireland.
• For consumer customers it will provide 'total communications' services including phone, online and entertainment solutions in neat and great value bundles for business and government organizations it brings together all their communications and IT services securely and efficiently and for other communications providers BT provides their network on an open access basis so that they can connect to their customers, and BT can design, build and manage their networks for them.

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

Client Description:

Juniper Networks is the leader in high-performance networking Innovative businesses view the network as critical to their success. Juniper Networks offers a high-performance network infrastructure. Juniper's networking solutions create a responsive and trusted environment for accelerating the deployment of serves and applications over a single network. The current project aims at loading universal financial and customer master with customers, contacts and Addresses data from different sources.

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

Client Description:

Smith International Inc. is a leading worldwide supplier of premium products and services to the oil and gas exploration and production Industry. The Company provides a comprehensive line of technologically-advanced products and engineering services. The company also offers supply-chain management solutions through an extensive North America branch network.

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

Client Description:

The company is involved in the whole selling and retailing of food, beverages and other consumable items. It also provides services in insurance, travel, shipping and engineering.

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