Stefan Corsten - SSIS 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 Transportation , Retail , and Banking and Finance .

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

Experience

Jun 2024 - Present

1 year 10 months

Munich, Germany

SSIS Development

Stadtsparkasse München

Replaced a Java application and Oracle DB to load the internal WerWasWo system using SSIS.
Developed SSIS packages to load text files into the database (SQL Server)
Developed a database project for deployment on different servers
Developed queries to monitor loading jobs
Created a PowerShell script for automated deployment of the SSDT projects.
Oracle, SQL Developer, Microsoft SQL-Server 2022 on Prem, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

Jul 2023 - Present

2 years 9 months

Munich, Germany

SQL and SSIS Development / Testing

Loyalty Partner (Payback)

Supported the clearing processes
Enhanced and stabilized the clearing processes
Developed SSIS packages
Developed SSRS reports
Tested new procedures and reports
Microsoft SQL-Server 2019 on Prem, SQL Server Management Studio v20, Visual Studio 2022, SSIS, SSRS, SSDT, PowerShell, Jira, Confluence, DevOps, Bitbucket.

Jul 2021 - Present

4 years 9 months

Hamburg, Germany

SQL Server Development and Reporting

Elis GmbH

Enhanced an existing eODS system.
Moved existing sources into an SSDT project, including introducing version control (GIT).
Integrated new Laundry Management Systems (LMS) into the eODS loading process.
Expanded existing eODS loads by adding more tables
Enhanced SSIS workflows for loading from the source systems.
Adjusted existing loads to new version updates of the source systems.
Developed a data store for sales from the eODS.
Developed a data store for HR
Created loading processes from eODS to Dynamics365 using Azure Synapse (Dataflow / Pipeline)
Maintained all of the above systems
Developed new Azure Pipelines to orchestrate the loads for all the above systems.
Installed and configured MDS on SQL-Server 2019.
Created an MDS model for capturing master data
Monitored systems, analyzed issues, and resolved them
Gathered requirements from business units and provided suitable solutions (HR, Finance, Controlling)
Managed users in Microsoft Entra ID
Created a PowerShell script for automated deployment of the SSDT projects.
Extracted data to Databricks (Parquet files / Delta Lake files)
Implemented measures to reduce costs in the Azure environment
Microsoft SQL-Server 2019 on Prem, 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

Developed and customized MDM portals using Profisee.
Custom programming of workflows using C# and the Profisee SDK.
Developed user forms, matching rules, and address verification services.
Loaded entities via staging tables and related procedures in Profisee
Developed workflows for custom functions in Profisee
Triggered workflows via subscribers and events
Built forms, presentation views, and FastApps in FastApp Studio for use in the Profisee portal
Created matching rules to identify identical or similar records
Built address verification rules to check the validity of addresses
Administered the Profisee environment
Microsoft SQL-Server 2016 on Prem, Microsoft SQL-Server Azure, Azure Data Factory, Azure Storage Account, Azure PowerShell, Azure KeyVault, Visual Studio 2017 and 2019, Profisee SDK, C#, Profisee Server (on Prem and Azure), Profisee FastApp Studio, Profisee Portal App, Git.

Jun 2020 - Sep 2020

4 months

Wiesbaden, Germany

SQL Server Administration

HZD

Administered Windows and SQL Servers for various processes of the State of Hesse
Created new servers using VMware
Maintained the servers
Microsoft SQL-Server 2016, SQL / T-SQL, Stored Procedures, VM-Ware.

May 2019 - Aug 2019

4 months

Hanover, Germany

DWH – Development

Delticom AG

Development of SSIS packages for data exchange between different systems.
Development of functions and procedures, as well as methods for table partitioning.
Development and bug fixing of SSIS packages
Development and bug fixing of functions and procedures
Implementation of SCD2
Implementation of table partitioning with automatic extension of partitioning 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

Migration of data from a legacy application (Java/Oracle) to a newly developed application (.Net/SQL Server 2016).
Data analysis of the legacy system.
Development of procedures to extract data from the legacy system.
Development of transformation routines.
Developing load procedures for the new database.
Integrating the procedures into SSIS packages.
Developing procedures for client calls.
Recreating 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

Development of SSIS packages for data exchange between different systems in the areas of personnel and job management.
Development of complex reports using SSRS.
Replacement of SSIS packages with T-SQL scripts triggered by the SQL Agent.
Development in a database project (SSDT) in Visual Studio 2017.
Reading data from source systems.
Adjusting data to the requirements of target systems.
Providing data for target systems.
Designing complex reports in finance and controlling.
Developing new reporting using Power BI in the SSAS Tabular Model and displaying reports 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 reports.
Acquiring data for reports using DAX queries.
Monitoring systems, problem analysis, and resolution.
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 – Microsoft Dynamics CRM Development for HugoBoss

