MySQL Experts in Essen

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

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

• Cross-departmental collaboration with other teams on operations and further development, and reporting.

• Firewall vulnerability analysis.

• Firewall access requests.

• Troubleshooting IP communication issues on network and firewall infrastructure.

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

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

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

• Designed and developed a production-ready data platform based on Microsoft Fabric for an e-commerce company
• Built a scalable Medallion Architecture (Bronze, Silver, Gold) with Lakehouse and Delta Lake as the foundation for analytics and AI applications
• Developed a metadata-driven ETL platform with PySpark and a generic Incremental Loading Framework (SQL Server → Bronze → Silver → Gold)
• Developed reusable components for Microsoft Fabric Notebooks to standardize data integration, transformation, and validation
• Implemented automated data pipelines including monitoring, logging, error handling, and Delta MERGE strategies for stable production operations
• Built a business layer architecture for reporting, data warehousing, and reusable data products
• Integrated heterogeneous data sources via SQL Server, REST APIs, Amazon SP API, and Google Analytics 4
• Worked closely with business departments to analyze business requirements and translate them into scalable data architectures

Technologies: Microsoft Fabric, PySpark, Python, SQL Server, Delta Lake, Lakehouse, OneLake, Data Factory, Data Warehouse, REST APIs, Amazon SP-API, Google Analytics 4

• QA Lead for end-to-end quality assurance of the Sparkasse & Sparkasse Business banking apps (iOS/Android); design and implementation of the Test Strategy including functional testing, regression testing, and UAT for eID, Push Notifications, and white-label components
• Creation and maintenance of test concepts and test plans in TestRail; structured Defect Management and error analysis; stakeholder management and risk management for the early identification of critical quality risks
• Accessibility Testing according to WCAG 2.1 (iOS/Android); coordination of AI-supported test automation and optimization of test processes to shorten release cycles
• Release Management: planning, management, and coordination of all test activities; status reporting to management and stakeholders; quality assessment of releases and release recommendations in an Agile/Scrum environment
• Challenge: Highly complex build and release process across several Sparkasse institutions; close coordination with the DevOps team to stabilize the CI/CD pipeline and ensure reproducible test builds before every release.

Tools: Jira, Confluence, TestRail, Android Studio, Xcode, Firebase, Jenkins, GA4

• Success: Successful launch of the eID authentication process - quality assurance ensured for 50+ Sparkasse institutions

• Created data pipelines and visualization tools to support sustainable energy decision-making
• Developed insights that could optimize renewable energy deployment and grid integration strategies

Gronic Ident & Sign

Core technologies: Android, Jetpack Compose, Retrofit, Regula Document Reader, Adobe Sign

Android app on dedicated devices for identifications and electronic signatures at the PoS

• Training AI models, evaluating images and text UI/UX, turning the provided data into insights through OpenAI Feather as part of the machine learning workflow

Technologies: OpenAI Feather

• Development of Power BI reports, measures, and KPIs for sales, purchasing, materials management, warehousing, and production
• Analysis of the proALPHA database (Progress OpenEdge) and high-performance SQL queries for extraction and transformation
• Data models, ETL processes, and pipelines including automated refresh via Power BI Service and Data Gateway
• Gathering requirements and implementation in close coordination with the specialist departments

Selected projects:

• Sales report: revenue, incoming orders, and order status
• Purchasing report with automated purchase suggestions (Power Automate)
• Monitoring of missing parts for production and materials management
• Production bills of materials on Microsoft Fabric including deployment pipeline (Dev → Prod)
• Forecast comparison report
• Central Power BI apps that bundle all reports by department

Technologies: Power BI, DAX, Power Query (M), SQL, proALPHA, Progress OpenEdge, Microsoft Fabric, Power Automate, Python

(Maternity/Parental Leave: July 2023 – Aug 2024)

• Domain: Payment Domain | Client: Telefonica Germany
• Project: General Payment Service

