INF30019 Information Systems Project Management

Swinburne University of Technology
Faculty of Information and Communication Technologies
INF30019 Information Systems Project Management
Guideline: Look at http://www.projectmanagementdocs.com/ for some other templates and
some explanations of different parts of the project plan.

FINAL PROJECT PLAN
1 Introduction and Objectives of the Project Plan
1.1 Overview of the Organization
The paper mainly focuses on the organization “Southern State TAFE” that mainly reflects
on the implementation of Business Intelligence data warehouse for enabling the production of
cross application reporting ability as well as BI portal. The project mainly helps in establishing
new capability of Data Warehouse within the IT infrastructure of SST that generally assists in
laying foundation for the activities of future reporting.
1.2 Current Situation and Problem/Opportunity Statement
The paper mainly focuses on the implementation of BI data warehouse within the
organization “Southern State TAFE” that is quite beneficial for the organization. It is found that
the organization faces lot of challenges and issues in managing data and information and for this
the organization wants to implement BI data warehouse for enabling the production of cross
application capability of reporting as well as BI portal. It is found that the implemented project
will be found as an advanced capability proof. The activities of the project is helpful in entailing
the establishment of the needed hardware and system software for supporting BI reporting, for
defining source system, for processing the data and for delivering in reports in both printable as
well as online format.
2 Project Charter [5 Marks] (Note this section should not be revised
after it has been written)
2.1 Project Information
Project Start Date: < Development of BI Data warehouse > <14/5/18>
Project End Date: <Development of BI Data warehouse > < 31/12/18>
Project Manager: < Please Fill >
Project Sponsor: <Please Fill>
2.2 Project objectives
The objectives of the project are as follows:
 To develop Business Intelligence data warehouse

 To establish new data warehouse capacity within SST IT infrastructure
 To establish the software and system software for supporting BI reporting, defined source
system as well as for delivering reports.
2.3 Project approach
The approaches that are utilized in the project include:
 Establishing Business Intelligence portal
 Establishment of data warehouse capacity
 Implementation of data ware house capacity
2.4 Roles and Responsibilities
Name Role Position Contact Information
<Please Fill> Project manager Project manager <Please Fill>
<Please Fill> Project planner Project planner <Please Fill>
<Please Fill> Resource manager Resource
manager
<Please Fill>
<Please Fill> Database
administrator
Database
administrator
<Please Fill>
<Please Fill> Network system
administrator
Network system
administrator
<Please Fill>
<Please Fill> Network architect Network architect <Please Fill>
<Please Fill> Application
engineer
Application
engineer
<Please Fill>
<Please Fill> Programmer Programmer <Please Fill>
2.5 Project Constraints
The constraints of the project are as follows:
 The development of BI data warehouse must be finished within 31st December 2018
 The project must be finished within the approved budget that is around $189,400
2.6 Assumptions
The assumptions related with the project are as follows:
 The project of BI data warehouse will be finished within the budget of around
$189,400
 The development of BI data ware will be finished within 31st December 2018

2.7 Preliminary Schedule and Budget Estimates
The development of BI data ware house will be finished within 31st December 2018 by
utilizing budget of around $ 189,400 as approved by the Southern State TAFE.
2.8 Plan Modification Rules
The rules for medication include:
 The project manager is the only person who can be able to make changes within the project
 The changes that are required to be done within the project must be approved by the higher
authority of the organization.
2.9 Approval Signatures
Project Manager:
As project manager on <Please fill >, I have reviewed the information contained in the Project
Charter and agree to its content.
Name Position Signature Date
<Please Fill> Project manager <Please Fill> <Please Fill>
<Please Fill> Project planner <Please Fill> <Please Fill>
<Please Fill> Resource manager <Please Fill> <Please Fill>
<Please Fill> Database
administrator
<Please Fill> <Please Fill>
<Please Fill> Network system
administrator
<Please Fill> <Please Fill>
3 Project Scope Management plan
3.1 Product description
The Business intelligence data warehouse that is implemented within the organization
Southern State TAFE generally assists in enabling the production of cross application reporting
as well as business intelligence portal.
3.2 Project Deliverables
The list of project deliverables include:
 Multi-dimensional database
 Validation procedure
 Report systems
 Data mechanism and data transfer
 Financial system
 Student management system
 Payroll system

