SUMMARY:

• Oracle Certified Professional having 13 years of experience in Oracle E - Business suite. As a Senior Oracle Applications EBS Techno functional Consultant, expertise in the area of developing RICE (Reports, Interfaces, Conversions, Extensions, Forms, OAF, workflows, Customizations, Migrations, API’S, SQL, PL/SQL.
• Well experienced on complex Forms development using Template.fmb, forms registrations.
• Have experienced on enabled special Menus using Custom.pll and invoked custom forms from special menus
• Have experienced on Form Zoom functionality for invoked the custom forms from the standard forms using Custom.pl, forms personalization
• Experienced on FSG Reports, Experienced on Query, Reports Tunings, Explain Plan,TKPROF
• Designed and developed Noetix Views and reports.
• Experienced on SQL Loader complex scripts (Control file) and written validation programs
• Implemented AIM Methodology
• Worked with development, customization of Views, folders, EUL for Discoverer Reports 10G/4i and well versed in Discoverer Administrator, Discoverer Desktop and Discoverer Viewer, Discover Administration
• Have experienced on UNIX Shell Scripting, Experienced on Creation and maintained SRS
• Migrate the Concurrent Programs, value sets from UAT to Production using FND LOAD/KINTANA
• Gathered the requirements and prepared MD.50, MD.70, MD.120, CV40, CV 60, TE.20 documents
• Have involved in End - End Implementation projects
• Maintaining all the source codes with the modified versions in the PVCS/ VSS

TECHNICAL SKILLS:

ERP Applications: Oracle R12/11i/ 11.5.10.2/ 11.5.9/11.0.3/10.7 Applications.

Modules: Accounts Payables, Accounts Receivables, Order Management, General Ledger, Purchasing, Project Accounting, iProcurement, isupplier, Pricing Fixed Assets, Projects, Inventory Management, Bill of Materials, HRMS, Payroll, Service Contracts, ASCP,MRP,WIP,ECO

RDBMS: Oracle 10G/9i/8i/8.0 / 7.3 / 7.1

GUI: Forms 10G/6i/4.5, Reports 10G/6i/2.5, OAF, ADF, Noetix reports, Graphics 6i/6.0/3.0/2.5, Procedure

Builder, Query Builder, Discoverer 10G/4i/3i Oracle workflow, Power Builder 5.0, Toad.: Languages

SQL* Plus, PL/SQL, Java, Servlets, C: Oracle Tools

SQL* Loader, Data Loader, Import/Export: Web Tools

Oracle Application Server 4.0(OAS 4.0), Jdeveloper3.2/3.1: Case Tools

Designer 6i/2000: Networking

SQL*Net, Net8, ODBC, JDBC: Operating

Systems: Windows 95 / 98, Windows NT 4.0, Windows2000HP UNIX

Hardware: IBM Compatibles

WORK HISTORY:

Confidential, Tampa, FL

Sr. Oracle Apps Techno Functional Consultant

Responsibilities:

• Attended meetings, involved in requirement gathering, design, development, implementation and customization of Oracle Applications financial modules in such as AP, FA, PO, GL and SLA modules.
• Developed New Custom form from Scratch for External Files Load for PA
• Setting up value sets, concurrent programs, Setting User Profiles.
• Prepared Test Cases, Performed Testing and debugging
• Prepared MD.50, MD.70 and MD.120, TC400 documents
• Production Support and SR support

Environment: Oracle Applications R12 Financials, Oracle 10G, SQL*Plus, PL/SQL, Unix Shell Scripting, OAF, SQL Loader, Forms &Reports 10Gi, Oracle Work Flows, XML Reports, Discover Reports, Designer 2000, and Windows NT/2000.

Confidential, Gaithersburg, MD

Sr. Oracle Apps Consultant

Responsibilities:

• Involved in requirement gathering, design, development, implementation and customization of Oracle Applications financial modules in such as AP, AR, GL and SLA modules.
• AP Invoice Details Report
• Supplier outstanding Report
• AP Remittance Report
• Customer Outstanding report
• AR Receipts details reports with all statuses(Unapplied, Applied, Unidentified)
• Enabled DFFs for Additional Claims information
• OAF personalization done on Supplier and Customer pages
• Production Support and daily we get the data from external system and process the data into Oracle Apps. Every week we need to run the Payment batch for payments and send the outbound file to Main System.

Environment: Oracle Applications R12 Financials, Oracle 10G, SQL*Plus, PL/SQL, Unix Shell Scripting, OAF, SQL Loader, Forms &Reports 10Gi,Oracle Work Flows, XML Reports, Discover Reports, Designer 2000, and Windows NT/2000.

Confidential, Tampa, FL

Sr. Oracle Apps EBS Suite Consultant

Responsibilities:

• Involved in requirement gathering, design, development, implementation and customization of Oracle Applications financial modules in such as AP, FA, PO, GL and SLA modules.
• Developed outbound Interfaces for their requirements
• Customized standard forms using Custom.pll
• Customized custom PO Requisition workflow. The work flow will execute only for US for Account Standardization. It checks the profile first, if it is US then the workflow will execute. The workflow process in the earlier was only financial approval. Now we added DM, CM, BUA, SME levels. In the each level we are checking Primary CM, Secondary CM, and Default. Again in the primary, secondary, default divided into country, region, global. So it is checking each of them until find the CM at any level. The requisition should forward to each level internal instead of approve until financial approval reach. The requisition should approve only financial approval. The requisition should rotate two times of each level. We are maintaining custom history table for each approval.
• Working on Production support VTS/SRM/Kintana process
• AOL: Setting up value sets, concurrent programs, Setting User Profiles.
• Prepared Test Cases, Performed Testing and debugging
• Prepared MD.50, MD.70 and MD.120,TC400 documents

Confidential, Dover, DE

Sr. Oracle Apps E-Business suite Consultant

Responsibilities:

• Involved in design, development, implementation and customization of Oracle Applications financial modules in such as PO, AP, GL, INV modules.
• Developed forms and reports. Customized Standard forms using custom.pll.
• Developed Debit Memo/Credit Memo and AP Remittance XML publisher reports.
• Created staging tables, data files, control files, transferred Data from Legacy System to Oracle Application using SQL Loader
• Developed custom forms using Template.fmb
• AOL: Setting up New Users, responsibilities, value sets, concurrent programs, Setting User Profiles.
• AR: System options, Auto accounting, Receivable Activities, Customers, Profile Classes, Approval Limit Set up, Customer Consolidated Billing Invoice.
• Prepared Test Cases, Performed Testing and debugging
• Working for Support Issues
• Prepared MD.50, MD.70 and MD.120 documents

Environment: Oracle Applications 11.5.10.2 Financials, Oracle 10G, SQL*Plus, PL/SQL, Unix Shell Scripting, OAF, SQL Loader, Forms 10G/6i, Reports 10G/6i, FSG reports, XML Reports, Discover, Noetix Reports 10G, Designer 2000, Oracle Workflows, and Windows NT/2000.

Confidential, Louisville, KY

Sr. Oracle EBS Techno/Functional

Responsibilities:

• Involved in design, development, implementation and customization of Oracle Applications financial modules in such as OM, AR, AP, and PO, PA, GL and INV modules.
• Developed XML publisher reports for Sales Order Invoice, Drop Shipment, Back Order, Designed and developed Customer Aging, aging calculates on TRX Date. Vendor Aging, aging calculates on GRN’S date.
• Designed and developed AR Auto Invoice inbound interface program. Loads the data from flat file to staging tables using SQL* Loader. Created Validation Procedure. Validation procedure validates the data and inserts into Interface tables.
• Designed and developed outbound Interface for ordered Items with shipping information
• Designed and developed Custom forms from scratch using template.fmb for getting Additional Information on AR such as Customer Payments Additional Information, AR Adjustments and Remitter Information are invoking from the Special Menus. This form gets the data from Custom tables.
• Defined Buyer creation, Position, Position Hierarchy, Approval Hierarchy, Approval Groups setups
• Customized PO Requisition form using Custom.pll using AOL
• Experienced on data migrations from UAT to Production
• Have Worked on UNIX Shell Scripting for FTP and transfer the file for directory
• Have Worked on Production Support
• Designed and created Noetix Views and developed several Noetix reports in AR module.
• Prepared MD.50, MD.70, MD.120, TE020 documents

Environment: Oracle Applications R12 Financials, Oracle 10G, SQL*Plus, PL/SQL, Unix Shell Scripting, OAF, SQL Loader, Forms 10G/6i, Reports 10G/6i, FSG reports, XML Reports,Discover, Noetix Reports 10G, Designer 2000, Oracle Workflows, and Windows NT/2000.

Confidential, Dearborn, Michigan

Sr. Oracle Financial EBS Techno/Functional

Responsibilities:

• Involved in design, development, implementation and customization of Oracle Applications financial modules in such as AR, OM, GL, AR, INV, PO, INV modules. R12 implementation Project.
• Developed Customer Invoice report using BI Publisher. The report executes from package procedure. In the procedure the query will build dynamically depends on parameters selection. The records will temporarily stores into PLSQL RECORDS using bulk collect and ref cursor. In the looping checking whether the customer is changed or not? and the information stores into temporary table. Mapped the temporary table in the report main query. Whenever Customer is changed then only report should be submitted using FND REQUEST.SUBMIT REQUEST and the report output send to appropriate customer either mail or fax or print based on output format parameter selection.
• Developed Revenue and Cost Journals inbound interface for GL. Using SQL loader load the data from flat file to staging tables. Validation procedure validate the data and inserts the data into interface tables after that executes Journal Import program from package Itself. After run the program successfully Journals will be created in GL base tables. Developed two custom reports, outbound interfaces for revenue and cost journals and executes these from package. Outbound interfaces excel files should go to respective mail addresses.
• Created staging tables, defined record types, package functions for validations, package procedure for creating Trading Community Architecture (TCA) Customers creation using API’S. Creating Organizations, Customer accounts, Customer profile amount, Locations, party Sites, customer account sites, site use code, person, org Contact, customer account role, contact point like phone or fax and created the relationship between organization and person.
• Designed and Developed Internal Sales Order, Purchase Order Detail BI publisher reports.
• Customized GL periods Form using Custom.pll using AOL.
• Developed Scrap Journals. Gets the data from people soft and developed Custom report with six layouts. Each layout starts from new page.
• Designed and created Noetix reports
• Performance tuning done in various reports, procedures
• Experienced on data migrations from UAT to Production, Worked on Production support.
• Prepared MD.50, MD.70, MD.120, TE020 documents

Environment: Oracle Applications R12 Financials, Oracle 10G,SQL*Plus, PL/SQL, UNIX Shell Scripting, OAF, SQL Loader, Forms 10G/6i, Reports 10G/6i, FSG reports, BI Reports, Discover, Noetix Reports 10G, Designer 2000, Oracle Workrflow, Windows NT/2000

Confidential, Columbia, Maryland

Sr. Oracle Applications EBS Developer

Responsibilities:

• Involved in design, development, implementation and customization of Oracle Applications financial modules such as AP, AR, OM, INV, PO, PA modules
• Designed and developed Payables Open Interface. Designed and developed control file and staging tables and validation procedure. Gets the data from the flat file and inserted into staging tables. Created Validation Procedure. Validation procedure validates the data and inserts into Interface tables. For Errors generate the error file for review the errors.
• Customized Supplier site form using Custom.pll
• Designed and developed Blanket Purchase Order/ releases reports. The releases starts from new page on the same report
• Used Optimizer techniques and tuning the reports, procedures
• Designed and developed Customer Aging report.
• Designed and develop various reports like Packing Slip, Pick Slip, Sales Order Invoice using XML Publisher Template builder
• Involved in vendor setups, buyer setups, Approval Hierarchy, Approval Groups, Assign Approval Groups
• Responsible for configuration and setups of DFF, Lookups, menus, responsibilities for AR, AP, Po and Inventory modules.
• Involved in Customers, Credit check, Credit hold, payment terms, holds, shipping parameters, price list, defaulting rules, Customer Classes in OM module reports in GL, AP, and AR module.
• Developed .PROG files using UNIX Shell scripting for move the files from one directory to another directory. The executes the file from package procedures.

Environment: Oracle Applications 11.5.9 Financials, Oracle 10GSQL*Plus, PL/SQL, UNIX Shell Scripting, OAF, SQL Loader, Forms 10G/9i/6i, Reports 10G/9i/6iXML Reports, Discover Reports, Designer 2000, Oracle Workrflow, Windows NT/2000

Confidential, Pittsburgh, Pennsylvania

Software Engineer

Responsibilities:

• Involved in customization and support of Oracle Applications in modules such as AR, AP PO, GL, OM, FA and INV modules
• Standard Purchase Order with 2-Way, 3-Way-, 4-Way matching, blanket purchase order/Releases Report, sub-Inventory transfer
• Developed Journal Import inbounds Interface Program. Designed and developed control file and staging table and validation procedure. Get the data from the flat file and inserted into staging tables using SQL loader. Created Validation Procedure. Validation procedure validates the data and inserts into Interface tables. For Errors generate the error file for review the errors.
• Involved in customization and bug fixing of custom reports, reports with in the SLA
• Developing Application architecture & MD70, MD120 documents
• Migration of Data from UAT to Production
• Customized Standard Request Submission form using Custom.pll using AOL
• Assisting team in delivering the code as per the required standards
• Developed Outbound Interface in Fixed Assets for Asset listing using UTL package.

Environment: Oracle Applications 11.5.9 Financials, Oracle 9i, SQL*PlusPL/SQL, SQL Loader, Forms 6i, Reports 6i, Discover Reports, Designer 2000, Oracle Workflow, Windows NT/2000

Confidential

Sr. Apps Consultant

Responsibilities:

• Involved in design, development, implementation and customization of Oracle Applications financial and manufacturing modules such as OM, AR, PO, OPM, BOM, WIP, PA, MRP, ASCP, PA, HRMS INV, AP, GL modules
• Designed and developed Samples Creation custom form from scratch using template.fmb. This form is uses for creation of samples in various shifts. After enter the shift code, machine, batch formula, process and packing and employer information. Whenever clicks the sample creation button then 8 samples are created with quantity, UOM and the samples are the combination of shift code, machine, batch formula, process and packing. Transfers the Data into Base tables after click the transfer button. The quantity and UOM gets from header block using copy value for item.
• Designed and development of BOM Routing Interface. Designed and developed control file and staging table and validation procedure. Gets the data from the flat file and inserted into staging tables. Created Validation Procedure. Validation procedure validates the data and inserts into Interface tables. For Errors generate the error file for review the errors.
• Developed report for Dunning letters of Customers, Designed and developed standard purchase Order Report
• Worked on Forms Personalization for Customization of Standard Forms.
• Developed Outbound Interfaces for AP/AR Invoices Summary with in the date range
• Developed Procedure for Release Plan Orders with respective lines
• Responsible for creation Functional Specification for Reports and Interfaces
• Migration of data from UAT to Production, have worked on Post Production Support
• Created the Batch File using UNIX for file transfer from Server to Desktop
• Prepared MD 50 and MD 70, MD.120 Document

Environment: Oracle Applications 11i Financials, Oracle 9i, SQL*Plus,PL/SQL, OAF, SQL Loader, Forms 6i, Reports 6i, Discover Reports, Designer 2000, Oracle Workflow, Windows NT/2000

Confidential

Responsibilities:

• Requirements gathering, Involved in design, development, implementation and customization of Oracle Applications financial and manufacturing modules such as AP, AR, PO, OM modules
• Standard Purchase/ Blanket Purchase Order
• Purchase Order Releases
• Excise Invoice
• Sales Invoice
• Debtors Out Standing
• Un-Adjusted Receipts
• Creditors outstanding
• RTV Invoice
• Form515 for OSP Items
• Form45-A Sales Invoice
• Import Purchase Order
• Sales Invoice
• Packing List
• Self certified Items
• Move order
• Debit memo
• Sample Items Checking for New Suppliers

Environment: Oracle Applications 11i Financials, Oracle 9i, SQL*Plus, PL/SQL, OAF, SQL Loader, Forms 6i, Reports 6i, Discover Reports, Designer 2000, Oracle Workflow, Windows NT/2000

Confidential

Responsibilities:

• Requirements gathering, Involved in design, development, implementation and customization of Oracle Applications financial modules such as AP, AR, GL modules
• Customer Aging/ Supplier Aging reports
• Customer Invoice report
• Pending GRN’S
• Un-Adjusted Receipts
• RTV Invoice
• Check Printing report
• AR Auto Invoice Interface
• AR/ AP Invoices Summary

Environment: Oracle Applications 11i Financials, Oracle 9i, SQL*Plus,PL/SQL, OAF, SQL Loader, Forms 6i, Reports 6i, Discover Reports, Designer 2000, Oracle Workflow, Windows NT/2000

Confidential

Responsibilities:

• Requirement gathering and prepared MD.50, MD.70 documents
• Designed and developed 10 apps custom forms from scratch using template.fmb for Procurement and Quality Assurance custom modules
• Developed Custom reports for AP Check and AP Remittance information
• Writing PL/SQL Procedures and Functions.
• Developed an Invoice outbound interface to extract all the AP invoice information from the Account Payables base tables into the excel files
• Using FND LOAD load the objects from UAT to Production
• Creation of Concurrent Programs and Value Sets, Customizations of standard forms and developed new Custom forms
• Unit and Integration testing, Preparation of User Documentation.
• Production Support
• Material Receipt Note, Inter Org Stock Transfer Note, Rejections Note, Stock Adjustments Note, Slow Moving Items, Non Moving Items
• Developed Custom Form for load the data from tables and Inserting into Summary tables using Dynamic SQL
• Requisitions Listing Report, ASL Supplier Listing Report, Customized Requisition Entry Form, Quotations Entry Screen, Quote Analysis, Developed form for Purchase Order with Lines and Shipment details
• Developed Custom Form for load the data from flat file to Base tables using Text IO package
• Developed Fort Night Screen for Receiving payments from the Debtors
• Agent Master, Route Master, Rate Master, Daily Milk Collection Sheet
• Analysis Reports like Agent wise and Route wise report, MIS Reports

Environment: Oracle Applications 11i Financials, Oracle 9i/8i, SQL*Plus,PL/SQL, SQL Loader, Forms 6i/4.5, Reports 6i/2.5, Designer 2000, Windows NT/2000