sql server
Microsoft Access, VBA, Microsoft SQL Server - Developer / Consultant
Adapting and extending an existing Microsoft Access solution. Originally, four files were imported, the data was refined and then evaluated. The evaluations concerned the distribution of the company NEF in Germany. The user interface already existed, realised with Microsoft Access and VBA; this was made a bit more modern and clearer and the new functionality was integrated. In the new application, only two files are now imported and the data is evaluated on the basis of the two files. Again, the import is done by VBA, the user interfaces have been adapted to the two new files and a lot of plausibility logic has been implemented. The evaluations concern the warehouse stocks and the warehouse stock values of the individual employees in distribution.
Microsoft Access, VBA, SQL Microsoft SQL Server / Consultant
Adapting and extending an existing Microsoft Access solution. Originally, four files were imported, the data was refined and then evaluated. The evaluations concerned the distribution of the company NEF in Germany. The user interface already existed, realised with Microsoft Access and VBA; this was made a bit more modern and clearer and the new functionality was integrated. In the new application, only two files are now imported and the data is evaluated on the basis of the two files. Again, the import is done by VBA, the user interfaces have been adapted to the two new files and a lot of plausibility logic has been implemented. The evaluations concern the warehouse stocks and the warehouse stock values of the individual employees in distribution.
Microsoft Access-Developer/ Berater - Microsoft Access, Microsoft Excel, VBA, SQL Server, T-SQL, Jira, SAP, Oracle, DWH, Microsoft SQL Server, SSIS, Alterix
Project SDLC Reporting
The project consists of several databases, which contain the tables needed to import the data, the queries needed to refine the data, the macros needed to execute the workflow, which in turn are started by the Power Shell scripts and in turn call the functions and procedures developed using VBA. Each of these individual databases can be compared to an ETL route. Further databases consolidate the data for reporting with regard to the SDLC reports. Procedure for executing the entire application: Power Shell scripts call the macros, which in turn call the complex VBA logicians for importing the data, cleaning the data and consolidating the data. The entire application was developed using Microsoft Access, VBA and Power Shell.