Microsoft SQL Server 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

• Setting architectural standards for Informatica Power Center development teams
• Maintenance-performance-health for DWH (Exadata) environments
• Qlik Sense / BO reports architectural standards
• Implementing best practices in ETL tasks
• Documentation ETL standards on Confluence
• Dynamic Data Masking rules for GDPR/KVKK regulations by using Informatica DDM tool
• DWH Data model Power Designer
• Upgrade Qlik Sense versions
• Merge all Informatica server's repository databases on one Oracle DB

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

• 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

• Company FROX (Schweiz), end customer: Bundesamt für Informatik und Telekommunikation.
• Consulting and development. ITSM Suite, development of a semi-generic REST API interface solution. Performance tuning.

• Support with the transition to the provider
• Quality assurance during the preparation of operating manuals
• Operational performance management of the provider

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

• 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

• 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

• Manage WordPress websites, ensuring SEO-friendly structures and high-performance functionality
• Create and optimize Google Ads campaigns, leveraging data to enhance conversion rates and ROI
• Develop Looker Studio & Power BI dashboards to track customer behavior, sales trends, and digital performance
• Implement Google Tag Manager (GTM) and Google Analytics (GA4) to enable precise event tracking and reporting

• 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

• Support in restructuring and designing the group's internal Android apps
• Defining essential modules and implementing accessible components
• Establishing agile approaches at an international level
• Technologies & Methods: Kotlin, Android, JUnit 5, Koin, Azure DevOps, Android Studio, Git, Jetpack Compose, Coil, Flow API, Ktor, Coroutines, TypeScript, Node.js