Alexander A. Herrmann

• Adjustments to a complex SQL-Server database system (2.800 Tables | 4.000 Procedures&Functions | 3.200 Views | 700 Triggers) • Database analysis, test, development and refactoring • Project: Serial Number Harmonization concerning Material Management Technologies: SQL-Server 2017, tSQLt, Scrum, Git, TFS, Redgate SQL Prompt / SQLClone

- Supporting and enhancing the legacy reporting system based on SQL-Server - Coaching the team in all things SQL and VBA Technologies: MS SQL Server 2012, T-SQL, SSIS, Access & Excel 2010, VBA, SAP

Datenbank-Entwickler Das Asset Quality Review (AQR) ist ein wichtiger Teil der umfassenden Beurteilung der europäischen Großbanken durch die EZB. - Teil des zentralen Entwicklungsteams einer flexiblen Access-Datenbank, die von den Wirtschaftsprüfern bei 8 deutschen Großbanken eingesetzt wurde - Unterstützung des Prüfungsteams der Hypo-Vereinsbank beim Einsatz der Datenbank sowie Erstellung ständiger Auswertungen & Statistiken Produkte: SQL-Server, Access, Excel, Sharepoint, SQL, VBA

Placed within business management to analyze and develop reporting solutions and coordinate with IT-database owners. • Writing complex Stored Procedures for reporting • Develop reports for Risk Management through SSRS and Excel • Develop customized Access-database solutions Technologies: SQL Server 2008_R2 (SSIS, SSAS, SSRS) Access & Excel 2010, VBA, Oracle

Programming & migration of the courts software system and SQL-databases in coordination with judges Technologies: Visual Basic, Word 2000, VBA, SQL, Sybase

• Development of an Access database-application for the administration and financial analyzation of 2.000 leasing cars for the accounting department • Including financial calculations, periodic automated import & export of data from Excel into Access along with reports and forecasts • Audited and approved by KPMG Technologies: Access 2002, Excel 2002, VBA, SQL, Visual Basic, SAP R/3

Development of schooling databases with web-technologies

Technician and 2'nd level support for banks in Berlin area

• Support of IT-department in migration of MS databases / applications • MS-Office, VBA, Scripting

System administrator and user-support

Database development for the prognosis of the world solar market

• Audit of SAP R/3 – System • Audit of Document Management System Technologies: SAP R/3, Excel, Access, SQL, VBA

Development of a software prototype in Visual Basic for the mathematical optimization Technologies: Visual Basic, Excel, SQL

Spanisch

Wirtschaftsinformatik Wirtschaftsenglisch Produktionswirtschaft