Sourcetree Experts in Germany

Task: Test tool development for Smart-Home IoT-based heating control Test tool development for Smart-Home HVAC heating and ventilation. Eliminating memory leaks in C/C++ within the CAN Analyzer application. Reviewing Python and Tcl/Tk code. Reviewing C-based simulator code for BOSCH Home Comfort cascade heating control using Visual Studio Code and Conan/Conda. Reviewing Delphi application: conversion to 64-bit. Reviewing PyQt6 user interface. SiL testing of domestic water heater control for memory leaks. Stability testing and continuous operation. Migration to Windows 11 24H2. Developing device connectivity with WinSock2 (WSAAPI, recv, send, select) for EMS/CAN IoT communication with C. Testing with virtual machines and Server Manager. Writing reports about the test cases. Logging with the RoboTT framework. Creating test procedure documentation with Docupedia. Bare-metal programming of embedded STM32 Cortex-M and simulation with Renode.io. In-depth familiarization with the SEGGER EmbOS firmware framework and its related system calls. Reviewing MATLAB/Sinumerik .m program files. Implementing redesigned OS schedulers in SEGGER EmbOS.Technologies: Embarcadero RAD Studio 10.2, Visual Studio Code, Sourcetree, Conan, Cmake, Conda, EmbOS, PyQt6, Qt6, Delphi VCL 32-bit, CAN, EMS, Powershell, MingW64, STM32 ARM-Cortex-M4F Renode.io, Windows Server 2022 Standard, RoboTT, IoT

As the lead business analyst in the in-house software division, I am supporting the relaunch of the internal system used by 20.000 employees and affecting the asset management of 8 Mio customers.

• Redevelopment of outdated software used in Hessian schools in C# .NET/WPF
• Understanding and analysis of old Delphi and Visual Basic 6 source code
• Use of Visual Studio 2022 as IDE
• Team collaboration through pull requests and version control with Git/SourceTree
• Project management with proprietary wiki software and Open Project
• TechStack: C#, .NET 8.0, WPF, Visual Studio 22, Delphi, Visual Basic 6, LDAP, Active Directory, FTP, SMB, Git, SourceTree
• Workflow: pull requests, Open Project, weeklies, weekly meetings, dynamic communication

• The goal of BIENE is to provide a unified tax collection program for all federal states.

• Tax collection involves collecting the taxes that have been assessed. This includes, for example, taking due dates into account, recording incoming and outgoing payments, and initiating reminders or refunds. Limitation periods and payment reminders are also important. BIENE handles all payment transactions with banks and accounting.

• Set up the architecture and coordinated the provision of development and test environments at the Hannover site

• Installed and configured the environments on Linux servers (Apache Kafka, PostgreSQL)

• Interface coordination: coordinated and aligned the connection of software products from other departments and their test data

• Migrated the application server, JDK, and Maven project structure

• Coordinated environments and managed builds

• Implemented external interfaces

• Delivered business requirements

• Designed and implemented RESTful APIs and OpenAPI specifications

• Designed and implemented a microservice architecture

• Set up and maintained CI/CD pipelines

• Deployed applications on OpenShift

• Created technical documentation and diagrams

• Worked with SQL databases (Oracle and PostgreSQL)

• Set up authentication and authorization for the application and users

• Containerized the application (automated deployment through the CI/CD pipeline)

• Development and implementation of backend components with PL/SQL and Oracle Forms 12c. Adaptation and further development of the policy administration system. Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.
• The project takes place in the technical environment of BIPRO, SQL databases and Oracle Forms applications. The assigned work includes backend development and technical further development in the above project with the following tasks:
• Development and implementation of backend components with PL/SQL and Oracle Forms 12c to technically map the business processes and ensure a stable and efficient system architecture
• Adaptation and further development of the policy administration system to ensure system functionality in line with the requirements of the new broker communication program
• Analysis of the existing system to identify and avoid errors and technical problems during implementation, in order to enable a smooth transition to the new system
• Carrying out patching and further development of existing Oracle and Oracle Forms applications to ensure compatibility and security of the systems in use
• Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.

Label: PL/SQL, Java, Oracle RDBMS and Oracle Forms

• Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
• The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.

Tasks Performed:

• Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
• Integration of Fabric with Microsoft Entra.
• Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
• Star Schema as well as entity relationship modeling.
• Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
• Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
• Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
• Planning and managing team of 4 ETL and reporting developers.
• Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
• SQL Performance Tuning.
• DB Design for Azure SQL.
• Reporting directly to project senior management.

Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.

• Planning, defining, and executing test cases for product creation, measurement data upload, and chart verification
• Developing keyword driven function tests using Robot Framework
• Defining and generating realistic test data with Python
• Implementing data-driven and REST API interface tests
• Performing image comparison tests based on OpenCV
• Developing load tests for various environments
• Conducting regression and end-to-end tests, reporting results, and managing defects
• Systematic expansion of test coverage
• Integrating Jenkins with Xray for test management
• Managing tickets with JIRA and documenting in Confluence
• Used Robot Framework, Playwright, Python, VS Code, Prectavi, JIRA, Confluence & Xray, Bitbucket, GitHub, Jenkins, MS Office 365, and Teams in an agile project.