3.3 Scope Statement
In-Scope
 SharePoint site for the BI portal
 Development of BI data warehouse
 Dashboard for displaying revised balanced scorecard
 Security model use for data warehouse and BI portal
 Review of errors
 Establishment of installation and infrastructure of the required system software.
Out scope
 Generation of data extracts from the system
 Changes within the financial system
 Replacing the management system for the student
 Reconciling of the data that is uploaded
3.4 Work Breakdown Structure Development
Figure 1: WBS
(Source: Created by Author)

3.5 Scope Change Management Process
The changes within the project scope can be identified, addressed, communicated as well
as documented with the help of following:
 Communication
 Tracking project
 Reporting
 Status report
The list of members of the change control board who will generally involve in rejecting
as well as approving the changes within the project are as follows:
 Project manager
 CEO
 Higher authorities of the organization.
3.6 Plan Modification Rules
The plan modification rules include:
 The changes in the project can only be done by the project manager
 Approval from the higher authority of the organization must be taken before making any types of
changes within the plan.
4 Schedule management plan
4.1 Project Schedule
Milestone Completion Date
Milestone 1: Completion of KPI excel workbooks Fri 18-05-18
Milestone 2: Completion of SST defines KPI's Thu 30-08-18
Milestone 3: Completion of SQL server data Wed 24-10-18
Milestone 4: Completion of BI portal Thu 06-12-18
Milestone 5: Completion of active directory group Tue 18-12-18

5 Cost management plan
5.1 Project Budget
The project “development of data warehouse” will be completed successfully within the
budget that is around 189,400. The cost that is needed in order to finish the budget of the project
is provided in the table below:
Task Name Duration Resource Names Cost
Implementation of BI data
warehouse 166 days $ 189,400.00
KPI 79 days $ 73,808.00
KPI excel workbooks 8 days $ 3,080.00
KPI's excel worksheet is
created by BPC, SST 5 days Project manager, Project planner $ 2,000.00
Setting manual insert
rules 3 days Project planner, Resource
manager $ 1,080.00
Milestone 1: Completion
of KPI excel workbooks 0 days $ 0.00
SST defines KPI's 71 days $ 70,728.00
Corporation 3 days Project planner, Resource
manager $ 1,080.00
SQL server data is
created by BPC, SST 4 days Network system administrator,
Network architect $ 1,632.00
Database is created by
BPC 5 days Application engineer, Database
administrator $ 1,800.00
Data validation is set up
BPC 3 days Application engineer, Database
administrator $ 1,080.00
Defining physical system 5 days Network architect, Programmer $ 1,840.00
Defining logical system 7 days Network system administrator,
Network architect $ 2,856.00
BPC develops database 8 days
Database administrator, Network
system administrator,
Hardware[1]
$ 25,328.00
Report is created by BPC 6 days Project planner, Resource
manager $ 2,160.00
BPC develops decreases
ETL process abase validation
rules
8 days Network system administrator,
Network architect $ 3,264.00
BPC creates ETL process
to load files from oracle
financials
8 days Database administrator,
Programmer $ 3,008.00
File mechanism is created
by BBC, SST 12 days Application engineer, Database
administrator $ 4,320.00

New structure of database
is created by BPC 8 days Database administrator, Project
manager $ 3,520.00
BPC implements new
database structure to student
management system
10 days Database administrator, Network
architect $ 3,920.00
BPC creates planning for
implementation 9 days Network architect, Project
manager $ 3,888.00
Project plan is executed
by BPC 8 days Project manager, Project planner $ 3,200.00
BPC perform further
maintenance 9 days Network system administrator,
Network architect $ 3,672.00
BPC implements new
database structures to SST
infrastructures
10 days Programmer, Project manager $ 4,160.00
Milestone 2: Completion
of SST defines KPI's 0 days $ 0.00
SQL server data 43 days $ 49,056.00
Multi-dimensional database 4 days Network architect, Programmer $ 1,472.00
Validation procedure 5 days Application engineer, Database
administrator $ 1,800.00
Report systems 8 days Project planner, Resource
manager $ 2,880.00
Data mechanism and data
transfer 9 days Network system administrator,
Programmer, Software[1] $ 31,496.00
Financial system 8 days Network system administrator,
Programmer $ 3,136.00
Student management
system 5 days Network architect $ 960.00
Payroll system 6 days Network system administrator,
Programmer $ 2,352.00
BPC creates excel
workbooks 7 days Programmer, Project manager $ 2,912.00
Automation rules are set by
BPC 4 days Network architect, project planner $ 1,408.00
Usage activities 4 days Project planner $ 640.00
Milestone 3: Completion
of SQL server data 0 days $ 0.00
BI portal 35 days $ 61,480.00
BPC set up connection to
SST intranet 4 days Database administrator, Network
architect $ 1,568.00
SharePoint screen 3 days Application engineer, Network
architect $ 1,056.00
SharePoint site 4 days Application engineer, Database $ 2,240.00

