SUMMARY

• Over 8 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.
• Has very good experience in customizing existing OAF Screens, Forms and Reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• 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.
• Good Knowledge in Oracle SOA Suite.
• Very Good Knowledge in developing OBIEE / Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer), Answers, Interactive Dashboards with drill-down capabilities, BI Publisher, Delivers, Security Setup (groups, access/query/report privileges), configuring Analytics, Metadata Objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling IBots.
• Experience in creating dimensional hierarchies, time hierarchies, level-based measures and adding multiple sources to business model objects.
• Well experienced in performance tuning using Explain Plan, Indexing, Hints, Partitioning, Database Trace, TKPROF utilities.
• 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.
• Interact with people at all levels and also have Onshore/Offshore Co-ordination. Possess excellent communication and problem solving skills, and work ethics.
• Proven characteristics of being highly motivated. Strong problem-solving skills and analytical skills. Self-Starter and ability to work independently without any supervision.

TECHNICAL SKILLS

ERP Applications: Oracle Applications R12/11i including Payables (AP), Receivables (AR), General Ledger (GL),Cash Management (CM), Order Management (OM), Purchasing (PO),Inventory (INV),Shipping(WSH),Sub Ledger Accounting, iExpenses, iProcurement, Service Contracts, Install Base, Advance Pricing and others.

Languages: SQL, PL/SQL, UNIX, HTML, XML, C and Java Scripts.

Database: Oracle 9i/10g/11g.

Tools: TOAD,SQL*Developer, SQL*Loader, FND LOAD,SQL*PLUS, Forms & Reports 10g/6i, Oracle Discoverer 4i/10g, XML Publisher, Workflow Builder, JDeveloper, OBIEE 11g, ADI & EDI Gateway.

Operating System: Windows, UNIX, SUN SOLARIS, LINUX.

Documentation: AIM, MD070, MD050, MD0120, CV060, BR100, and Reconciliation Tool kit Document.

PROFESSIONAL EXPERIENCE

Confidential, Jamesburg, NJ

Sr. Oracle Applications Consultant

Responsibilities:

• Designed and developed Functional and Technical specifications as well as test plans and test scenarios using AIM methodology.
• Designed and developed custom Item creation process.
• Developed an integrated solution to connect each of the individuals from each department such as Marketing, Service, Supply, Accounting and Salesor the Approval of the Item creation in Oracle System.
• Worked on Item Conversions and developed one time script to validate and update theitem definition attributes and item categories for the existing items.
• Worked on building a new custom API to check the on-hand availability for a given sub-inventory and warehouse
• Designed and developed the custom Data Integrity (DI) check program which helps in the accuracy of the sales order entry process. The book order button on sales order form will not be enabled until all issue has been resolved.
• Worked with OM Team to develop an inbound interface for order import from third party system.
• Worked on customer related setups and did modifications to the existing customers.
• Developed Customer License Registration form which is used to register the software once the order is delivered.
• Designed and developed Custom PO Automation for the drop ship sales orders.
• Customized Pick slip and Packing slip reports to include the additional Business requirements.
• Personalized PO entry form to disable Changing PO price for few responsibilities.
• Modified the Create PO Document and PO Approval workflows as per the user requirements.
• Designed and Developed AutoCreate Purchase order and PO Receipt interface for Back to Back Sales Orders.
• Developed Supplier Payments Report using BI Publisher.
• Involved in OBIEE Project and Customized the physical, business, and presentation layer of the repository using OBIEE Administration Tool.
• 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 (OM, INV, WSH, PO, AR), Oracle10g, Oracle Forms and Reports, OBIEE, XML Publisher, Work Flow Builder.

Confidential, Costa Mesa, CA

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 custom Check Templates in BI Publisher.
• Developed the custom programs to load the data into custom tables, printing and reprinting the checks.
• Good Knowledge of payment processing in R12.
• Developed interfaces to convert 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.
• Responsible for setting up the interfaces between legacy AR systems into AR invoicing system.
• Involved in AR Setups are such as Transaction Types (Invoice Types), Auto Accounting Setups, and Configured Invoice Types with Order types, AR Batch sources, remit to addresses, Receipt Classes and Payment Methods.
• Exposure to Accounting Business Practices used in Oracle GL.
• Cash management implementation covering the Bank setups, the Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.
• Customized GL Journal entry form using form personalization embedding trigger events with custom APIs as per the client requirement.
• Developed AP invoice interface for EDI 810 integration.
• Worked on resolving the Trial balance Reconciliation issues in AP module during Month end. Applied various Global Data fixes and analyzed their technical impact before migrating to production.
• Extensively worked on Oracle Sub Ledger accounting to analyze and gather information from Payables into GL and reverting back from GL Journal Entries to grab Payables Invoice and Payment Details through XLA.
• Developed New Forms and customizations in standard forms based on user requirements using Oracle Form Builder and OA Frame work in Account Payables.
• Developed Sales order report, Purchase order history and Invoice on Hold report in BI Publisher.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages developed.
• Involved in post-production support and enhancements of RICE objects in all three phases of project.

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

