PowerShell Experts in Frankfurt

Europe-wide re-platforming & centralization

• Independently created the migration concept and implementation plan for the Europe-wide centralization and consolidation of IT services for around 20 European companies as part of a re-platforming program.
• Migration assessment: analysis of the existing IT, infrastructure, application, and service landscapes of the companies as the basis for the migration strategy.
• Development of the centralized target vision and target architecture based on a modern technology stack, taking platform and containerization approaches into account.
• Design of a highly available central infrastructure in an active-active model across two data centers; consideration of cloud, infrastructure, application, CMDB, and IAM services.
• Development of the migration and transformation roadmap, including defining migration waves, dependencies, requirements, and priorities for the move from decentralized services to the central platform.
• Analysis of technical and organizational dependencies, identification of migration risks, and development of a structured approach for step-by-step migration and centralization.
• Creation of target, solution, and implementation views for each service domain; design of the end-to-end join-move-leave process as a blueprint for the European rollout (Jira/Jira Asset Management).
• Alignment of migration strategy and roadmap with European companies, management, IT, providers, and other stakeholders; presentation of the 12-month roadmap to the Managing Director Europe.

• Error analysis and fixes including performance optimization of the in-house developed platform API
• Change and incident management in day-to-day operations
• Responsible for compliance with security and compliance requirements
• Vendor management for software development and maintenance
• Planning and execution of migration of legacy services to a cloud native platform

Role in the project: project staff, implementation team

Used skills: requirements analysis, IT service and application management, IT operations, error analysis and performance optimization, software maintenance and lifecycle management

Project environment: Cloud Native Platform (Kubernetes, Crossplane, AWS, ArgoCD, Grafana)

• Devised a new Domain-Driven Design architecture for a core system: reverse-engineered a central component, refactored the data-access layer to minimise database round-trips (improving scalability) and migrated processing to async.
• Decomposed the platform into independent .NET Core microservices (database-per-service) with RabbitMQ pub/sub using the Outbox Pattern + Saga choreography, behind an Ocelot API Gateway (JWT, rate limiting, CORS, health checks).
• Delivered on .NET Core / Angular / SQL Server / EF Core with Docker and Azure DevOps CI/CD; implemented health checks and CORS; contributes technical designs for stories in agile Scrum.
• Sole ADR owner; mentored 3 engineers and presented architecture decisions directly to the Director of Corporate IT.

• Consulting and creation of various web applications based on SharePoint and the React framework for different clients
• Development and testing of accessible apps for SharePoint
• Creation of various test cases for test automation
• Development of various solutions based on Azure
• Creation of various web services based on .NET
• Development of various SharePoint Framework solutions
• Development of various UI solutions based on SharePoint
• Consulting and creation of various Power Apps applications and Power Automate for the steel industry and an IT consulting company
• Support, consulting, and development with offshore teams for SharePoint 2013, 2016, and microservices for a logistics company
• Consulting, concept design, and development of microservices and web applications based on Microsoft technology and the React framework for a logistics company
• Consulting, concept design, and development of various SharePoint Framework solutions on SharePoint 2016 for logistics
• Consulting for the migration from SharePoint 2010 to 2016 for an IT consulting company

• Creation of construction schedules and standard plans.
• Preparation and submission of traffic control orders (VRO) and RSA-compliant plans.
• Application for and documentation of all permits, including excavation permits and water permits.
• Carrying out and documenting site inspections.
• Maintaining digital site diaries.
• Coordinating and selecting subcontractor crews.
• Checking and approving measurements.
• Ensuring compliance with all technical requirements and standards.
• Summarizing and passing on operator rules to the subcontractors.

• Introducing 5 different process applications for various teams

• Release planning: scope and time management

• Resource/capacity planning

• Conducting sprint planning / retrospectives

• Increment planning (multiple sprints)

• Preparing steering committee meetings / reporting to the executive board

• Coordinating / aligning with external suppliers / deliveries

• Multi-project resource planning

• Aligning with the business unit and development team

• Identifying best practices with IBM BAW

• Cost control and planning for the project team and external service providers

• Collecting KPIs using LogScale

• Analyzing application errors with LogScale / queries

• Defining user stories / aligning requirements with the business unit and development team

• Testing and defect tracking

• UI/UX design of the application

• Preparing and facilitating brown-paper workshop

• Test concept, test data, test organization, test execution

• Recording team velocity / metrics

• Executing tests

• Scripts for automated testing

• Organizing tests with the business unit and IT

• Recording and prioritizing defects

• Setting up and operating the application

• Setting up application monitoring with LogScale dashboards

• Checking health endpoints with PowerShell

• Post mortem analysis

• Setting up incident management

• Setting up problem management

• Analyzing errors using LogScale queries and dashboard

• Pre-processing data for AI

• Conducting evaluation with AI language models (Meta Llama 3.3 LLM and deepset Haystack) and RAG

• Installing runtime environments for LLMs (large language model)

• Evaluating various LLMs