administrator, Resource manager
Balanced scorecard 5 days Network architect, Programmer $ 1,840.00
Dashboard 6 days Network architect, Programmer $ 2,208.00
BPC creates SharePoint 2 days Network system administrator,
Programmer $ 784.00
BPC creates SharePoint
screen 6 days Programmer, Project manager $ 2,496.00
BPC creates SharePoint site 6 days Application engineer, Network
architect $ 2,112.00
BPC creates balanced
scorecard 7 days
Database administrator, Network
system administrator, Additional
cost[1]
$ 27,912.00
BPC creates Dashboard 5 days Network architect, Resource
manager $ 1,960.00
Performance point screen 9 days Database administrator, Project
manager $ 3,960.00
KPI maintenance screens 7 days Network architect, Project
manager $ 3,024.00
BPC creates performance
points 6 days Network architect, Programmer $ 2,208.00
BPC creates KPI
maintenance screen 5 days Application engineer,
Programmer $ 1,680.00
BPC creates performance
point screen 9 days Application engineer, Network
architect $ 3,168.00
BPC creates KPI
maintenance screen 8 days Network system administrator,
Network architect $ 3,264.00
Milestone 4: Completion
of BI portal 0 days $ 0.00
Active directory group 9 days $ 5,056.00
Security systems 5 days Network system administrator,
Project manager $ 2,280.00
SST sets active directory
group 4 days Application engineer, Project
manager $ 1,600.00
BPC, SST creates system
security validation 3 days Network architect, Resource
manager $ 1,176.00
Milestone 5: Completion
of active directory group 0 days $ 0.00
5.2 Budget Constraints
It is identified that in this project, definitive estimate is used in order to estimate the budget
of the project. It is considered as one of the most accurate method of budget estimation. The
accepted level of variation that can occur within the projected cost and the actual budget of the

project will be around -10% to +10%. Thus in order to prepare the project budget with the
help of definitive method it is quite necessary to perform large amount of research within
the project for getting lower variations within the project.
6 Quality management plan
6.1 Quality Standards
Project Processes/Reports Quality Standards
<Enter project area here> <Describe the standards that apply to project processes/reports
here>
Status Reporting The project manager mainly tracks the process of collecting
information that is done for the project status report.
Quality reporting The resources that are utilized in the project are checked by the
project manager for ensuring that they are of good quality.
6.2 Quality Metrics
Project Deliverables Quality Metrics
<Enter project deliverable
here>
<Describe the quality metrics that apply to project deliverable
here>
Customer Satisfaction The customers of the organization are provided feedback form for
reflecting the level of satisfaction that they are getting from the
organization. The level of satisfaction must be between 3 to 3.5.
Employees satisfaction The satisfactions of the employees are checked and it is mainly
analyzed by the way they are mainly involved with the project.
6.3 Quality Management Approach
The lists of tools that are helpful in managing the quality of the project are reflected below:
 Check sheet
 Control chart
 Histogram
 Pareto chart
 Scatter diagram
 Stratification

6.4 Quality Control
The steps of quality control include:
Creating quality plan: The quality plan helps in describing how the quality requirements
as well as expectations, quality tools as well as quality needs are met.
Controlling quality of the project deliverables: It is identified that the quality control
activities are the steps that generally focuses on the entire quality of the project deliverables that
are generally produced.
Assure the quality of the deliverables: Quality assurance mainly refers to the step that
generally helps in validating processes for creating the deliverables of the project. It is quite helpful for
the sponsor as well as managers for managing project quality.
7 Risk management plan
7.1 Risk Management Strategies
Process Name Process Description
<Enter Process Name Here> <Describe Process Here>
Risk identification A brainstorming session is arranged before the initiation of the
project and a form is provided to the project team member’s so
that they can identify the risks.
Risk evaluation Proper information are gathered about and they are evaluated
so that proper idea about its mitigation can be identified
Risk mitigation Proper strategies are identified which are helpful in resolving
the risks and challenges
7.2 Risk Management Tools
Tool Name Tool Description
<Enter Tool Name Here> <Describe Tool Here>
Risk Status Report .Weekly status report is created so that the team members can
be able to know about the risks and challenges
Risk identification matrix Risk identification matrix is created for prioritizing risks as
well as challenges of the project.
Interviewing Interview of the team members are taken for knowing if they

