SUMMARY

• Having 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 Technical Consultant - Supply Chain Management(SCM) / Manufacturing / Financials
• Excellent technical development skills in developing Reports, Interfaces, Conversions and Extensions in the domain of Oracle E-Business Suite(EBS) using SQL, PL/SQL and Developer 6i
• Manufacturing & Supply Chain Management - Purchasing (PO), Inventory (INV), Order Management (OM), Bills of Material (BOM)
• Financials - Receivables (AR), Payables (AP), General Ledger (GL), Project Accounting(PA)
• Excellent knowledge 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 the 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 the Standard Documents (MD 50, MD 70, MD 120, CV 40, CV 60)
• Good knowledge in Procure To Pay(P2P) and Order To Cash(O2C) cycles
• 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 the reports as per user requirements
• Good knowledge 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/10g, Oracle Reports 6i/10g.
• Exposure to ERP Application Testing (Manual/Automation)
• Good knowledge 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 (Report, Interface, Conversion and Extension) 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 (PO, INV, OM, AP)

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

Confidential, Brooklyn, NY

Sr. Oracle Apps Technical Consultant

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

Responsibilities:

• Preparation of technical specifications from the functional specifications received from the functional team, technical design using AIM methodology.
• Writing custom packages to develop conversion programs.
• Designing new reports as per the requirement.
• Converted standard reports into BI Publisher Reports.
• Developing conversion programs and reports that are registered as concurrent programs and which are run from SRS form.
• Customization and extension of forms.
• Involved in Design and Code reviews.
• Involved in unit testing and fixing the problem that occurred in UAT (User Acceptance Testing).
• Supported the CRPs, SIT and go-live activities.
• Responsible for custom program maintenance during the production support.
• Coordinated with Functional team in understanding the Documentation, requirements gathering, and providing production support
• Documented the work using AIM Methodology
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility
• 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 the on-hand quantity cost v/s the physical count cost
• Prepared and reviewed MD70 Technical Design Documents for report customization
• Conducted Oracle applications System Administration duties including Defining users, Assigning Responsibilities and Defining Menus
• Designed and developed PO requisition interface to load PO requisitions from the legacy System into purchasing interface tables
• Developed report to show the rejected and returned quantities and the days between the rejected and returned quantities to the vendor.
• Developed rdf report to show all the 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 that exist on active POs by buyer and by organization.
• Developed report to show all the payables cleared invoices sorted by invoice groups.
• Form customization to zoom from the PO form to the supplier form using personalization feature.
• Involved in data validation and data reconciliation and tracked the defects using Rational Quality Manager

Confidential, Plano

Sr. Oracle Apps Technical Consultant

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

Responsibilities:

• Preparation of technical specifications from the functional specifications received from the functional team, technical design using AIM methodology.
• Writing custom packages to develop conversion programs.
• Development of interfaces.
• Designing new reports as per the requirement.
• Developing conversion programs and reports that are registered as concurrent programs and which are run from SRS form.
• Customization and extension of forms.
• Involved in Design and Code reviews.
• Involved in unit testing and fixing the problem that occurred in UAT (User Acceptance Testing).
• Supported the CRPs, SIT and go-live activities.
• Responsible for custom program maintenance during the production support.
• Tuned the application report queries, other SQL queries to improve the 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 the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables
• 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
• 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

Confidential, Kansas

Oracle Apps Technical Consultant

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), PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i and Forms 6i), System administration, XML Publisher, Discoverer (10.2),Windows XP, UNIX, Linux, PVCS.

Responsibilities:

• Preparation of technical specifications from the functional specifications received from the functional team, technical design using AIM methodology.
• Monitor the records and correct the records stuck in staging tables.
• Cleaning the records stuck in mtl transactions interface standard Interface table.
• Capturing metrics for Load Testing.
• Performing System Testing.
• Sending status report to the client.
• Designing new reports as per the requirement.
• Customizing the existing reports.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Coordinated with Functional team in understanding the Documentation, requirements gathering, and providing production support
• Documented the 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 the problem that occurred in UAT (User Acceptance Testing).
• Supported the CRPs, SIT and go-live activities.
• Responsible for custom program maintenance during the production support.
• Tuned the application report queries, other SQL queries to improve the performance

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications 11.5.9, 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 the functional specifications received from the functional team, technical design using AIM methodology.
• Designing new reports as per the requirement.
• Customizing the existing reports.
• Customization and extension of forms.
• Raising service requests using metalink.
• Customization of custom application report.
• Developed the new report Indent Vs PO Vs Receipt Vs Payment as per the requirement.
• Designed and developed Interface programs to load Vendors in Payables using Supplier Open 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

Confidential

Oracle Apps Technical Consultant

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

Responsibilities:

• Preparation of technical specifications from the functional specifications received from the functional team, technical design using AIM methodology.
• Writing custom packages to develop conversion programs.
• Development of interfaces.
• Designing new reports as per the requirement.
• Developing conversion programs and reports that are registered as concurrent programs and which are run from SRS form.
• Involved in Design and Code reviews.
• Involved in unit testing and fixing the problem that occurred in UAT (User Acceptance Testing).
• Supported the CRPs, SIT and go-live activities.
• Responsible for custom program maintenance during the 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 the 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
• UOMs conversion
• Inventory stock locators conversion
• Item attachments conversion
• Receipts conversion
• Standard purchase orders conversion
• Form customization to capture the date of related PO requisition in the DFF in attribute 15 using custom.pll.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications 11.5.6 (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 the offshore technical teams in developing PL/SQL programs for data conversions.
• Worked on the testing team doing manual testing of programs developed following the test scripts and recording the test results.
• Documented all the actual results in the testing documents provided.
• Worked on documenting all the code for review by the Team Lead.