SUMMARY:

• Over 7+ years of IT experience in oracle applications E - Business Suite(EBS) 11i and R12 as an Oracle Applications Techno Functional Consultant.
• Primarily worked in General Ledger (GL), Receivables (AR), Payables (AP), Purchase Order (PO), iProcurement, iSupplier Order Management (OM), Project Accounting (PA), Advance Pricing, Service Contracts, Install Base, CRM, Inventory (INV), Work in Progress (WIP),), Oracle Approval Management(AME), Application Object Library (AOL), System Administrator.
• Comprehensive technical experience in Oracle Applications tools - Oracle Reports 6i&10g, Oracle Discoverer 10g, Oracle XML Publisher, Oracle PL/SQL and SQL, Interfaces, AOL (Application Object Library).
• Extensively worked on PO RECEIPTS Conversion
• Worked on creation of Purchase Order through API
• Good expertise in developing Reports, Interfaces, Conversions and Extensions (RICE) Components.
• Highly experienced in registering the Custom Forms, Reports, Custom tables and Custom Value Sets in Oracle Applications R12. Involved in Monitoring the Deploy activities to Test and Production environment
• Involved in Data Migration from Legacy Systems to Oracle standard tables.
• 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
• Experienced in Customization, Personalization of Oracle Reports 6i/10g
• Experienced in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and API’s.
• Worked on Oracle Learning Management(OLM)
• Experienced in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data into Oracle Applications using PL/SQL,SQL*Loader, UTL File, Unix Shell script’s.
• Extensive experience in working with SQL Queries and in creating database objects like Tables, Triggers and Views.
• Experienced in Customizing and developing Oracle Forms 6i/9i/10g/11g.
• Extensively worked on PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Implemented in Procedure to Pay (P2P) Order to cash(O2C) workflows.
• Experience in Discoverer & XML/BI Publisher reports and using various templates to publish the reports as per user requirements.
• Worked on the integration of Oracle e-Commerce Gateway(EDI gateway) with Oracle Applications.
• Developed XML reports in iProcurement module
• Developed Interfaces in iSupplier module related iSupplier User Bulk Registration API.
• Involved in tuning of PLSQL using Optimizers
• Implemented and provided support on Service Contracts and CRM modules
• Involved in enhancements and extensions of custom components in Service Contracts
• Expertise in System Administration activities like application user setup, defining concurrent programs, responsibilities, values sets, flex fields, registering menus, forms, and reports.
• Involved in providing analysis or document review comments on Business Requirement.
• Involved in transition activities for migrating developed /customized objects across Development /Stage /Production Instances using version control tools.
• Effective communication on unforeseen issues that might cause potential risks for the project, resolving issues in time, good coding techniques following best practices of process improvements and quality standards helped in achieving 100% customer delight in all the projects worked.

TECHNICAL SKILLS:

ERP/EBS: R12 (12.0.6, 12.0.4), 11i (11.5.10, 11.5.9, 11.5.8)

ERP Modules: OM (Order Management), INV (Inventory), GL (General Ledger) AP (Account Payables), AR (Account Receivables), PO (Purchasing), BOM (Bill of Materials), WIP (Work in Progress), Iprocurement (iProc), AOL (Application Object Library), System Administration

RDBMS: Oracle 10g/9i/8i

Middleware: SOA Suite 11g, BPEL, ESB, Human Task, Discoverer Reports

Tools: Oracle Forms 11g/10g/9i/6i, OracleReports11g/10g/9i/6i, SQL*PLUS, SQL*Loader, SQL Developer, PL/SQL Developer, TOAD, Discoverer 10g/4i,XML Publisher, BI Publisher

Programming Languages: SQL, PL/SQL, XML, Java, HTML, C, C++

Operating Systems: Windows XP/2000/98/95,WindowsNT,MS-DOS6.0/3.0,UNIX,LINUX

PROFESSIONAL EXPERIENCE:

Oracle Applications Technical Consultant

Confidential, Alpharetta, GA

Environment: Oracle Applications 11g, GL, AP, AR, OM, R12, SQL *Loader, BI/XML Publisher 10g, SQL, UNIX, PL/SQL, Java, Toad

