Oracle Project

Manish Drona

Simi Valley, CA, *****. Cell - 805-***-****. Email -

***********@*****.***

* ********

. Dedicated professional with CPA and CA degree having overall 12 years

of experience in areas like IT Support, IT Consulting (ERP),

accounting & finance including 7 years of experience in Business

Analysts role.

. Core competency in domain knowledge of Oracle Financial (EBS) support

and implementation

. As a Business Analyst's, acted as liaison between Accounting/Finance

and IT groups on supporting, standardizing process, testing, training

- improving efficiency and cost reduction.

. Handled full fledged support activity for financial modules (GL, AP,

AR, FA, CM, PA and Adv Coll.) in global environment including

consolidation and multiple currency operations.

. Also successfully completed few "full life Cycle" Implementations;

prepared System Architecture, critical review of systems.

2 Work Career - A Snapshot

. Presently working as Senior Oracle Business Analyst, Sunkist Growers,

Sherman Oaks, CA. (Since 04/2008)

. Senior Systems Analyst, Allergan Medical (Previously Inamed Corp)

Santa Barbara, CA. (10/2003-03/2008)

. Associate Consultant, Infosys Technologies Ltd, San Diego, CA(10/2001-

10/2003)

. Associates, Oracle Apps Group of Satyam Computer Services Ltd.,

Hyderabad, India (03/1998-10/2001)

. Account Manager, Finance & Accounts, Crane Bank Ltd, Kampala, Uganda.

(08/1996-03/1998)

Professional Qualification

. Passed Certified Public Accountancy (CPA) Exam, 2006 California, US.

. Institute of Chartered Accountants of India, 1996 (All India Rank)

Mumbai, India.

. Bachelor of Commerce (Hons), 1995 (1st Rank in College) Mumbai, India.

. Oracle Financial Training, 1998 ("A" Grade) Hyderabad, India

Technical Skill

. Enterprise Resource Planning - Oracle Applications (GL,AP,AR,FA, CM

and PA)

. Utilities, Tools & GUI - Financial Statement Generator, Data Loader,

Application Desktop Integrator (ADI), WebADI, TOAD, SQL, Discoverer.

5 Professional Experience

Sunkist Growers (Since Apr-2008)

As a Senior Oracle Business Analyst - Production Support and Implementation

of Oracle Financials 11.5.10.2:

I am handling Production Support (day to-day activities) for financial part

(GL, AP, AR, FA, CM, Advanced Collections, Budgets and PA module). My role

here includes

. Handling the Role like - Everything related to Oracle Financials,

falls under my responsibility, including first and second level

support, training, testing - beginning to end driver for any oracle

financials related issue.

. Supporting day to day operational issue and month end support for all

financial modules.

. Acting as Internal Consultant - acting as liaison with finance and IT

Dept - resolving, prioritizing work orders/issue log,, improving

efficiency, actively involved in planning, implementing and executing

system implementation, upgrades, patching and enhancements,

. Writing ad-hoc queries with TOAD for data required by users/ internal

auditors from time to time.

. Implemented Electronic Funds Transfer (EFT Project) and Management

Report enhancement project.

. Successfully implemented Project Costing and working on implementation

of Project Billing module.

. Finding out gaps and suggesting new functionalities as for improvement

of finance function.

. Supporting management reporting through Financial Statement Generator

(FSG) and ADI.

. Currently working on implementing WebADI and Report Manager.

. Working on planning for R12 upgrade.

Allergan Medical (Formerly Inamed Corp) (Oct-2003-Mar 2008)

As a Senior Systems Analyst - Production Support and Implementation of

Oracle Financials 11.5.9:

I handled Production Support (day to-day activities) for financial part

(GL, AP, AR, FA and CM). My role

Included -

. Supporting day to day operational issue for all financial modules -

GL, AR, AP, FA and CM. for US, Costa Rica and Ireland operations -

multiple SOB and multi-currency with MRC feature.

. Acting as Internal Consultant (in fact joined Allergan after working

as Consultant), acting as liaison with outside consultants for

improving efficiency.

. Implemented Cash Management module with auto reconciliation for very

complex bank reconciliation

. Giving full fledged support for month close activities including all

Reconciliations.

. Implemented Consolidation and management reporting for consolidated

companies data.

. Writing ad-hoc queries with TOAD for data required by users/auditors

from time to time.

. Worked actively in upgrades, Critical patching - testing, planning

etc.

. Owned most of the financial system Setup/Configuration documents with

proper tracking of changes and maintained issue log etc.

. Supported Great Plans reporting system with Financial Statement

Generator reports.

. Handling SR and continuous liaison with Oracle regarding the software

related issues.

. Worked actively in integration project of Oracle Application with SAP.

. Worked actively in Sarbanes-Oxley Segregation of Duties project.

Infosys Technologies Ltd. (Oct-2001 to Oct-2003)

