SUMMARY

• About 8 years of experience, which includes over 6 years of experience as an oracle application Technical consultant with good exposure in Oracle Tools, Technologies, applications implementations and upgrades.
• Good experience in designing, developing, converting, implementing and Up - grading Oracle Applications 11i, R12 using ORACLE 10g/9i/8i, SQL, PL/SQL, Forms and Reports.
• Extensively worked on RICE (Reports, Interfaces, Conversions and Extensions) components of the Oracle E-Business Suite spanning across the 11i & R12 releases.
• Participated in all the phases of SDLC including specifications, design, and development, Testing, Training and Deployment. Has extensively worked as a Technical Consultant in various modules like Procure to Pay, GL, AP, AR, OM and O2C.
• Very well conversant with all aspects of Application Object Library (AOL) development standards, API’s and System administrations.
• Experience includes design & development of Applications using Oracle 8i, 9i & 10g, Reports (6i/10g).
• Good Experience in developing Form customization and personalization and custom.pll using For builder 6i and 10g.
• Strong knowledge in Data Migrations, Development and Customization of RDF and XML Publisher Reports.
• Excellent knowledge of Flex fields, Multi-Org and Multi-Currency.
• Good experience in SQL and PLSQL well in writing Triggers, Procedure, cursors as per the client requirement.
• Possesses excellent communication skills with strong adaptability, Team-work and Time management.

TECHNICAL SKILLS

Operating Systems: Unix, Linux, Windows

Languages: SQL, PL/SQL, Java

ERP Applications: Oracle Applications 11i & Release 12 General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Inventory(INV),Purchasing(PO),ReleaseManagement(RLM),Order Management(OM) and (AOL)

Oracle Tools: Developer 6i, Developer 10g & SQL*Loader, Form Builder, Work Flow Builder.

Reporting Tools: Oracle Reports Builder, XML Publisher 5.5/5.6

Methodology: Oracle Application Implementation Method 3.0

Database / RDBMS: Oracle 8i, Oracle 9i/10g

Architecture: OA Framework

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Oracle Technical Developer

Responsibilities:

• Worked on Interface, moving data from legacy system to interface table of new system.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL* Loader and did all the necessary validations before loading into AP INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables and Calling Payable Import Program.
• Worked on all components of Workflow builder (Workflow engine, workflow Definition, workflow monitor).
• Experience in performance tuning of custom objects (views, stored procedures, reports).
• Extensively worked on Cursors, PL/SQL Tables on TOAD in the interface development and used exception wherever necessary to improve the performance.
• I have developed the Supplier conversion to import Suppliers information from Legacy system into purchasing module of Oracle applications.
• I have developed an AP Open Invoice interface to import Invoices from Legacy system into Account Payables module of Oracle Applications.
• Involved in designing and developing PL/SQL Packages, Procedures and Functions as per the requirement.
• Implemented no. of PLSQL procedures to generate the XML data files which is used by XML to generate XML templates as part of “Shipping Docs Bypassing Concurrent Manger”.
• Worked on developing several oracle RDF reports and forms based on client requirements.
• Developing new forms based on single table ad multiple tables, single or multiple database blocks, Used pop up menu, alerts, program units, LOVs, visual attributes and libraries to make the front end application to make it user friendly interface as much as possible.
• Involved in Production support at different stages of the project
• Created custom programs to expedite and progress the order headers and lines stuck in error, purge the workflow errors using standard call to OM, WSH and WF APIs.
• Customized the Order Header level and Line level Workflow (WF) processes to add the custom activities
• Designed Fixed Assets Conversion which is a conversion from legacy systems
• Upgraded, maintained and troubleshooting Oracle Forms and Reports.
• Prepared CV060, MD070 and MD120 as part of the development process.
• Worked on an outbound interface Positive Payee file outbound interface for generating a payment file for the client.

Environment: Oracle ERP 11.5.10, R12.

Confidential, New York City, NY

Oracle Apps Technical Developer

Responsibilities:

• UMX-RBAC (Role Based Access Control) model implemented in client. this is new feature in R12
• OAF Personalization (Accounting Setup from in GL module had personalized according to client business requirements)
• Worked on required R12 Changes in GL,AP code and tested in R12 environment
• Customized interface to accommodate alternative code combination for R12.
• Responsible for writing several pl/sql procedure, functions, triggers.
• Worked on Developing Discoverer reports, and modified existing reports.
• Implemented sub ledger accounting concepts in Confidential .
• Involved in studying as-is process, requirement gathering, mapping solutions, Conference Room Pilot sessions, discussions with client, suggesting and implementing the solutions.
• Developed and implemented custom interfaces using oracle tools and API for system integration between internal and external systems.
• Developed concurrent programs to validate and update the item details in GL module.
• Worked on EDI interfaces to automate the edge label creation for different business units.
• Raised the Oracle SR (service Request) to fix the bugs in Invoice workbench & Tax related issues as well as to understand the new functionalities of R12 AP. Also interacting with the users as per urgency of issues & better understanding the Confidential process.
• Created user-level personalizations, administrator personalization’s, Deploy personalization’s and extensions.
• Worked with Discoverer so users would have the ability to generate ad-hoc reports.
• Designed a major customization involving Oracle Inventory and Oracle Purchasing. The customization required creation of new tables, database triggers, concurrent programs and forms.
• Developed a custom program to update vendor of type employee communication details.
• Imported data from flat files located in legacy system into database table using SQL * Loader.
• Developed a program to populate the vendor banking details.
• Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
• Developed a custom program to update item expense account based on client requirement using AP.

Environment: Oracle ERP 12.0.6 Forms 10g, Reports 10g, UNIX, Discoverer 10g.

Confidential, Fremont, CA

Oracle Application Developer

Responsibilities:

• Developed and tested custom forms developed using Oracle Forms 6i and reports using Oracle Reports 6i.
• Developed Interface to Export the Requisitions to flat file which will be used to update the Legacy System.
• Developed and tested outbound and inbound interfaces to interface Oracle with other systems.
• Customized the standard oracle forms for the client requirement using CUSTOM.pll technique.
• Imported the data into Oracle from Legacy flat files using UNIX shell scripts and SQL Loader.
• Scheduling the program runs using Appworx tool.
• Automated the conversion process using Oracle Workflows
• Involved in the development of numerous XML repots for Pack Slip, Commercial Invoice and Bill of Lading reports.
• Whirlpool schedule modification RLM.
• Horizon Updates Concurrent Program in RLM, Zero Elimination program in RLM.
• Developed IBS and GECARS outbound interface in AR.

Environment: SQL10g, PL/SQL10g, SQL*Loader, Toad.

Confidential, Louisville, KY

Oracle Technical Developer

Responsibilities:

• Developed a Custom Program to validate and Import Sales Order from legacy system into Oracle Application using order processing API.
• Gathered the requirements by talking to the user group and translated the requirements into detail technical and functional specifications.
• Participated in database development (Created PL/SQL stored procedures, functions, packages and sequences).
• Preparing PL/Sql procedures to refresh daily tables to full tables.
• Good Experience in various RICE components specifically Conversion/Interfaces, XML Reports.
• Worked on preparing shell program to schedule the scripts.
• Worked on preparing the gap report between entities and Fixing gaps
• Prepared the extraction queries for Items, Item Costs, Item Categories, Item extractions based on the user requirement.
• Customized the existing alerts for booking and shipping details information based on the business requirements.
• Customized existing discoverer reports Vendor Quality and Service Performance reports as per specifications.
• Developed an event based alert to process the stuck material transaction exceptions. Sending notification mail for the stuck transactions for the required people.
• Involved in Data Conversions Such as Sales order, Price List and etc.,
• Involved in Production Support activities for resolving the technical and functional issues.
• Involved in Pre and Post Month-end Activities.
• Involved in End user training and Documentation.
• Raising SR for oracle for few bugs in oracle.
• Involved in post testing for patches.

Environment: Oracle ERP 11.5.10, Unix.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Extensively Involving in Developing Database objects Like Stored Procedures, Triggers, Functions, Packages and Views using Oracle Pl/SQL.
• Data conversion through SQL* Loader, Stored Procedures and ad-hoc PL/SQL blocks to sync with newly developed interface systems.
• Customize Oracle Forms and reports for front end users.
• Develop Unit test plan and execute it
• Support during Integration testing, system testing.
• Requirement gathering and documenting requirements.
• Develop technical specification documents with screens, data conversion.

Environment: SQL*Plus, PL/SQL, DEVELOPER 2000 (ORACLE*Forms, ORACLE*Reports, ORACLE*Graphics),SQL*Navigator, Sql * Loader, TOAD, Windows XP, Lotus notes and MS-Office