Summary:

• Over 8 years experience in Oracle E-Business Suite Applications with expertise in Order Management , Purchasing , Inventory , General ledger, Account Payables, Account Receivables, Human Resources, Payroll, Time and labor, Advanced Benefits, Distribution modules and System Administrator.
• Experience in the Implementation and Customization of Oracle Financials, Oracle Manufacturing modules and Supply Chain Modules.
• Extensively worked on RICE Reports, Interfaces, Conversions and Extensions Components.
• Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite using PL/SQL, Oracle Reports 10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2, Oracle Forms 10g/9i/6i and Developer 2000.
• Good working knowledge in Technical Documentation using AIM Methodologies MD50, MD70, CV40 AND CV70 .
• Proficient in the E-Business Suite cycles of Order to Cash O2C , Procure to Pay P2P , Supply Chain Management SCM .
• Extensive hands on experience with developing new web pages using Oracle Applications Framework OAF .
• Experience in customizing and extending web pages using Oracle Applications Framework OAF .
• Experienced in Complete Software Development Life Cycle SDLC which includes System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Extensive experience in development of Conversions, Open Interfaces and Customization of Forms and Reports.
• Experienced in Customizing Standard Oracle Forms with CUSTOM.pll
• Experienced in Creating and registering Concurrent programs, Executables, SQL loader scripts, Functions, Procedures, Reports using system administration responsibility.
• Expertise in writing, testing and implementation of Procedures, Triggers, Functions, Packages and design of star schema at database level using SQL, PL/SQL.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF. Used Bulk collection for query optimization.
• Hands on Experience in BI and Reporting Tools like OBIEE, Discoverer, Reports and Xml Publisher.
• Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers iBots
• Experienced in Tuning SQL Statements and PL/SQL Procedures for enhancing the load performance of application in various schemas across databases
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL Loader, SQL Plus, Data Loader, TOAD and UTL FILE.
• Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer EUL .
• Worked in various projects involving migration, conversions and customization of Oracle Applications and also integration of Financials and Supply chain modules.
• Good problem solving and trouble shooting skills, highly motivated and ability to work as an individual or as a dynamic member in a team.

Technical Skills:

Professional Experience:

Confidential

Role: Oracle Apps Techno Functional

Responsibilities:

• Designed, documented Functional Specification MD050 and Technical Specification MD070 documents.
• Created FPGEC Enter and Update a new application, Enter post- exam, exam cancellation Pages using Oracle Applications Framework OAF .
• Generate and print FPGEC Certificates pages in FPGEC using Oracle Applications Framework OAF .
• Developed OAF pages that employs DML operations insert, update, delete , SPEL Simplest Possible Extension Language , PPR Partial Page Rendering and Independent and Dependent LOV's.
• Developed OAF Pages that calls PLSQL packages using OracleCallableStatement.
• Customized Colour of the items using CSS class in Oracle Applications Framework OAF .
• Extended and personalized the OAF pages to Created Backorder requisitions using OAF and Workflow.
• Extended and personalized existing AP HOLD Notification Viewmoredetails Page Using Oracle Applications Framework OAF .
• Created new page to display the Address details of the delivery to location of the Requisitions Using Oracle Applications Framework OAF .
• Extended View Object VO and Controller Object CO of the Select Source Page Using Oracle Applications Framework OAF .
• Created New Contract Request page and Contract Request search form which contains all basic searches and Advance searches, Notes and Attachments Using Oracle Applications Framework OAF .
• Developed OAF Pages that employs the concept of SPEL for implementing the PPR Partial Page Rendering using JDeveloper.
• Migrated OAF Page Personalization's and Customizations from development to production instance.
• Developed custom invoice workflow process using oracle workflow builder. This includes the notification and custom work list approval processes.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Provided Support for the API AR INVOICE API PUB to a create single or a batch of multiple Receivables in AR.
• Developed an Alert to notify managers to extend the termination of Contractors in HRMS.
• Integrated employee data from acquired companies into HRMS production tables using API's.
• Developed Oracle Workflow with I-Expenses to automatically route expense reports for approval, and enforce reimbursement policies.
• Developed custom workflow for sending oracle workflow notifications.
• Developed PL/SQL Concurrent programs to transfer customer data to AR interface tables and then run the Customer Interface create new Customers or import additional information for the existing Customers.
• Developed and fixed the issues of INV Shipping Manifest Report using Report 10g and XML/BI Publisher.
• Developed and fixed the issues of INV Pipe Manifest Report using Report 10g and XML/BI Publisher.
• Responsible for developing various views and PL/SQL scripts for Discoverer Reports.
• created ID Card, Address Label and Certificate reports using XML/BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes by using XML/BI Publisher.
• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report by using XML/BI Publisher.
• Responsible for solving production problems and providing permanent solutions.

