M adhu Kumar

Lead Oracle Applications Techno-Functional Consultant

Mobile : 214-***-****

E-Mail : acgrni@r.postjobfree.com

A Certified Oracle Expert Professional around 10 years of experience working as Lead Oracle

A pplications Techno-Functional consultant in IT industry. Key responsibilities include business

requirements gathering, designing, developing, mapping, configuring, testing and support

f inancial and SCM (Supply Chain Management).

• Experience in Procure to Pay ( PTP) modules, O rder to Cash ( OTC) modules and Asset

to Retire (ATR) modules B usiness Processes functionality.

• Experienced in Oracle Applications 11i, R12 financial modules G L, AP, PO, FA, CM,

A R, iExpenses, iPayments, EBTax and Supply Chain modules P O, Inv, iProc.

• Expertise in various Application Extensions, Conversions, and Process Re-engineering

( R ICE) and preparing Functional Document Design and Testing Documents developed

t hrough O racle User Productivity Kit Professional (UPK) tool.

• Designed and developed O racle Web AD I, financial modules I nterfaces for the legacy

system data t ransfer.

• Experience in configuring Sub Ledger Accounting Method (SLA) for the business

requirements.

• Experience in Implementing Oracle Application Implementation Methodology

( AI M) and O racle Unified Methodology (OU M).

• Experience in O racle Workflow, Approval Management Engine (AME), System

A dmin, Alerts and Form Personalization

• Expertise in P atch Analysis, analyzing R elease Content Documents (RCD) and

R elease Update Pack (RUP) for the complicated patches and advise the regression testing

p lan

• Experience in developing test scripts using Q uick Testing Professional (QTP) for the

testing and configuring applications per the application setup documentation.

• Expertise in handling high volume data loading through D ata load and using

Synchronizer tool for the validation.

Madhu Kumar Page 1 of 9

(Oracle Applications Techno-Functional Consultant)

• Coordinated with Wells Fargo Adapter payment system integrated with Payables.

• Experience in configuring and supporting Vertex O Series t ax integration with Oracle

Payables

• Expertise in documentation using AIM/OUM methodology like R D020, BP020, BP040,

B R100, M D050, CV040, BR030 and TE020, TE040 documents.

• Expertise in implementing F inancial System Generator (FSG) and G lobal

Consolidating System (GCS).

• Experience in F inancials Month End Close process (MEC).

• Developed extensive queries through SQL for financials modules.

• Experience in writ ing P L/SQL Queries, Packages, Stored Procedures, Functions,

T r iggers and Developer 6i (Forms and Reports).

• Manage offshore/onsite teams to make sure client requirements/issues understanding

correct and to deliver the requirements as expected.

• Excellent communications, In terpersonal and leadership skills, Target oriented and

Team oriented.

Madhu Kumar Page 2 of 9

(Oracle Applications Techno-Functional Consultant)

• • Oracle E-Business Suite 11i, R12

ERP

• • GL, AP, AR, FA, CM, PO, iProc, OM, iExpenses, Vertex, Inventory,

Functional

Modules AGIS

• • Sys Admin, AOL, Web ADI, Workflow Builder, AME, Form

Technical

Modules Personalization, E-ICU tool, iSetup

• • Oracle 9i/10g/11g/12c, SQL Server, MS Access

Database

• • SQL, PL/SQL, SQL*Loader

Languages

• Windows, Windows Server, Red Hat Linux, Oracle Linux, Unix, MS

• Operating

DOS, VMWare Server, VMWare Workstation, Vi r tual Machine, Sun

System

V i r tual Box

• MS Office, TOAD, SQL Developer, SQL Navigator, JIRA, Quality

Center, QTP, Remedy Incident Tool, BMC Service Desk tool, Putty,

• Tools

W in SCP, FTP Server, Dataload, UPK, M icrosoft Sharepoint, Lotus

Notes, Tortoise SVN, Notepad++

•

•

• Master in Business Administration(Finance) from Osmania University, India

•

• Certified in IT I L V3 Foundation

• Oracle Certified Professional in R12 Receivables

• Attended t raining in Oracle Core Financial Applications.

• Workshop on Application Implementation Methodology (AIM) and Oracle Unified

Methodology (OUM)

• Received Oracle On-Demand’s performance award in FY12 and FY13

• Received Oracle On-Demand’s monthly award winner.

Madhu Kumar Page 3 of 9

(Oracle Applications Techno-Functional Consultant)

P roject : Manheim, Atlanta, GA

Role : Lead Oracle Functional Consultant

Duration :Jan’2014 to Oct’2014 (Onsite) and May’2011 to Dec’2013 (Offshore)

Modules : R12.1.2 GL, AP, PO, iProc, Workflow, AR, Vertex

Manheim is a US and Canada based Auto Auctions company sells various types of vehicles,

boats, heavy machinery over 170 countries. I t has implemented R12.0.6 with 2 operating units

and upgraded to R12.1.2 with few customizations and is in process of upgrading to R12.1.3

