Freelancer profile translated to English.

Description

As a data professional with over 20 years of experience on SQL Server, I support you with my experience from data-driven software projects: in the conception and design of databases, the setup of an infrastructure for the data pipeline, data maintenance, data enrichment and validation, as well as performance improvement of SQL jobs up to the preparation of data for data analysts and data scientists.

Visit me on my website:

der-softwareentwickler.net

Industry field of expertise

Languages

German
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Stuttgart (up to 50km), Pforzheim (up to 75km), Karlsruhe (up to 50km)

Ratepay GmbH
Analytical Business Engineering, Development of new BI Processes
BANKING AND INSURANCE
November 2021 - July 2022 (9 months)
Integration of new data sources into a data warehouse and expansion of a data mart for reporting in the business departments. Analysis, design, implementation, quality assurance and monitoring of new ETL and ELT pipelines.

• Integration of new data sources
• Implementation of new ETL processes
• Documentation and training of stakeholders
• Improvement of existing processes
• Analysis of existing reports and improvement of query performance
ETL Database Development SSIS SSRS SSAS Azure DevOps Jira Confluence Transact-SQL MS SQL Server
axsysNET AG
Migration of SQL Reports, Employee Qualification in SSRS
SOFTWARE PUBLISHING
August 2021 - October 2021 (3 months)
Migration of Crystal Reports to MS SQL Reporting Services on a SQL Server 2019. Planning, conception, realization and consulting for the switch to the new reporting solution. Training of employees.

• Analysis of existing Crystal Reports and planning of a general procedure for the migration of over 600 different reports
• Consulting and coaching for the transition
• Implementation of various complex reports in SSRS with Visual Studio 2019
• Analysis of data sources and optimization of query performance
SQL SQL Server SSRS Reporting Microsoft Visual Studio Crystal Reports Microsoft Teams
WS Weinmann & Schanz GmbH
Data Warehouse Migration, Database Development and Consulting
RETAIL (LARGE RETAILERS)
September 2019 - June 2021 (1 year and 10 months)
Balingen, Germany
Migration of SQL Server 2008 databases to SQL Server 2016. Conception, realization and consulting on the migration strategy. Setup of a new DWH according to current standards and development of data flows.

• Migration of business-critical data and processes to SQL Server 2016
• Setup of a complete DWH including loading strategy
• Analysis of existing systems and data flows
• Conception and realization of ETL and ELT processes
• Connection of existing data from a warehouse management system to the DWH
• Improvement of data quality and query performance
• Consulting and support on SQL Server related issues
SQL SQL Server Transact-SQL SSIS Microsoft Visual Studio TFS VSTS Atlassian JIRA Crystal Reports