Professional Profile

I have more than 16 years of experience in IT industry with 9+ years as Oracle application professional. I have worked on multiple implementation of CRM/ERP in Lease, Retail, Telecommunication and Education industry and UK government project. I have global experience of implementing various Oracle products in US, UK, Asia and Middle East region. I was also involved in Project Management, Planning and some pre sales activities for effort estimation.

My core strength is Oracle Application E-business Suite, in which my primary areas of expertise are Oracle Lease Management, Oracle Service contracts, Trading Community Architecture (TCA), Oracle Install base, Field Service, Accounts receivable and Oracle Purchasing.

Professional Skills

Oracle Applications 11i, R12

• Oracle Lease Management - OLFM
• Oracle Contracts – Service, Subscriptions, Lease
• Oracle TCA
• Oracle Install Base
• Oracle Field Service
• iSupplier
  
• Oracle Purchasing
• Accounts Receivable
• Oracle General Ledger
• Workflow
• Service Contracts
• Oracle Order Capture – Quoting
• Advance Pricing

Databases

• Oracle 11g, 10g, 9i, 8i
  
• MS SQL Server

Hardware & Operating Systems

• Windows NT/2000/XP
  
• Sun Solaris

Programming Languages

• Oracle PL/SQL
• UNIX shell scripting

Engagement Experience

• Business requirements analysis, effort estimation and solution architecture.
• Functional/Technical design creation, coding and testing of applications.
• Applications implementation and end-user training.
• Creation/Presentation of demos to prospective clients for Oracle Portal sales.

Education :

Master of Computer Management

Bachelor of Science

Professional Work Experience

Confidential,

Dec 2011 – Present

Oracle Application Consultant

Confidential,

Jan 2006 – Dec 2011

Programmer Analyst

Confidential,

May 2005 – Jan 2006

Solution Architect

Confidential,Pune, India

June 2003 – May 2005

Software Specialist

Confidential,Mumbai, India

Jan 2001 – Jun 2003

Programmer Analyst

Confidential,Mumbai, India

Sept 2000 – Jan 2001

Sr. System Analyst

Confidential,Mumbai, India

May 1999 – Sept 2000

Executive - IT

Confidential,Nashik, India

Oct 1995 – May 1999

Programmer Analyst

PROJECT EXPERIENCE:

1. Client : Confidential,Bethlehem , PA , USA
Duration : Mar \'12 –Present
Language : Oracle Accounts Receivables, Oracle Service Contracts, iSupplier, Oracle Accounts Payable.
Database : Oracle 11g
Description : Confidential,considered Service Contract Implementation for their usage based billing. Complex pricing based on certain parameters like territory and price breaks, mid-month price change, Service contract maintenance interface was one of the challenge for the project. KGB implemented iSupplier Portal to communicate key procure-to-pay information with suppliers. Gives flexibility to kgb-‘s global supplier base to manage their information in a more timely and effective manner.

Role/Responsibilities : Techno Functional Consultant

• Map and Gap analysis for requirements.
• Understand requirements and prepare Gap design MD.050, MD.070.
• Understand requirement and configure system for all 5 operating units for Accounts Receivables, Service Contracts and Advance Pricing module.
• Configure Discoverer End User Layers, Business Areas for MIS and BI reports.
• Configure Service Contract Module for Europe Operating Units
• Design Service Contract Maintainence interfaces with various sources
• Design functional and technical solution for Mid-Month Price change.
• Design solution for Cost Per Call usage based billing.
• Configure Vanilla iSupplier module based on requirements.

2. Client : Confidential,NJ USA
Duration : Dec \'11 –Mar ‘12
Language : Oracle Apps 11i , Oracle CRM 11i, Oracle Service Contracts
Database : Oracle 11g
Description : Confidential,implemented Oracle 11i E-Business Suite. Recently canon acquired Oce who is leading in the leasing business of Photocopier. Objective of project was to do Business Process Reenginnering to suit needs of Oce.
Role/Responsibilities : Techno Functional Consultant

• Understand business requirement and prepare MD.050 document for enhancements to existing extensions.
• Working on various requirement which needs enhancement to bill customers usage for more types of counter than existing Canon Business

3. Client : Confidential,PA, USA
Project : Beacon Release 2
Duration : May \'09 –Dec ‘11
Language : Oracle Application 11i – Oracle Financials
Database : Oracle 11g
Description : Confidential,is a global strategic initiative focused on standardizing the core processes that support De Lage Landen’s business around the world. Release 2 is focused for Netherlands operations which includes two operating units.
Role/Responsibilities : Techno Functional Consultant

• Liason between Business and Technical team
• Planning of Cutover Conversion activities during Go Live
• Gather conversion specific requirement and prepare CV.040 functional specification and mapping document for additional functionality of Inventory Item, Parties, Collectors & Sales Rep, AR Balances – cash receipts in Release 2.
• Execute the all conversion programs including Lease Conversion for each CRP upto Go Live.
• Supported interface team to prepare MD.050 for few interface from major vendor.
• Design GAP related to ITR Invoice Printing and Late Interest Policy billing.
• Oracle EBS R12 Assessment to analyze the impact of upgrading to R12.
  

4. Client : Confidential,PA, USA
Project : Beacon Invoice Swat
Duration : Feb \'09 –May ‘09
Language : Oracle Application 11i – Oracle Financials
Database : Oracle 11g
Description : Post go live of Beacon Release 1, there were few issues in ITR (Invoice to Receipt) area reagarding Invoicing and billing. Invoice Swat team was formed to address these issues and provide appropriate solution. Since ITR was directly impacting customers, this initiative was taken to provide accurate and quick solution.
Role/Responsibilities : Techno Functional Consultant

