Stefan Corsten - SQL, ETL, Reporting, DWH Development

Q: Where is Stefan based?

Stefan is based in Munich, Germany and can operate in on-site , hybrid , and remote work models.

Q: What languages does Stefan speak?

Stefan speaks the following languages: German (Native), English (Advanced), Portuguese (Advanced) .

Q: How many years of experience does Stefan have?

Stefan has at least 32 years of experience. During this time, Stefan has worked in at least 40 different roles and for 39 different companies . The average length of individual experience is 1 year and 9 months . Note that Stefan may not have shared all experience and actually has more experience.

Q: What is Stefan's latest experience?

Stefan's most recent position is SSIS Development at Stadtsparkasse München .

Q: What companies has Stefan worked for in recent years?

In recent years, Stefan has worked for Stadtsparkasse München , Loyalty Partner (Payback) , Elis GmbH , pmOne , and Altran .

Q: Which industries is Stefan most experienced in?

Stefan is most experienced in industries like Information Technology , Professional Services , and Government and Administration . Stefan also has some experience in Retail , Banking and Finance , and Transportation .

Q: Which business areas is Stefan most experienced in?

Stefan is most experienced in business areas like Information Technology , Business Intelligence , and Quality Assurance . Stefan also has some experience in Finance , Human Resources , and Marketing .

Q: Which industries has Stefan worked in recently?

Stefan has recently worked in industries like Information Technology , Professional Services , and Retail .

Q: Which business areas has Stefan worked in recently?

Stefan has recently worked in business areas like Information Technology , Business Intelligence , and Finance .

Recommended expert

Munich, Germany

Check rate

Experience

Jun 2024 - Present

2 years

Munich, Germany

SSIS Development

Stadtsparkasse München

Replacement of a Java application and the Oracle DB for loading the internal WerWasWo system using SSIS.
Development of SSIS packages to load text files into the database (SQL Server)
Development of a database project for deployment on various servers
Creation of queries to monitor the loading runs
Development of a PowerShell script to automate the deployment of the SSDT projects.
Oracle, SQL Developer, Microsoft SQL Server 2022 on-premises, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

Jul 2023 - Present

2 years 11 months

Munich, Germany

SQL and SSIS Development / Testing

Loyalty Partner (Payback)

Support of the clearing processes
Further development and stabilization of the clearing processes
Development of SSIS packages
Creation of SSRS reports
Testing of new procedures and reports
Microsoft SQL Server 2019 on-premises, SQL Server Management Studio v20, Visual Studio 2022, SSIS, SSRS, SSDT, PowerShell, Jira, Confluence, DevOps, Bitbucket.

Jul 2021 - Present

4 years 11 months

Hamburg, Germany

SQL Server Development and Reporting

Elis GmbH

Further development of an existing eODS system.
Migration of existing source code into an SSDT project, including introduction of version control (GIT).
Integration of new Laundry Management Systems (LMS) into the eODS system loading process.
Expansion of existing loads into eODS to include additional tables
Further development of SSIS pipelines for loading data from the source systems.
Adjustments of existing loads to new version updates of the source systems.
Development of a data store for sales from eODS
Development of a data store for HR
Development of loading processes from eODS to Dynamics 365 using Azure Synapse (data flow / pipeline)
Maintenance of all systems mentioned above
New development of Azure Pipelines to orchestrate the loads of all systems mentioned above.
Installation and setup of MDS on SQL Server 2019.
Creation of an MDS model for capturing master data
Monitoring of the systems, problem analysis and resolution
Elaboration of requirements from the departments and provision of suitable solutions (HR, Finance, Controlling)
Managing users in Microsoft Entra ID
Development of a PowerShell script to automate the deployment of the SSDT projects.
Extraction of data to Databricks (Parquet files / Delta Lake files)
Measures to reduce costs in the Azure environment
Microsoft SQL Server 2019 on-premises, Microsoft SQL Server 2016 Azure, Visual Studio 2019 and 2022, SSIS, SSRS, SSAS, SSDT, Microsoft SQL Server 2019 Master Data Services, Azure Data Factory, Azure Synapse, Azure Storage, Azure DevOps, JetBrains PyCharm, PowerShell, Python, Jupyter, Pandas, Databricks, Jira, Confluence, Entra ID.