Responsibilities:

• Worked on Extraction of data from General Ledger, SLA and AP,AR,CM,FA
• Extensively worked on iprocurement, isupplier, iexpenses, AP, PO modules
• Extensively worked on extraction of data from different modules and send them as a pipe delimited file to the France government
• Extensively worked on PO RECEIPTS Conversion
• Worked on creation of Purchase Order through API
• Translator - Software application that translates data into or out of a specific format or standard for processing by an ERP system.
• Worked on Form personalization
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs
• Involved in MD50 Analysis and prepared Technical Specification, Unit Test Case documents. Coding and Unit testing of Forms/Packages/Reports and other PL/SQL objects. Involved in review of other migrated Components.
• Worked on customization of Flat File Formats.
• Developed Interface for Shippable Items for orders and returns to Install Base via Inventory
• Worked on Inbound and Outbound Interface on Install Base module
• Worked on Performance tuning of the Codes developed
• Involved in the defining of Code Conversions
• In these seen in Onsite Offshore Model Projects, Mitigated risks & on timely manner raised flag to next level leads/managers on project related issues for smooth delivery of the project deliverables without any major customer escalations.
• Implemented and provided support on Service Contracts and CRM modules
• Designed and developed Auto Invoice Import Program to create invoices from the legacy system into the Oracle Receivables Base Tables.
• Create Advance Shipment Notice and Advanced Shipment Billing Notice
• Worked on Inbound interfaces in Account Receivable Module
• Extensively worked on OE ORDER PUB API for process order
• Developed XML Publisher and Discoverer Reports in AR,OM Modules
• Worked on Shipping and Pick Slip Report
• Involved in the Sales Orders conversion in OM
• Customization and development of reports in OM
• Developed large number of XML publisher reports in OM

Oracle Apps Techno Functional Consultant

Confidential, Austin, TX

Environment: Oracle Applications 11g, R12, SQL *Loader, BI/XML Publisher 10g, SQL, UNIX, PL/SQL, Java,Toad

Responsibilities:

• Oracle Applications Technical Developer to design, develop, implement Oracle Reports in Oracle Applications 11i(SCM, CRM, OAM, FS, Reports and Forms), R12.
• Provide ERP Application support by handling day-to-day issues
• Provide bug fixes to resolve these issues.
• Collection, Analysis and consolidation of user requirements to technical documents.
• Coordinate software system testing to ensure specifications are met.
• Develop reports using XML/BI publisher and Oracle Reports 10g.
• Develop custom forms using Oracle Forms 10g.
• Create custom tables, views and materialized views.
• Develop PL/SQL packages, procedures and functions.
• Responsible for writing queries and tuning of queries.
• Write UNIX Shell scripts for coping and moving files to and from the server.
• XML/BI Publisher / Reports Builder / Forms:
• Developed reports on AP, AR, OM, PO, INV,WSH and GL modules using Reports 10 g, XML/BI Publisher and Custom Packages.
• Creating Technical Design document for Oracle Report to fetch information across Projects Module, Order Management, Account Receivables and General Ledger and developed the report(110 Column report).
• Modified a complex invoice report which imports guardian invoice data into oracle, generate invoice and email it to customers.
• Modified oracle reports from plain text output to PDF format using XML/BI Publisher
• Created data definition template to generated PDF report.
• Created Complex Matrix reports in XML/BI Publisher
• Responsible for Technical design documentation of the reports
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen Confidential the template level
• Worked on Formula Columns, Summary Columns and Placeholder Columns for developing the reports using Reports 10g.
• Created complex templates, using Sub templates, Dynamic images, complex charts, dynamic parameters and Dynamic columns to produce the output in PDF and EXCEL formats.
• Personalized form to enforce new terms and validations on Sales Orders form.
• Developing UNIX Shell Script to migrating code between instances.
• Resolved issues with Requisition, Purchase Orders and Sales Orders
• Pushed Sales Orders for invoicing by closing them while the lines are stuck in workflow process.
• Modified guardian data after import in oracle but before invoicing to customer.
• Imported users into CRM to assign any group. User can receives notification when a ticket is created for the group.
• Resolved iExpense report of the user by correcting the approval list generated by AME.
• Resolved the issues with requisition in iProcurement. Fixed approval lists generated by AME.
• Pushed sales order in Oracle to Open Air by calling Open Air Integration request set program.
• Worked on Cost Center issues.
• Worked on GL Daily Rates stuck in interface table not letting conversion rates to hit base tables.
• Fixed the issues with Workflow on SO lines and PO lines when SO lines are back ordered.
• Reprocessed failed EDI transmissions.
• AME Approval Manager.
• Performed mass updates to buyers in purchasing.

