We provide IT Staff Augmentation Services!

Oracle Apps Consultant Resume

4.00/5 (Submit Your Rating)

Huntersville, NC

SUMMARY

  • Over 11 years of IT experience with 10 years of extensive experience in design, development, testing and implementation of Oracle Applications.
  • Experience in full life cycle implementations and upgrade of Oracle Applications as a Oracle ERP functional/Support/Quality analyst consultant includes various Oracle Applications modules like Supply Chain Management (OM, WMS, INV and PO) and Financials (AP, AR, GL and FA), Distribution Modules (PO, INV, OM) and all aspects of Application Object Library (AOL) and Sysadmin.
  • Very strong technical and functional experience in implementing, upgrading, and customizing Oracle Supply Chain Modules (11.10.5) in large & R12
  • Experience in Testing and Support of both Development and Production Systems.
  • Strong design experience on Open Interfaces (inbound and outbound interfaces), APIs and RICE components Oracle Reports, Interfaces, Conversions and Extensions in financials, manufacturing modules and Oracle SCM.
  • Implemented more TEMPthan 100 DCs to WMS from the old system (Mainframes).
  • Configure all the WMS setups for each DC until go - live and support.
  • Experienced in Analysis, Implementation, Design, Development, Customization, Upgrade, Integration, Testing and Support of Oracle Applications as part of full life cycle implementation
  • FullFunctional and Technical experience withorder to cash(O2C), procure-to-pay(P2P) and END-ENDcyclesofOracle Applications E-Business Suite and accounting-to-financial reporting functions. This halped alot to bring TEMPeffective processes in place, reduce costs with less headcount and make the process more efficient for clients.
  • Interacting with business SMEs, Business analysts, and End Users to analyze and map the Business and Functional requirements with Oracle Applications.
  • Experience in Project management activities and set up of Test Methodology in Agile and Waterfall
  • Worked on theTest Scripts, Test Cases and executing the Test Scenarios for testing in Oracle Applications.
  • Responsible for the preparation of Test plans, user training document, work instruction & OBIEE reports. Conducted System Testing, UAT and supported post Go-Live.
  • Excellent background in financials and distribution modules with an innate ability to take these functions and apply them to system implementations.
  • Strong technical skills and knowledge of DML, DDL, SQL and PL/SQL.
  • Experience of using Toad and PL/SQL Developer to manipulate SQL statements and PL/SQL blocks.
  • Well conversant with AOL and System Administration (Registering Applications, Forms, Functions, Menus, and Concurrent Programs).
  • Experience working with Web Analytics and Business Intelligence solutions.
  • Extensively used TCA (Trading Community Architecture) to create customers in Oracle Receivables.
  • Experience working with client in moving from legacy system to Oracle 11i.
  • Extensive experience on AIM (Applications Implementation Methodology) for functional and technical specification/documentation Familiar in developing Modular Design Documents like MD50 and MD70.
  • Experience in Database testing using Oracle, MS SQL Server, TOAD, Hadoop, and Teradata.
  • Performed Business process analysis & also business analyst tasks such as Gap Analysis, Business Requirements Gathering, Project Documentation and Testing.
  • Involved in all aspects of Software Development Life Cycle and Production Troubleshooting, Software, Testing, Requirement Analysis, Design Documents
  • Excellent communication (Verbal / Written) and presentation skills, Quick in grasping client’s business requirements and good at adapting to new work environment and ability to work as part of a team as well as independently.

TECHNICAL SKILLS

RDBMS: ORACLE 10g/9i/8i.

ERP/Modules: Oracle E-Business suite R12/11i/ 11.0.3/10.7 (OM, WMS, INV, PO, AR, AP, GL, FA and WIP)

Lang & Scripting: UNIX Shell Scripting, OA Framework, JAVA, SQL, PL/SQL, JSON, HTML and XML

Release Eng. Tools: CVS, VSS, PVCS.

Development Tools: TOAD, QC, QTP, ECLIPSE, Reports 6i/3.0/2.5, Forms 6i/4.5, JDeveloper XML Publisher and OBIEE (Oracle Business Intelligence Enterprise Edition)

