We provide IT Staff Augmentation Services!

Sr. Oracle Apps Techno - Functional Consultant Resume

Milford, CT

SUMMARY:

  • Over 13 years of experience in Information Technology, involved in Requirement gathering, Analysis, Design and Development of Oracle Applications, Web and Client - Server Technology Applications on Windows and UNIX environments.
  • 10 years of experience in the implementation, designing customizations and extensions in Oracle Financials, Manufacturing, Supply Chain and CRM Modules.
  • Experienced in Upgradation, Implementation and Production Support of Oracle Application 10.7/11.0.3/11 i/R12.
  • Experienced in Data Conversion, Interfaces, Extensions, Customization and new development in Oracle Application including Oracle General Ledger, Oracle Payables, Oracle Receivables, Fixed Assets, Project Accounting, Purchasing, Order Management, Shipping, Advanced Pricing, Inventory, Bill of Materials, Work in Process, MRP, CRM Foundation, Install Base, Service Contracts, Quoting, Oracle Configurator, iProcurement and iExpense.
  • Expertise in AOL, System Administration, XML Publisher/BI Publisher, Workflow, Alerts, Discoverer, Oracle Configurator Developer, OAFramework, BPEL and Trading Community Architecture (TCA).
  • Extensive experience in Oracle backend objects like Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
  • Expertise in developing database applications using Oracle with Developer 2000 (Forms 6i, Reports 6i), Web Applications using Java, Servlets, JSP, XML and other web programming tools.
  • Used both Oracle AIM (Application Implementation Methodology) and other custom methodologies for Implementation and Upgradations.
  • Experienced in Developing Technical Specification and Design Document.
  • Exposure to Oracle Applications R12 features and hands on experience.
  • Having strong Business and Analytical skills.

TECHNICAL SKILLS:

ERP: Oracle Applications 12i/11i/11.0.3/10.x.

ERP Technical Modules: Oracle Workflow, XML Publisher, OAFramework, BPEL, AOL, Alerts, and SYSADMIN

ERP Functional Modules: GL, AP, AR, CM, FA, PA, OM, QP, WSH, PO, INV, BOM, WIP, MRP, ASO, Install Base, Service Contracts, iProcurement and iExpense.

Operating Systems: Windows NT/2000, UNIX

Languages: C, C++, Shell Script, Java, SQL, PL/SQL, Visual Basic, HTML, Java Script

Web Programming: JDBC, Servlets, JSP, RMI, XML, ASP

Databases: MS SQL Server 7.0/2000, Oracle 7.x/8i/9i/10g

Tools: /Utilities: TOAD, CVS, PVCS, Clearcase, Taviz, SQL*Loader, Export, Import, Developer 2000/6i, Oracle jDeveloper, BI Publisher, Oracle Translation Manager, Oracle Discoverer 4.x/9i.

PROFESSIONAL EXPERIENCE:

Confidential, Milford, CT

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Designed and developed a custom reports and processes for the month end closing activity.
  • Designed and developed custom form, program for month end report automation.
  • Setup the Cash Management module.
  • Created BR.100 Cash Management Application setup.
  • Created MD.050 for Cash Management AutoReconciliation process.
  • Used the Data Loader and create loader scripts to import the Bank Transaction Codes used for the AutoReconciliation in Cash Management.
  • Created MD070 for AutoReconciliation process customizations and Custom programs for identifying Payments for Reconciling Wire Payments.
  • Setup a process and created required programs to archiving the Bank Statements that imported to the Cash Management.
  • Created Service Requests and worked with Oracle support for bugs and patches.
  • Prepared System Test Scripts for UAT sessions and Training Documents with screenshots for end users.

Environment: Oracle APPS R12 (12.1,3), Linux, Oracle 10g, Forms 10g and Reports 10g, TOAD, OM, INV, AR, AP, CE and GL.

Confidential, Valencia, CA

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Designed and developed a custom configuration for Item selected in Customer Item Cross Reference, Quotes and Sales Orders.
  • Worked on Data Conversions for “One System” Project. Developed Conversion programs to bring St. John’s company data to PDC system.
  • Developed Custom forms for sales order configurations.
  • Developed and Modified XML Publisher Report templates in OM and Shipping Modules.
  • Developed Forms personalization in OM, INV modules.
  • Customized Sales Order Line Workflow for custom business process.
  • Worked on performance tuning in Conversion programs and Reports.
  • Worked on Service Requests Conversion in Service Module
  • Worked on the Service Contracts Conversion in the OKS Module.

