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.
* 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.