Amit Kulwal

E mail: acn179@r.postjobfree.com

Mobile: +1-949-***-****

Date of Birth: 5th May 1981

Experience Summary

Over 11 years of experience in Oracle Application E-Business Suite R12/11i as Oracle Apps Techno Functional

Consultant expertise. Exceptional abilities in solution architecture, study/audit of existing business process, design

& development of functional/technical requirements, Gap Analysis, Configuration Management, User Training,

handling Client Testing Phase (CRP, SIT, UAT, GO-LIVE), RICEF Development, business process blue printing,

process modeling, scoping of integration requirements. Experience of more than 8 End to End implementations in

various domains of Supply Chain Management, Oracle Advance Pricing, Financial, TCA, WIP, Discrete

Manufacturing, Service Contract and Install Base to meet and beat deadlines.

Exposure with roles and responsibilities of Team / Module Leading, Onsite-Offshore Coordination, Development and

Customization, Regression Testing, Excellent knowledge of software quality processes and documentation. Proven

track record of delivering projects within time and budgetary expectations. Fast learner, Good communication,

interpersonal, mentoring and conflict resolving skills.

Supply chain, Manufacturing, Consumer, Service Oriented

Industry Expertise:

Technical Expertise : SQL, PLSQL, XML Publisher, Reports, Forms Customizations, Forms Personalization,

Interfaces, Conversions using Standard Oracle APIs, Web and XML/Java based Interface

Programs

SQL Loader, MS Visio, SQL* Plus, Toad, Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i

Tools :

/10g, XML Publisher, JDeveloper, SQL Developer, Open Text Livelink Intranet7.0,

Sharepoint, Source Code Tool, DataLoader, Agile, Service Now. Surroud SCM Client.

Discoverer 10g, Workflow 2.6, Quality Center 11, Clear Case and MS-Office.

Professional Qualifications / Certificates

Oracle Certified Professional (OCP)

Post Graduate Diploma in Advanced Computing

Project Star Award for outstanding performance

Professional Training

Imparted Campus fresher (In-house) training on Forms Development and PL/SQL

Imparted Java, PL/SQL (In-house) training

Education

Bachelor of Commerce, University of Mumbai, India -2003

Professional Experience

HID Global, US

Client

November 2013 to Date

Duration

Oracle EBS Techno Functional Lead

Role

Active Identity and Genesis Implementation

Project

HID Global had acquired Active Identity entity and planned global implementation where in

Description

elimination of their R11 system and converting the existing data to R12 and new RICE objects are

scheduled

Techno-Functional Consultant on Safenet Integration involving Order Management,

Responsibilities

Inventory, Service Contract, Installed Based.

Discuss and review client requirements and propose solutions. Perform POC (Proof of

Concept) for the proposed solutions and get approval.

Designed and Developed the Solution to Integrate the Oracle to Safenet and vice versa

Document the Functional Requirement and approved solutions for the development team

to proceed.

E mail: acn179@r.postjobfree.com

Amit Kulwal Page 2

Extensively used to Agile for Details documentation.

Worked on SOA Interface for sending Order and Contract Information from R12 to

BHOOMI Web Service systems.

Extensively worked on various Inventory (INV) Conversion and Bill of Material (BOM)

Conversion, Open PO Conversion

Designed and Developed Custom Programming Form for OM.

Actively involved in Star Item Implementation and Forms, Reports Customization for

Genesis Project

Extensively worked on Customization on pricing to incorporate the Star Item Changes

and Was responsible for Pricing Attributes, Qualifier Setup and Pricing Formulas

Identify and track requirement gaps and Maintain Build Tracker. Getting user approvals

and sign off for various objects developed under major/minor releases.

Preparation of Development Requirement based on customer requirement. Work with

PMO & adminteam towards availability if instances, tools & facilities for various testing

and development activities.

Initiate migration Approvals/Requests to instances like QA, SIT, UAT and Production.

Extensively used EXCEL for: SIT/UAT Functional Test scripts/Variability Matrix, Master

Component List for Migrations.

Assisted QA analysts and technical team with troubleshooting and fault resolution.

Prioritized outstanding defects and system problems, ensuring accuracy and deadlines

were met.

Oracle Applications E-Business R12, BI Publisher, Oracle SCM / Manufacturing, Purchasing

Environment

(PO), Order Management (OM), PIM, Bill of Material (BOM), Service Contracts (SC) and Installed

Based (IB), Inventory (INV), Application Payables (AP), Accounts Receivables (AR), Order to

Cash (OTC), RICE(Reports, Interfaces, Conversions, Extensions), Forms Personalization, Forms

