Visual Studio Experts in Düsseldorf

• Analysis and remediation of security vulnerabilities in a risk assessment system for energy trading
• System analysis
• Threat modeling
• Decision-making on vulnerability mitigation strategies
• Implementation of vulnerability detection mechanisms
• Security scans
• DevSecOps practices
• Technical environment: Visual Studio Code, JetBrains Suite, MS Threat Modeling Tool, DevSecOps, Git, AWS, DynamoDB, SQL Server, Endur, Snowflake, Orca
• Languages: C#, JavaScript, TypeScript, Python, PowerShell, Bash, Terraform, SQL

AI Strategy & Enablement for SMEs Management consulting – SMEs (e.g. marketing boutique, IT & office services)

Concept and delivery of structured AI introduction and strategy workshops for small and medium-sized businesses. Result: Practical AI status assessment, prioritized use case list, and management decision template as the basis for the next steps in the company’s AI development.

Activities

• Needs analysis and individual preparation of the consulting formats
• Facilitation of a structured AI status assessment including vision, mission, and target picture
• Identification and prioritization of relevant AI use cases and action fields
• Creation of management decision templates and roadmaps
• Raising awareness for opportunities, risks, and success factors of AI introduction
• Support for first customers with AI-supported automation scenarios
• Supporting people and teams through the change process of AI introduction (CM)

Methods / Tools / Technologies

Methods:

• AI status assessment & use case analysis
• Workshop moderation / facilitation
• Requirement Management
• Change Management (PROSCI)

Tools:

• Generative AI tools (e.g. ChatGPT, Claude)
• Automation/AI coding tools (e.g. n8n, Claude Code, Visual Studio, Antigravity)

Technologies:

• Prompt engineering
• AI workflow automation

• Migration of a .NET Core loyalty program for Snipes, used by mobile cash registers in Snipes stores
• Part of the customer’s digitalization strategy in an agile, cross-functional team with a high level of ownership
• Connecting interfaces to third-party systems (e.g. Brandung, CDS)
• Quality assurance through automated tests
• Carrying out developer, unit, and integration tests
• Patterns & methods used: Clean Code, microservice architecture, agile development with SCRUM
• Technologies & tools used: Spring Boot, Java 23, Java Persistence API (JPA), Azure DevOps, Azure Key Vault, Azure PostgreSQL, Docker & Kubernetes, Git, Graylog, Grafana, JUnit, SonarQube, Jira, Confluence, Prometheus, GitLab, GitLab CI/CD, Visual Studio Code

• Development and maintenance of database-driven applications for managing supplier and food contracts, using Oracle PL/SQL extensively for complex business logic and data processing
• Optimization of PL/SQL procedures, functions, and triggers to ensure the performance and scalability of Oracle database solutions
• Ensuring adherence to best practices in PL/SQL development and implementing standards for code quality and data integrity
• Close collaboration with backend and frontend teams to ensure seamless integration between the Oracle database, C#-based APIs, and Azure cloud services

• Design and implementation of an OCI-based data warehouse and ETL system to replace legacy mainframe applications
• Developed a database optimization strategy and planned the rapid conversion of JCL and COBOL routines to PL/SQL using AI
• Developed an Oracle Apex-based app for internal administrative processes in the public sector (office equipment, staff training)
• Implemented PL/SQL workflows for approval processes and created a responsive mobile version with JavaScript and CSS
• Used Azure DevOps for backlog management and documentation, and Git for version control
• Developed REST interfaces to CRM systems
• Replaced and reprogrammed Oracle Forms screens with Oracle Apex and updated to the latest Apex versions
• Designed a Git branching strategy and conducted code reviews
• Maintained and further developed an EDI-based data exchange system based on Oracle Advanced Queuing for the public sector in Austria
• Performed data analysis and created charts in the Oracle Apex frontend; installed standalone ORDS and Apex 23.1
• Worked agile using the Spotify model; developed complex Apex pages with support from Oracle JET
• Rebuilt and customized existing PL/SQL packages, created workarounds for database version differences, and optimized queries
• Developed Apex applications for broker pools to manage and optimize Oracle databases in the banking environment, including SSO-based authorization systems with OAuth2 and Keycloak
• Built extensive Oracle Apex applications for BI and data mining modernization projects and developed manual and automated projection methods in the frontend
• Carried out data warehousing projects in the banking sector and used Scrum and Kanban in team projects

• Project: Migration of large data sets
• Result: ETL route development with AWS Glue and Talend Open Studio

• Redesign of the 'Hessian Platform for Migration and Refugees'
• Technologies: C#, .NET 8.0, ASP.NET WebAPI, Blazor
• Architecture principles: Domain Driven Design, Mediator Pattern, Outbox Pattern, IOSP, Clean Code
• Methodologies: SCRUM, Coaching, Team Lead

• Implement the BI solution and replace the old BI landscape
• Sub-project lead for Sales Bonus Plan: Extend the existing solution and migrate to Azure
• Sub-project lead for Cognos migration: Expand the existing data warehouse based on MS technologies
• Analyze business requirements and create the technical solution
• Expand the relational DWH database
• Develop the ETL processes (SSIS)
• Develop the multidimensional database (OLAP cubes/SSAS)
• Use of MS SQL Server 2016 (SSMS, SSIS, SSAS, SSRS), MS SQL Server PDW, Oracle, Power BI, Delta Lake, Databricks, Synapse

• Implemented communication between heating system modules via the SOME/IP interface in C++
• Developed additional software components in C++
• Executed unit tests and integration tests in the GitLab CI workflow
• Set up desktop publishing functionality
• Tools: C++, Python, Linux, Robot Framework

• Supported an agile team in the development of a new CRM tool
• Web frontend development (Angular 17 with MDB-Bootstrap, microfrontends, DDD)
• Backend development (C# & .NET 7-9, MongoDB, MassTransit, RabbitMQ, Elasticsearch, microservices, DDD)
• Coordination with stakeholders & product owners
• Assisted in sprint planning

• Extraction and transformation of relevant data from the SAP system developed for the bank and consolidation into the existing reporting environment
• Integration of the data into the existing BI model (extending the star schema to a galaxy schema) for generating the funding committee report and the business development report
• Ensuring data quality
• Knowledge transfer to department staff (SAP, SQL database, Power Pivot, DAX)

• Software development for microcontrollers and PCs
• Design of architecture and modular structures based on requirements
• Implementation in programming languages (preferably C, C#)
• Documentation in source code (e.g., Doxygen) and additional documents
• Use of version control and backup systems (e.g., SVN, GitLab)
• Developer testing
• Hardware development of microcontroller-based, digital and analog circuits including power electronics
• Circuit concepts (digital and controller circuits, analog, power electronics)
• Calculation of relevant parts
• Compliance with EMC and safety guidelines
• Simulations and component selection
• PCB implementation: layout, manufacturing data, EMC and safety guidelines
• Support of prototype manufacturing and series ramp-up
• Commissioning of prototypes
• Test development: manual and automated tests, test specifications, test stand conception and equipment selection
• Requirements management and maintenance (requirements specification)
• Support of certifications and series introductions