SUMMARY

• Around 9.6 years of IT experience wif extensive experience in design, development, testing and implementation of Oracle Applications.
• Experience in full cycle implementations and upgrade of Oracle Applications as a techno - functional consultant includes various Oracle Applications modules like Supply Chain Management (INV, BOM, OM, OSFM and PO), CRM Modules(Service Contracts, Install Base), ASCP and Financials (AP, AR, GL and FA ) and all aspects of Application Object Library (AOL) and Sysadmin.
• Very strong technical and functional experience in implementing, upgrading and customizing Oracle Modules (11.10.5) & R12 in large.
• Experience in Development and Support of both Development and Production Systems.
• Strong design and development experience on Open Interfaces (inbound and outbound interfaces), APIs and RICE components.
• Worked extensively on Oracle Reports, Interfaces, Conversions, Customizations, Forms, OAF, Discoverer, OBIEE, XML Publisher, Forms Personalization, Custom.pll and Workflow in financials, manufacturing modules and Oracle SCM.
• Experienced in Analysis, Implementation, Design, Development, Customization, Upgrade, Integration, Testing and Support of Oracle Applications as part of full cycle implementation.
• Proficient in functional noledge of Order to Cash, Procure to Pay and Financial business processes wiforder to cash(O2C), procure-to-pay(P2P) and END-ENDcyclesofOracle Applications E-Business Suite and accounting-to-financial reporting functions. This halped a lot to bring TEMPeffective processes in place, reduce costs wif less headcount and make teh process more efficient for clients.
• Well conversant wif AOL and System Administration (Registering Applications, Forms, Functions, Menus, and Concurrent Programs).
• Extensive experience in Functional Analysis, Application Implementation and Upgrades Including understanding Business Process reviews and Requirement Definition, Gap Analysis, Customization Analysis, Preparation of Training Material, Data Conversion, Pilot Planning, Preparation of Test Strategies and Test Plans, Training and Post Implementation Support. Experience in teh preparation MD50, MD70, and TE40 AIM documentations.
• Extensive experience on AIM (Applications Implementation Methodology) for functional and technical specification/documentation Familiar in developing Modular Design Documents like MD50 and MD70.
• 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

Oracle Technologies: Oracle Database, Java, SQL, PL/SQL, Forms(6i, 9i, 10g),Reports, XML Publisher, Discoverer, OA Framework, and OBIEE.

Application: Oracle Applications Supply Chain (INV, BOM, OM, WIP, OSFM, Shipping, PO), ASCP and Financials (AP, AR and GL), Service Contracts, Install Base

Languages: Java, PL/SQL, SQL, UNIX Shell Scripts.

Skills: Object oriented design, Oracle DBA, Relational Database design, Reverse Engineering,able to gain competency in new technical skills quickly.

Operating System: UNIX and Windows NT, XP servers.

PROFESSIONAL EXPERIENCE

Sr. Oracle Techno Functional

Confidential

Responsibilities:

• Customer Creation
• Install base Premise instance creation (representing teh property).
• Quote/Sales Order
• Service contract creation- service agreements
• Invoice Creation
• Reviewing Functional Specifications wif teh client
• Performing Gap-fit Analysis. Prepared MD50’sand validated it from business.
• Analyzed business needs, user requirements and specifications in Order Management, Service Contracts, Install Base, Inventory
• Prepared MD70 Technical document for Orders, Service Contracts and IB
• Reviewed teh Business Requirements documents wif teh business and development teams and analyzed teh functionality of teh Oracle applications so as to finalize teh solution
• Designed and developed custom Interfaces for Service Contracts, adding new lines to contract and delete old lines from existing contracts
• Implemented customizations for Order Management Workflows
• Designed and implemented customizations for Install base
• Designed and developed AR Interface which runs on daily basis and file will be uploaded and data is stored in Oracle using API and interfaces tables invoices are created.
• Designed and developed Custom AR Invoice Report based on requirements and layout format suggested by client Summary report and Detail report.
• Custom Order Management Reports showing header and line level attachments attributes and logo of company on teh report

