Summary




9+ years of Total experience as Oracle Applications consultant
Functional responsibilities : Working on RFPs, Business Flow designs, Workshops, Business interaction, As is Analysis, requirements gathering, functional gap analysis, solution design, configuration, module setup, testing and deploy activities, planning and executing data conversion activities, test script generation, writing training guides, training super users and production support.
Expert in the Following Modules : Install Base
Service Contracts
Sales Contracts
Core Contracts
Tele service
Field Service
Order Management
Inventory
Mobile Field Service
Depot Repair
Spares Management
Knowledge Base
Sufficient Knowledge in the following modules
Accounts Receivables
Advanced Pricing


Employment

December, 2008 -  Present

Environment : Oracle 11.5.10, Service Contracts, Sales Contracts, Install Base, Tele service, Depot Repair, OM, INV, AR
Role and Responsibilities : Conducted Requirement Gathering workshops, CRP, UAT sessions in multiple locations
Worked with the business team to finalize the sales contract Terms and conditions
Re designed the OM workflow for OM to have a link to the PDF version of sales contracts
Enabled the sales contracts from quoting module
Designed the sales contracts template
Re designing the OM transaction type to enable sales contracts
Setup terms library, protected clause for terminations
Designed the Business process for the Warranty Process which helps the company to stop revenue leakage
Designed the Business process for Calibration Contract and to track the calibration readings which helps the company to track the correct entitlement

Designed a Monthly Accounting rule to auto recognize the deferred revenue and other SC related finance setups
Designed a Custom Invoice Report specific to Service Contracts
Designed a upgrade process covering Tele service, Depot Repair, OM, Service Contracts, IB
Designed a warranty creation and extension program for existing units and for future
Designed Multi serial number Senior which facilitated to avoid lots of customer confusion
Involved in the P2P Optimization Project s requirement gathering

May, 2008 -  December, 2008

Environment : Oracle 11.5.10, SIEBEL, Install Base, Tele service, Field Service, Knowledge Base, Service Contracts, OM, INV
Role and Responsibilities : Conducted workshops, CRP, UAT sessions in multiple locations
Designed the Business Flows for the Implementation process, Maintenance process
Dismantling Siebel and bringing all the functionality to oracle
Mapped the Siebel concepts for Regional Account, Systems, Assets to oracle Install Base
Requirement gathering and workshops for Implementation of IB, KB, Tele service, FS
Introduced the T and M Quoting concept using charges module
Mapped the Siebel concepts for Regional Account, Systems, Assets to oracle Install Base
As a first phase, KB was implemented only for the internal company
Designed KB article conversion from Primus
Suggesting solutions for TCA related issues
Designed the functional specifications for the custom programs

March, 2008 -  April, 2008

Environment : Oracle R 12, Install Base, OM, BOM, WIP
Role and Responsibilities : Requirement gathering and workshops for Implementation of IB
Implemented IB to reflect the RMA process
Implemented the multilevel BOM explosion into IB for ATO items

Mainstream energy, CA January 2008 to March 2008

Environment : Oracle R 12, Install Base, Service Contracts, Sales Contracts, OM, INV, PO
Role and Responsibilities : Requirement gathering, Design and Project Management
Conducted workshops and demonstrated IB and Service Contracts
Worked as cross functional in the business critical areas
Leading the offshore team and on site team for delivery of conversions
Designed Customer, Item, Invoice, Sales Order, PO conversions
Set up the OM transaction types to include Contract templates, Layout templates
Included the Sales Contract approvers in the approval list
Blanket Sales Agreements were used extensively
Used system defined variables in the clause
Setup sales contract to order flow
Setup sales contract for 1 time orders

November, 2007 -  January, 2008

Environment : Oracle R 12, Service Contracts, Install Base, Advanced Pricing, Inventory, AR, High Deal
Role and Responsibilities : Single finished the mini implementation for the RFP
Solutions for the Complex rating business using IB counters and Service Contracts
Interacting with the 3rd party rating tool company High Deal for an integrated solution which increases the scalability of Oracle Service Contracts
Multiple workshops and demos to become 1 of the 2 finalists

February, 2007 -  October, 2007

Environment : Oracle 11.5.10, Service Contracts, Install Base, Depot Repair, Knowledge Base, KNet, Order Management, INV
Role and Responsibilities : Single implemented the Sales Contracts, Service contracts, Install Base, Depot Repair
Changed the legacy contracts management and billing system to Oracle SC
Integrated their Knet application systems to Oracle Install Base
Implemented Knowledge base for their internal employees
Involved in Item, Price Setup
Configured BOM, Inv and OM to implement warranty contract and service agreements

Training documents are converted into Oracle KB

Depot repair was the other key module. Explored lot of new ideas in DR
Based on our interaction, even Oracle standardized their DR module and made significant changes in their product

August, 2006 -  December, 2006

Environment : Oracle 11.5.9, Service Contracts, OM, Siebel, TITAN, Advanced Inbound, email center
Role and Responsibilities : Involved in the service contracts application setups
Replace Siebel with Oracle
Implemented the contact ID, Temporary Entitlement concepts from Siebel to Oracle as per the Symantec requirements
Titan VERITAS' case tracking system Oracle ERP Integration
Implemented the concept of Support Identifier in oracle.
Designed the integration between Titan and Oracle for Titan PFS orders

