SUMMARY

• Overall 8 years of experience as Oracle Applications E - Business Suite as an Techno-Functional Consultant in Design, development and implementation of Oracle Applications.
• Extensive experience in Oracle EBS Supply chain Modules SCM (OM, PO, Quoting, Advance Pricing, INV, WMS, WSH, iProcurement), Manufacturing Modules (BOM, WIP, Costing), Financials (AP, AR), iSupplier, iReceivables and good knowledge on Mobile Supply Chain Applications(MSCA).
• Strong Knowledge on Procure to Pay and Order to Cash Business Processes.
• Experience on iProcurement for purchase requisitions and catalog management.
• Functional expertise in Oracle Applications with Implementation, Upgradation, Testing and Post Production Support of Procurement and Supply chain modules.
• Adapting to the business process and design, development of the custom requirements to fulfill the business needs.
• Involved in the setup, testing and support of Oracle Approval Management (AME) for purchase requisitions.
• Experience in writing/debugging Oracle SQL PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Constraints, Indexes, Views, Materialized Views, Database Links, and Sequences.
• Worked on implementing various versions/upgrades of Oracle Applications 11i E-Business Suite to R12.
• Experience in entire phases of Software Development Life Cycle SDLC such as Analysis, Process engineering, Design, Development, Deployment, Testing, and Support.
• Expertise on Application Developer, System Administration, Oracle Workflow Administrator and Oracle Alert (ALR).
• Proficient in design, developing Data conversion Programs, validation programs and Interfaces.
• Worked with UNIX shell scripting to automate the execution of the batch processes.
• Worked with various Oracle Application Development tools including Reports Builder, Forms Builder and Discoverer.
• Strong Working experience on Oracle XML Publisher, developing the XML Reports in Microsoft word and integrate to the Oracle Applications EBS.
• Proficient in developing Custom Forms and Customizing standard Forms. Experienced in Form Personalization and Custom.pll
• Well experienced in customizing standard Oracle Workflow and Troubleshooting issues related to Workflows in the process flows.
• Worked on design of inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs).
• Worked on Oracle E-commerce Gateway.
• Worked on building interfaces via EDI with the trading partners.
• Developed 855 Po Acknowledgment interface.
• Involved in design and development of EDI 875 Grocers purchase order, EDI 888 Item maintenance, EDI 861 for PO receipts.
• Developed 856 Advance Shipment Notice for Purchase Orders.
• Worked in different client environments and Production support projects handling wide range of issues due to incorrect setup, Data dependencies, Struck transactions etc., Handle them accordingly.
• Excellent writing skills to create business requirements and functional specifications document.
• Experience in writing MD50, BR100, MD70, MD120, CV040 and test case documents using AIM Methodology.
• Closely work with the client to gather the requirements efficiently.
• Well versed with oracle support, opening of SRs, maintaining SRs and bug fixing, Conducting OWC sessions and working 24/7 to resolve high priority issues.
• Well experienced in Onsite/Offshore model.
• Self-Starter and ability to work independently without any supervision.

TECHNICAL SKILLS

ERP Applications: Oracle Applications R12/11i Order Management(OM), Purchasing(PO), Advanced Pricing, Inventory(INV), Warehouse Management(WMS), Shipping(WSH), Payables(AP), Receivables(AR), iProcurement, iSupplier, iReceivables, Application Developer, System Administrator, Oracle Alerts, Approvals Management Engine (AME), HRMS, Mobile Supply Chain Applications(MSCA).

Programming Languages: SQL, PL/SQL, UNIX, XML.

Database: Oracle 9i/10g/11g.

Tools: TOAD,SQL*Developer, SQL*Loader, FND LOAD, SQL*PLUS, Forms & Reports 10g/6i, Oracle Discoverer10g, XML Publisher, Workflow Builder, Putty and various Ticketing tools.

Operating System: Windows

PROFESSIONAL EXPERIENCE

Confidential, Keene NH

Oracle Applications Functional Consultant

Responsibilities:

