SUMMARY

• Around 8 Years of experience in Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of Oracle Applications 11i and R12
• Domain expertise as Techno Functional Consultant - Supply Chain Management (SCM) / Financials
• Excellent technical development skills in developing Reports, Interfaces, Conversions and Extensions in teh domain of Oracle E-Business Suite (EBS) using SQL, PL/SQL and Developer 6i/9i/10g
• Supply Chain Management - Purchasing (PO), Inventory (INV), Order Management (OM)
• Financials - Receivables (AR), Payables (AP), General Ledger (GL)
• Good exposure to Oracle Project Accounting (PA)
• Excellent noledge of System Administration, Application Object Library (AOL), Oracle APIs and Open Interfaces
• Used Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in teh process of development
• Extensive experience in developing Interfaces and Conversion Programs to import data from various sources into Oracle Applications
• Good experience in AIM methodology for implementing Oracle Applications. Familiar with all teh Standard Documents (MD 50, MD 70, MD 120, CV 40, CV 60)
• Good noledge in Procure To Pay (P2P) and Order To Cash (O2C) cycles
• Good noledge in Trading Community Architecture (TCA)
• Hands on experience with Oracle Discoverer which includes report development, Discoverer Administration, configuring Discoverer and End User Layer (EUL)
• Experience in creating XML Publisher reports and using various templates to publish teh reports as per user requirements
• Good noledge in Workflow and OA Framework
• Good programming skills in SQL and PL/SQL
• Proficiency in writing PL/SQL Stored Procedures, Functions, Packages, Cursors, Database Triggers and SQL * Loader scripts, UNIX Shell Scripts
• Extensively worked in Oracle Front-end programming and Back-end development using tools like PL/SQL, SQL*Plus, Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g.
• Exposure to ERP Application Testing (Manual/Automation)
• Good noledge in manual testing and automation testing tools like WinRunner, QTP, Load Runner, Quality Centre and Rational Quality Manager
• Experienced on Project go-live and post-implementation support
• Performed requirement study, FIT-gap analysis, solution designing, development, tuning, and user testing and production support of RICE (Reports, Interfaces, Conversions and Extensions) elements with AIM documentation
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self motivated to work independently with excellent communication skills
• Ability to work under pressure, meet deadlines and work extra hours when needed

TECHNICAL SKILLS

ERP: Oracle Applications EBS 11i, R12

GUI: D2K (Forms 6i/9i/10g, Reports 6i/9i/10g)

Tools: Used SQL * Plus, SQL* Loader, TOAD, Discoverer and XML Publisher

Other Tools: Oracle Workflow builder, JDeveloper

Languages: SQL, PL/SQL

Database: Oracle 8i, 9i, 10g

Operating Systems: Windows, UNIX, LINUX

Testing Tools: QTP, Load Runner, Quality Centre, Rational Quality Manager

PROFESSIONAL EXPERIENCE

Sr. Oracle Apps Techno Functional Consultant

Confidential, Jamesburg, NJ

Environment: Oracle Applications 11.5.9 (PO, INV, OM, GL, AP, AR, CM), Procure To Pay (P2P), Order To Cash (O2C), TCA, BI Publisher, Discoverer, Oracle 10g, Reports 10g, Forms 10g, Custom.pll, Forms Personalization, Unix, TOAD, SQL*Loader, and PL/SQL, PVCS, PPM (ITG)

Responsibilities:

• Preparation of technical specifications from teh functional specifications received from teh functional team, technical design using AIM methodology
• Writing custom packages to develop conversion programs
• Designing new reports as per teh requirement
• Converted standard reports into BI Publisher Reports
• Developing conversion programs and reports dat are registered as concurrent programs and which are run from SRS form
• Worked on different objects in Oracle Payables and Receivables as a part of production support
• Report to show all teh Booked & Pending sales orders
• Designed and developed Interface programs to load Vendors in Payables using Supplier Open Interface
• Customized Purchase Order Detail report to list all purchase orders from a particular vendors over a specific period of times
• Customized a report to compare teh on - hand quantity cost v/s teh physical count cost
• Designed and developed PO requisition interface to load PO requisitions from teh legacy System into purchasing interface tables
• Developed report to show teh rejected and returned quantities and teh days between teh rejected and returned quantities to teh vendor
• Developed rdf report to show all teh pending purchase orders
• Developed supplier analysis report showing no of PO-s raised on a supplier with closed, open for receiving, open for invoicing information
• Developed rdf report to display inactive items dat exist on active POs by buyer and by organization
• Developed report to show all teh payables cleared invoices sorted by invoice groups
• Form customization to zoom from teh PO form to teh supplier form using personalization feature
• Monitoring teh performance related issues using Explain plan, SQL Trace and TKPROF utility
• Created ldts for valuesets, Concurrent programs, request groups and request sets
• Maintained teh versions of database objects using PVCS
• Resolved production tickets based on priority and pushed them for testing using ITG
• Involved in unit testing and fixing teh problem dat occurred in UAT (User Acceptance Testing)
• Responsible for custom program maintenance during teh production support