Implemented the concepts of Welcome Letters, Support Certificates.

November, 2005 -  August, 2006

Environment : Oracle 11.0.3, Oracle 11.5.10, Service Contracts, IB, OM, Inventory, E Quotes
Tele service, Advanced Inbound, email center, Oracle Knowledge Base
Role and Responsibilities : Involved in the service contracts application setups
Involved in the PBX Advanced Inbound Integration process
Enabled the customized interaction keys for the PBX

Involved in the email center setup activities like classifications, routes, New Intent setup
Designing the to be email accounts, resource groups
Involved in setting up the knowledge base
Up gradation from 11.0.3 to 11.5.10 OM Service Contracts
Designed the Integration between Order Management 11.0.3 and Service Contracts 11.5.10.
Contracts is created in 11.5.10 for the orders from 11.0.3
De booking and Rebooking of contracts based on the 11.0.3 Sales Order de book and rebook.
Implemented the custom billing schedule concepts of Warranty, Warranty Upgrade, Concession, Prepaid policies
Designed custom contracts renewal process
Designed the custom EOSL End Of Service Line Program
Suggested and Designed the Custom form for defining the default service item
Involved in the service contract data conversion design from the merged companies Legato, Documentum, Win peak, RTS

November, 2004 -  October, 2005

Environment : Oracle 11.5.10, Field Service, Mobile Field Service, Tele service, Advanced Inbound, Email Center, Oracle Knowledge Base, Install Base, Service Contracts, Dataflo, GSB
Role and Responsibilities : Involved in the advanced Inbound telephony system integration, complete end to end testing of the whole process, helping the operations team for setting up the adapter server.
Helped the operations team in setting up the email server for the email center.

Involved in the email center setup activities like classifications, routes, New Intent setup
Designing the to be email accounts, resource groups
Designed reports to help the MFS Administrator

Involved in the clean up activities of synchronization data error
Involved in setting up the knowledge base
CCAP - SCADA Java tool Integration was designed for capturing the service requests from the Turbine directly
Debrief to IB Update Program
Disabled the Standard Oracle Interface and introduced this custom Inter Module interface for the gap of partial implementation
Oracle To Dataflo, GSB Integration
It integrates Oracle CRM Modules with legacy Billing System. Billing is done in the legacy system and the details are sent back to Oracle

June, 2003 -  November, 2004

Environment : Oracle 11.5.10, Field Service, Install Base, Service Contracts. Tele service, Mobile Field Service, Oracle Knowledge Base
Role and Responsibilities : Involved in the setups of Field Service, MFS with Laptop, Service Contracts
Configuring MFS involved 3 tiers
Server Side
Worked with DBAs to install 9i lite, publish the mobile application
Application Side
Explored the options of pocket PC or Handheld Devices and Laptop. Demonstrated the users the pros and cons of it.
Configured the MFS to show IB, inventory in the laptop
MFS specific concurrent programs were scheduled and tested
Setting up the Mobile users
Laptop Setup
Installing the client on the laptop
Connecting to the server
Initial synchronization with the server
Designed the integration between the Data Warehouse System and Oracle Applications
Designed a Quick Senior form - Making the user's input to minimal level
Designed a Quick Debrief form- Easy access to the Debrief form
Designed a Multi Turbine Senior form- to create multiple SRs at the same time

Designed Service Contracts conversion activities that included conversion of Billing schedules, Billing History, Discounts and Sales Credits
Designed Custom QA Check for Contracts
Designed Custom Renewal Consolidation
Involved in the Post Production support

January, 2002 -  May, 2003

Environment : Oracle 11i, OM, Inventory, Tele service
Role and Responsibilities : Oracle Tele service - Bug tracking Integration system
It is an Interface between the 3rd party Bug tracking system and Oracle Applications. Bug details and the Senior tracking details is shared between the 2 systems.
EDI to Oracle Apps Interface
Processes the inbound EDI documents sent by 3rd party logistics providers 3PLPs, picked up from the VAN, read into the EDI staging tables and simulate the complete process in Oracle. order creation to ship confirm
Involved 2 types of EDI documents Solicited 945 Unsolicited 945

Designed an Email Alerting system for the status of the concurrent programs running in the Production System
Developed Multilingual Reports
Customer Service Report
Service Request Exception Report
Parts Usage Report
Developed various Shell Scripts
FTPing the Data extracts to legacy system servers
Running multiple concurrent programs depending on various conditions in a programmatic manner.

June,  -  December, 2001

Education

Skills


Tools : Oracle Business Accelerator, TOAD, Data Loader, SQL Navigator, Reflection X Business Process Tools : CVC, Harvest, Kintana, Mercury, HP Quality Center and Clear quest


Miscellaneous

Project : Office Automation Review System OARS
Environment : Oracle 8i, Forms 6i, Reports 6i
This project was developed as a complete Business solution for the Shriram Group Companies.
The main modules of the project are Chit, Financial Accounting, Human Resource Management, Purchase, Legal, Fixed Asset, Development, Internal Audit and Management Information Systems.
This project is a re engineering of all the existing systems of Shriram Chits and Investments Ltd which is working in FoxPro and SCO UNIX.
This re-engineering process involves converting all the existing data into Oracle8i and making the all the applications available over the web so that every transaction is updated at a central database where all the data is stored.
This project is a web-based project where the back end is Oracle8i and the front end is Forms 6i.