APP/WEB Servers: Oracle Application Server OCJ4 and Oracle Weblogic.

Operating System: UNIX and Windows NT, XP servers.

Other: Microsoft Office Tools with MS Access, Html, Xml, Excel, and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential - Huntersville, NC

Responsibilities:

  • Created BR-100 Design Document for several projects like ‘Traction-MDS’,’3PL’,’Warehouse Management -Conversion’
  • Acted as liaison between management and development team for Requirements and testing.
  • Working as Functional Support Analyst, Business Analyst and Quality Tester for all the SCM and Financial modules.
  • Implementation, upgrade, and support experience on Oracle EBS R12 and 11i Supply chain modules
  • Worked on analysis and understanding of existing customizations in and around Sales Order Workbench.
  • Working with Finance Super Users /Directors on Business Enhancement Requests, creating BRD documents, coordinating UAT and production set-ups.
  • Responsible for creation of Test cases and Test plans for business unit testing, updating the functional & technical specification documents with the latest changes/upgrades
  • Worked on Order Booking, Shipping, receivable interfacing, and Invoice process cycles.
  • Entered, Booked, Manufacturing Released, Pick released the orders, Created deliveries.
  • Involved in Pending automation process, which is a customization where Service Contracts are created for the order lines with service items created in OM.
  • Involved in code reviews of the code developed, being a part of code review team.
  • Coordinated with business and development team during the various test cycles.
  • Collecting and analyzing the project’s business requirements and transferring the knowledge to the development team
  • Made modifications to the standard workflow to identify projects related PO requests.
  • Worked on accounting flex field legal entity, ledger sets, Sub ledger accounting in R12.
  • Customized Back-order Report, Customer Statement Report in AR in reports.
  • Involved in Complete Testing Cycles during the R12 upgrade process, worked with Business Users to explain with New Features in R12.
  • Implemented more TEMPthan 100 DCs to WMS from the old system (Mainframes).
  • Configure all the WMS setups for each DC until go-live and support.
  • Tested all types of WMS reports (Loading Manifesto, LPN packing slip report, warranty packing slip, shipping labels, pick to load labels etc)
  • Worked on WMS rules and setups.
  • Worked on Agile Environment attended Scrum meetings daily
  • Coordinated with the Business and technical consultant teams, for the business process understanding, unit and integration test script documentation, on-time delivery of documents, and identification and documentation of the custom objects.
  • Involved in preparing Technical Design documents to satisfy the business requirements
  • Involved in design and development of various business specific customizations in Purchasing & Order Management workflows.
  • Involved Project management activities and set up of Test Methodology in Waterfall.
  • Supported process owners with setting up of Oracle Production environment and developing Go Live plan. Provided post-production support to end users.
  • Responsible for TEMPeffective communication through progress reports, user documentation and formal presentations to teams and management.
  • Printing Custom Messages on Invoices based on customer requirement.

Environment: Oracle Applications R12 ( 12.1.3),11.5.10(GL, AP, AR, WMS, Order Management, PO, AOL and Sys Admin), OIC(R12), OA Framework, Reports 6i, Oracle 11g, ( PL/SQL), TOAD, SQL*loader, UNIX shell script, Teradata, Hadoop, Oracle, BI Discoverer, Sabrix Tax, JIRA, Mainframes, SOAPUI, Hogan, Agile and Waterfall.

Confidential, Schaumburg, IL

Oracle Apps consultant

