Recommended expert

Stefan Corsten

SSIS Development

Stefan Corsten
Munich, Germany

Experience

Jun 2024 - Present
1 year 8 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 7 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 7 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 1 month

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.

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
Lorem ipsum dolor sit amet

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

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Stefan Wimmer
Stefan Wimmer

Architect/Software Developer/Infrastructure

View Profile
Joachim Bleichert
Joachim Bleichert

Further development and maintenance of a company-wide monitoring database

View Profile
Kai Pankatz
Kai Pankatz

Oracle Project Management and DBA

View Profile
Ildar Allayarov
Ildar Allayarov

Senior Data Engineer

View Profile
Guino Ndjenndja
Guino Ndjenndja

Senior Data Engineer

View Profile
Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Gurpreet Dhami
Gurpreet Dhami

Digital Finance Consulting – Advanced Data Analysis

View Profile
Yannick Reinke
Yannick Reinke

Power Platform Developer

View Profile
Kerstin Burgen
Kerstin Burgen

Reporting and Analytics for HR

View Profile
Christian Hacker
Christian Hacker

Qualifications Profile

View Profile
Ben Spouse
Ben Spouse

Data Engineer/ ETL Developer

View Profile
Guido Schedlbauer
Guido Schedlbauer

Senior Software Developer

View Profile
Philipp Grunert
Philipp Grunert

Data Scientist & Data Engineer

View Profile
Ernst Höfler
Ernst Höfler

Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD

View Profile
Christian Schulz
Christian Schulz

Data-Scientist/AI Engineer

View Profile
Reinhold Schätz
Reinhold Schätz

Senior Software Developer

View Profile
Serge Kalinin
Serge Kalinin

MLOps (machine learning operations)

View Profile
Frank Eppink
Frank Eppink

DevOps

View Profile
Hicham Mokhtari
Hicham Mokhtari

Freelance Software Developer

View Profile
Rodrigo Herrán
Rodrigo Herrán

Data Engineer

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Tim Safarowsky
Tim Safarowsky

Freelance Business Intelligence Consultant

View Profile
Stephan Martin
Stephan Martin

Sabbatical, professional development

View Profile
Steffen Pollin
Steffen Pollin

Senior SAP BI Consultant

View Profile
Anton Klonov
Anton Klonov

Head of Technical Overall Integration NSC / Hadoop Cloud Development

View Profile
Stephan Sahm
Stephan Sahm

Senior Data/ML Consultant & Technical Lead

View Profile
Vitali Haberkorn
Vitali Haberkorn

Power BI Expert

View Profile
Michael Pförringer
Michael Pförringer

Setup Azure cloud, Java development, CI/CD pipelines

View Profile
Ashkan Zadeh
Ashkan Zadeh

Microsoft Azure Senior Data Engineer / Senior Data Scientist

View Profile
Markus Groh
Markus Groh

Data Solution Architect, Founder

View Profile