• Design and involve in the all-round development of various interfaces between multi layered business structures.
• Worked for in integration of three business acquisitions of Confidential &S in Oracle.
• Requirement gathering, Design and coordination with development teams, middleware teams in development of integrations of new business acquisitions.
• Documenting the requirements in MD50 for various interfaces according to business requirement and discuss with development team.
• Involved in pre development activities and post development testing, validation and training wherever required.
• Creating functional requirements as an input to application design and test documents.
• Coordinate with teams, help them to understand the customer requirement and provide the solutions.
• Closely interacted and assisted with users during UAT sessions in executing process documents.
• Handled Vendor interface from the discussion stage. Gathered requirement, Created MD50 and data mapping, business conditions to be implemented in the design. Post development testing and deployment.
• Worked on vendor custom User defined attributes (Vendor UDAs) in oracle.
• Involved in Deals interface to send all the eligible pricing modifier along with the qualifier information to the target system.
• Handled Price list and item interface to the target system.
• Tested the interfaces in all the scenarios along with automation of data transfer to target system using ETL as middleware. Prepared required test case documents.
• Worked on EDI 888 Item maintenance, EDI 861 PO receipts integration to a target system that processes perishable goods.
• Worked on EDI 875 to communicate Grocery product POs to vendors. This includes all the PO information with price adjustments and promos.
• Worked on item product information management (PIM) in oracle.
• Effectively made use of concept called Value maps where ever required to turn on/off the data according to various businesses of Confidential &S.
• Supported Purchase order interface of various kinds of POs where Source system has the Functionality of reusing the PO numbers.
• Supported regular and perishable kind of POs which has a different organizations and business process. Issues related to pricing, Item management and vendor site.
• Coordinate with cross functional teams to handle various issues related to the POs and receipt transactions.
• Worked on enhancements to the process to create requisitions from an internal tool Micromain system.
• Involved in code review discussions with development teams.
• Involved in Post production support after Go-Live to stabilize the newly implemented processes.
• Interacted with buyers and vendors on various issues in the process to give them timely support.
• Proactively interacted and supported cross functional teams in their support activities.

Confidential, Bedford MA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Performed Requirement Analysis, System Design, Coding, Testing and Implementation.
• Worked on the functional setup based issues which hinder the smooth flow of the Sales order.
• Process the Sales orders which have issue due to the customization done by building scripts. Later working on the root cause of the issue to fix it.
• Working with the Finance team in implementing revenue recognition on bundle items and work on the include bill items in BOM.
• Worked on various issues related to routing and enhancements in the jobs, resources.
• Setup a OM line transaction type and associate the related workflow and order type to it.
• Customized the Order Lines (OEOL) and Order Headers (OEOH) workflows, when Order is booked, then will send some notifications to the Quality team for checking the order lines information like items, quantity, shipment date etc for certain flows.
• Customized the Order Line level workflow, which will hold the order lines till all the lines are fulfilled for some order types.
• Worked on both BOM and ATO/PTO Models Flow in OM
• Prepared categorized iProcurement catalog for different kind of items used in the company
• Worked on the issues related to the requisition approval based on AME rules and the custom approval groups.
• Worked on custom holds to be placed on the order lines according to client requirement.
• Worked on enhancements to the existing application based on client requirements.
• Involved in PO Approval workflow for sending approval notifications to Buyer and approver along with the preparer, using workflow builder.
• Form personalization to default and restrict data based on the OM Order transaction type.
• Setup formula based defaulting rules to default a specific warehouse for a particular RMA order type.
• Setup DFF field structure to capture additional data in various forms.
• Create and add different context values based fields in the DFF.
• Create valuesets and assign them to DFF field definitions.
• Work on updating pricelists with a minor enhancement.
• Creating modifiers and qualifiers for price adjustments according to the requirement.
• Created and customized reports using XML Publisher/BI Publisher in OM, BOM, PO, AP, AR, WIP and INV.
• Functionality testing of various enhancements and customizations. Documenting the test cases.
• Moved various foundation objects from one instance to other using FNDLOAD. Including forms, form personalizations, Responsibilities, Menus, Concurrent programs, lookups, value sets and XML publisher templates.
• Used UNIX shell scripting for automating various tasks.
• Proper documentation of business requirement, enhancement, Testing and migration.
• Maintain the documents in the client SharePoint with proper version.
• Wrote business requirements documentation for Order management setups.
• Worked with the client to help them in making decisions on customizing OM module.
• Created Service requests with oracle support and worked towards solving critical issues.

Confidential, NY

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in Setup, integration and testing of warehouse management systems (WMS) to EBS.
• Developed Forms and Reports as per the client requirement.
• Worked on Inventory and pricing setups to create pricelists, shipping networks. Monitoring the inventory transactions.
• Worked on Discoverer reports using Discoverer Administrator to create various workbooks that users can use them to generate different reports of their choice.
• Worked on pricing modifiers and qualifiers create various discounts according to the client requirement.
• Created a custom hold for RMA orders to be notified and inspected by concern personal.
• Developed procedures and SQL queries to capture data upon a user ticket.
• Created some of the Alerts for sales orders and Inventory items.
• Build the business case for a proposed solution to address the customer’s business needs.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Coordinating with the offshore team and help them in requirement analysis, development and testing.

