Wednesday, January 28, 2009

Oracle Implemenation Stages not taught in training

Today we will be seeing the different stages that are available in an implementation project. A Project is not a short term activity to be completed in matter of days, it requires intensive analysis, thoughtful thinking and serious decision making in core and critical business activities. There decisions taken at every stage is critical and irreversible, there is no going back after
performing final step. We have to understand how a long term project is broken up in to phases and completed smoothly. We will see what are the different stages in an Oracle Application Implementation project in real time. i have taken Application Implementation Methodology (AIM) standards as the base for further explanations.

Application Implementation Methodology (AIM) has laid out various stages available in a project.

Stage 1 - Definition of Project Management
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Description
===========
The success to any project is a well thought of PROJECT PLAN at the very beginning considering the requirements and available resources. A Normal Contention of many people is that Project Plan should normally stage the Start Date and End Date and the Consideration, but in real time it is actually more than that, the whole project is broken in to different phases and for each phase a detailed plan is laid out which in turns account for the overall project plan. Project Plan must be revised whenever there is a Change in the contract or requirement of the client.

Documentation to be Prepared
============================
Project Plan (Finalized or Draft)
Write up about the Client and the Consultant.


Stage 2 - Operational Analysis
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Description
========
This is the very very Critical stage of the Project. One must devote the maximum possible time to this stage. Any compromise on this stage may prove critical at later stage of the project. In this stage a Consultant, who is a total stranger to the client so far is going to make an effort to become an expert in understanding the client business every inch. Only when he masters the clients business, he will be in a position to think beyond it and provide solutions considering the impact it can have on overall business. In this stage a consultant must carryout following activities:

--> Clearly understand the contractual obligations made between the client and the consultant with respect to the work to be performed.
--> Detailed study on the Client business and Organisation Structure
--> Capture the current business process as they are following ( Also known as AS IS documentation)
--> Collect the requirements from the client, managers, end users as to what they expect from the Oracle Product
--> Requirements with respect to Functional Side as well as Technical Side is collected
--> Document the bottlenecks faced with the existing system in place
--> Most important point is that get the document signed from the client
( Note: Normally speaking once a requirement is expressed at this stage , it will be taken care by the consultant, however in real time, requirements gathering becomes a day to day activity in many clients place, which is highly unprofessional way of working)

Documentation to be Prepared
============================

RD 10 --> Current Financial and Operating Structure
RD 20 --> Current Business Baseline
RD 50 --> Business Requirements Scenario

Stage 3 - Solution Design
~~~~~~~~~~~~~~~~~~~~~~~~~


Description
===========

After making serious understanding and analysis on clients current business practices and future requirements, consultant must begin the process of providing solutions to each and every aspect. If an straight forward solution is not possible , think about the possibility of workaround. Enough analysis has to be one in drafting the new business process of the client which is going to be followed here after, it is also known as To Be Process.Once the solution is decided on, the same must be communicated to the client seeking acceptance. when the client is satisfied with the solution, consultant can put an end to his research work on providing alternate solutions.

Documentation to be Prepared
============================
BP 80 --> Business Process Design ( To be process )
BR 10 --> High Level Gap Analysis
BR 30 --> Business Requirements Mapping
MD 50 --> Application Extension Functional Design
MD 70 --> Application Extension Technical Design

Stage 4 - Building Stage
~~~~~~~~~~~~~~~~~~~~~~~~


Description
===========

Only at this stage the work of performing setups and access to the instance begins. Based on the Solutions and new business process ( To Be) designed at the previous stage, the consultant starts performing setting up of the Application. In case of a functional requirement, it will be setups from the front end, in case of technical requirements, sql scripts, customizations will be performed. Document all the setups that has been carried out at this stage, since it will be useful when the production Instance is configured or when there is a system crash or corruption of data or any hardware failure. After performing all required setups, the system has to be tested for its readiness to carry out operations