are facing any risk while involving with the project.
7.3 Data Sources
Data Source Name Data Source Description
<Enter Data Source Name Here> <Describe Data Source Here>
Lessons Learned Database PMO maintained database is used that include information bout
risks
Documentation PMO maintained document is used for getting idea about how
to manage project.
7.4 Risk Categories
Categories Description
Budget shortfall Budget shortfall occurs when the budget of the project is not
tracked properly. In order to resolve this issue, it is necessary to
undertake earned value analysis.
Technical issue Technical issue occurs because after implementation, the
system is not tested. If the system is tested properly then the
chances of technical issue will get minimized.
Improper management If the project managers are not able to manage the project
effectively then it will be quite difficult to finish the project on
time. In order to avoid such issues,, it is necessary to hire
experienced project manager.
Schedule slippage Schedule slippage occurs if the schedule is not tracked
properly. For mitigating this issue, it is necessary to track
schedule on a regular basis.
7.5 Risk Probability and Impact
Item Probability (P) Impact (I) Total Risk Score
<List items here> <Enter a value between
0.1 – 1.0>
<Enter a value between
1 – 10>
<Multiply P x I>
Budget shortfall 0.8 9 7.2
Technical issue 0.7 9 6.3

Project sponsor
Project manager
Programme
r
Applicatio
n engineer
Network
architect
Database
administ
rator
Resource
manager
Project
planner
Improper management 0.7 8 5.6
Schedule slippage 0.7 8 5.6
8 HR management plan
8.1 Project Organization
8.1.1 Project Team
Name Role Phone Number Email Address
<Please Fill> Project manager <Please Fill> <Please Fill>
<Please Fill> Project planner <Please Fill> <Please Fill>
<Please Fill> Resource manager <Please Fill> <Please Fill>
<Please Fill> Database administrator <Please Fill> <Please Fill>
<Please Fill> Network system
engineer
<Please Fill> <Please Fill>
<Please Fill> Network architect <Please Fill> <Please Fill>
<Please Fill> Application engineer <Please Fill> <Please Fill>
<Please Fill> Programmer <Please Fill> <Please Fill>
Figure 1: Project organization
(Source: Created by Author)

8.1.2 Key Stakeholders
Key Stakeholders
<Stakeholder 1> <Stakeholder 2>
Role on Project Project Sponsor Supplier Project manager
Organization VP of IT VP of IT VP of IT
Phone Number(s)
Email Address
Unique Facts Prefers the use of
email for project
documents
Utilizes resource
list for supplying
resources
Utilizes progress
report for updating
team members
about project
progress
Suggestions for managing
communications
Keep informed of all
project progress
Keep information
about the quality
of the resources
Guide the team
members so that
they can perform
well
8.2 Resource Requirements
Project manager
Project planner
Resource manager
Databse administartor
Network system administrator
Network architecht
Application engineer
Programmer
0 hrs
200 hrs
400 hrs
600 hrs
800 hrs
1,000 hrs
1,200 hrs
Actual Work Remaining Work Baseline Work
Figure 2: Resource Histogram

(Source: Created by Author)
8.3 Resource Assignment
Task Project
manager
Project
planner
Resource
manager
Database
administrator
Network
system
engineer
Network
architect
Programmer
KPI's
excel
workshe
et is
created
by BPC,
SST
I R, A
Setting
manual
insert
rules
I C R, A
Databas
e is
created
by BPC
I A, R C
Data
validatio
n is set
up BPC
I A, R C
BPC
develops
decrease
s ETL
process
abase
validatio
n rules
C A, R I
BPC
creates
ETL
process
to load
files
from
oracle
financial
s
I C A, R
File
mechani
sm is
I C A, R