• Requirements Engineering / UI / Testing
• Analysis, elicitation and preparation of user stories
• Definition of acceptance criteria and quality requirements
• Creation of wireframes and mock-ups
• Roadmap planning and backlog prioritization
• Test management, test case creation and execution
• Creation and tracking of bugs
• Identification and planning of automated tests
• Management of cooperation partners
• Organization of project employees, including project controlling and budget planning
• Coordination meetings with stakeholders
• Facilitation of retrospectives
• Onboarding, coaching and trials with customers
• Conducting webinars

• Managed and developed the system architecture for the INEOS Grenadier model year 2028/29, ensuring interaction of all E/E system components according to GB/T 32960.
• Developed a product reference model for the entire E/E system of the vehicle.
• Coordinated requirements for Battery Management Systems (BMS) between OEM and suppliers at SYS.1 and SYS.2 levels for VW and Porsche.
• Created and aligned requirements for BMS fan control and OBD within Polarion.
• Developed a secure system architecture for steer-by-wire systems, including ECU hardware, software, and communication.
• Integrated various process design approaches from CARIAD, including SAFe (Scaled Agile Framework), FUSE/FAME, and RFLP, with ASPICE requirements.
• Created a process model in ESCAPE mapping essential components of SAFe onto ASPICE.
• Served as Lead Architect for electric drive development, focusing on parklock and cooling and lubrication functions for Mercedes AMG.
• Analyzed requirements in Integrity and developed functional models in UML using Enterprise Architect.
• Developed generic models for parklock and cooling functions, including sequence diagrams and a navigation model for the overall project.

• Designed and built from scratch the automation framework using Playwright, Typescript, JavaScript, Gherkin, Cucumber, BDD, Maven, IntelliJ IDEA
• Defined, developed and maintained test plans, test scripts, reports and other QA documentation in Confluence
• Created and maintained test data with SQL Server Management Studio, Toad and Faker.js
• Performed web services and API testing using Swagger Open API, SoapUI, JSON, HTML and XML
• Executed functional, smoke, regression, black box, GUI, cross-browser, UAT and E2E testing using CrossBrowserTesting and Safari Web Inspector
• Integrated and maintained automated scripts within sprints following Kanban, CI/CD, GitHub, Docker, Azure Pipelines, Agile, Scrum, Kafka and Kibana
• Raised and managed defects in Azure DevOps
• Conducted mobile testing with Robot Framework and Appium

• Created concepts and architecture for ECU diagnostics over CAN-Bus using UDS, PDX, ODX and safety paradigms
• Designed system deployment for EMS and documented using UML, Draw.io, MS Word, MS Visio and Confluence
• Developed process flows for development, planning, logistics, test & diagnostics in Scrum with Jira and MS Planner
• Communicated across multiple customer teams, conducted knowledge transfer

• Creation of automated tests.
• Extension of the functionality of the enterprise BI data warehouse.
• Design and development in SQL and PL/SQL.
• Data modeling as well as performance measurement and tuning.
• Creation of and contribution to user stories and concepts.
• Technical environment: Windows, Linux.
• Database: Oracle 19c incl. DWH, CDB, PDB.
• Tools: Confluence, CVS, Eclipse, Git, GitLab, Jira, N4, PL/SQL, SQL Developer, utPLSQL.

• Full-stack development of new applications as well as error analysis and fixing
• Refactoring to a framework
• Customization of shop software
• Connecting the SAP interface and exporting data to the shop
• Production control with time scheduling
• Connecting invoicing to ZUGFeRD (electronic invoice transmission)
• Technologies used: PHP, MySQL, Symfony, Laravel, JS, jQuery, MSSQL, ZUGFeRD

• Transformation project to S/4HANA
• Test management and coordination of functional tests for SAP
• Preparation and support of tests (SIT 1+2, MOCK 1+2, UAT) as part of the SAP S/4HANA rollout (SD, MM, FI/CO, MD)
• Creation of test strategies, test plans, and test cases to ensure system quality
• Monitoring and compliance with service level agreements (SLAs) as well as ensuring the timely delivery of agreed performance indicators
• Coordination of the approach with test managers from other regions (US, JP)
• Planning of European test activities in the SAP implementation project in cooperation with test managers from the supplier
• Coordination of interdisciplinary business and technical test teams in Europe
• Business collaboration with global implementation partners
• Use of Tricentis qTest and ValGenesis as test management tools (for validation-relevant processes)
• Training functional consultants in testing and test tools
• Creation and evaluation of change requests, including effort estimation, prioritization, and tracking
• Reporting on test progress