Oct 2020 - Oct 2021

1 year 1 month

MDM Development with Profisee

pmOne

Development and customization of MDM portals using Profisee.
Custom programming of workflows with C# and using the Profisee SDK.
Development of user forms, matching rules, and address verification services.
Loading entities via staging tables and the associated procedures in Profisee
Development of workflows for custom functions in Profisee
Triggering workflows via subscribers and events
Development of forms, presentation views, and FastApps in the FastApp Studio for use in the Profisee portal
Development of matching rules to identify identical and similar records
Development of address verification rules to check the authenticity of addresses
Administration of the Profisee environment
Microsoft SQL Server 2016 on-premises, Microsoft SQL Server Azure, Azure Data Factory, Azure Storage Account, Azure PowerShell, Azure Key Vault, Visual Studio 2017 and 2019, Profisee SDK, C#, Profisee Server (on-premises and Azure), Profisee FastApp Studio, Profisee Portal App, Git.

Jun 2020 - Sep 2020

4 months

Wiesbaden, Germany

SQL Server Administration

HZD

Administration of the Windows and SQL servers for various procedures of the state of Hesse
Creation of new servers using VMware
Server administration
Microsoft SQL Server 2016, SQL / T-SQL, stored procedures, VMware.

May 2019 - Aug 2019

4 months

Hanover, Germany

DWH – Development

Delticom AG

Developing SSIS packages for data exchange between different systems.
Developing functions and procedures, as well as methods for table partitioning.
Developing and debugging SSIS packages
Developing and debugging functions and procedures
Implementing SCD2
Implementing table partitioning with automatic extension of the partition functions
Microsoft SQL Server 2016, SSIS 2016, SSRS 2016, SQL/T-SQL, Stored Procedures, Visual Studio 2015 and 2017, GIT, Jira, Confluence.

Aug 2017 - Apr 2019

1 year 9 months

Ludwigshafen, Germany

SQL Server Development for BASF

Softwarekontor

Migrating data from a legacy application (Java/Oracle) to a newly developed application (.Net/SQL Server 2016).
Data analysis of the legacy system
Developing procedures to extract data from the legacy system
Developing transformation routines
Building load procedures into the new database
Integrating the procedures into SSIS packages
Developing procedures for client calls
Reproducing data preparation for reporting
Automated generation of standard objects (procedures, views, etc.) using T4 templates.
Microsoft SQL Server 2016, Oracle 11.2 g, SQL Developer 4.0.2, SSIS 2016, SQL/T-SQL, T-SQL-T, XML, Stored Procedures, User Defined Functions, Tangible T4, Visual Studio 2015.

Apr 2017 - Sep 2022

5 years 6 months

Hamburg, Germany

DWH – Development and Reporting

Altran

Developing SSIS packages for data exchange between different systems in HR and job management.
Creating complex reports using SSRS.
Replacing SSIS packages with T-SQL scripts triggered via SQL Agent.
Development in a database project (SSDT) in Visual Studio 2017.
Reading data from source systems
Adjusting data to meet the requirements of target systems
Providing data to the target systems
Designing complex reports in finance and controlling
Building new reports using Power BI in SSAS Tabular Model and displaying them in Microsoft Reporting Services
Designing and building a new DWH including a staging layer using T-SQL scripts
Designing and building the Tabular Model
Developing the reports
Gathering data for the reports using DAX queries
Monitoring systems, analyzing and resolving issues
Gathering requirements from business units and providing suitable solutions. (HR, Controlling)
Microsoft SQL Server 2016, SSIS 2016, SSRS 2016, SSAS 2016, MDS, Power BI, DAX, SQL/T-SQL, Stored Procedures, Visual Studio 2015 and 2017.

Jul 2016 - Jul 2017

