Anshu Garg

Contact no 818-***-****

abg17c@r.postjobfree.com

Summary

. Overall 6+ years of strong experience as an Oracle certified financial

consultant with strong Functional experience in application set-

ups, implementation, conversions, interface development, testing and

end-user training.

. Currently working on R12 Upgrade from 11.5.10

. Extensively worked on modules such as General Ledger (GL), Account

Payables (AP), Account Receivables(AR),Cash Management(CM),Fixed

Assets(FA),Purchasing(PO),Project Module PA).Inventory (INV) and Order

Management (OM), Costing

. Expertise in the functional and technical aspects of Oracle E-Business

Suite/ Applications 11i deployment Requirements Study, GAP Analysis,

Requirements Mapping, Development, Customizations, Testing, and

Functional User Training.

. Strong knowledge of development methodology including Structured

Systems Analysis and Design.

. Played main role in analysis, design, development, testing,

implementation, production support and documentation of Oracle E-

Business Suite .

. Experience in implementing Procure-to-pay, Order-to-cash Cycles.

. Development and Enhancement Request for Customizations

. Expertise in development tools such as Financial Statement Generate

Reports,

. Experienced on Project go-live and post-implementation support.

. Proficient in corporate finance/ resource planning, financial systems

evaluation, design and implementation.

. Prepared Test cases TE-020 for Financials modules (AP, AR, and GL).

. Prepared detailed user Requirement for New Development.

. Conducted training for end users

. Interacted with Business users and the client for providing testing

and Production Support as Functional Consultant after GO Live.

. Conducted CRP Presentations for User Community

. Troubleshoot all set up related issues.