Defacto Realations

Development and bug fixing of SSIS packages for loading data into the CRM system.
Data selection and enrichment for marketing campaigns.
Development and error analysis of SSIS packages for data selection for marketing campaigns.
Further development of SSIS packages for importing data into the CRM system.
Further development of SSIS packages for data exchange in CSV or XML format.
Further development and error analysis of 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 procedural processes from development to a pilot environment.
Setting up a maintenance environment.
Further development in 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)

R + V – Versicherung

Migration of the CONDOR insurance contracts in Hamburg into the R+V Insurance portfolio.
Analysis of the PL/1 copybooks and their associated data files of the source system.
Analysis of the COBOL copybooks of the target system.
Development of a C# solution for automated processing of the data taking the copybooks into account.
Translation of the copybooks into XML files to describe the host data structure.
Loading and splitting fixed-length flat files into CSV files while handling 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 for determining customer satisfaction (One CXX).
Review of existing documentation.
Review of existing databases, tables, attributes, values and dependencies.
Development of a suitable DWH structure 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 streams for statutory health insurance (GKV) using shell scripts, Fastload files and C functions.
Loading GKV flat files into the DWH (billing data of the health insurance funds).
Adaptation and integration of ETL processes.
Unloading the data prepared for each health insurance fund into flat files.
Creation, execution and documentation of test cases.
Unix, Bash, AWK, SED, Fastload, C, PuTTY, WinSCP, TortoiseSVN, 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 the database structures and integration of the ETL processes.
Development of new key 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, Power BI, Team Foundation Server, Visual Studio 2010/2013, C# .NET, MongoDB, SQL/T-SQL/JSON, MDX, XML/XSLT, SEM/SEO/SEA, WebTrekk, Distimo, Qonka, Dymatrix Campaign Management Tool (KMT), Windows 7/Windows Server 2012 R2, Sybase PowerDesigner 16.5.

Mar 2013 - Dec 2013

10 months

Munich, Germany

DWH – Development

Pro7Sat1Group (7Games)

Monitoring existing ETL processes (stored procedures).
Analysis of error causes and troubleshooting 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

Munich Reinsurance

Migration of ETL processes from ODI to SSIS for technological standardization and license cost reduction.
Analyzing existing ODI processes and creating equivalent SSIS processes.
Testing, QA, debugging and troubleshooting as well as support for report development.
Further development of a portfolio management system for risk calculation (Life, Annuity, Income Protection) using Insight Enterprise.
Developing ETL processes to load and delete portfolios and policies and to implement a delta load procedure.
Developing stored procedures for data acquisition using MDX and OpenQuery from cubes.
Creating reports in SSRS and Excel based on stored procedures.
InsightEnterprise 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

DWH development and reporting (E-Postbrief, Paket & Punkt, QS)

Deutsche Post / DHL

Creating statistical analyses for the E-Postbrief product.
Importing source data via SSIS from sFTP servers into a SQL Server 2008R2 DWH.
Creating, encrypting (PGP/AxCrypt) and sending reports using SSRS.
Designing database models with PowerDesigner and replicating production environments.
Automating report generation using C#.NET and command-line applications.
Developing a customer service cube and BI reporting.
Acquiring data for the Paket & Punkt bonus program into a central fact table.
Developing transaction-controlled BTEQ scripts and loading flat files.
Creating ETL mappings, worklets and workflows with Informatica PowerCenter (8.6.1 and 9.1.0).
Tuning SQL statements and monitoring regular job executions.
Teradata 13.00.01.04, SQL Assistant 13.0.0.15, Informatica PowerCenter Designer, MS SQL Server 2008R2, 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 Insurance

Extending an intranet application for database documentation (tables, views, attributes) with grouping functions.
Creating the database diagram.
Developing a migration script to replicate existing data into the replication layer.
Developing 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

Extending an inventory management system with e-commerce features for managing sales channels.
Developing new forms and functions in VB6.
Creating 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 Fleet

Developing and supporting VBA applications in Excel and Access 2003.
Creating SQL queries and stored procedures using T-SQL on SQL Server 2008.
Developing reports with Crystal Reports 2008.
Creating 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 using VB.Net 2005.
Development of a command-line tool for automated batch transformation of XML configuration files into 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 – Fuhrpark

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/T-SQL, VB 6.0, .NET 2005, Infragistics NetAdvantage Suite 2008.

Mar 2008 - Jul 2009

1 year 5 months

Nuremberg, Germany

Data warehouse reporting for controlling and statistics

