Sybase Expert

Temporary employment

• System black-box integration tests (BBIT, IVVQ): Execution of regression, release, confirmation and conformity tests for safety-critical braking control units in the railway industry
• Software Test Application & Integration: Runtime configuration of software components and libraries, validation of interfaces, configuration dependencies and component interactions
• Test Automation (FEAT Framework): Co-development and further development of an automated test framework for test execution, reporting and result analysis
• Functional Safety (SiL4, FuSi): Ensuring compliance with safety requirements, traceability and coverage as well as conformity with EN50126/28/29
• Test Automation for Communication Components: Configuration and validation of fieldbus (CAN) and Ethernet-based TCMS data communication interfaces (TRDP and CIP)
• Requirements Analysis & Shift-Left (PTC Windchill ALM): Analysis of software and system artifacts to identify gaps, ambiguities and redundancies early in the SDLC
• Test Design & Test Case Development: Derivation of test conditions and coverage strategies and implementation of data-driven test cases (DDT) including reusable test data fixtures
• CI/CD & Automation (Python, PowerShell, Jenkins, SVN): Automation of build, test and HIL deployment processes as well as integration into CI/CD pipelines
• Test Data & Configuration Management (XML): Maintenance and adjustment of XML test vectors and system configurations with automated integration into test environments
• Non-Functional Testing: Execution of performance and load tests to assess stability and system behavior
• Agile Development & Defect Management (JIRA, Confluence): Work in Scrum teams, test coordination, review of test artifacts as well as defect tracking and root-cause analysis
• Error Analysis & Debugging (CANoe, CANalyzer): Analysis of errors and message flows across multiple system levels (application to bus)
• Model-Based Analysis (UML, Enterprise Architect): Specification of SUT/SOW and support for systematic test control
• Process & Test Documentation: Creation of integration and test documentation according to internal quality and certification requirements

The online service "Special Use of Streets and No-Parking Zone" was in a partially completed state. The following tasks had to be carried out to reach final completion:

• Preparation of an expert report on the status of the online service, and recommendations for action
• Ensuring that all LEIKAS to be used are available (service catalog / service descriptions of the authorities)
• Creating and aligning concepts for complex IT projects (business/IT concepts, architecture, interfaces, roadmaps)
• Requirements management
• Multi-project management with 3 stakeholders (Police, Dataport, development company)
• Determining resource needs
• Coordination to identify technical requirements through the IT architects
• Creating use cases and test cases
• Creating action items
• Managing external IT service providers
• Coordination and management of all activities
• Conflict resolution / business mediation
• User Acceptance Test (UAT) and acceptance by Hamburg Police (Traffic Directorate, Policy Department, Central Road Traffic Authority)

Technical environment: .NET, EfA minimum requirements, Leikas, Administrative Procedure Act (VwVfG), HWG (Hamburg Roads Act), Atlassian Jira, Confluence, MS Office

Successful delivery of projects on behalf of customers:

• -> 2023 – present: Project management for the consolidation of sites/data centers for a large telecommunications provider (infrastructure project, customer: Telefonica)

• Opening and preparing new sites

• Application migrations

• Decommissioning and handover of old sites

• -> 2021 – 2022: IT multi-project management for a large car leasing company (customer: Athlon)

• Migration of applications to the cloud and to another data center

• Additional projects to expand and optimize the application landscape

• -> 2021: Project management for the development of a platform providing internet access on aircraft operated by various airlines (customer: m3Connect/German Telekom)

• -> 2017-2020: Responsible management of an IP network consolidation (infrastructure project, customer: Cisco/Vodafone) at a large telecommunications provider

• Planning and coordination of migrations and their rollout

• Team leadership and integration of different teams (network operators, hardware and service providers)

• Management of IT with 10 employees, including budget and personnel responsibility.
• Harmonization of the Navision systems in Germany, Switzerland and Austria.
• Connection of the ERP systems in Switzerland, Austria and Italy to the central Microsoft Power BI systems in Germany.
• Rollout of a new firewall at 10 locations in D, CH and A.
• Evaluation of a new DMS.
• Migration to Windows 10 / 11.
• Transformation of 9 countries into ONE Europe.
• Start of NIS2 implementation in 5 European countries.

Migration from Exchange 2016 to Exchange 2019 and Exchange Online, as well as the introduction of a backup solution and an archiving solution. The goal was to securely modernize the email and archiving infrastructure in compliance with legal requirements and ensure high performance.

