Microsoft SQL Server Experts in Dusseldorf

• Operation and further development of the network and security infrastructure.

• Monitoring, analysis and resolution of network and security incidents.

• Cross-department collaboration with other specialist teams for operations, further development and reporting.

• Firewall vulnerability analysis.

• Firewall rule approvals.

• Troubleshooting IP communication issues in the network and firewall infrastructure.

• Security-critical IT infrastructure, processing of personal data, compliance with legal regulations.

• Products: Palo Alto Networks Firewalls, Cisco ACI, Checkpoint Firewalls, F5

• Technologies: SDN, SDWAN, Cisco EPIC, Cisco ACI

• Designed and implemented enhancements in SAP BW on HANA 7.5 in the context of CRM migration and S/4HANA and BW/4HANA transformation programs
• Migrated SAPI data sources to the ODP framework as part of the S/4HANA migration
• Delivered SAP ECC data to Snowflake using BW data models and Calculation Views for Power BI analytics
• Integrated SAP and non-SAP data sources (including MS Dynamics)
• Improved reporting transparency through consolidated data models
• Optimized data loading processes for FI-CO data sources, significantly improving load times and system performance

• -- ENGLISH Version (Deutsche Version unten) ---

Experience

• Ex-BCG Platinion: 14 years as Manager & Chief IT Architect, leading large-scale IT transformations in complex group structures
• 20+ years of C-level consulting across AI/IT strategy, enterprise architecture, IT organization, transformation, M&A due diligence, project recovery, and interim management
• IT leadership experience with cross-functional, intercultural teams of up to 100+ people
• Hands-on background in software engineering, IT architecture, and project management
• Fortune Europe 500 focus; numerous international projects; SME and start-up experience

Core services:

• IT strategy, enterprise architecture (EAM), target architectures and roadmaps
• PE/M&A/carve-out IT/tech due diligence, asset valuation, cost estimation
• GenAI transformation, process automation, and AI governance
• IT reorganization, target operating model (TOM), agile transformation
• IT governance, development and ITSM process optimization (BizDevOps, SAFe)
• Review and recovery of critical large-scale IT programs
• Planning and steering of transformation programs and IT project portfolios
• IT vendor and platform selection (RfI / RfP)
• Coaching & Interim management

Industries (selection): Insurance, financial services & banking, energy & utilities, telecommunications, retail & consumer goods, logistics, media, industry & engineering, healthcare, professional services

Projects (selection):

• M&A Buy-side IT/Tech Due Diligence of an Acquisition in the Energy Sector (Utility, Smart Home) — AI-augmented with Anthropic Claude

• AI Initiative for LLM-Based Optimisation and Automation of Sales and Billing Processes

• Interim management Enterprise Architecture & group target architecture/roadmap development (METRO)

• Reorganization: Design and introduction of agile IT target operating model at international wholesale group (METRO)

• Design and implementation of agile BizDevOps target operating model (E.ON Grid Solutions)

• Platform/vendor selection for renewal of core insurance solution of start-up (ELEMENT Insurance)

• Establishment of project assurance capability and review/recovery of critical transformation projects (ERGO)

• Enterprise architecture management and development of divisional/solution architectures (Deutsche Post DHL)

• Strategic pricing architecture decisions in digital sales application landscape (E.ON Energie)

• IT due diligence: Architecture evaluation and monetary valuation of IT assets (ProSiebenSAT.1 Media)

• Interim management of group-wide security/compliance programme (ERGO)

• Enabling an application landscape for different sales organizations and product structures (E.ON Energie)

• Realignment of business/IT strategy and InsurTech platform selection (RfI, RfP) (nexible, ERGO Digital Ventures)

• Stabilization/optimization of an agile/SAFe business/IT DevOps landscape transformation (Lufthansa AirPlus)

• Process optimization and design/management of digitization and robotics introduction in power plants (RWE Nuclear)

• BSS target architecture development for fixed/mobile networks convergence (Deutsche Telekom)

• Optimization of IT organization model and methodology in application development and testing (Deutsche Telekom)