1 year 1 month

Erlangen, Germany

DWH – Development Microsoft Dynamics CRM for HugoBoss

Defacto Realations

Developing and debugging SSIS packages for loading data into the CRM system.
Data selection and enrichment for marketing campaigns.
Developing and troubleshooting SSIS packages for data selection in marketing campaigns.
Enhancing SSIS packages for importing data into the CRM system
Enhancing SSIS packages for data exchange in CSV or XML format.
Enhancing and troubleshooting SSIS packages that exchange data between CRM and other systems like SAP (upstream and downstream)
Microsoft SQL Server 2012, Microsoft SQL Server 2014, Microsoft Dynamics CRM 4.0, Microsoft Dynamics CRM 2015, SQL/T-SQL, Stored Procedures, C#, .NET Framework.

Jul 2016 - Mar 2017

9 months

Bonn, Germany

DWH – Development in Teradata and Informatica

DHL Paket

Transferring process procedures from development to a pilot environment.
Setting up a maintenance environment.
Enhancing quality assurance systems.
Teradata 13.00.01.04, SQL Assistant 13.0.0.15, Informatica Power Center Designer 9.1.0 Hotfix 2, Informatica Power Center Workflow Manager 9.1.0, Informatica Power Center Workflow Monitor 9.1.0, SQL/PL-SQL, AIX/UNIX/KSH/Bash, PuTTY, WinSCP, FTP, BTEQ, Perl.

Jan 2016 - Jul 2016

7 months

Wiesbaden, Germany

DWH – Data Migration (Life Department)

R + V – Versicherung

Migration of the insurance contracts from CONDOR Versicherung in Hamburg into the portfolio of R + V Versicherung.
Analysis of the PL/1 copybooks and the related data files of the source system.
Analysis of the COBOL copybooks of the target system.
Development of a C# solution to automate data processing based on the copybooks.
Translation of copybooks into XML files to describe the host data structure.
Loading and breaking down fixed-length flat files into CSV files considering OCCURS structures.
Data preparation, import and export of data.
Development of generators to create stored procedures for loading and mappings in SQL Server.
Microsoft SQL Server 2012, Microsoft SQL Server 2014, DDL, SQL / T-SQL, Stored Procedures, C#, .NET Framework, MVVM, TPL Dataflow, XQuery, LINQ to XML.

Nov 2015 - Jan 2016

3 months

Düsseldorf, Germany

DWH – Redesign

Vodafone

Review and redesign of an existing DWH to determine customer satisfaction (One CXX).
Review of the existing documentation.
Review of the existing databases, tables, attributes, values and dependencies.
Development of a DWH structure suitable for the task, taking into account the respective loading layers.
Development of a concept for creating a GUI for master data maintenance.
Sybase PowerDesigner 16.5, Microsoft SQL Server 2015, DDL, SQL / T-SQL.

Oct 2015 - Mar 2016

6 months

Munich, Germany

DWH – Development

Teradata

Development of load and unload processes for the statutory health insurance (GKV) using shell scripts, Fastload files and C functions.
Loading flat files from the statutory health insurance (billing data of the health funds) into the DWH.
Adaptation and integration of the ETL processes.
Unloading the data prepared for the respective health funds into flat files.
Creation, execution and documentation of test cases.
Unix, Bash, AWK, SED, Fastload, C, PuTTY, WinSCP, Tortoise SVN, Teradata database, Teradata Administrator 15.10, Teradata SQL Assistant 15.10, Teradata Macros, DDL, SQL / T-SQL.

Jan 2014 - Dec 2015

2 years

Nuremberg, Germany

DWH – Development

Hotel.de

