Engineer Software
Resume:
Oracle Finance Functional Consultant
ROHIT AGGARWAL
***************@*****.**.**
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