Reinhold Schätz

Built and administered a dashboard for various KPIs from the incident/change/problem ticket system

Created the infrastructure from ETL (T-SQL) → datamarts → layer system

Split data into facts (calculating KPIs) and dimensions (data itself) via SQL views and stored procedures

Display and visualization via Power BI

Set up the data gateway → Azure

Migrated the dashboard from on-premises → Azure

Built a banking environment in Azure: installation via PowerShell/AZ CLI, Azure Bastion for RDP access, Azure Storage Explorer for files on-premises → Azure, testing SharePoint → Azure Active Directory & ADDS, linking SharePoint → Okta/OneID – SSO, migrated all apps (VB6/C#) → Azure, .NET Framework (NET Core, ASP.NET MVC)

Installed and configured Power BI/SSRS server, created dashboards/paginated reports and SSRS reports, developed SSAS cubes, developed Power BI dashboards (data modeling), datamarts and dashboard, ETL frameworks, data models, database design development, data mining, databases (SQL)

SharePoint 2019 admin/developer: installation and configuration, health services, logging, auditing, security (NTLM/LDAP), migration from SP2010 → SP2019, developed LDAP and SQL membership providers, migrated farm solutions (8 projects)

Blazor app framework evaluation: DevExpress UI components, component structure, dependency injection and data access, authentication with OWIN (OpenID Connect/SSO), routing, editing and validation, JavaScript interop, Blazor Server ↔ Blazor WebAssembly

Built DWH/SQL Server (>2012): set up DWH server, prepared for reporting, KPI calculation based on configuration, layering/data marts, dimensioning tables, layer concept with dynamic SQL

SharePoint 2016 admin/developer: installation and configuration, search service, health services, logging, auditing, security (NTLM/LDAP) via PowerShell

SharePoint 2013 Foundation admin/developer: installation and configuration, search service, Nintex workflows including security, custom membership providers, health services, logging, auditing, security (NTLM) via PowerShell

Developed web applications: architecture and design, maintenance and enhancement, integration into the IT landscape, continuous integration with SVN/GIT and Jenkins, UI via WPF, technologies: Visual Studio, C#, HTML, XSLT, XML, JavaScript, jQuery, JSON, Subversion, T-SQL, LINQ, Entity Framework, WCF services, Web API, MVC

Enhanced the Shared Cockpit Tool: generic web framework based on Entity Framework, OOP in C#, implementation via ASCX, role delegation, dynamic input forms, continuous integration with SVN and Jenkins

Created VisualBoard in SharePoint 2010: KPI display, issue/task/log management, health index overview of 35 pools, role-based security concept, admin management via application pages, web parts for pool structure and issue overview, dashboard data model, SSRS reporting, T-SQL processing for KPI calculation

Migrated SharePoint 2007 → SharePoint 2010: planning, concepts, documentation, introduction of SP2010, FBA login via LDAP, programming application pages, BCS integration, enterprise search, web parts, Subversion, Nintex workflows

Reporting resolution project: built DWH with data modeling and documentation, automatic import interfaces via SSIS/email, data loader with logging and restarts, SSRS reports and integration in SharePoint 2007 MOSS/2010, stored procedures and T-SQL optimization

Project SAP@AM: refining data delivered from custody accounts into file format and creating MT535 SWIFT messages under SOX compliance, documentation and test cases, technology: Excel VBA

Project legacy/new VB to .NET: evaluating existing VB applications, shared database and data modeling, OOP/OAD documentation, implementation in C#/.NET, 3-tier application with a small Oracle 10g DWH

Migration Oracle 8i → Oracle 10g: evaluating and documenting dependencies, testing, adapting PL/SQL statements, timely coordination and handover via SQL script

Project FXPMS/FIDB: maintenance and testing of existing VB applications for trade processing (Bloomberg), ETL with Oracle Warehouse Builder, automation via Redwood Cronacle, extension of PL/SQL procedures and Redwood chains, adjustment of the data model and UI, biannual Telekurs releases, SOX compliance and testing

Project MCD/FDR to OPDP: data extraction via SQL*Loader, transformation and loading into reporting tables, focus on data modeling, ADO, PL/SQL, OWB, BI with SSIS+SSRS