Idag är det vanligt på större IT-företag att konstellationen i de agila teamen ändras i och med projektens kompetensbehov. Förutom de egna anställda, hyrs ofta konsulter in med spetskompetens inom olika områden. För att effektivisera projektplanering, kompetensutveckling och för att hitta kompetenser i andra team på företaget, behövdes ett verktyg för att hantera kompetenserna på företaget. Denna rapport bygger på ett uppdrag förmedlat av Transportstyrelsen. Transportstyrelsens IT-enhet växer och ett stort antal konsulter är ständigt på plats. Uppdraget gick ut på att ta fram en prototyp till en webbaserad plattform för att hantera de olika teamens kompetenser. Projektet resulterade i en webbapplikation med ett användargränssnitt byggt i Angular med data lagrad i en code first-baserad SQL-server. Kommunikationen mellan Angular och SQL-servern görs över ett Web-Api. / Today, it is common for large IT companies that the constellation of the agile teams changes based on the projects skills requirements. In addition to their own employees, consultants are often hired with excellence in different areas. In order to streamline project planning, skills development and finding skills in other teams in the company, a tool was required to manage the skills in the company.   This report is based on a mission conveyed by the Swedish transport Agency. The Transport Agency's IT unit is growing and a large number of consultants are constantly present. The mission was to produce a prototype of a web-based platform to handle teams various skills.   The project resulted in a web application with a user interface built in Angular with data stored in a code first-based SQL server. Communication between Angular and the SQL Server is done over a Web Api.

<p>  </p> <p>This project analyzes the concept of time efficiency in the data management process associated with the personnel training and competence assessments in the quality control (QC) laboratory of Nigeria’s foods and drugs authority (NAFDAC). The laboratory administrators are encumbered with a lot of mental and paper-based record keeping because the personnel training data is managed manually. Consequently, the personnel training and competence assessments in the laboratory are not efficiently conducted. The Microsoft Excel spreadsheet provided by a Purdue doctoral dissertation as a remedial to this is found to be deficient in handling operations in database tables. As a result, hence doctoral dissertation did not appropriately address the inefficiencies.</p> <p>The problem addressed by this study is the operational inefficiency that results from the manual or Excel-based personnel training data management process in the NAFDAC laboratory. The purpose, therefore, is to reduce the time it essentially takes to generate, obtain, manipulate, exchange, and securely store the personnel competence training and assessment data. To do this, the study developed a software system that is integrated with a relational database management system (RDBMS) to improve the manual/Microsoft Excel-based data management procedure. This project examines the operational (time) efficiencies in using manual or Excel-based format in comparison with the new system that this project developed, as a method to ascertain its validity.</p> <p>The data used in this qualitative research is from literary sources and from simulating the distinction between the times spent in administering personnel training and competence assessment using the New system developed by this study and the Excel system by another project, respectively. The fundamental finding of this study is that the idea of improving the operational (time) efficiency in the personnel training and competence assessment process in the QC laboratory is valid. Doing that will reduce human errors, achieve enhanced time-efficient operation, and improve personnel training and competence assessment processes.</p> <p>Recommendations are made as to the procedure the laboratory administrator must adopt to take advantage of the new system. The study also recommended the steps for the potential research to extend the capability of this project. </p>