Project description MIGRATIONS PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Matrix42, Microsoft SQL Server, T-SQL, Reporting Server

UBS

Matrix, MS SQL Server, T-SQL, Reporting Server

IBM Kelsterbach

PROJECT LINK: Not available
People in PROJECT: Stefan Troehler
PROJECT Duration: May 2020 - Aug 2022
PROJECT Value: SFR. 00'000.00
 

Migrationen

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

Based on the Matrix42 Workflow Management application, a report on compliance with the SLA contracts is created by IBM, taking into account the SLA contracts. The source of the data is the Microsoft SQL Server, which serves as the backend of the Matrix42 workflow management application. With the help of dynamic functions, the reports are generated in matrix as well as Github the workflows, which automatically generate monthly or temporary calculations for the reports. Here is a small excerpt of the knowledge required to implement this project:

  • Create SLA reports in Matrix42 (Microsoft Reporting Server).
  • Create workflows in Matrix42 (T-SQL, SQL).
  • Create complex queries with T-SQL (T-SQL, SQL).
  • Creating complex stored procedures with T-SQL (T-SQL, SQL).
  • Creating complex functions with T-SQL (T-SQL, SQL).
  • Testing dynamic complex reports (T-SQL, SQL).
  • Dynamic complex queries (T-SQL, SQL).
  • Dynamic workflow with T-SQL (T-SQL, SQL).