OBJECTIVE

• To work in a stimulating environment that would provide me ample opportunities to utilize my analytical, technical skills and improve my knowledge so that I can give the best to the organization I work for.
• PROFESSIONAL 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 KNOWLEDGE

• Oracle 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.
• Development Tools: XML Reports Forms 6i/10g
• DB Tools: SQL PLUS, SQL Loader, TOAD, SQL Navigator, SQL Developer.
• Languages: SQL, PL/SQL, C, JAVA
• Reporting 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

Confidenital

Oracle Apps Technical Consultant

Confidenital is a Fortune 500 financial security company providing confidence and financial independence. The Genworth Financial family of companies operates through three segments: Retirement Protection, Confidenital, and International. Genworth is headquartered in Richmond, Virginia and conduct business in all 50 states of The United states of America.

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 in Form Personalization's in Financial and manufacturing Modules.
• 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 and did all the necessary validations before loading into interface tables and Calling Payable Import Program.
• 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.
• 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 the Software 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 on TAR'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.

Confidenital

Oracle Apps Technical Consultant

Confidenital is one of the world's leading casual dining restaurant companies. With more than 1,500 restaurants and over 100,000 team members in 32 countries and two territories, Brinker and its brands welcome more than one million guests into our restaurants every day. The project involved end to end implementation for Oracle R12 Financials, Supply chain, WMS and Manufacturing modules

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
• 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 developed custom forms and 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.

Confidenital

Oracle Apps Technical Consultant

Confidenital is a multinational company based in Wayne, Pennsylvania, which provides software and services to education, financial services, and public sector organizations. It was formed in 1983, as a spin-off of the computer services division of Sun Oil Company, during a period of low crude oil prices. The company has more than 25,000 customers in more than 70 countries.

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.
• 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 customized all 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.
• Responsible for migration script of code to different instances.
• Developed reports for Quotation, Invoice, contracts and checks using BI/XML Publisher.
• Involved with Testing Team in testing and fixing all the issues that 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.

Confidenital

Oracle Apps Consultant

Working as Oracle Apps Consultant for the client who is a leading, world-class supplier of custom-imprinted products for the promotional products industry, implementing Oracle Applications 12.1.3 for various businesses and integrated with various legacy systems on Oracle On-Demand environment

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

Confidenital

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.