Adaptation of a campaign management tool customized for HRS.
Adjustment of database structures and integration of ETL processes.
Development of new metrics in coordination with the marketing department.
Development of the reporting cube.
Reverse engineering and further development of the data model.
Bug fixes in existing ETL processes and development of new ETL processes.
Further development of the operations cube.
Participation in building a new DWH for performance optimization.
SQL Server 2012 / 2014, SSIS 2012 / 2014, SSRS 2012 / 2014, SSAS 2012 / 2014, PowerBI, Team Foundation Server, Visual Studio 2010 / 2013, C# .NET, MongoDB, SQL / T-SQL / JSON, MDX, XML / XLST, SEM / SEO / SEA, WebTrekk, Distimo, Qonka, Dymatrix Kampagnenmanagement Tool (KMT), Windows 7 / Windows Server 2012R2, Sybase PowerDesigner 16.5.

Mar 2013 - Dec 2013

10 months

Munich, Germany

DWH – Development

Pro7Sat1Group (7Games)

Monitoring of existing ETL processes (stored procedures).
Analysis of error causes and bug fixes in data load runs.
Manual data correction and reloading of time periods.
Gradual replacement of SP technology with SSIS jobs.
Analysis of existing procedures and data.
Development of SSIS processes according to documentation.
Development of reports.
Toad for MySql 11.5.1.2, SQL Server 2012, SSIS 2012, SSRS 2012, Visual Studio 2010, SQL / T-SQL, Windows XP / Windows 7, Cognos Report Studio 10.1.

Feb 2013 - Dec 2013

11 months

Munich, Germany

ETL migration and portfolio management system development

Münchner Rückversicherung

Migration of ETL processes from ODI to SSIS for technological standardization and license cost reduction.
Analysis of existing ODI processes and development of equivalent SSIS processes.
Testing, QA, error analysis and bug fixing, as well as support for report development.
Further development of a portfolio management system to calculate risks (life, annuity, income protection) using Insight Enterprise.
Development of ETL processes to load and delete portfolios and policies, as well as implementing a delta load process.
Development of stored procedures for data acquisition using MDX and OpenQuery from cubes.
Development of reports in SSRS and Excel based on stored procedures.
Insight Enterprise 9.1, SQL Server 2012, SSIS 2012, SSRS 2012, SSAS 2012, Visual Studio 2010, SQL / T-SQL / PL/SQL, MDX, Oracle 11.2.0, Toad 11.5.1.2.

Dec 2010 - Feb 2013

2 years 3 months

Bonn, Germany

Data warehouse development and reporting (E-Postbrief, Paket & Punkt, QA)

Deutsche Post / DHL

Creation of statistical analyses for the E-Postbrief product.
Import of source data via SSIS from sFTP servers into a SQL Server 2008 R2 data warehouse.
Creation, encryption (PGP/AxCrypt) and delivery of reports using SSRS.
Development of database models with PowerDesigner and replication of production environments.
Automation of report generation using C#.NET and command line applications.
Development of a customer service cube and BI reporting.
Data acquisition for the Paket & Punkt bonus program into a central fact table.
Development of transaction-controlled BTEQ scripts and loading of flat files.
Development of ETL mappings, worklets and workflows with Informatica PowerCenter (8.6.1 and 9.1.0).
Tuning of SQL statements and monitoring of regular job executions.
Teradata 13.00.01.04, SQL Assistant 13.0.0.15, Informatica PowerCenter Designer, MS SQL Server 2008 R2, SSIS, SSRS, SSAS, C#.NET, Visual Studio, Oracle 11g, PowerDesigner, BTEQ, AIX / UNIX / KSH / Bash, PuTTY, WinSCP.

May 2010 - Dec 2010

8 months

Wiesbaden, Germany

Further development of a documentation system

R+V -Versicherung

Extension of an intranet application for database documentation (tables, views, attributes) with grouping functions.
Development of the database diagram.
Development of a migration script to replicate existing data into the replication layer.
Development of a migration script to prepare data for the web interface.
Informix 8.2 (OLTP and XPS), Harvest, AQT, dbaccess, SQL / PL/SQL, AIX / UNIX / KSH / Bash, Cygwin, Perl, HTML, JavaScript, AJAX, XML.

Feb 2010 - Apr 2010

3 months

Wermelskirchen, Germany

Further development of an inventory management system