Customization (Forms 10g), JDeveloper, SOA/BPEL, Advance PL/SQL, SQL*Plus, Toad, Reports

10g, Forms 10g. Agile.

Client NRMA, Australia

November 2012 to Sepember 2013

Duration

Oracle EBS Techno Functional Lead

Role

Oracle EBS 12 Implementation (R1 and R2)

Project

The National Roads and Motorists’ Association, known as NRMA Motoring and Services, is an

Description

Australia based, member-owned mutual organization offering roadside assistance, vehicle

inspections and repairs, motoring advice, International Driving Licenses and other services in

New South Wales (NSW) and the Australian Capital Territory (ACT). The Project name GFS where

Oracle Apps Financial and P2P is to be implemented in first phase.

Responsible for Leading Reports Team and Design, Build and Test phases of the project.

Responsibilities

Identify key requirements, defined Reporting Phase scope, developed Phase plan and

scheduling, Reporting Leadership on project progress and daily development issues.

Facilitated issues resolution. Prepared and presented timely status reports to client and

internal senior management.

Conducted resource planning and budgeting; tracked costs to ensure adherence to

project budgetary limitations.

Acted as escalation point for change requests and client concerns, and worked closely

with the Project Leads to prioritize issues and coordinate troubleshooting efforts.

Conducted weekly meeting with client release managers on project updates and future

risk management to avoid any cost and time discrepancies.

Developed tools and templates to continuously project tracking and reducing defects.

Conducted skills assessments and training sessions for new joiners on Oracle Technical

Areas and delivery support tools and methods.

Led training and development to the team on the new project releases and addition of

new scope.

Conducted Code Reviews of the deliverables of quarterly bucket releases and resolving

functional and technical concerns of the developers.

Developed and customized new reports based on user req uirements like Invoice

Printing, Check Printing, .

Designed testing scenarios and prepared Unit Test Plan and Scripts.

Oracle Applications E-Business R12, BI Publisher, Oracle SCM: Order Management(OM),

Environment

Advanced Pricing(QP); Inventory(INV); Procure to Pay (P2P), General Ledger(GL), Order to Cash

(OTC), RICE, Interfaces, Conversions, SAP, Advanced PL/SQL, JAVA, CUSTOM.PLL, Forms

Personalization, XML / BI Publisher, UNIX, SQL*Plus, Toad

E mail: acn179@r.postjobfree.com

Amit Kulwal Page 3

D & H Distributing, US

Client

June 2010 to November 2012

Duration

Oracle EBS Web Integration Lead

Role

Oracle Global Fusion R1

Project

The Client is involved in Distribution sector of Electronic products and major client being BestBuy,

Description

Amazon. This project is complex in nature with maximum customization on Pricing and Pricing

Cache, Catalog Generation, Website integration with Oracle Apps, Best Branch Selection, Freight

Integration with Kewill, Mercardo Search Engine and Etilize Item Accessories Integration

Techno-Functional Consultant on Oracle SCM/Manufacturing – Purchasing (PO), Order

Responsibilities

Management (OM), Advanced Pricing (QP), Inventory (INV), Application Payables (AP),

Application Receivables (AR).

Discuss and review client requirements and propose solutions for Website Integration.

Perform POC (Proof of Concept) for the proposed solutions and get approval.

Developed and Designed Order Entry Integration, Pricing and Warehouse availability of

Item, Customer Creation, Invoice Payment Integration with Paypal and Oracle using API

Designed the Customer Profile and Preference Module for Web Site.

Developed Product Catalog Functionality in Oracle Apps and publishing the same to Web

Server.

Product and Pricing Availability with Mercado and Etilize Integration

Participated in Code Review, QA process, Technical Document Design, Code

Configuration Management, UAT Handling for Web Integration and User Training

Conducted Code Reviews of the deliverables of quarterly bucket releases and resolving

functional and technical concerns of the developers.

Preparation and review of transition documentation. Extensively used EXCEL for: Build

Tracking, Defect tracking, Resource occupancy, Release Roll out Plan for Migrations .

Validated technical designs created by Developers against functional specifications.

Oracle Applications E-Business R12, BI Publisher, Oracle SCM: Order Management(OM),

Environment

Advanced Pricing (QP); Accounts Receivables (AR), Accounts Payable (AP), Inventory (INV);

Procure to Pay (P2P), Order to Cash (OTC), RICE, Interfaces, Conversions, Advanced PL/SQL,

CUSTOM.PLL, Forms Personalization, Forms Customization (Forms 10g), XML / BI Publisher,

SOA/BPEL and UNIX.

Vaisala Oyj, Finland

Client

May 2009 to May 2010

Duration

