Alexander Herrmann not available until 07/01/2022

Alexander Herrmann

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

not available until 07/01/2022
Profileimage by Alexander Herrmann Microsoft Datenbanken Spezialist: SQL-​Server (T-SQL, SSIS, SSRS), Access, Excel, VBA from HalternamSee
  • 45721 Haltern am See Freelancer in
  • Graduation: Master of Business Administration
  • Hourly-/Daily rates:
  • Languages: German (Native or Bilingual) | English (Full Professional) | French (Elementary) | Spanish (Limited professional)
  • Last update: 30.07.2021
KEYWORDS
PROFILE PICTURE
Profileimage by Alexander Herrmann Microsoft Datenbanken Spezialist: SQL-​Server (T-SQL, SSIS, SSRS), Access, Excel, VBA from HalternamSee
ATTACHMENTS
Full Profile with References

You need an account to view this information.

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

    • Rosen Group
    • 1000-5000 employees
    • Energy, water and environment
  • SQL-Server Database Developer for Business Software
    • 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

    • Flint Group
    • 1000-5000 employees
    • Transport and Logistics
  • Development of a Price Effect Database Prototype
  • Access & Excel 2013, SQL, VBA

  • 06/2017 - 11/2017

    • Oki Printing Solutions
    • >10.000 employees
    • Consumer goods and retail
  • Database Developer for Controlling and Customer Service
  • 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

    • Flint Group
    • 5000-10.000 employees
    • Transport and Logistics
  • Data Analyst for Controlling
  • 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

    • Oki Printing Solutions
    • >10.000 employees
    • Consumer goods and retail
  • SQL Server Database Developer for Controlling
  • - 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

    • Flint Group
    • 5000-10.000 employees
    • Transport and Logistics
  • Database Analyst for Controlling
  • 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

    • Ernst & Young
    • >10.000 employees
    • Auditing, taxes and law
  • Database Developer supporting Ernst & Young during the ECB stress-test
  • 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

    • E.ON Global Commodities
    • >10.000 employees
    • Energy, water and environment
  • SQL Server Database and Reporting-Developer for Risk Management
  • • 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

GET IN TOUCH

Message:

Sender:


exali seal of third party liability for IT representatives (special rate for freelancermap members):

The original exali seal of third party liability for IT representatives ensures that the person or company concerned has concluded an actually valid third party liability for IT representatives. This insurance has been concluded applying a special rate for freelancermap members.

Commencement of insurance:
01.03.2015

End of insurance:
01.03.2023

Show exali-profile »