Functional Consultant Project Manager

Oracle Apps Finance Functional Consultant

Talari Mu rthy Mobile: +60-176******

E -Mail:

Oracle Apps F inance Functional Consultant

t acn7nk@r.postjobfree.com

P rofile Summary:

• Have an overall 6+ years of professional experience out of which 5+ Years related

t o the O racle Apps Financials as a F inance Functional Consultant .

• Analyzing and identifying the functional requirement of client and maintain its

v isibility throughout the implementation.

• Have been working in Oracle applications financial modules ( GL, AP, AR and

P O) Good knowledge in FA and C M .

• Good exposure on E-Business Tax Setups

• I have been working in O racle HR MS Module (Preparing Template and Extract

t he Data from legacy system and Cleansing duplicate data etc.)

• Hands on experience with D ata cleansing and M igration i n Oracle R12.

• Basic SQL data extraction knowledge

• Comfortable with data presentation / analytics using Excel

• Involve as a team member in P rocure to pay & Order to Cash

I mplementation.

• Configuration of Instances and Prepare Setup Documents (BR-100) and Test

scripts based on the business requirement.

• Preparing the T est Scripts based on the business process of the client and

worked on the Business system testing before submit ting.

• Preparation of t raining documentation for the user t raining and helping

t he technical consultant to arrive at the functional aspects.

• Configuration of Instances and Prepare C ustomization Documents (MD-050)

and T est scripts based on the business requirement.

• Interaction with client through r egular conference and web-cam calls.

• Good Experience in form personalization & Multiple I nstances (DEV, DIT,

T E & Prod).

1

Oracle Apps Finance Functional Consultant

Experience:

1. Working as an O racle Apps Finance Functional Consultant w ith “Amway

A TLAS I n te rnship P rogram” u nder payroll o f D igital Intelligence Systems,

L LC (D ISYS), Kuala Lumpur, Malaysia. F rom April-2014 to till date .

2. Worked as an A pplication Consultant (Oracle Techno functional Consultant ) with

“I nternational Baccalaureate ” under payroll of Optimum Solutions,

S ingapore . (Nov-2013 to Ma r-2014)

3. Worked as an O racle Business System Analyst w ith D ell I nternational Services

I ndia Pvt. Ltd (D IS), Bangalore, I ndia Sep-2011 to Oct-2013.

4. Worked as an Oracle Apps F inancials Associate Consultant w ith S imtec Global I T

Services Pvt. Ltd F rom Nov-2008 to Jun-2011.

5. Worked as a J unior Accountant w ith M ed-Ex Soft I ndia Pvt. Ltd . from Oct-2006 to

M ar-2008.

Educational Qualifications:

• Bachelor of Commerce with Computers (B.com Computers) f rom Sri

K r ishna Devaraya University, Anantapur, Andhra Pradesh.

2

Oracle Apps Finance Functional Consultant

Applications and Development Skills

Operating Systems Windows Server-2003, XP, 2007 & 2008

Package Tally 6.3

Oracle Applications General Ledger, Oracle Purchasing and Accounts Payable,

11i & R12 Accounts Receivables, Fixed Assets and Cash Management.

Project #1: I mplementation & Rollout in R12 (12.1.3)

D uration: April-2014 to Till Date

M odules Involved: GL, AR, OM & OMS

Role: Finance Functional Consultant.

C lient: Amway I T Services Sdn Bhd C yberjaya, Malaysia.

Amway IT Services Sdn Bhd, a subsidiary of Amway Incorporation in USA, is the Global Data Centre and IT

Service Hub for markets in the Asia Pacific region. This Global IT Hub is located in Cyberjaya and serves as a

regional shared services center, regional IT infrastructure and support services center.

Roles and Responsibilities:

A nalyze business requirements to identify testable conditions

Develop or lead functional test planning based on business and functional requirements

Build test cases with detailed test conditions and directional/navigational test steps

Support the creation and maintenance of test data in the test environment

Conduct and participate in functional test plan inspections and obtain key stakeholder signoff

Execute and validate the functional test plan to ensure the business requirements, functional

and navigational requirements are met.

Conduct data analysis and validation to ensure all system and application modifications meet

t he end user business requirements

Preparation of project documentation such as test scripts (TE40), standard operating procedures,

and training materials

Identify, document, communicate, support and follow through to resolution of defects

Review requirements documents for accuracy and completeness and ensure coverage by

appropriate test cases

Partner with the developers in validation and resolution of problems in new and existing

applications.

Develops Quality Assurance standards, practices and procedures, especially as it pertains to test

data creation/maintenance.

Involved in daily conference call with onsite team for UAT Progress

Preparing for and participating in the CRP workshops

Preparing for and conducting FUT,SIT and UAT.

