Home » Other » Marketplace » Re: Oracle Financial Functional Consultants Needed!
Re: Oracle Financial Functional Consultants Needed! [message #104985] Mon, 16 April 2001 03:27
Gautam Dhirendra
Messages: 1
Registered: April 2001
Junior Member
Gautam Dhirendra
P.O. Box - 4538,
Al Khobar - 31952, Saudi Arabia
Telephone No.- 966-3-8121999, Extension - 165
Email - dhirendra.gautam@unilever.com and



To establish myself as an ERP professional /consultant by integrating the training in Oracle - Applications( Financial ), People Soft and Sun System with live Implementation exposure and functional expertise in Finance, Accounts, Audit and Costing.


1. ERP - Oracle Application Implementation Masters ( Oracle Financials) Certificate from Oracle Corporation.
2. RDBMS - Oracle 7.3,FRONT END - Developer 2000 (Forms-4.5,Reports 2.5)PL/SQL, SQL*Plus, and Programming in DBASE, Operating System- Windows - NT, Windows - 95. From SQL STAR INTERNATIONAL LTD.(An Oracle Authorized Training center) New Delhi. INDIA.
3. Diploma in Information Technology and Computer application from Brilliant Computers .
3. Cost & Management Accountant (I.C.W.A.) from The Institute Of Cost And Works Accountants Of India.
5. Chartered Accountant (Semi Qualified) from The Institute of Chartered Accountants of India
6. Honors Graduate from the University of Patna



About Two and Half year experience in ERP Implementation - Which includes

1. One and half year in Implementation of Oracle Financial (10.7 SC) as a Team member on a Project for MOTOROLA (European Infrastructure cellular Group). Which is done for the Local as well as Global reporting requirement of the Company .

2. And since October.1999 as a Functional Consultant with UNILEVER ARABIA ( wall's ) to Setup, Design and Implement the Functional area of Oracle Financial ( GL, AR and AP ) with MFG - PRO for Supply Chain and SUN SYSTEM, for the functional , MIS and Reporting requirement of the Company.

3. Training in PEOPLE SOFT financials for General Ledger and Accounts Receivable.

4. On Job training in SUN SYSTEM Accounting Software for financial accounting.


Name of Organisation UNILEVER ARABIA ( wall's )
Designation ERP- Functional Consultant
Period October 1999 to Date


A detail Business Process reengineering (BPR) and analysis for understanding of the diverse Commercial and Reporting requirement of UNILEVER for its local requirement in the host country, regional requirement of CAME and its global MIS to UNILEVER plc. London. Which are as under :

GENERAL LEDGER : Set up and designing Set of Books ( SOB ) specially Chart of accounts in accordance with the Stander Chart of accounts ( SCOA ) followed by UNILEVER world wide for its uniform accounting and reporting. Defining Budgets Budget Accounting Cycle & Encumbrance accounting for its AC, LE budgets till TRIC and for Below the line items. Defining various type of Journals like Recurring and Mass allocation journal, Formula-journal, Journal Source and Categories.

REPORTING : Analysis, Design and Implementation of all UNILEVER stander reports :

TREADING TREND - For Calculation of NPS, Product cost, Supply and Distribution Cost and Market development cost to ascertain the Gross profit, Profit before Overhead and TRIC for Concern and Third Party.
FMT - 1 - For Calculation of Category wise OTI, RM/PM/FG Provision and W-off reconciliation and Financial Indirect and Overhead.
FMT - 2 - For Preparation and calculation of Profit and Loss account, Operational Cash Flow, Source & Use of Funds, Category GCE & OCF , Average working capital, Exit working capital & Movements, Other debtors & Creditors, Supply Chain Cost and Balance sheet of the Unit.
BUPA - For calculation of Binzagr ( Third Party ) and UNILEVER ( Concern ) Trading Contribution and Minority Interest.

Lot of other reports like Total Indirect report, Total fixed cost report , IWC calculation of CRV and RLRV etc.

ACCOUNTS PAYABLES : Defining Suppliers ,Setups, Quick codes, Financial, Payable, Receiving & Purchasing Options, according to UNILEVER Accounting Policy and procedure. Defining Expense report & Expense report Templates for different Work Levels of employees as per UNILEVER policy. Recurring invoice for all stander expenses and Provisions made every month as Statistical Charge in accounts of UNILEVER. Payments - Payment type and Payment terms.

ACCOUNTS RECEIVABLE : Defining Customers, Payment terms, Profile Class, Agreements and Price list for Associate and Third Part Customers as per UNILEVER Policy. Accounting & Invoicing rules for Prepaid and Accruals. Setting up Accounting Receipts, Receipt Class, Receipt Source, Receivable Activity, and Distribution set.

Name of Organisation MOTOROLA INDIA LIMITED.
Designation Team Member of MOSAC Team( As Functional Consultant )
Period August 1998 to October 1999.

Being the first ERP Implementation project the basic involvement was in detail Business Process reengineering ( BPR ) of the Organization to turn out the whole system in line with ERP setup. For Setup, design, Analysis and Implementation of Oracle Financial (10.7SC) to meet the functional , Commercial and Reporting requirement on MOTOROLA Corp. Which are as under :

GL : Defining Set of Books(SOB), Designing Chart of accounts, Rollup groups, Summery templates, Defining Recurring and Formula-journal, Journal Source and Categories, Budget Accounting Cycle & Encumbrance accounting, STAT Currency & Journal, Financial statement report generator(FSG) , Row & Column set and Reports.

AP & PO : Setups, Quick codes, Financial Options, Payable Options, Receiving & Purchasing Options, Defining Supplier, Expense report & Expense report Templates, Special Calendars, Recurring invoice, Tolerance, Invoice Hold & Approvals, Payments - Payment type, Bank & Bank Account, Payable Document, Payment term, TDS & Withholding tax.

AR & OE : Setups, Quick codes, system options, Customers, Payment terms, Profile Class, Agreements, Price list, Accounting & Invoicing rules, Tax code - Exemptions & Exceptions, Order type, Order-Cycle, SVRS, Discounts. Securities rules, Transaction-type, Invoice Batch source, Setting up Accounting Receipts, Receipt Class, Receipt Source Receivable Activity, Distribution set, Bank & Bank Account.

INVENTRY : Setups, Quick codes, Workday calender, location, Inventory Organization, Operating Unit, Legal Entity, Defining Items, Control level of status Attributes,, Inventory control, Lot, Revision & Serial, Item categories & Catalogs , UOM, ABC analysis, Cycle counting and physical counting, Inventory Planning Min-Max, Reorder point planning and Replenishment count.

Designing Tables, Normalization, SQL, PL/QSL Codes, Descriptive & Key Flex-Fields, Creating Responsibility & User, Document sequence numbering and Customizing Reports & Forms as per Oracle Application standers.

Oracle Inventory, Oracle Purchasing. Oracle Payables, Oracle Order entry, Oracle Receivables, Oracle General ledger , Oracle Application object Library, Oracle Flex Fields and Oracle application system administration.

Being Strong Functional person in Finance and Accounts having 7 years of experience working as an Finance and Accounts Manager , Mgr. MIS, Cost & Management accountant, Auditor and Financial Analyst responsible for Various types of Commercial work in area of Accounts, Finance, Costing, MIS, Direct & Indirect taxation, Budgets, Project reports, Working Capital Management & Ratio analysis, Fixed Assets and Capital Budgeting, Treasury and Forex management, External-Internal & Management Audit work and all other allied commercial and Company Secretarial works.

(Gautam Dhirendra)

Previous Topic: Re: Oracle DBA - Columbus Ohio
Next Topic: Re: Oracle DBA needed in Cleveland, OH
Goto Forum:

Current Time: Fri Oct 22 21:48:55 CDT 2021