Consultant, Oracle Applications

Confidential, Rochester, New York

Responsibilities:

• Reviewing Functional Specifications wif teh client
• Performing Gap-fit Analysis.
• Analyzed business needs, user requirements and specifications in Order Management, Shipping and Inventory Management
• Reviewed teh Business Requirements documents wif teh business and development teams and analyzed teh functionality of teh Oracle applications so as to finalize teh solution
• Organized cross training of team members and users on teh Oracle applications
• Setting up promotional modifiers
• Setting up discount modifiers
• Setting up modifiers for coupons, buy one get one free scenarios and accruals
• Preparing detailed design documents as per teh functional requirements
• Setup and Configuration of Modules OM, BOM and WIP
• Interacting wif teh client regarding data mapping of teh requirements
• Financials
• Developed an interface for Unapplied Receipt Amounts against open invoices.
• Developed an interface for Credit Memo Transaction Register.
• Worked on Conversions which involved Customer, Receivables, Payables, Supplier.
• Customized Account Analysis Report both 132 and 180 characters in GL Ledger.
• AR to GL Reconciliation Report, both Summary and Detailed.
• OM, Shipping Execution
• Dock Scheduling: User-friendly Custom Screen which automates and streamlines teh delivery appointment process, thus eliminating delays and saving valuable time while arranging for a dock appointment.
• Features:
• Reduces carrier wait-time and minimizes demurrage.
• Eliminates dock congestion.
• Real-time visibility and communication.
• Provides visibility of dock utilization and scheduling performance.
• Create Trips for outgoing docks.
• Modified teh Sales order Workflow to allow booking of sales order only when their is at least one taxable item.
• ASCP
• Pegging Report: Designed and Developed Report in BI Publisher which gives all teh information about availability of Raw Materials of a Planned Order and Work Order of a Finished Good.
• JIT Customization: Customized teh standard package msc release hook.extend release to order raw materials Just in Time instead of stocking them at teh inventory.
• Ran Data collection for planning.
• Designed and developed BI Reports in all INV, BOM, ASCP, OM, AP, AR, PO Modules.

Consultant, Oracle Applications

Confidential, California

Responsibilities:

• Technical resource in Financial GL and AP conversion
• Modules involved: Financial GL/AP/AR/PO/OM/INV/BOM/Shipping
• Developed forms which involved
• Customized PO workflow to make sure only some custom PO’s are sent as mail attachment every time PO is Approved.
• Developed reports using XML Publisher and Discoverer and Procedures for Physical Inventory which takes place every 6 months for testing teh system accuracy and making teh quantities adjustment accordingly.
• Technical skills involved: INV, BOM, OM, PO, WIP, PL/SQL, Java, Forms, XML Publisher, Workflow and Discoverer.
• Performed all of teh setups for Order Management(OM), Inventory, Purchase Order.
• Worked on User requirements gathering, design solution, development and testing.
• Preparing System / Integration Test cases and carrying out Integration testing
• Supporting teh users wif teh User Acceptance Testing (UAT)
• End-user training
• Provided Production Support after Go Live.

Consultant, Oracle Applications

Confidential

Responsibilities:

• Technical skills modules involved: Oracle WMS, Inventory, Order Management, Shipping
• Conversions dat involved
• Inventory (Items, Costs, On-hand Conversion)
• Bills Of Material (BOM, Routing Conversions)
• Order Management (Open and Closed Orders Import)
• Account Receivables (Customers and Open AR Conversion)
• Account Payables (Vendors and Open AP Conversion)
• Price List
• CRM (Install Base and Service Contracts Conversion)
• General Ledger
• HRMS (Worked on all conversions in HRMS) dat includes
• Employee Conversion
• Elements Conversion
• Cost Conversion
• Employee Contacts

WIP/OSFM Consultant

Confidential

Responsibilities:

• Design and develop Physical Inventory interface to do teh quantity adjustments.
• Performed all INV, BOM, OSFM, PO, OM Setups.
• User Training of end to end process.
• Developed forms dat involved