created
by BBC,
SST
BPC
creates
KPI
mainten
ance
screen
C A, R I
BPC
creates
perform
ance
point
screen
C A, R I
Security
systems
C I A, R
SST sets
active
director
y group
I C R, A
.
9 Communication plan
9.1 Stakeholder Analysis
<Please Fill> <Please fill> <Please fill>
Role on Project Database administrator Project Sponsor Project manager
Organization VP of IT VP of IT VP of IT
Contact Information <Please Fill> <Please Fill> <Please Fill>
Unique Facts Stores information
properly within the
database of the
organization.
Prefers use of email
for project
documents
Manages the project
effectively so that it get
finished within time
Level of Interest High High High
Level of Influence Medium High High
Suggestions for Keep informed if any Keep informed Guiding the team members

managing relationships type of technical issues
occur
about the progress of
the project
of the project
9.2 Project Reports
Data Needed Frequency
of
Collection
Responsible
Party for Data
Collection &
Analysis
Report
Media &
Format
Responsible
Party for
Distributing
Report
Schedule Status Tracking
project
schedule
Weekly Project team
member
Schedule
status Form
Project manager
Quality status Tracking
quality of the
resources
Weekly Quality analyst Quality
status form
Project manager
9.3 Project Meetings
Purpose Frequency Attendees Reporting
Requirements
Status Review
Meeting
Update on project
status
Weekly Project team
members,
sponsor and
other
stakeholder
Meeting Minutes
Monthly status
meeting
Update on the
challenges that the
team is facing while
working with the
project
Monthly Project manager
and project
planner
Status report
Kick off meeting Update on the
objectives as well as
goals of the project.
Once Project team
member
Meeting minutes
9.4 Project Information Accessibility
The information related with the project is mainly stored within the following places:
Website: Website act as one of the centralized location for for storing project documents and oter
templates

Database: All the other information related with the business is stored within the database of the
organization
10 Communications Summary
Stakeholder Type Communication
Medium
Frequency Responsible Party
<Please Fill> Weekly status
report
Email, face to face Every Monday Project manager
<Please Fill> Kick off report Face to face, Email Once before the
initiation of the
project
Project manager
<Please Fill> Technical review
report
Email, conference Whenever needed Technical engineer
<Please Fill> Monthly project
performance report
Email Last day of the
month
Project manager

11 Bibliography
Badewi, A., 2016. The impact of project management (PM) and benefits management (BM) practices on
project success: Towards developing a project benefits governance framework. International Journal of
Project Management, 34(4), pp.761-778.
Calvo-Mora, A., Navarro-García, A. and Periañez-Cristobal, R., 2015. Project to improve knowledge
management and key business results through the EFQM excellence model. International Journal of Project
Management, 33(8), pp.1638-1651.
Chih, Y.Y. and Zwikael, O., 2015. Project benefit management: A conceptual framework of target benefit
formulation. International Journal of Project Management, 33(2), pp.352-362.
Conforto, E.C., Salum, F., Amaral, D.C., da Silva, S.L. and de Almeida, L.F.M., 2014. Can agile project
management be adopted by industries other than software development?. Project Management
Journal, 45(3), pp.21-34.
Costantino, F., Di Gravio, G. and Nonino, F., 2015. Project selection in project portfolio management: An
artificial neural network model based on critical success factors. International Journal of Project
Management, 33(8), pp.1744-1754.
Heldman, K., 2018. PMP: project management professional exam study guide. John Wiley & Sons.
Joslin, R. and Müller, R., 2015. Relationships between a project management methodology and project
success in different project governance contexts. International Journal of Project Management, 33(6),
pp.1377-1392.
Kucharska, W. and Kowalczyk, R., 2016. Trust, Collaborative Culture and Tacit Knowledge Sharing in
Project Management–a Relationship Model.
Marcelino-Sádaba, S., Pérez-Ezcurdia, A., Lazcano, A.M.E. and Villanueva, P., 2014. Project risk
management methodology for small firms. International journal of project management, 32(2), pp.327-340.
Marcelino-Sádaba, S., González-Jaen, L.F. and Pérez-Ezcurdia, A., 2015. Using project management as a
way to sustainability. From a comprehensive review to a framework definition. Journal of cleaner
production, 99, pp.1-16.
Mir, F.A. and Pinnington, A.H., 2014. Exploring the value of project management: linking project
management performance and project success. International journal of project management, 32(2), pp.202-
217.
Riol, H. and Thuillier, D., 2015. Project management for academic research projects: balancing structure and
flexibility. International Journal of Project Organisation and Management, 7(3), pp.251-269.
Svejvig, P. and Andersen, P., 2015. Rethinking project management: A structured literature review with a
critical look at the brave new world. International Journal of Project Management, 33(2), pp.278-290.