Information System Project Management for Telstra

This report discusses Telstra's project to implement a cloud based database for efficient operations and customer convenience. The report covers the scope, schedule, budget, risks and outcomes of the project.

Running Head: INFORMATION SYSTEM PROJECT MANAGEMENT
Information System Project Management
Name of the Student
Name of the University

1INFORMATION SYSTEM PROJECT MANAGEMENT
Executive Summary
Telstra is an Australian telecommunication company that decided to initiate a project in order to
implement cloud based database for the migration of all business information into online
interface. For this project, they had a number of objectives including enhancement of their
services as well as providing more convenience to their customers. The project was first
approved in 2017 and a deadline was set for mid-2018.

2INFORMATION SYSTEM PROJECT MANAGEMENT
Table of Contents
1.0 Introduction and Background of the Project..............................................................................3
2.0 Project Scope and Objectives....................................................................................................3
3.0 Project Schedule........................................................................................................................4
4.0 Project Budget and Cost Benefit Analysis.................................................................................9
5.0 Project Stakeholders................................................................................................................17
6.0 Risks Identified and Mitigation Plans Undertaken..................................................................18
7.0 Project Outcomes and Benefits Gained...................................................................................19
8.0 Conclusion...............................................................................................................................19
Bibliography..................................................................................................................................20

3INFORMATION SYSTEM PROJECT MANAGEMENT
1.0 Introduction and Background of the Project
The project under focus in this assignment is the development and implementation of
cloud based database for Telstra. Telstra is an Australian company that provides
telecommunication services in Australia. In their previous operational system, most of the
processes like data entry, bill processing, payments, bill generation and others were done
manually with minimal use of automated systems. This system was causing significant problems
as the customer base of the company increased and the system could no more be handled
efficiently manually. Hence, Telstra decided to undertake a project for cloud based database
implementation that would significantly solve the main problems faced by the operations of the
company. The project was approved in 2017 and was completed in April 2018.
In this project report, the major features of the project like scope, schedule, budget, cost
benefit, risks and others have been analyzed and discussed.
2.0 Project Scope and Objectives
The main scope of the project involved the development of cloud platform, development
of cloud based database and migration of the business data and operations to the cloud database.
The objectives of the project were as follows.
 To make the system operations much more efficient and faster
 To reduce operational costs due to too many human resources working on similar
operation set
 To reduce the need for physical storage spaces for the various types of data

4INFORMATION SYSTEM PROJECT MANAGEMENT
 To provide more convenience to the customers regarding bill payments and
service information viewing
3.0 Project Schedule
The project schedule that was followed by Telstra for the implementation of the cloud
based database was as shown in the following table.
Task Name Duration Start Finish Predecessors
Implementation of Cloud
Based Database for Telstra
200 days Mon 7/3/17 Fri 4/6/18
Project Survey,
Discussion and Approval
32 days Mon 7/3/17 Tue 8/15/17
Survey of the Current IT
System of the Company
10 days Mon 7/3/17 Fri 7/14/17
Identify Specific
Problems Faced by the
Company
5 days Mon 7/17/17 Fri 7/21/17 2
Call Board Meeting 1 day Mon 7/24/17 Mon 7/24/17 3
Discuss Regarding the
Implications of the Problems
2 days Tue 7/25/17 Wed 7/26/17 4
Generate Idea Regarding 2 days Thu 7/27/17 Fri 7/28/17 5

5INFORMATION SYSTEM PROJECT MANAGEMENT
the Possible Solutions
Determine a Final
Solution that Would Address
the Problems
2 days Mon 7/31/17 Tue 8/1/17 6
Develop a Rough
Proposal for the Project
4 days Wed 8/2/17 Mon 8/7/17 7
Discuss Regarding the
Proposal
4 days Tue 8/8/17 Fri 8/11/17 8
Approve the Proposal 2 days Mon 8/14/17 Tue 8/15/17 9
Project Initiation and
Planning
40 days Wed 8/16/17 Tue 10/10/17
Develop a Project
Management Team
3 days Wed 8/16/17 Fri 8/18/17 10
Develop a Project
Charter
5 days Mon 8/21/17 Fri 8/25/17 12
Estimate an Appropriate
Schedule for the Project
2 days Mon 8/28/17 Tue 8/29/17 13
Estimate an Appropriate
Budget for the Project
4 days Wed 8/30/17 Mon 9/4/17 14