Environment: Oracle Applications R12 Order Management, Inventory, Purchasing, Accounts Payables, Account Receivables, Human Resources, Payroll, Time and labor, Advanced Benefits, Fixed Assets , Oracle 10g, OAF Oracle JDeveloper , XML Publisher, Reports 10g, Forms 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL Plus, SQL Loader, PL/SQL, UNIX.

Confidential

Role: Oracle Apps Developer

Responsibilities:

• Involved in design of AIM Application Implementation Methodology documents MD-50, MD-70 for all conversion and interfaces.
• Provide programming, Technical and Functional assistance to team members for issues/queries related to object developed for the client
• Support Oracle Deployment and provide assistance with critical functions performed by the Production Control Teams
• Read and review design document of requirements for project needs for business progression.
• Involved in setup and customization of Oracle Payables and did data conversion from legacy system into Payables..
• Provided Support for the API AR INVOICE API PUB to a create single or a batch of multiple Receivables in AR.
• Gathered Client Specification and Requirements from functional people and developing different Core HRMS, Payroll Benefit Reports
• Created a New OAF page to add Payroll Bank accounts to the employees in HRMS.
• Extended HRSSA Workflow to add AME Approvals for the Hire and Re-Hire Process in HRMS.
• Added the Attribute values in Workflow for the Custom Re-Hire Process in HRSSA.
• Created a Fast formula to transfer hours from Weekend Balance to Weekday Balance.
• Created SunTrust Invoice List Page which contains the list of Category Names, Count of Invoices and SunTrust Invoice Details Page which contains list of invoices, view, comments and edit buttons Using Oracle Applications Framework OAF .
• Created SunTrust Invoice entry Page which contains Invoice Header, Distributions and Comments sections buttons Using Oracle Applications Framework OAF .
• Created SunTrust Invoice Search and Advanced Search Pages which contains all basic searches and Advance searches, Notes and Attachments in Oracle Applications Framework OAF .
• Extended View Object VO and Controller Object CO of Suppliers Inquiry page in Payables Using Oracle Applications Framework OAF .
• Personalized Supplier Quick Update page in Payables using Oracle Applications Framework OAF .
• Customized AP Invoice on Hold Report, AP Payment Register Report using Oracle Reports.
• Built custom reports using Oracle Reports to fulfil the business requirements of the client.
• Developed and customized reports like Min-Max Planning report and cancelled purchase orders using Oracle Reports.
• Customized the standard AP Check Print Report in Account Payables using XML/BI publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes by using XML/BI Publisher.
• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report by using XML/BI Publisher.
• Developed custom invoice workflow process using oracle workflow builder. This includes the notification and custom work list approval processes.
• Developed Oracle Workflow with I-Expenses to automatically route expense reports for approval, and enforce reimbursement policies.
• Developed custom workflow for sending oracle workflow notifications.
• Developed PL/SQL Concurrent programs to transfer customer data to AR interface tables and then run the Customer Interface create new Customers or import additional information for the existing Customers.
• Responsible for developing various views and PL/SQL scripts for Discoverer Reports.
• Responsible for solving production problems and providing permanent solutions.

Environment: Oracle Applications R12 Accounts Payables, Account Receivables, Fixed Assets, Human Resources, Payroll, Time and labor, Advanced Benefits , Oracle 10g, OAF Oracle JDeveloper , XML Publisher, Reports 10g, Forms 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL Plus, SQL Loader, PL/SQL, UNIX.

Confidential

Role: Oracle Apps Consultant

Responsibilities:

