SUMMARY:

• Around Eight years of extensive experience in Analysis, Design, Development, Testing, Implementation and upgrading Oracle Applications 11i, R12 of Software Applications using Oracle Applications Financial and Manufacturing modules.
• Extensive experience in Oracle E - business suite Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Purchasing, me-Procurement, me-Supplier, Shipping, Inventory, Application Objects Library (AOL), System Administration, Functional Administrator modules.
• Demonstrated delivery in Procure to Pay and Order to Cash business flows.
• Extensive experience in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Extensively worked in Oracle back-end programming and Front-end development using tools like TOAD, PL/SQL*Plus, SQL*Loader, Oracle*Forms 10g/6.0, Oracle*Reports 10g/6.0, XML Publisher.
• Extensive experience in Implementations, version upgrades, Personalization, data conversions, customization of Reports and Forms in Oracle Applications.
• Development and customization ofForms personalization, Reports and Interfaces in Oracle Apps modules.
• Has strong technical noledge in SQL & PL/SQL Programming and developing Adhoc-Reports by using SQL and Oracle Applications 11i tables.
• Translate business needs into technical deliverable solutions.
• Very good noledge on working with reporting tools like D2k Reports, XML Publisher Reports.
• Experienced in debugging, testing and deploying teh applications designed and developed interactive GUI screens and reports using oracle forms/reports.
• Expert in troubleshooting and fixing teh bugs, creation of SR with Oracle Support, obtaining patches from oracle support and applying patches with coordination of Apps DBA.
• Experienced in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), User Training Documents, test procedures document preparation and CRP.
• Strong programming experience in creating Procedures, API, Packages, Functions, Triggers and other database objects using SQL, PL/SQL, UTL File, UNIX and Shell scripts etc.
• Also experienced in fine-tuning code for better performance using EXPLAIN PLAN and SQL TRACE.
• Knowledge of complete Software Development Lifecycle including requirement analysis, design, development, implementation and testing.
• Experience in interacting with teh off-shore development team.
• Strong analytical, Inter-personal and communication skills. Good working experience with oracle applications end users.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications R12, 11i.

Operating Systems: HP UNIX, Windows 7/XP/2000/NT, MS-DOS

Languages: C, C++,Unix Shell Scripting, PL/SQL

RDBMS: Oracle 10g, 9i.

Tools: Toad, SQL*PLUS, SQL*Loader

Development Tools: Developer 2000, XML Publisher, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i, OA Framework.

Methodology: Oracle Application Implementation (AIM) methodologies

Oracle Financial Modules: Account Receivables, Accounts Payables, Purchasing, General Ledger.

Oracle Manufacturing Modules: Order Management, Inventory.

PROFESSIONAL EXPERIENCE:

Confidential, Ridge Field Park, NJ

Oracle Techno-Functional Consultant

Responsibilities:

• Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
• Written an API for Converting teh Invoice Payments(AP) and was able to convert all teh Historical Invoice Payment History into Production.
• Responsible for converting teh entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
• Responsible for converting all teh Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Developed PL/SQL Procedures for Customer interface using TCA in (R12) Accounts Receivables according to Client Requirements.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Designed, developed and documented an Inbound interface for AP Invoices from windows based applications.
• Responsible for providing production support for Account payables (AP).
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Responsible for running teh Open Interface to import data from OM interface tables into teh base tables.
• Involved in importing data from legacy system to Oracle Application by interfacing like Auto Invoice, Customer Interface, etc.
• Designed, developed and documented Project Accounting conversion of Projects, Tasks, Expenditure types using oracle provided API
• Involved in Implementation of iProcurement module and Customization of interfaces in this Module.
• Developed an interface program to load data from custom tables to interface tables and tan created journals into Oracle General Ledger as per business requirements.
• Creating staging tables required for loading teh legacy data and loading teh staging tables with teh legacy data using SQL Loader.
• Developed a PL/SQL program, which reconciles teh Reply Bank file data (Lockbox) and calls Receipt API to reverse teh receipts for which credit card status is declined.
• Created a Report for End Users to get teh vendor and its site information.
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR).
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.

