Skip to content

IT Project Management

Introduction

With the continues competition and changing customer needs and demands, it is becoming very important to change as per the market needs ,in order to survive in tough competition and increase growth over time.

With increase in customer base and satisfaction the company needs to improve its technology that can help in managing the records and documents in a defective manner so that the company can be able to formulate strategies as per their needs and demands. In this task the central point of discussion would be on understanding the requirement of Atlas which is an insurance providing companies in Australia who is looking forward to upgrade its database management system to Oracle is the current system is not able to when be the needs and requirements of high data records and customer details.

In this task the study is going to provide in-depth analysis on different documents and process that is going to be undertaken by at least company in order to upgrade their database management system to Oracle and also provide a discussion on different steps that needs to be taken while going for a database management upgradation system.

Literature review

In order to have a proper project monitoring and evaluation criteria for the project of database management system in atlas company and schedule management plan and resource requirement plan has been developed that can help the management in understanding the importance of schedule and can also help in managing them all the timelines with better efficiency and utilization.

The below provided schedule management plan helps in understanding the different schedule provided in the form of the game chat and critical path analysis while managing different activities during the project.

Stakeholders are the people who directly or indirectly have control over the decision making of a project hence it becomes very important to have a clear understanding and management procedure in order to manage their needs and demands.With the help of stakeholder management plan analysis, It would be it would be easy for the organisation to manage different stakeholders a different level of the organisation.

Communication plan is a document that helps in analysing all the needs of the claimants in order to communicate the need for change in the organisation. It includes kick-off meetings that is a formal meeting which involves defining the goals and objectives of the project to all the stakeholders in order to provide them better understanding about the project.

Change management is a process that involves change in any existing process or task of an organisation in order to achieve better accuracy and efficiency.

Stakeholder Analysis

Stakeholders are the people who directly or indirectly have control over the decision making of a project hence it becomes very important to have a clear understanding and management procedure in order to manage their needs and demands.

With the help of stakeholder management plan analysis, It would be it would be easy for the organisation to manage different stakeholders a different level of the organisation.The stakeholder management plan analysis is discuss this below.

Name Interest Level Influence Level Potential strategies for management
Will Smith High High As he is the project coordinator all the proceedings are going to be directly managed by him. He must be informed regularly with all the preceding of the project.
Rebeka Adams High High All the business requirement gathering is going to be done by her, it becomes very important to access all the client needs very carefully so that the database management upgradation can be done carefully.
Finance Manager High High He needs to be informed about all the expenses of the project that can help in building trust.
Sales manager High High They are opposing the change hence need to convey about the importance of the new change.
Service managers High High Service team will acquire huge positive impact from the development of this software as it will operations will be much more automatic and systematic in nature
Customers High Low Owing to the rise in the number of customers (and anticipated potential growth) it was often difficult to monitor the fleet or cars for loans and to respond to customer requests if one is eligible to make a reservation. With consumers continuing to seek multiple payment mechanisms such as e-mail, PayPal etc., the app can support.
Workers Medium High Continuous motivation and work related guidelines needs to be provided.
Suppliers Medium Medium Competitive pricing strategies need to be adopted to ensure timely delivery of the raw material.
Employees of Atlas High Medium Any resistance by the employees can cause high damage to the plan. In order to avoid this, it is important to communicate the need of change.

Communication Plan

Communication plan is a document that helps in analysing all the needs of the claimants in order to communicate the need for change in the organisation. It includes kick-off meetings that is a formal meeting which involves defining the goals and objectives of the project to all the stakeholders in order to provide them better understanding about the project.

                                                              Kick-Off Meetings

                                                            1 November 2020

Project Name: Atlas Compacy

Meeting Objective:  Starting off the project effectively that can help in kick start the project effectively and introducing different stakeholders, communicating the project goals and plans and discussing future plans with core team and stakeholders.

Agenda;

  • Brief introduction
  • Review of project background
  • Reviewing all project related documents (project charter, assumption, risk management plan etc.)
  • Discussion on project structure
  • Discussion on project time line, scope , goals, deliverables
  • Discussion on other core topics and issues.
  • List of action items
Action Item Assigned To Due Date
Introduction Meeting coordinator 01 November 2020
Understanding on project goals Sales Manager 10 November 2020
Project scope, resources Finance manager 15 November 2020

Project charter

Project charter is a formal documentation that helps in knowing all the requirements of a project which involves the cost,Scope analysis,problem and overall cost of the project.

Work Breakdown structure

Work breakdown structure is a graphical representation of all the tasks and activities that are going to be incurred and carried in a project to complete the project on time with higher efficiency and effectiveness.

