OBJECTIVE

• Providing quality solutions to complex business problems within scope, budget and tight schedules. Also seeking to handle increasing responsibility and challenging assignments to harness my software skills, to update my knowledge and achieve recognition.
• I want to be a part of an environment that promotes team effort and provides opportunity for value based growth, as well as career advancement while making a significant contribution to employer organization.

SUMMARY

• More than 15 years of experience in Oracle Applications 11i and R12 (Oracle E - Business Suite) implementations and post production support.
• Performed PM activities like work distribution, SLA monitoring, resource utilization.
• Handled Team of 8-10 people responsible for Global Support.
• Extensive knowledge of O2C (Order to Cash), Procure to Pay and Service Request To Resolution Cycle
• Kapil has extensive knowledge in SCM Modules (Order Management, Shipping, Advanced Pricing, Inventory, Sourcing, Freight Settlement and Purchasing) and CRM modules (Field Services, Tele-Services, Tele-Sales, Service Contracts, Install Base and Depot Repair) and Account Receivables.
• Technically proficient in RICE (Reports, Interfaces, Configuration, and Enhancements) methodologies including Implementation, Interfacing, Conversion and Data Migration. Experience in up gradation to Oracle Apps 11i and Implementation of Oracle Apps11i.
• Strong programming experience in creating Procedures, API, Packages, Functions, Triggers and other database objects using SQL and PL/SQL. Providing support to apps users for any technical or functional issues and having a strong knowledge on registering menus and forms
• Proficient in writing SQL queries & PL/SQL program units and Expertise in developing interfaces, PL/SQL, Stored procedures/packages, db triggers.
• Experience includes Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, reports, concurrent programs by using Application Object Library (AOL) and having knowledge on developing and customization of forms.
• Experience in developing MD70 (Technical specification) documents based on MD50 (Functional specification) documents.
• Excellent experience in business requirements gathering from end users and preparing BR30, BR100 to meet those requirements.

TECHNICAL SKILLS

Applications: Oracle E-Business Suite 11i/R12

Oracle and Programming Tools: SQL/PL/SQL, Oracle Forms, Developer 2000 (Reports 6i), SQL*Loader, XML reports, Workflows.

DBMS / RDBMS: Oracle 9i and 10g

Operating Systems: Solaris, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Environment: Oracle Apps R12, SQL, PL/SQL, UNIX

Responsibilities:

• Setup Inventory Organizations, Locations, Shipping Networks, Organization Access etc.
• Data migration- Data Migrate of Item Master, Inventory on-hand, Stock Locators, Costing, Sub Inventories, Categories etc.
• Create BR100, BR30, and FDD for respective reports, customization, Inventory, OM and Purchasing processes.
• Support business applications through Remedy Tool.
• Perform System validation after database /application Patching
• Perform Post patch functional testing.
• Create some Customize Oracle WIP, BOM Report as per client requirement.
• Define Sourcing Rules, Assignment sourcing Rules and ASL.
• Define Price breaks on price list.
• Define formula components etc.
• Testing for custom components. This is done by running the business case scenario in Production clone instances so that there are no issues faced by the business users in the production instance.

Confidential

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX

Responsibilities:

• Performed PM activities like work distribution, SLA monitoring, resource utilization, emphasize on the repository maintenance.
• Presenting weekly and monthly status reports to the client.
• Interacting with offshore team ensuring proper knowledge transitioning, issue handover taking place.
• Handled Team of 8-10 people responsible for Global Support.
• Providing Functional Support in Supply Chain, Financial and Manufacturing Modules.
• Worked as Site Lead/SPOC for any issues reported for different Sites.
• Assisting Business in Month End Closure Activities.
• Providing Training Guides/Sessions to the Key users for major day to day activities.
• Providing Root Cause and fixing bugs for the recurring issues.
• Understanding, reviewing and implementing new requirements/requests made by the Users.
• Writing/Reviewing FDDs, RDDs and TDDs for new Enhancements and fixing existing Bugs.
• Worked with Oracle team on various SRs.
• Involved in the Unit and System Testing with the teams handling other interfaces.

Confidential

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX

Responsibilities:

• Understanding the customer’s on-going business flow and implementing the changes for the business cycle.
• Implemented component mainly aimed at providing better Tele Services to its huge customer base.
• Setup Change Management for project and owner of project change management.
• Worked on the various main functionalities such as service request and workflow, customization and integration of Forms 6i with Applications, concurrent requests, interface programs, flex fields, and Call Center applications.

Confidential

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX

Responsibilities:

• As a Business Analyst I was responsible to explain the complete flow of CRM module and to suggest the changes to functional team and to explain the current functionality to fast team and to create some reports for the business user
• Preparing Technical Design Document MD70
• Held responsibility for form personalization.
• Data Conversions, some major code enhancements(like changes in the cosmos to OFS integration program)
• Data Conversion Activities which includes Customer conversion, PA Expenditure Conversion
• Form development(like Financial Info Form from PA CHECK T table)
• Form customization (like Service Request form)
• Forms personalization (Task Line Item form, outage mapping form, contracts Summary form and Service Request form).

Confidential

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX

Responsibilities:

• Worked as Technical Consultant.
• Develop Conversion Program for Customer Conversion, PA Expenditure Conversion, Employee Conversions
• Preparing MD 70 for Technical Components
• Designing and detailing Customizations to the technical to fulfill the Business requirement.