MS SQL Server, MS Access, VBA
Julius Baer, Zürich
Persons in the PROJECT: Stefan Troehler
PROJECT Duration: Jan 2020 - Nov 2020
PROJECT value: SFR. 00,000.00
This project can be divided into three main tasks:
Task one: Creating an application using Microsoft Access for the calculation and reporting of the TAX calculations for Italy and France. The application includes the import of the tax files taking into account weekends and public holidays, the listing of the imported files as well as the possibility to store comments regarding the imported files. The second area of the application enables correction postings with regard to the imported data and the third area of the application creates a reconciliation between the financial data of the core application and the financial data that has been imported by the system. The application was implemented using Microsoft Access (backend) and the frontend was also placed in Microsoft Access using VBA.
- Creation of an application for the TAX authorities of France and
- Integration of 40 applications in one MS Access template.
- Developing various applications using VBA, Access.
- Development of various applications using VBA, Access, SQL Server.
- Creation of complex reconciliations using VBA and T-SQL.
- Create user forms and their functionalities.
- Creation of input checks and data comparisons / synchronizations.
Task two: Creating an application for Triple AAA to manage the customer's restrictions. For this purpose, a Microsoft SQL Server was used, which served as the backend, and a Microsoft Access database, which served as the frontend. My area of responsibility was the backend development with the following requirements, which were necessary to implement the project.
- Creating queries using Microsoft SQL.
- Create stored procedures using Microsoft T-SQL.
- Creation of communication interfaces using file transfer.
- Creation of communication interfaces with Jason.
- Creation of communication interfaces using XML.
- All communication interfaces were created in the form of stored functions or stored procedures using Microsoft T-SQL.