Liaison with Oracle for support on various critical issues

3

Oracle Apps Finance Functional Consultant

Project #2: Upgrade & Implementation from 11i to R12 ( IB)

D uration: Nov-2013 to March -2014 (Onsite)

M odules Involved: GL, AP, AR, FA, CM & HR MS

Role: Application Consultant

O rganization: I nternational Baccalaureate Pte Ltd ( IB), Singapore.

The I nternational Baccalaureate (IB ), formerly the I n ternational Baccalaureate

O rganization (IBO ), is an international educational foundation headquartered in Geneva,

S witzerland and founded in 1968. IB offers four educational programmes for children aged

3–19.The organization's name and logo were changed in 2007 to reflect reorganization.

Consequently, "IB" can refer to the organization itself, any of the four programmes, or the

d iploma or certificates awarded at the end of the diploma programme.

Oracle Apps Implementation in I nternational Baccalaureate Business School. Each

having a Implementation Team of KPMG and we in I nternational Baccalaureate, is giving

Support to them technical and functional. Oracle Application R12 modules General Ledger,

Accounts Payables, Accounts Receivables, Cash management, Fixed Asset, HRMS .

Role: I n terface between the Oracle Implementation team and IB Finance Users .

Responsibilities:

Coordinated between business operational user, end user and project manager.

Review the data conversion requirements and strategy.

Extract conversion Data for financial modules from 11i.

Work with Finance users to reconcile and validate accuracy of converted data.

Review test plans produced by Oracle Implementer and guide finance users in

developing test scenarios and sign-off for UAT test(s).

Review and validate accuracy and correctness of deliverables produced by Oracle

I mplementer for the business requirement definition phase prior to.

Sign-off by finance process Owners.

Participate in cross module testing during the In tegration Testing.

Drive and co-ordinate end-user’s UAT.

Review Users’ M anual & Training documents.

Cleansing the Duplicate or Mul tiple Customer Masters and Vendor Masters.

Preparing Data Template in Oracle HRMS and Financial Modules.

Preparing Conversion and Design documents like CV-010, BP-080 in Oracle

F inancial.

4

Oracle Apps Finance Functional Consultant

As a functional consultant, responsible for studying the business process. P repared

AS-IS understanding document for AP,FA,AR,GL,CM

Transform 11i Data for R12, working with the End Users.

Assisted in business process reengineering, created TO-BE process document .

Performed GAP analysis and prepared solution presentation for review .

Performed functional testing for existing modules to understand existing business

p rocess, created documents to understand functional requirements for interfaces.

Prepared Mapping document RD.50 and setup document BR.100 for

AP,FA,AR,GL,CM module

Testing of various test scenarios.

Understood existing interfaces and provided AS-IS document.

Giving user t raining to end user

Preparing the MD 50 document for various interfaces.

Setting up AP,FA,AR,GL,CM modules

Involved in some activit ies for Oracle System Administration module such as

Registering the Users and assigning responsibilities, printers in Oracle Apps

Creating new responsibilities and defining the required system profile options

Enabling Key Flex field and Descriptive Flex field.

Prepare issue and r isk t racker and submit to client weekly basis

W riting / executing scripts using SQL Navigator to perform various extracts from

database.

P roject #3: OMEGA Environments. (OMAR)

D uration: Sept-2011 to Oct-2013

Modules Involved: AR, GL, OM.

Role: Oracle B usiness System Analyst

Organization: D ell I nternational Services I ndia Pvt. Ltd (D IS),

B angalore.

Team Size& Name: 18 & OTC_FUN_SETUP_TEAM

Role:

Participate in all Instances phases as required and provide input that

helps PMs to create a consistent and relevant schedule (PROD,DIT, DEV,

T E1&TE2)

E-Business Tax Upgrade Considerations

5

Oracle Apps Finance Functional Consultant

US Sales and Use Tax - Setup Considerations

Canada VAT & Recovery - Setup Considerations

Latin Tax Engine - (Mexico, Argentina, Chile and Brazil)

Preparing Business Process As is Document and Mapping with Oracle 11i.

Discrete manufacturing standard process and preparing to be Document for the

business process.

Prepared the Setup documents for the configuration of Oracle Purchasing.

Worked in the Documentation and setting up of the Multi Organization Access

Control (MOAC) Setup.

Prepared the test Plans.

Understanding the methodologies and their interaction with other business

p rocesses and applications.

Taking decisions independently and interacting directly with the implementation

partners.

Preparing Training Documents

Worked as Help Desk member after post implementation providing

f unctional business solutions.

Configuration of Setups for AR, PO and GL Modules in Dev and Test

I nstances

Interacting with the users for process pending activities and

Requirements.

Providing Functional documentation for Technical Team for

developing reports

Project #4: Applera Corporation.