Responsibilities as IT PROJECT MANAGER: Overall project management and operational coordination / Ensuring compliance with budget and resource limits / Ensuring project objectives are met / Ensuring compliance with regulatory requirements and policies, including ISMS, ITIL, and data protection requirements / Preparing and presenting management reports for the project sponsor and steering committee / Coordinating cross-functional teams across Exchange, network, data protection, and IT security / Planning and carrying out the migration from Exchange 2016 to Exchange 2019 / Planning and carrying out the migration from Exchange 2019 to Exchange Online / Planning and introducing a backup solution for Exchange Online / Coordinating an EU-wide tender for an archiving solution, including market research with potential suppliers / Planning and introducing an archiving solution for Exchange Online / Coordinating and preparing the BAS notices required for the project / Coordinating and aligning with stakeholders (for example, business units, external service providers, and suppliers) to define requirements and deliver solutions

Technical environment: MS Exchange 2016, MS Exchange 2019, MS Exchange Online, MSOffice, MS Planner, MS Powerpoint, MS Project, MS Teams, CodeTwo, Hornet Security

• Designing the audit logging framework
• Implementing APIs for developers to integrate in their codebase
• Implementing ingestion pipeline, database query layer and UI for browsing the audit events
• Improving stability and reliability of the backend system

Oracle Project Management and Automation

As part of the project, the operation of an Oracle infrastructure was automated through the development and enhancement of Puppet modules and the migration of existing Bash scripts to a standardized configuration management solution.

The project aimed 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.

• Analyzed and migrated existing Bash shell scripts to a Puppet-based automation solution
• Developed and enhanced Puppet modules for Oracle environments
• Automated installation, configuration, and operational processes using Infrastructure as Code
• Standardized and optimized configuration management for Oracle systems
• Created and maintained technical and operational documentation
• Planned, coordinated, and provided technical support for project implementation
• Operated and automated Oracle systems on x86-based Linux server platforms
• Tested and ensured the quality of the developed Puppet modules
• Analyzed and resolved technical issues related to automation and migration
• Worked closely with business units 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

• 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

• Creation and testing of test cases for sprint-dependent requests within JIRA via TestLink
• Arrangement of technical and business additions with external providers (Stakeholder Management) and internal departments
• Implementation of an automatic internal deployment of deliveries provided by an external company via bash scripts
• Concept for a secure, general password implementation for users (PC, iOS, Android)
• Testing of all online banking issues, e.g. payments, instant payments, registration, online credit
• Testing against dwpbank (WP2) via Postman
• Technical environment: Linux, bash scripting, Python (reading), test & release management

• Development, maintenance, and execution of „Regulatory Transaction Reporting“ (MiFIR & Dodd-Frank)
• Business and IT specification, testing, and business analysis in the banking systems environment of Summit, Murex, and Calypso, particularly in migration projects.
• Development, maintenance, and execution of P&L and risk reporting.
• Liaison between the business department and IT in an agile project environment.

• Creating interfaces between the legacy platform and the new container solution
• Coordinating required contributions from line units
• Moderating regular status meetings with the software vendor
• Minimally invasive conversion of TWS scheduling from the old to the new platform
• Environment: IBM Mainframe, DB2, CICS, MQ, Red Hat Linux, Oracle, Kubernetes, Kafka, Helm, GitLab, Jenkins

• Designed and specified the technical network integration of a new business critical application system (MUREX) in the capital market area in a complex interface and outsourcing environment.

• Created component specifications, catalog of measures and implementation plan.

• Ensured proper integration of developed results in accordance with the bank’s framework: IT compliance, IT security, change and release management.

• Selected and integrated a new service provider for the bank; moved critical bank applications to the provider.

• Designed, implemented and supported the new Cisco network and Fortinet security setup at the service provider data center.

• Acted as technical interface between bank, service providers and consulting partners.

• Supported and further developed the network and security infrastructure (clients, servers, networks); performed error analysis and implemented solutions within agreed service levels.

• Analyzed and diagnosed all security and network failures, glitches and malfunctions.

• Initiated continuous enhancements to guarantee efficient resource utilization and acceptable response times to users.

• Provided network support in financial service organization and operational change preparation on production banking network infrastructure for both large and small projects within strict change management discipline.

• Designed, defined, tested, governed and improved engineering standards.

• Performed role of network architect for medium-large projects involving team resources.

Tasks

• Further development of a new ERP system with Blazor
• Generation of e-invoices in the XRechnung and Zugferd formats
• UI/UX design Client-server system
• Windows 11 Technology
• Microsoft .NET 9, Git, Azure DevOps, ASP.NET, MSSQL, Blazor Programming languages
• C#, MVVM Development tools
• Microsoft Visual Studio .NET 2022 Database
• MSSQL Industry
• Other

Consulting and prototype work on AI voice and multilingual agent systems, using AI-assisted delivery across realtime translation prototypes, call-centre automation, and voice-to-voice consultation workflows.

• Built and advised on AI voice / agentic conversation prototypes, including realtime translation and consumer-facing consultation experiences.
• Worked across call-centre automation, voice UX, product architecture, implementation tradeoffs, and prototype development.