6INFORMATION SYSTEM PROJECT MANAGEMENT
Determine Possible
Risks for the Project
5 days Tue 9/5/17 Mon 9/11/17 15
Prepare Suitable
Mitigation Plan for the
Project
5 days Tue 9/12/17 Mon 9/18/17 16
Receive Customer
Feedbacks Regarding the
Proposed Project
5 days Tue 9/19/17 Mon 9/25/17 17
Determine Constraints
and Limitations of the
Project
2 days Tue 9/26/17 Wed 9/27/17 18
Determine Driving
Forces of the Project
2 days Thu 9/28/17 Fri 9/29/17 19
Review the Project Plan 5 days Mon 10/2/17 Fri 10/6/17 20
Approval to Proceed
with the Project
2 days Mon 10/9/17 Tue 10/10/17 21
Project Execution Phase 110 days Wed 10/11/17 Tue 3/13/18
Hire Team of Developers
and Testers
4 days Wed 10/11/17 Mon 10/16/17 22

7INFORMATION SYSTEM PROJECT MANAGEMENT
Procure Budget from the
Authority
6 days Tue 10/17/17 Tue 10/24/17 24
Procure Hardware
Resources
4 days Wed 10/25/17 Mon 10/30/17 25
Procure Software
Resources
3 days Tue 10/31/17 Thu 11/2/17 26
Set Up Cloud
Implementation Platform
10 days Fri 11/3/17 Thu 11/16/17 27
Start Developing Online
Business Portal
4 days Fri 11/17/17 Wed 11/22/17 28
Design the Website
Interface
12 days Thu 11/23/17 Fri 12/8/17 29
Add Features to the
Website
8 days Mon 12/11/17 Wed 12/20/17 30
Add Online Payment
Gateway to the Portal
8 days Thu 12/21/17 Mon 1/1/18 31
Connect the Portal with
the Cloud Interface
5 days Tue 1/2/18 Mon 1/8/18 32
Development of the 4 days Tue 1/9/18 Fri 1/12/18 33

8INFORMATION SYSTEM PROJECT MANAGEMENT
Cloud Database
Apply Online Security to
the Database
5 days Mon 1/15/18 Fri 1/19/18 34
Test the Database 10 days Mon 1/22/18 Fri 2/2/18 35
Migrate All Business
Data to the Cloud Database
15 days Mon 2/5/18 Fri 2/23/18 36
Final Testing of the
Entire System
10 days Mon 2/26/18 Fri 3/9/18 37
Hand Over 2 days Mon 3/12/18 Tue 3/13/18 38
Project Closing 18 days Wed 3/14/18 Fri 4/6/18
Review the Project Plan 5 days Wed 3/14/18 Tue 3/20/18 39
Appaisal 3 days Wed 3/21/18 Fri 3/23/18 41
Final Payments for the
Project Team
2 days Mon 3/26/18 Tue 3/27/18 42
Documentation 5 days Wed 3/28/18 Tue 4/3/18 43
Sign Off 2 days Wed 4/4/18 Thu 4/5/18 44
Closing 1 day Fri 4/6/18 Fri 4/6/18 45

9INFORMATION SYSTEM PROJECT MANAGEMENT
4.0 Project Budget and Cost Benefit Analysis
The estimated project for the project was as shown as follows.
Task Name Resource Names Cost
Implementation of Cloud
Based Database for Telstra
$663, 120.00
Project Survey, Discussion
and Approval
$107, 400.00
Survey of the Current IT
System of the Company
Telstra IT Supervisor $17, 200.00
Identify Specific Problems
Faced by the Company
Telstra IT Supervisor $8, 600.00
Call Board Meeting Project Manager $2, 000.00
Discuss Regarding the
Implications of the Problems
Finance Manager, Project Manager,
Telstra IT Supervisor
$10, 800.00
Generate Idea Regarding the
Possible Solutions
Finance Manager, Project Manager,
Telstra IT Supervisor
$10, 800.00
Determine a Final Solution
that Would Address the
Problems
Finance Manager, Project Manager,
Telstra IT Supervisor
$10, 800.00

10INFORMATION SYSTEM PROJECT MANAGEMENT
Develop a Rough Proposal
for the Project
Finance Manager, Project Manager,
Telstra IT Supervisor
$21, 600.00
Discuss Regarding the
Proposal
Finance Manager, Project Manager,
Telstra IT Supervisor
$21, 600.00
Approve the Proposal Project Manager $4, 000.00
Project Initiation and
Planning
$130, 200.00
Develop a Project
Management Team
Project Manager $6, 000.00
Develop a Project Charter Telstra IT Supervisor $8, 600.00
Estimate an Appropriate
Schedule for the Project
Project Manager, Telstra IT Supervisor $7, 440.00
Estimate an Appropriate
Budget for the Project
Project Manager, Telstra IT Supervisor $14, 880.00
Determine Possible Risks
for the Project
Project Manager, Telstra IT Supervisor $18, 600.00
Prepare Suitable Mitigation
Plan for the Project
Project Manager, Telstra IT Supervisor $18, 600.00
Receive Customer Project Manager, Telstra IT Supervisor $18, 600.00