OBI

Extension of an inventory management system with e-commerce features to maintain sales channels.
Development of new forms and functions using VB6.
Development of complex SQL queries to populate grids.
SQL Server 2008, SQL Server Management Studio, SQL / T-SQL, VB6, UniToolbox, ComponentOne tools (VSFlexGrid), Eclipse.

Jul 2009 - Nov 2009

5 months

Troisdorf, Germany

Development and reporting

BW-Fuhrpark

Development and support of VBA applications in Excel and Access 2003.
Development of SQL queries and stored procedures using T-SQL on SQL Server 2008.
Development of reports with Crystal Reports 2008.
Development of an Access ADP file as a GUI with ADO data access.
SQL Server 2008, SQL Server Management Studio, SQL / T-SQL, SSIS, VBA, Excel 2003, Access 2003.

Mar 2009 - Apr 2009

2 months

Bielefeld, Germany

Development of an XML configuration and transformation tool

Diamant – Software

Development of a GUI for configuring XML transformations in VB.Net 2005.
Development of a command-line tool for automated batch transformation of XML configuration files to HTML using XSL templates.
Development of XSL templates.
Visual Studio 2005, .Net Framework 3.5, Oxygen XML Editor 10.1, MS-DOS shell scripts.

Jul 2008 - Aug 2008

2 months

Troisdorf, Germany

Development of a VBA application

BW – Fleet

Development of analysis functions in Excel 2003 (VBA).
Development of a GUI for capturing and analyzing IT processes, IT resources, interfaces, and their dependencies.
Data source: SQL Server 2005.
SQL Server 2005, SQL Server Management Studio, SQL/Transact-SQL, VB 6.0, .NET 2005, Infragistics NetAdvantage Suite 2008.

Mar 2008 - Jul 2009

1 year 5 months

Nuremberg, Germany

DWH reporting in controlling and statistics

Federal Employment Agency

Creation of cubes in Analysis Services 2000 based on requirements.
Development of transfer scripts for the process database (relational, OLAP, and file system).
Development of a tool to change the data source in the OLAP database during runtime.
Development of a tool for renaming an OLAP database.
Analysis Server 2000, SQL Server 2000, SQL/Transact-SQL/MDX, Visual Basic 6.0 and .NET 2005, DTS with VBScript, MS-DOS shell scripts.

Mar 2007 - Feb 2008

1 year

Nuremberg, Germany

Functional testing of A2LL software

T-Systems

Functional testing (QS2 level, disbursement area) of the A2LL software for calculating and paying unemployment benefit II.
Conducting tests at the premises of the Federal Employment Agency.
A2LL browser, DB-Visualizer, PVCS Tracking Tool, Mercury TestDirector 8.0, Informix, UNIX/KSH/BASH, PuTTY, WinSCP, Excel VBA and VB 6.0.

Jan 2007 - Mar 2007

3 months

Wiesbaden, Germany

Scripting and reporting

R+V-Versicherung

Data acquisition for master data supply of RUVIS-PC 3.0.
Preparation of host data using COBOL, shell, and Perl scripts for the GDV data set on AIX/UNIX.
Creation of statistical reports for the EDM system using Crystal Reports 10.
Informix, Harvest, SQL/PL-SQL, AIX/UNIX/KSH/Bash, Perl, Crystal Reports 10, CygWin.

May 2006 - Jan 2007

9 months

Bonn, Germany

DWH – Test

T-Mobile

Testing applications in the national and international data warehouse.
Creating test case catalogs and conducting systematic tests.
Defect tracking and reporting error statistics.
Generating reports with Cognos PowerPlay on automatically generated cubes.
Oracle 9/10, Informatica PowerCenter, AbInitio, Cognos PowerPlay, Toad, SQL / PL-SQL, Unix / KSH, UC4, Mercury QualityCenter, Rational TestSuite.

Apr 2006 - May 2006

2 months

Kaarst, Germany

Development of an interface for an online billing system

Megasat

