portfolio
Project management - Microsoft Access, VBA, Microsoft Excel, SQL
Creation of a project management application for the financial officers of the Board of Directors of UBS AG. Group projects were monitored with this application. For this purpose, data from various sources were loaded and compared with the respective accounting values (financial data). The budget and the hours worked were monitored. The application was developed using Microsoft Access, VBA, SQL and Microsoft Excel.
Microsoft SQL Server and SSIS, SSRS development
Creation of complex SSIS packages to migrate existing data into a uniform data structure.
Microsoft SQL Server DWH and SSIS, SSRS, SSAS and T-SQL development
The aim of the project is the generation of reports based on a data warehouse to be created, which evaluates the data from Microsoft SCCM.