SUMMARY

• Over 7 years of experience as an Oracle Applications (E - Business Suite) Consultant, Technical developer with experience in developing and customizing Reports and Forms using Oracle Forms 10g/6i/4.5 and Reports 10g/6i/4.5 and XML Publisher 5.6.2/5.6.3.
• Experience in the Implementation and Customization of Order Management (OM), Oracle Inventory (INV), Purchase Order (PO), General ledger (GL), Account Receivables (AR), Account Payable (AP), CE, Shipping (WSH), Order2Cash, Invoice to Cash, AOL and System Administrator.
• Expertise in Design, Development and Customization of RICE (Reports, Interface, Data Conversions and Extensions/Customization) using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader.
• Data conversion/integration from Legacy systems and external systems into Oracle Applications.
• 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.
• Used Trading Community Architecture (TCA) APIs to create/Update Parties and Relationships.
• Strong working knowledge of business flows like Order-to-Cash and Procure-to-Pay along with the dependencies and relationships between Oracle Applications modules.
• Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
• Experienced in Customization and development of New Forms and Forms Personalization.
• Developed Custom Forms using Forms 10g to provide Zoom functionality using Custom.pll.
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts
• Experienced in Performance Tuning and analyzing using Tkprof, SQL Trace, and Explain Plan.
• Sound working knowledge in UNIX Shell Scripting.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents using AIM Methodologies.
• Experience in supporting the production system and handling day-to-day issues.

TECHNICAL SKILLS

ERP: Oracle applications 11i/11.x/R12 AP, AR, GL, SLA, CE, PO, OM, HR, PA, Advance Pricing

Databases: Oracle RDBMS, Oracle 8i /9i/10g/11g, MS SQL Server 2000

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, PERL,UNIX Shell Scripting

Web Technologies: HTML, JAVASCRIPT

Tools: Forms 6i/9i/10g, Reports 6i/10g, OA Framework, SQL Navigator, Oracle Work Flow Builder 2.5, JDeveloper, XML Publisher 5.6.3/5.6.2 , TOAD, SQL*PLUS, and Export, Import, SQL*Loader

Operating System: UNIX, Linux and WINDOWS family

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Worked on inbound interface of automatic payroll system to get the data from the new source system and import in to the PA and GL base tables from the account and work file staging tables.
• Prepared design documents for the CAN Extract to process the new source system records and get the CAN BACS for the listed agencies.
• Enhancement of supplier to people inbound interface to process the data for the AP, PO, HR employees and suppliers from the new source system NFC.
• And import or update to the HR and AP base tables.
• Worked closely with functional team to set up JE categories, JE sources and PA sources for the new source system created.
• Worked on the FND tables to pull the GL segments information using the fnd id flex segments, fnd flex values, fnd application etc.,
• Created new lookups for the agencies under each OpDiv to filter them according to the enabled flag.
• Developed PL/SQL packages, procedures for the given task to generate a Control Access Number extract for the filtered agencies.
• Done performance tuning in order to make the query efficient, and less time consuming.
• Detected changes need to be done in the reconciliation, suspense CANS and several other reports and custom forms using Oracle Dev Suite.

Environment: s: Oracle Applications R12, HR, AP, PA, PO, GL, FND, Forms, Reports, SQL*Loader, TOAD, UNIX, Windows 7.

