We provide IT Staff Augmentation Services!

Sr. Oracle Apps Techno Functional Consultant Resume

3.00/5 (Submit Your Rating)

Jamesburg, NJ

SUMMARY

  • Around 10 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 the 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)
  • Good knowledge in Oracle Service Contracts, Oracle Core Contracts and Oracle Lease Management
  • 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
  • Good knowledge 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(BI 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/9i/10g, Oracle Reports 6i/9i/10g.
  • Good experience in change control software PVCS and VSS.
  • 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 (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

Confidential, Jamesburg, NJ

Sr. Oracle Apps Techno Functional Consultant

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 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
  • Worked on different objects in Oracle Payables and Receivables as a part of production support
  • Report to show all the 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 the on-hand quantity cost v/s the physical count cost
  • 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
  • Monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility
  • Created ldts for valuesets, Concurrent programs, request groups and request sets
  • Maintained the 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 the problem that occurred in UAT (User Acceptance Testing)
  • Responsible for custom program maintenance during the production support

Confidential, Brooklyn, NY

Sr. Oracle Apps Technical Consultant

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 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
  • RMA conversion to transfer all Return Orders and Lines from external Source to Oracle using Sales Order API
  • Form customization to Customize the 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 the Booked & Pending sales orders
  • Customer interface
  • 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
  • Monitoring the 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 the defects using Rational Quality Manager

Confidential, Plano

Sr. Oracle Apps Technical Consultant

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 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
  • 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 the cancelled orders based on customer name
  • API to apply hold on new orders
  • Form customization to populate the DFF in Order headers block based on the salesperson Territory ID
  • Conversion program to import OM Holds information from legacy system to Oracle Applications
  • Order Approval form to enable the user to approve each and every order to be imported into the 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 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
  • 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

Oracle Apps Technical Consultant

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 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
  • 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 the 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

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), 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 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
  • Outbound interface of closed and uninvoiced orders
  • Report on Order details with shipped date more than ‘X’ days
  • Report for Sales order with zero onhand quantity
  • Report to show all the open backlog orders across multiple organizations
  • Update import order using interface API
  • Form customization to customize the 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 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.10 (AP, AR, PO, INV, OM), Oracle 8i, HP UNIX, Reports 6i, Oracle Discoverer 4i, SQL *Loader, and TOAD, BI Publisher

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
  • Inventory stock locators conversion
  • Sales order conversion
  • Report on cancelled orders
  • 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.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 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

We'd love your feedback!