SUMMARY

• Around 9.6 years of IT experience with 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 knowledge of Order to Cash, Procure to Pay and Financial business processes withorder to cash(O2C), procure-to-pay(P2P) and END-ENDcyclesofOracle Applications E-Business Suite and accounting-to-financial reporting functions. This helped a lot to bring TEMPeffective processes in place, reduce costs with less headcount and make the process more efficient for clients.
• Well conversant with 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 the 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 the property).
• Quote/Sales Order
• Service contract creation- service agreements
• Invoice Creation
• Reviewing Functional Specifications with the 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 the Business Requirements documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the 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 the report

Consultant, Oracle Applications

Confidential, Rochester, New York

Responsibilities:

• Reviewing Functional Specifications with the client
• Performing Gap-fit Analysis.
• Analyzed business needs, user requirements and specifications in Order Management, Shipping and Inventory Management
• Reviewed the Business Requirements documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution
• Organized cross training of team members and users on the 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 the functional requirements
• Setup and Configuration of Modules OM, BOM and WIP
• Interacting with the client regarding data mapping of the 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 the 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 the Sales order Workflow to allow booking of sales order only when there is at least one taxable item.
• ASCP
• Pegging Report: Designed and Developed Report in BI Publisher which gives all the information about availability of Raw Materials of a Planned Order and Work Order of a Finished Good.
• JIT Customization: Customized the standard package msc release hook.extend release to order raw materials Just in Time instead of stocking them at the 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 the system accuracy and making the quantities adjustment accordingly.
• Technical skills involved: INV, BOM, OM, PO, WIP, PL/SQL, Java, Forms, XML Publisher, Workflow and Discoverer.
• Performed all of the 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 the users with the 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 the quantity adjustments.
• Performed all INV, BOM, OSFM, PO, OM Setups.
• User Training of end to end process.
• Developed forms dat involved