Documentation to be Prepared
=============================

BR 100 --> Application Setup
TE 20 --> Unit Test Script
TE 40 --> System Test Script
TE 50 --> System Integration Test Script
TE 120 --> System Integration Test Plan


Stage 5 - Transition Stage
~~~~~~~~~~~~~~~~~~~~~~~~~~

Description
===========

In this stage, client is exposed to the Applications for the first time to get the comfort level. In order to make the client to get a feel of the system, user guides, training manuals and training may be given in understanding how thier business is completly taken care by the product. Once the client is exposed to the Applications, they normally tend to show some interest in learning
new things, which can be used for testing the system. Once the client is satisfied with the Solutions and the way in which the system performs, he can express his willings to accept the system. In real time, acceptance will be taken up at two levels,
First Level - CRP - Conferance Room Piloting - Where the consultant gives a preview of the new system to the selected members of the client and get thier feedback.
Second Level - UAT - User Acceptance Testing - Here the consultant gives detailed demonstration on the new system to the users ( Super and End ), and get the acceptance from the users that the new system meet thier expectations.

Documentation to be Prepared
======================

TE 130 - User Acceptance Test Report


Stage 6 - Production Stage
~~~~~~~~~~~~~~~~~~~~~~~~~~

Description
===========

Once CRP and UAT is approved, it is the duty of the consultant to replicate the same in a new environment which will be used solely and exclusively for the Production purposes only. After making the production server ready with all setups, it is advised to clone the production server to an development or test server, so that any value addition or future testing can be carried out
separately in future. Once the production server is ready, it is given to the client to begin thier operations, which is termed as GO LIVE . In order to assist the client in adopting to the new system, consultant will provide them with User Manuals and also a support consultant for a short period of time if needed.
Once the production server is ready and used, the implementation gets over, and the client should give it in writing that he is satisfied with the implementation taken place, which is termed as sign off ( A Big Good Bye ) !!

Documentation to be Prepared
============================

User Manuals
Client's sign off on the Acceptance Certificate

NOTE:
=====
Documentations suggested in this post is recommended when AIM is adopted. Instead of the recommended documents, users can prepare documents based on thier methodology.
Nothing stated above is mandatory, every aspect is recommendatory in nature.

**********************************************

GENERALISED
===========

The Implementation Phase in a Oracle implementation project as per Oracle AIM.
1.Definition
2.Operation Analysis
3.Solution Design
4.Build
5.Transition
6.Production Process Overviews - Tasks & Deliverable

[BP] Business Process Architecture
[RD] Business Requirements Definition
[BR] Business Requirements Mapping
[TA] Application and Technical Architecture
[MD] Module Design and Build
[CV] Data Conversion
[DO] Documentation
[TE] Business System Testing
[PT] Performance Testing
[AP] Adoption and Learning
[PM] Production Migration

There are several deliverable from Oracle to deliver at the time of Implementation, But to provide all those documents is not required for Sensible Project.

To my understanding required documents needed to be delivered are

RD - 20 -Requirement Gathering document
BP - 80 or 90 - Future Business Mapping Document
MD - 50 - Functional Specification for Application Customization.
MD - 70 - Technical Specification for Customization.
CV-40-CV-60 - Data Collection Template
UAT - Training Scripts TA - Training Documents
BR - 100 Application Setup Documents


Its better if you have the AIM document generator with you. So that you can have all the document Templates handy. To download the AIM oracle documentation software go to http://www.ziddu.com/download/1682474/AIMtoolaset.EXE.html

4 comments:

Unknown said...

That was an excellent posting to help understand the flow of activities and their corresponding AIM documents. Thank you for posting it.

Vanitha said...

Great work... Amazing post, Very Easy to understand Thanks a Lot

Vanitha

Cool said...

Excellent...!!Explanation on AIM was really wonderful..!!

KSR said...

It's really good to understand about the process...Thank you so much..:)