Responsibilities:

  • Performed the whole Sales Order Cycle which includes Booking, Pick Release, Ship Confirm, Complete Line, Complete Order and Interfacing to Receivables, Inventory.
  • Worked on Return Material Authorizations (RMA), Drop Shipment Processes in Order Management.
  • Involved in implementation of Order Management (OM) interface as part of the data conversion from legacy system.
  • Involved in gathering the Customer and Item master data from users of G&PS to the offshore team for migrating the data into the iFocus 11i instance.
  • Involved in creating the interface for the Master Item between the Confidential iFocus and CTDI instance which is the inventory warehouse for the Confidential Inventory located in ELGIN.
  • Involved in creating the outbound interface between the CTDI and iFocus ( Confidential Oracle 11i instance) to get the customer orders to CTDI.
  • Back order detail report, which is used to review all customer orders that have been backordered.
  • Designed and developed a concurrent program to apply or release holds on an order or line.
  • Designed reports for shipping, listing out the deliveries created and comparing the promise and the actual delivery dates
  • Worked on Pick extract outbound, Pick Confirm and Ship confirm inbound interfaces.
  • Extensively worked in developing Functional Design Documents (MD50) and Technical Design Documents (MD70) using Application Implementation Methodology (AIM) for the business application according to the Confidential standard.
  • Customized Shipping Reports namely pick slip, Packing List and Performa Invoice in OM, and Open Purchase Orders report in PO modules.
  • Converted the customer information from legacy system into oracle Applications using custom program and API to TEMPeffect the HZ tables in TCA
  • Involved in supporting the offshore technical team for the development by gathering the requirements from the Confidential users.
  • Worked on Agile Environment attended Scrum meetings daily
  • Involved in creating the reports for the YANTRA orders for Confidential .
  • Developed Item maintenance report, which lists all the items that are currently in Inventory Organization which are either purchased or manufactured through work orders but have not yet have completed the maintenance process. This takes into account repetitive schedules and gross requirements for the assembly items and also prints order type (Demand Type), item category, Vendor name and quantity of items required. This involved OM, INV and WSH modules.
  • Involved in functional testing for the reports developed by the development team.
  • Involved Project management activities and set up of Test Methodology in Waterfall.
  • Performing AOL Tasks (Creating responsibilities, users, request groups, attaching responsibilities to users etc.

Environment: Oracle E-Business Suite 11.5.8 and 11i, Oracle 10g, Jdeveloper, PL/SQL, TOAD, SQL Plus, SQL Loader, XML Publisher and Quality Centre (QC) and OBIEE, SOAPUI, Hogan, Agile and Waterfall, Teradata, Hadoop and Oracle.

Confidential, Torrance, CA

Oracle Apps Consultant

Responsibilities:

  • Extensively worked in developing Functional Design Documents (MD50) and Technical Design Documents (MD70) using Application Implementation Methodology (AIM) from the reverse engine HP3000 (Main Frames System) documents.
  • Participated in the Unit and Integration Testing along with the end-users.
  • Interacted and Gathered information from users to build the reports according to their requirements for all the Confidential users for APAC countries.
  • Gathered the information and halped in Interfacing HP3000 (Main Frames System) systems with Oracle Applications for Order Synchronization using PL/SQL interfaces.
  • Developed picklist, packlist, PO cancel, PO summary/Detail and Payment Invoice XML reports.
  • Productions go live support and bug fixing and responsible for resolving the production support tickets.
  • Participated in testing of new modules and revised program codes that implement meta-rules tables for territory assignment in a global order capture system.
  • Responsible for documenting the mapping and requirements for the interfaces and conversions between the third party system Convey and oracle Applications.
  • Developed Reports in OM and shipping like summary, Detail report for Orders cuts and returns, Developed reports in Shipping: Bill of Lading report and Pack list Report.
  • Worked on Interfaces to import items and item data (item attribute, item number) from existing system in to Oracle Inventory through Item Import Interface.
  • Involved in testing all the oracle reports comparing with HP reports and created theTest Scripts, Test Cases and Executing the Test Scenarios for all the Year End Tax Reports.
  • Gathered the requirements from the users to create the US and Canada 1042 and 1099 Year End Tax Reports.
  • Involved Project management activities and set up of Test Methodology in Waterfall.
  • Production Support of interfaces/day to day operations/Month End Close/Quarter Close/Year-End Close support.
  • Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
  • Performing AOL Tasks (Creating responsibilities, users, request groups, attaching responsibilities to users etc.
  • Performed the full configuration, testing, documentation, training, and post-production support of the following modules

Environment: Oracle E-Business Suite 11.5.10, Oracle 10g, Oracle Reports/Forms 6i, PL/SQL, UNIX, Oracle BPEL Process Manager, TOAD, SQL Plus, SQL Loader, XML Publisher and Quality Centre (QC), Agile and Waterfall, Teradata, Hadoop and Oracle.

We'd love your feedback!