Recommended expert
Stefan Corsten
SSIS Development
Experience
Jun 2024 - Present
1 year 8 monthsMunich, 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 monthsMunich, 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 monthsHamburg, 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 monthMDM 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 monthsWiesbaden, 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 monthsHanover, 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 monthsLudwigshafen, 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 monthsHamburg, 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 monthErlangen, 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 monthsBonn, 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 monthsWiesbaden, 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 monthsDü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 monthsMunich, 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 yearsNuremberg, 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 monthsMunich, 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 monthsMunich, 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 monthsBonn, 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 monthsWiesbaden, 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 monthsWermelskirchen, 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 monthsTroisdorf, 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 monthsBielefeld, 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 monthsTroisdorf, 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 monthsNuremberg, 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 yearNuremberg, 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 monthsWiesbaden, 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 monthsBonn, 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 monthsKaarst, 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 monthNuremberg, 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 monthsMunich, 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 monthsDevelopment 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 monthsRatingen, 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 monthsRatingen, 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 monthsMö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 monthDü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 monthsInstallation 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 monthWiesbaden, 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 monthsNetwork 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 monthsWolfsburg, 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 monthsStuttgart, 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 monthsSoftware 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 monthData 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 monthIT 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 monthsDeveloping 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
NativeEnglish
AdvancedPortuguese
AdvancedEducation
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