Oracle EBS Technical Lead

Role

Oracle EBS Europe Implementation

Project

For this Project we developed custom tool to feature View ATO, PTO, Non ATO -PTO Items in

Description

single view and allowed to release Work Order. Generate Custom Serial and Lot Number, Assign

Serial and Lot Number to Job, Move Transaction for Serial and Lot Item

Requirement Gathering and Gap analysis

Responsibilities

Designed 18 Forms to develop Order BackLog Tool and Seller WorkBench.

Integrating the Module with Mobile Supply Chain API’s, to facilitate Release Work Order.

Functional and Technical Specification writing for the module.

Move Transactions integration with Mobile Supply Chain API.

Extensively worked on various Procure to Pay (PTP) and Order to Cash (OTC) Cycles.

Worked on SOA Interface for sending contract information from R12 to service systems.

Web-service was invoked through a concurrent program which was scheduled. (PO

Outbound & PO Receipt Interface with DHL)

Oracle Applications E-Business R12, BI Publisher, Oracle SCM: Order Management(OM), Work in

Environment

Process (WIP), Order Configurator, Inventory(INV); Accounts Payable (AP), Accounts Receivables

(AR), Procure to Pay (P2P), Order to Cash (OTC), RICE, Interfaces, Advanced PL/SQL,

CUSTOM.PLL, Forms Personalization, XML / BI Publisher and UNIX.

Masco BCG, US

Client

October 2008 to April 2009

Duration

Oracle EBS Technical Lead

Role

E mail: acn179@r.postjobfree.com

Amit Kulwal Page 4

Build to Truck Custom Implementation

Project

This is a system developed for maintaining and controlling the Loading of Inventory before

Description

shipment to Customer. BTT facilitates the store manager with carton replenishment, bill handling,

grouping multiple orders of a Customer and planning the shipment on scheduled dates

Extensively worked on various Order to Cash (OTC) Cycles, Providing Importance to re-

Responsiblities

usability and development standards.

Developed Carton Replenishment Report.

Grouping of Internal Requisition for External Sales Order

Enhancement of existing system

Defect prevention & defect fixing activities

GL COA Mapping

GL Detail Journal Entry from Interface JDE to Oracle

GL Subleger Reporting

Onsite-offshore co-ordination

Handling a team size of 7 members

Salesforce Integration and Management with Oracle Apps

Code Development and Code reviews of code developed by team. Review of migration

plan for releases including back out plan.

Oracle Applications E-Business R12, BI Publisher, Oracle SCM: Order Management(OM), Accounts

Environment

Payable (AP), Accounts Receivables(AR), General Ledger (GL), Service Warranty (SW),

Salesforce, Inventory(INV); Procure to Pay (P2P), Order to Cash (OTC), RICE, Interfaces,

Advanced PL/SQL, Forms Customization, XML / BI Publisher and UNIX.

Harlem, US

Client

September 2008 to October 2008

Duration

Oracle EBS Conversion Lead

Role

EBS Conversion Project

Project

This was Conversion Project

Description

Client interaction for new projects with respect to the requirement analysis, architectural

Responsibilities

design co-ordination between different teams like network management, IT Team,

Datacenter team etc.

Understand the business requirements by doing the effective communication and

documentation, doing effort estimation by Gap analysis and Impact analysis documents.

Worked on Sales Order Conversion and Updated Sales Order for other Interfaces. Have

used Open interface approach for Conversion and API

OE_ORDER_PUB.PROCESS_ORDER for Sales Order Update.

Developed Item and Freight Cost Conversion.

Defect prevention & defect fixing activities

Conducted design and code reviews

Oracle Applications E-Business R12, SQL Loader, Oracle SCM: Order Management(OM),

Environment

Inventory(INV); Procure to Pay (P2P), Advanced PL/SQL, Conversions and UNIX.

TJMAXX, US

Client

January 2008 to August 2008

Duration

Oracle EBS Technical Lead

Role

Oracle Apps R12 Implementaion

Project

This was Oracle Apps Implementation Project

Description

Developing the Active Supplier Conversion, Sales Audit Entries to GL Conversion

Responsibilities

Developed Conversion code for GL Balances and GL Transactions Conversion

Developed Conversions for Inventory Item Catalog, Inventory Item Categories

Developed Conversions for Shared HR Conversion. Converted Employees Supervisor

Information and Assignments.

Developing RFQ (XSL-FO) Report, Payroll Register Report

Developing Employee Outbound Interface

Facilitated Configuration Management Documents, base lining the Code, Check in Check -

out code strategies, Timely Audit of CM, Assisting project Manager in CM Monthly Audit

Conducted design and code reviews

