Project SQL Server DWH Developer - TSQL migration

MS Access, VBA

UBS AG, Zürich

PROJECT LINK: Not available
Persons in the PROJECT: Stefan Troehler
PROJECT duration: 3 months
PROJECT value: SFR. 70,000.00

Project portfolio

HOURS REQUIRED

CUP OF COFFEE

LINES IN THE CODE

EXPERTS IN THE PROJECT

The UBS AG analysts give their recommendations on the securities traded on the stock exchanges on a weekly basis.
The recommendations made by the analysts (Microsoft Excel) are summarized, consolidated and reassessed in another Excel file.
For this purpose, the individual recommendations are read in file by file using Microsoft Visual Basic for Application into the new Excel file, consolidated and reevaluated, this on the basis of defined mathematical principles and complex projections.
Taking into account all recommendations, a recommendation is recalculated for each security (buy, hold, sell).
The Microsoft Excel file consolidated in this way will then be made available to UBS AG customers on the UBS AG Internet.
Testing and documentation (user and technical).

Stefan Tröhler

20 Nov12:41:02 PM

11 May01:41:02 PM

21 Jan12:41:02 PM

08 Apr01:41:02 PM

07 Oct01:41:02 PM