SUMMARY

• Having 9 years of experience as an Oracle applications (E - Business Suite) consultant, technical developer with expertise in Order Management (OM), Purchase Order (PO), Oracle Inventory (INV), shipping (WSH), General ledger (GL), Account Receivables (AR), Account Payable (AP), Cash Management, Fixed Assets(FA), CRM(Service Contracts, Install Base).
• Worked on Implentation, Support, Upgradation projects and having experience in AIM methodology.
• Expertise to develope RICEW (Reports, Interfaces, Conversions, Extensions and Workflows) components.
• Good exposure in Order to Cash (O2C) and Procure to Pay (P2P) Business flows.
• Expertise in Design/Development of Interfaces using Oracle opens Interfaces and Oracle Public API’s.
• Excellent in Data conversion/integrations from Legacy systems and external systems into Oracle Applications using PL/SQL, SQL*Loader etc.
• Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Good exposure in BI Publisher, which includes report development objects like data templates and RTF’s.
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Advanced PL/SQL data types like Record Type, Table Type, Bulk Collect and SQL * Loader scripts.
• In-Depth knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import etc.
• Solid Knowledge and understanding of AOL/FND.
• Used Trading Community Architecture (TCA) APIs to create/Update Parties and Relationships.
• Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD50, MD70 documents.
• Worked on Performance Tuning to increase the performance of Custom concurrent programs.
• Experience of Oracle Multi-Org and Multi-Currency
• Experienced in Customization of Forms and Forms Personalization.
• Expertise working with Oracle 7.x/8.x/9i/10g, Developer 2000, PL/SQL, Forms 6i/9i/10g, Reports 6i/9i/10g, SQL * Loader, Discoverer 3.x/4.x/10g and XML/BI publisher 5.6.2.
• Experienced with Performance Tuning, Optimizing SQL, PL/SQL scripts and with UNIX shell scripts
• Successful execution experience of On-Site and Off-Shore Model
• Strong communication skills with ability to manage expectations of Business and IT users. Possess good organizational, analytical and problem solving skill.

TECHNICAL SKILLS

ERP: Oracle applications 11i/R12 (Financials, SCM,CRM).

Development Tools: Oracle Reports 10g/9i/6i, Oracle Forms 10g/9i/6i/, Oracle WorkflowOracle Discoverer 10g/9i/4i, XML/BI Publisher, SQL*PLUS, SQL*LoaderToad, SQL Navigator

Databases: Oracle 10g/9i/8i, SQL Server, MS Access 2003 Languages C/C++, Java, PLSQL, XML, UNIX Scripts

Operating Systems: Windows XP/NT/2000/98/95, UNIX, LINUX

Documentation: AIM (MD50, MD70)

PROFESSIONAL EXPERIENCE

Confidential, Lehi, UT

Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed AR Customer Conversion to migrate Customers data from multiple Legacy Systems.
• Created Lookups for Validations of Legacy values mapping with Oracle Values(Brand and Market).
• Developed AR CDH Customer Data Hub related UDA conversion to populate Party Org Level and Site Level Values.
• Developed Credit Card Conversion to create customer Credit Card details.
• Have done functional setups for Customer conversion by defining values for Customer Class Code, Customer Types.
• Have done Functional and Technical designs for conversion documents of AR, OPM.
• Worked on Oracle Process Manufacturing Conversions Lot cost, Actual Cost and Standard Cost.
• Extensive experience in technical specification design, development, unit testing Oracle e-business suite of Applications.
• Implementation of business specific custom programs by writing PL/SQL stored procedures.
• Created Value Sets and Request Sets to call batch programs with same batch number.
• Worked extensively on PL/SQL Advanced Concepts Bulk Collect, Table Type, Record Types.
• Coordinating with Business Users on day to day activities to requirement clarifications and coordinatin with DBS for code migrations to various instances.

Environment: Oracle applications R12, HP Unix, Oracle Database 11g Oracle Receivables, Payables, General Ledger, SLA, OPM, Order Management, Purchasing, Inventory

Confidential, Seattle, WA

Oracle Apps Technical Consultant

Responsibilities:

• Developed the interface program for Accounts Payables given in the flat file and loading the data from flat file to the staging table using SQL * Loader and did all the necessary validations by developing PLSQL procedure before loading into oracle Standard Interface tables Ap Invoice Interface, Ap Invoice Lines Interface.
• Developed PL SQL procedure for Auto Invoice Conversion Program to validate, and load Invoices data into interface tables from staging table.
• Developed AP, AR and OM XML/BI Publisher reports. Created Data templates, Data definition in XML Publisher Administrator.
• Extensive experience in technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.
• Worked on various bug fixing activities during System Integration Testing.
• Worked on GL Outbound Interfaces, extract all the journal entries from EBS modules and send it to the Legacy system.
• Customizations done in Order Import Interface, PO outbound interface and Enhancements in PO.
• Implementation of business specific custom programs by writing PL/SQL stored procedures.
• Have done Form personalization in Order Header form to control Customer having same contract number.
• Coordinating with offshore team on day to day activities to code migrations to various instances.

Environment: Oracle applications 11i and R12, HP Unix, Oracle Database 10g/8i, Oracle Receivables, Payables, General Ledger, Forms,Reports 6i,Discoverer 10g, Xml Publisher 5.6.3, Unix, Shell Scripts .

Confidential, CA

Oracle Apps Technical Consultant

Responsibilities:

• Developed the interface program for Accounts Payables given in the flat file and loading the data from flat file to the staging table using SQL * Loader and did all the necessary validations by developing PLSQL procedure before loading into oracle Standard Interface tables Ap Invoice Interface, Ap Invoice Lines Interface.
• Developed PL SQL procedure for Auto Invoice Conversion Program to validate, and load Invoices data into interface tables from staging table.
• Developed AP, AR and OM XML/BI Publisher reports. Created Data templates, Data definition in XML Publisher Administrator.
• Extensive experience in technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.
• Worked on various bug fixing activities during System Integration Testing.
• Worked on GL Outbound Interfaces, extract all the journal entries from EBS modules and send it to the Legacy system.
• Customizations done in Order Import Interface, PO outbound interface and Enhancements in PO.
• Implementation of business specific custom programs by writing PL/SQL stored procedures.
• Have done Form personalization in Order Header form to control Customer having same contract number.
• Coordinating with offshore team on day to day activities to code migrations to various instances.

Confidential, Torrance, CA

Oracle Apps Technical Consultant

Responsibilities:

• Implemented XML/BI Publisher Reports to the new operating units of Belarus and Kazakhstan.
• Created technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.
• Worked on Form Personalization of Shipping Transactions Form for Kazakhstan documents.
• Developed PL/SQL procedure to get XML tags tor Notify to shipement, Pick slip report, Bill of Lading Repsorts.
• Modified XML Generate program for Belarus, Kazakhstan, Macau Country Implementations.
• Created Data templates, Data definition and layout templates for reports.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Registered Concurrent Programs, Request Sets,including parameters based on the previously selected. Created new valuesets of different validation types.
• Implementation of business specific custom programs by writing PL/SQL stored procedures.
• Created Migration documents to implement developed componets in various Instances by coordinating with migration team.
• Interacted with business users to understand the requirements ontime.
• Worked with finance,SCM teams to understand the business functionalities.
• Developed PL/SQL scripts to load order data from external system to OM Interface tables and OE base tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL).
• Customized workflow in PO Top Approval process to control require reapprovals of standard PO’s.

Environment: Oracle applications 11i, HP Unix, Oracle Database 10g/8i, Order Management, Distribution Management, Oracle Receivables, Payables, General Ledger, Reports 6i, OPTIO Reports, Xml Publisher 5.6.3, Unix, Shell Scripts .

Confidential, Schaumburg,IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked on Order to Cash Cycle, from entering orders to move order stage followed by the ship confirm and updating the GL.
• Extensive experience in technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.
• Customized the Order Header level workflow, which will send a notifications to collectors when exceeded a threshold limit.
• Developed a custom report to review the reasons for Return Material Authorizations (RMAs), which shows the reason, items returned, order number and customer name for a given date range.
• Worked on Auto Invoice Conversion Program to validate, load Credit memos, Debit memos and Invoices from legacy system.
• Custom developed Order Management reports like bookings, shipments and backlog reports, service contracts detail report and inventory transaction report using XML Publisher to display in excel format.
• Setup Descriptive Flex Fields, Value sets for various components in OM, Inventory modules.
• Defining System Profile Options, Descriptive and Key Flex fields.
• Various ad-hoc SQL queries and bear SQL reports for taking business decisions were developed whenever requested by user.
• Requirements gathering for the Interface and custom programdevelopment through meetings with functional team and business users.
• Worked on Design and Development Requirements for various Confidential Legacy Financial applications.
• Worked on Separation Activities for Confidential and involved in coordinating and leading the activities for Confidential Solutions.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Analysis, Design and Development of MD70 technical documents based on MD50 functional documents and business requirements and documented in Doors.