• Evaluation of fulfillment of a general contractor agreement for run-off/migration of contract portfolios (ERGO)

• -- DEUTSCHE Version (English version above) ---

Experience

• Ex-BCG Platinion: 14 years of strategy and implementation of large-scale IT transformations in complex corporate structures (Manager & Chief IT Architect)
• 20+ years of C-level-adjacent IT consulting: IT strategy, enterprise architecture, IT organization, transformation, due diligence, project recovery, and interim management
• IT leadership responsibility for cross-functional, intercultural teams of up to 100+ people
• Solid hands-on experience in software development, IT architecture, and project management
• Focus on Fortune Europe 500, numerous international projects; SME and start-up experience

Industries: insurance · financial services & banking · energy · telecommunications · retail & consumer goods · industry & engineering · logistics · media · healthcare

Services (focus areas):

• IT strategy, enterprise architecture (EAM), IT landscape target visions and roadmaps
• M&A/carve-out IT/tech due diligence, asset valuation, and cost estimation
• GenAI transformation, process automation, and AI governance
• IT reorganization, target operating model (TOM), agile transformation
• IT governance, development and ITSM processes (BizDevOps, SAFe)
• Review and recovery of critical large-scale IT projects
• Planning/steering of transformation programs and IT project portfolios
• IT service provider/platform selection (RfI, RfP)
• IT project management (agile, classic, hybrid)
• Coaching & interim management

Projects (selection):

• M&A buyer-side IT/tech due diligence of an acquisition in the energy sector (utility, smart home) — AI-augmented with Anthropic Claude
• AI initiative for LLM-supported optimization and automation of sales and billing processes
• Interim management of Enterprise Architecture and development of group target architecture in wholesale (METRO)
• Reorganization: design and introduction of an agile IT target operating model (TOM) at an international wholesale group (METRO)
• IT reorganization: introduction of an agile BizDevOps target operating model (TOM) at an energy group (E.ON Grid Solutions)
• Platform selection / vendor selection for renewal of the core insurance solution of a B2B2C start-up (ELEMENT Insurance)
• Process optimization, digitalization, and introduction of robotics in power plants (RWE Nuclear)
• Assessment of fulfillment of a general contractor agreement for run-off/migration of life insurance portfolios (ERGO)
• Business/IT strategy and InsurTech platform selection for a digital insurer/start-up (nexible, ERGO Digital Ventures)
• Enabling an energy application landscape for multiple sales units (E.ON Energie)
• Strategic architecture decisions in price management of a digital sales application landscape at an energy group (E.ON Energie)
• Stabilization/optimization of an agile DevOps IT transformation in business travel and payment management (Lufthansa AirPlus)
• Interim management in a group-wide security and compliance program of a global insurer (ERGO)
• Building project assurance capability as well as review and optimization/recovery of critical IT projects in an insurance group (ERGO)
• Building enterprise architecture management and development of domain and solution architectures for a logistics group (Deutsche Post DHL)
• M&A IT due diligence – evaluation and valuation of IT assets in the media sector (ProSiebenSAT.1 Media)
• Development of BSS target architecture and roadmap for fixed/mobile convergence (Deutsche Telekom)
• Optimization of IT governance/organization and methodology in application development and testing at a telecommunications group (Deutsche Telekom)

• Creating interfaces between the legacy platform and the new container solution
• Coordinating required contributions from line units
• Moderating regular status meetings with the software vendor
• Minimally invasive conversion of TWS scheduling from the old to the new platform
• Environment: IBM Mainframe, DB2, CICS, MQ, Red Hat Linux, Oracle, Kubernetes, Kafka, Helm, GitLab, Jenkins

• Analysis and remediation of security vulnerabilities in a risk assessment system for energy trading
• System analysis
• Threat modeling
• Decision-making on vulnerability mitigation strategies
• Implementation of vulnerability detection mechanisms
• Security scans
• DevSecOps practices
• Technical environment: Visual Studio Code, JetBrains Suite, MS Threat Modeling Tool, DevSecOps, Git, AWS, DynamoDB, SQL Server, Endur, Snowflake, Orca
• Languages: C#, JavaScript, TypeScript, Python, PowerShell, Bash, Terraform, SQL