Bundesagentur für Arbeit

Creation of cubes in Analysis Services 2000 based on business requirements.
Development of transfer scripts for the application database (relational, OLAP, and filesystem).
Development of a tool to change the data source in the OLAP database during runtime.
Development of a tool to rename an OLAP database.
Analysis Services 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, payment processing 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 VB6.

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.
Processing HOST data using COBOL, shell and Perl scripts for the GDV data set on AIX/UNIX.
Creating statistical reports for the EDM system with 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 – Testing

T-Mobile

Testing applications in the national and international data warehouse.
Creating test case catalogs and performing systematic tests.
Defect tracking and reporting error statistics.
Creating 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 one-time payments and subscription setup with automatic billing dates.
ActivePerl 5.8, Komodo Professional 3.5, Suse Linux 10, bash, ksh.

May 2005 - May 2006

1 year 1 month

Nuremberg, Germany

DWH / Reporting

Federal Employment Agency

Creating reports with Crystal Analysis 9.0 on Microsoft Analysis Server 2000 cubes for SGB II evaluations.
Deploying the reports on the intranet using Crystal Enterprise 9.0.
Administering the Microsoft Analysis Server.
Extracting 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

Datawarehouse

Siemens

Data acquisition from local SAP systems of individual plants.
Consolidating and transforming 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 for managing contact histories and contact persons.
Implementing search options and mail merge features.
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

Developed reports with Crystal Reports 10 compatible with MS SQL Server 2000 and Oracle 9i (ANSI SQL).
Developed a tool to generate XML files with report input parameters and data types.
MS SQL Server 2000, Oracle 9i, SQL, TransactSQL, PL/SQL, TOAD, SQL Navigator, Crystal Reports 10, VS .NET 2003.

Jan 2004 - Sep 2004

9 months

Ratingen, Germany

User-Help-Desk

HP

First-level support for corporate and end users.
Developed a customer database in VB.Net on MS SQL Server 2000.
Implemented automatic case creation using API functions.
Implemented schedules, escalation logic, import functions, and statistics.
MS SQL Server 2000, SQL, TransactSQL, 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 merchants.
Assisted with installation, configuration, and operation of financing software.
Windows NT4, Lotus Notes 5, Octohelp, MBS, AS/400, Novell Admin, CAPS, ADAM/Netadam.

Sep 2002 - Sep 2003

1 year 1 month

Düsseldorf, Germany

Generating Reports and Scripts

WestLB

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

Aug 2002 - Sep 2002

2 months

Installation and Customization of a Web Portal

B2B Marktplatz

Installed web and database servers.
Configured and tested an online shopping application for auto parts.
Oracle 8i, SQL*Plus 8.1.7, TOAD 7.1, Windows 2000 Server.

Jul 2002 - Jul 2002

1 month

Wiesbaden, Germany

Development of canteen software

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 for Samba Linux servers

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

Mar 2002 - May 2002

3 months

Wolfsburg, Germany

Development of an online help

VW

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

Sep 2001 - Mar 2002

7 months

Stuttgart, Germany

Contributing to the development of a vehicle management system

Daimler Benz

Developed functions and GUI with 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)

Mittelständisches Softwarehaus

Developed a customer database with VB 6.0 and Access 2000 backend.
Imported data from dBase files and developed statistical analysis and chart tools.
Developed an email client with SMTP integration 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 in dBase IV

Preparing and importing new data into existing dBase IV databases.
Developing user interfaces and reports.
Performing statistical analysis and selecting modified entries.

Jan 1994 - Present

32 years 3 months

IT Support

Assembling, repairing, and BIOS configuration of PC systems.
Installing operating systems (Windows, OS/2, Linux, OpenVMS).
Configuring networks on Windows NT/2000 and SuSE Linux.
Remote maintenance of PC systems (SMS) and Alpha/VAX machines (VMS).

Dec 1993 - Jan 1994

2 months

Developing a voting aid with a 6502 processor

Designing a circuit for signal adaptation of the serial interface.
Programming control routines in BASIC.
Implementing a database for phone numbers and names.
Porting to a 68000 processor and Casio FX-850P pocket calculator.

Industry Experience

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

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

Information Technology

Professional Services

Government and Administration

Banking and Finance

Retail

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

Skills

Computer And Hardware 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
Abinitio
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 / Quick Basic / 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 (Incl. 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 7 m

Longest experience 32 y 2 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, Government and Administration

Main business areas Information Technology, Business Intelligence, Quality Assurance

Qualifications

Certifications earned 5

Profile

Created

June 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

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 Transportation, Retail, and Banking and Finance.

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 is immediately available part-time for suitable projects.

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.