. Developed Functional design documents ((MD-050, BR-100)

. Worked extensively with development team members in resolving issues

by creating

. TAR(s) and obtaining one of the solutions using METALINK

. Worked on Custom Bolt on Programme & integrate with Oracle like

IMPACC System and commission accounting

. Worked on Investment Custom Programme

. Knowledge of OBIEE

Expertise

ERP General Ledger, Accounts Payable,

Accounts Receivables, Assets, Cash

Management, Purchasing, Inventory,

Project Accounting,, Order Management

Packages EBS Suit Oracle Applications 11i

(11.5.10.2).

Tools/Utilities FSG, Web ADI, Data Loader,Citrix

LANGUAGES SQL, PL/SQL,.

Office Tools MS Word, Excel, Power Point, Visio.

Education

ICAI from Institute of Chartered Accountant of India.

Trainings

ERP : Knowledge of following Modules

- Oracle Receivables

- Oracle Payables

- Oracle General Ledger

- Cash management

- Project Billing & costing

. ERP : Conversant With

- Oracle Order Management

- Oracle Purchasing

- Oracle Inventory

- Pl/Sql Training

. Six Sigma Green belt

Achievement

. CMD Award for delivering Superior Results

. Appreciated by CFO for completing Six Sigma with in Timelines &

achieving targets

. Spot award for resolving difference in Cash management

Professional Experience

Total experience of more than 8 years (including 6 experiences in EPR

implementation)

Company : Cummins

Designation: Executive Manager

Period : 2006 to till Date

ENGAGEMENT HISTORY:

Cummins Generator Technologies Ltd.

Oracle Finance Functional

May'2010 - Till Date

Environment

Oracle Applications11.5.10.2(AR,GL,AP,PO,SysAdmin),

Scope

Cummins Generator Technologies Ltd.is a manufacturing company that

manufactures Alternators. CGT has Implemented oracle Financials and

Manufacturing Modules. This project is mostly involved in implement Oracle

for all modules from legacy system and Production support of Oracle

Financials & other Modules

Responsibilities -

. Set up for Operating Unit

. Defined the critical business process being implemented

. Define Project Timelines, arrange for CRP, manage technical

development, period review, report preparation etc.

. Implementation of Oracle Payables including setup of payment options,

payment terms, distribution set, payment format, banks, tax codes.

. Implementation of Oracle Receivables including setup of system

options, payment terms, transaction types, transaction sources, auto

accounting, banks, receipt methods, receipt classes, tax codes.

. Creation of Menus & responsibilities as per SOX Control

. Enable Security Rules & Cross validation rules

. Help to implement Purchasing, Order Management modules, Inventory

Modules in relation to finance flow and testing the flow.

. Pre-production pilot testing and manage schedules for end user

training

. Create User Requirement, Solution Design Documentation, Set up

documents, Test cases, User Training Documents

. Prepare documentation and sign off process before and after every CRPs

. Developed auto reversal program to reverse the batch, and post to GL

program and then reconcile journals in Oracle general ledger as per

business requirements.

. Participated in user testing, helped in migration to production.

. Participated in User testing, and Involved in Production support for

Oracle Receivables and Financials modules

. Monitor progress on remedy tickets/dev, tracks within the team and

ensure SLA compliances on ticket worked on by themselves and team

members.

. Providing production support of Oracle financials, including following

up SR's with Oracle metalink

. Created M.O.P (Method of Process) documents for all the custom

programs developed.

. Development of FSG report for financial Analysis

Six Sigma

Oct 2009 to April 2010

Environment

Oracle Applications11.5.10.2(AR,GL,AP,PO,,FA,InventorySysAdmin),

Completed Six Sigma Project to reduce the timelines from 207 Man hours to

95 Hours for CMI Closing .Achieved target by introducing automated

processes to reduce man hours with accuracy and in time solution. Completed

Six Sigma project before time.

My Role included -

. Analysis of Base Line Study - Activities involved, ownership of

activity, analysis of each activity and time consumed by each resource

. Identifying possibility of automation of activities using Oracle

Reports or identify requirement of new developments

. Requirement gathering of new reports and preparation of requirement

document

. Development of FSG report for financial Analysis

. Acted as a liaison between developers and clients to enable product

development with close fit to clients requirements

. Implement oracle functionality to avaid manual work like early payment

discount function

. Enable personalistion to restrict user for selection of wrong account

& wrong Taxes

. Implementing the solution

. Create Alert if something is in interface to make reconciliation more

easier

New Operating Unit CBS Setup

July 2009 to Sep2009

Environment

Oracle Applications11.5.10.2(AR,GL,AP,PO,INV,Sysadmin

Implemented New Operating unit Cummins Business services) as a functional

expert, Task Handled-

. Implementing Receivables, Payables, General, Purchasing, Order

Management & Inventory modules

. Create User Requirement, Solution Design Documentation, Set up

documents, Test cases, User Training Documents

. Creation of Menus & responsibilities as per SOX Control

. Define Project Timelines, arrange for CRP, manage technical

development, period review, report preparation etc.

. Prepare documentation and sign off process before and after every CRPs

. Pre-production pilot testing and manage schedules for end user

training

Apr 2009 to Jun 2009

Implemented role based access roles

I worked as a financial Expert in implementing of role based Access Control

for Cummins Sales & Service India Limited, (known more as CDSS), a

distribution company for Cummins in India.

Involved in Implementation for Role based for Cummins Research and

Technology India Limited (CRTI) & Power Generation Business unit.

Setup of Trading-Warehouse

Apr 2008 to Dec 2008

Environment

Oracle Applications11.5.10.2(AR,GL,AP,PO,INV,Sysadmin

My role included:-

. Implemented Receivables, Payables, General, Purchasing, Order

Management & Inventory modules

. Create User Requirement, Solution Design Documentation, Set up

documents, Test cases, User Training Documents

. Define Project Timelines, arrange for CRP, manage technical

development, period review, report preparation etc.

. Prepare documentation and sign off process before and after every CRPs

. Pre-production pilot testing and manage schedules for end user

training

. Use ITPM Mythology to complete this Project

Implement11.5.10.2forCumminsGroupofCompanies

2006 to Mar 2008

Environment

Oracle Applications11.5.10.2(AR,GL,AP,PO,INV,Sysadmin)

Implementing Oracle Applications 11.5.10.2 for Cummins Group of Companies

in India & coordinate with US Provide Infant care Support .Task handled-

General Ledger -

. Set of Books - Creation of Value Sets, Segment Calendar, Currency

and Chart of Account.

. Defining account aliases.

. Defining Security Rules and Cross Validation Rules

. Defining Journal Sources and Sequences for Journal Sources.

. Open/Close of GL Periods

. Assigning of Profile Options.

. Documentation of Set ups and Testing.

. Creation of Descriptive Flexfields and contexts.

. Creation of Reports using FSG.

Accounts Payables -

. Defining Payment Terms, Distribution Sets.

. Defining Payment formats for Checks.

. Defining Financial Options and Payables Options.

. Defining Special Calendar for Tax due Dates and aging periods.

. Creation of Bank and Bank Accounts.

. Defining Vendors and Vendor Sites.

Accounts Receivables -

. Defining Transaction Types and Transaction Sources

. Defining Rules and Auto Accounting Rules.

. Defining Payment Terms and Aging buckets

. Defining Sales Person.

. Defining Receivable Activities.

. Defining Payment Methods and assigning Banks to Payment Methods.

. Defining Customers and Customer Sites.

System Administrator -

. Defining New Users, Creation of New Responsibilities.

. Assigning Responsibilities to users.

. Defining Request Groups, Assigning Request Group to Users.

. Assigning profile option to the responsibilities.

End User Training -

. Preparation of End User Manuals.

. Providing online-end user training to the users.

Other Activities -

. Managing implementation meetings - internally with the consultants

and with the clients.

. Providing MD 50 to the Technical Consultants for development of new

reports and customization of seeded forms and reports.

.

Company : Bestech India Limited

Designation: Finance Manager

Period : July 2004 to Feb 2006

Bestech India Ltd is specialized in Construction industry.

Job profile:

1) Balance sheet finalization & handling all legal and financial matters.

2) Quarterly closures for Indian financials

3) Receivables management

4) Budget Preparation

5) Taxation

Company : Star Alu build Pvt. Ltd

Designation: Finance Manager

Period :

Jun 2002 to Jun 2004

M/s Star Alubuild Pvt Ltd . its Head Office located in Gurgaon is one of

the Manufacturing company . The Books of account of the company are

maintained in "Tally" accounting package.

Job Profile:

Being Manager - Finance, the job responsibilities included:

Monthly reporting .: Preparation of monthly financial statement to be

reported

Stock Valuation on monthly basis

Costing of IC engines & Diesel Generating Set

Maintenance of books of accounts up to preparation of financial statements;

Liaoning with banks

Payroll processing

Receivables management.

Cash flow management;

Providing other Management Information Systems (MIS) reports as required by

the management such as Daily Sales Report, Monthly Sales report working

etc.

I am sincere and precise in my work and try to achieve the best from

anything I do. I believe in team spirit and can prove myself as an active

team member when entrusted to with my amiable personality, good

communication skills and strong belief in human relationships. Whatever I

have achieved I will cherish throughout my life and am still on the look

out to attain higher goals.

References: On request

Contact this candidate