Confidential, Germantown NY

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Worked extensively on resolving critical issues relating to Sales Order creation, order pricing, holds, credit checking, workflows and custom process, picking, shipping, tax codes, Auto invoicing, Purchase Order creation, PO / Requisition Approvals, Approval Assignments etc.
• Visit Client location to gather requirements in building SCM interfaces via EDI with the trading partners.
• Developed 855 Po Acknowledgment interface.
• Developed 856 Advance Shipment Notice for Purchase Orders.
• Setup Modifiers and Qualifiers in QP.
• Define Pick Release rules, Shipping Parameters.
• Worked on setups in Inventory, Order Management and Purchasing modules.
• Established a Item Category and Item Cataloging for their products.
• Created Customer Item and Customer Item Cross Reference
• Developed defaulting scenarios for a particular order type using form personalization of Sales order form.
• Involved in adding new descriptive flex field in Order Management to capture additional data.
• Worked on enhancements and extensions to existing functionality as per BRD / MD-50
• Developed XML report for sales order report in order management.
• Extensively worked with Oracle to create SRs for Production issues.

Confidential, Boston,MA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in implementing various business process extensions of Order-to-Cash and Procure-to-Pay cycles as per the business requirements.
• Loading Catalogs into iProcurement. Actively participated in the implementation of Punch-out.
• Workflow customization in Purchasing Module i.e. PO Requisition Approval and PO Approval.
• Modified OM Order Header Workflow to trigger Booking Acknowledgment program when the order is Booked.
• Working on Lot Controls, Items, Picking, Shipping, pricing, transaction types in Oracle ERP.
• Worked on customer related setups and any modifications to the existing customers.
• Worked on Order defaulting rules to default the Order Header and Order Line level fields like Freight Terms, Warehouse.
• Worked on Sales order issues due to invalid/end-dated salesrep.
• Customized reports like Printed Purchase Order Report and Printed Requisitions.
• Developed XML/BI Publisher reports for standard purchase order with 2-Way 3-Way- 4-Way matching, Customer aging report.
• Converted Oracle 6i Reports to BI Publisher reports.
• Involved in various interface processes.
• Developed and Customized Forms, Reports, PL/SQL Procedures, Triggers and Functions.
• Personalized the Shipping transactions form to disable serial number changes.
• Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Worked on Metalink to raise and track Service Requests to Oracle.
• Working with Oracle on SR management on high priority issues parallely.
• Perform pre-patch analysis on the suggested patch by oracle. Coordinate with DBA in applying the patch in near-clone instance and perform impact analysis with test scenarios on different objects. Application of patch in production after successful test.
• Rectified the errors in the log file and loaded the data into the interface tables using SQL*Loader.
• Prepared Deployment documents for moving custom developed reports and forms from the development instance to production after code testing.
• Coordinated knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.
• Worked on Sales order related issues in the order life cycle.
• Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting task deadlines. Facilitated discussions with end-users / managers to gather functional requirements.
• Performed pre-clone and post-clone activities on the production clone instances.

Confidential, Austin TX

Oracle Applications Technical Consultant

Responsibilities:

• Involved in upgrading process from 11i to R12.
• Identifying the list of all custom objects those needs to be migrated from 11i to R12.
• Used FND LOAD extensively for downloading LDTs for form personalization migration to TEST, UAT and production environments.
• Re migrated all custom objects (procedures, forms and reports) into R12.
• Designed and developed Interface Programs to import orders from legacy system using Order import into Order Management.
• Involved in post upgradation support by raising various SRs with Oracle and attended OWC sessions explain them the issue and provided 24/7 support to obtain business critical issue resolution.
• Directly communicated with oracle support for bug fixing.
• Identified gap between 11i to R12 for new features MOAC and SLA and incorporated these in R12 Objects.
• Supported for the production issues, resolving them on a timely basis based on ticketing system prioritization.

Confidential, Bedford MA

Oracle Applications Technical Consultant

Responsibilities:

• Overseeing project implementation and process changes.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Coding for the Interface programs to extract data into flat file and uploading of data files to the media application.
• Fine tuning the SQL Queries to improve the speed of program execution.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully.
• Ensured the programs, scripts, procedures fully tested to ensure bug free performance.
• Performed SQL Performance tuning.
• Developed Forms and Reports as per the client requirement.
• Build the business case for a proposed solution to address the customer’s business needs.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in customization of standard Oracle reports in AR, AP and GL as per client requirements using Oracle Reports.
• Registering Concurrent Program and Forms. Supporting the Issues from various customizations (forms, reports, and interfaces) during the test cycles on priority basis.
• Developed several adhoc queries in TOAD and Oracle alerts for my Business Analyst needs.