Environment: Oracle APPS R12 (12.1,3), Linux, Oracle 10g, Forms 10g and Reports 10g, TOAD, OM, INV, AR, OKS.

Confidential, Pittsburgh, PA

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Involved in the upgradation of the Oracle Apps from 11i (11.5.10.2) to R12 (12.1.3). Involved heavily in both Functional and Technical issues during the upgrade.
  • Worked on the modification of custom objects, and programs for R12.
  • Involved in the testing of Business cycles in OM, INV, PO, AP, AR, Payment, and GL modules.
  • Worked with business users to resolve the issues.
  • Created Service Requests and worked with Oracle support for bugs and patches.
  • Involved in preparing documents and setting processes for the R12 upgrade project.
  • Developed Forms personalization in GL and AR modules.
  • Developed custom AR Invoice report using XML/BI Publisher.
  • Configured Payments module for Check Print and developed custom check print layout in Payment module.
  • Customized Shipping document reports for R12 using BI Publisher.
  • Create customization to create events in Projects from Receivables.
  • Worked on custom reports for iExpense, Projects and Payables.
  • Worked on tracing and performance improvement.

Environment: Oracle APPS R12 (12.1,3), Redhat Linux, Oracle 10g, Forms 10g and Reports 10g, OAF (JDeveloper), TOAD, PVCS, OM, INV, PO, AP, AR, PA, Payment, iExpense, GL.

Confidential, Red Bank, NJ

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Involved in the implementation of the Oracle Apps R12 (12.1.3).
  • Worked on the development and testing of cheque printing report for Multiple cheque templates in Payments module.
  • Worked on the custom XML Publisher Freight and Duty report that brings the Material transactions from Regular POs and Logical Transactions.
  • Worked on the custom solution to report all the non-trade management deductions (adjustments) in AR Module.

Environment: Oracle APPS R12 (12.1,3), IBM UNIX, Oracle 10g, Forms 10g and Reports 10g, OAF (JDeveloper), TOAD, PVCS, INV, PO, AP, OKS, Payment, Process Manufacturing (OPM).

Confidential, Cherry Hill, NJ

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Involved in all phases of the upgradation of the Oracle Apps from 11.5.10 to R12 (12.1.3). Analyzed, Modified, Redesigned the Customizations for the R12 environment.
  • Worked as a mentor for in-house development team for R12 upgradation.
  • Redesigned Oracle Reports to BI Publisher, Reapplied the customizations on some of the reports that have been changed in R12.
  • Used Data Templates, Bursting features in BI Publisher to generate Custom reports like Dealer Statements, Commercial Invoice, and Dealer ACH Payments Reports in R12.
  • Developed custom Drill-down reports from Sub ledger modules using the new R12 SLA Module tables.
  • Modified the custom forms, reports, pl/sql programs for changes in Bank, Vendor, Payables, and Payments modules tables.
  • Performed extensions on Customer Bank Accounts and Supplier Bank Accounts OAF pages using jDeveloper.
  • Modified custom forms for MOAC features in R12.
  • Enhanced customizations PO and Receipt creation process in Purchasing, Inventory Module. Enhanced functionality in custom.
  • Designed and Developed a Custom inbound interface to load Parts information for Claims Service.
  • Developed custom forms to have a facility to Query, Modify and Create the Parts for the Claims Service.
  • Developed common utility programs for FTP, Archiving to be used by multiple interface programs.
  • Involved in the Analysis and Design of the Re-org Structure Project.
  • Worked on modifying the Custom PL/SQL, Forms and Reports for the Re-org Project.
  • Developed custom Sales Order form with query only facility in the OM Module using the forms6i.
  • Developed data correction forms to correct the exported sales order shipments data.
  • Developed forms for dealer hierarchy and makes the form accessible from Sales Orders and Invoice forms through Forms Personalization.
  • Developed Custom 1099 Reports using the Oracle Reports6i and XML Publisher in AP Module.
  • Developed Custom AP Invoices Import to create Invoices for Dealer commissions in AP Module.
  • Developed custom PLSQL APIs to get the Incentive information for external web applications.
  • Developed custom OA Framework screens to query the vehicle spec details and the Incentive information.
  • Implemented parallel process in Billing and other critical programs to cut short the nightly batch jobs window.
  • Used AIM methodology and created MD070, MD120 Documents for customizations developed.