• Liason between Business / Triage and functional team to priortize issues by analyzing in terms of dollar amount, number of invoices, number of customers impacted.
• Provide functional solution to ITR production support.
• Coordinate with SME / Business transformation team to communicate with Business.

5. Client : Confidential,PA, USA
Project : Beacon Release 1
Duration : Jan ’06 –Feb ‘09
Language : Oracle Application 11i – Oracle Lease Management
Database : Oracle 11g
Description : Confidential,is a global strategic initiative focused on standardising the core processes that support De Lage Landen’s business around the world. This is first ever largest implementation of Oracle Lease Management in terms of Project size and scope. This is first ever conversion of Lease Contracts from Legacy to Oracle.
Role/Responsibilities : Techno Functional Consultant

• Gather conversion specific requirement and prepare CV.040 functional specification and mapping document. Prepared CV.040 for Oracle Lease Insurance Billing, Composite Meter Groups (Consolidated Meters), Meter Reads History, AR Balances , Syndication Investor Agreement conversion.
• Based on functional requirement and mapping prepare CV.060 – Technical design docuement. Prepared CV.060 and CV.070 for all above mentioned conversion items
• Execute the conversion program and coordinate with client for testing for each CRP upto Go Live.
• Based on functional requirement fix Extension code defect during cutover and pre go live CRPs.
  
  

6. Client : Confidential,NJ USA
Duration : May \'05 –Dec ‘05
Language : Oracle Apps 11i , Oracle CRM 11i, Oracle PL/SQL, Forms 6i, Reports 6i
Database : Oracle 9.2.0.3.0
Description : Confidential,implemented Oracle 11i E-Business Suite. Objective of project was to do Business Process Reenginnering. 50% of Canon\'s business is thru Services. Field Service, Service Contract and Install base are one of the core business modules.
Role/Responsibilities : Techno Functional Consultant

• Understand functional requirement and prepare MD.070 document and Code for PLSQL packages to extract data for Oracle Portal Reports
• Prepared Technical specification MD.070 document for issues in Production support for PLSQL extension Service Contracts - Meter read rollup for Fleet Contracts, Missed meter read insertion, Meter read validation for Service Meter read entry.
• Prepared MD.050 and MD.070 document and code for 6i reports for Service contract and field service.

7. Client : Confidential,OH , USA
Duration : Nov ‘04 –May ‘05
Language : Oracle PLSQL , Digital Fuel 4.0
Database : Oracle 9.2.0.3.0
Description : Objective of the project – GBS Cockpit was to provide GBS (P & G’s division Global Business Services) with a business management tool that enables transparent tracking and reporting for end-to-end service performance metrics. The Cockpit shows a consolidated view of performance across P&G’s Shared Services environment.
Role/Responsibilities : Technical Lead

• Involed in Presales activities for Estimating project size and scope.
• Estimate and Schedule Releases for each month
• Analyzing the Data from Data warehouse.
• Onsite coordination with Offshore Team
• Work closely with Digital Fuel Product Development team to enhance features of tool

8. Client : Confidential,
Duration : Feb ’04 –Oct ‘04
Language : Oracle Apps 11i , Oracle CRM, Oracle PL/SQL, Forms 6i, Reports 6i
Database : Oracle 9.2.0.3.0
Description : Aspect was on Oracle Applications release 10.7 character; Confidential,This project is to bring Aspect up to Oracle 11.5.9 with a fresh implementation approach.
Role/Responsibilities : Technical Lead/ Project Lead

• Actively Involved in pre sales activities such as estimating efforts, defining project scope , planning resource utilization and timelines for Offshore Delivery.
• Gather conversion specific requirement and prepare CV.040 functional specification, CV.060 technical specification and CV.070 test cases for Service Contracts, Install base, TCA Parties, Purchasing (Open PO), Inventory Items and Common Utilities. Extensively used PO open interface to get Standard PO / Blanket Agreements, receipts and releases.
• Lead the team of developers and coordinate with Onsite Implementation partner – Oracle Corporation.

8. Client : Confidential,NJ USA
Duration : Jun’03 –Feb ‘04
Language : Oracle Apps 11i , Oracle CRM, Oracle PL/SQL, Forms 6i
Database : Oracle 9.2.0.3.0

Description : Confidential,is the organization that accredits public accountants in the U.S. AICPA was implementing Oracle Applications(OTA – Oracle Training Administration) to better manage its membership and training services.

Role/Responsibilities : Extension Technical Lead

• Actively involed in pre sales estimations and planing for offshore delivery of GAP Extesions and Conversion.
• Understand the functional requirement and prepare MD.070 – Technical design document for various GAPs of functionality around Order Management , Service Contract and AR , Vendor Refund, iStore Integration to Quoting, TCA synchronization and deduplication of customers.
• Lead the extension team of 12 developers.
• Worked on optimizing and tuning of conversion programs. Specifically TCA, Service Contracts to convert 1million customers and related child reacords.
• Prepared CV.060 Design for Conversion of Sales quotes, Service contract from legacy to 11.5.9.

10. Project : CRB
Organization : Mastek Ltd., India
Client : Confidential,UK
Duration : Jun’01 –Mar ‘03
Language : Oracle Apps 11i , Oracle CRM, Oracle PL/SQL, Forms 6i
Database : Oracle 8i
Description : Confidential, is organization set up by the home office of the government of UK. The organizations main role is to improve access to criminal records for employment-related and voluntary appointment purposes.
Role/Responsibilities : Techno Functional Consultant

• Maintaining CRM team Matrix and Responsibility Matrix
• Creating all necessary Setups required in Oracle CRM / General Ledger/ Receivable
• Prepare BR.100 for required setup for implementation.
• Customization in Oracle CRM – Contact Center.