• Analyzed legacy system and prepared Functional MD050 , Technical MD070 , Conversion Mapping CV040 documents.
• Extended iProcurement Shopping Cart Page to added available quantity and Backorder flag fields using Oracle Applications Framework OAF .
• Personalized in Hiding/Displaying/Disabling/Re-ordering Attributes on iSupplier pages using Oracle Applications Framework OAF .
• Extended View Object VO and Controller Object CO of the Select Source Page Using Oracle Applications Framework OAF in iProcurement.
• Created a New OAF page to extend or terminate a CWK in HRMS.
• Developed custom inbound interfaces. Bank files generation HRMS
• Worked on Employee Interface in HRMS.
• Involved in Loading Employee and Employee Assignments in Human Resource using API's called HR EMPLOYEE API, UPDTAE EMP ASG CRITERIA and UPDATE EMP ASG API.
• Design and development of AP suppliers, AP invoices conversion programs using AP suppliers open interface and AP invoices open interface.
• Developed code for GL Conversions to extract legacy journals and to load them to GL INTERFACE table.
• Worked on Customer Interfaces to import Customers from Legacy System into AR.
• Up gradation and conversion of GL, AP, AR modules.
• Personalized iProcurement Review and Submit Page using Oracle Applications Framework OAF .
• Extended and personalized existing AP HOLD Notification Viewmoredetails Page Using Oracle Applications Framework OAF .
• Extended iExpense Approver LOV View Object Using Oracle Applications Framework OAF .
• Created New Contract Request page and Contract Request search form which contains all basic searches and Advance searches, Notes and Attachments in iProc Using Oracle Applications Framework OAF .
• Extended P-Card holders and approvers Workflow to Remove 'More Information' and 'Reassign' buttons.
• Customized the AP Invoice Hold Notification Workflow, The objective of this customized workflow is to send notification to appropriate stakeholder s after a specific hold is placed on AP invoice.
• Developed PL/SQL programs, temporary tables, views as part of OAF customization and development.
• Developed custom Workflow using Oracle workflow Builder to notify Approvers about the payment requests submitted.
• Developed and fixed the issues of INV Shipping Manifest Report using Report 10g and XML/BI Publisher.
• Developed and fixed the issues of INV Pipe Manifest Report using Report 10g and XML/BI Publisher.
• Customized Inactive Item Report and Cancelled Sales Order Report using Oracle Reports.
• Customized the report called Backorder Detail Report which is used to review all customer orders that have been backordered using Reports 10g.
• Developed Inbound and Outbound Interfaces in PO, AP, INV, AR modules to interface legacy systems and oracle EBS.
• Worked extensively with Application Object Library AOL by registering OAF forms, reports, creating value sets, lookups, key flex fields, descriptive flex fields.
• Facilitate Integration testing and User Acceptance testing for each module of redesign.
• Preparing Technical Designs, Test Plan and Installation Guide documents.
• Provide programming, Technical and Functional assistance to team members for issues/queries related to object developed for the client.

Environment: Oracle Applications R12 General Ledger, Accounts Payables, Account Receivables, Human Resources, Payroll, Time and labor, Advanced Benefits , Oracle 10g, OAF Oracle JDeveloper , XML Publisher, Reports 10g, Forms 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL Plus, SQL Loader, PL/SQL, UNIX.

Confidential

Role: Oracle Apps Consultant

Responsibilities:

• Designed, documented Functional Specification MD050 and Technical Specification MD070 documents.
• Involved in customer conversion from legacy system into Oracle Accounts Receivable AR by using Customer Interface.
• Defined Auto-Lockbox and Transmission Format and ran standard Lockbox program to transfer receipts into Oracle Receivables.
• Developed pl/sql package and utl file to load merit review data to temp tables and used API's to import into Oracle HRMS application.
• Mapped fields from Oracle HR application tables to ADP payroll data fields.
• Modified ADP connection views to add fields required by ADP application in HR.
• Created ADP translation table to manipulate data as per the requirement and setup in HR.
• Developed PL/SQL Packages, Procedures, Functions for validating the Invoices and Payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program AP and populated the base tables.
• Developed OA Framework Page to view rejected and cancelled Invoices from Account Payables.
• Unit Testing of all OA Framework Pages
• Extended and personalized the functionalities of existing pages using OA Framework.
• Extended View Object VO and Controller Object CO of the iSupplier pages Using Oracle Applications Framework OAF .
• Extended View Objects for displaying more columns in iSupplier using Oracle Applications Framework OAF .
• Involved in developing new reports and customizing standard Oracle reports using Discoverer 10g, Reports 10g and XML/BI Publisher.
• Created Materialized views in an external system on Purchase order data, Requisition data and Vendor data in Oracle Payables.
• Utilized FND REQUEST API to submit concurrent Program from Oracle Report after Report Trigger.
• Involved in Creating and registering Concurrent programs, Executables, SQL loader scripts, Functions, Procedures, Reports using system administration responsibility.
• Conversion of Oracle Reports to XML/BI Publisher Reports like AP Check Printing Report and AR Invoice Report.
• Customized the standard AR Aging Report and Invoice History Report by using XML/BI Publisher.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Designed and developed Forms using Forms 10g as per the business requirements, provided Zoom functionality using CUSTOM.pll.
• Customized the Order Header level Workflow, which will send a notification based on the data mismatch between order header level and order line level.
• Customized the Work Flow for Credit Memo Request approval in AR through Workflow Builder.
• Customized the Journal Line Report in Oracle General Ledger and Invoice Aging Report in Oracle Payables.
• Modified the Print Statements report and Invoice report as per the formats/layout of the client using Reports 10g.
• Designed and developed ad-hoc Oracle Discoverer workbooks and reports and also trained the End Users.
• Tuning of PL/SQL queries for better database performance, worked on tools like TKPROF and Explain Plan.
• Involved in registration of concurrent programs, executables, creation of Responsibilities, request groups, menus, value sets, request Sets, Forms, functions in System Administration AOL.
• Interacted with the end users to gather desired requirements, analyzed the requirements, and finally, developed and implemented various PL/SQL and Oracle Application routines to fulfill those requirements.