Handling 4 member team in delivering, assisting and coordinating on their part with the

team

E mail: acn179@r.postjobfree.com

Amit Kulwal Page 5

Oracle Applications E-Business R12, Oracle SCM: Order Management (OM), Accounts Payable

Environment

(AP), Accounts Receivables (AR), General Ledger (GL), Human Resource (HRMS),

Inventory(INV); Procure to Pay (P2P), Order to Cash (OTC), RICE, Interfaces, Advanced PL/SQL,

Forms Customization (Forms 9i), XML / BI Publisher, Reports 9i, XSL-FO, SQL Developer,

Kintana, SqlLoader.

Weightwatchers, US

Client

September 2007 to December 2007

Duration

Lead Oracle EBS Technical Consultant

Role

Oracle Apps R12 Extension

Project

Client is a leading personal weight management/consulting company. Design, development and

Description

support for new objects developed for US Extension and customization of objects being

developed during US implementation. Development included Forms Customization, Interfaces

including shell scripts. Development phases involved unit testing, integration testing and UAT

support.

Discuss and review client requirements and propose solutions. Perform POC (Proof of

Responsibilities

Concept) for the proposed solutions and get approval.

Identify and track requirement gaps and Maintain Build Tracker. Getting user approvals

and sign off for various objects developed under major/minor releases.

Developed Supplier Member Refund form

Developed Interface to integrate pricelists into Solution Builder (IBM Comergent), AP -

AR Netting, AP Payments Lockbox Import, AP Payments Adjustments Import.

Check Printing report for Member Refund

Assisted QA analysts and technical team with troubleshooting and fault resolution.

Prioritized outstanding defects and system problems, ensuring accuracy and deadlines

were met

Preparation of Development Requirement based on customer requirement. Work with

PMO & admin team towards availability if instances, tools & facilities for various testing

and development activities.

Initiate migration Approvals/Requests to instances like QA, SIT, UAT and Production.

Extensively used EXCEL for: SIT/UAT Functional Test scripts/Variability Matrix, Master

Component List for Migrations.

Oracle Applications E-Business R11, Accounts Payable (AP), Accounts Receivable (AR), Inventory

Environment

(INV), Interfaces, Advanced PL/SQL, Forms Customization (Forms 6i), Forms Personalization,

Custom PLL, UNIX, Winscp, Sharepoint, Sql Developer.

AW Rostamani, Dubai

Client

November 2006 to August 07

Duration

System Executive ( Requirements Analysis, Design, Implementation and Change Management )

Role

CRM Extension Project

Project

AW Rostamani is an important Car Dealer in Dubai owned. The scope of this project is to develop

Description

the Service Warranty and Claim Module in Oracle EBS 11i based on Business Requirement.

Documentation was prepared as per AIM methodology Functional Documents MD50 was used

Responsibilities

as the requirement base for Technical Design MD70.

Requirement analysis

Unit Testing

Developed Extraction Form to Extract the Service Requests for Claim Generation, Distributor

Claim Form, Claim Reconciliation Form, Developed Unclaimable Form for Warranty Service

Period

Writing the interface which loads data from flat file to interface tables. Wrote procedures,

functions, packages, and database triggers. Logging/following up Service Requests with

Oracle Support

Form Personalization on Service Request for Operation Code LOV, Custom PLL menu

attachment for PDI allowed in SR Form

Developed SQL Loader program for Claims Approval file to manufacturer

Developed BOM and Price Upload Interface program

Developed Contract Burnout Report, Technician Idle Time Report, AAC Stock in Japanese Yen

Report

E mail: acn179@r.postjobfree.com

Amit Kulwal Page 6

Oracle Apps R11, Oracle Apps Service Contract (SC), Service Requests (SR), Service Claim,

Environment

Inventory ( INV), Accounts Receivable (AR), Accounts Payable (AP), Forms 6i, Forms

Personalization, Customization, Custom PLL, Interfaces, Reports 6i, SQLLoader, Unix, Toad

Erricson, Netherlands

Client

July 2006 to September 2006

Duration

Oracle EBS Technical Consultant (R11)

Role

Oracle EBS Extension Project

Project

Oracle Apps Support and Development

Description

Resolving level 3 support tickets.

Responsibilities

Developed Supplier Forecasting Discoverer Report

Oracle Apps R11, PL/SQL, PL/SQL Server Pages, Discoverer

Environment

Deepak Nitrite Ltd, India

Client

June 2005 to July 2006

Duration

Oracle R11 Project Leader ( Requirements Analysis, Design, Implementation and Change

Role

Management )

Oracle Sankalp Project

Project

