We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

Grain Valley, MO

PROFESSIONAL SUMMARY:

  • Having 8+ years of IT experience in development, setup, support, customization and testing in Oracle ERP Applications (10.7 / 11.0.3 / 11 i/ R12).
  • Worked on data conversion projects in supply chainmodules.
  • Expertise in activities like creation and maintenance of users, creating responsibilities, menu maintenance, creation of requests and request sets, registering applications, forms, formfunctions,reports, concurrent programs, etc.
  • Proven Experience in development tools such as PL/SQL, Oracle Developer suite 10g & Forms 9i/10g and Reports 9i/10g, Workflow Builder and XML Publisherin Oracle 11i/R12 environment and strong experience working with RICEW (Reports, Interfaces, Conversions, Extensions & Workflow) components.
  • Migration Experience working on 11.5.10 to R12 Instances.
  • Worked with RICE components in various modules like Purchasing (PO), Order management (OM), Inventory(INV), General Ledger(GL), Account Payables(AP), Accounts Receivables (AR)and system administration.
  • Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Data Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms, Materialized Views and Sequences.
  • Substantial development experience in creating stored Procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursormanagement and Exception handling.
  • Customized various forms, reports and other programs according to client's requirements and integrate with the new system. Conversant with many Database Tables, Views, and APIs associated with Modules.
  • Expertise in Order to Cash (O2C) and Procure to Pay (P2P) cycles.
  • Created custom templates with Data Definitions for XML Publisher and developed reports using reports and registered as XML reports in applications.
  • Good at developmentof Interface/Conversion (inbound and outbound) Programs using PL/SQL, Interfacetables andOracle Standard API's. Also developed Extensions to add additional validations and functionality to seeded oracle processes to meet the client's requirements.
  • Expertise in writing Challenging Codes using SQL, PL/SQL.
  • Wrote Test Cases, Prepared Test Plans, did unit and integration testing.
  • Good understanding of Multi Org and TCA Architecture
  • Used EXPLAIN PLAN, TKPROF to tune SQL queries.
  • Proficient in writing stored procedures, Packages and functions using SQL &PL/SQL.
  • Experience in supporting the production system, handling day - to-day issues and end user training.
  • Excellent analytical and problem solving skills, excellent writing/documentation skills, excellent interpersonal and leadership skills.

TECHNICAL SKILLS:

ERP: Oracle Apps R12, 11.5.10, 11.5.9 (GL,AR,AP,OM,PO,INV,Alerts, SysAdmin)

Operating Systems: Windows7/Vista/XP/2000.

Languages: SQL, PL/SQL, UNIX,HTML, XML, C, DS.

Application Software Tools: Microsoft Office- Word, Excel, Outlook, Power Point, Visio.

Data Modeling Tools: Oracle Developer Suite

RDBMS: Oracle 11i,10g, SQL Server 2000, MS Access.

Oracle Tools and Products: SQL*Plus, SQL*Loader, Reports 10g/9i, Forms 10g/9i, XML Publisher (Bi Publisher), TOAD, PL/SQL Developer, Workflow Builder 2.X, AIM, WinSCP, Putty,HP Kintana, PVCS.

PROFESSIONAL EXPERIENCE:

Confidential, Grain Valley, MO

Oracle Apps Technical Consultant

Environment: Oracle Applications R12, SQL, PL/SQL, Forms (9i), Report builder (9i), XML Publisher.

Responsibilities:

  • Worked on the development of interfaces, Data Conversions, custom Forms, Reports.
  • Used Standard API’s to Define and Schedule Concurrent Programs to launch as Concurrent Requests.
  • Involved in AP Invoice, PO, OM Conversions to load legacy data using SQL * Loader into Oracle Applications base tables.
  • Developed Custom Forms to create AP Consolidated Invoices by closing Individual AP invoices.
  • Developed Customer facing custom reports i.e. External Quote pdf report.
  • UsedKintana migration tool to migrate components from Development instances to Test instance.
  • Migrated the Custom components among the instances using FNDLOAD LDT's.
  • Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
  • Modified existing custom packages to add new functionality and to optimize the performance.
  • Worked with business teams to analyze system and process requirements.
  • Hands on experience in Oracle Applications System administration, involved in setting up user responsibilities, privileges of users, registering various Forms and Reports.
  • Translating and design of functional requirements into technical designs within the Oracle system. Documenting all technical designs and actual development product (code) according to the company's IT documentation standards.
  • Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
  • Developed PL/SQL packages, procedures, functions, triggers, Indexes to implement complex business logic.
  • Understand and apply System Development Life Cycle methodologies.
  • Involved in User acceptance testing and other levels of testing, resolving the HPQC defects.
  • Extensively Used DBMS, UTL packages and collections to develop PL/SQL code.
  • Setting the System Profile options at Site, Responsibility and User level for GL, AP, AR, PO, INV& OM modules.

