About Joachim
English
Fluent
German
Native or bilingual
Experience
- Stellantis Financial ServicesData Management / BI ArchitectBANKING AND INSURANCEMay 2020 - Today (6 years and 3 months)Rüsselsheim am Main, GermanyVarious 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.
- AccentureSystem ArchitectSOFTWARE PUBLISHINGOctober 2009 - June 2018 (8 years and 9 months)Kaiserslautern, GermanyTechnical 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 OracleSystem Environment:- SQL Server 2008-2014- Oracle 10-11- Windows 2012 - 64 BitTools:- Accenture/CAS 7 - 10- Visual Studio 2008/2012- VB.Net
- MarsSystem ArchitectAGRICULTUREJuly 2018 - March 2019 (9 months)Hagenau, FranceSystem 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), controlledvia 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 consolidationsSystem Environment:- Accenture/CAS ERP System- SQL Server 2014- Windows 2012 - 64 Bit- SAP/Hana, SLTTools:- Visual Studio 2008/2012- T-SQL- Excel
Recommendations
Be the first to recommend Joachim
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Diplom Engineer in Engineering Informatics (University of Applied Sciences)Kaiserslautern University of Applied Sciences1985Numerik, 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".