• Managed day to day business issues for AP, PO, iProc, Workflow, GL modules. Handle

c ritical and show stopper PROD issues.

• Provided Continual Service Improvements (CSI) for various areas to improve after

analyzing the gaps or difficulties of the business process

• Worked with Q uality Center (QC) help desk and R emedy I ncident tools to resolve L evel

2 a nd Level 3 i ssues.

• Worked and supported mock close in stage environments and M onth End Process (MEC)

for PROD financial and AP module.

• Worked on Vertex O Series t eam for the tax calculation functionality and Oracle Product

support for the tax issues.

• Work with Wells Fargo Adapter team for the electronic payments made and integrated

w ith Wells Fargo Bank in regular payments made through AP.

• Performed u pgrade analysis r equired upgrade from R12.1.2 to R12.1.3 and provided

i mpact analysis. Analyze existing functionality and advice business or CEML I for any

changes required.

• Work in the environment T ranscepta, OSN, XML Gateway and AP I nterfaces

• Assist end users directly, super users in resolving the issues through phone, Cisco or Oracle

S tbeehive OWC and providing instructions to the users.

• Ini tiate Bridge/Critical calls and involved every team and managed the call until the show

s topper issue got resolved.

• Performed in finding the R oot Causes Analysis (RCA) issues and prepared documentation

and provided precautionary instructions.

• Schedule resources for the critical issues, MEC plan, and Monthly Releases Deployment

i nto PROD.

• Coordinate Offshore/Onsite team for the different issues, schedules, meetings, client

requirements to get good understanding between teams and client requirements/issues.

Madhu Kumar Page 4 of 9

(Oracle Applications Techno-Functional Consultant)

• Prepare business process document, support document, user manuals, test cases for the

enhancements and extensions

• Prepare Whitepapers for the ongoing chronic issues to help other teams in the

organization.

• Lead and provide the status in client meetings for various issues on weekly basis, organize

conferences, meetings for the regular issues

• Provide KTs to the super users, presentation new changes/process required.

• Prepare different types of status reports for project activities and report to management.

• Coordinate with client, DBA, functional and technical team for the helpdesk issues,

performance issues, and CEML I issues.

•

Project : Ciena, Baltimore, M D

Role : Lead Oracle Functional Consultant (Offshore – I ndia)

Duration :Feb’2010 to Apr’2011

Modules : iExpenses, iP roc, PO, GL, AP, FA

Ciena is one of the leading US based MNC working for Network software and manufactures

Optical, Ethernet, and Network Automation. Ciena has implemented 11.5.10.2 with 12 SOB’s,

17 Operating Units and 17 Inventory orgs. I t has upgraded few 7 more OU and Inventory orgs

and few enhancements.

• Support for i Expenses, iP roc, PO, AP, GL, FA modules

• Helpdesk support through the tool BMC Service Desk tool and assist users in resolving day

to day business issues.

• Gather business requirements and design and build the solution with the coordination of

CEML I team.

• Perform R oll outs and M ulti-Org setups and for new operating units and deactivate any

existing operating units per prepared BR100 document.

• Support super users in setting up COA values i n addition or disabling of the new changes

i n business.

• Developed excel sheet for the A P Open I nterface p rogram for large volume of invoices

entered on regular basis.

• System Administration Setups for Users, Responsibilities, Menus and Request Groups

for the new user groups added in new roll outs.

• Configure new L edgers, COA, Calendar and O U’s for the new businesses added those

cannot be not aligned to the existing applications configuration.

• Support employees in i Expenses and provide clarifications, workarounds immediately at

t heir desks, mails, phone and WebEx web conferences

Madhu Kumar Page 5 of 9

(Oracle Applications Techno-Functional Consultant)

• Support iExpenses C redit Card functionality i mplemented and coordinated HDFC bank

for the frequent issues.

• Work with Oracle Support for the issues and coordinating with DBA to close the issues.

• Perform P atch Analysis for the patches, Generic Data Fixes G DF and deploy the M aster

D iagnostics Scripts (MGDF) i n PROD to find any data corruption on the t ransactions.

• Write SQL queries t o provide data to the client on any emergency one-t ime need.

• Attend daily conference calls to coordinate with on-site team on support and prepare status

reports.

•

Project : Vale, Brazil

Role : Senior Oracle Functional Consultant (Offshore - I ndia)

Duration :Nov’2009 to Feb’2010

Modules : GL, AP, AR, FA and CM

Vale is a top Brazil based mining company and largest in Latin America. Vale has implemented

11.5.10.2 with 38 operating units with few customizations.

• H igh volume application setups per day to day business need HR Positions, Jobs, and

O rganization H ierarchy setup through Q TP testing tool and D ataload .

• GL, AP, iExpenses, AR, AOL, PO, H R, OM, PA, Form Personalization and related

application Setups for new rollouts added.

• Extracting application setups data through SQL queries and validate them through excel

sheet.

• Support month end close for the financial modules.

• Prepare weekly and monthly estimation on t ime schedule and efforts/resources required for

t he bulk volume setups.