• DWH modernization
• Migration from Informatica PowerCenter to IDMC/CDI
• Migration from IBM DB2 to Databricks

Technologies: Informatica IDMC, Databricks

• Implemented the BI solution and replaced the old BI landscape
• Led the “Sales Bonus Plan” subproject: expanded the existing solution and migrated to Azure (Databricks)
• Led the “Cognos Migration” subproject: expanded existing data warehouses based on MS technologies (source systems: Oracle), analyzed business requirements and designed the technical solution
• Expanded the relational DWH database
• Developed ETL processes using SSIS
• Developed the multidimensional database (OLAP Cubes/SSAS)

• Self-employed PLC and software specialist focusing on automation and special-purpose machinery
• Programming, modernization, expansion and optimization of production systems, focusing on increased efficiency, data transparency and system integration
• PLC programming and safety with Siemens S7 Classic/TIA Portal, Beckhoff TwinCAT 2/3 and CoDeSys
• Development of high-level language software and database applications (.NET / C#, C++, Visual Basic .NET, Borland/Embarcadero C++)
• Development of custom software solutions for industrial automation, including embedded systems (Raspberry Pi, Arduino, NodeMCU, ESP8266)
• Integration of external systems such as reading devices, printers, scales, scanners and cameras, as well as various bus systems (Ethernet, Profinet, Profibus, EtherCAT, CAN bus, RS232, TCP/IP)
• Creation of visualizations and HMI applications with Siemens WinCC flexible, Beckhoff HMI and .NET frontends
• Planning, development and integration of machine vision solutions (Keyence, Cognex, AVS Alfavision, camera systems) in PLC and PC environments
• Design and implementation of process data collection systems and traceability solutions (100% traceability) based on Microsoft SQL Server (Compact, Express, Server), including stored procedures and direct PLC-SQL communication
• Creation of software and PLC concepts, standard function blocks and project libraries for PLC and high-level language projects
• Planning and programming of conveyor, inspection, assembly, packaging and grinding systems in industries such as automotive, chemical, food, electronics, machinery and systems engineering
• Conducting workshops and training on Siemens TIA Portal, STEP7 Classic, Beckhoff TwinCAT (including TwinSAFE), as well as topics such as architectures, safety, database integration and documentation
• Creation of technical documentation, manuals, training materials and class documentation with Microsoft Office and Doxygen
• Project management tasks from requirements analysis through planning, concept development and supplier coordination to commissioning, production support and customer support

• Supporting several agile teams in the new product development of an enterprise CRM and ERP application
• Web frontend development with Angular 17–21 (microfrontends, Domain-Driven Design, MDB-Bootstrap)
• Backend development with C# and .NET 7–10, MongoDB, MassTransit, RabbitMQ, Entity Framework Core, ElasticSearch (microservices, DDD)
• Technical feature design for assigned tasks
• Technical architecture design including forward-looking planning of AI-supported extension options
• Proof-of-concept implementation of AI-supported workflows with n8n and a locally hosted LLM (Ollama)
• Coordination with stakeholders and Product Owners, support with sprint planning

Result: Delivery of production-ready microservices and frontend modules in agile sprint cycles.

Environment: .NET 7–10 · Angular 17–21 · C# · TypeScript · OpenAPI · Microfrontends · DDD · Kubernetes · Docker · Helm · MS SQL Server · PostgreSQL · MongoDB · MassTransit · RabbitMQ · EF Core · ElasticSearch · Kibana · Azure DevOps · KeyCloak · n8n · Ollama

• Development and maintenance of database-driven applications for managing supplier and food contracts, with extensive use of Oracle PL/SQL for complex business logic and data processing
• Optimization of PL/SQL procedures, functions, and triggers to ensure the performance and scalability of Oracle database solutions
• Ensuring compliance with best practices in PL/SQL development and implementing standards for code quality and data integrity
• Close collaboration with backend and frontend teams to ensure smooth integration between the Oracle database, C#-based APIs, and Azure cloud services

The Helaba ATLAS project aims to modernize core systems and make them future-proof. As part of the subproject, the existing legacy system for international payments is being replaced by a modern web-based application.

• Analysis of functional and technical requirements
• Analysis and optimization of business processes
• Process modeling
• Preparation and facilitation of workshops
• Defining project scope and prioritizing requirements
• Business process management (analysis, modeling, and optimization)
• Specification of user stories
• Designing business and authorization concepts
• Testing and acceptance
• Designing mockups in Figma
• Creating the UI/UX style guide for web applications Approach: Scrum (agile) Technologies: Jira, Confluence, MS Teams, Conceptboard, Java, Vaadin, Figma

• Executed post-carve-out stabilization, system consolidation and cybersecurity uplift. Re-assessed system landscape and assets and designed new IT strategy for future. Implemented new IT operating model focusing on product-centric organization and re-internalization of critical resources.
• Successfully designed new IT operating model of the company, based on massive reduction of external dependencies, insourcing of key positions and upskilling of employees.
• Massive reduction of IT cost in the first three years (-40m$), bringing IT spend level below Gartner industry benchmark (1.27%).
• Introduced new product-centric organization based on fusion teams between business and IT across the company.
• Administered implementation of corporate-wide IT/OT cybersecurity program with more than 60 projects.
• Continuous improvement of enterprise IT/OT cybersecurity maturity level with significant increase in the first two years (CMMI >3.5, C2M2 >2.5).
• Governed successful implementation of the business transformation program within IT area by overachieving the savings target by $8m.
• Initiated and created new cloud-based data management platform based on best-in-class technology.
• Implemented first company-wide Microsoft Copilot AI program based on various business cases, leveraging GenAI and AgenticAI.

• Deriving test cases in IBM DOORS for various devices according to ISTQB
• Automating and running test cases in Python under Linux
• MobaXtrem, Windchill are in use

• Design, installation, configuration, administration, optimization, and further development of IT infrastructures in Citrix environments
• Upgrading older Citrix systems to the latest versions
• Installation, configuration, and delivery of applications in Citrix environments
• Support in 2nd- and 3rd-level support
• Performing performance analyses and optimizations in complex Citrix environments
• Analysis and fixing of issues in complex Citrix systems
• Creating, updating, and maintaining technical documentation
• Troubleshooting slow logons in Citrix XenApp / CVAD environments
• Analysis and fixing of printer problems in Citrix environments
• Creating, maintaining, and optimizing Citrix VDI policies
• Citrix Virtual Apps and Desktops (CVAD) 2402 LTSR, Citrix Virtual Desktop Infrastructure (VDI), Citrix Hypervisor / Citrix XenServer, Citrix Director / Citrix StoreFront, Citrix Machine Creation Services (MCS) / Citrix Provisioning Services (PVS), Citrix App Layering, Citrix Workspace Environment Management (WEM), Citrix Profile Management
• NetScaler SDX 14 / NetScaler Gateway 14 / NetScaler Console 14, NetScaler Load Balancing / Global Server Load Balancing (GSLB), NetScaler Applications Analytics (Web Insights, Security Insights, SSL Insights, TCP Insights, Gateway Insights, HDX Insights, ADC Infrastructure Analytics)
• Design, installation, configuration, management, optimization, and further development of IT infrastructures in Microsoft environments
• Upgrading older Microsoft systems to the latest versions
• Installation, configuration, and delivery of applications in Microsoft environments
• Creating, managing, and optimizing Microsoft Group Policy policies
• Design, implementation, and administration of Microsoft Azure environments
• Windows Server 2022 / Windows 11, Windows Group Policy / Active Directory, Remote Desktop Services (RDS), SQL Server 2022 / SCCM Server, RADIUS Server, FSLogix, PowerShell
• Implementation of standard changes according to ITIL guidelines
• VMWare / Splunk