11INFORMATION SYSTEM PROJECT MANAGEMENT
Feedbacks Regarding the
Proposed Project
Determine Constraints and
Limitations of the Project
Project Manager, Telstra IT Supervisor $7, 440.00
Determine Driving Forces
of the Project
Project Manager, Telstra IT Supervisor $7, 440.00
Review the Project Plan Project Manager, Telstra IT Supervisor $18, 600.00
Approval to Proceed with
the Project
Project Manager $4, 000.00
Project Execution Phase $370, 320.00
Hire Team of Developers
and Testers
Project Manager, Telstra IT Supervisor $14, 880.00
Procure Budget from the
Authority
Finance Manager $10, 080.00
Procure Hardware
Resources
Procurement Manager, Hardware[1] $20, 600.00
Procure Software Resources Project Manager, Software[1] $16, 000.00
Set Up Cloud
Implementation Platform
Developer 1, Developer 2,
Development Team Leader, Tester 1,
$33, 200.00

12INFORMATION SYSTEM PROJECT MANAGEMENT
Tester 2
Start Developing Online
Business Portal
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$13, 280.00
Design the Website
Interface
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$39, 840.00
Add Features to the Website
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$26, 560.00
Add Online Payment
Gateway to the Portal
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$26, 560.00
Connect the Portal with the
Cloud Interface
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$16, 600.00
Development of the Cloud
Database
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$13, 280.00
Apply Online Security to Developer 1, Developer 2, $16, 600.00

13INFORMATION SYSTEM PROJECT MANAGEMENT
the Database
Development Team Leader, Tester 1,
Tester 2
Test the Database
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$33, 200.00
Migrate All Business Data
to the Cloud Database
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$49, 800.00
Final Testing of the Entire
System
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$33, 200.00
Hand Over
Developer 1, Developer 2,
Development Team Leader, Tester 1,
Tester 2
$6, 640.00
Project Closing $55, 200.00
Review the Project Plan Project Manager, Telstra IT Supervisor $18, 600.00
Appaisal Project Manager $6, 000.00
Final Payments for the
Project Team
Finance Manager $3, 360.00

14INFORMATION SYSTEM PROJECT MANAGEMENT
Documentation Development Team Leader $5, 000.00
Sign Off
Developer 1, Developer 2,
Development Team Leader, Finance
Manager, Procurement Manager,
Project Manager, Telstra IT
Supervisor, Tester 1, Tester 2
$20, 240.00
Closing Project Manager $2, 000.00
Based on the budget developed for the project, the cost benefit analysis was done as
follows.
Cost Benefit Analysis for Telstra Cloud Based Implementation
Hardware $ 15,000.00
Software $ 10,000.00
Development team salaries $ 636,120.00
Other Costs $ 2,000.00
Total Development Cost $ 663,120.00
Maintenance $ 10,000.00
Changes $ 15,000.00
Operational Labor $ 75,000.00
Total Operational Cost $ 100,000.00

15INFORMATION SYSTEM PROJECT MANAGEMENT
Approximate salary savings $ 150,000.00
Savings from Technical Processes $ 250,000.00
Total Benefit $ 400,000.00
Discount Rate Used 6.00%
Project Cost-
Benefit
Analysis
Analysis
Variables:
Discount Rate
Used
6.00%
Annual
Benefits
$
400,00
0.00
Annual
Operational
Costs
$
100,00
0.00
One-Time
Development
Cost
$
663,12
0.00
Year of

16INFORMATION SYSTEM PROJECT MANAGEMENT
Project
0 1 2 3 4 5 TOTA
LS
Economic
Benefit
$0.00 $
400,000.
00
$
400,000.
00
$
400,000.
00
$
400,000.
00
$
400,000
.00
Discount Rate 1.0000 0.9434 0.8900 0.8396 0.7921 0.7473
PV of Benefits $0.00 $377,35
8.49
$355,99
8.58
$335,847
.71
$316,83
7.47
$298,90
3.27
NPV of all
BENEFITS
$0.00 $
377,358.
49
$
733,357.
07
$
1,069,20
4.78
$
1,386,04
2.25
$
1,684,9
45.51
$
1,684,9
45.51
One-Time
COSTS
$(663,
120.00
)
Recurring
Costs
$0.00 $
(100,000
.00)
$
(100,000
.00)
$
(100,000.
00)
$
(100,000
.00)
$
(100,00
0.00)
Discount Rate 1.0000 0.9434 0.8900 0.8396 0.7921 0.7473
PV of
Recurring
$0.00 $
(94,339.
$
(88,999.
$
(83,961.9
$
(79,209.
$
(74,725.

17INFORMATION SYSTEM PROJECT MANAGEMENT
Costs 62) 64) 3) 37) 82)
NPV of all
COSTS
$(663,
120.00
)
$
(757,459
.62)
$
(846,459
.27)
$
(930,421.
19)
$
(1,009,6
30.56)
$
(1,084,3
56.38)
$
(1,084,3
56.38)
Overall NPV $
600,589
.14
Overall ROI
0.5539
5.0 Project Stakeholders
The stakeholders in the project were as follows.
Stakeholder Designation Stakeholder Roles
Project Manager Management, control and monitoring of the project
Finance Manager Management and control of the project budget
Telstra IT Supervisor Monitoring the current system and the project
progress
Procurement Manager Procurement of resources for the project
Developers Development of the cloud platform, cloud database
and migration of data to the database
Testers Testing of the entire system

