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

• 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

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

Technologies: Informatica IDMC, Databricks

• 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

• 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)

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

• Support for the transition to the provider
• Quality assurance in developing operations manuals
• Operational performance management of the provider

• Enterprise application packaging and deployment for Allianz's global Windows migration programs across Europe, North America, and APAC
• Migrated hundreds of enterprise applications from Windows 10 VDI to Microsoft Azure Windows 365 (Windows 11)
• Created software packages in MSI/MST, FlexApp, PSADT 3/4, and App-V according to enterprise packaging standards
• Developed an ASP.NET packaging automation platform with MongoDB, SQL Server, SharePoint, and Outlook integration
• Built PowerShell modules for automated quality checks of MSI and FlexApp packages
• Developed a release conflict detection module in PowerShell to identify potential deployment issues before production
• Created WDAC monitoring scripts for automated policy oversight and incident response
• Implemented MSGraph API calls in PowerShell for Azure AD and Intune operations
• Created Citrix oData scripts for historical usage analysis (BYOD, VDI, fat clients)
• Developed an Intune Win32 app 'Do Not Disturb' deployment routine for an optimal user experience
• First point of contact for troubleshooting production incidents with packaged applications
• Coordinated application owner, UAT, and release testing for hundreds of deployments
• Administered Microsoft Intune, Citrix environments, and SQL Server security
• Created and tested WDAC policies in Intune; managed configuration policies and Win32 app deployments
• Primary packaging resource for Allianz France since 2019

• Independent work as a PLC and software specialist focusing on automation and custom machinery
• Programming, modernization, expansion and optimization of production plants with focus on efficiency improvements, 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)
• System integration of external systems such as readers, printers, scales, scanners and cameras, as well as various fieldbus systems (Ethernet, Profinet, Profibus, EtherCAT, CAN bus, RS232, TCP/IP)
• Creation of visualizations and HMI applications with Siemens WinCC flexible, Beckhoff HMI and .NET front-ends
• Design, development and integration of machine vision solutions (Keyence, Cognex, AVS Alfavision, camera systems) in PLC and PC environments
• Design and implementation of process data acquisition 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
• Design and programming of conveyor, testing, assembly, packaging and grinding systems in industries such as automotive, chemical, food, electronics and machinery and plant engineering
• Conducting workshops and training on Siemens TIA-Portal, STEP7 Classic, Beckhoff TwinCAT (including TwinSAFE) as well as topics like 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 requirement analysis through planning, concept development and supplier coordination to commissioning, production support and maintenance

• Design, development, and execution of load and performance tests for the PRISMA project
• Use of Apache Jmeter, Gatling, Apache ActiveMQ, Jms/Tibco Ems, SikuliX, Jython, Amazon AWS, PAN-Client
• Methods: load tests, test automation

• Third-side integration development (REST: Amazon, OpenAI, Etsy, Shopware, Prestashop, etc)

• Performance optimization (Refactoring, SQL analysis)

• LMS development and deployment (Moodle)

• Cloud deployment automation (Amazon, Azure, Gitlab CI/CD, Docker)

• Backend and Frontend development (Laravel, VueJs)

• Collaboration with partner-developers (national and international)

• Shirtigo GmbH

• GRELLARTIG Digital GmbH

• velpTEC edutainment GmbH