Handled all consulting project including -

Implementation of Oracle Financials 11.5.8 for Panasonic Inc, San Diego,

CA: (Jul'02 to Sep'03)

Lead the team for implementing all finance modules for Oracle

Application11i at Panasonic Inc., San Diego, CA, US. After preparing Master

Global Template at Matsushita Headquarter, Japan, my role here included

. Fit/Gap Analysis of Master Global Template process with the local

requirement of Panasonic.

. Implementation of Finance modules (AP, AR, GL, FA and CM) in a team.

. Suggesting the best practices in the industry in conjunction local

requirement and within the preview of Global Template considering the

System constraint.

. Making suitable input for Global Consolidation at Headquarter, Japan.

. Liaison between the Key User, Regional Head Office and Head Quarter

regarding implementation issues.

. Guiding the local IS staff for Data Conversion issues starting from

Strategy for Data Conversion.

. Supporting daily operation for all Finance Module.

. Guiding for Customized Report, Interfaces etc.

System Appreciation Study for Matsushita Electric Industrial Co., Ltd,

Japan: (Feb'02 to Jun'02)

Involved as a team member in studying and analyzing Global Standard

Template. The detailed activities carried out are as follows:

. Analyzing requirement analysis of Global Standard Template and UK

implementation.

. Analyzing business process of Global Standard Template and UK

implementation.

. Analyzing fit/gap analysis, solutions design for Global Standard

Template and UK implementation.

. Analyzing set up of Global Standard Template and UK implementation.

. Analyzing CRP of Global Standard Template and UK implementation

. Recommending the best practices from Global Standard Template and UK

implementation for Master Global Standard Template to be used for

Global Roll-outs.

. Recommending other best practices to be included in Master Global

Standard Template.

Managerial Reporting Requirement Definition for TOSHIBA Europe GmbH,

Germany: (Nov'01 to Feb'02)

Involved as a team member in carrying out requirement analysis. I was

responsible for Functional related activities for managerial reporting and

providing the source of data from various systems. The activities carried

by the whole team are as follows:

. Define Architecture Requirement

. Review business requirement and data model.

. Evaluate alternatives with their requirements.

. Provide recommendations on what alternatives can be considered.

. Reviewing Oracle Financial Analyzer and MS SQL 2000 in more details as

the expected the tool for the Managerial Reporting Requirement.

. Verifying that all the expected Managerial Reports will be available

in OFA or MS SQL 2000.

. Analysis risks associated with the chosen products.

Satyam Computers Services Ltd. (Mar-1998 to Oct-2001)

Implementation of Oracle Applications11i at Gati Cargo Management Limited,

Hyderabad: (Jun'00 to Oct'01)

Involved as a team member in the implementation activities and responsible

for Accounts Receivable and Cash Management -

. Involved in the study of business processes of Gati Limited for Oracle

GL, AR and CM.

. Involved in ascertaining the feasibility of configuring the required

reports from the viewpoint of functionality of the AR and CM and

provided the relevant design for customization in terms of defining

the functional process and the relevant tables and fields that are

impacted.

Production Support of Oracle Financials at Aayan Leasing and Investments

Ltd., Kuwait: (Oct'00 to Mar'00)

Involved in the entire gamut of production support activities relating to

AR, CM, AP, FA and GL modules.

As a team member, my basic responsibilities included:

. Ascertaining the feasibility of configuring the required.

. Providing extensive functional inputs for development of interfaces

between the existing system and Oracle.

. Testing - unit testing & integration testing.

. Providing functional Inputs & Coordinating with the technical team for

custom development, as the same was crucial for customization.

. Providing post implementation support covering all the above modules.

3 Related Functional Experience:

As part of my work experience, I have been involved with in providing

consulting, finance and audit services. A brief profile of my experience is

given here.

Had conceptualized, designed and developed comprehensive systems and

controls for operational, accounting, management information, performance

evaluation and budgeting. Have been with major group for over two years,

providing accounting and consulting services. My major responsibilities

were

. Monitoring & Maintenance of Flow of System in accountancy including

Bank's Disbursement account, Journal Voucher, Ledger accounts, Cash &

Bank books with reconciliation, Asset Register.

. Calculating, paying & claiming all taxes like VAT, Income Tax, Import

Duty and liaison with all related government offices.

. All basic preparation for auditing, by auditors, internal as well as

external and working simultaneously with them for the preparation of

Balance-Sheet, Funds Flow, Cash Flows.

. Generation of MIS reports using Ms-Excel. All these activities were

for group of companies diversified in Banking, Insurance, Finance,

Hotel, Resort and Gas Station.

. Monthly closure of all books and presenting Profit and Loss Account,

Balance Sheet to top management.

Personal Information:

- Age: 35 yrs

- Visa Status: Holding Employment Authorization (renewal till Green Card

is approved).

- Reference: Available upon request.

Contact this candidate