Oracle Sales
Resume:
AMOL KALWADE Contact Number: - 937-***-****
Email: - ***********@*****.***
Amol Kalwade
. 12 years of experience in IT as Functional Consultant, Analyst /Team
Lead mainly in the areas of Supply Chain Management (SCM)- Oracle
Order Management(OM),Oracle Advanced Pricing(QP),Account Receivables
(AR),Oracle Purchasing(PO),Oracle Inventory (INV),Account
Payables(AP).
. Good exposure to AIM methodology, extensive exposure in preparing
MD50, MD70.
Knowledge of business processes across the E- Business Suites, Order
to Cash (O2C), and Procure to Pay (P2P).
. Experience of working as a Functional Consultant OM (Order
Management), Oracle Advanced Pricing (QP).
. Diversified experience in all phases of software development life
cycle.
. Proven Expertise in business process mapping, analysis, design and
configuration, customization & workarounds, functional issue
resolution, System Integration and Acceptance Testing as a part of
Implementation& Upgradation
. Ability to handle full life cycle implementation going through
Analysis, Design, Conference Room Pilot (CRP), User Acceptance Test
(UAT), User training, Go-live and Post Production support.
Professional Experience:-
Company : Accenture
Client : United States Steel Corporation (US Steel)-Pittsburgh,
PA
Period : Jan 2011 - Till Date.
Environment : Oracle Apps R12.
Role : Oracle Apps Functional Consultant.
Responsibilities:
. Worked as an Oracle Applications Functional Consultant;
responsibilities included writing FDD (Functional Design
Document) for detailed business requirements.
. Worked very closely with Business users and stakeholders
extensively on day to day basis in collecting business
requirements to prepare Design Documents. Also involved in
integrated testing and UAT.
. Involved in doing system setups for Oracle Advanced Pricing (QP)
and Order Management Modules (OM). Also involved in maintaining
setup document (AP322) for these modules.
. Also involved in Analysis and Design of IR-ISO (Internal
Requisition/Internal Sales Order) Processes.
. Also involved in Analysis and Design of Intercompany Invoices
Process.
. Performed pricing Setups for Internal Purchase
Requisition/Internal Sales order and Inter-company
Relationships, Shipping network.
. Also involved in trouble shooting various post production issues
in full Order to Cash cycle.
. Also involved in setup of various Advanced pricing entity (Price
Lists, Modifiers, Formulas, Attributes Management), Order
Management Setups in various testing cycles.
. Also involved in performing requirement gathering, fit/gap
analysis, functional specification design, unit and integration
testing, data conversion, documentation, user training,
production and post production support activity.
. Extensively involved in Unit Testing, System Integration
Testing, end to end Functional Testing, User Acceptance Testing,
Regression Testing, preparing Test cases, documenting Test
Scripts.
. Experience in preparing Configuration documents, Process Mapping
documents, user guides, write ups for communications to user.
. Also involved in End-to-End implementation of Order to Cash
cycle.
Company : Cisco Systems-Morrisville, North Carolina.
Period : July 2009 - Dec-2010
Environment : Oracle Apps 11i, Oracle Apps R12.
Role : Oracle Apps Functional Consultant.
Responsibilities:
. Worked as an Oracle Applications Functional Consultant;
responsibilities included writing
Functional Design Document for detailed business requirements.
. Analyzed the various Pricing business scenarios to understand
the pricing & discounting requirement of the client.
. Implemented various pricing & discounting measures based on
product hierarchy & pricing attributes.
. Defined various price lists, pricing contexts, attributes &
attribute values to meet the business requirement of the
customer.
. Analyzed user requirements to 12.0.6 functionalities & mappings
within order management, purchasing & advanced pricing modules.
. Also involved in coordinating onsite and off-site team for issue
resolutions and query.
. Worked as a Team-lead, which includes providing
technical/Functional solutions for business requirements and
assigning works to team mates.
. Involved in writing BULK Import of Price Lists interface, Also
involved in setting up formula.
. Extensive Experience of working on Reports, Interfaces on Oracle
Order Management (OM) modules.
. Also Analyze/developed custom List Price Catalog (LPC)
application which is used for Publication of Price lists in
Advanced Pricing.
. Extensive experience of Oracle Advanced Pricing (QP) setups like
Setting up Context, Attribute Linking and Mapping, Modifier
Setups, Qualifier Setups. Also involved in Pricing Formula
setups.
. Experience of working on Price modifications and Rules in
Advanced Pricing (QP).
. Experience of customizing QP_CUSTOM in Advanced Pricing.
Company : DS Waters of America, Atlanta-GA
Period : May 2007 - June 2009
Environment : Oracle Apps 11i, Oracle Apps R12.
Role : Oracle Apps Functional consultant.
Responsibilities:
. Worked as an Oracle Applications functional Consultant;
responsibilities included Key in Preparing the Functional
Specification Documents (FSD), Business Requirement Documents (BRD)
and Functional Testing Documents.
. Responsible for creating, Internal Sales Order and complete Order
Cycle setups from order entry to ship confirm to support business
requirements.
. Involved in Analysis and Design of Sales Order Interface in Order
Management (OM).
. Also involved in customization of Autoinvoice program in
Receivables.
. Involved in map and gap analysis of upgrading 11.5.8 to Oracle R12.
. Worked on Return Material Authorization (RMA) Process in Order
Management Application.
. Responsible for creating, Internal Purchase Requisition/ Sales Order
and complete Order Cycle setups from order entry to ship confirm to
support business requirements
. Involved in Co-ordination between the Client, Onsite Team and the
offshore team
Company : IBM.
Period : March 2006 - Feb 2007
Environment : Oracle Apps 11i 11.5.10
Role : Oracle Apps Techno Functional consultant.
Responsibilities:
. Worked as an Oracle Applications Techno functional Consultant;
responsibilities included writing technical specifications for the
functional requirements, responsible for developing/testing/ and
implementing the technical requirements using Oracle Applications
(11.5.10) tools. These tools include PL/SQL, SQL, Forms, Reports,
Interfaces, and AOL.
. Responsible for the quality of technical analysis, design, and
development of all customer upload interface.
. Worked with the onsite people and other functional team members on
getting requirements, creating fit gaps and ensuring that the
business provided enough information for a good design.
. Responsible for writing test plans and executed them for the
developed code.
. Responsible for the customization of customer upload interface which
included writing technical specifications, mapping of all the
interface tables' fields with the legacy system, and writing PL/SQL
code to populate interface tables.
. Worked on Oracle Trading Community Architecture (TCA) API to upload
customers.
. Worked on FND Load utility to migrate AOL objects.
. Responsible for developing custom report in General Ledger (GL) for
Carlson Corporation. Also responsible for writing Control M scripts
for scheduling concurrent programs.
. Responsible for writing and executing Test Cases in Mercury's Test
Director.
. Designed and developed custom package for creating OPM Formula.
GMD_FORMULA_PUB, GMD_STATUS_PUB API were used for creating OPM
formula.
. Designed and developed custom enhancements in Invoice on Hold (AP)
seeded report.
. Designed and developed custom PL/SQL code to fill the gaps of FA
Mass addition CER tracking number.
. Designed and developed a conversion program, custom PL/SQL code to
import open sales orders from the Legacy system into Order
Management using Order Import.
. Designed and developed custom enhancements in Pick Slip seeded
report.
. Involved in the study of the existing system, prepared the
functional (MD50), technical (MD70) design document and conversion
mapping document (CV40) to extract data from two Oracle Application
instances of RICOH.
. Designed and developed the custom form for maintaining and
publishing unusual demands for RICOH international.
. Developed conversion programs, staged tables and customized PL/SQL
API and interfaced for BOM Import and Open Sales Order Import.
. Also responsible for development of Requisition Import (REQIMPORT)
interface in Oracle Purchasing.
. Experience of working on Multi Org/MRC (Multi Reporting Currency)
reports for Carlson Corporation. Developed General Ledger (GL)
reports using MRC.
. Worked on OM (Order Management) cycle, Experience of creating full
Order cycle.
. Successfully Implemented P2P (Procure to Pay) cycle with all the
setups.
. Extensive experience of configuring SQL queries in TOAD.
. Experience of analyzing PL/SQL code in Oracle Purchasing and Oracle
Inventory schemas.
Brief description of the project:
IBM is an International Information Technology (IT) Company with a massive
presence worldwide with a portfolio of capabilities ranging from consulting
to software and hardware. CCC is a major insurance company in Chicago, US
which was providing damage claims for cars. This project, Oracle revolves
included implementation of AR, OM, HRMS, and CRM modules.
Company : KPIT Cummins Infosystems Ltd.
Period : February 2005 - March 2006
Environment : Oracle Apps 11i 11.5.9
Role : Oracle Apps Technical Consultant.
Responsibilities:
. Worked as a Technical Consultant for building interfaces; wrote
database packages, and customized reports of Oracle
inventory/PO/WIP/MRP.
. Responsible for the customization of forms and PL/SQL.
. Responsible for the customization of the following interfaces:
- Open Item Interface.
- Item Categories Interface.
- Purchase Document Open Interface (PDOI)
- Requisition Import (REQIMPORT)
- Scheduled group Update interface in WIP.
- BOM Upload.
. Responsible for customization as well as new development of reports.
Gained experience in OAI (Oracle Application Interconnect) tool
which was used as a kind of Middleware software between Legacy
system and Oracle Application.
. Responsible for the registration of custom concurrent programs for
the developed components as well as value set definitions and
registration of form, function, and menu.
. Worked on Forms customization and Report customization.
. Handled a separate module, which was bolted-on to Oracle
Applications.
. Worked on Chainlink as well as post implementation support activity.
. Worked on Remedy as a supporting tool and Appworx as a scheduling
tool.
. Involved in interacting with onsite functional people regarding
queries.
. Involved in the exposure of Oracle XML Publisher reporting tool.
. Involved in giving technical solutions to client for certain
requirements.
. Responsible for the customization of Oracle Alerts.
. Responsible for giving support in the UAT (Users Acceptance Testing)
phase.
Brief description of the project:
Fleetguard Nelson is the Cummins group of companies which produce diesel
engine. They implemented Oracle 11i for there Stoughton and Mexico plant.
Initially they implemented Apps for manufacturing modules at Stoughton and
Mexico plant and then they have planned to implement it to there other
locations. They have sales order legacy system SOMS (Sales Order Management
System) after word they want to implement OM.
Company : KPIT Cummins Infosystems LTD.
Period : June 2004 - February 2005
Environment : Oracle Apps 10.7
Role : Oracle Apps Technical Consultant.
Responsibilities:
. Responsible for gathering the requirements for a change and
successfully implemented those requirements.
. Responsible for complex validation of forms and reports.
. Responsible for the kind of outbound interface and sent e-mails
through UNIX.
. Responsible for writing PL/SQL code for the requirements.
. Designed, developed, and implemented various customizations for
Oracle Manufacturing modules like BOM, MRP, Order Entry, Purchasing,
and Costing.
. Involved in giving technical solutions over the requirements.
. Interacted with the functional people to know the business process.
Brief description of the project:
Holset Turbochargers (UK) is also Cummins group of company, they
Manufacture the full range of turbochargers and supply core components to
there sister plants worldwide. They have implemented Oracle Apps. 10.7 but
there are some enhancements and production support issues in the INV, PO,
and Order Entry modules of Apps. My responsibility would be to study the
system and do the gap analysis.
Company : FWL Technologies (UK).
Period : September 2002 - May 2003
Environment : Oracle Applications 11.5.8
Role : Team Lead.
Responsibilities:
. Responsible for understanding old form logic and designed that form
in Forms 6i; also understood the old code and converted that code to
PL/SQL. Created the form library for validation and reuse.
. Responsible for understanding the old report logic and converted
that report into Reports 6i, and designed the layout and code.
. Responsible for writing test plans for the converted code and
checked that functionality was as per the old system.
. Wrote complex and reusable logic in database package and procedures.
Brief description of the Project:
PJH is one of the main companies in the field of Supply Chain Management
and Freight Forwarding and Warehouses. They had their old system in Axcell
and the database was in Powerhouse; these forms and reports were converted
in Oracle Developer 6i.
Company : Sunrise Systems.
Period : January 2002 - September 2002
Environment : Oracle Applications 11.5.8
Role : Techno Functional Consultant
Responsibilities:
. Responsible for handling 5 to 8-member teams.
. Involved in database design for the complete project; designed the
system and explained to the team members.
. Used PL/SQL extensively for coding and writing complex database
triggers, stored procedures, and packages.
. Involved in creating users, roles, and profiles and granted and
revoked the privileges to the users.
. SQL*Loader was used for data loading; the old data was loaded in
temporary tables and then transferred to new tables by using insert
scripts (Anonymous PL/SQL blocks).
. Extensive testing was done on the programs for achieving accuracy
and timely processing of data.
. Wrote test cases for forms and reports.
. Involved in designing the screens and reports. Coded many important
forms (screens) such as Group type, Subgroup type etc., Master forms
and assets register, depreciation schedule, opening depreciation
calculation, deletion of assets etc., and transaction forms using
Oracle Forms 6i.
. Involved in the creation of all the menus in this application.
. Developed many important reports such as Fixed Assets Schedule,
Asset Card Printing etc. using Oracle Reports 6i.
. Involved in discussions with the clients regarding the screen
appearance and their new requirements, complaints, suggestions etc.
. Involved in the development of property classes, PL/SQL libraries
etc
Brief description of the Client:
Fixed Assets Management System was initially developed in FoxPro 2.5. The
whole application was converted into Oracle. This module provided
information on the exact value of asset, what amount of depreciation value
during the year; it handled complete asset management activity such as
addition of asset, maintenance of asset's register, depreciation schedule
year wise, and opening depreciation calculation. Reports such as
depreciation schedule, asset card printing etc. were generated through the
system.
Technical Skills
. ERP: Oracle Applications 10.7/11.0.3/11.5.9 & 11.5.10,R12
SCM(INV,PO,Order Management(OM),Advanced Pricing(QP),Accounts
Receivables(AR)),
. Tools: SQL Plus, SQL Loader, Oracle Developer (Forms 6I, Reports 6I)
. Languages: JAVA 2, C, C++, JAVA, SQL, and PL/SQL.
. RDBMS: Oracle 7.3/8 and Oracle 8i (8.1.6/8.1.7).
. OS: MS Windows, HP UNIX, and Windows NT.
EDUCATION:
. Master's degree in Computer Management.
. Bachelor's degree in Computer Science.
. Diploma in Advanced Computing from C-DAC
Training:
. Oracle Application (11I) for all Manufacturing and Financial
modules.
. OA Framework and JDeveloper (9.0.3-OA Extension) from Oracle
University
Contact this candidate