Case Study Project Management For Data Warehouse Development Project

Question: Discuss about the case study Project Management for Data Warehouse Development Project. Answer: Project Integration Management 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 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 Scope Statement 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. Management of Project Scope, Execution Control, Change Management 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. Scope of the Project 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 Out of Scope 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 Project Execution and Control 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. Project Quality Management 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 Control 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. Configuration Management 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. Human Resource Management 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 Organisational Chart/s 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. Resources 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 Project Communications Management 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 Suitable Medium/s Channels 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 Project Procurement Management 400 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. Scope Procurement of resources (technical or human) will help the company in the upgradation as well as expansion. Contract Commencement Date The contracts will commence from the start of the project (at least few days prior to the start of actual operations. Number of Contractors 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. Contract Terms 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. Funding 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 companys part. Approval to Proceed The final approval for proceeding will be given by the project manager. Outsourcing 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 Planning Purchases and Acquisitions 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 Bibliography Caldern, 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. OConnor, R.V. and Laporte, C.Y., 2012, June. Software project management in very small entities with ISO/IEC 29110. InEuropean 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 Gemnden, 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. Varajo, J., Dominguez, C., Ribeiro, P.M.G.D.A. and Paiva, A., 2014. Failures in software project managementare we alone? A comparison with construction industry.International journal of modern project management,2(1), pp.22-27.