Functional Consultant Oracle
Resume:
M adhu Kumar
Lead Oracle Applications Techno-Functional Consultant
Mobile : 214-***-****
E-Mail : ******.******@*****.***
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