With the help of work breakdown structure it becomes easy to understand different activities that are going to be a part of the project and the differentiation becomes easy on the basis of activity and department.

Gantt chart

Gantt chart Is a visualisation that helps in understanding the breakdown of different activities over different time period allotted to a project.

Cost management plan

Cost and finance are one of the most important aspects for the success of an organisation as the organisation wants to run out of cash while operating their operations in the market. It is very important for an organisation to estimate all types of cost that might incur during the project like fixed cost, tangible cost etc.

In order to have a control over the cost we have developed different types of financial documents like payback period analysis,Cost benefit analysis and other financial documents.

Year Annual cash flows  ($) Cost of capital @10% DCF ($)
0 -12000 1 -12000
1 5200 0.909 4727
2 5800 0.826 4791
3 6400 0.751 4806
Net present value  2324

Negative sign indicates the outflow of money.

Payback period

Year Annual cash flows  ($) Cumulative ($)
0 -12000 -12000
1 5200 -6800
2 5800 -1000
3 6400 5400

Cost benefit analysis

  Q1 Q2 Q3 Q4
Benefits        
Increased revenue  702 585 655 398
Cost saving  546 455 510 309
Costs avoided 1404 1170 1310 796
Quarterly Total benefit  1560 1300 1456 884
Cumulative Value 1560 2860 4316 5200
Investments        
one time investment 8010 0 1780 890
Ongoing investment 990 0 220 110
quarterly total 9000 0 2000 1000
Cumulative Investment 9000 9000 11000 12000

Risk assessment

Risk management plan is one of the most important document while managing a project in an organization as it helps in understanding different types of risk that can occur during the course of the project with the help of this document in place the management to take corrective decisions for all types of risk that might hamper the productivity and efficiency of the project.

Risk Management Plan

Project Name: Atlas Company

Project Overview: Making a database management software upgradation to Oracle software so that all the needs of the data management and record handling can be done effectively.

Project Lead: Will Smith

Risk Identification & Planning

Risk Overview Category Risk triggers
Low level of resources Internal risk poor Performance management
Pandemic situation External risk Overall execution of the project.
Poor management Internal risk It may leads to failure and delay in the project.
Performance issue Internal risk Duplication and underperformance by the project team.
Communication gap Internal Miscommunication and delay in decision making.
Other risk

High turnover

Lower efficiency

Internal May lead to increase in cost and time required for completion of the project.

Planning

 In order to minimize the different risk that might hamper the productivity and efficiency of the project, in order to deal with low availability of resources, proper reserves and contingency planning can be done.

In order to deal with the situation of pandemic and continue the working of the project, proper precautions like PPE kits, gloves, and face shields can be taken.

In order to deal with communication gap which is one of the major risk for the project success proper meetings and communication strategies needs to be established.

In order to deal with poor performance and poor management decision it is required to do regular controlling and monitoring activities for the project that helps in reducing the cost and increasing the efficiency for the project.

Project monitoring and Evaluation

In order to have a proper project monitoring and evaluation criteria for the project of database management system in atlas company and schedule management plan and resource requirement plan has been developed that can help the management in understanding the importance of schedule and can also help in managing them all the timelines with better efficiency and utilization.

The below provided schedule management plan helps in understanding the different schedule provided in the form of the game chat and critical path analysis while managing different activities during the project.

                                                              Schedule Management plan

Project title: Atlas company database system upgradation

Schedule Tools: Gantt chart and critical path analysis

Level of Accuracy                              Units of Measure                                          Variance Thresholds

 86%                                                     Controlling measures and                               Weekly checks.

                                                              Comparison between actual

                                                              and planned.

Schedule reporting and format

Daily performance trackers and master trackers are going to be developed.

Process Management

Training and performance reviews of project team members.

Activity Identification 2 weeks
Activity Sequencings 1 week
Estimation of resources 2 Weeks
Estimation of duration and effort 2 weeks
Data migration and development 4 weeks
Testing and change request 2 weeks
Updating, monitoring and controlling weekly
Support 1 week

Requirement document

Requirement document is a systematic document that helps in gathering the requirements of a project like the functional needs, non-functional needs and also helps in managing them effectively. With the help of requirement document it becomes easy to manage all the requirements of project at the initiation and different levels of the project.

Project name Atlas company
Reference code 5987
Reference no 45736
Location Melbourne, Australia
Due Date 2 November
Detailed project requirements

  • Scope     

                                                               

  • Inputs
  • Outputs
  • Due date
  • Acceptance criteria
  • Testing and quality control
  • Additional instructions
  • Technical requirements