Oracle Apps Techno Functional Consultant

Confidential, Ontario, CA

Environment: Oracle Applications 11g, R12, SQL Developer, SQL *Loader, BI/XML Publisher 10g, SQL, UNIX, PL/SQL, Java, Toad

Responsibilities:

• Wrote scripts in PL/SQL to download data into text files from various tables using DBMS UTL file package and procedures.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• 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.
• 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.
• Created new concurrent request set and scheduled the Order Import interface program to run periodically
• Development of Oracle Order Management Inbound interface to load massive amount of Open Purchase Orders Programmatically by running user friendly concurrent programs.
• Created a PL/SQL package to consolidate multiple invoices (orders) to print on a single invoice based on the PO number in order to mimic the original customer PO.
• Responsible for converting all the PO vendors, vendor sites and vendor contacts into Production.
• Wrote CV40, MD50, MD70 documents, design and develop conversion routines, staging tables, PL/SQL API’s for
• Transaction Import
• Invoice Conversion
• Converting Suppliers, Supplier sites, Open Purchase Orders (PO)
• Performed Extensive Application Tuning for order to cash business process.
• Migrated custom value sets, DFFs and packages from 11i to R12. This involved modification of code to include the new R12 tables
• Developed Order Management, Inventory, Receivables, Shipping, Warehouse Management, Pricing queries to compare summary information of the standard and custom reports
• Designed and developed ad-hoc Oracle Discoverer workbooks and reports and also trained the End Users.
• Created templates for seeded oracle report such as Customer Invoice, Purchase order, Request for quotation, Dunning letter.
• Created Complex Matrix reports in XML/BI Publisher
• Developed XML template for invoice report using XML/BI Publisher
• Created output format in XML, new templates for XML Publisher to display the reports in client requirement format.
• Collection, analysis and consolidation of users reporting requirements.
• Created Business Area’s and Custom Folders in Discoverer Admin version.
• Utilized FND REQUEST API to submit concurrent Program from Oracle Report after Report Trigger.
• Developed several new forms using TEMPLATE.fmb & Customized standard forms through custom.pll.
• Unit & System testing for the developed components.
• UNIX shell scripting to move the files between interface directories.
• Creating AIM Documentation like MD50, MD70 for Functional and Technical Documentation for the projects.

Oracle Apps Technical Consultant

Confidential, CHICAGO, ILLINOIS

Environment: Oracle Applications 10g, R12, SQL Developer, SQL *Loader, BI/XML Publisher 10g, Reports Developer, SQL, UNIX, PL/SQL, Java, Toad

Responsibilities:

• Developed Custom Interface to import vendor’s information from legacy system to Oracle Applications.
• Handling multiple projects with multiple clients.
• Involved in development of reports based on business requirements and registered them in Oracle applications.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Worked on AP Supplier Invoice Import interface to upload the Invoice data into Oracle apps Database Tables.
• Developed UNIX shell scripts to load data through external tables.
• Customized seeded OTL workflow for Employees (HXCEMP).
• Used OTL API to load legacy time entry into OTL.
• Customized Timecard Layouts for Projects and Purchasing.
• Performed the unit testing for the code and migrated the files.
• Involved in the development of technical documentations, Release notes of reports and interfaces.
• Development and customization of reports based on Customer requirements.
• Extensively worked in tuning the SQL queries using Explain Plan, Tkprof, SQL*Trace.
• Involved in Interface designing and Documentation and implementation of these as per AIM.
• Developed OPM and Discrete parts Label for work order completions triggered through form personalization with BAR CODE on the labels.
• Developed a custom 3PL form used for both Inbound and Outbound Shipping. Custom form will be able to update both Sales Order/Deliveries and Purchase Orders.
• Developed and customized several Forms Personalization.
• Developed time card weekly report using bursting.
• Developed reports for compliance and analysis certifications.
• Developed various Business and ad-hoc Reports.

