PROFESSIONAL SUMMARY:

• Over 8 years of experience with Oracle Applications R12 (12.1.3) and 11i (11.5.10, 11.5.9, 11.5.8) E - Business Suite.
• StrongTechno-Functionalexperience inOrder to Cash Process, P2P, SCMandmoreTechnicalexperience in all Financial, ManufacturingandDistributionmodules inEBS.
• Good expertise in Oracle financials modules (AP, AR, GL, Cash Management, FA), AOL, System Administrator and Supply chain management (SCM) and CRM, E Biz Tax, i Exp, i Proc..
• Two full lifecycle Implementations R12 with Two full lifecycle Implementations R12 with GL, AP, AR,FA,CE,iProcurement, I Receivables, I Expenses, E-business tax and Sub ledger Accounting(SLA) .
• Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Setup Global Inventory (INV) profile options, Purchasing (PO) profile options and Order Management (OM) profile options Strong working knowledge of business flows like Order-to-Cash (O2C) and Procure-to-Pay (P2P) along with the dependencies and relationships between Oracle Applications modules.
• Expertise in SQL* Plus, PL/SQL, Forms 6i, Reports6i, XML Publisher, Workflow, OAF, Interface Development.
• Expert level knowledge and experience in developing objects for implementation and upgrade in Oracle Applications like
• Data Conversion codes in (AP, AR, GL, INV,PIM, OM, PO, BOM, WIP)
• XML Reports / BI Publisher / XML Gateway
• OAF (Oracle Application Framework)
• Personalization (Forms / HTML pages)
• SQL Loader / Shell Scripting / Unix / PLSQL
• TOAD / SQL developer / WF builder
• Strong experience and expertise inOracleApplicationRICEW(Reports, Interfaces, Conversions, Extensions, Work flow),EDI, FSG ReportsandAPI'sdevelopment using the Development Suite/tools (likeOracle Forms, Oracle Reports) PL/SQL, Work Flow Builder2.6, OBI/XML Publisher, SQL*Loader, Discoverer, SQL*Plus.
• Strong knowledge in Testing the Order to Cash (O2C) life cycle with all the Standard items in Order Management (OM) and Financial Modules.
• Actively involved in performance tuning task force team, fine tuning all the affected processes (Reports, Concurrent Programs) which would have High I/O Cluster waits.
• Expert in using UTL FILES, Export, Import, SQL*Loader Utilities, FTP, TOAD.
• Have been a part of User Acceptance Testing Phase in many projects and wrote Test cases to verify the functionality of many process.
• Good working knowledge in Technical Documentation using AIM Methodologies (MD50, MD70, CV40 AND CV70) and Agile Methodologies.
• Expertise in design and development of Interface Conversion Programs to import data from legacy systems and integrate it into Oracle Apps using open interfaces and API’s.
• Excellent skills at programming in PL/SQL (Triggers, Functions, Packages, Procedures), SQL*Plus, SQL*Loader, Oracle Reports 6i, PL/SQL Bulk Programming.
• Thorough understand of source-code repositories, Version control tools and migration activities.
• Excellent Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Good expertise in using Application Implementation Methodology (AIM) and TCA (Trading Community Architecture).
• Involved in all phases of Software Development Life Cycle.
• Good communication skills and excellent understanding of Business applications. Willing to take up challenging assignments and interested to work in different kinds of modules and emerging technologies.

TECHNICAL SKILLS:

Oracle Application: Oracle E-Business suite R12/11i OM, INV, GL, AP, AR, PO, FA, CM, SLA,AOL and System Administration.

Application Tools: Reports 6i/10g, Discoverer 4i/9i/10g, BI/XML Publisher 5.6.3/5.6.2 , Oracle Forms 6i/9i/10g, TOAD, SQL*PLUS, Export, Import, SQL*Loader, Oracle J Developer, OA Framework, AOL

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS.

Languages: SQL, PL/SQL, Web PL/SQL, C, Java Script, Java, HTML, XML.

Scripting Language: UNIX Shell scripts, Python, Perl.

RDBMS: Oracle 8i/9i/10g/11g, Access, SQL Server 2000, MySQL.

PROFESSIONAL EXPERIENCE:

Confidential, Wisconsin

Oracle Techno Functional Consultant

Responsibilities:

• Involved in Auto invoice interface to load invoices automatically from Legacy systems to Oracle Receivables to interface tables.
• Implemented Order to Cash modules: OM, Inventory, Warehouse, Purchasing, Receiving and module integrations withOM GL, AP, AR, CM, INVwithinEBSSystem.
• Designed solutions to enhance standard oracle flows for Order to Cash (O2C), Procure to Pay (P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Registered concurrent programs & request sets to load AR customer, Lockbox and Transaction interface.
• Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
• Involved in implementation and testing of Oracle Applications Financial R12 GL, AP, AR and CRM modules.
• Customized various transactions in Account Receivables like Invoice, Receipts, Credit Memos and Debit Memos etc. Customizations ofRequisition Approval,PO Approval&Auto Create Workflows.
• DevelopedFSG Reports in GLlike (Income statement, Dept. Expenses, Inter Company Summary)
• Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked on customization of Fixed Assets Account generator process where the retirement and cost accounts are derived from the data entered instead of the default setups
• Built custom reports using Oracle Report Builder and integrated them with the application (based on descriptive flex fields) to solve the clients reporting needs.
• Involved in creating workflow and assigning alerts to the workflow.
• Involved in validation of PO workflow approval for approving purchase orders.
• Built custom forms using Form Builder to fulfill business requirements of the clients.
• Customized existing forms to add search criteria on descriptive flex fields.
• Fixing bugs in forms and reports previously designed.
• Extensive use of PLSQL programming like procedures, functions, triggers & packages and used dynamic SQL in stored procedures.
• Responsible for creating value sets required for the additional parameters.
• Used SQL Loader and UTL file packages for data conversion and interfaces.
• Developed customer conversion program to load the customers from legacy system into Oracle EBS System by using the TCA APIs.
• Developed SQL *Loader Scripts to load data into staging tables.
• Created and registered Concurrent Programs and Request Sets required for all the conversions in Oracle R12.
• Provided various validations such as purging previous data, checking for duplicate files, validating input data, updating invalid data, formatting input data and transferring data from custom staging table(s) to interface table(s) such as GL INTERFACE.
• Created some Periodic Alerts, Event Alerts in Oracle EBS R12 as per the customer requirement.
• Worked extensively on inventory turns report using BI/XML Publisher.
• Wrote UNIX Shell Scripts for copying and moving files to and from the server.
• Developed design and implementation documents such as MD070, MD120 and user documentation.
• Involved in testing the System Integration Testing, User Acceptance Testing, Preparation of material, and conducting actual User testing.

Environment: Oracle Apps Financials EBS R12 and EBS 11.5.10.2 (GL, AR, AP, Cost Mgmt), PO, INV, OM, SLA,SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, U NIX, P4V, Team Track, TOAD, Workflow Builder, SQL*Developer.

Confidential, New Jersey

Oracle Applications Techno-Functional Consultant.

Responsibilities:

• The project involved in implementing and developing various RICE components for financial, supply chain Management, Order management, inventory, Oracle CRM in R12.
• Developed an Inbound Interface in CRM module with all Standards, for uploading the Service and Software Subscription Agreement legacy data into Customer Base Tables. The error data is captured into Custom tables and forwarded to client's mail through e - mail Frame Work Mechanism.
• Responsible for all workflow customizations and customized various workflows like Requisition Approval Workflow, PO Approval Workflow, Create PO workflow, Order Line Workflow, and PO Requisition Account Generator as per user requirements.
• Testing the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
• Developed the Form to upload multiple records at a time via single formatted .csv file for both insert and delete operations.
• Worked on BI Publisher Report for Display Unit Selling Price, Shipment Value (Unit Selling Price * Order Quantity) And Shipment Value (USD) and Total Order Value only Once for the first occurrence of the Order#, Ship set# and Line# combination to avoid Duplicates.
• Defined and tested Mass Allocations for IR Group Books to distribute Costs across different Cost centers.
• Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder and Application Object Library (AOL).
• Prepared design documents (MD050), technical documents (MD070) and Installation documents (MD120) for all the customizations.
• Update the Account Generator Process for the Set of Books to use the new workflow process.
• Created and used stored procedures, packages, cursors and functions to do the validations on the Legacy data, Created indexes to enhance the performance of the application.
• Worked on conversion of journal entries from old set of books to new set of books.
• Created Staging tables to load the records and uploaded the flat files using SQL*Loader.
• Involved in managing concurrent programs, application user setup, defining responsibilities.
• Customized the Journal Entries Report in AR, which is used to review the details that make up the general ledger journal entries.
• Registered the PL/SQL scripts using Concurrent Programs and attached the programs to Request Sets.
• Designed and developed Fixed Assets (FA) Conversion by running Mass Additions Concurrent Program to Transfer the data from interface to base tables in Fixed Assets (FA).
• Created and customized Reports in AP, AR, FA, and OM using Reports 10g.
• Used FNDLOAD utility to migrate the responsibilities, request sets, concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization's etc.
• Involved in the User Acceptance testing and Post Production support.

Environment: Oracle Applications R12.1.3 (GL, AR, AP, PO, OM, FA, I Expenses, Payments, Cost Mgmt.), SLA, Oracle 10gSQL, PL/SQL, Forms 10g, Reports 10g, Developer 10g, Work flow and TOAD.

Confidential, Ann Arbor

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Worked as a technical developer in an 11i implementation project.
• Worked on Inbound Interface in AP module to upload AP Invoices from The Previous System with all Apps Standards, for uploading the legacy data into Customer Base Tables. The error data is captured into custom and seeded error tables and forwarded to client's mail through e - mail procedure.
• Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables (Ar Payments Interface All), from interface table to the Base Interim tables and finally to the base table.
• Provide solution of complex issues like pay groups and Operating Units through SLA
• Customized seeded Invoices Form in AP module using personalization, such that, for invoices that are paid either fully or partially, the fields Invoice Date, Invoice No. and Invoice Amount are protected against Update.
• Setup and ConfiguredGL, AR, AP, FA, PO, CM, ADI, version R11i.
• Modified SLA Definition as per client's requirement and resolve problems with SLA.
• Developed an .rdf Report in Account Payables to get the details of payment status.
• Developed an .rdf Report in Account Payables to retrieve the details of Payment Holds Information.
• Developed a Report in PO to get the details of Request for Quotation generated Legal entity (LE wise) &operating unit (O.U.wise).
• Developed a report in Account Receivables (AR) to retrieve the Payment Information.
• Developed custom forms using TEMPLATE.fmb to hold additional item information.
• Developed SQL *Loader Scripts to load data into staging tables.
• Registered the PL/SQL scripts using Concurrent Programs and attached the programs to Request Sets.
• Documented the work done as per the client requirement.

Environment: Oracle Apps Financials EBS R12 and EBS 11.5.10.2 (GL, AR, AP), PO, INV, OM, SLA,SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, Team Track, TOAD, Workflow Builder, SQL*Developer.

Confidential, Atlanta

Oracle Apps Technical Consultant

Responsibilities:

• Responsible as a primary Technical Lead/owner for Project accounting, Purchasing, Order Management (OM) and Inventory (INV) Modules and developed various customizations in Advance Pricing, GL.
• Involved in Registration/Migration of concurrent programs, executable, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.
• Lead multiple projects under numerous modules including custom applications, some of them are mentioned below:
• Inventory - Item Load, Item categories, Item Status Change Program, Item Auto Assign Program
• Purchasing - Change PO Program (Create PO Workflow), Loading Requisitions and POs from legacy systems
• GL- GL Interfaces and Journal Balances in Outbound interface.
• Order Management(OM): Price List conversion, Custom Sales Order Import, Packing Slip report, Pick slip reports
• Developed xml reports in PA, AR, and OM.
• Actively involved in performance tuning task force team, fine tuning all the affected processes (Reports, Concurrent Programs) which would have High I/O Cluster waits, Poor Explain Plan, High CPU Cost. Reviewed (by generating trace files, explain plans etc.) and modified the existing programs to drastically increase the performance.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Achieved custom functionality in OM Sales Order form, Purchasing Receiving Controls form through Forms personalization
• Involved in various Interfaces and conversions, some of them are mentioned below:
• Interfaces: Receiving Transaction Processor, Requisition Import, and GL Interfaces.
• Conversions: Item (IDS) Conversion, Categories Conversion, Price List Conversion.
• Assisted users in Month end Closing procedures.

Environment: Oracle Applications (R12), Oracle10g, Oracle Forms, INV,PO,OM,PA,GL and Oracle Workflow 2.6, Reports 6i

Confidential, Houston

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked pre dominantly on Project Accounting Module.
• Performed Project conversion from Legacy system and implemented interface to create and update project related data from third party system called GOET.
• Designed and implemented TNL and time sheet related cost import process into ERP and implemented error reports for users.
• Designed and implemented score card report for failure transactions.
• Implemented payroll program based on time sheet information we have in PA.
• Customized Project and Budget related approval workflows.
• Customized account generator workflows.
• Customized Billing and costing Extensions.
• Implemented form personalization on Event entry form.
• Implemented draft and invoice reports.
• Customized purchase Order report.
• Implemented Purchase order, Receipt interface from third party systems and exception reports for failures.
• Monitoring all PA and GL interfaces during closing period and resolving if any issues.

Environment: Oracle Applications (R12), Oracle11g, Oracle Reports 10g,PA, BI/XML Publisher, UNIX, Team Track, TOAD, Workflow Builder, SQL*Developer.

Confidential

Oracle Apps Developer

Responsibilities:

• Migrated the data from the legacy systems into OracleApplications INV module using Item Import Program.
• Developed custom interface program to load Inventory (INV) Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables.
• Extensively worked on OM API's to import the orders from the legacy system and to process the order.
• Developed interface to populate WIP move interface tables and to submit concurrent request to perform WIP move transaction.
• Reviewed the process flow in OM module with Business users and developed GAP analysis report.
• Developed multiple custom reports in AP, AR, PO, GL and Fixed Assets. Played a major role in the go - live support for the smooth transition of the business activities from the legacy applications into OracleFinancials.
• Developed Reports to extract the monthly sales information. Developed custom reports and added columns in the existing reports according to the requirement.
• Involved in performance tuning of PL/SQL code and SQL queries using Explain Plan, TKPROF, Events 10046, Hints, ASH Reports, ADDM and TOAD.

Environment: Oraclee-Business Suite 11.5.9, OracleDatabase 9i Special SoftwareOracleApps11i, PL/SQL Developer, Toad,OracleWorkflows,OracleForms,OracleReports, Data Loader, SQL loader, Putty.