Upgrade Post project
Profileimage by Alexander Herrmann Microsoft Datenbanken Spezialist: SQL-​Server (T-SQL, SSIS, SSRS), Access, Excel, VBA from HalternamSee

Alexander Herrmann

Haltern am See
available

Last update: 02.01.2024

Microsoft Database and Reporting Specialist: SQL-​Server (T-SQL, SSIS, SSRS), Access, Excel, VBA

Company: Herrmann und Bücker GbR
Graduation: Master of Business Administration
Hourly-/Daily rates: show
Languages: German (Native or Bilingual) | English (Full Professional) | French (Elementary) | Spanish (Limited professional)

Keywords

Attachments

Alexander Herrmann - SQL-Server Programmer 2020.pdf

Skills

Industries:
- Finance: Controlling / Risk Management / Banking
- Energy
- Government Agencies
- Logistics
-----------------------

Skills:
- Data Modelling
- SQL Database Development
- Reporting

MS SQL Server / Business Intelligence (BI):
Microsoft SQL Server 2017: T-SQL, Stored Procedures, Reporting Services (SSRS)
 
MS Access / VBA:
- Microsoft Access 2010 / Microsoft Access 2007 / Microsoft Access 2003
 
MS Excel / VBA:
- Microsoft Excel 2010 / Excel 2007 / Excel 2003

Personality:
  o able to quickly find his way around unfamiliar facts, contexts and processes
  o quick comprehension, result-oriented
  o Team Player
  o Punctual
  o Friendly
  o Healthy / Fit / Never Sick
  o Service oriented

Project history

06/2018 - 07/2020
SQL-Server Database Developer for Business Software
Rosen Group (Energy, water and environment, 1000-5000 employees)
  • 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
Knowledge: Scrum | Git | Business Reporting
Products: Microsoft SQL-Server 2017 | TSQL | tSQLt | TFS | Redgate | SQL Prompt | SQLClone
12/2017 - 02/2018
Development of a Price Effect Database Prototype
Flint Group (Transport and Logistics, 1000-5000 employees)
Access & Excel 2013, SQL, VBA
06/2017 - 11/2017
Database Developer for Controlling and Customer Service
Oki Printing Solutions (Consumer goods and retail, >10.000 employees)
Im Customer Service die Linux Server und MySQL-Datenbanken dokumentieren und weiterentwickeln.
Im Controlling neue Reports und Datenbanken aufsetzen

Kenntnisse: Controlling | Customer Service
Produkte: SQL-Server 2012 | T-SQL | MySQL | Linux | Python
11/2016 - 04/2017
Data Analyst for Controlling
Flint Group (Transport and Logistics, 5000-10.000 employees)
Support of Controlling Department in Data Processing

Supporting the complex yearly approval process of customer contracts. Enhancing and automating processes via VBA and SAP BeX


Products: Excel 2013 | VBA | SAP R3 | SAP BEx Analyzer | Access 2013
03/2015 - 10/2016
SQL Server Database Developer for Controlling
Oki Printing Solutions (Consumer goods and retail, >10.000 employees)

- Supporting and enhancing the legacy reporting system based on SQL-Server, SSIS, Excel and Access VBA

 - Coaching the Controlling-Team in all things SQL and VBA

Products: MS SQL Server 2012 | T-SQL | SSIS | Access 2010 | Excel macros | VBA | python

12/2014 - 03/2015
Database Analyst for Controlling
Flint Group (Transport and Logistics, 5000-10.000 employees)
Financial Reporting for Business Controlling

ABC analysis of distributors and agents:
- Querying large amounts (400.000 rows) of fairly unstructured business data out of SAP BI
- Normalizing and bringing the data into relation via T-SQL

Products: SAP BEx / SAP BI / Excel 2010 / SQL-Server 2008 / T-SQL

03/2014 - 08/2014
Database Developer supporting Ernst & Young during the ECB stress-test
Ernst & Young (Auditing, taxes and law, >10.000 employees)

Das Asset Quality Review (AQR) ist ein wichtiger Teil der umfassenden Beurteilung der europäischen Großbanken durch die EZB.

Ziel war die Überprüfung der Vermögenswerte unter Berücksichtigung von Kredit- und Marktrisiken. Dies umfasst die Validierung der Datenintegrität, Stichproben aus Zielportfolien, Beurteilung der Ratings, Klassifizierung von notleidenden Forderungen, Sicherheiten und Risikovorsorge.

So wurden innerhalb kurzer Zeit, unter stetiger Anpassung der Richtlinien, mehrere Millionen von Datenfeldern erhoben und analysiert:

- Teil des zentralen Entwicklungsteams einer flexiblen 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 Reportings

Products: SQL-Server 2012 | T-SQL | Access 2010 | Excel 2010 | Sharepoint | VBA

11/2011 - 04/2013
SQL Server Database and Reporting-Developer for Risk Management
E.ON Global Commodities (Energy, water and environment, >10.000 employees)
• Entwicklung von kundenspezifischen Datenbank-Lösungen
• Enge Zusammenarbeit mit Business Usern in Koordination mit der IT
• Access Prototypen-Entwicklung
• SQL-Server Programmierung über Stored Procedures
• Reporting über Reporting Services, Excel und Access

Products: SQL-Server 2008 R2 | T-SQL | SSIS | SSRS | Excel 2010 | Access 2010 | Oracle 10g | VBA

Local Availability

Open to travel worldwide

Covered by Exali's professional indemnity insurance

Exali image

The freelancer is covered by a reliable insurance provider that offers protection against common risks associated with digital and IT professions (damage claims, third-party cyber damage, etc.).

Profileimage by Alexander Herrmann Microsoft Datenbanken Spezialist: SQL-​Server (T-SQL, SSIS, SSRS), Access, Excel, VBA from HalternamSee Microsoft Database and Reporting Specialist: SQL-​Server (T-SQL, SSIS, SSRS), Access, Excel, VBA
Register