SUMMARY

• Over 8+ years of experience as an Oracle Applications Consultant in implementation and upgrade and customization of Oracle e - Business Suite Applications which included design, development, maintenance and support.
• Extensive experience of various oracle modules in Supply Chain Modules(SCM) (like OM-Order Management, INV-Inventory, PO-Purchasing) Oracle financials modules like (GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables), Manufacturing Modules such as (BOM-Bill of Materials, WIP-Work in Progress)
• Excellent development skills in RICEW components (Reports, Interfaces, Conversions and Form Personalization) in teh domain of Oracle E-Business Suite Essentials.
• Extensive knowledge of Business Processes across teh E- Business Suite, Order to Cash (OTC) and Procure to Pay (P2P)
• Expert in Trading Community Architecture (TCA) and involved in importing customers into Oracle AR using TCA API’s
• Good Understanding of teh Multi-org
• Experience in developing variousCustom reports, Customized existing reports according to teh functional specifications usingReports 10g and XML publisher
• Extensively worked on personalization and extensions of self-service pages wif iProcurement and iSupplier modules
• Strong coding experience in PL/SQL development using Packages, Procedures, Stored Procedures wif, Functions, Triggers and UNIX Shell Scripting
• Extensive experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader and UTL File
• Solid working knowledge in analyzing and understanding teh source/existing/legacy system business functionality and preparing teh functional and Technical Design Documents using AIM Methodologies
• Successfully completed various R12-upgradations/re-implementations and proficient in R12 up-gradation technical/functional challenges in financials modules
• Experience on WEB-ADI for loading bulk data into tables wif validations
• Experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration
• Tuned SQL queries and performed refinement of teh database design leading to significant improvement in system response time and efficiency
• Hands-on experience in Implementation, Testing, end-user training, post-implementation support and customization

TECHNICAL SKILLS

Oracle ERP Applications: Oracle Applications R11i,R12.2.x

Languages: C,SQL,PL/SQL, Java, JSP,HTML,CSS,Java Script

Database Tools: SQL *PLUS, SQL *LOADER,TOAD,SQL Developer, Microsoft SQL Server

Oracle Tools: Oracle Jdeveloper,BI Publisher (XML Publisher) 10g,OAF,Forms 10g,Reports 10g

Other Tools And Utilities: Eclipse, Putty, WinSCP

Operating System: Windows,Linux

PROFESSIONAL EXPERIENCE

Confidential, Orlando, Florida

Oracle Techno - Functional Consultant

Responsibilities:

• 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
• Involved in Requirement gathering, Analysis and Client interaction
• Worked on teh requisitions and PO conversions using open interface tables
• Worked on Banks conversion, creating banks, branches, locations and accounts using standard API’s
• Worked on AR receipts conversion using standard API
• Worked on Item conversion using standard open interface table
• Involved in development of TCA Customer Conversion program which includes data validation and API calls
• Created SQL*Loader scripts and External tables to load teh data from flat files and validated teh data wif PL/SQL procedures
• Developed BI reports using Data Templates, designed several RTF templates
• Developed a form using OAF as per teh business requirement
• Worked on TCA (Trading Community Architecture model)
• Developed several XML publisher reports using RTF/Excel/eText templates and bursting feature in financial modules
• Worked on journal import for importing journals from different sources
• Developed SLA Variance report to compare SLA and GL balances
• Developed PL/SQL procedures, functions, packages, triggers to validate teh data and insert teh data into Oracle Standard interface tables
• Coordinated wif teh offshore support team in resolving issues
• Developed design and implementation documents and user-documentation
• Developed test cases and test scripts as a part of unit testing
• Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields.
• Documented Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40).

Environment: Oracle Applications R12, OAF, SQL*Plus, PL/SQL, TOAD, and RICEW objects, SQL*Loader

Confidential, Atlanta, GA

Oracle Apps Techno - Functional Consultant

Responsibilities:

• Worked wif P2P (Procure to pay) business flow including modules PO (purchase order), AP (accounts payable) and GL (general ledger)
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs
• Designed and developed complete Vendor Interface for import of vendor information into teh system
• Developed variousCustom reports, Customized existing reports according to teh functional specifications usingReports 10g and XML publisher
• Customized an existing OAF page as per teh business requirement
• Involved in conversion process right from design, pre-conversion/data-cleansing, reconciliation of converted data to deployment of conversion packages
• Customization of iProcurement approval hierarchy to reflect business requirement
• Designed interfaces, conversions along wif AIM (Application Implementation Methodology) documentations
• Involved in HR and Payroll conversion
• Involved in payoll production support activities like getting teh environment ready for Oncycle and Offcycle Payroll runs and provide support till transfer to GL process
• Worked on Importing Asset Information into Oracle Assets Using Mass Additions in Fixed Assets (FA)
• Defined Fixed Asset categories, calendar periods, System Controls, Book Controls (corporate books), Prorate Convention and Fiscal years and calendar
• Worked on SQL*Loader to load data from flat files
• Worked on SLA (Sub-Ledger Accounting) process
• Developed teh WEB ADI to load bulk data into staging table using validation as per teh requirement
• Developed XML Publisher report for Sub-Ledger Accounting
• Developed XML Publisher report for GL Account Analysis
• Extensively used AOL and System Administrator modules for Creation of users and creation of roles and responsibilities, set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields registered concurrent programs, request groups for reports and concurrent requests
• Gathering requirements, creating technical design and specifications documents and unit test plans

