26.02.2026 aktualisiert

**** ******** ****
Premiumkunde
100 % verfügbar

Interim-Teamlead | Data Architect | Data Management | Oracle, SQL Server, DB2

Mannheim, Deutschland
Weltweit
Vordiplom
Mannheim, Deutschland
Weltweit
Vordiplom

Profilanlagen

20260216 Jens-Peter Giersch - Profil Deutsch.pdf
20260211 Jens-Peter Giersch - CV - General.pdf

Skills

ArchitekturBusiness IntelligenceC#DatenbankenData ArchitectureDatenmanagementData VaultData WarehousingIBM DB2BildungssystemInfrastrukturMicrosoft Sql-ServerVisual Basic .NETOracle FinancialsSchreiben von DokumentationSoftwareentwicklungVBA Programming Language
Interims-Management (vorwiegend Datenmanagement und Infrastruktur), Kommunikation, Wissensvermittlung und Dokumentation
Data Warehouse-Architektur mit Data Vault 2.0/2.1, Star/Snowflake-Schema (Kimball/Inmon), Anwendungsentwicklung und Beratung im Bereich Business Intelligence, Datenbanken und Programmiersprachen im Microsoft-Umfeld. Schwerpunkt hierbei sind SQL Server, Oracle, IBM DB2 und VB.NET/C#.NET/ VBA.

Erfahrung

Berufserfahrungmehr als 10 Jahre
Freelancer seit1998

Sprachen

BulgarischGrundkenntnisseDeutschMutterspracheEnglischverhandlungssicherPortugiesischGrundkenntnisse

Projekthistorie

Interims-Management DBA und Infrastruktur

ALD Automotive

Banken und Finanzdienstleistungen

1000-5000 Mitarbeiter

* Teamlead Database Administrators; re-organizing DBA team
* Consulting and organising the merge of IT infrastructures of two companies
* Analysis, documentation and implementation of NIST requirements
* Oracle license cost optimization
* Development and implementation of data protection processes according to GDPR and BAFIN/BAIT

Data Modeler Data Vault 2.0

Deutsche Bundesbank

Öffentlicher Dienst

1000-5000 Mitarbeiter

* Create conceptual, logical and physical data models
* Align development processes to Data Vault 2.0 methodology
* Establish Data Vault modeling and templates between teams
* Mentoring developers in regards to Data Vault 2.0
* Deployment of artefacts using PowerDesigner

Mentoring BI team

Wilhelm Böllhoff GmbH & Co. KG

Industrie und Maschinenbau

500-1000 Mitarbeiter

* Develop a coaching concept for SQL Server administration, development, SQL Server Reporting Services, SQL Server Analysis Services
* Coach junior team members
* Analyze existing BI infrastructure and identify improvement potential
* Introduce an indexing strategy (both on row based and columnstore indexes)
* Trouble shooting in SQL Server administration, SSRS and SSAS
* Prototype of SSAS Tabular model

Migration Oracle to SQL Server

VTB-Bank

Banken und Finanzdienstleistungen

1000-5000 Mitarbeiter

* Autonomous identification and implementation of requirements in close cooperation with business
* Planning and implementation of a migration- and test process
* Conception and implementation of a test process for non-standard requirements
* Migration of PL/SQL code to T-SQL

Senior Consultant, Mentor

Erste Asset Management GmbH

Banken und Finanzdienstleistungen

500-1000 Mitarbeiter

Consultant for Data Vault 2.0 architecture and modelling. Team counsel for implementation issues and modelling, processes for development, loading, implementing and documentation on behalf of Scalefree GmbH.

Senior Consultant Data Vault

Bosch AG, Stuttgart

Automobil und Fahrzeugbau

1000-5000 Mitarbeiter

Data Vault design, performance tuning on SQL Server

Senior Consultant

Telefónica Germany

Telekommunikation

1000-5000 Mitarbeiter

Implementation of a forecasting based on Oracle 11g, R and R/Shiny.
- Interface design Oracle/R
- Data design
- Implementation in R

Data Vault Modeler

WL BANK AG

Banken und Finanzdienstleistungen

500-1000 Mitarbeiter

Development of a Data Warehouse using Data Vault on SQL Server 2016: Performance Tuning, design and specifications using MID Innovator, automated creation of SSIS packages using BIML

Senior Consultant

Roche Diagnostics GmbH

Pharma und Medizintechnik

1000-5000 Mitarbeiter

Performance tuning of stored procedures, reengineering existing data platform, data carve out.

Consultant - Programmierung

arvato Systems

Konsumgüter und Handel

500-1000 Mitarbeiter

Implement a Service Broker infrastructure as a data river; performance optimization for stored procedures; design target data structures; train and mentor teams on SQL Server 2014 and Service Broker.

Data Architect

Milestone Systems

Internet und Informationstechnologie

50-250 Mitarbeiter

Data Architect: Identify requirements, propose technical solution using Data Vault modelling technique, implement the solution, document project and transfer knowledge to customer using the MS BI stack. Cooperation with near shore team in Sofia/Bulgaria.

BI Architect/Senior BI Consultant

Bayer Business and Technology Services LLC
Analysis and conception of a BI environment based on SQL Server 2008 R2/2014. Design of relational databases for staging area and data marts using Tabular Model in SQL Server 2014 based on user requirement specifications. Performance Tuning on relational DB, team lead.

BI Architect

Kassenärztliche Vereinigung Hessen (KVH)

Versicherungen

500-1000 Mitarbeiter

Planning and implementation of a BI environment based on SQL Server 2012, data migration using SSIS 2012 from Informix 11.5. Design Staging Area, trouble shooting, data validation, programming SQL stored procedures on Informix 11.5.

Technical Consultant

Daimler AG

Automobil und Fahrzeugbau

>10.000 Mitarbeiter

Adaption of documentation for SQL Server 2012 Analysis Services on Windows Server 2012 R2 as well as appropriate tests in an Hyper-V 2012 environment.

Consultant

DWS Investment GmbH

Banken und Finanzdienstleistungen

500-1000 Mitarbeiter

Short term script based migration of SQL Server 2005 databases to SQL Server 2008. Migration of logins, linked servers, synonyms, jobs etc.
Zeitlich eng begrenzte, skriptbasierte Migration von SQL Server 2005-Datenbanken nach SQL Server 2008. Migration von Logins, Linked Server, Synonyms, Jobs etc..
Tools:
TortoiseSVN, Red Gate SQL Compare

BI-Consultant

Kaufhof Warenhaus AG

Konsumgüter und Handel

1000-5000 Mitarbeiter

Development of reports based on SQL Server 2008 R2 Reporting Services (SSRS) and Oracle 11g.

VAG Armaturen GmbH

Senior Consultant

Industrie und Maschinenbau

250-500 Mitarbeiter

Microsoft SSRS: Redirect data source from SQL Server to SAP BW 7; Proof of Concept; Report design using SQL and MDX; error analysis in SSAS/SSIS, trouble shooting for performance and connections to SAP BW 7.

Consultant

Raiffeisen Schweiz

Banken und Finanzdienstleistungen

1000-5000 Mitarbeiter

Conception and implementation of database migrations from SQL Server 2000/2005 to SQL Server 2008, Performance Tuning for stored procedures, views, tables and functions. Evaluation of Unit Test Frameworks for Visual Studio 2010 (xUnit.NET, MbUnit, NUnit, MSTest)

Kontaktanfrage

Einloggen & anfragen.

Das Kontaktformular ist nur für eingeloggte Nutzer verfügbar.

RegistrierenAnmelden