Open Access

Betül Güngör

• This paper aimed to assist project portfolio management in driving strategic business transformation with an efficient PPM implementation because progress in business practice is slow. Motivated by the problem, the thesis, therefore, set itself the goal of developing a data model as the basis for an information system for project portfolio management. For this, the following conception was pursued: In the first chapter, the problem defini-tion, the motivation, and the structure of the work were presented to the reader. From this introductory chapter, it became clear that the rising competition pressure forces the producing enterprises to strategic reorientations and requires speed and flexibility. Although companies are aware of this, they are confronted with challenges to achiev-ing their strategic goals. Project portfolio management can be of decisive help in this respect, supporting selecting the suitable projects to achieve critical strategic goals. The second chapter introduced the basics of business transformation and project port-folio management. In addition, an introduction to data management and the pharma-ceutical industry was given. The literature has shown that there is no uniform definition for the term business transformation and that it has gained in importance over time. In addition, the essential terms, which are also frequently mentioned in connection with the change, are distinguished from one another. Further, the project portfolio manage-ment was differentiated from the program and project management. This was followed by an introduction to the pharmaceutical industry and its challenges to illustrate the relevance of the topic addressed in this thesis. In the third chapter, existing business transformation and project portfolio management were examined about their use as a basis for the data model to be developed. For this purpose, the methodology for executing a systematic literature analysis according to VOM BROCKE ET AL. was described in the first step and adapted to the research objective of this thesis. The literature review confirms the hypothesis that PPM is an essential tool for business transformation. However, existing PPM concepts only focus on the processes but not on the information management for the uniform design of the PPM and the creation of transparency. This resulted in the need for a data model as the basis for an information system for project portfolio management to increase the efficiency and clarity of the processes. From the resulting need for action, the procedure for developing the data model was presented in chapter 4. For this, first, the bases of the model theory and the unique characteristics of the Web application were compiled since the data model serves as a basis for implementing an information system. Subsequently, the procedures for de-veloping such a data model in software management were presented, and the method selected in the context of this work was derived. In the present work, the data model to one at the SCRUM methodology leaned proceeding was developed and imple-mented since the characteristics of the current work correspond to the agile proceed-ing. In chapter 5, the data model was detailed. For this purpose, the requirements analysis was carried out first. In this thesis, functional requirements were determined by the end-users using the brainstorming methodology. Non-functional requirements are based on a previously conducted systematic literature analysis. The developed data model for project portfolio management is a template for an information system. Mod-eling was done at the presentation level, including the content and navigation levels. To explain the navigation structure in more detail. The relevant pages of the information system were modeled individually. Each page (User Interface View) consists of at least two blocks (Presentation Classes). The presentation class PPM Menu is part of each page to ensure navigability and clarity of the information system. The second presen-tation class is individual and reflects the content and structure of each page. The data model was then implemented in chapter 6 using the example of Bayer AG in product supply. For this purpose, the company and its challenges were first introduced. Microsoft SharePoint was used for the implementation, as this is a standard tool for creating information systems and databases within the company. Since it was an agile approach, the plan was also tested in parallel with the implementation. The testing procedure was described. Finally, the results are presented in more detail. During the performance, it was recognized that Bayer AG still lacks uniform process steps in the PPM in some places and that these would have to be subsequently developed, deter-mined, and incorporated. Finally, in Chapter 7, the validation and critical reflection of the data model and infor-mation system were carried out. For this purpose, a short introduction to the basics of the questionnaire methodology was given, after which the questionnaire for the survey was designed. This was completed by end-users of the system (sample size n = 140) and then evaluated and interpreted. The validation showed that the previously deter-mined requirements were fully or partially met. The non-functional requirements were eval as fully completed. In addition, the underlying data model was assessed as suita-ble for use in other companies in the pharmaceutical industry. The end users have also affirmed the relevance of the system. It helps to get an overview of the company’s topic and pick up and coordinate the teams and employees of all areas. In contrast, the functional requirements were partially met. This is because not all in-formation was available within Product Supply at the implementation time. The intro-duction of a standardized PPM was still in the roll-out phase, so specific processes had not yet been uniformly defined. These should be incorporated over time.