Environment: Oracle APPS 11i (11.5.10.2), R12 (12.1,3), HP UNIX, Oracle 10g, Forms 6i/10g and Reports 6i/10g, OAF (JDeveloper), TOAD, PVCS, SQL*Loader, INV, AP, AR, OM, Incentive Compensation.

Confidential, CA

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Involved in the study of Ahnu's Legacy Application, and data extraction and data cleaning.
  • Prepared Conversion Data mapping Document CV040 using Oracle AIM Documentation standards.
  • Performed the Required setups in AR, PO, INV, and OM Modules in the Decker's R12 System for the Data Conversion.
  • Worked on the Performance improvement of Custom PL/SQL Programs.
  • Developed a few custom reports like Asset Reserve Summary Report, Asset Reserve Detail Report in FA Module using Reports 10g.
  • Developed Custom PL/SQL programs to validate and Import the Items, Sales Orders, Purchase Order and the AR Invoices.
  • Worked on the Performance improvement of SQL statment and Custom PL/SQL Concurrent Programs.
  • Used Oracle AIM Methodology for Technical Specification Documents(MD70).

Environment: Oracle Apps R12, HP UNIX, Oracle 10g, TOAD, SQL*Loader, PO, OM, INV, AR, Reports 10g.

Confidential, Pine Brook, NJ

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Developed a Customization for Credit and Re-bill for the corrected Meter Reads in Service Contracts and AR Modules.
  • Customized the Lockbox process for Receipts Import and applied against Invoice for various matching requirements in AR Module.
  • Developed utilities to change the Billing Amount, Billing Frequency for a Service Contracts in Service Contracts Module.
  • Developed Custom forms for the Aggregate Billing extension solution in Service Contracts and Billing.
  • Worked on the customization of Service Contracts Main Billing Program.
  • Used CUSTOM.pll for validations and zoom functionality.
  • Developed various adhoc reports for the Business using Reports6i and PL/SQL Package Programs.
  • Developed Custom Solution to upload files using attachment from a Custom form using Forms6i for various data uploads.
  • Developed Custom Program to validate the Sales Orders comes from the EDI in OM Module.
  • Worked on the Defaulting and Validating using POR CUSTOM PKG iProcurement Module.
  • Customized the Account Generator Workflow to Rebuild Charge Account in iProcurement Module.
  • Setup the Approval Group, Rules in the Oracle Approval Management Engine.
  • Customized the PCard Transaction flow using OAFramework in iExpense Module.
  • Worked on Performance improvement of Custom PL/SQL Code, Forms and Reports.
  • Worked with the Business users for gathering the Business Requirements gathering, Analysis, Functional Test and UAT stages.

Environment: Oracle APPS 11i(11.5.10), HP UNIX, Oracle 9.i, Forms 6i and Reports 6i, TOAD, SQL*Loader, Service Contracts (OKS), Install Base, OM, AR, AP, iProcurement, iExpense.

Confidential, Fullerton, CA

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Customized the Contracts Approval Workflow to check for the Profitability Analysis of the Contract.
  • Developed PL/SQL Programs for Custom QA Check validation in the Contracts Module.
  • Developed Wrapper Program on top of Pricing APIs to get the list price for an Item.
  • Customized the existing interface program from Contract to OM, to add the Adjustments for sales order lines as per the Modifier and Qualifier Setup in Pricing Module.
  • Defined the Custom Rule Groups and Rules in the Contracts Module.
  • Created a Custom Report using the PL/SQL and XML Publisher for Profitability of the Contract.
  • Developed Interface Program from Contracts to OM. Used OM Adjustments tables to create adjustments based on the Modifiers that Setup in the Pricing Module.
  • Performed the Setups and Created a Custom Form to capture the Credit Card details of the customer on the Contract. Used Oracle Java Classes to Encrypt and Decrypt the data to secure the data.
  • Involved in the Setup of Expenses Payment Process in AP Module.
  • Worked on Performance improvement of Custom PL/SQL Code, Forms and Reports.
  • Developed Conversion Programs to Import pricing information from the legacy systems for Contracts extension modules.
  • Used Oracle Form Personalization for some Form Customizations.
  • Used CUSTOM.pll for validations and zoom functionality.
  • Developed Workflow for Approval of Adjustment in Receivables Module based on Position Hierarchy and their approval levels.
  • Developer Unix Shell Scripts to migrate the Form Personalization code, XML Publisher code to different instances.
  • Worked on the Conversion of Projects, Tasks and Expenditures in PA Module.
  • Developed Technical Design Documents for the Form, Report Customizations using the Oracle AIM Methodology.
  • Worked with the Oracle Support Team for TAR/Service Requests for some issues on the Install Base and Service Contracts.
  • Worked with the Business users for gathering the Business Requirements gathering, Analysis, Functional Test and UAT stages.