Making a database management software upgradation to Oracle software so that all the needs of the data management and record handling can be done effectively

.

Hardware, physical storage areas, servers, technical consultants, functional requirements, nonfunctional requirements, Reserves.

31 Jan 2021

Company standards and requirements

Approval by quality assurance team

Required for completion of the project

Techno-functional consultants with knowledge of servers.Approved ByWill SmithSignature

Conclusion

After going through in the taluses in case study of at least company who is looking forward to hell of a database management upgradation system with Oracle software it can be easily set and concluded that, With the help of proper project management techniques and documentation it becomes very important to manage different asking procedures required to complete the task on time with higher accuracy and efficiency. There are several documentations that are facilitating organization to take a pill of utilization of resources like project charter risk management blogs stakeholder management documents communication plans that can help them in avoiding duplication of work and achieving optimum utilization of resources.

At the end it can be easily set up concluded that with having appropriate documents in hand and proper planning and initiation in mind it is easy to achieve all the project goals and objectives with higher efficiency and success

References

Athiyah, U., Rahem, A. and Setiawan, CD, 2018. An Analysis of Drug Requirement Plan and Its Relationship with Anti-Hypertension Drug Availability at Community Health Centers. International Journal of Pharma Research and Health Sciences6(4).

Björkstrand, R., 2019. Change request knowledge management in global product data management.

de Assis, C.A., Houtman, C., Phillips, R., Bilek, E.M., Rojas, O.J., Pal, L., Peresin, M.S., Jameel, H. and Gonzalez, R., 2017. Conversion economics of forest biomaterials: risk and financial analysis of CNC manufacturing. Biofuels, Bioproducts and Biorefining11(4), pp.682-700.

Demirkesen, S. and Ozorhon, B., 2017. Impact of integration management on construction project management performance. International Journal of Project Management35(8), pp.1639-1654.

Fashina, A.A., Abdilahi, S.M. and Fakunle, F.F., 2020. Examining the challenges associated with the implementation of project scope management in telecommunication projects in Somaliland. PM World Journal.

Kivilä, J., Martinsuo, M. and Vuorinen, L., 2017. Sustainable project management through project control in infrastructure projects. International Journal of Project Management35(6), pp.1167-1183.

Martin, J. and Haggerty, N., 2017. The Project Charter as a Sensemaking Device.

Radujković, M. and Sjekavica, M., 2017. Project management success factors. Procedia engineering196, pp.607-615.

Behzadi, G., O’Sullivan, M. J., Olsen, T. L., & Zhang, A. (2018), Agribusiness supply chain risk management: A review of quantitative decision models. Omega79, 21-42.

Corvello, V., Javernick-Will, A., & Ratta, A. M. L. (2017). Routine project scope management in small construction enterprises. International Journal of Project Organisation and Management9(1), 18-30.

Demirkesen, S. and Ozorhon, B., (2017), Impact of integration management on construction project management performance. International Journal of Project Management35(8), pp.1639-1654.

Hansen, J., Hellin, J., Rosenstock, T., Fisher, E., Cairns, J., Stirling, C., … & Campbell, B. (2019), Climate risk management and rural poverty reduction. Agricultural Systems172, 28-46.

Mark, S. and Lurie, Y., (2018), Customized project charter for computational scientific software products. Journal of Computational Methods in Sciences and Engineering18(1), pp.165-176.

Martin, J., & Haggerty, N. (2017), The Project Charter as a Sensemaking Device.

Nurre, S. G., & Weir, J. D. (2017). Interactive Excel-based Gantt chart schedule builder. INFORMS Transactions on Education17(2), 49-57.

Ong, H. Y., Wang, C., & Zainon, N. (2016). Integrated earned value Gantt chart (EV-Gantt) tool for project portfolio planning and monitoring optimization. Engineering Management Journal28(1), 39-53.

Sutrisna, M., Ramanayaka, C. D., & Goulding, J. S. (2018). Developing work breakdown structure matrix for managing offsite construction projects. Architectural engineering and design management14(5), 381-397.

Valdés-Souto, F. (2019, October). Earned Scope Management: Scope Performance Evaluation for Software Projects Considering People and Effort as Resources. In 2019 7th International Conference in Software Engineering Research and Innovation (CONISOFT) (pp. 213-222). IEEE.

Appendix

                                                              Schedule Management plan

Project title: Atlas company database system upgradation

Schedule Tools: Gantt chart and critical path analysis

Level of Accuracy                              Units of Measure                                          Variance Thresholds

 86%                                                     Controlling measures and                               Weekly checks.

                                                              Comparison between actual

                                                              and planned.

Schedule reporting and format