• Configuring customized form which will be applied for automatic Generic Datafix (GDF)

for known issues

• Proactively developed and test custom HR interface program to load daily high volume data

required to setup.

• Develop and run Q TP Scripts and D ataLoad for bulk data

• Write financial modules, system administrator SQL Queries to extract and validate

t he setups for bulk data.

• Interacting with client on clarifications of setups

• Setup changes and validating the same to ensure the deliverables quality

•

•

Madhu Kumar Page 6 of 9

(Oracle Applications Techno-Functional Consultant)

P roject : Shared Pool Support, Global Support

Role : Senior Oracle Functional Consultant (Offshore – I ndia)

Duration :Jul’2009 to Oct’2009

Modules : GL, AP, AR

CSPQ is shared pool support for global Oracle’s customers implemented 11.5.10.2 version.

Supporting for Oracle financial based on 24x7 work basis.

• Production Global Support for G L, AP, PO, AR, CM modules, work on Sev-1, Sev-2

Services Requests r aised by clients across globe

• Support F SG issues and configure FSG accordingly business changes.

• Coordinate On-Demand DBA team, Development team and thi r ty parties required to

resolve third party integrated functionality.

• Plan instance R efresh Schedules for the stage, development and test instances.

• Prepare weekly status report on the worked issues

• Interacting with end users for the clarification on issues through phone, email or web

coference.

• Setup changes and validating the same to ensure the deliverables quality

• Suggesting work around on critical problems.

•

•

Project : Office Depot, Boca Raton, FL

Role : Oracle Functional Consultant (Offshore – I ndia)

Duration :Feb’2008 to Jul’2009

Modules : GL, AP, AR, FA and CM

Office Depot is a largest US based MNC for Retail stationary company. I t has implemented

11.5.10.2 with various customizations including 2 SOB and 2 Operating Units.

•

• Worked on GL, AP, AR, FA, CE, iProc, iPayments, iReceivables, and iSetup

• Configure iSetup module and run to load application configurations from one instance to

another test instances.

• Update B R100 as per change in Business requirement

• Review B R030, BP080, M D050 and prepare Test Scripts for Shakedown and Regression

testing

• Execute Test Scripts as per Shakedown and Regression test documents

• Setup changes and validating the same to ensure the deliverables quality

Madhu Kumar Page 7 of 9

(Oracle Applications Techno-Functional Consultant)

• Prepare application setup queries for all the financial and SCM modules to utilize them in

I nstances comparison utility tool ( E-ICU Tool)

• Validate different instances application configuration to make them in sync with the BR100

by extracting the data from the backend

• Work on A dvanced utilities (Synchronizer) to compare the high volume data extracted

a fter Instance t Instance Setups completed.

• Load the large volume setups by D ata Load tool for and validate them to ensure the

quality

• Attend scheduled conferences daily to interact with Onsite team and Client manager about

work, issues, clarifications and deliverables

•

•

•

•

•

Project : Bharti Airtel Limited, I ndia

Role : Oracle Functional Consultant (Offshore – I ndia)

Duration :Feb’2007 to Feb’2008

Modules : GL, AP, AR, FA and CM

Bharti Ai r tel Limi ted is the leading telecom industries in India. I t has implemented Oracle

A pplications 11.5.10.2 with Standard functionality and India Localization in Finance, SCM,

H RM and CRM modules.

• Gathering Business Requirement Documents for the new Modules Implementation and

analyzing the gaps and Suggesting optimum solutions.

• Engaging with client on new requirements, prepare As-Is Process, To-Be process and

s tudy gap analysis and mapping the requirement in B R030.

• Developed A R I nterface custom stage program to load legacy data into A R interface

• Created various new custom reports for AP, GL, AR, Cash Management and Asset

modules.

• Prepare Functional specifications and coordination with technical team for various

customizations, interface analysis and designing the interface.

• Prepare User Acceptance Test Scripts as per the Business process scenarios and

coordinating the same with Client

• Applications setups for new rollouts and enhancements.

• Prepare various documentation like B P020, BP040, BR030, RD20, M D050, BR100,

C V040, TE20, TE40

Madhu Kumar Page 8 of 9

(Oracle Applications Techno-Functional Consultant)

• Perform mock close and support M onth End Closing and making sure soft close period

• Level 3 Support for month-end activit ies for financial modules, and coordinate with

Technical and DBA for interrelated support issues.

• Interacting with end users for understanding issues and impact of severity of the issue, then

resolving the issue based on priority setup.

•

•

Project : Merial Pharmaceuticals, North America

Role : Oracle Associate Functional Consultant (Offshore – I ndia)

Duration :Jan’2006 to Feb’2007

Modules : GL, AP, AR, FA and CM

•

Project : Namma Cargo Ltd, Saudi Arabia

Role : Oracle Associate Functional Consultant (Offshore – I ndia)

Duration :Jan’2005 to Nov’2005

Modules : GL, AP, AR CM

Madhu Kumar Page 9 of 9

(Oracle Applications Techno-Functional Consultant)

Contact this candidate