Confidential, Cleveland, OH

Oracle Apps Technical Consultant

Environment: Oracle Applications 11i/R12 (Order Management, PO, AP, AR), SQL, PL/SQL, Forms (6i), Report builder (6i), XML Publisher.

Responsibilities:

  • Production support, bug fixing, enhancements to existing reports and interfaces, developing new reports, coordinating with business team and providing customized solutions, technical design, development and support business processes.
  • Design and development of XML Template reports for Intercompany transactions in AR, PO, OM modules.
  • Worked on the Bursting functionality of the XML Publisher to send the output of a concurrent program as an attachment to a mail id.
  • Worked on Kintana migration tool to migrate components from Development instances to Test instance.
  • Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
  • Modified existing custom packages to add new functionality and to optimize the performance.
  • Worked with business teams to analyze system and process requirements.
  • Hands on experience in Oracle Applications System administration, involved in setting up user responsibilities, privileges of users, registering various Forms and Reports.
  • Translating and design of functional requirements into technical designs within the Oracle system. Documenting all technical designs and actual development product (code) according to the company's IT documentation standards.
  • Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
  • Developed PL/SQL packages, procedures, functions, triggers, Indexes to implement complex business logic.
  • Developed Periodic and Event Alerts related to PO, AP, and AR Modules.
  • Participated in code management process, including use of source-code control utilities and facilitation of migration of code across multiple Oracle instances.
  • Created materialized views and refreshed through concurrent request.
  • Understand and apply System Development Life Cycle methodologies.
  • Developed PL/SQL packagesusing Custom, OM, AR and AP module tables.
  • Developed Test Scripts, Training Documentation using AIM.
  • Created end to end Sales order cycle, Inter Company Shipping flow for Business testing scenarios.
  • Worked on creating the pricelists based on the customer requirement.
  • Involved in User acceptance testing and other levels of testing, resolving the HPQC defects.
  • Extensively Used DBMS, UTL packages and collections to develop PL/SQL code.
  • Setting the System Profile options at Site, Responsibility and User level for GL, AP, AR, PO, INV& OM modules.

Confidential, Bedford, MA

Professional Services Consultant

Environment: Oracle Applications 11i/R12 (Payables, Purchasing), Oracle 10g, SQL, PL/SQL, Forms, Reports, XML Publisher

Responsibilities:

  • Used PL/SQL Programming language to develop customized packages, stored procedures, functions and database triggers.
  • Used Standard API’s to Define and Schedule Concurrent Programs to launch as Concurrent Requests.
  • Used descriptive flex fields extensively to capture additional information in standard as well as customized forms.
  • Implemented custom logic using Form Personalization.
  • Created materialized views and refreshed through concurrent request.
  • Wrote PL/SQL scripts for validating the data and Storing the data into MTL SYSTEM ITEMS INTERFACE and then populating the base tables by running the ITEM IMPORT Interface.
  • Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
  • Developed custom AR reports using XML Publisher.
  • Participated in code management process, including use of source-code control utilities and facilitation of migration of code across multiple Oracle instances.
  • Worked with business teams to analyze system and process requirements.
  • Writing conversion scripts invoking APIs to convert and write legacy data into Oracle tables.
  • Modified existing custom packages to add new functionality and to optimize the performance.
  • Worked extensively with tools such as EXPLAIN PLAN, SQLTRACE and Oracle Diagnostics for troubleshooting application and SQL issues.
  • Understand and apply System Development Life Cycle methodologies.
  • Supported Client’s Production Go-Live On-Site/Remote.

Confidential, Carlsbad, CA

Oracle Apps Technical Consultant

Environment: Oracle Applications R12 (Order Management, PO, INV), Oracle 10g, SQL, PL/SQL, Forms (9i, 10g), Reports (9i, 10g).