18INFORMATION SYSTEM PROJECT MANAGEMENT
6.0 Risks Identified and Mitigation Plans Undertaken
The major risks identified for the project and the mitigation actions taken are listed as
follows.
Risk Identified Mitigation Action Taken
Cyber Security Risk Suitable firewalls were installed before the
migration of data, anti-virus software was used to
block any unauthorized access and broken files
Scope Creep From the start, a clear plan was developed with
specifically defined scope statement and project
team duties and responsibilities
Budget Risk Market analysis was done and possible price
changes were considered in the final budget
User Acceptance Feedbacks from the service users were taken and
the benefits were specified to them regarding the
implementation of the cloud based database,
assurance was provided regarding security of their
personal data

19INFORMATION SYSTEM PROJECT MANAGEMENT
7.0 Project Outcomes and Benefits Gained
After the cloud based database was ready, all the business data including business
statistics, service details, customer data, financial statistics and others were migrated to the
cloud. Although there were risks regarding the security of the data, no major problems were
faced as proper actions were taken from the start. After migration was complete and the system
was put online, significant changes have been noted in the operations of Telstra. The processing
of the data, entry of new data, data calculations and others have been found out to be much more
efficient and faster and no significant human interference is now required as most of the process
has been automated and accurate. Furthermore, this has been much more convenient for the
customers as they can now pay bills online, generate online receipt anytime and view their
service usage details whenever they want instead of waiting for customer service to respond.
8.0 Conclusion
Finally, it can be concluded that the project was successful for Telstra as all the
objectives were successfully fulfilled by the project. Moreover, the project did not cross the
estimated budget for the project and was also completed within a reasonable time schedule.

20INFORMATION SYSTEM PROJECT MANAGEMENT
Bibliography
Braglia, M. and Frosolini, M., 2014. An integrated approach to implement project management
information systems within the extended enterprise. International Journal of Project
Management, 32(1), pp.18-29.
Harrison, F. and Lock, D., 2017. Advanced project management: a structured approach.
Routledge.
Joosten, D., Basten, D. and Mellis, W., 2016. Measurement of information system project
success in German organizations. In Project Management: Concepts, Methodologies, Tools, and
Applications (pp. 1175-1196). IGI Global.
Kerzner, H. and Kerzner, H.R., 2017. Project management: a systems approach to planning,
scheduling, and controlling. John Wiley & Sons.
Laudon, K.C. and Laudon, J.P., 2016. Management information system. Pearson Education
India.
Li, Y., Lu, Y., Kwak, Y.H. and Dong, S., 2015. Developing a city-level multi-project
management information system for Chinese urbanization. International Journal of Project
Management, 33(3), pp.510-527.
Marchewka, J.T., 2014. Information technology project management. John Wiley & Sons.
Nicholas, J.M. and Steyn, H., 2017. Project management for engineering, business and
technology. Routledge.

21INFORMATION SYSTEM PROJECT MANAGEMENT
Ptak, C.A. and Schragenheim, E., 2016. ERP: tools, techniques, and applications for integrating
the supply chain. Crc Press.
Putra, S.J., Ahlan, A.R. and Kartiwi, M., 2016. A Coherent Framework for Understanding the
Success of an Information System Project. TELKOMNIKA (Telecommunication Computing
Electronics and Control), 14(1), pp.302-308.
Schwalbe, K., 2015. Information technology project management. Cengage Learning.
Shojaie, A.A., Shadalooie, M.A.S.O.U.D., Khalili-Damghani, K.A.V.E.H. and Pakzad, M.R.,
2016. Development of a conceptual model of project management information systems for
investigating its effective factors impacting the success of project using structural equation
model. International Journal of Life Science & Pharma Research, Special Issue, 1, pp.17-29.
Sligo, J., Gauld, R., Roberts, V. and Villa, L., 2017. A literature review for large-scale health
information system project planning, implementation and evaluation. International journal of
medical informatics, 97, pp.86-97.
Too, E.G. and Weaver, P., 2014. The management of project management: A conceptual
framework for project governance. International Journal of Project Management, 32(8),
pp.1382-1394.
Verzuh, E., 2015. The fast forward MBA in project management. John Wiley & Sons.
Zwikael, O., 2016. International journal of project management special issue on “project benefit
management”.