Page 1 of 1

Role of an Oracle Functional Consultant?

Posted: Sat Aug 01, 2009 11:54 am
by aruns
Hi Everybody,

I always get confused by the role of a Oracle Financial Functional Consultant.

What is the role of a Functional Consultant?

a) In case of conversion to Oracle Financials from Legacy systems
b) In case of upgrades(For instance from 10.5.9 to R12) ,patch application etc other than post implementation testing.
c) In case of a customised implementation of Oracle Financials.
d) In case of Gap - the customization of apps - discssion with technical consultants.

Another aspect which confuses me is to what extent an Oracle Financials Functional Consultant needs to know the technical aspects like a) Backend tables b) PL/SQL c) Discoverer d) Oracle Forms and Reports d) Data Loader considering all the phases of implementation

I will be glad if I can receive a detailed answer with the perspective of one who has only 1 or 2 implementation experience and one who has more than 5 to 6 years of implementation experience (Difference in experience for the two with the assumption of same skill sets).

Thanks,
Arun

Posted: Tue Aug 04, 2009 3:35 am
by tgs100
Functional consultant's role in Implementation
=============================
? Requirement Study in detail
? Preparation of RD020 document (As-Is process document) and get sign-off from client
? Mapping the requirements to Application process
? Preparing BP080 Document (Mapping of As-Is process to To-Be Process) and get sign-off from client
? Identification of GAP
? Preparing MD050/60 for customization
? Conference Room Pilot environment Setup
? Conduct CRP and Resolve CRP issues
? Training Environment Setup (Optional, Same CRP instance may be used)
? Prepare SOP manuals
? Testing of Customizations (Forms, Interfaces and Reports)
? UAT environment Setup
? Prepare TE040 document (Test Case Document)
? Assist users in UAT and resolve UAT issues
? Prepare BR110 document and get the access details requirement from the client
? Production Instance Setup
? Assist Developers to upload the master data and open transactions
? Verify the uploaded masters and open transactions
? Post Live support
? Prepare BR100 document (Setup Document)
? Co-ordination with DBA and Oracle Support

Functional Consultants Role in Support Projects
==============================
? Handling tickets and application support to the end-users. When an issue is received, it needs to be analyzed and resolved.
? In case, if the issue requires the support of development, then transfer the issue to development team with the inputs. Monitor and help development team to complete the task
? In case, if the issue requires support from Oracle, then raise SR and co-ordinate with oracle support team till closure
? Preparing MD050/MD060 documents for any customizations
? Preparing Test Cases, Test Data & testing.
? Interaction with client/end users & updating the issue status.
? Training the end users and preparing end user training material.
? There will also be interaction with other modules consultants/DBAs
? Creation of process documents & its updation

Functional consultant should know the basic SQL and the important tables. Data Loader is an easy to use tool, hence it is better to know it. Knowledge of discoverer is a plus. Forms and Reports, PL/SQL are not required.

Cheers,
Saravanan TG

Posted: Tue Aug 04, 2009 7:39 pm
by aruns
Hello,

What is the full form of CRP and SOP? Can you provide me with the sample filled AIM documents that you refered here?
Thanks,

Arun

Posted: Wed Aug 05, 2009 2:17 am
by guhanadh
Hi Arun

CRP is Conference Room Pilot
SOP is Standard Operating Procedure

All those (AIM) Documents are Clients Property.
SOP are User Training Manuals for Standard Procedures how client should follow daily.

Regards
Guhanadh

Posted: Fri Sep 25, 2009 1:07 am
by admin
Excellent explanation. tks