Page 106 - DCAP304_DCAP515_SOFTWARE_PROJECT_MANAGEMENT

Software Project Management

Notes Planning and Analysis

The objectives of the planning and analysis phase are to:
 Recognize and secure approval for information management requirements; and
 Complete project planning in enough detail to commence technical architecture and design.

Architecture and Design

The objective of the architecture and design phase is to describe the technical architecture for the
entire solution including:
 Database architecture and infrastructure;
 Database sizing and performance expectations;

 Identification of the extract, transform and load process;
 Recommendations for the sizing and configuration of hardware; and
 Access control, backup and recovery guidelines.

Build and Test

The objectives of the build and test stage is to deliver:
 Code required to extract data from the source systems and load it into a temporary staging
area;
 An automated process that will extract data from source systems;
 Programs that will load the data warehouse with the source data from the staging area
including all data base scripts for views, indexes, synonyms and aggregations;
 Processes to clean the data in the staging area and ensure that it is fully consistent with
business rules;

 Programs and scripts that ensure backup/recovery, access control and archiving;
 System processes to handle the data warehouse manager;
 A query manager to support business intelligence requirements;
 Pre-developed queries and reports and user access tools to access information;

 A set of repeatable system integration, volume and aggregation tests; and
 A set of repeatable manual reconciliation tasks.

User Acceptance Test (UAT)

The objective of the UAT stage is to ensure that the information management solution meets
agreed requirements.

Release to Production

The objective of this stage is to migrate the information management solution into a production
environment. The initial data should be pre-loaded and the Data Warehouse should be tuned for
performance, if necessary.

100 LOVELY PROFESSIONAL UNIVERSITY