SQL 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

• Established a cyber resilience framework for AI-accelerated threats in the Frontier AI Threat Endurance (FATE) program: capability assessments, maturity assessments and gap analyses covering cyber security, operational resilience, incident response, recovery and governance, followed by target concepts and improvement measures
• Supported action owners from specification through implementation: implementation roadmaps, decision papers, management presentations and governance reporting, as well as audit- and supervision-ready documentation; managed stakeholders from IT, Information Security, Risk Management, Operational Resilience, Business Continuity and the business units

• 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

• 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

Tools: Fabric, AWS, dbt, Power BI, SQL, DWH, R, Python

• Supported customers in implementing an architecture design for extracting and preparing data
• Planned the design and implementation of the BI and DWH platform
• Ensured the scalability and performance of the data platform

• 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

• Title: Enhancing Syntactic Awareness in Transformer Language Models for Hindi Dependency Parsing
• Investigated syntactic knowledge captured by transformer language models (RoBERTa, XLM-RoBERTa) for Hindi dependency parsing, a morphologically rich and low-resource language.
• Developed structure-aware model variants (Struct_Roberta_hi, Struct_XLMR) by integrating a CNN-based parser network between transformer layers, inspired by the StructFormer architecture.
• Conducted extensive error analysis including label-wise, distance-based, direction-based, sentence length-based, and LVC/Non-LVC evaluations.
• Evaluated models on downstream NLP tasks (NER, POS tagging) using the IndicXTREME benchmark.

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

• AI-Enabled Analytics & Reporting: Lead a 2-person BI team, applying predictive analytics and automation to translate complex business requirements into forward-looking insights, recommendations, and financial reports.
• Advanced Data Visualization: Design and maintain 25+ high-impact Power BI/Tableau dashboards tracking company-wide KPIs and trends, structured to support predictive and automated reporting.
• Web Analytics & Insights: Own GA4 tracking and analysis, driving a 15% increase in conversion insight through deeper customer journey analysis.
• Data Pipeline Optimization: Partner with data engineers to redesign and automate data pipeline workflows, cutting manual reporting time by 20% while safeguarding data accuracy and system uptime.

• Frontend development
• Spring Boot
• Swagger
• Git
• GitLab
• SonarQube
• Docker
• Maven
• Java
• Angular

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