SUMMARY

• 8+ years of IT Experience as an Oracle Applications Consultant in Design, Development, Testing, Post implementation, maintenance & Up - gradation.
• Experience in Oracle Apps R12/11i modules that include Order Management(OM), Purchasing(PO), Inventory (INV), Shipping(WSH), Advanced Pricing(QP),Warehouse Management(WMS), Bills of Material(BOM), Configurator(CZ), iProcurement, General Ledger(GL),Account Payables (AP),Account Receivables(AR),Fixed Assets (FA),Costing,WIP,AOL, HRMS, TCA, Workflow, EDI & XML Gateway.
• Knowledge of Install Base, Service Contracts, Field Services & Telesales
• Adept in Business Cycles - Order to Cash (O2C) and Procure to Pay (P2P).
• Involved in designing Technical Design Document and Requirements Document
• Oracle Certified Associate (OCA) with expertise in SQL,PL/SQL, Oracle Reports & Forms 6i/9i/10g, Workflow, JAVA, XML & OA Framework
• Proficient in writing PL/SQL Functions, Procedures, Packages and Triggers.
• Experience with Other Tools: TOAD, SQL * PLUS, Forms & Reports Builder, Work flow builder, Oracle Discoverer, XML Publisher, BI Publisher & QTP.
• Extensively worked on all the RICEW components.
• Extensive experience in Database query tuning, Performance tuning (TK-Prof, explain plan and schema statistics)
• Extensive experience in UNIX Shell Scripting, good understanding and knowledge of SOA & BPEL
• Experience in all phases of SDLC that include Requirement Analysis, Application Design, Development, Implementation and Maintenance
• 4+ years of experience in creating and tracking the TARs, SRs
• Detailed Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Adept at all stages of project life cycle including gathering business requirements, developing technical definitions (interfaces, conversions) and testing.
• Outstanding organizing, detail orientation and customer/client service skills.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, JAVA, Java Script, XML, HTML, C, C++

ERP: Oracle applications EBS R12/11i OM, INV, PO, WSH, WMS, WIPQP, BOM, CZ, GL, AP, AR, FA, WIP, AOL, HRMS, TCA, EDI

Databases: Oracle 11g/10g/9i/8i

GUI Tools: Developer 2000 Forms & Reports

Operating Systems: Windows 2000/NT, XP, ME, 9x, Linux, Solaris 5.8

Tools: SQL * PLUS, TOAD, SQL Developer, Forms & Reports builderWorkflow builder, SQL * Loader, Oracle Discoverer, JdeveloperXML Publisher, Informatica, QTP

PROFESSIONAL EXPERIENCE

Oracle Apps Techno-Functional Consultant

Confidential

Responsibilities:

• Actively participated in gathering requirements for building reports using Qlikview and implementing Oracle Configurator.
• Involved in automation of RMA to send the NAFTA and Canada Customer’s Invoice XML reports when booking an RMA.
• Involved in creating the BOM’S and configurator rules when implementing the Configurator for Houston OU.
• Involved in creating the Items through master item form and costing setup for Oracle Configurator Implementation.
• Created form personalization’s to meet the business users requirements for Orders and ASN’s
• Provided the solutions and resolved the tickets logged by business users or CSR’s in modules OM, INV, AR, WSH, CZ and PO
• Created XML reports to provide the order metrics information
• Involved in creating the Oracle Discoverer business areas and workbooks
• Involved in extracting the Sales order history, Order Shipment Backlog and Quote to Order Transitions data for building the reports using Qlikview tool.

Oracle Apps Techno-Functional Consultant

Confidential

Responsibilities:

• Actively Participated in gathering the Requirements from the Business Users for building the Interfaces and RICE Components.
• Handles all the issues related to Order to Cash for ordered imported using HVOI.
• Involved in design and review of functional set ups of OM, PO & INV
• Created Internal Requisitions and executed the ‘Create Internal Orders’ program to populate the internal orders in OM interface tables
• Extensively worked on Regular Sales Orders, Internal Sales Orders, RMA, Drop Ship Orders, Configure to Order, Back to Back Orders and Assemble to Order cycles.
• Work on Performance Improvement and tune queries for best optimal performance.
• Involved in modifying the form, changing the existing packages, procedures, and functions.
• Prepared test plans, training manuals & tested the functionality
• Co-ordinate with the customer and project manager to analyze the new requirements and document them.
• Conduct weekly status meetings.

Confidential

Responsibilities:

• Responsible for gathering and analyzing Functional Requirements. Converted them to Technical design documents
• Involved in design and review of functional set ups of OM, WSH, AR & INV.
• Performed the actions of Launch pick release, auto create deliveries and trips, assign/unassign from trip or delivery, ship confirm delivery and launching Interface Trip Stop (ITS) for the order line to be shipped.
• Studied the feasibility of reusable PL/SQL components and implementing as per the current requirement by creating new procedures, functions
• Prepared test plans, training manuals & tested the functionality
• Conduct weekly status meetings.

Confidential

Environment: Oracle Apps 12.1.1 OM, AR,Workflow, INV, PL/SQL, UNIX, Oracle Database 11g Tools: SQL * PLUS, TOAD, Forms Builder, Workflow builder

Responsibilities:

• Responsible for gathering and analyzing Functional Requirements. Converted them to Technical design documents
• Involved in design and review of functional set ups of OM & AR
• Worked in Revenue Cycle with Multi-Currency.
• Set up transaction types, invoices, guarantees, deposit, and credit memos, debit memos.
• Assigned receivable account, revenue account, unbilled account, freight account, clearing account, and unearned account to transaction types.
• Defined the Cash Discounts, which will calculate the discounts for the customers for early payments.
• Defined Split payment terms for invoice installments that have different due dates and assigned multiple discounts to each payment line.
• Created invoice by running the ‘Auto Invoice’ and performing all the required setups for successful completion of ‘Auto Invoice’
• Created two new Sales Order Line workflow processes and created new procedures and coding underlying functions that will be invoked by the new workflow
• Prepared test plans, training manuals & tested the functionality

Confidential

Environment: Oracle Apps 12.1 OM, WSH,Workflow, INV, PL/SQL, UNIX, Oracle Database 11g Tools: SQL * PLUS, TOAD, Forms Builder

Responsibilities:

• Responsible for gathering and analyzing Functional Requirements. Converted them to Technical design documents
• Involved in design and review of functional set ups of OM & WSH
• Performed set up steps related to shipping in Order Entry (delivery and delivery lines concept)
• Worked on Inbound and Outbound interfaces between Legacy systems and Oracle Order entry module.
• Worked on Ship Confirm interface, Material transactions interface & Receiving Transactions interface.
• Defined freight Charges and Freight carriers to specify on order.
• Worked with agreements to define agreements with Customers that let you define the prices, payment terms and freight terms
• Involved in Pick/Pack/Shipping process.Partial/Batch Reservations, Packing Process with Serialization, Trip Organization, Ship Confirmation
• Created new API & modified the existing procedures and functions for achieving the desired behavior by
• Created new checkboxes on Copy form and coding the corresponding trigger.
• Prepared training manuals & tested the functionality
• Conduct weekly status meetings.

Confidential

Responsibilities:

• Architected/Implemented the Plan design setup - Plan Certification module of Oracle Fusion Benefits using Oracle ADF Tech Stack.
• Working closely with Product Management teams to understand ever-changing business requirements in Plan Certifications module and to in corporate them in the product.
• Worked Technical Design Documents (TDD) for Plan Design setup.
• Develop and execute system unit, integration test plans.
• POC for deployment issues on behalf of my team. Working closely with Release and Versioning team for Integration with other Modules of Fusion HCM.
• Responsible for migrating existing ADF applications to ADF 11g.
• Identified the performance bottlenecks, memory issues in the application and corrected the code/architecture to fix the issues.