Environment: - Oracle Applications 11.5.10, Release 12.1.3 (AP/AR/GL/Order Management, Inventory, Reports 10g/9i/6i, SQL, SQL*Loader, TOAD, XML Publisher, UNIX.

Confidential, San Roman, CA

Oracle Applications Technical Consultant

Responsibilities:

• Involved in database development by creating PL/SQL functions, procedures, triggers, packages and materialised views.
• Created procedures and SQL*Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data and Customer Bank data.
• Developed teh AP invoices Interface program, loaded teh data from flat file to teh staging table using SQL * Loader and did all teh necessary validations before loading into AP INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables and Calling Payable Import Program.
• Developed interfaces to load teh GL Data from legacy system into GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program.
• Involved in customer conversion from legacy system into Oracle accounts receivable (AR) by using Customer Interface.
• Involved in Development, Customization of teh OM Interface Applications.
• Worked on Purchase Order Import Interface, which creates teh Standard Purchase Orders by inserting Validated Purchasing Data into Interface Tables and calling Import Standard Purchase Order Program.
• Developed Purchase Order Receiving package, which includes validating teh Receiving Data, Inserting Data into Receiving Open Interface Tables and calling teh Receiving Transaction processor Concurrent program.
• Involved in Production support at different stages of teh project.
• Developed Various Error Correction forms in teh interface process. These forms are used in correcting teh error records in staging tables and interface tables.
• Developed Projects Custom reports like weekly labor, monthly labor, Cost at completion, Non labor Report and Work order Report.
• Created custom reports using XML/BI Publisher.
• Created Unix Shell scripts for automating teh execution process.
• Used Application Implementation Methodology (AIM) for documentation.

Environment: Oracle E-business Suite12.0.6, Oracle10g, AP, AR, INV, FA, OM, PO, XML/BI Publisher, Report Builder, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential, Virginia Beach, VA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Designed, Developed and Documented Supplier Conversion from Legacy system to destination system me.e., R12.
• Designed, Developed and Documented Employee as Supplier conversion from legacy system (11i and other systems) to R12.
• Designed, Developed and Documented Supplier Bank Conversion from Legacy Systems (11i and other systems) to R12.
• Designed, Developed and Documented Purchase Order inbound interface to upload teh Purchase Orders details from teh legacy to Oracle Applications base tables
• Extensively worked on conversions into Oracle AR, GL Balances import, PO by mapping teh data, writing oracle stored procedures, packages and oracle seeded packages. TEMPHas developed interfaces for transferring data from legacy to Oracle Apps.
• Worked on GL interfaces for balances Conversion, SQL, PL/SQL, stored procedures and packages.
• Worked on invoice conversions by designing, developing style sheets and generating XML files using Oracle PL/SQL, Oracle AR, and BI Publisher.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger GL.
• Worked on teh development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM.
• Developed New Reports and Customizations in XML Based reports using XML Publisher.
• Customized forms using CUSTOM.PLL file to meet teh specific requirements.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated teh Descriptive flex fields with Report flex field data.
• Experience in System Administration activities like Managing Concurrent Programs.

Environment: Oracle Applications 11.5.10, Release 12.1.3 (AP/AR/GL/Order Management, Inventory, Reports 10g/9i/6i, SQL, SQL*Loader, TOAD, XML Publisher, UNIX.

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Designed and implemented Approvals Management (AME) for purchase requisition approval to send approval notifications to special pre-approvers, chain of authority and post-approvers.
• Designed and implemented Approvals Management (AME) for requisition change order approval to send approval notifications to special pre-approvers, chain of authority and post-approvers.
• Developed custom discoverer reports like, Expense PO Details, Inventory PO Details.
• Developed Alerts like PO funds alert, Rejected Purchase requisitions alert, New cost center alert, New job code alert
• Customized purchase requisition approval notification by extending teh View Object to add additional fields.
• Designed and developed concurrent process to send reminder notifications for approval notifications (Purchase Requisition Approval, Absence Request, Time card approval, Expense report approval)
• Customized Purchase Order Print Program using XML Publisher.
• Designed and developed custom interface programs for orders to interface into Oracle applications base tables where teh data comes in XML/DAT format or from web portals.
• Designed and developed custom interface programs for items to interface into Oracle base tables where teh data comes in XML format.
• Designed and developed concurrent process to send Packing List and Commercial Invoice reports to CM via email as a pdf attachment.
• Developed RDF (XML) reports like Order Management report, Drop ship material transactions report, Physical Inventory Accuracy Analysis report, Physical Inventory Adjustments Report, Order Booking Report, and Item Category Accounts Report.
• Designed and implemented Approvals Management (AME) for Internal Requisitions approval to send approval notifications to special pre-approvers, chain of authority and post-approvers.
• Developed Billing Reports to chargeback teh customers by pulling information from OM and departure information on monthly basis where teh reports will be sent directly to financial analysts via email after teh report finishes running.
• Developed a Custom Interface to Update/Insert attributes on Items and Item Catalogs through Item Import.
• Wrote SQL*Loader script to migrate teh data from teh legacy system flat file to GL Staging table
• Wrote a PL/SQL procedures for validating teh data in GL staging table
• Populated teh GL interface table using a PL/SQL package
• Used GL Journal Import program to load teh GL base tables.
• Developed Custom Reports as per teh business functionality and requirements.

Environment: Oracle Applications R12, 11.5.10 ( Purchasing/ me-Procurement, OM, Inventory, Forms 10g/9i/6i, Reports 10g/9i/6i, SQL, SQL*Loader, TOAD, XML Publisher

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Involved in analyzing teh legacy data for conversion into Oracle, Data mapping was done with teh inputs from functional users and Business Analysts. Gaps for teh same were identified and rules created.
• Conversion of Customer billing, Customers account sites, customer account contacts was also implemented as a part of business requirement.
• Defined Pricing Attributes process to attach pricing attributes to agreements.
• Created Reports for Seeded Order Management reports execution based on requirement.
• Released holds using OE ORDER PUB API and adjusted line adjustments.
• Legacy data was loaded into pre staging tables and tan teh PL/SQL programming logic with different procedure and function calls was used to analyze and validate teh data and load into teh staging tables. Generated errors were handled with proper error logging.
• Developed Pl/SQL Programs for Customer Conversion.
• Developed reports in Oracle inventory for comparison of available and on-hand quantities in various lots.
• Created technical design for item conversion, Used standard Inventory Application Program Interfaces supplied by Oracle.
• Transferred GL Account Balances from legacy system.
• Created various business areas, user views, custom folders and joins for reporting in user edition.

Environment: Oracle Applications 11.5.9 Manufacturing, Order Management, INV, GL, AP, AR,QM, Windows 2000, Forms 6i, Reports 6i.

Confidential

Oracle Applications Developer

Responsibilities:

• Responsible for teh design, development and import of invoice information into Oracle Receivables.
• Developed custom PL/SQL conversion program for loading PO Vendors using Oracle Standard Vendor API
• Performed SQL tuning using Explain plan and tuning database with appropriate indexes.
• Maintaining concurrent manager and assigning priorities.
• Creating users & modifying teh privileges for users. Creating appropriate roles and assigning it to users.
• Loaded data into oracle tables using SQL*Loader.
• Used Order Import to import data into Order Entry/Shipping for processing.

Environment: Oracle Applications 11.0.3, SQL*Loader, Toad, Shell Scripts, Developer 2000, SQL, PL/SQL.