Sr. Oracle Apps Technical Consultant

Confidential, Brooklyn, NY

Environment: Oracle Applications 12.1.3 (GL, AP, AR, Project Accounting (PA), FA, PO, INV, OM, Costing, CM, Advanced Pricing), Procure To Pay (P2P), Order To Cash (O2C), TCA, BI Publisher, Discoverer, Oracle 10g, Reports 10g, Forms 10g, Custom.pll, Forms Personalization, Unix, TOAD, SQL*Loader, and PL/SQL, Rational Quality Manager

Responsibilities:

• Preparation of technical specifications from teh functional specifications received from teh functional team, technical design using AIM methodology
• Writing custom packages to develop conversion programs
• Designing new reports as per teh requirement
• Converted standard reports into BI Publisher Reports
• Developing conversion programs and reports dat are registered as concurrent programs and which are run from SRS form
• Customization and extension of forms
• RMA conversion to transfer all Return Orders and Lines from external Source to Oracle using Sales Order API
• Form customization to Customize teh Customer Site form to make a field mandatory for a specific org - id and optional for other org-ids
• Price list conversion
• Oracle Projects and tasks conversion
• Report to show all teh Booked & Pending sales orders
• Customer interface
• Involved in Design and Code reviews
• Involved in unit testing and fixing teh problem dat occurred in UAT (User Acceptance Testing)
• Supported teh CRPs, SIT and go-live activities
• Responsible for custom program maintenance during teh production support
• Monitoring teh performance related issues using Explain plan, SQL Trace and TKPROF utility
• Conducted Oracle applications System Administration duties including Defining users, Assigning Responsibilities and Defining Menus
• Involved in data validation and data reconciliation and tracked teh defects using Rational Quality Manager

Sr. Oracle Apps Technical Consultant

Confidential

Environment: Oracle Applications 12.1.1 (AP, AR, GL, FA, CM, PO, INV, OM, BOM, WIP), Procure To Pay (P2P), Order To Cash (O2C), TCA, Workflow Builder 2.6, Reports 6i, Forms 6i, Custom.pll, Forms Personalization, Discoverer, Oracle, Sun Solaris 2.6, TOAD, SQL*Loader, and PL/SQL

Responsibilities:

• Preparation of technical specifications from teh functional specifications received from teh functional team, technical design using AIM methodology
• Writing custom packages to develop conversion programs
• Development of interfaces
• Designing new reports as per teh requirement
• Developing conversion programs and reports dat are registered as concurrent programs and which are run from SRS form
• Customization and extension of forms
• Bank Payment Voucher
• Cash payment voucher
• Bank Receipt Voucher
• Cash Receipt voucher
• Prepared detailed documents for all customizations related to interfaces and reports
• Customized various reports in Accounts Payable according to customer requirements
• Custom extension to capture salesperson's expenses on each order (to zoom from OM form to enter date)
• Outbound interface of Cancelled Sales Orders
• Report to list all teh cancelled orders based on customer name
• API to apply hold on new orders
• Form customization to populate teh DFF in Order headers block based on teh salesperson Territory ID
• Conversion program to import OM Holds information from legacy system to Oracle Applications
• Order Approval form to enable teh user to approve each and every order to be imported into teh interface table
• Order Import interface to import orders from legacy system to Oracle Applications
• Involved in Design and Code reviews
• Involved in unit testing and fixing teh problem dat occurred in UAT (User Acceptance Testing)
• Supported teh CRPs, SIT and go - live activities
• Responsible for custom program maintenance during teh production support
• Tuned teh application report queries, other SQL queries to improve teh performance
• Used AOL & System Admin to register new reports, procedures, forms, functions, menus and created validation sets, request sets and concurrent programs
• Developed PL/SQL Packages, Procedures, Functions for validating teh invoices and payment information from teh legacy system and imported into Oracle Application using teh Payables Open Interface Import program and populated teh base tables
• Created Value sets for report parameters and registered them in apps using AOL
• Modified and created new concurrent programs as well as executable files when new reports and interfaces were created. Registered Concurrent Programs and attached to Request Groups

Oracle Apps Technical Consultant

Confidential

Environment: Oracle Applications 11.5.10, GL, AP, AR, OM, INV, PO, BOM, WIP, WSH, PL/SQL, SQL*Loader, Reports 6i, Discoverer, Shell Scripting, Toad, Sun Solaris 2.6, and Windows NT

Responsibilities:

• Preparation of technical specifications from teh functional specifications received from teh functional team, technical design using AIM methodology
• Designing new reports as per teh requirement
• Customizing teh existing reports
• Customization and extension of forms
• Raising service requests using metalink
• Customization of custom application report
• Developed teh new report Indent Vs PO Vs Receipt Vs Payment as per teh requirement
• Designed and developed Interface programs to load Vendors in Payables using Supplier Open Interface
• Price list conversion
• Outbound interface of Cancelled Sales Orders
• Order Import interface to import orders from legacy system to Oracle Applications
• Sales Orders & RMA Outbound Interface
• Report to show all teh Booked & Pending sales orders
• Customer interface
• Stock Statement Report
• Bank Payment Voucher
• Cash payment voucher
• Customization of custom application form
• Sub inventories conversion
• Item conversion
• Requisitions conversion
• AP open invoices conversion
• Buyers conversion

Oracle Apps Technical Consultant

Confidential

Environment: Oracle applications 11i (11.5.10), OM, INV, OIC, AP, GL, AR, PO, FA, iSupplier, iProcurement, Procure To Pay (P2P), Order To Cash (O2C), TCA, PL/SQL, SQL*Plus, TOAD, Developer 2000 (Reports 6i and Forms 6i), Custom.pll, Form Personalization, System administration, XML Publisher, Discoverer (10.2), Windows XP, UNIX, Linux, PVCS.

Responsibilities:

• Preparation of technical specifications from teh functional specifications received from teh functional team, technical design using AIM methodology
• Monitor teh records and correct teh records stuck in staging tables
• Cleaning teh records stuck in mtl transactions interface standard Interface table
• Capturing metrics for Load Testing
• Performing System Testing
• Outbound interface of closed and uninvoiced orders
• Report on Order details with shipped date more TEMPthan 'X' days
• Report for Sales order with zero onhand quantity
• Report to show all teh open backlog orders across multiple organizations
• Update import order using interface API
• Form customization to customize teh OM Sales Order form to capture customer note
• Report on inactive customers
• Report on drop ship po's having pending receipts but order lines closed
• Sending status report to teh client
• Designing new reports as per teh requirement
• Customizing teh existing reports
• Involved in PL/SQL code review and modification for teh development of new requirements
• Coordinated with Functional team in understanding teh Documentation, requirements gathering, and providing production support
• Documented teh work using AIM Methodology
• Designed/developed tables, views, various SQL queries, stored procedures, functions
• Involved in Design and Code reviews
• Involved in unit testing and fixing teh problem dat occurred in UAT (User Acceptance Testing)
• Supported teh CRPs, SIT and go - live activities
• Responsible for custom program maintenance during teh production support
• Tuned teh application report queries, other SQL queries to improve teh performance

Oracle Apps Technical Consultant

Confidential

Environment: Oracle Applications 11.5.10 (AP, AR, PO, INV, OM), Oracle 8i, HP UNIX, Reports 6i, Oracle Discoverer 4i, SQL *Loader, and TOAD

Responsibilities:

• Preparation of technical specifications from teh functional specifications received from teh functional team, technical design using AIM methodology
• Writing custom packages to develop conversion programs
• Development of interfaces
• Designing new reports as per teh requirement
• Developing conversion programs and reports dat are registered as concurrent programs and which are run from SRS form
• Involved in Design and Code reviews
• Involved in unit testing and fixing teh problem dat occurred in UAT (User Acceptance Testing)
• Supported teh CRPs, SIT and go - live activities
• Responsible for custom program maintenance during teh production support
• Inventory item costs comparison report between organizations
• Report on cancelled PO lines with PO details where such PO has made any receipts against any of teh lines
• XML report on inventory balances
• PO report with matching criteria with item cost
• Customization of Purchase Requisition Status Report - Layout adjustment and appearance change
• Interface to process changes to PO-s using API
• Cancelled purchase orders outbound interface
• Inventory stock locators conversion
• Sales order conversion
• Report on cancelled orders
• Item attachments conversion
• Receipts conversion
• Standard purchase orders conversion
• Form customization to capture teh date of related PO requisition in teh DFF in attribute 15 using custom.pll

Oracle Apps Technical Consultant

Confidential

Environment: Oracle Applications 11.5.9 (GL, AP, AR, OM, INV, PO, and WSH), Oracle 9i, Reports 6i, PL/SQL, SQL*Loader, SQL Navigator, and Linux

Responsibilities:

• Started as a trainee assisting teh offshore technical teams in developing PL/SQL programs for data conversions
• Worked on teh testing team doing manual testing of programs developed following teh test scripts and recording teh test results
• Documented all teh actual results in teh testing documents provided
• Worked on documenting all teh code for review by teh Team Lead