Corporate Database Development Essay For FNB.

In the course of this subject the student will be responsible for bridging theory and practice while undertaking a substantial body of work above and beyond their normal employment duties.  The student will prepare a daily log of their activities and present to the academic supervisor at fortnightly intervals.  The academic supervisor will then provide formative guidelines and feedback to the student so they can ensure the overall subject objectives are met.  

In preparing your assignment, ensure you include the following:

• a daily log of activities as part of the project;
• a description of the tasks that have been achieved on that day;
• an explanation of the outcome and how it is related to the project; and
• supporting commentary and reflection.  

Corporate Database Development for First National Bank (FNB)

The aim of the project is to implement a corporate database at FNB and make sure that the employees adapt to the changes.

First National Bank (FNB) is one of the finest banks that are set up in the Midwest. The bank has been involved in purchasing small banks in Ohio. The expansion of the business operations and activities will lead to the requirements and involvement of increased number of data sets. It will be required to implement a corporate database in the bank.

• The resources of the bank will be better utilized with the implementation of the corporate database.
• The business services and operations will be streamlined leading to higher returns on investment.
• The business risks and cost of business will come down leading to higher investor engagement and customer satisfaction levels.

• To successfully implement the corporate database in the First National Bank
• To migrate and manage the existing information and data sets in a secure manner
• To adhere with the estimated schedule and budget for the project (Wearne, 2014)

First National Bank (FNB) is one of the finest banks that are set up in the Midwest. The bank has been involved in purchasing small banks in Ohio. The expansion of the business operations and activities will lead to the requirements and involvement of increased number of data sets. It will be required to implement a corporate database in the bank. The resources of the bank will be better utilized with the implementation of the corporate database. The business services and operations will be streamlined leading to higher returns on investment. The business risks and cost of business will come down leading to higher investor engagement and customer satisfaction levels (Teller, 2013).

The following tasks will be completed by the members of the project team:

• Observation & Analysis of the Current System
• Aims and Objectives Definition
• Development of the Project Proposal
• Meeting with Stakeholders
• Project Approval
• Risks Assessment and management
• Scope Definition and Project Estimations
• Change Management Planning
• Resource Allocation
• Security Planning & Communication Guidelines
• Technical Infrastructure Analysis
• Procurement of database and other tools
• Designing of the database set-up
• Setting up of the environment and infrastructure (Dalcher, 2015)
• Network Compatibility and topologies
• Database implementation
• Syncing with other tools
• Integration with BI tools
• Migration of legacy data and systems
• User access and permissions
• Security Analysis
• Trainings to the employees of FNB
• Management of changes
• Feedback and lessons learned
• Performance ratings and measurement
• Final documentation

The members of the project team will not negotiate with the vendors and supplier groups. The marketing tasks will also not be covered.

• Project Proposal & Plan: The document covering the high-level and elaborated details of the project.
• Migrated information sets: The data sets migrated from the legacy system to the new system.
• Change Report: List and details of the changes made or to be made.
• Minutes of Meetings: The notes on the daily and weekly project meetings.
• Final Report: Completion report of the project.

• Cost & Schedule Variance: These values will be calculated as per the Earned Value Analysis method and the project will be considered successful only when the values are not negative.
• Employee Feedback: The feedback from the employees of FNB will be collected and shall be positive.
• Performance Graphs: The database performance graphs will be obtained.
• Return on Investment: The value of ROI will be calculated.

• Information Security: The implementation of the corporate database will lead to enhanced security of the information sets.
• Performance Growth: The performance and skill sets of the employees will be improved with the use of new tools.

• The skill sets of the resources will be utilized in the project correctly.
• The Project Manager will have the skills to utilize the resources in an optimum manner.

• Project schedule and budget
• Resource skills and competencies

The work breakdown structure for the project is as shown below.

There will be several changes that may come up in the project in the form of project technological changes, changes in expectations of the client, changes in quality parameters, resource changes, etc.

Management of these changes will be essential to ensure that the project is successful. There will be a phased process implemented for managing these changes. The phases will include planning of the changes by developing change requests followed by execution of the changes. The changes will then be monitored and controlled. The change closure will then take place.

Corporate Database Development for First National Bank project plan requires the company to design a corporate database and expects employees to adapt to it. In developing the project management plan, I possess both an analyst skill and managerial skills. Before framing the plan, the exact needs of the proposed system is to be framed. In doing so, various fact finding techniques can be used. In the given scenario, observations technique was used. Information was gathered on the basis of details given in the case study. I have good skills at finding out answers to three questions – What, How and When. I was able to figure out the root cause of problem. With respect to project management, I have skills pertaining to managing time and resources. Activities were broken into small manageable small tasks. Then on the basis of previously done projects, I was able to figure out the duration each of the tasks and then I also managed to find out which all activities can be done in parallel and in linear manner. The next task of resource allocation was also done proficiently because there should not be any resource conflicts. Managing resources in assigned deadline is the key behind every successful project.

I have studied Project Management as well in my course. Specifically, in project management I studied various aspects of Project Management from the perspective of PMBoK which is Project Management Body of Knowledge. It is among the most famous methodologies in project management and is being used across the world for various types of project. In the case for the database being developed for the First National Bank, the same project management principles shall be used. This is because, it’s a large and diverse project that will ultimately affect millions of users of the bank. The database has to be robust and reliable for it to perform its required functions. Within project management, specifically, the theory that shall be used extensively would be areas of project management such as Stakeholder Management, Risk Management, Change Management, Resource, Time and Budget management among others. The theories for these respective areas needs to be strong so as to be put to use for such a task. Apart from that, my theories of Database Management Systems shall also be put to use. DBMS is an active interest area particularly because all kinds of software and systems require database and a thorough understanding of the intricacies of database management will help in the development of this project.

References

Atkinson, R., Crawford, L., & Ward, S. (2006). Fundamental uncertainties in projects and the scope of project management. International Journal Of Project Management, 24(8), 687-698. doi: 10.1016/j.ijproman.2006.09.011

Dalcher, D. (2015). Going Beyond The Waterfall: Managing Scope Effectively Across the Project Life Cycle. Project Management Journal, 46(1), e2-e2. doi: 10.1002/pmj.21475

Koskinen, K. (2004). Knowledge Management to Improve Project Communication and Implementation. Project Management Journal, 35(2), 13-19. doi: 10.1177/875697280403500203

Missonier, S., & Loufrani-Fedida, S. (2014). Stakeholder analysis and engagement in projects: From stakeholder relational perspective to stakeholder relational ontology. International Journal Of Project Management, 32(7), 1108-1122. doi: 10.1016/j.ijproman.2014.02.010

Sul, W., Yeom, H., & Jung, H. (2018). Towards Sustainable High-Performance Transaction Processing in Cloud-based DBMS. Cluster Computing. doi: 10.1007/s10586-018-2826-3

Teller, J. (2013). Portfolio Risk Management and Its Contribution to Project Portfolio Success: An Investigation of Organization, Process, and Culture. Project Management Journal, 44(2), 36-51. doi: 10.1002/pmj.21327

Turner, J. (2006). Towards a theory of project management: The nature of the project governance and project management. International Journal Of Project Management, 24(2), 93-95. doi: 10.1016/j.ijproman.2005.11.008

Wearne, S. (2014). Evidence-Based Scope for Reducing “Fire-Fightingâ€Â in Project Management. Project Management Journal, 45(1), 67-75. doi: 10.1002/pmj.21395