Oracle Applications Technical Consultant

Confidential, Chesterfield, MO

Environment: Oracle Applications 10g, R12, SQL Developer, SQL *Loader, Reports 9i, BI/XML Publisher 10g, Reports Developer, SQL, UNIX, PL/SQL, Java, Toad

Responsibilities:

• Involved in Importing the Order Management data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program.
• Designed and developed a program to convert Bill Rate Schedules of Project Accounting (PA).
• Experience in importing requisitions from legacy system to Oracle Purchasing through Requisition Open Interface (PO).
• Expertise in Creating and managing customers Using TCA (Trading Community Architecture) in AR module.
• Worked on Auto Invoice Conversion (AR) Program to validate, load credit memos, debit memos and invoices from legacy system.
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Followed MD50 functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.
• Created updated and closed several TARs to solve issues related to Order Management Production problems.
• Extensively worked on Tuning different views using EXPLAIN PLAN, SQL TRACE and TKPROF and increased their performance by creating functional Indexes.
• Solved high severity production issues raised by the users. Reports/BI (XML) Publisher/Discoverer:
• Developed and customized several reports in OM, INV, PO, AP and AR using Oracle Report Builder.
• Developed and Customized the following reports using reports 9i and XML/BI Publisher
• Extensively worked on Format Triggers, Formula Columns, Summary Columns and Placeholder Columns for developing the reports and prepared complex Data Model and Data Layout in Oracle Reports.
• Modified existing reports by creating additional joins. Designed and developed many reports by using lexical parameters in before, after parameters and before report triggers in reports 9i.
• Customized AR reports to display detail and summary information using Format Triggers in Report Builder.
• Extensively worked on XML/BI Publisher to develop various reports in OM, AR, AP, GL, INV and Shipping modules to meet the client requirements.
• Worked on creating BA’s, EUL, granting privileges in Discoverer Admin, creating and sharing the workbooks in Discoverer Desktop and Plus and running the reports using Discoverer Viewer.
• Used Oracle Discoverer to design the end user layer as per the client specifications and involved in the creation and scheduling of the workbooks and also defined the hierarchies.
• Developed and customized the Ad-hoc reports based on the Mark-ups provided by the end users and exported the worksheets into Excel and HTML format.

Oracle Applications Technical Consultant

Confidential

Environment: Oracle Applications 11.5.10, R12, Discoverer 10g, SQL Developer, SQL *Loader, BI/XML Publisher 10g, Reports Developer, SQL, UNIX, PL/SQL, Java, Toad

Responsibilities:

• A Migration and Customization Project from 11.0.3 to 11i Oracle Applications being developed for Confidential .
• Confidential intends to migrate their existing Oracle Application from 11.0.3 to 11.5.10 to take the advantage of new Oracle applications features. It also involves customizations of some existing reports and development of some new interfaces to suit their business.
• Involved in migrating and new development of Reports and Forms in Confidential related Oracle Application Modules.
• Analysis of the specifications/requirements provided by the client. Understanding of the process flows, Confidential specifications, ERP Upgrade and Consolidation Methodology and Individual Customization Documents
• Upgrading custom objects, messages etc. Registrations of AOL objects. Development of New Customization Reports and Forms. Migration of Reports/Forms/Packages from Oracle apps of 11.0.3 to 11.5.10.
• Preparing the Change document and Test checklist. Unit testing of the Packages/Function/Procedures and other objects developed.
• Involved in doing Peer Review of other migrated Components.
• Provided Post Implementation Support which involved Bug Fixing, Performance Tuning and Enhancements.
• Extensively used AOL and System Administrator modules for Creation of various Concurrent programs, Request sets, Value-sets and Descriptive flex fields, request groups for reports and concurrent requests.
• Pack Slip Report Customization (RDF to XML Publisher)
• Developing Custom queries and folders in Custom Business Area using Discoverer 10g Administrator