Microsoft Visio Experts in Essen

• Transition of Microsoft Azure operations to BTC AG
• Responsibility: budget of €60k
• Staff: leadership of 5 people
• Tools: Office 365, JIRA, Confluence

• Optimization of the transmission media of the data links in the Ruhr area
• Configuration/expansion of switches and routers for an autonomous system AS
• Improve the network protocols used Layer 2/3 (OSI model), RSTP, broadcast, etc.
• Laying cables, crimping, antennas, routers, switches
• Maintenance, expansion, selection and prioritization of troubleshooting measures for network monitoring (PRTG, The Dude)
• Organization and new connection of another BGP peering, data center, NGN fiber optic
• VPN IPSec site connections for 6 sites with PFSense, Fritzbox
• Configuration of WLAN devices (Mikrotik, UBNT

Label: TCP/IP, VLAN, BGP, OSPF, MPLS, VPLS, routing protocols, WLAN, EoIP, PPPoE, routing, SNMP, DHCP, DNS, NAT, native IP, VLAN, Ethernet, VoIP., switches and routers from: Nortel, Cisco, MikroTik, UBNT., network management systems: The Dude, PRTG, UISP

• Developed an IT governance and oversight framework aligned with DORA requirements
• Coordinated and trained external service providers
• Optimized financial processes and performance

• The goal of Afworki GmbH IT-Consulting is to make small and medium-sized companies more competitive by overcoming challenges in digitalization, automation, and data management.

• Tailored technology, strategy, and specialist consulting designed to meet the individual needs of each company.

• Analyzing the company's current situation and developing the best possible solution together with the client.

• Using both agile and classical IT project management methods to deliver projects on time and within budget.

• Focusing on automating and orchestrating all data flows in a data warehouse to create a unified and standardized data foundation.

• Considering the dependencies between IT and business to achieve sustainable positive effects.

• Employing modern strategies and tools specifically tailored to the company's needs.

• Supporting digitalization, the introduction of agile working methods, and the creation of up-to-date reports and analyses.

• Objective: streamlining management and enabling well-founded, data-driven decision-making.

• Led the subproject for implementing Vulnerability Response as part of DORA
• Documented the current processes in compliance, risk & security
• Created the functional design for introducing application, infrastructure, and cloud vulnerabilities
• Agile management of the integration service provider, the technical department, and the company's cross-functional teams
• Integrated the V scanners Tenable, Qualys and Defender, as well as NVD and CISA/KEV
• Integrated GitLab Ultimate for importing and processing SBOMs
• Developed automation rules to match scan results with CIs in the CMDB, assign vulnerabilities and remediation tasks, handle approvals (false positives, exceptions) and closures
• Calculated multiple risk scores and priorities
• Defined dashboards and reports (Workspaces, Performance Analytics)
• Aligned the new processes, especially to improve the CMDB data quality (according to CSDM)

• Operational and financial support for the start-up build of a medical care center brand in Germany with 11–25 planned locations
• Designing a scalable site rollout model including a standardized ramp-up (go-live, capacity, FTE plan, revenue/cost projections)
• Developing an operating model and making TCO/make-or-buy decisions
• Building site business cases (revenue mix, cost structure, break-even, sensitivities) to prioritize the expansion pipeline
• Setting up liquidity and financing planning, including deriving funding requirements
• Establishing a reporting structure for transparency on performance and scaling progress
• Implementing budgeting and forecasting (rolling forecast, scenario analyses) for operational control of the medical care center build
• Standardizing employment contract templates and supporting the hiring setup

• Architecting and developing SaaS platform for graphical definition and execution of pandas data processing pipelines
• Developed POlyglott, an open-source Python CLI tool for translation workflow management featuring PO file parsing, quality linting with glossary enforcement, and DeepL API integration for machine translation
• Developed web application for material compliance management (EU REACH) using Django and modern web technologies
• Built automated infrastructure platform using Proxmox, Terraform, and Ansible — VM provisioning, configuration management, internal DNS, and fleet-wide security hardening across multiple subnets

• Provided expert level consulting for lifecycle, upgrades and refresh activities
• Used Remedy for effort recording and billing to customers
• Used ServiceNow for service management and workflow
• Used Jira for project management with agile/Scrum methods
• Used Confluence for documentation
• Worked with customer-specific software tools
• Worked with customer-provided and secured hardware suitable for IT security operations infrastructure setup for customers
• Built firewall rule sets and handed over to service owner and delivery teams
• Environment: Cisco ASA, Cisco Firepower, CSM, Cisco AnyConnect, Cisco ISE, Check Point VSX and gateways

• SD-WAN solution by Aruba – Swiss energy company (330 sites): design and implementation of an SD-WAN branch solution with Aruba 9004 gateways, encrypted overlay, policy-based routing, WAN load balancing, and centralized management via Aruba Central.
• LAN/WLAN & security – schools in Germany (9 sites): deployment of Aruba switches & AP-505, FortiGate 80F firewalls; setup of Checkmk monitoring, incident and change management, and secure admin access (BeyondTrust).
• Multi-site security – energy billing company (20 sites): deployment of a complete Fortinet solution (FortiGate HA cluster, FortiSwitch PoE, FortiAP), IPsec remote-access VPN via FortiClient, centralized management via FortiCloud, IntraID authentication, operations and incident management.
• Data center migration – German client: migration of data center switches (Mellanox), firewall cluster, and OfficeConnect switches to a new data center; securing configurations, implementing HA designs, testing, monitoring, and coordinated change and incident processes. Setup of two new 6300 M VSX clustered switches.
• Data center security – university hospital: implementation of a high-availability FortiGate 400F firewall cluster across three data centers; security policy design, operational support, and change/incident management.
• Enterprise campus & network access control – manufacturing company in Germany: introduction of Aruba ClearPass NAC, setup of a VSX-based switching architecture, secure WLAN access with MPSK, and integration into existing networks.
• EU client (Germany & Poland) – Sophos firewalls: operations, incident and change management of Sophos firewalls including IPsec VPN; troubleshooting and ongoing optimization of security configurations.
• Network modernization – pharmacy client in Germany: design and rollout of core and access switching (Mellanox, Aruba Instant On), migration from Sophos to Fortinet firewalls, network segmentation, and security hardening.

• Plan and design complex production systems as part of a team
• Develop and modify electrical circuit diagrams
• Design electrical machine controls and drive technology
• Troubleshoot electronic assemblies
• Develop PLC and visualization software as well as process control software
• Identify and implement optimization measures
• Create operating instructions
• Ensure IT security of all operational technology
• Support building services
• Technologies: Eplan P8, PCS7, ProLeiT, PlantiT, TIA, S7

• Design of requirement verification based on the INVEST principle
• Implementation of the prediction model with scikit-learn and BERT
• Implementation of the web client with ReactJS and FastAPI
• Adaptation of the T5 model to improve user story generation according to the INVEST framework
• Certification of NLP and scikit-learn
• Technologies: Python, NLP, Scikit-Learn, BERT, T5, ReactJS, FastAPI, Cursor Visual Paradigm, Visual Studio, Draw.io, NSIS, vite, Electron

• Contract negotiations with Infor
• Implementation of Infor LN Cloud "Finance" in 10 countries in Europe within 6 months
• Implementation (ongoing) of materials management, purchasing and sales in 16 countries worldwide

• SAP Basis operations for complex SAP system landscapes (ABAP and Java stacks)
• Administration, monitoring, and optimization of SAP systems with regard to availability, performance, and stability
• Planning and execution of data center moves as well as migrations of SAP systems and databases
• Handling of incidents, changes, and problems according to ITIL processes, including root cause analyses
• Creation of technical concepts, operations documentation, and implementation plans

Technologies: SAP NetWeaver, ITIL processes, technical migrations

• Creating the functional specification for a dashboard solution for E2E management in the 5G deployment team in an Open RAN architecture
• Developing dashboards and reports with Power BI Desktop (data connection using Power Query, KPI calculations with DAX, publishing to Power BI Service)
• Developing solutions with Power Apps
• Integrating Power BI reports into Dynamics 365 Business Central