OBJECTIVE

Grow in an organization that utilizes my skills, experience and enhances my professional development.

SUMMARY

• Over Seven years of experience as Oracle E-Business Suite Techno-functional Consultant in design, development and implementation in 11i/R12.
• Extensive experience in Oracle ERP modules like Financial Modules AP, AR, GL, CM and FA , Supply chain Modules PO, OM, INV and WSH , Manufacturing Modules BOM, WIP and AOL Objects.
• Strong implementation knowledge of O2C Order to Cash , P2P Procure to Pay Cycles.
• Experience in development of Packages, Procedures, Functions and Database Triggers using PL/SQL.
• Developed and customized RICEW components like Reports, Interfaces, Conversions, Extensions and Workflows.
• Experienced in Reports development and Customization using XML Publisher.
• Good experience in form personalization.
• Expertise in technical skills such as registration of Custom programs, Forms and Reports,Custom Development of Modules following application hierarchy.
• Experience in Oracle Application SYSADMIN.
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces APIs .
• Good knowledge on iExpenses and iProcurement.
• Extensive technical experience in Oracle Alerts, SQL Loader, Data Loader and Shell script.
• Extensively worked on Data Conversion, Migrations and Interface Programs.
• Experienced in Implementation, version upgrade, support maintenance projects.
• Experience with well-known clients having line of business like Sales, retail, manufacturing, insurance etc.
• Experience in writing MD70, MD120, MD50, CV040 and CV060 using AIM Methodology.
• Responsible for various phases of Software Development Life Cycle SDLC i.e. from executing CRP sessions, business requirement gap analysis, solution requirement gathering for custom interfaces, reports and conversions, QA Testing, Integration testing, hands on user training and post production Burn-in Supports.
• Experience in fixing issues and work with support team on SR and Bug fix.
• Highly motivated team player with good communication skills and excellent problem solving abilities would be willing to work independently or as part of a team.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Applications Consultant

Responsibilities:

• Involved in Requirement gathering, Analysis and Client interaction. This involves writing MD50 and MD70 Specs.

• Developed custom Check Printing solution in Oracle to replace the Paybase Application.
• Developed Check Templates in BI Publisher.
• Developed the custom programs to load the data intocustom tables, printing and reprinting the checks.
• Good Knowledge of payment processing in R12.
• Developed interfaces toconvert the data from legacy system called East Central suppliers/Invoices into Oracle.
• Worked extensively in testing conversion programs and Bug fixes.Involved in unit testing and performance testing of all conversion programs.
• Updated the Supplier Contact Details Using TCA API's.
• Exposure to Accounting Business Practices used in Oracle GL.
• Customized GL Journal entry form using form personalizationembedding trigger events with custom APIs as per the client requirement.
• Developed AP invoice interface for EDI 810 integration.
• Developed Purchase order history and Invoice on Hold report in BI Publisher.
• Personalized PO entry form to disable Changing PO price for few responsibilities.
• Customized the Accounts Payable Supplier Entry Form.
• Involved and resolved issues related month-end closing process in Account Payables.
• Involved in production support and helped service desk team in resolving oracle tickets.

Environment: Oracle Application R12 GL, PO, AP, AR Oracle10g/11g, Oracle Forms and Reports, XML Publisher, Work Flow Builder.

Confidential

Sr. Oracle Applications Consultant

Responsibilities:

• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the data into Oracle Standard interface tables.
• Involved in requirement gatherings from users, design and development of custom objects.
• Developed control files for SQL Loader in PL/SQL programs for loading and validating data into interface tables from Legacy systems.
• Developed the custom program to feed Customer data from the external source to the standard tables.
• Involved in AutoLock Box Receipt Interface to load data that is received from bank into interface tables from interface table to the Base Interim tables and finally to the base table.
• Involved in customization AR Transaction Detail Invoice History Report that enlists all the invoice related items including the credit memos, receipts and adjustments applied to it.
• Involved in custom sales order interface for EDI 850 integration.
• Used oe order pub API to change the Orders from entered to booked, released the holds and line adjustments.
• Customized OM Sales Order Line workflow for custom order lines and sending notifications.
• Developed Item interface import Program to integrate with Agile System.
• Developed Inventory Outbound Interface Program for EDI 846 to extract the inventory item/upc data from base tables to flat file using UTL FILE package.
• Developed a custom form to automate all Requisitions to PO's through which users can automatically select all Requisitions to Purchase Orders.
• Modified the Create PO Document and PO Approval workflows as per the Business requirements.
• Involved in Custom AP Payment Check formatprogram which creates payment file in custom format, designed by business users and send it to check printing group.
• Provided the production support for ongoing issues which are related to Order to cash and Procure to pay like Order Import, booking, pick release, ship confirm, Customer invoice and intercompany invoice issues.

Environment: Oracle Application 11i/R12 PO, AP, AR, INV, OM, Shipping Oracle10g/11g, Oracle Forms and Reports, XML Publisher, Work Flow Builder.

Confidential

Sr. Oracle Apps Consultant

Responsibilities:

• Involved in upgrading process from 11i to R12.
• Identifying the list of all custom objects those needs to be migrated from 11i to R12.
• Re-developed some custom packages after upgrading to R12.
• Converted oracle seeded reports in Reports10g to XML reports
• Used FND LOAD extensively for downloading LDTs for form personalization migration to TEST, UAT and production environments.
• Re migrated all custom objects procedures, forms and reports into R12.
• Customized PO workflows after upgrading to R12.
• Involved in post upgradation support by raising various SRs with Oracle and attended OWC sessions explain them the issue and provided 24/7 support to obtain business critical issue resolution.
• Directly communicated with oracle support for bug fixing.
• Identified gap between 11i to R12 for new features MOAC and SLA and incorporated these in R12 Objects.
• Involved in End-End testingafter upgrading to R12.
• Supported for the production issues, resolving them on a timely basis based on ticketing system prioritization.

Environment: Oracle Application 11i/R12 GL, PO, AP, AR, INV , Oracle10g, iProcurement, iSupplier, Discoverer, XML Publisher, Work flow Builder.

Confidential

Oracle Applications Developer

Responsibilities:

• Involved in various business meeting for gathering requirements for new developments and enhancements. Authored MD70 and MD120 based on the requirements.
• Analyzed data flow in the business process.
• Worked on the Procure to Pay Process flow.
• Experience in importing requisitions from legacy system to Oracle Purchasing through Requisition Open Interface.
• Worked on the Data clean up in Procurement and Developed the Custom Report Health Check Utility to check the data validity i.e. BPAs, ASL, Sourcing Rules, Purchase Orders, Invoices, and Uninvoiced receipts for the items.
• Customized purchase order accounting generator workflow to derive accrual account segment3 value from vendor setup.
• Worked on BI Publisher XML Publisher for various Purchasing reports. Generated new reports as well as converted existing oracle reports to XML.
• Involved in customization iProcurement, iSupplier and Sourcing module pages as per client requirements added additional functionality by customizing Pages using OAF.
• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice
• Worked on item import and on-hand quantity interface.
• Involved in technical design of outbound interfaces.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PLSQL packages.
• Proficient with the System administrator responsibility, which included customizing the menus, adding new concurrent requests, registering the custom applications etc.
• Moved various foundation objects from one instance to other using FNDLOAD. Including Forms, Form Personalizations, Responsibilities, Menus, Concurrent programs, lookups, value sets and XML publisher templates.
• Performed code performance tuning rule based and cost based and optimization using Execute Plan, TK proof and Trace files generating indexes and providing hints.
• Created Service requests with oracle support and worked towards solving critical issues.

Environment: Oracle Application 11i/R12 GL, PO, AP, AR, INV Oracle9i, Discoverer, XML Publisher, Work flow Builder.

Confidential

EBS Developer

Responsibilities:

• Prepared the conversion strategy and managed Conversions. Involved in identifying the data sources, mapping the data, design and develop the feeder system using SQL Loader and PL/SQL and implementing the conversion.
• Worked extensively on PO, AP and Item conversions. Created SQL Loader scripts to load the data from flat file to staging tables.
• Performed Data Validation on Invoice, Payment, Suppliers, Employee Suppliers and Expense Reports data during Conversions.
• Developed Validation Programs for Purchase orders and Payables conversions.
• Developed Backlog Summary report for Sales Orders.
• Developed Price Book Extract Report for various price lists using Discoverer.
• Developed the Technical document for Several Reports and guided the offshore team till the UAT.
• Worked extensively in testing conversion programs and critical Bug fixes. Involved in Unit Testing and Performance Testing of all conversion programs.
• Worked on various forms and reports customizations.
• Developed custom PL/SQL conversion program for loading Journals using Oracle Standard GL Interface program.
• Developed AR custom credit process where business use a custom form to feed information and integrated with AR interface Process.
• Involved in PO Approval workflow for sending approval notifications to Buyer and approver along with the preparer, using workflow builder.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Involved in developing Oracle BPEL workflows for Property Tax, AP Invoice, Check Request and Purchasing.
• Used UNIX shell scripting for automating various tasks.

Environment: Oracle Application 11i/R12 GL, PO, AP, AR, INV Oracle9i, Discoverer, XML Publisher, Work flow Builder.

Confidential

Oracle Applications Developer

Responsibilities:

• Requirement gathering and participation in discussions with Management related to incorporating required Business Process implementation.
• Prepare Technical documents MD70 MD120 based on AIM methodology.
• Responsible for the registration of the developed reports in Application Object Library AOL .
• Developed programs to extract vendor related data in Oracle Applications PO module including details like vendor site, contacts, term's etc. The data was extracted in the form of an Excel spreadsheet.
• Created various data files, which included details such as all Open Purchase Orders, and all PO's less than a particular amount.
• Extensively involved in the design and development of PL/SQL packages for loading Blanket Purchase Orders having thousands of items using Standard APIs like Purchasing Documents Open Interface, Requisitions Interface.
• Designed and developed complete Invoice Import interfaces for import of Invoice information into the system. Used SQL Loader for import into interface table and PL/SQL block for complete validation of data and inserting into base tables.
• Created Custom reports and Customization of StandardReports in OM, which includes extensive PL/SQL code Procedures and Functions .
• Prepared ER Diagrams, Data flow diagrams based on the requirement.
• Written SQL scripts to create database objects like tables, views and sequences.
• Used SQL Loader to load bulk data from various flat files.
• Extensively worked on Format Triggers, Formula Columns, Summary Columns, Placeholder Columns and Ref Cursor Query for developing the reports and prepared complex Data Model and Data Layout in Oracle Reports 6i.
• Developed Interface to load Sales Orders from the Legacy System to Oracle. Used Oracle API for loading the Sales Orders and creating RMAs and used EDI interface also.
• Developed database triggers on insert or update on MTL ITEM CATEGORIES table.
• Developed a Custom Package to update and add pricing attributes to Items.

Environment: Oracle Apps 11i GL, PO, INV, OM, AP, AR , SQL, PL/SQL, UNIX, Oracle 9i, Forms and Reports 6i, Developer 2000.

Confidential

Oracle Applications Developer

Responsibilities:

• Overseeing project implementation and process changes.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Development of Executables, Concurrent Programs, Parameters, Value Sets, Request Sets.
• PL/SQL method of submitting Concurrent programs.
• Registering Reports in Oracle 11i Application.
• Worked intensively with Oracle Developer 2000 Forms and Reports 6i with different complication levels and layouts.
• Developed Control files, SQL Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Fine tuning the SQL Queries to improve the speed of program execution.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully.
• Ensured the programs, scripts, procedures fully tested to ensure bug free performance.
• Performed SQL Performance tuning using Explain plan, Trace utility TKProf.

Environment: Oracle E-Business Suite 11i AP, AR, GL , SQL, PL/SQL, Oracle 9i, Oracle Forms 6i Reports 6i, TOAD, Developer 2000