Project at DNL was an Oracle Apps 11.5.10 release implementation project. I was involved in

Description

Integration of Export module with Oracle Apps.

Client interaction & requirements gathering

Responsibilities

Analysis & Design

Preparation of TO-Be Documentation for Export Module

Development, unit testing & Integration.

Project Budgeting

Delivery Scheduling

Core User training in OM Module and Export Integration

Developing custom reports using Reports 6i and customizing the standard reports. Writing

the Interface to load the work requests using the API’s.

Writing the interface which loads data from flat file to interface tables. Wrote procedures,

functions, packages, and database triggers.

Documentation was prepared as per AIM methodology Functional Documents MD50 was

used as the requirement base for Technical Design MD70.

Oracle Apps R11, Oracle SCM : OM, PO, AP, AR. General Ledger (GL), Cash Management (CM),

Environment

Inventory ( INV), Forms 6i, Reports 6i, SQLLoader, DataLoader, Unix, SQL Developer, Workflow

2.5

Flex (UFlex) Industries Ltd, India

Client

June 2004 to May 2005

Duration

Oracle Tech Lead / Project Leader ( Requirements Analysis, Design, Implementation and Change

Role

Management )

Oracle EBS Implementation

Project

This project was Oracle Apps 11.5.10 implementation

Description

Client interaction & requirements gathering

Responsibilities

Analysis & Design

Preparation of TO-Be Documentation for Export Module

Inbound Customize Interface with Delivery in OM module to integrate Barcode with Apps

Interface

Major Reports Customized:

Excise Invoice in delivery

Internal Sales Order Report

Proforma Invoice

RG23 Report

ARE Invoice

Gate Entry Report

PO Print Report

Forms Customization –

ARE Invoice Form Customization

-

E mail: acn179@r.postjobfree.com

Amit Kulwal Page 7

Document Attachment Facility for Orders Forms

-

Customized Forms in Order Management to capture various Manufacturing

-

Attributes.

GL Reconciliation form customization

Oracle Apps R11, Oracle SCM : OM, PO, AP, AR. General Ledger (GL), Cash Management (CM),

Environment

Forms 6i, Reports 6i, SQLLoader, DataLoader, Unix, Interfaces, Customizations, Toad, SQL*Plus

West Coast Paper Mill, India

Client

May 2003 to May 2004

Duration

Technical Lead

Role

Oracle Apps R11 Implementation

Project

This Project was R11 Implementation with Export/Import Module Integration.

Description

Client interaction & requirements gathering

Responsibilities

Analysis & Design

Preparation of TO-Be Documentation for Export Module

Coding of Interface specific SQL* Loader control files, PL/SQL Package and SQL* Plus Script

(For extracting the data, building the interface table and related synonyms, indexes,

granting Privileges, defining value sets, concurrent programs, parameters, request group,

adding concurrent programs to request groups ).

Creating Value Set as per the client requirement in Customized form.

Handling Form bases and Database Errors and rectifying it in Customized form

Shipping Overhead Form development and Integrating it with the Order Management Form.

LC Form, Order Return Channel Management Forms, Bonded Warehouse Form

Development

Oracle Apps R11, Oracle SCM : OM, PO, AP, AR. General Ledger (GL), Cash Management (CM)

Environment

Forms 6i, Reports 6i, SQL Loader, Data Loader, Interfaces, Customizations, PL/SQL, SQL*Plus,

Unix, Toad

Key Words: Oracle, Oracle Applications, Oracle Apps, Oracle EBS, E -Business, Ebusiness, Technical, TechnoFunctional, Techno

Functional, Supply Chain, SCM, Manufacturing, Distributions, Discrete, R12, 11i, O2C, OTC, Order To Cash, P2P, PTP, Procure T o

Pay, Purchasing (PO), iProcurement, Account Payable (AP), Order Management (OM), Fixed Asset (FA), Inventory (INV), Account

Receivable (AR), Bill of Material (BOM), Work In Process (WIP), Service Contracts (SC), Warranty, Project Accounting ( PA) Oracle

Advanced Queuing, QP (Advance Pricing), Functional, RICE, Reports, Interfaces, Customizations, Extensions, Conversations,

Workflow, BOM, SQL, PLSQL, Oracle Reports, Discover, Oracle Forms, BI Publisher, XML Bursting, Oracle Workflow and SQL

Tuning, OAF, AOL, Alerts, BI/XML Publisher, PL/SQL, ASCP, Planning, General Ledger (GL), Supply Chain Management, Supply,

Chain, Oracle SCM, SOA, Integration, Service Contract, Install Base, Unix, Toad

E mail: acn179@r.postjobfree.com

Contact this candidate