Confidential, Sunnyvale, CA

Sr. Oracle Applications Consultant

Responsibilities:

• Involved in requirement gatherings from users, design and development of custom objects.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the data into Oracle Standard interface tables.
• Developed control files for SQL*Loader in PL/SQL programs for loading and validating data into interface tables from Legacy systems.
• Developed Item interface import Program to integrate with external 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.
• Analyzed the various reports that require customization in OM and Inventory. Customized Sales Order Acknowledgement report to meet the business requirements for Retail orders.
• Forms Personalization for Related Item Price and Quantity in Order Management.
• Involved in Oracle Order Import API to validate and load the PO information to the interface tables.
• Worked on Order defaulting rules to default the Order Header and Order Line level fields like Freight Terms, Warehouse.
• Developed Pick confirm and Ship confirm Interface using oracle API’s.
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Responsible for analysis/development of functionality integrating Oracle Order Management and Service Contracts using Fusion middleware (SOA Suite 11g).
• 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.
• Developed the custom program to feed Customer data from the external source to the standard tables.
• Updated the Customer Details Using TCA API’s.
• Involved in Auto Lock 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.
• Created invoices in AR using Auto Invoice Import program.
• EDI (e-commerce Gateway) experienced with documents like 850(PO Outbound), 810 (Invoicing), 856(Orders) and 852(Sales).
• Involved in customization iProcurement, iSupplier and Sourcing module pages as per client requirements added additional functionality by customizing Pages using OAF.
• Created various SRs in different levels working in close proximity with Oracle support group for resolving various bugs.

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

Confidential, Malta, NY

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 testing after 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, NYC, NY

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.
• 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, Midland, MI

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 the development of TCA Customer Conversion program which includes data validation and API calls.
• 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.
• Implemented Order Returns with and without credits, which involved setting up transaction type, loading order using SQL Loader, creating receipts to close the order.
• Developed Custom Discoverer reports like Monthly customer sales report, Monthly region sales report.
• Developed a report, which showed requisition details, purchase order details, receiving details, invoicing details and payment details in Oracle Procure to Pay Cycle.
• Developed various custom reports and customized standard Oracle reports like Account Status Report and Bank Account Listing as per the business requirements.
• Customized AR account status Report, and AP Trial Balance report using Report 6i tool.
• Created flex fields as required in the forms of various modules like AP, AR and GL.
• 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 Standard Reports 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.
• Responsible for extensive data validations, feeding of live data and user acceptance for each module.
• Overseeing project implementation and process changes
• Worked on GL interface to import journals from legacy systems into GL interface tables.
• Designed and developed Invoice rejection report, Active supplier list report and purchase order reports.
• Worked on Oracle reports to serve the business needs.
• 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:

• Involved in the development of new User interfaces and made modifications to existing applications to resolve issues and add new functionality.
• Developed database tables/views for designing the database using primary keys and foreign keys.
• Extensively worked on PL/SQL and wrote necessary scripts.
• Used PL/SQL in reports to perform calculation and to get desired output.
• Written stored procedures, Functions and Package to implement business rules using SQL and PL/SQL.
• Designed and developed various types of forms, menus and reports.
• Developed Forms and Reports to assess the data and display results for users in an easily understood and Usable format.
• Developed Reporting and Trending like mean time trouble report by site and by Location and other regulatory reports of Customer Case Management.
• Designed and customized various Oracle reports in OM, AR, and GL.
• Customized the standard reports in AR module like Aging by Account, Dunning History and Billing History.
• Worked on XML Publisher for generating reports.
• Worked extensively in various RICEW components.
• Performed customization on existing Forms appearance, validation logic, and behavior and incorporating new functionalities for control purpose.
• Dealt with registering / defining of custom applications, tables, reports, concurrent requests, standard report submission etc. and also with profile options, defining of application users and responsibilities.
• Developed packages containing different procedures and functions using PL/SQL.
• Designed and built new database views and tables.
• Developed and customized PL/SQL programs, functions, procedures and triggers.
• Worked on performance tuning of complex queries, functions, procedures and packages.
• Worked on interfaces and SQL packages to import data from external system like IBS (Internal Billing System), VFS (Vendor Financial Systems into Oracle AP standard tables.
• Coding for the Interface programs to extract data into flat file and uploading of data files to the media application
• To provide necessary technical support for fixing the bugs involved in interacting with end user.
• Involved in Testing, Integration System test, Implementation and documented the entire project.

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