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.

• Definition and setup of the subject areas
• Building a governance model for the department with the areas of responsibility
• IT strategy, project management, process management, and quality and sustainability management
• Developing a communication strategy within the group
• Creating the IT strategy
• Designing templates, guidelines, and processes for consistent work
• Capturing strategic guardrails and grouping ongoing projects – deriving a roadmap for strategic planning
• Reviewing ongoing projects
• Creating staffing calculations and volume structure
• Defining job profiles

• Led strategic IT and process consulting projects, streamlined business processes, and aligned IT systems with business goals, resulting in a 20% improvement in organizational efficiency.
• Led international transformation projects using agile and traditional methods, managing a cross-functional team of more than 15 professionals and delivering solutions on time and within budget.
• Developed cloud-based ERP/CRM systems (Salesforce, Infor, Microsoft) for clients, ensuring seamless integration and reducing system downtime by 30%.
• Led large-scale change management initiatives, actively involving stakeholders at all levels and driving the successful rollout of innovative systems in global organizations.
• Led requirements analysis and the tender process for clients, identified cost-saving opportunities, and improved operational workflows.

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.

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

• 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

• 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

• Migration and maintenance of a legacy system to the latest version of .NET for the asset management system
• Design and implementation of tests
• Creation of deployment pipelines and documentation
• Further development and implementation of change requests
• Technologies: C#, ASP.NET, Unit of Work, IOC, Three tier architecture, Entity Framework Core, DB First, Web API, Swagger, Open API, Monolith, Python, Oracle, Azure DevOps, GIT, xUnit, NSubstitute
• Methods: Agile development using Scrum

• 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