Confidential, Milpitas, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked on Invoice adjustments, deferral calculations, applying credit memos in AR.
• Defined Auto-Lockbox and Transmission Format and ran standard Lockbox program to transfer receipts into Oracle Receivables.
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format
• Designed a solution for the new orders to be processed in AR and GL.
• Authored Functional and Technical design documents for customization and/or development of various Conversions, Interfaces and Reports across GL, AP and AR modules.
• Worked on Revenue Recognition of AR for the enhancement of Revenue accounting engine.
• Extensively worked on Daily Rates Interface, Customer Interface, Tax Interface and Journal Import from GL interface using PL/SQL procedures.
• Worked on gl balances, gl periods, and gl daily rates tables along with AR tables.
• Created ERD for the data model changes that need to be made for the project.
• Analyzed PL/SQL packages and worked towards performance tuning.
• Worked on Reason Codes, GL Periods, GL Posting and Financial Summary.
• Designed AS-IS and TO-BE process flows for the WebEx orders including the table level analysis.
• Driven meetings from the On-Site through WebEx to co-ordinate with the Off-Shore team.
• Designed process flows and table architectures using Microsoft Visio.
• Involved in the BRD and TFSD preparations and worked with business team to provide feasibility level of BRD’s.
• Developed PL/SQL procedures, functions and packages.
• Created the materialized views and also created the partitioning tables.
• Created several PL/SQL packages, stored procedures and functions.
• Worked on database triggers for automatically updating the tables.

Environment: s: Oracle apps R12 (AR, GL, OM, INV), NG CCRM, WebEx, Toad, Microsoft Visio, ADF Screens, PVCS, Kintana, Windows 7.

Confidential, Secaucus, NJ

Oracle Apps Technical Consultant

Responsibilities:

• Worked on the Auto Invoice Interface to load legacy invoices into AR.
• Involved in customer conversion from legacy system into Oracle Accounts Receivable (AR) by using Customer Interface.
• Enhanced invoice printing Interface and to its report according to the client requirement in AR. Used Report Builder 6i to make the changes.
• Worked on the Qualifier and Modifier setups of the Price list in Advance Pricing.
• Created and tested an AR Divisional Aging report customer transaction to have customer transactions, name, Bill - to location and Etc., in AR.
• Involved in implementation of the Interface for the statuses to generate for the sales orders in OM.
• Created a new hold code for the one of the OM business line. And assigned the responsibilities to it.
• Implemented and tested on the report for the open orders to show when they are booked.
• Changed User for the COOP Budget Load Program in the Oracle Trade Management.
• Designed and Developed Staging tables, Data Conversion, Custom API(Interfaces) and SQL Loader Programs to import the data from legacy system into OM using Order Import Concurrent Program.
• Created an alert of type periodic to email to the OTC group ICLE business center.
• Enhanced Re pricing package to have a condition to check with list price on the line to the unit list price in the Advance Pricing before it re prices.
• Created Price Lists In Advance Pricing. And added Items to the Price List.
• Used QP tables for the price comparison of an Order line to price of the price list.
• Enhanced an Outbound Interface of the Order status to include tracking and carrier information from WSH (Shipping) tables.
• Created a new Order category for the DFF’s of sales order header additional information.
• Defined the descriptive flex fields and key flex fields in AR and GL module
• Worked on the Application Object library (AOL) to create executables, concurrent programs.
• Added values to the existing value set of a DFF in the value set of type table.
• Worked in System Administration to add the responsibilities to user, assign requests to a group Etc.,
• Worked on the Work flow builder and its tables to have statuses generated for the bill only orders.
• Worked with the DBA team to have a new print style to increase the logical page width and length for an output to avoid blank spaces in the spool file.
• Done UAT for some the enhancements in the OTC team. And interacted with user to approve it to move in to production.
• Involved in the preparation of various documents like MD050, MD070 (functional & Technical Design), Mapping, Configuration documents.
• Involved in Preparation of User test plan for the UAT and Installation guide to migrate the changes from development instance.

Environment: Oracle Applications 11.5.10, AR, OM, WSH, Advance Pricing, Forms, Reports, SQL*Loader, Work Flow Builder, CVS, TOAD, UNIX, Windows 7.

Confidential, Exeter, PA

Oracle Apps Technical Consultant

Responsibilities:

• Involved in various aspect of R12 upgrade User interaction, Designing, Developing, and Documenting, creating test cases, modifying current customRICE objects in accordance with the R12 guidelines, tuning of queries and testing of various objects.
• 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.
• Worked on accounting process of Sub Ledger Accounting (SLA) to GL transfer.
• Created events in SLA of R12 to process the records to GL.
• Worked on xla ae headers, xla ae lines and xla ae events tables of SLA.
• Implemented and tested Purchasing solution - Procure to Pay (P2P)Integrated purchasing with payables to allow matching invoices to PO receipts.
• Created AP supplier sites for the existing Suppliers using AP Supplier sites open interface.
• Worked on Bank Statement Open Interface to load account statements information into Cash Management. worked on cash positioning and forecasting templates taking into account both internal and external transaction sources.
• 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.
• Involved in creation of functional and technical designs for conversion of the data from the existing system.
• Worked with Application Object Library (Defined executable, programs, linked with responsibilities, defined DFF and value sets.
• Customized Supplier Open Balance Report in Accounts Payables (AP) using XML/BI Publisher
• Defining setup option, Accounting Flex fields, set of books, security rules, recovery Journals, Budget, Budgets organizations mass budget formulae, roll up groups in General Ledger Modules.
• Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.
• Analyzed legacy system and prepared Functional (MD050), Technical (MD070), Conversion Mapping (CV040) documents for converting Open Sales Orders, Price Lists including discounts, Customers, Purchase Orders and Assets.
• Used FND SUBMIT Pub to Submit Requests, Request Sets.
• Worked with FND PROGRAM package to Register, Delete the Concurrent Programs from the backend.
• Extensive hands on experience with Oracle Applications Framework (OAF)
• Developed custom forms in AP usingOracle Applications Frame Work (OAF).
• DevelopedOAF Screens for OE (Open Enrollment) for client associates
• Customized supplier inquiry page using VO Extension and controller extension of OA Framework
• Developed a custom page using OA Framework to register new suppliers and submit for approval
• Worked on customizing a webpage to initiate custom workflow from OA Framework webpage.

Environment: Oracle Applications R12 (EBS) AP, PO, SLA, GL, CE, INV, Forms, Reports, OA Framework, SQL*Loader, Work Flow Builder, TOAD, UNIX, Windows.

Confidential, New York, NY

Oracle Technical Developer

Responsibilities:

• 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.
• Involved in writing Package to extract Orders from Legacy System, validated and imported into Order Management Interface tables and submitted a concurrent request to populate base tables.
• Involved in writing AR Premium Extract Outbound interface program, Extracting Data from AR Base Tables (Transactions, Receipts and Adjustments) into Temp Table and Generated Data File Using UTL FILE.
• Worked on Auto Invoice Conversion (AR) Program to validate, load credit memos, debit memos and invoices from legacy system.
• Converted the customer information from legacy system into Oracle Applications using custom program and API to affect the HZ tables in TCA.
• Responsible for converting all the PO vendors, vendor sites and vendor contacts into Production.
• Used PL/SQL extensively to write SQL outbound, procedures, packages, database for validations etc.
• Worked on personalization and extensions of Oracle standard pages usingOracle Applications Frame Work (OAF).
• Have extended the HRMS Self Service screens usingOAFto meet the various business requirements
• Customized various reports in OM, AR Module including Outstanding Hold Report, Invoice Aging Report, and Reconciliation Report.
• Developed executive level reports for Inventory listing, Inventory wholesale value, Inventory retail value, listing by quantity, listing by cost, listing by date using Reports Developer 10g.
• Created SQL Loader scripts to load data from legacy systems to Oracle Apps.
• Modified existing reports by creating additional joins. And Designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• PersonalizedHRMS screens usingOAF
• Have personalized and customized various screens in benefits using J Developer andOAFmeeting business requirements
• Firsthand knowledge and experience on all OAF concepts: list of values, page redirect, partial page rendering, View Objects(VO), Entity Objects(EO), Application Module(AM), SPEL, VO Extensions, CO Extensions, personalization’s etc.
• Customized Iprocurement pages using VO Extension and Controller extension of OA Framework.

Environment: Oracle Applications R12 (AR, PO, OM, INV) Oracle 10g, OA Framework, Reports 10g, SQL* Loader, PL/SQL, XML/BI publisher 5.6.3, TOAD, Windows XP.

Confidential, Libertyville, IL

Oracle Apps Technical Developer

Responsibilities:

• Loaded legacy Journal Entries in General Ledger (GL) into the interface table and developed a validation program to check for valid entries.
• Developed an interface to run the Standard Journal Import Program in General Ledger (GL) to load those valid journal entries into their respective base tables.
• Involved in day-to-day maintenance of Account Payables (AP) invoice approval process.
• Designed and developed interface scripts for Account Payables (AP) interfaces such as AP invoice import.
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR PAYMENTS INTERFACE ALL.
• Validated and imported the data into AR base tables.
• Experience in custom.pll for Customization of forms in OM, AR modules and also responsible for creating new forms using template.fmb
• Designed and customized various Oracle reports in financial and supply chain management.
• Used AOL and System Administrator Responsibility for registering the developed and customized reports.
• Performed AOL Tasks such as Creating responsibilities, users, request groups and attaching responsibilities to users
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables
• Developed views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Extensively worked on XML Publisher to generate custom reports.

Environment: Oracle Application E-Business Suite 11.5.10.2, R12 (AR, AP, GL, PO, OM) Oracle 9i/10g, XML/BI Publisher, PL/SQL, SQL Bulk Loader, Oracle Reports 6i/10g, Oracle Forms 6i/10g, TOAD 10.1.1.8.

Confidential, Detroit, MI

Oracle Applications Technical Consultant

Responsibilities:

• Worked on the setups of Order to Cash life cycle. This included Customer, Order Types, Item and credit checking rules.
• Developed custom API’s to change the move order lines after pick release.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Cancellation and creation of order lines using Process order API.
• Designed and Developed the Back end process for Auto Lock Box Interface to read and write the multiple files coming from Bank.
• The preprocessor is then used for receipts validation before submitting the auto lockbox validation.
• Also tested Process lockbox program and tested the setup of lockboxes.
• Worked extensively on System Administration responsibility by doing set ups in AR, AP and GL Modules.
• Modified Privileges for Users using System Administration responsibility depending upon various Organizations.
• Developed new reports such as Cancelled Sales Orders, On-hand Details, Material Adjustments using Reports 6i and XML/BI Publisher
• Worked on complete Software development Lifecycle (SDLC, from gathering requirements to deployment).
• Created the materialized views and also created the partitioning tables.
• Written shell scripts and used them as Concurrent programs for data extraction from Inventory.

Environment: Oracle Applications 11i (EBS) (GL, AR, AP, OM), SQL*Loader, Developer 6i (Forms and Reports 6i), XML publisher, Workflow 2.6, VSS, TOAD, and UNIX.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Customization of Standard Consolidated OM/PO Reports, which includes extensive PL/SQL code (Procedures and Functions) using Report Builder 6i.
• Involved in writing Interfaces using PL/SQL Procedures of incremental and refresh program (Inbound and Outbound) to send data from one system to another.
• Responsible for implementing Purchase Order Interface program with validations to Import Purchase Order from legacy system into Oracle Purchase Order base tables
• Customization of Standard Consolidated OM Reports, which includes extensive PL/SQL code.
• Designed and Developed Repository for Order Management and Invoices for Reports.
• Requirements Analysis and Technical documentation, development/enhancement of Custom reports, interfaces for SCM modules.
• Invoices are ported from the Excel sheets to the Oracle Database using SQL * LOADER.
• Involved in setup and customization of Oracle Payables and data conversion from legacy system into Oracle Payables.
• Involved in preparation of Functional and Technical Documentation using AIM Methodology.

Environment: Oracle Applications 11i (OM, PO, AP, AR), Oracle 9i, Forms6i, Reports 6i, PL/SQL, SQL*Loader, Toad 7, UNIX, Windows.