D uration: July-2010 to Jun-2011

Modules Involved: GL, AP, PO and AR.

Role: Oracle Associate Consultant

Organization: Simtec Global I T Services Pvt. Ltd. Bangalore

Applera Corporation consists of the Applied Biosystems Group; The Company is focused on

t he discovery, development, and commercialization of Novel Diagnostic Products. The

p roject was to implement and customize the Oracle Applications R12. The various modules

of Applications

Role:

6

Oracle Apps Finance Functional Consultant

In teract effectively with customers, developers, and peers to ensure the successful

delivery and implementation of the solution.

Modified check-printing program in AP to suit new company requirements. Provided

modifications to custom Expense Distr ibution Report in AP.

Ongoing technical and functional support for oracle application modules like GL, AP,

AR and monitoring user activity, supporting user requests for new oracle reports,

C reating Concurrent Programs and make the report as executable

All Support Tickets in All module in I, Purchasing, General Ledger, Payable, and

Receivable Modules

Involved in solving various functional issues related to GL as well in the functional

analysis of GL reports to meet the User requirements.

Imported assets invoice into accounts payables and integrated to different modules

for fur ther processing of mass additions.

Use the proactive approach in month End closing, cleared all the pending

t ransaction in Inventory and close the sub ledgers.

Discuss all the issues with business on weekly call. Send the document to users for

t he user Training related issue to decrease the no of logs.

Discuss the development and Enhancement Task list with business on weekly.

Project #5 Bridgestone ( Implementation)

D uration: Jul-2009 to Jun-2010

Modules Involved: GL, AP, PO and AR.

Role: Oracle Associate Consultant

Organization: Simtec Global I T Services Pvt. Ltd. Bangalore

Br idgestone is one of the biggest tyre and rubber manufacturers in the world and i t sells its

t yres and other products in more than 150 nations, Tyres and Tubes, Automotive Parts,

Chemical Products, Electro-Materials, Sporting Goods, Bicycles and other products.

Role:

7

Oracle Apps Finance Functional Consultant

Responsible to perform process analysis, design, integration, testing,

i mplementation, documentation based on AI M Methodology

Creating AP Invoice Types like Prepayment (Advance Payment), With hold Tax

setups and AR Invoice Types like Deposit & Accounting Rules, Invoice Rules etc.

Defined Payment terms and recur ring invoice templates. Set up employee expense

templates and distribution sets. Activated some descriptive f lex fields to capture

additional information for the client not available in standard oracle forms. Set up

Suppliers and Banks for AP use.

Order-to-Cash: Receivables processes including Revenue Recognition, Collections,

I nvoicing; understanding of integration with Order Management, Inventory, GL,

Cash Management

Responsible for define different types of standard and financial statement and drill

down through application development integration.

Involved in solving various functional issues related to Financial Module (AP, AR,

PO and GL) as well in the functional analysis of financial reports to meet the User

requirements.

Core Review Team Member: The team reviews of all critical development work,

w hich are planned to go live in production. The primary purpose of review is to find

i mpact of design changes into system so as to have defect free design.

Study and improve performance of existing business functionality within Oracle.

Developed new programs to enhance business functions.

Gathering the requirement for new functionality understand and convert it in

technical terms and assign it to resource and help them to deliver i t on t ime

Responsible to reconcile the all Financial modules (AP, AR, GL and PO) and period

end close by month to all financial modules

P roject # 6 Supporting

Client: B rocade

8

Oracle Apps Finance Functional Consultant

Duration: Nov-2008 to Jun-2009

Role: T eam Member

Organization: Simtec Global I T Services Pvt. Ltd. Bangalore

Brocade is an industry leader in data center networking solutions and services that enable

organizations to manage their most vital information assets. Global 500

companies rely on Brocade technology to keep their businesses running around

t he clock.

Role:

Supporting the Installed product of Oracle financials 11i.

My work is involved in GL,AP and PO

Submission of Weekly reports to the Client about Ticket Statuses

Planning, Designing and delivering custom and standard features including oracle

payables, and oracle general ledger to the end users.

Interacting with Users for required information about the issues arise

Handling the t ickets, resolving the issues on day to day basis on priority.

Undertaking all steps necessary to satisfactorily closure of the t ickets raised by

clients.

Interacting with Project manager on daily and weekly basis and submit ting status

report

Handling situations for run t ime problems and suggesting the work around.

Domain Experience

Responsibilities:

Vouching the bills for sale or purchasing of Materials.

Maintenance of Debtors ledger, Creditor Ledger.

Writing Purchase and Sales registers.

Preparation of final accounts- Trial balances, P&L account and Balance’s

sheet.

9

Oracle Apps Finance Functional Consultant

Computation of total income for individuals.

10

Contact this candidate