Stefan Corsten
BI Developer
Experience
Jun 2024 - Present
1 year 2 months Germany
SSIS Development
Stadtsparkasse München
- Replacement of a Java application and the Oracle DB to load 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 different servers
- Development of queries to monitor load runs
- Development of a PowerShell script for automated deployment of SSDT projects
- Documentation
Jul 2023 - Present
2 years 1 month Munich, Germany
SQL and SSIS Development / Testing
Loyalty Partner (Payback)
- Support of clearing processes
- Enhancement and stabilization of clearing processes
- Development of SSIS packages
- Development of SSRS reports
- Testing of new procedures and reports
- Documentation
Jul 2021 - Present
4 years 1 month Hamburg, Germany
SQL Server Development and Reporting
Elis GmbH
- Enhancement of an existing eODS system
- Migration of existing sources into an SSDT project including introduction of version control (GIT)
- Integration of new laundry management systems (LMS) into the eODS load process
- Extension of existing loads into the eODS with additional tables
- Enhancement of SSIS workflows for loading from source systems
- Adjustments of existing loads for new version updates of source systems
- Development of a data store for sales data from the eODS
- Development of a data store for HR
- Development of load processes from the eODS to Dynamics 365 using Azure Synapse (Dataflow / Pipeline)
- Maintenance of all aforementioned systems
- New development of Azure Pipelines to orchestrate the loads of all aforementioned systems
- Installation and configuration of MDS on SQL Server 2019
- Creation of an MDS model for managing master data
- System monitoring, problem analysis and resolution
- Gathering requirements from business units and providing suitable solutions (HR, Finance, Controlling)
- Managing users in Microsoft Entra ID
- Development of a PowerShell script for automated deployment of SSDT projects
- Data extraction to Databricks (Parquet files / Delta Lake files)
- Cost reduction measures in the Azure environment
Oct 2020 - Oct 2021
1 year 1 monthMDM Development with Profisee
pmOne
- Development and customization of MDM portals using Profisee
- Custom programming of workflows using C# and the Profisee SDK
- Development of user forms, matching rules, and address verification services
- Loading of entities via staging tables and stored procedures in Profisee
- Triggering workflows via subscribers and events
- Development of forms, presentation views, and FastApps in FastApp Studio
- Development of matching rules to identify duplicate and similar records
- Development of address verification rules
- Administration of the Profisee environment
Jun 2020 - Sep 2020
4 months Wiesbaden, Germany
SQL Server Administration
Hessische Zollverwaltung (HZD)
- Administration of Windows and SQL servers for various applications in the state of Hesse
- Creation of new servers using VMware
- Server administration
May 2019 - Aug 2019
4 months Hanover, Germany
DWH Development
Delticom AG
- Development of SSIS packages for data exchange between systems
- Development and bug fixing of SSIS packages, functions, and stored procedures
- Implementation of SCD2
- Implementation of automatic table partitioning
- Documentation
Aug 2017 - Apr 2019
1 year 9 months Ludwigshafen, Germany
SQL Server Development for BASF
Softwarekontor
- Data analysis of the legacy system (Java/Oracle)
- Development of procedures for data extraction and transformation
- Development of load procedures into the new .NET/SQL Server 2016 application
- Integration of procedures into SSIS packages
- Development of procedures for client calls
- Recreation of data preparation for reporting
- Automated generation of standard objects using T4 templates
Apr 2017 - Sep 2022
5 years 6 months Munich, Germany
DWH Development and Reporting
Altran
- Development of SSIS packages for data exchange in personnel and job management
- Development of complex reports using SSRS
- Replacement of SSIS packages with T-SQL scripts via SQL Agent
- Reading data from source systems and adapting it to target systems
- Design of complex reports in finance and controlling
- Development of new reporting using Power BI in SSAS Tabular Model
- Design and setup of a new DWH including a staging layer using T-SQL scripts
- Design and setup of the Tabular Model
- Development of reports and data acquisition using DAX queries
- System monitoring, problem analysis and resolution
- Gathering requirements from business units and providing suitable solutions (HR, Controlling)
Jul 2016 - Jul 2017
1 year 1 month Erlangen, Germany
DWH Development for Microsoft Dynamics CRM
Defacto Realations on behalf of Hugo Boss
- Development and bug fixing of SSIS packages for CRM system data loads
- Data selection and enrichment for marketing campaigns
- Enhancement of SSIS packages for data import into the CRM system and data exchange in CSV or XML format
- Data flow between CRM and other systems (SAP)
Languages
German
Native
English
Advanced
Portuguese
Intermediate
Education
Oct 2014 - Jun 2016
ILS
Computer Science
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
Similar Freelancers
Discover other experts with similar qualifications and experience