Mercurial Experts in Germany

Reporting and controlling using Power BI for a production ERP system

• Analysis of ERP data and interfaces for use in Power BI dashboards
• Evaluation and migration of existing reports (e.g. Excel) to Power BI
• Development of an authorization concept for selective data access
• Documentation and training on the use and customization of Power BI dashboards

Label: Power BI, Excel, SelectLine ERP, Microsoft SQL, SQL Server Management Studio

• Building a data integration platform for high, medium, and low voltage assets for contextual analysis of time series with master data from the SCADA control system (IEC 60870 104), INIS, and SAP.
• Responsibility for the architecture and implementation of the solution, as well as sparring partner for the Product Owner.
• Use of Kotlin, Spring Boot, Maven, TimescaleDB, PostgreSQL, liquibase, Elements IoT, Docker, Kubernetes, Grafana, Python, jupyter, and various API gateways.

• Development of automated software tests (unit, integration, regression and end-to-end tests).
• Applied technologies: Playwright, Vitest, JavaScript, TypeScript, Vue3, Go, Laravel, REST API, CI/CD, Docker, Git, GitHub, Scrum, Jira.

Oracle Project Management and Automation

As part of the project, the operation of an Oracle infrastructure was automated by developing and enhancing Puppet modules and migrating existing Bash scripts to a standardized configuration management solution.

The aim of the project was to standardize and automate administrative processes, improve the maintainability of the Oracle platform, and increase the efficiency and traceability of infrastructure management through the use of Infrastructure as Code.

• Analysis and migration of existing Bash shell scripts to a Puppet-based automation solution
• Development and enhancement of Puppet modules for Oracle environments
• Automation of installation, configuration and operational processes using Infrastructure as Code
• Standardization and optimization of configuration management for Oracle systems
• Creation and maintenance of technical and operational documentation
• Planning, coordination and professional support during project implementation
• Operation and automation of Oracle systems on x86-based Linux server platforms
• Testing and quality assurance of the developed Puppet modules
• Analysis and resolution of technical errors as part of the automation and migration
• Close coordination with specialist departments and infrastructure teams to implement automation requirements

Technologies used: Puppet 7/8, SLES 15, Oracle 19, Oracle Grid, SVN, Windows Server, Confluence, VS Code, Ruby, Bash, Pass

• Further development and operation of a central backend service for providing vehicle inventory for international Mercedes-Benz online shops
• Further development of a reservation service for vehicles as part of the checkout process
• Design and implementation of a highly scalable end-to-end test architecture with a focus on maintainability, reusability, and a high number of automated test cases
• Development of a multi-layer test infrastructure with a strict separation of test logic and access layers
• Development of an initialization and caching architecture to significantly speed up local and CI/CD-based test runs
• Development of an AI-supported review architecture for automated evaluation and quality assurance of end-to-end tests
• Development of a dashboard for consolidated display of a vehicle context across multiple backend systems, including AI-generated summaries and compact case analyses
• Integration and further development of connections to various reservation systems via Apache Kafka and REST
• Design of new microservices and support with architecture decisions
• Risk analysis and design of microservice migrations
• Technologies: Java, Spring, Spring Boot, Gradle, Maven, Apache Kafka, REST, OpenAPI, Swagger, Github, Confluence, CI/CD, Microservices, AI, LLMs

• Drive migration of enterprise authorization platform from Styra DAS to open-source OPA via Skipper (Zalando's Golang-based ingress proxy) integration
• Optimise k8s resources and integrate native Prometheus metrics with OPA
• Migrate from internal monitoring solution to Prometheus CRs + Dash0

Tech Stack: Java/Kotlin, Golang, Python, Spring Boot, AWS, Kubernetes, Docker, OpenTofu, Prometheus, Grafana

• Consulting and project management to build an AI-based automation platform for market data analysis
• Automated testing of financial data
• Market data automation with Python and N8N
• AI data integration and AI learning
• Use of Ollama and Qwen
• Data organization and database management

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

• Develop hardware drivers and middleware using C++11, Java and Python
• Design of various RF features such as deembedding based on stakeholder requests
• Work with multiple teams to design drivers for multiple RF products
• Perform HW control to deliver RF signals and measure modulated response
• Develop RF drivers for generation of low noise signals to test WiFi7 products
• Use digital modulation techniques such as QAM for low level driver development
• Develop low level USB drivers for device enumeration
• Develop drivers for HW relay control of control boards for device testing
• Perform JTAG operations on devices under test
• Use network-based protocols (SFTP, UFTP, FTP, SSH) for control board communication
• Manage HW devices such as BADC and EEPROM for control board maintenance
• Utilize C++11/14/17 features, template metaprogramming and STL
• Employ multithreading for testing and control of multiple HW devices
• Develop tools for deployment of customer OS on control boards
• Perform component and integration tests using CxxTest
• Follow Scaled Agile Framework for software development
• Create detailed design documents using PlantUML

• Main developer in an online retail company
• Built an online shop using the Next.JS React framework
• Integrated the site with dozens of third-party apps using REST and GraphQL APIs
• Built a backend for order management, warehouse management (with iPhone app), and supply management
• Automated invoicing and finances with QuickBooks

• Implementation of a GitLab CI/CD pipeline based on SAP Commerce Cloud 2211
• Development of a new B2C shop with Vue, Node and TypeScript to ensure scalability, extensibility and performance optimization
• Integration of Microsoft Azure Event Grid with SAP Hybris
• Implementation of BDD with Cucumber using Gherkin syntax to promote collaboration between development and business teams
• Support and customization of a Spartacus shop
• Technologies/Languages: Java, REST, OData, Behavior Driven Development (BDD), Cucumber, Node, Vue, TypeScript, Spartacus, GitLab CI/CD, Gradle, Maven, Ant, SonarQube

• Integration of SAP Commerce Cloud with SAP Cloud for Customer
• Creation and execution of unit and integration tests
• Error analysis and bug fixing

• Development of a test system
• Establishment of the architecture using Scala/Java for the backend and Swing for the frontend
• Setup of CI/CD pipelines with Jenkins for continuous integration, including automated builds
• Participation in the Scrum team, including daily stand-ups, sprint planning, and retrospectives
• Technology environment: Scala, Swing, EJB, JPA, Scrum, PostgreSQL, Mercurial