27.11.2025 aktualisiert
100 % verfügbar
Freelancer Microsoft BI Specialist
Gemünden, Deutschland Hanze University of Applied Sciences, Groningen, 1993
Skills
SQL Server, Programming, SQL Server databases as DBA, Deutsche Bahn, Société Générale, AEGON, HELABA, SQL Server DBA, ABNAMRO, Fortis, CGI, Friesland Bank, KPN, Application Developer, PL/SQL, SSRS, MS Access, VBA, Net, C#, R, MVVM, WPF, ENECO, NUON, client server, backend, frontend, Excel, Word, object oriented design, MS Office, databases, database, SAP, SQL Server 2008 R2, SQL, XAML, Infragistics, Entity Framework, Jenkins, Visual Studio, SSIS, SSAS, Tortoise SVN, HP ALM, CA Harvest, Change Manager, CMM, Redgate SQL, DWH, ETL, Object, Data Quality, database performance, agile methods, Data Vault, Microsoft Azure SQL DB, Power-BI, stored procedures, SSIS packages, data analysis, SCRUM, PowerShell, Azure SQL DB, Azure SQL DWH, SQL Server 2016, VSTS, Agile SCRUM, data processing, Windows Server, Sybase ASE, Excel/Access, Windows Server 2000, HPSC, Access, Sybase, ASE, RHEL7, VMWare vSphere, Oracle 11, IIS, Citrix XenApp, XenDesktop, Cognos, ITIL, ASL, reporting tools, Agile, Prince2, EPM, SAP BI, IT security, system configuration, MS Project, MS Project Server, SharePoint, SharePoint Server, DTS, Data warehouse, Microsoft's Enterprise Project Management, dynamic data, bugs, MS EPM, MS SharePoint Server, MS SQL Server, MS SQL Server Management Studio, MS SQL Server Reporting Services, ODBC, MS Project/VBA, SharePoint 2010, ARIS, Business Objects, Configuration Manager, data migration, Configuration Management, MS Access application, HP Quality Center (QC), MS Access/VBA, BIA, visualization, MS Project interface, PowerPoint, Visio, Pro, Photoshop, MS Project /VBA, PowerPoint/VBA, Visio/VBA, Excel/VBA, agile/scrum, QA Management, Access/VBA, Project Server, SQL Server Management Studio, SQL Server Reporting Services, SQL Developer, QA Manager, EPM database, EPM databases, function points, system. In, RUP, UML, SOAP, Java, DB2, Cobol, Tuxedo, UniFace, Niku Workbench, IBM WebSphere, Bea WebLogic, Web server, Bea WebLogic server, Oracle, GIS, SmallWorld, Unix, MicroStation, VB, Server, C++, database design, Testframe, DSDM, MS Visual Source, Oracle Forms, Emacs, GPS, algorithm, MapInfo, dBase, Clipper, SPSS, MATLAB, geographical information system, bug fixing, SDM, WML, MS EPM (Project Server), MS Excel, C++/C#/.Net, MS SharePoint, MicroStation GIS, SmallWorld GIS, AutoCAD / AUTO LISP, PC Draft, Arkey Arcos, ++ Obj, Oracle CRM, SQL Server Databases, SQL Server Integration-Services 2019, Microsoft SQL Server 2019, x, Specialist x, Developer x, Project Manager x, QA Manager x, Systems Manager x, Scrum Master, Configuration Manager x, Manager x, Tester x, Bureau x, Bid Manager x, Methodology / Method, Scrum x, Workshops x, Prince2 x, ITIL / ITSM X, DSDM x, SDM x, UML x, ASL x, ISO 9001 x, ISO 14001 x, SQL Server x, T-SQL x, MS VBA X, C#/.Net x, SSIS X, SSRS X, PowerShell X, Excel x, EPM x, Project x, Access x, SharePoint x, SPSS x, R X, CAD x, Small World, GIS x, MapInfo GIS x, SSAS x, Windows Server (2003/2008/2012, Active Directory x, Arc Info GIS x, Oracle x, Clipper x, Java x, Linux/RHEL 7 x, VMware x, Sun Solaris X, Sybase ASE X, MS Dynamics X, architect / advisor
Sprachen
DeutschMutterspracheEnglischverhandlungssicherFranzösischgutItalienischgutNiederländischMuttersprache
Projekthistorie
HELABA started the development of its credit risk management system in the early 2000s as a client server application with a SQL Server backend and an MS Access frontend. Within 15 years of time the complexity grew into a software hog with more than a million lines of code. German joined the Team BI in order to maintain the current system as well as to develop a new modern frontend. After modelling the application and adding a debug code trail to the software he was able to quickly analyze and resolve outstanding issues as well as expand functionality of the backend and the multiple frontends (MS Access, Excel, Word, half a million lines of code each in complex object oriented design patterns…). Quickly he became known as all-round trouble shooter for MS Office and VBA related issues. In the meantime, he (co-)developed the new .Net frontend for the credit risk management application as well as numerous other databases as well as complete applications, for example an HR Reporting database based on SAP data. For detailed statistical analysis of operational risk data, he created R-scripts i.e. classes. Currently he is the responsible Systems Manager for Credit Risk and Operational Risk Applications.
Aegon Finance / Master Servicing
Aegon started the improvement project at the beginning of 2016. German joined the
initiative in September. After mapping the current situation and bringing the
team up to speed for agile methods he initiated a separate analysis phase to
determine the full range of business and data requirements. This phase resulted
in the documentation and analysis (technical and business wise) of ca. 4000 data
fields and ca. 10.000 lines of SQL code. Meanwhile he designed a relational data
model which was soon replaced for a Data Vault model due to the DQ issues that
were discovered. The current SQL Server 2008 R2 was replaced by a brand-new
Microsoft Azure SQL DB instance (OTAP) with a 4-tier DWH solution (landing zone,
control tables, data vault, data marts) with a SSRS/Power-BI frontend. German
designed and built the DWH-structure, all SQL statements, stored procedures, SSIS
packages and SSRS reports. For detailed statistical source data analysis, he
created R-scripts. Further activities were providing the services of a SCRUM
master and supervising an internship sub-project (scraping pdf data with
PowerShell) and being the technical lead of a team of four people.
Tools: SQL Server 2008 R2, Azure SQL DB, Azure SQL DWH, SQL Server 2016,
PowerShell, VSTS, Visual Studio, SSIS, SSRS, R
Skills: Mortgages, Business Information Analysis, DWH Design/build, ETL, Agile
SCRUM
Aegon started the improvement project at the beginning of 2016. German joined the
initiative in September. After mapping the current situation and bringing the
team up to speed for agile methods he initiated a separate analysis phase to
determine the full range of business and data requirements. This phase resulted
in the documentation and analysis (technical and business wise) of ca. 4000 data
fields and ca. 10.000 lines of SQL code. Meanwhile he designed a relational data
model which was soon replaced for a Data Vault model due to the DQ issues that
were discovered. The current SQL Server 2008 R2 was replaced by a brand-new
Microsoft Azure SQL DB instance (OTAP) with a 4-tier DWH solution (landing zone,
control tables, data vault, data marts) with a SSRS/Power-BI frontend. German
designed and built the DWH-structure, all SQL statements, stored procedures, SSIS
packages and SSRS reports. For detailed statistical source data analysis, he
created R-scripts. Further activities were providing the services of a SCRUM
master and supervising an internship sub-project (scraping pdf data with
PowerShell) and being the technical lead of a team of four people.
Tools: SQL Server 2008 R2, Azure SQL DB, Azure SQL DWH, SQL Server 2016,
PowerShell, VSTS, Visual Studio, SSIS, SSRS, R
Skills: Mortgages, Business Information Analysis, DWH Design/build, ETL, Agile
SCRUM
The Master Control Room is the command center of ING and be-ensures all systems
and controls the data processing. German is responsible for the proper and prompt
solution and handling of infrastructural failures, problems and interactions in
the field of SQL Server, Windows Server, and Sybase ASE. Furthermore, German
developed various reports (HPSC-DWH source) that give in-sight in the performance
of the SOS team, he also developed and implemented a time-management application
in Excel/Access.
Tools: SQL Server 2000 - 2012, Windows Server 2000-2012 (Core), PowerShell, TSM,
HPSC, Excel, Access, Sybase ASE, RHEL7, VMWare vSphere, Oracle 11, IIS, Citrix
XenApp, XenDesktop
and controls the data processing. German is responsible for the proper and prompt
solution and handling of infrastructural failures, problems and interactions in
the field of SQL Server, Windows Server, and Sybase ASE. Furthermore, German
developed various reports (HPSC-DWH source) that give in-sight in the performance
of the SOS team, he also developed and implemented a time-management application
in Excel/Access.
Tools: SQL Server 2000 - 2012, Windows Server 2000-2012 (Core), PowerShell, TSM,
HPSC, Excel, Access, Sybase ASE, RHEL7, VMWare vSphere, Oracle 11, IIS, Citrix
XenApp, XenDesktop