• Installing RAG (retrieval augmented generation) and integrating with LLM

• Extracting unstructured data with LLM and RAG

• Project based on IBM BAW (Business Automation Workflow), WebSphere Liberty, Domea, d.3, REST, LogScale (formerly Humio), Swagger, PowerShell, JIRA, Confluence, Lucom Interaction Platform (LIP), Mattermost, Jabber

• Datastage 11.7, dbt, Oracle 19, Python 3.12 / PySpark 3.5, Azure GitHub, Azure DevOps, Automic
• Development of migration jobs to transfer data from the collection DWH to the new Risk Mart, as well as development of ETL pipelines to migrate historical data from the old Mart to the new Risk Mart.
• Storage of the silver layer on Hadoop and the gold layer in Oracle.
• Translation of DataStage jobs into dbt to publish reporting data in Google Cloud to a PostgreSQL database.
• Creation and optimization of complex SQL queries for data extraction from a data vault, taking into account historical data in the point-in-time tables.
• Creation of Oracle table definitions (DDL) and adjustment of existing stored procedures.
• Versioning changes in GitHub and deployment via the CI/CD portal.
• Refactoring long-running DataStage jobs into Python using PySpark to reduce server load.
• Migration of SAS scripts to PL/SQL, including new development of distribution functions that have no direct equivalent in Oracle.
• Development of Automic jobs to run DataStage pipelines and Python scripts (PySpark jobs) that control the population of the SME and institutional risk tables in the Risk Mart and perform business calculations.
• Participation in the agile process, including creating user stories, estimations, and planning in Azure DevOps.
• Handling Azure DevOps tickets and close collaboration with testers and business teams for error analysis and resolution.

• Testing the SekIDP and related components
• Test design, execution and automation, microservices, GitHub Enterprise, Eclipse, Katalon Test Platform, API Testing, Confluence 8, JIRA/Xray, Draw.io, Swagger/OpenAPI, Postman, Docker, Kubernetes, Podman, PuTTY, E-Health, Telematik, Gematik standards, EPA, E-Rezept, sektoraler IDP, encryption, XaDES, PaDES, DICOM, HL7, FHIR, IHE, ICD, SSO, SAML/Shibboleth, OAuth, smartcards, JWT, two factor authentication Android and iOS, Wireshark, BrowserStack, Cypress, gRPC, REST, SOAP, WS-Security, Linux Shell, PowerShell, SSH/SSL, Java, Kotlin, Cordova, Gradle, Groovy, Python, TypeScript

• User account management and creation in Active Directory
• Group management and modification in Active Directory
• Permission management on file servers
• Exchange/Outlook support
• VPN setup
• System and product support: Windows 10, Windows 11, Office 2019, Office 365, Active Directory, TeamViewer, RSA VPN, Microsoft Teams, RSA Security Console, Deep Discovery Mail Inspector, ServiceNow, Macmon

• Requirements analysis for the enterprise-wide observability platform.
• Creation of playbooks and pipelines for rolling out Envoy, OpenTelemetry Collectors, and OpenTelemetry Agents.
• Conducting load tests for capacity planning of metrics for the observability platform.
• Documentation and implementation of compliance standards for production readiness.
• Creation and design of RED metrics, spanmetrics, JBoss, and Tomcat dashboards for mission-critical applications.
• Setting up alerts for critical applications for proactive incident response.
• Integration of OpenShift applications into the enterprise-wide observability stack.

• Conducting and analyzing web analytics
• Creating and editing tags and scripts in tag management as well as banners and other client-side web elements in consent management
• Technologies used in development: Tealium, JavaScript, IntelliJ, Git, Android Studio, Selenium, Appium, Adobe Analytics, Power Automate, Power App

• Support and optimization of incident, change & problem processes based on ITIL for >10,000 users.
• Problem-solving for >1,000 complex cases/year across different service towers (File Services, Identity, Citrix, ANF).
• Work in the security cluster: vulnerability analysis and firewall change coordination.
• Governance & migration of file services to Azure NetApp Files (M365, Citrix, PowerShell), including data optimization.
• Creation and maintenance of business-critical process & operational services, enterprise documentation.
• Focus on stabilization, security (endpoint hardening), and optimization through AI solutions.

• Interim project manager and requirements engineer in various client projects

• Implementation of complex Azure resources using Terraform IaC and Azure DevSecOps pipelines with network security and zero-trust governance policies

• Optimization of the existing network design, firewall and database migration

• Implementation of governance and network policies as Policy as Code (PaC)

• Establishment of company-wide Azure connectivity using Azure VPN as an IPSec tunnel

• Implementation of hybrid on-premises multi-cloud connectivity (GCP, Azure) using Terraform

• Development of Azure Functions for scheduled cron jobs and Service Bus message queuing with topics

• Optimization of messaging with Service Bus premium features and IP whitelisting

• Stakeholder management, customer communication and creation of Architectural Decision Records (ADR)

• Responsible for cost-efficient quick wins in Azure and on-premises systems