Environment: Oracle Applications R12 General Ledger, Accounts Payables, Account Receivables, Human Resources, Payroll , Oracle 10g, OAF Oracle JDeveloper , XML Publisher, Discoverer 10g, Reports 10g, Forms 10g, Workflow Builder 2.6.3.5, Windows 2000/NT, SQL Plus, SQL Loader, TOAD, PL/SQL, UNIX.

Confidential

Role: Oracle Apps Consultant

Responsibilities:

• Developed SQL loader script and PL/SQL script to load and validate Customers data into Oracle Receivables
• Involved in development of inbound interface custom package to validate and import Order details data into Oracle Applications OM Order interface tables from external system.
• Imported Items from legacy system into Oracle Inventory INV base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Responsible for converting the entire Historical Purchase Orders PO using Import standard Purchase Orders into Production.
• Developed an Outbound interface program to transfer the data from oracle PO base tables into the flat file.
• Routed the PO Requisitions for approval using Approval Management Engine AME .
• Developed PL/SQL programs using Toad, temporary tables, views as part of OAF customization and development.
• Registered new forms and also different concurrent programs for reports, PL/SQL packages, SQL loader Programs
• Customized Standard Oracle Applications forms in Order Entry by implementing logic in CUSTOM.pll
• Registered newly created forms with Oracle
• Involved in customizing the forms for adding extra information through DFF's.
• Developed custom workflow for sending oracle workflow notifications.
• Generated Order submission summary and Detail reports and Order submission summary by email Report using XML/BI Publisher.
• Revised Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with onsite functional team to build technical extensions
• Developed Order Management, Inventory, Receivables, Shipping, and Warehouse Management, Pricing queries to compare summary information of the standard and custom reports using Reports 6i.
• Created ad hoc workbooks using Discoverer plus, Discoverer desktop and shared the workbooks with the designated users only.
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.

Environment: Oracle Applications R12/11i 11.5.10 Order Management, Inventory, Purchasing, General Ledger, Accounts Payables, Account Receivables , OAF Oracle JDeveloper , Oracle 10g, OBIEE 10.1.3.4.0, XML Publisher, Discoverer 10g, Reports 6i, forms 6i, Workflow Builder 2.6.1, Windows 2000/NT, SQL Plus, SQL Loader, TOAD, PL/SQL, UNIX.

Confidential

Role: Oracle Apps Consultant

Responsibilities:

• Designed Customer Products Summary Report in Install base using XML/BI publisher.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Developed PL/SQL Packages, Procedures, Functions for validating the journals for accrual and payment information in the staging table and importing them into Oracle Application using the GL Open Interface and populated the base tables, which involved in creation of multiple journal entries for each type accrual and payment and journal import.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG's.
• Designed and developed a custom package to import open sales orders from legacy system into Order Management using Order Import. Created parties, party sites, location, customer Account, customer acct sites, sites uses, contacts, contact points using TCA APIs.
• Involved in importing invoices in to Oracle Financials AR base tables from legacy systems by defining staging tables, performing the required validations by writing SQL, PL-SQL programs Using Auto Invoice Interface.
• Fixed Assets, FA Set Up, Books Corporate Tax , Category, Location Descriptive Flexified definitions, Chart Set Up for Fixed Assets Categories, Transactions of Mass Additions, Mass Deletions Mass Transfers, Fixed Assets Inventory Interface using ADI Tools, and Tax Books Interface using SQL Loader.
• FA Reconciliation Process Set Up, FA with GL FA with AP, Depreciation Calculations Period Close.

• Registered functions using Discoverer Administrator.
• Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.
• Developed Open interface to import orders from legacy system to apps.

Environment: Oracle Applications 11i 11.5.10 , Order Management, Inventory, Purchasing, General Ledger, Accounts Payables, Account Receivables, XML/BI Publisher, Oracle 9i, Discoverer 10g, Financials Analytics , Windows 2000/NT, SQL Plus, TOAD, Oracle Reports 6i, UNIX

Confidential

Role: Oracle Developer

Responsibilities:

• Gathered the requirement from the client and translated the business design into Technical design.
• Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.
• Triggers, procedures and functions are developed in this reports using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables. Created user defined Exceptions while handling exceptions.
• Troubleshooting production problems and worked effectively with other team members to identify and address problem.

Environment: Oracle 8i, Reports 4i, Discoverer 4i, SQL PLUS, SQL Loader.