Oracle Database Experts in Hamburg

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

Rollout of printers and PCs

• Effective management of external service providers to ensure smooth operations.
• Planning and implementation of a global rollout for 150,000 clients.
• Carrying out a comprehensive risk analysis, including overall risk, site-specific risks, and security risks.
• Successful consolidation of two existing ServiceNow systems to optimize service management.
• Close coordination with program management to achieve the project goals.

• Administration and further development of the M365 environment including Teams, Exchange Online, Intune and SharePoint Online
• Development of dashboards for performance monitoring using Microsoft Power BI
• Implementation of user requirements and processes with low-code/no-code technologies (Power Apps, Power Automate)
• Use of Jira and Azure DevOps to plan and implement user stories in an agile project context
• Participation in daily stand-ups, sprint planning, sprint reviews and retrospectives as technical point of contact
• Planning and implementation of security policies using Azure Conditional Access and multi-factor authentication
• Configuration and deployment of clients and applications via MECM (SCCM) and Baramundi

• Support for one of the largest logistics service providers in handling ServiceNow tickets in the areas of SAP MDG, Business Partner (BP), customer and supplier master data
• Technical analysis and resolution of tickets through in-depth review of various database tables
• Creation and maintenance of accounting clerks in the system
• Deactivation of company codes using transports
• Carrying out mass changes with LSMW (Legacy System Migration Workbench)

Strategic technology leadership and architecture consulting.

• Fractional CTO & interim management for startups, scale-ups, and enterprises – technical strategy, team building, architecture oversight, and delivery.
• Architecture consulting on cloud-native, distributed, and event-driven systems: reviews, design partnerships, and ongoing advisory.
• Event-driven architecture training – a hands-on 2-day course for engineering teams
• Conference speaker on distributed systems

Project:

• Migration of existing VB6 applications to C# (Web API, web app)
• Report development and risk management systems (C#, API interfaces, databases)
• Document archive (API interfaces, databases)

Team size: 9 people

• Reports for Risk and Credit Management Development and maintenance of report structures to support risk and credit decisions, including data modeling, validation, and automated delivery for business departments.
• Migration and maintenance of a legacy system to the latest version of .NET for the asset management system Planning and execution of the modernization of an existing asset management system, including code refactoring, performance optimization, test automation, and sustainable maintenance after migration.
• Replacement of the COM-based archive connection with a REST API Redevelopment of the connection of the document archive (HYPARCHIV) to a REST API based on OpenAPI/Swagger, including archiving with index and stamp fields as well as PDF export into the customer portal.
• Redesign of payment receipt processing Replacement of an existing Oracle PL/SQL process with a new implementation in C# based on a business concept, including business alignment, data modeling, and test coverage.
• Design and implementation of tests, creation of deployment pipelines, and documentation
• Further development and implementation of change requests.
• Regular code reviews within the team as well as optimization of application scalability and stability

Technologies: C#, .NET 10, ASP.NET, Unit of Work, IoC, Three-Tier Architecture, Entity Framework Core, DB First, Web API, Swagger, OpenAPI, Python, Oracle, HYPARCHIV, Azure, PowerBI, DevOps, AKS (Azure Kubernetes Service), GIT, xUnit, NSubstitute, TypeScript, Vue.js, Pinia,

Methods: agile development using Scrum

• Development of ETL pipelines with Talend (7/ Enterprise)
• Development/adaptation of database schema/database functions (PostgreSQL)
• Development of GIT CI pipelines

Technologies: Talend Enterprise, Git, PostgreSQL, Dbeaver, SQL, PL-SQL, Liquibase

• Disciplinary and professional leadership of the IT and service team
• Definition and documentation of the Current Mode of Operation (CMO) in Confluence: application landscape, infrastructure, networks, backup & storage
• Development of the Future Mode of Operation (FMO) including process analysis & stakeholder interviews with all departments using BPMN and flowcharts
• Optimization of license management: reduction of ongoing software costs by approx. 17% p.a.
• Introduction and establishment of Jira as the central tool for project and service management
• Introduction and rollout of the HR software MindKey to digitize HR processes
• Introduction of a VoIP solution with Microsoft Teams incl. PSTN connection to replace classic telephony
• Introduction of the production and planning software OptiControl to digitize operational processes
• Rollout of Intune as a Mobile Device Management solution for Windows, iOS and Android
• Build-up of Power BI dashboards for machine park monitoring and financial reporting
• Planning and execution of the IT consolidation of two locations for 170 users
• Introduction of automated penetration testing with Pentera
• Coaching and mentoring the team in agile methods & project management
• Operational support in day-to-day business: administration, incident & change management
• Management of external service providers and assurance of the quality of outsourced IT services
• Responsibility for the IT budget incl. planning and controlling
• Direct reporting line to management with regular management reports on IT KPIs, budget and project status

• Several projects in a police context
• Model and document police procedures/projects with Archimate (as-is/to-be) in the context of P20 (BKA)
• Create software architectures with microservices
• POC development with Springboot/Docker/Kubernetes
• Project size: 10 people
• Enterprise architecture management with Togaf and Archimate
• Backend software development Springboot
• DevOps with Kubernetes
• Implemented using: Java 17/21, Springboot 3, P20 architecture, Togaf, Archimate

• Data-analysis, Preparation, gathering and coordination of business requirements for retrieval of monthly- and long term (CLV – relevant) cost- and revenue-components per contract for a customer–base–grouping project (HUB–Project) for B2C-Postpaid-Controlling
• Concept and Implementation of cost- and revenue-KPIs calculation and corresponding CLV–reports (Oracle, Perl, SVN, MS SQL Server, MS Power BI, Serviceware Performance Analytics)
• Operational support of the HUB-Project – various ad-hoc reports, deployments, job-scheduling etc. (Oracle, SVN, BICSuite–Scheduler, DWSODA etc.)
• Analysis, implementation, retrieval and reporting of various physical and financial KPIs for B2P-Prepaid Business on an existing data-mart (Oracle, Perl)

• Project leadership and management
• Implementing reporting solutions in banks
• Enhancing and optimizing reporting processes in bank finance and risk departments
• Consulting through all phases of regulatory requirement implementation, including requirements analysis, defining business requirements, testing, tool development, and audit-compliant documentation
• Supporting regulatory implementation projects
• Analyzing business requirements and implementing reports
• Acting as a liaison between business and IT
• Publishing on regulatory changes
• Training internal colleagues on regulatory topics

• Software packaging and distribution with SCCM/MECM
• Application responsibility and support (50–100 applications)
• Documentation via ticket system
• User management via AD console
• Software updates and distribution
• Maintenance and updating of software packages
• Customizing scripts with PowerShell
• Rolling out and implementing new software
• Supporting IT security and compliance

Tools and software: Confluence, M365, Active Directory, Intune, Endpoint Management, SCCM/MECM, PowerShell, VMware Hardware: Lenovo, Cherry, Plantronics, Jabra + peripherals

• Consulting, training, and coaching in the financial sector on strategy, organization, and IT topics

• MorgenFund: Advising the operator of a fund platform on software selection for a sub-ledger "Cash Accounts" based on Virtual IBANs (VIBAN)

• Structuring requirements, market screening, creating RfIs, communicating with vendors, and conducting the selection process

• UniCredit/HypoVereinsbank: Workstream lead "Booking and Customer Reporting" in the payment transformation project "PULS"

• Business analysis, creating business requirements and aligning solution items as part of the functional specification with the bank's IT service providers

• Business analysis of SEPA CT and SWIFT MX (.camt, .pain, and .pacs formats), change management, team lead for a virtual team of fifteen line experts, and stakeholder management

• equensWorldline Germany: Program management for three projects of the SWIFT service bureau (CBPR+, ESMIG, and Euro1Step1 migration) as part of the SWIFT MX migration

• Managing individual project managers regarding overarching goals and requirements; reporting to internal and external committees and stakeholders; coordinating with dependent projects and programs

• Project management/PMO: interim project management, stand-in for project managers, resource planning, budget and cost management, general PMO tasks

• Reviewing functional and technical requirements from a testing perspective
• Creating test cases and automated tests to validate requirements
• Performing manual and automated functional, end-to-end, and regression tests
• Documenting test results and tracking defects
• Using models like GPT-4, BERT, and Hugging Face Transformers for automated test case generation, analysis of test results, and improving test coverage, including bias checks and security reviews
• Techs: MS Office, Jira, Zephyr, Confluence, Tosca, stakeholder communication, Agile, Kanban, Scrum, OpenAI API, Hugging Face, PyTorch, LangChain.