Daily performance trackers and master trackers are going to be developed.

Process Management

Training and performance reviews of project team members.

Activity Identification 2 weeks
Activity Sequencings 1 week
Estimation of resources 2 Weeks
Estimation of duration and effort 2 weeks
Data migration and development 4 weeks
Testing and change request 2 weeks
Updating, monitoring and controlling weekly
Support 1 week
                                                              Schedule Management plan

Project title: Atlas company database system upgradation

Schedule Tools: Gantt chart and critical path analysis

Level of Accuracy                              Units of Measure                                          Variance Thresholds

 86%                                                     Controlling measures and                               Weekly checks.

                                                              Comparison between actual

                                                              and planned.

Schedule reporting and format

Daily performance trackers and master trackers are going to be developed.

Process Management

Training and performance reviews of project team members.

Activity Identification 2 weeks
Activity Sequencings 1 week
Estimation of resources 2 Weeks
Estimation of duration and effort 2 weeks
Data migration and development 4 weeks
Testing and change request 2 weeks
Updating, monitoring and controlling weekly
Support 1 week
Project name Atlas company
Reference code 5987
Reference no 45736
Location Melbourne, Australia
Due Date 2 November
Detailed project requirements

  • Scope     

                                                               

  • Inputs
  • Outputs
  • Due date
  • Acceptance criteria
  • Testing and quality control
  • Additional instructions
  • Technical requirements
Making a database management software upgradation to Oracle software so that all the needs of the data management and record handling can be done effectively

.

Hardware, physical storage areas, servers, technical consultants, functional requirements, nonfunctional requirements, Reserves.

31 Jan 2021

Company standards and requirements

Approval by quality assurance team

Required for completion of the project

Techno-functional consultants with knowledge of servers.Approved ByWill SmithSignature

Risk Management Plan

Project Name: Atlas Company

Project Overview: Making a database management software upgradation to Oracle software so that all the needs of the data management and record handling can be done effectively.

Project Lead: Will Smith

Risk Identification & Planning

Risk Overview Category Risk triggers
Low level of resources Internal risk poor Performance management
Pandemic situation External risk Overall execution of the project.
Poor management Internal risk It may leads to failure and delay in the project.
Performance issue Internal risk Duplication and underperformance by the project team.
Communication gap Internal Miscommunication and delay in decision making.
Other risk

High turnover

Lower efficiency

Internal May lead to increase in cost and time required for completion of the project.

Planning

 In order to minimize the different risk that might hamper the productivity and efficiency of the project, in order to deal with low availability of resources, proper reserves and contingency planning can be done.

In order to deal with the situation of pandemic and continue the working of the project, proper precautions like PPE kits, gloves, and face shields can be taken.

In order to deal with communication gap which is one of the major risk for the project success proper meetings and communication strategies needs to be established.

In order to deal with poor performance and poor management decision it is required to do regular controlling and monitoring activities for the project that helps in reducing the cost and increasing the efficiency for the project.

  Q1 Q2 Q3 Q4
Benefits        
Increased revenue  702 585 655 398
Cost saving  546 455 510 309
Costs avoided 1404 1170 1310 796
Quarterly Total benefit  1560 1300 1456 884
Cumulative Value 1560 2860 4316 5200
Investments        
one time investment 8010 0 1780 890
Ongoing investment 990 0 220 110
quarterly total 9000 0 2000 1000
Cumulative Investment 9000 9000 11000 12000
Name Interest Level Influence Level Potential strategies for management
Will Smith High High As he is the project coordinator all the proceedings are going to be directly managed by him. He must be informed regularly with all the preceding of the project.
Rebeka Adams High High All the business requirement gathering is going to be done by her, it becomes very important to access all the client needs very carefully so that the database management upgradation can be done carefully.
Finance Manager High High He needs to be informed about all the expenses of the project that can help in building trust.
Sales manager High High They are opposing the change hence need to convey about the importance of the new change.
Service managers High High Service team will acquire huge positive impact from the development of this software as it will operations will be much more automatic and systematic in nature
Customers High Low Owing to the rise in the number of customers (and anticipated potential growth) it was often difficult to monitor the fleet or cars for loans and to respond to customer requests if one is eligible to make a reservation. With consumers continuing to seek multiple payment mechanisms such as e-mail, PayPal etc., the app can support.
Workers Medium High Continuous motivation and work related guidelines needs to be provided.
Suppliers Medium Medium Competitive pricing strategies need to be adopted to ensure timely delivery of the raw material.
Employees of Atlas High Medium Any resistance by the employees can cause high damage to the plan. In order to avoid this, it is important to communicate the need of change.