Responsibilities:

  • Working as team member in Technical Development and Production Support Teams.
  • Design, Development and support of reports, forms using Forms & Reports Developer (9i/10g).
  • Used Standard API’s to Define and Schedule Concurrent Programs to launch as Concurrent Requests.
  • Developed custom forms using standard AOL components like template forms and libraries.
  • Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
  • Design and development of Custom AR Billing status report (AR module).
  • Prepared Reports in Purchasing such as Purchase Order Detail Report, Blanket and Planned PO Status Report, Purchase Agreement Audit Report, Purchase Order and Releases Detail Report, Purchase Summary Report by Category.
  • Worked on customization of various reports of supply chain to ensure that it works in new operating unit.
  • Wrote SQL*Loader scripts to migrate the data from the text files, Excel Spreadsheet etc. and populated the intermediate tables.
  • Hands on experience in Oracle Applications System administration, involved in setting up user responsibilities, privileges of users, administering concurrent managers/transaction managers (activate/deactivate, request priorities), registering various Forms and Reports.
  • Translating and design of functional requirements into technical designs within the Oracle system. Documenting all technical designs and actual development product (code) according to the company's IT documentation standards.
  • Developed several PL/SQL packages, procedures, functions, triggers from UI events or database triggers, to implement complex business logic.
  • Implemented several custom logic using Form Personalization.
  • Extensive Experience in customization of modules using Forms 9i/10g, Reports 9i/10g.
  • Developed PL/SQL packagesusing Custom, OM and INV module tables.
  • Transferred Custom Concurrent programs, executable, request groups, profile options using Oracle's FNDLOAD utility.
  • Developed Test Scripts, Training Documentation using AIM.
  • Involved in User acceptance testing and other levels of testing, resolving the defects and in cut over activities.
  • Extensively Used DBMS, UTL packages and collections to develop PL/SQL code.
  • Setting the System Profile options at Site, Responsibility and User level for GL, AP,AR,PO, INV& OM modules.

Confidential, Little Rock, AR

Oracle Apps Technical Consultant

Environment: Oracle Applications 11.5.10.2/R12 (GL, AP, PO, OM, INV), Oracle 9i/10g,SQL, PL/SQL, HTML, Forms 9i/10g, Reports 9i/10g, UNIX.

Responsibilities:

  • Designed and Developed Concurrent Programs using Oracle API’s.
  • Worked extensively with customizations in Order to Cash and Procure to Pay life cycles.
  • Customized Reports Open order report, Customer Detail listing report, Item definition Summary Report, Item detail listing report.
  • Developed a program to load external data from legacy system into PO HEADERS INTERFACE and PO LINES INTERFACE.
  • Extensively worked with CUSTOM.pll and event based triggers in forms.
  • Extensively used data templates with XML publisher to develop custom reports.
  • Involved in implementing GL, AP, PO and OM modules including writing interface programs according to user and business requirements and developing several reports using Oracle Reports 9i & 10g according to the functional specifications provided.
  • Responsible for Oracle Applications Customizations and Report development.
  • Developed SQL (DML) scripts for checking data in the database for customized import processes.
  • Provided database maintenance, resolved technical problems in respect to performance of the database.
  • Developed Custom Reports in Inventory for audit purposes.
  • Developed PL/SQL Procedures, Packages, Functions and Triggers.
  • Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements in AP, OM,POand GL.
  • Involved in production support for Development Releases.
  • Involved in developing Integration Test Scripts and Documenting End-User Training Materials for General Ledger, Purchase Order and Accounts Payable modules.

Confidential, Maryland

Oracle Apps Developer

Environment: Oracle Applications 11.5.9, Oracle 9i, SQL, PL/SQL, HTML, UNIX, Windows 2000, Reports 6i, XML Publisher, Forms 6i.

Responsibilities:

  • Customized the Invoice report in AR and developed other new reports in OM, FA and PO.
  • Customized XML Publisher Pick Slip and Pack slip reports.
  • Developed BOM Explosion Report using User Exits.
  • Customized PO Report and Open PO Report.
  • Developed Interfaces for employer Conversion in HRMS and Tax conversion in AR.
  • Customized reports like Journals General, Account analysis, Payables details, Invalidated Invoice Register.
  • Involved in Items conversion in Inventory Module and loading of BOM’s from the legacy system.
  • Develop programs that facilitate data conversion from legacy applications to Oracle's enterprise suite
  • Developed new forms using Template.fmb (AU TOP/forms/US).
  • Developed PL/SQL Procedures, Functions, Packages and Triggers.
  • Involved in developing Integration Test Scripts and Documenting End-User Training Materials for General Ledger, Fixed Assets, Purchase Order, HRMS and Accounts Payable modules and Performing Integration Test.

Confidential

Oracle Developer

Environment: Oracle Applications 11.5.6, Oracle 9i, SQL, PL/SQL, HTML, windows 2000.

Responsibilities:

  • Customized existing forms appearance and incorporated new functionalities.
  • Customized Forms in INV module.
  • Developed new Custom forms.
  • Design and development of Custom Purchase Order report.
  • Design and Development Custom Invoice Document.
  • Developed new forms using Template.fmb (AU TOP/forms/US).
  • Used SQL Loader to Load data into the custom tables.
  • Developed SQL Applications for extracting the data from the Oracle tables.
  • Wrote SQL Scripts to create, alter, and drop database objects like tables, views, and sequences.
  • Responsible for Development of Oracle Reports and Customizations.
  • Developed PL/SQL Procedures, Functions, Packages and Triggers.
  • Extensively Used DBMS, UTL packages and collections to develop PL/SQL code.
  • Involved in fine tuning SQL Queries by properly using indexes and hints.

Hire Now