Environment: Oracle APPS 11i(11.5.10), HP UNIX, Windows XP, Oracle 9.i, Forms 6i and Reports 6i, TOAD, SQL*Loader, Core Contracts (OKC), Service Contracts (OKS), Install Base, OM, AR, AP, PA, INV, Star Team, Kintana.

Confidential, San Ramon, CA

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Developed Custom forms in extension modules to Oracle Service Contracts.
  • Automated the creation of a Fleet product from Service contracts authoring form to increase user productivity and reduce user errors and downstream issues.
  • Developed Custom Packaged procedure for QA Check in Service Contracts Module.
  • Used Oracle Service Contracts and Install Base API for Conversion.
  • Developed Items and BOM Models for the Custom Oracle Configurator Models.
  • Worked extensively in the Oracle Configurator Developer Tool and Developed the Custom Configuration Models tool.
  • Developed Java Code for Oracle Configurator Module.
  • Used Quoting API’s and developed a Custom Procedures to import quotes in Oracle Quoting and Sales-Online module.
  • User Get Custom Price API for Custom Pricing in Advanced Pricing module.
  • Developed stored procedures for the Custom Application in Service Contracts.
  • Worked on Performance tuning in Purchasing Module.
  • Developed Custom Control files in SQL*Loader for Auto Lockbox in AR Module.
  • Developed Out-bound Interface for Direct Debit Remittance Transactions in AR Module.
  • Developed Conversion Programs using HZ APIs for updating Customer Information (TCA) for Business Requirements.
  • Used Oracle 9iAS Advanced Queues to integrate the Oracle Custom Modules with other legacy systems.
  • Developed Supplier Conversion in AP Module.

Environment: Oracle APPS 11i, Sun Solaris, Windows XP, Oracle 9.i, Oracle 9iAS, Forms 6i and Reports 6i & TOAD, SQL*Loader, Quoting, Sales Online, Service Contracts, OM, Oracle Configurator, AR, INV, AP, PO, CVS, Kintana.

Confidential, Jamesburg, NJ

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Developed Custom Order Import Program to load data that comes from the external source to the Order Management.
  • Developed a Custom Form to show the Canon Delivery Confirmation Information in OM Module.
  • Used Oracle Service Contracts API for Interface Programs.
  • Worked on some fixes and Custom Programs in Service, Contracts Modules in CRM.
  • Worked on the Invoices that got stuck at AutoInvoice Program in AR Module.
  • Developed Price List Loader program using Pricing Module APIs.
  • Developed Custom Open Invoice Interface program in AP Module.
  • Developed a brand new Workflow to send notification for update of lines on RMA order, when it's different from the Receiving quantity.
  • Developed Discoverer reports in OM Module.
  • Worked on the resolution to the Performance issues in OM Module.
  • Interacted with the Users and Business Process Managers to gather requirements to resolve the issues and fix the problems.
  • Created TAR on some issues and worked with Oracle Support.

Environment: Oracle Applications 11i (11.5.6, 11.5.9) (OM, Shipping, Pricing, INV, BOM, Service and Contracts, AR) Sun Solaris, Oracle 8i, SQL, PL/SQL, Workflow, Discoverer, TOAD.

Confidential, Chicago, IL

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Customized the AR Invoice, Sales Tax Reports in Receivables.
  • Customized the AutoAccounting and AutoInvoice Programs in Receivables.
  • Modified Customer Validation Program in Receivables.
  • Developed Custom Invoice Import Program in Payables Module.
  • Developed Custom Program to load freight tax exception data in Receivables.
  • Customized the Order Import Process for the Price List in OM.
  • Developed Order Import Error Report in OM, and Developed a Shell Program to send the report as an email.
  • Involved in all the stages of the Project, gather requirements, Prepared Design Documents, Developing and Prepare Test Cases and Testing.
  • Used Kintana to migrate objects developed/modified from one instance to the other.
  • Used Clearcase for Configuration Management.
  • Followed Motorola Coding and Quality standards for Development.
  • Involved in Code reviews of objects developed by other team members and ensure the Quality standards.

Environment: Oracle Applications 11i (11.5.8) (AP, AR, OM) Sun Solaris, Oracle 9i, Reports 6i, SQL*Loader, SQL, PL/SQL, Unix Shell, TOAD, Clear Case, Kintana.