Creating a Perl script for online validation and processing of credit card payments.
Implementing functions for single payments and subscription setup with automatic booking dates.
ActivePerl 5.8, Komodo Professional 3.5, Suse Linux 10, bash, ksh.

May 2005 - May 2006

1 year 1 month

Nuremberg, Germany

Data Warehouse / Reporting

Bundesanstalt für Arbeit

Creating reports with Crystal Analysis 9.0 on Microsoft Analysis Server 2000 cubes for SGB II evaluations.
Publishing the reports on the intranet using Crystal Enterprise 9.0.
Administering the Microsoft Analysis Server.
Acquiring data from OLAP cubes using MDX into relational databases via DTS.
Creating UDFs and stored procedures for data export to Excel.
Automating Excel templates for chart generation using DTS and VBA.
MS SQL-Server 2000, AS 2000, MDX, SQL, Crystal Reports/Enterprise 9.0, Office XP, HTML, XML, CSS, Javascript, VB/VBA, Innovator.

Nov 2004 - Apr 2005

6 months

Munich, Germany

Data Warehouse

Siemens

Acquiring data from local SAP systems of individual plants.
Consolidating and transforming the data into a standardized format for I2 supply chain management tools.
Oracle 8i/9i, TOAD, WinCVS, Informatika 6.2.1, Putty, PL/SQL, Unix Scripting.

Sep 2004 - Dec 2005

1 year 4 months

Development of a customer database with web frontend

In-house project

Designing and developing a database and an ASP.NET frontend to manage contact histories and contacts.
Implementing search options and mail merge functions.
MS - SQL-Server 2000, TransactSQL, ASP.NET, C#, Microsoft Server 2003, IIS 6, Sybase Power Designer.

Sep 2004 - Nov 2004

3 months

Ratingen, Germany

Creating Reports

Nemetschek Crem Solutions

Development of reports in Crystal Reports 10 compatible with MS SQL Server 2000 and Oracle 9i (ANSI SQL).
Development of a tool to generate XML files with report input parameters and data types.
MS SQL Server 2000, Oracle 9i, SQL, Transact-SQL, PL/SQL, TOAD, SQL Navigator, Crystal Reports 10, Visual Studio .NET 2003.

Jan 2004 - Sep 2004

9 months

Ratingen, Germany

User Help Desk

HP

First-level support for corporate clients and end customers.
Development of a customer database in VB.NET on MS SQL Server 2000.
Implementation of automatic case creation using API functions.
Implementation of schedules, escalation logic, import functions, and statistics.
MS SQL Server 2000, SQL, Transact-SQL, Visual Basic .NET 2003, Clarify, ComponentOne ActiveX, MS Office XP.

Oct 2003 - Dec 2003

3 months

Mönchengladbach, Germany

Hotline Support

CC-Bank

First-level support for internal staff and merchandise dealers.
Assistance with installation, configuration, and operation of financing software.
Windows NT4, Lotus Notes 5, Octohelp, MBS, AS/400, Novell administration, CAPS, ADAM/Netadam.

Sep 2002 - Sep 2003

1 year 1 month

Düsseldorf, Germany

Report and Script Generation

WestLB

Generating reports from SQL databases using MS Access (pass-through queries).
Creating Perl and shell scripts for process automation and file generation.
Managing Connect Direct jobs and processing Sybase tables.
MS SQL Server 2000, MS Access 2000, Perl, Front Arena Atlas, Connect Direct.

Aug 2002 - Sep 2002

2 months

Web Portal Installation and Customization

B2B Marketplace

Installation of web and database servers.
Configuration and testing of an online shopping application for automotive parts.
Oracle 8i, SQL*Plus 8.1.7, TOAD 7.1, Windows 2000 Server.

Jul 2002 - Jul 2002

1 month

Wiesbaden, Germany

Canteen Software Development

LTG Hessen

Development of an intranet-based canteen software with user management.
Created HTML pages and Perl scripts for database access and email sending.
Active Perl 6, MySQL 3.23.51.

Jun 2002 - Jul 2002

2 months

