OBJECTIVE

• To work in a stimulating environment dat would provide me ample opportunities to utilize my analytical, technical skills and improve my knowledge so dat I can give the best to the organization I work for.

SUMMARY

• Having 7+ years of experience in Oracle Applications (E - Business Suite) R12/11i on Analysis, Design and Development, Testing, Implementation, maintenance and support of Oracle EBS.
• Excellent experience in Application Modules of Oracle which include General ledger (GL), Accounts payable (AP), Accounts Receivables (AR), Purchasing (PO), Inventory (INV), Order Management (OM) and Cash Management (CM).
• Good Knowledge on Development skills in developing RICE (Reports, Interfaces, Conversions and Extensions) Components in the domain of Oracle Applications E-Business Suite.
• Good Technical experience in Procure to Pay (P2P) and Order to Cash (O2C) life cycles with related Open Interfaces and API’s.
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Excellent Knowledge of R12 MOAC architecture, 11i Multi org structure and AOL Objects.
• Expert at creating and maintenance of users, responsibilities, menu, requests, value sets and registering applications, forms, form functions, reports and concurrent programs, etc.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers, views, collections (nested tables and arrays), records, sequences, views, Constraints and other database objects using SQL and PL/SQL.
• Experience in OA Framework and customization and Personalization of JSP pages.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Good in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Good Knowledge on Conversion, inbound and outbound interfaces Programs using PL/SQL, Interface tables and Oracle Standard API's.
• Good knowledge in Oracle cursor management and Exception handling.
• Proficiency in creating business and technical project documentation.
• Ability to work hard as an individual and in a team to achieve desired results and ability to work under pressure in coordinating multiple tasks in the work environment as a good team player.
• Excellent in quick adaptation and problem solving with client interaction/customer handling, conflict management, escalation handling and analytical skills.

TECHNICAL SKILLS

Applications: Oracle E-Business Suite R12, 11i

Modules: GL (General Ledger), AP (Account Payables), AR (Account Receivables), PO (Purchasing), OM (Order Management), INV (Inventory), P2P, O2C, Cash Management (CM) and AOL (Application Object Library).

RDBMS: Oracle 8i/9i/10g, SQL Server 7/2000.

Tools: XML Reports & Forms 6i/10g

DB Tools: SQL*PLUS, SQL*Loader, TOAD, SQL*Navigator, SQL Developer.

Languages: SQL, PL/SQL, C, JAVA

Tools: Reports 6i/10g, XML/BI Publisher.

Operating Systems: Windows XP/NT/VISTA/ 2000/98/95/2007, LINUX.

Office Tools: Microsoft Word, Excel, Outlook, Access

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Oracle Apps Technical Consultant

Responsibilities:

• Customized standard Oracle Applications (EBS) reports and developed custom reports on financials (AR, AP, GL), Distribution (OM, WSH) and inventory INV modules.
• Preparation of AIM (Application Implementation Methodology) Documents for Functional and Technical specifications of Customizations, Interfaces and Conversions.
• Developed New Reports and Customizations in XML Based reports using BI/XML Publisher.
• Worked on Order to Cash life cycle implementation and integrating modules.
• Developed many new reports like Customer Order status Report, Backlog Detail Report, Backlog Summary Report, Backlog by Item Report, Cycle Status Report, Open Work Order Report, Sales Rep Commission Report, Customer Profiles Report etc.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL * Loader
• Designed, developed the screens like main menu, cash date form, general ledger input form which is involved in refreshing data and process net settlement activity on any particular day for batch rejections, individual rejections using Developer.
• Worked in Creating Value sets, Descriptive flex fields, Lookups, Customer Design using TCA, setups and Statement of account Setups customizations in Dunning letters and Statement of accounts.
• Extensively worked on RICEW objects to view, transfer and modify the data in the same or different system.
• Proficient in Procure to Pay (P2P) & Order to Cash (O2C) life cycles.
• Customized Forms using Zoom Functionality.
• Developed PL/SQL programs using TCA API’s to validate and import customers from legacy system into base tables.
• Involved in migration of GL and AP custom interfaces and reports, during oracle financials upgrade project.
• Developments include building data migration scripts using Oracle SQL*Loader and UTL Packages.
• Developed an interface to upload the journal data into the Oracle Application’s General Ledger, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validation.
• Experience with theSoftware Development Life Cycle (SDLC)process - performing detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production install and support.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Skillful in utilizing key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed several PL/SQL packages, procedures, functions, triggers from GUI events or database triggers, to implement complex business logic.
• Involved in troubleshooting errors, fixing the bugs and fulfilled the new business requirements.
• Interacted with users to resolve any issues during the production, development and enhancement phases.
• Experience onTAR's(Service Requests) with Oracle on Demand Team and End users.
• Involved in Performance tuning of complex queries.

