Oracle Finance Functional Consultant

ROHIT AGGARWAL

acf1zp@r.postjobfree.com

***-987-***-****

Professional Summery [pic]

> Working with HCL Technologies as 'Consultant' & had worked with Steria

(Previously Known as Xansa) as "Consulting Engineer" & with Mercer as

"Software Engineer".

> Having total experience of 5 years in which Oracle experience is of 4

years in Purchasing, Payable, General Ledger & I-Expense Module, OM.

> Involved in Performing the Setup Steps for Financial Module & I-Expense.

> Motivated team member with sound understanding, good Communication and

Writing Skills and willing to accept exciting challenges.

> Sincere, hard working and good learner with time management skills.

Skills[pic]

> ERP

Oracle Applications 11.5.10.2

R12

> Other

Ms-Office, Tally, Dataloader

HP Application Lifecycle Management 11.00 (ALM)

Yellow Jacket Portal

Professional Experience

[pic]

Involved in implementation of various Functional modules of Oracle

Financials like AP, GL, and Purchasing.

Responsibility:

. Giving functional support for the implementation team.

. Conducted a detailed review of accounting process.

. Actively Involved in Performing the Setup Steps for Financial

Module.

. In depth Functional Understanding of AP, PO, GL Modules of Oracle

Apps.

Payable Setup:

. Defining Financial and Payable options.

. Setting up Banks and Defining Bank Account (Internal & Supplier).

. Defining Supplier with site.

. Creating different types of Invoice, Payment and Payment Batch.

. Matching of Invoices at PO and Receipt Level.

. Transfer of data from AP to GL and Calculation of Vendor Balance.

. Doing Accounting in Payables.

Purchasing Setup:

. Defining Financial, Purchasing and Receiving Options.

. Define buyer, using employee as buyer, supplier and supplier site.

. Define Categories, Items, Approval Group, Approval Assignment.

. Defining Document Types, Open Periods.

. Creating Requisition, Purchase Order including Auto Ceation.

. Setting up of PO Matching and Invoice Match Option.

. Defining Independent Categories, Dependent commodity.

. Receiving and Delivery of Purchase order and their Accounting.

GL Setup:

. Defining Ledger

. Define Accounting Flexfield Structure

. Open Periods, Doing journals, Posting and Reversing.

. Define Cross Validation Rule, Security Rule, Assign Security Rule

Setup.

. Run Journal Import.

HRMS Setup:

. Defining Key Flex Field (Job, Position), Location.

. Define Employees with job position and Supervisors.

. Defining Different Organization (E.G. BG, LE, OU, IO).

Professional Experience [pic]

HCL Technologies

July 2014 - Present

Project Title: Testing

Position: Consultant

Client: Expedia

Currently involve in preparing & execution of the test scripts in Oracle

R12 after understanding the business requirements.

Responsibility:

> Test Scripts preparation on basis of requirement.

> Execution of test scripts on Oracle R12.

Steria India Ltd (Previously known as Xansa) July 2011 - June

2014

Project Title: Off-shore Implementation Oracle Financial

July 2011 - Jan 2014

Position: Consulting Engineer

Client: National Health Services (NHS)

Involved in the Migration of Oracle application from 11i to R12 with IT

Migration/ Technical Team and working on Organization Buildup (Base

configuration).

Role:

> Setting up of Clients in R12.

> Giving all setup options in R12.

> Extraction of Master data from 11i

> Uploading of Transaction data to core (R12)

> Uploading of Transaction data to core (R12)

> Preparing the status reports Daily.

> Testing on various environment before GO-LIVE (T1, UAT & Pre Prod)

Project Title: Testing Service Line

Jan 2014 - Mar 2014

Client: MACE Limited

Involved in preparing & execution of test scripts for change requests for

Yellow Jacket web portal after understanding the business requirements and

raising defects for the same in ALM.

Role:

> Understanding the Business Requirements.

> Test Scripts preparation on basis of requirement.

> Execution of test scripts in web portal.

> Uploading scripts in ALM.

> Raising defect.

> Coordinating with other team for test.

> Ensuring all changes required before live.

Project Title: Testing Service Line

Mar 2014 - June 2014

Client: National Health Services (NHS)

Involved in preparing & execution of the test scripts & coordinating with

development, onshore team & business owners for the change requests in

Oracle R12 after understanding the business requirements.

Role:

> Test Scripts preparation on basis of requirement.

> Execution of test scripts on Oracle R12.

> Raising query/ defect.

> Coordinating with development, onshore team members & business owners to

ensure timely & correctly completion.

Mercer India Pvt. Ltd.

July 2010 - July 2011

Project Title: Off-shore production Support & I-Expense Implememtation

Position: Software Engineer

Involved in I-Expense Implementation, Account Payables & Oracle Apps

Financial Support on System Administrator.

Role:

> Define Employees with Supervisors & assigning of Approver Limits.

> Creation of new Responsibilities, Profile Setup.

> Creation of Expense report in testing environment.

> Approving & auditing of expense report in testing environment.

> Import Expense report & payment in testing environment.

Self Employed

June 2009 - July 2010

Education[pic]

Examination University/ Institute Year Percentage

Board

Bachelor of GGS Indraprastha

Business Univ., Delhi BLS Institute of 68.74

Administratio Management 2009

n (BBA)

Sr. Secondary CBSE 70.50

(XII) (New Delhi) Greenways Modern 2006

Public School

Secondary CBSE

(X) (New Delhi) D.A.V Public School 2004 58.00

Personal Information

Father's name Mahesh Chand Aggarwal

Address A-237, Sector-46, Noida

Date of Birth 17.04.1989

Languages Known English, Hindi.

Hobbies Playing Cricket and to learn new

things.

Date

ROHIT AGGARWAL[pic]

Contact this candidate