Network Administration Training (Samba Linux Server)

Set up a Linux server.
Administered system services, network, printers, and users.
Configured smb.conf and inetd.conf.
Samba Linux 8.0.

Mar 2002 - May 2002

3 months

Wolfsburg, Germany

Online Help Development

VW

Wrote help texts in Word.
Compiled texts into online Java help.
Microsoft Word 2000, ComponentOne Doc-To-Help 6.0.

Sep 2001 - Mar 2002

7 months

Stuttgart, Germany

Vehicle Management System Development

Daimler Benz

Developed functions and GUI in VB 6.0 (3-tier architecture).
Developed server functions in C.
Created complex SQL queries, functions, triggers, and views.
Developed reports with Crystal Reports.
VB 6.0, C with Embedded SQL, Oracle 8i, TOAD 7.3, Crystal Reports 6.0/8.5.

Feb 2001 - Aug 2001

7 months

Software Development (Customer Database & Email Client)

Medium-sized Software Company

Developed a customer database in VB 6.0 with an Access 2000 backend.
Imported data from dBase files and developed statistical analysis and charting tools.
Developed an email client with SMTP connection to Exchange Server.
Implemented send/receive routines and address book management in the registry.
Visual Basic 6.0, MS-Access 2000, Crystal Reports 8.5.

Dec 1998 - Dec 1999

1 year 1 month

Data maintenance and tool development with dBaseIV

Preparation and import of new data into existing dBaseIV databases.
Development of user interfaces and reports.
Statistical analysis and selection of modified entries.

Jan 1994 - Present

32 years 5 months

IT Support

Assembly, repair and BIOS configuration of PC systems.
Installation of operating systems (Windows, OS/2, Linux, OpenVMS).
Configuration of networks on Windows NT/2000 and SuSE Linux.
Remote maintenance of PC systems (SMS) as well as Alpha/VAX computers (VMS).

Dec 1993 - Jan 1994

2 months

Development of a voting aid with a 6502 processor

Design of a circuit to adapt signals for the serial interface.
Programming the control in Basic.
Implementation of a database for phone numbers and names.
Porting to a 68000 processor and a Casio FX-850P pocket computer.

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Professional Services, Retail, Government and Administration, Banking and Finance, and Transportation.

Information Technology

Professional Services

Retail

Government and Administration

Banking and Finance

Transportation

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Quality Assurance, Finance, Human Resources, and Marketing.

Information Technology

Business Intelligence

Quality Assurance

Finance

Human Resources

Marketing

Summary

I bring a strong background in SSIS development, SQL Server, and data integration. I have designed and implemented complex ETL solutions and managed data migrations across diverse systems. My work includes developing reliable processes using SSIS packages, PowerShell scripts, and SSDT projects, ensuring data accuracy and continuous process improvements.

Over the years I have gained experience in multiple environments ranging from on-premise servers to cloud-based solutions. I have successfully supported systems in finance, insurance, and retail, always focusing on practical, cost-effective solutions while maintaining high data quality and robust reporting functionality.

Skills

Hardware And Computer Systems

Ibm-Pc
Dos
Windows 95 / 98 / Me
Windows Nt (All Versions, Server And Client)
Windows 2000 (All Versions, Server And Client)
Windows Xp
Windows Vista (All Versions)
Windows 7 (All Versions)
Windows 8
Windows 8.1
Windows 10
Windows Server 2003 - 2012
Os/2
Linux / Unix
Mac Os X

Databases And Development Tools

Dbase Iv For Dos
Informix
Ms Access
Ms Sql Server 2000 - 2022
Ms Analysis Services (Ssas) 2000 - 2022
Ms Reporting Services (Ssrs) 2005 - 2022
Ms Integration Services (Ssis) 2005 - 2022
Ms Master Data Services (Mds)
Ms Power Bi
Oracle 8 - 11
Teradata
Mongodb
Mysql
Informatica Powercenter 8.6.1 Hotfix 12
Informatica Powercenter 9.1.0 Hotfix 2
Cognos Powerplay
Cognos Reporting Studio 10.1
Cognos Query Studio 10.1
Ab Initio
Visual Studio 2003 – 2022
Tfs
Git
Profisee Master Data Management
Azure Adf
Azure Synapse
Azure Storage
Databricks

