Microsoft SQL Server Experts in Essen

• Development of a production-ready Enterprise AI solution for the automated processing of invoices and business documents
• Integration of Azure AI Document Intelligence and LLM technologies into existing business processes
• Development of robust REST APIs for automated document processing and system integration
• Extraction, validation, and storage of structured invoice data in Azure SQL as a base for analytics and machine learning models
• Development of an AI-based recommendation engine with machine learning and deep learning to generate personalized product recommendations based on historical purchase data
• Implementation of logging, monitoring, error handling, and validation mechanisms for stable production use
• Collaboration with business teams to define business rules and integrate the solution into existing enterprise processes

Technologies: Python, Azure AI Document Intelligence, Azure OpenAI, Azure SQL Database, REST APIs, Machine Learning, Deep Learning, OCR, Pandas, JSON, Workflow Automation

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Strategic transition into AI Engineering through intensive mentoring and project execution.

• Developed MASX AI, an agentic AI platform integrating LangGraph, AutoGen, and RAG for geopolitical forecasting and real-time ETL.

• Designed and delivered functional AI prototypes for prospective clients showcasing applied expertise in multi-agent systems, real-time data pipelines, and LLM integrations.

• 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

• Designed and implemented an automation test framework using Junit and Maven, developing BDD scripts with Cucumber and reusable methods for application behavior.
• Created test data using automation scripts with Selenium WebDriver, Java, and Python, validating UI components, popup windows, and mouse movements.
• Conducted API functional testing of RESTful web services using Postman.
• Automated test execution using Maven and integrated with Jenkins, achieving a 20% reduction in regression testing time.

• Project Livebash (2021-12-01–2023-12-31)

• Development and design of the core system

• Code reviews

• Developer management

• CI/CD

• Client communication

• Leading epics

• Speaking at conferences

• Managing the production system

• Interviewing project developers

• Outcome: production system

• Technologies and tools: Java 11, Java 17, Kotlin, Spring Boot, TeamCity, Gradle, AWS DynamoDB, JUnit, Mockito, Docker, Docker Compose, AWS SQS, AWS EC2, AWS S3, AWS MediaLive, Ethereum, Postman

• Project Robinhood (2024-01-01–2024-05-31)

• Customization and development of product features for specific clients

• Interviews with project developers

• Technologies and tools: Java 17, Java RX, Kotlin, Spring Boot, TeamCity, Gradle, JUnit, Mockito, Docker, Docker Compose, PostgreSQL

• Projects Sway, Tickmill, Pepperstone, UCapital (2024-06-01–present)

• Customization and development of product features for specific clients

• Bug fixes

• Porting tickets from the product

• Feature development

• Technologies and tools: Java 17, Java RX, Kotlin, Spring Boot, TeamCity, Gradle, JUnit, Mockito, Docker, Docker Compose, PostgreSQL