Confidential, North Canton, OH

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Customized Shipping Reports namely Pickslip, Packing List and Proforma Invoice in OM, and Open Purchase Orders report in PO modules.
  • Developed custom Reports in INV, BOM and WIP modules using Reports 6i.
  • Customized Order Entry form to populate Intermediate ship-to locations using the CUSTOM.pll.
  • Developed a New Workflow Process to send the notification on modifying the Schedule Ship Date and Promised Date of an order.
  • Customized a Buyer Notification workflow in iSupplier Module using the Oracle Workflow Builder.
  • Used Oracle CIO Java API, and developed Java Interface Program to import ATO and PTO orders from the legacy system in OM.
  • Defined the Configurations in the Oracle Configurator Front.
  • Worked on the Item Conversion in the INV Module.
  • Developed a Custom program to Calculate the Daily schedules, and Weekly Schedules from the Unscheduled Orders per item on the basis of the Capacity and Work Calendar by using the various algorithms in WIP and MRP Modules.
  • Developed a Custom Report from the Scheduled data in the Custom tables in WIP Module.
  • Developed a Custom form for the Line flow Schedule data in WIP Module.
  • Worked on the Customer Conversion from legacy Systems using the Oracle HZ Schema APIs in the AR Module.
  • Developed Custom Journal Import Program in GL Module.
  • Developed Auto Invoice Interfaces in the AR.
  • Used HZ Schema in TCA.
  • Worked on the Translations of Reports to different languages using Oracle Translation Manager (OTM).
  • Preparation of Unit Test Cases and Installation (MD120) Documents.
  • Used CVS, and TortoiseCVS for Configuration Management.
  • Code reviews of objects developed by other team members and ensure the Quality standards.

Environment: Oracle Applications 11i (11.5.6)(GL, AR, TCA, PO, OM, INV, BOM, WIP, MRP, iSupplier), HP UNIX, Oracle 9i, Forms 6i, Reports 6i, TOAD, SQL Loader,SQL, PL/SQL, Oracle Translation Builder, Oracle Workflow Builder, CVS.

Confidential, San Jose, CA

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Conducted the System Study and Mapping of Scripts in 10.7.
  • Redesigned the System to eliminate storing the user and passwords to connect to different instances of the System.
  • Modified the Custom Programs and Reports in the OM, INV, BOM, and WIP Modules for the Oracle Apps 11i Environment.
  • Modified the programs that connect to the schema in different databases by Database Links.
  • Solved the issues that arise in the Distributed databases.
  • Involved in Performance tuning of various queries and stored procedures.
  • Developed SQL*Plus Reports.
  • Prepared Unit Test Cases.
  • Migration and Testing of the Deliverables in different instances.
  • Worked on PVCS to Check-in and Checkout the code and Control the version details.
  • Code reviews of objects developed by other team members and ensure the Quality standards.

Environment: Oracle Applications 11i (11.5.5) (PO, AR, OM, INV, BOM, WIP), HP UNIX, Oracle 9i, Reports 6i, SQL, PL/SQL, TOAD, PVCS.

Confidential, Michigan, DT

Sr. Oracle Apps Techno - Functional Consultant

Responsibilities:

  • Developed an Interface for the Journals Import in GL.
  • Worked on the Data Conversion using SQL*Loader to import legacy Suppliers in the PO Module.
  • Developed Custom Bitmap Reports namely Sales Invoice, Purchase Order and Sales Order in AR, PO and OM.
  • Developed Custom Reports in AR namely Invoice Exception Report, Customer Credit Report.
  • Worked on Mass Addition Interface in FA module.
  • Worked on the Data Conversion of Customer in the AR Module.
  • Developed Auto Invoice Interface in the AR Module.
  • Worked on the Open Invoices Interface in the AP Module.
  • Customized Order Entry Form to match the Business Requirement.
  • Developed Interface for the Standard Items of Sales Orders Import in OM.
  • Customized the Standard Workflow Process for a Specific Order Types using Oracle Workflow Builder.
  • Developed FSG Reports in GL.
  • Preparation of Test Cases and Installation Documents.
  • Migration and Testing of the Deliverables in different instances.

Environment: Oracle Applications 11.0.3 (GL, AR, AP, FA, PO, OM, INV), HP UNIX, Oracle 8.0, Reports 4.5, Forms 2.5, SQL*Loader, SQL, PL/SQL, TOAD.

Hire Now