Project Integration Management
Discuss about the case study Project Management for Data Warehouse Development Project.
Project Charter
Don't use plagiarized sources. Get Your Custom Essay on
Discuss About The Case Study Project Management For Data Warehouse Development Project.
Just from $13/Page
The project deals with developing and establishing a multidimensional, multilevel data warehouse on Microsoft 2012 SQL Server Platform. The project will also ensure the security of the files in the warehouse along with the validation of the data stored. Furthermore, the reviewing of the errors in ETL processes and training of the staffs for using the warehouse also include within the project deliverables.
|
Project Title
|
Establishing new data warehouse capability within the existing SST IT infrastructure
|
|
Project Location
|
Southern State TAFE
|
|
Brief Description of the Project
|
The project “Establishment of a new warehouse” aims to ensure the cross application production reporting capability. The undertaken project will encompass data warehouse provision, dashboard production and will provide reporting capability of the BI portal.
|
|
Prepared By
|
[Name of the Student]
|
|
Date
|
[Mention Date]
|
Version
|
1.0
|
An efficient project scope statement in the project management plan allows in identifying the detailed scope of the undertaken project along with constraints required for the project. In this particular project, the scope is mainly based on enhancing the performance of the organization by bringing a large number of changes in the systems and frameworks. These are mainly targeted by using more efficient working database and warehouse systems and other technical changes.
As there are many scopes in a project, management of each scope is needed. For this, the actual scopes of this project and the out of scope parts are to be determined.
Following are the in scope of the project.
- To develop a multi-dimensional database of the warehouse based on Microsoft 2012 SQL Server Platform
- To develop a SharePoint site for using the Business Intelligence Portal
- To implement a data load and file transfer mechanism according to the SST infrastructure standards
- To develop a security model for BI portal and data warehouse that provide a conjunction along with Active Directory Groups
- To define the Key Performance Indicators (KPI) along with the Balance Score card
- To create a link between the BI Portal and SST intranet
- To train the SST staff for using the data warehouse and BI portal
The following will be excluded in the project.
- To link any other system with the data warehouse
- To create the data extraction from any other systems
The project will be executed according to the plan blueprint. The plan blueprint will be developed following the work breakdown structure as follows:
Figure: Work Breakdown Structure
(Source: Created by Author)
Change Management
Previously, an estimated task schedule was provided for the required project plan. However, after analysis with the actual project scenario and using latest technical equipments, several changes will be made in that table as follows:
|
Task Name
|
Duration
|
|
Data Warehouse Development and Installation Project
|
375 days
|
|
Project Initiation Phase
|
6 days
|
|
Understanding the Requirement
|
2 days
|
|
Conducting feasibility test
|
2 days
|
|
Developing the project charter
|
2 days
|
|
Project Planning Phase
|
39 days
|
|
Develop project plan
|
15 days
|
|
Create project scheduling
|
5 days
|
|
Create resource allocation
|
5 days
|
|
Developing communication plan
|
4 days
|
|
Forming the team
|
10 days
|
|
Execution phase
|
285 days
|
|
Development of Data Warehouse
|
103 days
|
|
Develop the architecture
|
30 days
|
|
Collect the data from various sources
|
5 days
|
|
Develop the multidimensional cube of the warehouse
|
20 days
|
|
Develop the blueprint of hardware system
|
10 days
|
|
Develop the system design of Business Intelligence Portal
|
23 days
|
|
Design the User Interface of the system
|
15 days
|
|
Implementation phase
|
87 days
|
|
Hardware implementation
|
20 days
|
|
Designing the database
|
20 days
|
|
Software implementation of the data warehouse system
|
15 days
|
|
Development of the SharePoint site
|
10 days
|
|
Connecting the Business Intelligence Portal and data warehouse
|
15 days
|
|
Connecting the warehouse with another system
|
7 days
|
|
Deployment and Testing Phase
|
95 days
|
|
testing the architecture design
|
15 days
|
|
software testing
|
20 days
|
|
data validation testing
|
10 days
|
|
security testing
|
15 days
|
|
unit testing
|
5 days
|
|
Risk identification and mitigation
|
30 days
|
|
closing phase
|
45 days
|
|
creating the link to BI portal and SST intranet
|
10 days
|
|
training of the staffs
|
20 days
|
|
maintenance of the warehouse
|
15 days
|
[The ones marked in yellow have been changed]
Management of changes will be needed as some of the tasks will need lesser time due to use of technology instead of manual work and some will take greater time as more emphasis are to be put into the tasks.
Planning
This project will have a number of phases that must be conducted one after the order in order to complete all of them with success. The order and type of tasks will be as follows:
|
Task No
|
Task Name
|
|
1
|
Data Warehouse Development and Installation Project
|
|
1.1
|
Project Initiation Phase
|
|
1.1.1
|
Understanding the Requirement
|
|
1.1.2
|
Conducting feasibility test
|
|
1.1.3
|
Developing the project charter
|
|
1.2
|
Project Planning Phase
|
|
1.2.1
|
Develop project plan
|
|
1.2.2
|
Create project scheduling
|
|
1.2.3
|
Create resource allocation
|
|
1.2.4
|
Developing communication plan
|
|
1.2.5
|
Forming the team
|
|
1.3
|
Execution phase
|
|
1.3.1
|
Development of Data Warehouse
|
|
1.3.1.1
|
Develop the architecture
|
|
1.3.1.2
|
Collect the data from various sources
|
|
1.3.1.3
|
Develop the multidimensional cube of the warehouse
|
|
1.3.1.4
|
Develop the blueprint of hardware system
|
|
1.3.1.5
|
Develop the system design of Business Intelligence Portal
|
|
1.3.1.6
|
Design the User Interface of the system
|
|
1.3.2
|
Implementation phase
|
|
1.3.2.1
|
Hardware implementation
|
|
1.3.2.2
|
Designing the database
|
|
1.3.2.3
|
Software implementation of the data warehouse system
|
|
1.3.2.4
|
Development of the SharePoint site
|
|
1.3.2.5
|
Connecting the Business Intelligence Portal and data warehouse
|
|
1.3.2.6
|
Connecting the warehouse with another system
|
|
1.3.3
|
Deployment and Testing Phase
|
|
1.3.3.1
|
Testing the architecture design
|
|
1.3.3.2
|
Software testing
|
|
1.3.3.3
|
Data validation testing
|
|
1.3.3.4
|
Security testing
|
|
1.3.3.5
|
Unit testing
|
|
1.3.3.6
|
Risk identification and mitigation
|
|
1.4
|
closing phase
|
|
1.4.1
|
Creating a link to BI portal and SST intranet
|
|
1.4.2
|
Training of the staffs
|
|
1.4.3
|
Maintenance of the warehouse
|
The project will be controlled as per the planning made for the scheduling. Each of the tasks will be done one after another to execute the project effectively.
The systems will be configured according to the requirements once the project starts. Latest technical configurations and best possible equipments will be used for the project.
Project Scope and Execution Control
HR Planning
For this project, HR planning is necessary for recruitment of the stakeholders that are not available inside the organization. The following will be the duties of the HR team in this project.
|
HR Department
|
Duty
|
|
Examination Team
|
To test the stakeholder candidates for possible selection
|
|
Recruitment Team
|
To recruit candidates according to the test results and recruitment guidelines
|
|
Management Team
|
To manage the employees and delegate the tasks in the project
|
|
Program Handling Team
|
To handle the project according to plan
|
|
Resource Management Team
|
To manage allocated resources according to the requirements of the project
|
|
Employee Concern Team
|
To manage and address concerns of the employees
|
|
Procurement Team
|
To procure necessary resources after allocation
|
Role of the Project Manager and Project Team
The role of a project manager is huge. He has the duty of managing the whole project in the right direction. In this project, the role of the project manager will be the following:
Managing the Project – The project manager will manage the project according to the requirements. After analysis of all the requirements, the research team will send a report to the project manager. He will analyse this report and financial statement and will decide the direction of the project.
Resource Allocation – After analysing the project requirements, the manager will analyse financial statement and available resources. He will then allocate resources in each field of the project.
Employee Management – The project manager will delegate tasks to the employees according to their specializations. He has to ensure that every employee completes their jobs effectively and efficiently.
Analysis of Project Reports – The project manager will analyse the regular project reports sent to him to judge the progress of the project. He will then decide the future and the direction of the project.
The project team is responsible for conducting the project according to requirements. The following are the duties of the project team.
Project Operations – The project team will be responsible for conducting the project according to the requirements. The team has to ensure that all the operations are being conducted according to the project plan.
Resource Management – The project team will manage resources allocated to them according to the requirements. They have to ensure the resources are spent in such a way that no extra expenses are encountered during the project.
Preparation and Sending of Project Reports – The project team should prepare and send regular project reports to the manager so that he is able to track the progress of the project.
The estimated resources for this project are as follows:
|
Task
|
Resource
|
Estimated Cost
|
|
Feasibility Test
|
Testing Softwares, Automated Analysis Tools
|
$1000
|
|
Employee/Expert Recruitment
|
Specialized Experts
|
$15000
|
|
Architecture Development
|
Architecture Softwares, Latest Computer Systems
|
$5000 + $20000
|
|
Data Collection
|
Internet Tools
|
$1000
|
|
Development of Blueprint, Intelligence Portal, User Interface
|
Design Softwares
|
$10000
|
|
Implementation of Architecture, Hardware, Blueprints, Designs
|
Technically Upgraded Systems
|
$10000
|
|
Testing (Software, Unit, Design, Security)
|
Testing Softwares
|
$2000
|
|
Staff Training
|
Specialized Trainers
|
$10000
|
Communications Plan
The following communication plan may be followed.
|
Vehicle
|
Description
Purpose
|
Frequency
|
Owner / Stakeholder
|
Internal/
External
|
Comments/
Distribution List
|
|
Project Report, Financial Report
|
The sponsors will check the reports and will decide on future investment.
|
Quarterly
|
Project Sponsors
|
External
|
Future Investment Policy
|
|
Future Service Details
|
Future service details will encourage more customers to come to the organization.
|
Weekly
|
Customers
|
External
|
Use of Service, Feedback
|
|
Project Report
|
Project Manager will decide the direction of the project based on the project report.
|
Weekly / Biweekly
|
Project Manager
|
Internal
|
Leading and managing of the project, project guidelines
|
|
Project Progress Report
|
Internal customers will understand the upgraded services.
|
Monthly
|
Internal Customer
|
Internal
|
Feedback
|
|
Tests Schedule
|
They will prepare the systems and make backups for the existing systems.
|
Daily
|
SST Staffs
|
Internal
|
System Quality Report
|
|
Test Results
|
They will further enhance the codes and designs.
|
Daily
|
Tester, Developers, Coder
|
Internal
|
Quality Report
|
|
Trainee Progress Report
|
Training team provides efficient training to the employees and staffs for using the data warehouse for storing and retrieving files.
|
Daily
|
Training Team
|
Internal
|
Updated Progress Reports
|
|
Financial and Protection Statements
|
Insurance company will be providing effort in regulatory and licensing business and data protection act.
|
Monthly
|
Insurance Company
|
External
|
Funds Reports
|
|
Security Information and Threat Reports
|
They will be responsible for maintaining the security of data both from internal and external parties.
|
Daily
|
Security Team
|
Internal
|
Security Reports
|
|
Data Reports
|
They are responsible for maintaining and administrating the data, and authentication the users
|
Biweekly
|
SST Administrator
|
Internal
|
Authentication Reports
|
The communication media according to stakeholders are as follows:
|
Stakeholder
|
Communication Medium
|
|
Project Sponsors
|
Phone calls, formal mails, fax
|
|
Customers
|
Advertisements
|
|
Project Manager
|
Face-to-face, phone calls, formal mails
|
|
Internal Customer
|
Leaflets
|
|
SST Staffs
|
Face-to-face
|
|
Tester, Developers, Coder
|
Face-to-face
|
|
Training Team
|
Face-to-face (Interactive)
|
|
Insurance Company
|
Mails, fax
|
|
Security Team
|
Face-to-face
|
|
SST Administrator
|
Mails, chats
|
Processes to Support Project Procurement Background
In this particular project, procurement is necessary for assimilating all the necessary resources and using them effectively to proceed with the project according to the plan. Procurement will be necessary for technical equipments and employees / personnel.
Procurement of resources (technical or human) will help the company in the upgradation as well as expansion.
Project Quality Management
The contracts will commence from the start of the project (at least few days prior to the start of actual operations.
The number of contractors will depend on the decision of the company on the ground of outsourcing. However, the number should not exceed a limit such that the company is forced to overspend in the project.
The contract terms should favour both the contractor and the company. The contractor should be to benefit from the terms and the company should not overspend due to the terms.
The company should provide sufficient funding. But the company must not overspend.
Estimated Contract Value
The estimated total contract value is $100,000.
General Conditions
The general conditions will be following:
- The contractor should not break the terms of the contract unless mutually agreed.
- The company holds the right to terminate any contract anytime.
- The contractor will not be responsible for any effect of the fault from the company’s part.
Approval to Proceed
The final approval for proceeding will be given by the project manager.
In this project, there are several tasks that cannot be done by the internal employees of the organization only. Hence, outsourcing is needed in order to hire outsiders in this project. A simple outsourcing plan has been provided as below.
|
Project Task
|
Outsourcing Plan
|
|
Valuation of Assets
|
Hiring of Insurance Company
|
|
Employee Training
|
Hiring of external and expert trainers
|
|
System Security Checks (Advanced Level)
|
Use of external security experts
|
|
Marketing and Promotion
|
Use of an advertisement agency
|
A purchase plan for the company along with estimated budget is provided below.
|
Asset / Requirement
|
Estimated Budget
|
|
Updated Hardware Systems
|
$100,000
|
|
Latest Versions of Softwares
|
$50,000
|
|
System Equipments
|
$20,000
|
|
Others
|
$25,000
|
Calderón, A. and Ruiz, M., 2014. Bringing Real-life Practice in Software Project Management Training Through a Simulation-based Serious Game. InCSEDU (2) (pp. 117-124).
Hughes, R., 2012. Agile Data Warehousing Project Management: Business Intelligence Systems Using Scrum. Newnes.
Kerzner, H.R., 2013. Project management: a systems approach to planning, scheduling, and controlling. John Wiley & Sons.
Leach, L.P., 2014. Critical chain project management. Artech House.
Marchewka, J.T., 2014. Information technology project management. John Wiley & Sons.
Menzies, T., Brady, A., Keung, J., Hihn, J., Williams, S., El-Rawas, O., Green, P. and Boehm, B., 2013. Learning project management decisions: a case study with case-based reasoning versus data farming. IEEE Transactions on Software Engineering, 39(12), pp.1698-1713.
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.
Nagarajan, R., Joseph, A.V. and Sujatha, S., 2015. Behavioural Aspects of Software Project Management-In-House Software Development. Indian Journal of Science and Technology, 8(S3), pp.1-9.
O’Connor, R.V. and Laporte, C.Y., 2012, June. Software project management in very small entities with ISO/IEC 29110. In European Conference on Software Process Improvement (pp. 330-341). Springer Berlin Heidelberg.
Reiss, G., 2013. Project management demystified: Today’s tools and techniques. Routledge.
Ryerson, M.S. and Woodburn, A., 2016. Manage Flight Demand or Build Airport Capacity?. ACCESS Magazine, 1(48).
Sen, A., Ramamurthy, K. and Sinha, A.P., 2012. A model of data warehousing process maturity. IEEE Transactions on Software Engineering,38(2), pp.336-353.
Sun, Y. and Schonfeld, P., 2015. Stochastic capacity expansion models for airport facilities. Transportation Research Part B: Methodological, 80, pp.1-18.
Teller, J., Unger, B.N., Kock, A. and Gemünden, H.G., 2012. Formalization of project portfolio management: The moderating role of project portfolio complexity. International Journal of Project Management, 30(5), pp.596-607.
Trendowicz, A. and Jeffery, R., 2014. Software project effort estimation: Foundations and best practice guidelines for success. Springer.
Varajão, J., Dominguez, C., Ribeiro, P.M.G.D.A. and Paiva, A., 2014. Failures in software project management–are we alone? A comparison with construction industry. International journal of modern project management,2(1), pp.22-27.
