Creation of a project management for the finance officers of the Board of Directors of UBS AG. Group projects were monitored with this application. For this purpose, data was loaded from various sources and compared with the respective booking values ​​(financial data). The budget and the hours worked were monitored. The application was developed using Microsoft Access, VBA, SQL and Microsoft Excel.

• Realization of a project monitoring for the group management of UBS AG.
• With the help of this application, projects of the group management as well as global projects of the group are monitored and controlled.
• The application includes a contractor database, a project planning database with the budget figures, an invoice database with the invoiced expenses as a data basis.
• Using the information available (read from mainframe systems), various evaluations and comparisons can be made.
• Data that have been read from the mainframe systems (import) can be adapted and reimported into the systems.
• Project monitoring is implemented using Microsoft Access 2.0 and migrated to Microsoft Access 97 in 2003.
• Reports are exported to Excel.
• Requirement Engineering.
• Create a data model using Dezign.
• Implementation of customer requirements using Microsoft Access 2.0, Microsoft Visual Basic for Application, Microsoft Excel.
• Testing and documentation (user and technical).
• Later migration to Microsoft Access 97.