Environment: Applications (R12), PL/SQL, SQL *loader, Oracle Reports, XML Publisher, OAF, TOAD, Windows XP

Confidential, Ft. Lauderdale, FL

Oracle Apps Techno - Functional Consultant

Responsibilities:

• Extensively utilized teh Application Object Library to register SQL*Loader programs, PL/SQL procedures, Forms and reports. In addition, also used teh System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets.
• Involved in designing, developing interfaces, customizing user requests and implementation change requests. During these processes interacted wif end users and implemented their requirements into teh Application Systems
• Built Price Engine for Ebrary based on qualifiers, modifiers and pricing attributes factor list
• Worked in resolving teh technical related issues related to OTC cycle
• Involved in building teh packages for order import and Post-Invoice programs daily between Ebrary and ProQuest
• Designed new royalty reports which are used every quarter for making teh payments to publisher using XML/BI Publisher
• Developed custom reports in Oracle General Ledger that gives a listing of all accounts balances according to teh financial calendar
• Defined Mapping Sets and Account Derivation Rules in Sub ledger Accounting (SLA) Developed Functions to change accounts in SLA
• Involved wif study of existing system, preparing teh Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables
• Worked on enhancements to existing Auto lockbox to facilitate new commitment changes
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import teh Open AR Transactions (Invoices) from legacy system to Oracle interface tables. Used Auto Invoice Master Program to load teh interface table data into Oracle AR base tables

Environment: Oracle Application R12, SQL*Loader Forms10g, Reports10g, Oracle EBS,XML Publisher and Linux

Confidential, Schenectady, NY

Oracle Apps Technical Consultant

Responsibilities:

• Created database objects such as tables, views, indexes, sequences, PL/SQL stored procedures, functions and packages
• Registration of Reports, Forms and PL/SQL Packages wif Oracle Apps Developments of database objects
• Worked on Employee conversion using Standard APIs
• Designed and developed Conversion scripts for AR Module, for teh Customer related data, Scripts were developed to use teh standard Customer Interface program and includes converting Customers, Addresses, Sites, Contacts, Phones, Profiles, Profile Amounts etc
• Extensively worked BI Publisher to create reports to satisfy teh user requirements
• Worked on Application Object Library, defined Executables, Concurrent Programs, Request Groups, Users, and Responsibilities.
• Performed Various System Administrator activities like defining a concurrent program, creating users, creating menus, creating responsibilities
• Developed multiple outbound interfaces for sendingpayrolland employee information
• Proficient wif Subject areas in preparing Adhoc report wif OTBI for Core-HR,Payroll
• Wrote complex SQL queries to retrieve information from teh databases depending on teh requirement
• Coordinated wif teh offshore support team in resolving issues
• Using SQL*Loader loaded teh data into staging table, Developed PL/SQL packages to validate teh data and load into interface tables
• Generated sequences that can be shared by multiple users to generate unique integers
• Fine tuned SQL and PL/SQL scripts to improve performance and reduce overhead
• Involved in Unit level testing

Environment: Oracle EBS, SQL, PL/SQL, TOAD, XML Publisher, SQL*Loader

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in teh customization of reports as per teh clients requirement
• Developed database objects like table, Constraints, Views, Synonyms, Cursors, PL/SQL Procedures, Functions, Packages to validate teh data and insert teh validate data into Oracle Standard tables
• Created PL/SQL program units to include DML, DDL statements using dynamic SQL
• Wrote complex queries involving multiple-joins to generate user reports
• Creation of value-sets, registering teh reports and running teh reports using teh System Administrator Module
• Developed row level and statement level triggers for auditing tables in PL/SQL
• Defined Executables, Concurrent Programs, Request Groups, Users, and Responsibilities
• Worked on tuning SQL queries and performed refinement of teh database design
• Involved in preparation of Test Cases and Test Scripts

Environment: Oracle, SQL, PL/SQL, SQL*Plus, PL/SQL Developer, TOAD