Discuss About The Case Study Project Management For Data Warehouse Development Project.

Project Integration Management

Discuss about the case study Project Management for Data Warehouse Development Project.

Project Charter

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 Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper
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.