The General Payment Service is responsible for processing of online payments via external payment service provider like Safer pay and PayPal

• Developed Design of Use (DOU) and interface contract documentation, ensuring clarity and compliance across system integrations
• Designed and delivered REST/SOAP web services with Spring Boot and Spring Data JPA, publishing Swagger contracts through WSO2 API Gateway to improve accessibility and governance.
• Spearheaded the on-premises to AWS Cloud migration, re-platforming from Oracle to PostgreSQL on AWS RDS and deploying services on EC2, improving scalability and cost efficiency.
• Containerized microservices using Docker and orchestrated deployments with Kubernetes, streamlining deployment pipelines and improving system reliability.
• Implemented proactive monitoring and logging via AWS CloudWatch and Kibana, ensuring stability and performance during cutover.
• Enhanced collaboration through code reviews and peer reviews, promoting maintainability and clean coding standards.
• Strengthened quality by writing comprehensive JUnit tests and preparing detailed test cases enabling early defect detection
• Delivered automated API testing with Ready API, Postman, and SOAPUI, and conducted performance testing with JMeter, ensuring reliability in high-transaction environments.

• Expansion and support of the product portfolio for video analytics and Computer Vision
• Requirements gathering and requirements engineering
• Consulting, project management, and coordination of pilots and the international rollout
• Tools: IP-based camera and video systems, Citrix Administration, OneNote, Microsoft Teams, Node-Red, Office 365, Age Verification, Qognify Umbrella, Thingsboard, Xovis 3D Sensors, AXIS Cameras, GK POS software, Atlassian JIRA

• Design and implementation of a system for controlling the complete process of installing, removing, and replacing electricity meters by external service providers for an energy supplier

• Automated retrieval of orders and available devices through defined interfaces (e.g. from SAP)

• Orchestration of the process steps (assignment of meters, processing of meter data, transfer of updated information back to the source system) through a Spring-Boot backend

• Provision of a React-based web client for operational tracking and control of orders, e.g. to continue failed process steps or resend notifications

• Development and implementation of test concepts for complex, multi-layered systems
• Creation of regular management reports and presentations for stakeholders and clients
• Technical and disciplinary leadership of international test teams (coordination, coaching, resource planning)
• Responsibility for quality assurance across multiple test levels (unit, integration, system, and acceptance tests)
• Design of test cases and test plans in Azure DevOps; ensuring traceability and coverage
• Use of BDD approaches (Gherkin/Cucumber) to prepare test automation
• Building a test automation architecture with Playwright and integrating new tests into CI/CD pipelines
• Performing API tests (REST) and tests for mobile/PWA applications
• Setup and maintenance of test environments across multiple stages (integration, QA, UAT, pre-production)
• Test data management (synthetic and production-like data), ensuring consistency and reproducibility
• Collaboration with DevOps teams for containerization (Docker/OpenShift) and CI/CD integration
• Working under SAFe & Scrum, closely coordinating with product owners and DevOps teams
• Active participation in PI plannings, sprint reviews, and retrospectives
• Promoting an agile QA culture through coaching and knowledge sharing
• Introducing scalable test automation with Playwright → significant reduction of manual testing efforts
• Increasing test transparency through clean defect and reporting management in Azure DevOps
• Improved release quality through an end-to-end QA strategy and automated regression tests
• Strategic leadership of Trikolon Consulting GmbH and responsibility for finance, personnel, and business development

• 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

• 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

• Significantly enhanced user experience and application performance through spearheading the development of frontend components, emphasizing native JavaScript, Vue.js, and UI implementation.
• Ensured efficient data flow and content management by seamless integration of backend APIs (REST) with frontend components and successful connection to CMS Hippo elements.
• Increased sales volume on the customer page through the development and implementation of new components, leading to improved user engagement and conversion rates.
• Worked in an Agile Scrum environment.
• Utilized technologies such as JavaScript, Vue.js, Node.js, Azure DevOps, Azure Functions, Next.js, and more.