Environment: Oracle applications 11i,R12, HP Unix, Oracle Database 10g/8i, Order Management, Oracle Receivables, Payables, BOM,WIP General Ledger, Developer 2000/6i, Xml Publisher, Unix, Shell Scripts .

Confidential, MA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed PL/SQL scripts to load order data from external system to OM Interface tables and OE base tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL).
• Conversion and customization of BOM, AR and OM modules. Bill of material (BOM) conversion; from legacy mainframe information to ORACLE 11i base tables. Designed and developed strategy to capture the legacy data and API to ORACLE database. Bom Bill of Mtls interface and Bom Inventory Components interface were populated during conversion and API inserts the information to Oracle base tables.
• Performed Extensive Application tuning for Order to Cash Business process
• Developed PL/SQL program to be used to create Ship Confirm with delivery details using shipping API
• 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.
• Created all items of supply for Item Master Organization to enable assigning them to different organizations.
• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system
• Developed XML reports using Oracle Report Builder 6i and integrated them with the application (based on the descriptive flex fields) to solve the client’s reporting needs.
• Worked extensively in Design & Development of extension forms with Forms 6i, to enhance the functionality as per user’s requirement
• 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.
• Developed new reports using Report Builder 6i and also customized seeded reports in order management module.
• Released holds using OE ORDER PUB API and adjusted line adjustments.
• Customized Pick slip, packing list Reports based on functional specification.
• Created Functional and Technical design documents (MD060, MD070) and test scripts.
• Implementation of business specific custom programs by writing PL/SQL stored procedures and UNIXscripting.
• Have done UAT/Post Go Live Testing for all business functionalities.
• Modified Asset details Report in XML Publisher.

Environment: Oracle applications R12, HP Unix, Oracle Database 10g, Order Management, Oracle Receivables, Payables, BOM, Inventory, General Ledger, Service Contracts, Developer 2000/6i, Xml Publisher, Unix, Shell Scripts.

Confidential, Carlsbad, CA

Oracle Applications Developer

Responsibilities:

• Involved in development of inbound interface custom package to validate and import order details data into Oracle Applications OM order interface tables like OE HEADERS IFACE ALL, OE LINES IFACE ALL, and OE ACTIONS IFACE ALL from external system. This Package involves calling Order Import process for loading the Order Headers and Lines.
• Defined Payment terms, Locations, Periods, Tolerances etc. Integrated Payment reconciliation information and Purchase Order information with AP.
• Developed PL/SQL program to be used to create Ship Confirm with delivery details using shipping API
• Designed and Developed Custom Pick Release process using standard Online Pick Release APIs.
• Worked on on-hand quantity interface to get the material transactions in Oracle Inventory (INV).
• Developed Pricing, Inventory, Shipping & Order related Reports using XML Publisher.
• Developed UNIX Shell scripts to run the interface program and to archive the data.
• Documented all my work in the form of MD70, MD120 documents and Unit testing scripts.
• Improved the performance of existing reports by performance tuning the SQL and PL/SQL scripts.
• Created data definitions and design templates for some simple custom reports for order and inventory control using Oracles XML Publisher.
• Registered new forms and also different concurrent programs for reports, PL/SQL packages, SQL loader Programs
• Performed the system administrator role by setting up the user privileges, Assigning Responsibilities, adding new concurrent requests, registering custom reports with applications so that they can be accessed from within the applications.

Environment: Oracle Apps R12, Oracle Apps 11.5.9, OM, INV, PO, AR, Oracle 8i, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, Shell Scripting, TOAD.

Confidential, Atlanta, GA

Oracle Applications Developer

Responsibilities:

• Involved in design, development of Financial Modules that includes General Ledger, Accounts Payable, Account Receivables, System Administration, Application Object Library (AOL) and used EDI Gateway.
• Developed interface programs to integrate Legacy System with the AR module to import customer information using the Customer Interface.
• Imported Legacy data from Customers into Account receivables (AR) using SQL*Loader and Customer Import program.
• In GL module created Set of Books by defining Value sets, Segments, security rules, cross validation rules, key flex field structure, Period types, Currencies and Accounting calendar.
• Importing data into applications and posting the Batches at regular intervals across all the sets of books, cross validation rules, historical and periodical exchange rates, and loaded budget organizations. All processes are automated as per requirement.
• Developed the interface program for Accounts Payables given in the flat file and loading the data from flat file to the staging table using SQL * Loader and did all the necessary validations before loading into Ap Invoice Interface, Ap Invoice Lines Interface that is the Oracle Standard Interface table.
• Developed flow charts to study the process flow of data in conversions, interfaces and API’s.
• Worked on Auto Invoice Conversion Program to validate, load Credit memos, Debit memos and Invoices from legacy system.
• Customized standard reports like Aging Report and Invoice in AR.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
• Developed interfaces to load the GL Data from legacy system into GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using Journal import concurrent program.
• Worked extensively in Design & Development of extension forms with Forms 6i, to enhance the functionality as per user’s requirement.
• Customized Reports, Flex fields and Registered with AOL.
• Excellent understanding of AOL & Sys Admin, created users and attached responsibilities, defined request sets and managed concurrent programs.
• Worked with Performance Tuning tools like Explain Plan and TKPROF to improve the performance of various developed custom PL/SQL Packages.
• Converted existing RDF reports to XML Publisher. Created Data templates, Data definition and layout templates for all the converted reports.
• Designed and developed Business Areas in Discoverer EUL as per the business requirement.
• Involved in developing Technical & Functional Documentation MD50 & MD70 using AIM methodology.

Environment: Oracle applications 11i, HP Unix, Oracle Database 10g/8i, Oracle Receivables, Payables, General Ledger, Forms 6i, Reports 6i, Unix, Shell Scripts .

Confidential

Oracle Technical Consultant

Responsibilities:

• Conversion and reconciliation of Legacy AP Invoices and Payments into Oracle Applications.
• Designed and developed Payables interface import program and interface tables to load invoices from the legacy systems into the oracle payables base tables.
• Designed and developed Conversion scripts to convert data from 11. systems for AR Module. For the Customer related data, Scripts were developed to use the standard Customer Interface program and includes converting Customers, Addresses, Sites, Contacts, Phones, Profiles, and Profile Amounts etc.
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Customer setup, invoice class, bank accounts, and receipts. System options defined. Setup task included defining the payment terms and transaction types, manual invoice entry (invoice, debit memo, credit memo).
• Also defined auto accounting, rules for Auto invoicing from Order Entry-Interface, tax set up and customer definition.
• Worked with Oracle Workflow for purchasing.
• Designed and developed complete Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Designed and developed custom auto-hold release interface program, to release the holds. Used PL/SQL block and body specifications for releasing hold and update the tables
• Developed custom reports (such as Invoice Audit, Duplicate Invoice, APX-sheet, Invoice aging, Stopped Payment, Payment Registered, etc.).
• Imported Requisition Details (Requisition Import) using PL/SQL UTL file package wrote interface program to import Requisitions into the Interface tables.
• Used AOL features and Reports extensively while working on Invoice aging reports, stopped payment report, Invoice audit report. Registered these reports as Concurrent program in AOL and modified request group to add the programs.
• Member of the Production support team and assisted in solving open issues.
• Modified GL reports and designed, developed and tested custom reports as per users’ requirements
• Used PL/SQL for validating the data from legacy system to interface tables. Run journal import to load the data into Oracle application tables.

Environment: Oracle Applications R12, 11.5.10, Oracle 10g/9i, OM, INV, GL, PO, AP, AR, CE & AOL, Forms 6i/4.5 and Reports 6i/2.5, Workflow 2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, SQL Navigator, Win NT and UNIX

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Customization of Standard Consolidated OM/INV/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 Created Business Areas and built Discoverer Workbooks using Discoverer 4i.
• 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.

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

Confidential

Oracle Technical Consultant

Responsibilities:

• Development and customizations of Oracle Reports Inventory, OM, PO, AP.
• Performed conversions of AP closed invoices and payments using SQL*Loader to load legacy closed invoices data into staging tables and PL/SQL programs to validate and import data into Oracle Payables standard tables.
• Defined concurrent programs, executables, Creation of responsibilities, request groups, values sets, and functions in System Administration & AOL.
• Creating value sets in various modules of the application.
• Developed Control Files for Conversions and validation programs for interfaces.

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