Programming Languages

Sql
Transact-Sql
Pl/Sql
Mdx / Dax
C / C++ / C#
Perl
Php
Python / Pyspark / Jupyter / Pandas
Basic (Visual Basic .Net 2003 - 2015 / Visual Basic 6.0 / Quickbasic / Vba / Vbscript)
Asp.Net
.Net Framework
Pascal (Turbo Pascal 6.0 / Delphi 5.0)
Unix Shell Scripts
Powershell

Other

Html / Css
Xml / Xslt
Java (Basic Knowledge)

Standard Software

Ms Office (Including Vb/Vba Programming)
Ms Visio
Ms Project

Languages

German

Native

English

Advanced

Portuguese

Advanced

Education

Oct 2014 - Jun 2016

ILS Fernstudium

Computer Science

Oct 2000 - Jun 2001

Programming in C/C++ and VB 6, as well as network administration in a Windows 2000 environment

Certifications & licenses

MOC 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

Microsoft

MCSA SQL Server 2012

Microsoft

MOC 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Microsoft

MOC 70-462: Administering Microsoft SQL Server 2012 Databases

Microsoft

MOC 70-461: Querying Microsoft SQL Server 2012

Microsoft

Statistics

Experience

Total positions 43

Experience in Information Technology 32.5 y

Avg length 1 y 8 m

Longest experience 32 y 4 m

Global Experience

Countries worked in 1 (Germany)

Primary country Germany

Expertise

Recent roles SSIS Development, SQL and SSIS Development / Testing, SQL Server Development and Reporting

Main industries Information Technology, Professional Services, Retail

Main business areas Information Technology, Business Intelligence, Quality Assurance

Qualifications

Certifications earned 5

Profile

Created

June 2025

Last Update

May 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Stefan based?

Stefan is based in Munich, Germany and can operate in on-site, hybrid, and remote work models.

What languages does Stefan speak?

Stefan speaks the following languages: German (Native), English (Advanced), Portuguese (Advanced).

How many years of experience does Stefan have?

Stefan has at least 32 years of experience. During this time, Stefan has worked in at least 40 different roles and for 39 different companies. The average length of individual experience is 1 year and 9 months. Note that Stefan may not have shared all experience and actually has more experience.

What roles would Stefan be best suited for?

Based on recent experience, Stefan would be well-suited for roles such as: SSIS Development, SQL and SSIS Development / Testing, SQL Server Development and Reporting.

What is Stefan's latest experience?

Stefan's most recent position is SSIS Development at Stadtsparkasse München.

What companies has Stefan worked for in recent years?

In recent years, Stefan has worked for Stadtsparkasse München, Loyalty Partner (Payback), Elis GmbH, pmOne, and Altran.

Which industries is Stefan most experienced in?

Stefan is most experienced in industries like Information Technology, Professional Services, and Government and Administration. Stefan also has some experience in Retail, Banking and Finance, and Transportation.

Which business areas is Stefan most experienced in?

Stefan is most experienced in business areas like Information Technology, Business Intelligence, and Quality Assurance. Stefan also has some experience in Finance, Human Resources, and Marketing.

Which industries has Stefan worked in recently?

Stefan has recently worked in industries like Information Technology, Professional Services, and Retail.

Which business areas has Stefan worked in recently?

Stefan has recently worked in business areas like Information Technology, Business Intelligence, and Finance.

What is Stefan's education?

Stefan attended ILS Fernstudium for Computer Science.

Does Stefan have any certificates?

Stefan has 5 certificates. Among them, these include: MOC 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012, MCSA SQL Server 2012, and MOC 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.

What is the availability of Stefan?

Stefan will be available part-time from July 2026.

What is the rate of Stefan?

Stefan's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.