You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Joachim MutterJM

Joachim Mutter

Senior System Architect - Data Management / BI

€800/day
Maßweiler, DE
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Joachim

Know-how development since 2006 around SQL Server 2005-2016 using T-SQL and VB.Net/C# based client/server systems. Starting from performance optimization, troubleshooting, to the use of SSIS (Integration Services) for data migrations, data interfaces, and ETL processes, up to the design of Data Warehouses/Datamarts using SSAS (Analytics). This business area has been continuously expanded to date, leading to profound knowledge in the analytics field, with the planning and implementation of BI projects oriented towards the concepts of the Kimball Group.
  • English

    Fluent

  • German

    Native or bilingual

Can work on-site
Maßweiler (up to 50km)

Experience

  • Stellantis Financial Services
    Data Management / BI Architect
    BANKING AND INSURANCE
    May 2020 - Today (6 years and 3 months)
    Rüsselsheim am Main, Germany
    Various projects involving new implementations in regulatory reporting, migrations from Oracle to SQL Server, SQL Server version upgrades, server moves (Linux -> Windows).

    Development of a "Strategic Retail Acquisition Platform" datamart in Unified Star Schema. Development of middleware systems (ETL pipelines including raw data cleansing, enrichment via various external service providers (Crefo, InfoLegale)) for supplying the Austrian National Bank (FREX), the Deutsche Bundesbank (BAIS), the French National Bank, and the Swiss ZEK (Central Credit Information Office).
    Further development of these middleware systems, development of auxiliary programs for data analysis and/or additional reports such as payment transaction statistics, encrypted XML response files, etc.
    SQL Server SSIS .NET C# Data Analysis Business Intelligence
  • Accenture
    System Architect
    SOFTWARE PUBLISHING
    October 2009 - June 2018 (8 years and 9 months)
    Kaiserslautern, Germany
    Technical architect for the Promotion Planning CRM (On-Premise) system.
    Functional and technical design, subject matter expert in the database area (SQL Server and Oracle), effort estimation, onboarding of offshore resources, and technical implementation.
    Commissioning of change requests, new markets, operational support, and preparation for further countries.

    Tasks

    • Creation of functional and technical designs
    • Design reviews
    • Time estimations
    • Subject Matter Expert On-Premise Solution
    - Single point of contact for technical/systemic questions
    - Performance Optimization SQL Server and Oracle

    System Environment:
    - SQL Server 2008-2014
    - Oracle 10-11
    - Windows 2012 - 64 Bit

    Tools:
    - Accenture/CAS 7 - 10
    - Visual Studio 2008/2012
    - VB.Net
    Accenture/CAS VB.NET SQL Server Oracle Microsoft Visual Studio
  • Mars
    System Architect
    AGRICULTURE
    July 2018 - March 2019 (9 months)
    Hagenau, France
    System architect for the data export interface from a CRM system to SAP / HANA BI solution.
    Commissioning of new markets, operational support, and preparation for further countries.
    Optimization of the involved processes in the source and transport systems. Analysis of occurring problems in the involved SAP and CRM systems regarding data continuity and consolidation of different systems.

    Tasks

    • Creation of functional interface designs
    • Creation of a system landscape (Stage-DB Server) for decoupled data transport
    • Development of suitable methods for seamless data transport
    - Master data via SQL Server Transactional Replication
    - Operational data via dedicated pull daemon processes (multiple parallel), controlled
    via a custom-developed start/stop/monitor Windows service

    • Single point of contact for
    - CRM-related technical/systemic questions
    - Transport Layer (Masterdata / Operational Data (5-10 GB/day))
    - Data consistency
    - Data consolidations

    System Environment:
    - Accenture/CAS ERP System
    - SQL Server 2014
    - Windows 2012 - 64 Bit
    - SAP/Hana, SLT

    Tools:
    - Visual Studio 2008/2012
    - T-SQL
    - Excel
    Accenture/CAS SQL Server VB.NET Microsoft Visual Studio SAP

Recommendations

Be the first to recommend Joachim

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Diplom Engineer in Engineering Informatics (University of Applied Sciences)
    Kaiserslautern University of Applied Sciences
    1985
    Numerik, Computeralgorithmen im Bereich der Matrizen Arithmetik, Approximation , Interpolation Mikroprozessortechnik, allgemeine Assemblerprogrammierung, Programmierung von Mikrocontrollersystemen mit Emulatoren und Realtime-Processing Systemen. Analoge und digitale Reglungstechnik, Steuerungstechnik Theorie der Simulation linearer Differentialgleichungssysteme, praktische Erfahrungen durch eine Semesterarbeit "Optimale Reglung von Totzeit behafteten Systemen höherer Ordnung".

Skill set

Categories