Environment: Oracle E-Business Suite R12 (GL, AP, AR, INV & OM), Oracle 10g/9i, SQL, PL/SQL, Form10g, Reports 10g, Workflow Builder.

Confidential, Dallas, TX

Oracle Apps Technical Consultant

Responsibilities:

• Created new custom Self service pages using Oracle Application Framework (OAF) in Oracle Applications R12, PL/SQL.
• Created a custom search page for Items and added custom item attributes in the search results.
• Created custom dash board for sales representative.
• Designed and customized OAF (Oracle Application Framework) pages using Jdeveloper
• Created many OAF pages for HR application called EXIT interview so the company can analysis the employee's feedback
• Developed an Interface from Legacy System to Oracle General Ledger to migrate data between them using SQL loader.
• Create a custom wrapper for Quoting process and embedded in quote details page based on the business requirements.
• Inter linked quoting with Order management - Sales order form.
• Created custom report in supply chain modules using BI Publisher.
• Involved in Design, Development and Customization of OA Framework Pages (Jdeveloper). Extensively worked on BC4J and UIX components such as Pages, Regions and items.
• Use regions like page layout region, switcher region, train region, query region, message component region, table region and many more.
• Created and extended various AMs, VOs and EOs as per the requirement.
• Created dependent LOVs.
• Customized various pages like create questionnaires page, search questionnaires page, update questionnaires page, delete questionnaires page, questionnaires detail page, confirm message page.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher and good expertise on WF, OAF using JDeveloper 9i
• Created custom forms with vendor specific information to aid Payables department secure information by department.
• Worked on form personalization (i) User cannot change AP invoice Workbench if the data moved from AP to legacy system(ii) Enabling Attribute1 in AP Payment Window (iii) Customized Invoice Form (iv)Call PO Window from PO Receipt Window.
• Designed and developedcustomformsand changed the forms based on requirement.
• Added Descriptive and Key Flex fields on various Pages.
• Created multiple pages with advanced table regions and export to excel functionality so users can export all the data in the excel file.
• Created a PL/SQL package to create and handle procedure and function which perform required actions in the backend
• Created custom tables, Value Sets and Lookups for HR Exit Interview Process application.
• Developed a PL/SQL package procedure to calculate multiple calculations based on Business requirement.
• Developed a custom report to download price list and customer quotation using BI/ XML publisher.
• Interacted with business analysts to develop modeling techniques and re-structuring strategies
• Created Testing and Migration document (TE 20 / MD 120) for the testing components worked on.

Environment: Oracle Applications R12/11i, JDeveloper 10g, Toad 10.1, Java, Java Scripts, BI/XML Publisher, WinSCP, Putty.

Confidential, Wayne, PA

Oracle Apps Technical Consultant

Responsibilities:

• Worked on conversions and customizations (Reports) of different modules extensively worked on GL, AR, AP The forms involved Procedures, Record Groups, LOV, Alerts, Parameters, Global Variables, Multiple Canvases, Multiple Windows, Multiple Blocks, Control Block and triggers at various levels
• OAF Developer responsible for developing a custom OAF Application. Created new custom Self service pages using Oracle Application Framework (OAF) in Oracle Applications 11.5.10 and PL/SQL.
• Designed and customized OAF (Oracle Application Framework) pages using JDeveloper. Created many OAF pages to complete the Offer Creation Process in quoting module.
• Responsible for Migration script of code to different instances in both legacy and Oracle EBS.
• Created Offer Home Page, Offer Lines Page, Offer Lines Detail Page, Offer Review Page and Offer Update Page for the process of creating an Offer in Oracle.
• Created Customer Pages in which the user can enter the customer details and Customer Update Page to update the details of Customer.
• Created Dependent LOVs and dependent Message Choice Pick List on multiple pages to meet the business requirements.
• Created Drop down PPRs. Created new Pages to add rows and update rows for Custom tables and customizedall icons, buttons other images such as logos, arrows, etc.
• Created Review Page where customer can review all the details of the offer. Used HTML coding to get a better view of the Review Page.
• Created and Personalized Short, Long and Page Tips. Handled various Exceptions in the pages for various functions involved in transactions.
• Created a process to import data from excel file directly into the oracle table.
• Developed reports for Quotation, Invoice, contracts and checks using BI/XML Publisher.
• Involved with Testing Team in testing and fixing all the issues dat came up while testing.
• Created Functional, Technical, Testing, Migration documents (MD 050, MD070, TE 20, MD 120) by gathering the entire business requirements, components etc worked on.

Environment: Oracle Applications 11i, Developer 10g, PLSQL Developer, Java, Java Scripts, PL/SQL, SQL* Plus, SQL *Loader, WinSCP, BI Publisher, FileZilla.

Confidential, Hodgkins, IL

Oracle Apps Consultant

Responsibilities:

• Involved in user requirement gathering, design, mappings and development of RICEFW (interfaces, conversions, forms, reports and extensions) components.
• Worked on conversions like TCA (Customer & Supplier) conversion, PO, Sales Order Import, Price List load, item load, forecast load, Item categories load and locators using Interfaces/APIs
• Actively involved in design and development of third party applications (Demand solutions, Norwood custom applications) Integration with Oracle EBS on PO, OM and Inventory modules applications.
• Customized the standard forms and developed lot of Custom forms using oracle forms 10g, Form Personalization and custom.pll
• Involved in the analysis and design of various custom reports and customized the standard reports using XML/BI Publishers and Oracle Reports.
• Participated in troubleshooting, bug fixing, and resolving critical errors emerging during UAT and SIT.
• Using Oracle AIM (Applications Implementation Methodology), I involved in the development of the functional, design and technical documents.
• Involved in preparing Test plan and Test cases and regressive testing in all the phases.
• Extensively worked on Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Involved in analyzing and designing and development various APIs for the application

Environment: Oracle Applications R12 Financial/Supply Chain /CRM (PO, AP, AR, TCA,GL,OM,, INV), Oracle 10g, Reports 10g, Forms 10g, custom pll, Form Personalization, Oracle XML/BI Publishers, Workflow, Toad, Windows XP and SQL*Plus

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in the Customization and custom development of Oracle Forms/Reports using Forms 10g, Reports 10g and PL/SQL and registered them to Oracle Applications using AOL, Data conversion in AP, AR, Projects, Purchasing Module
• Involved in Requirements Analysis, Design, Data Mapping and Client Interaction.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• DBMS developments include building data migration scripts using Oracle SQL*Loader and UTL Packages.
• Mapping, Design and Development of Invoice Interface from Legacy Entities to Oracle Payables.
• Designed and Implemented Auto Lockbox to load receipts into Oracle Receivables.
• Designed and developed PL/SQL packages to validate and import invoices into Oracle Receivables.
• Worked on Purchase Open interface and receivables interface by loading data into staging tables from the legacy system.
• Developed Discoverer reports for Accounts Payables and Accounts Receivables.
• Customization of Oracle Purchase requisition account generator workflow.

Environment: Oracle E-Business Suite11.5.10 (PO, AP, AR, TCA), Work Flow, AME, Oracle 9i, Reports 6i, Forms 6i, XML Publisher, PL/SQL, SQL*Loader, Toad, UNIX.