PL/SQL Experts in Zurich

• Migration of databases from ODA to ExaData
• Migration of databases from ExaData to ExaCC/OCI
• Reduced UCC usage by 10%
• Developing automation scripts using Python
• Performance tuning
• Reduced development databases from 6 TB to 3 TB using Exadata columnar compression
• Improved application performance by 30% using the inmemory option
• Improved non-production Exadata performance by 20% to free up CPU resources before ExaCC migration
• Database patching of Oracle 19c
• Basic Ansible scripting for deployments and database cloning
• Developing an accounting model for a shared Oracle platform
• Migrating single-instance databases to Oracle RAC
• Analysis of RAC issues
• Advising development teams on how to migrate to RAC

• Advising insurance companies on modelling, reporting, valuations, risk management and acting as Appointed Actuary
• 2023–2025: Improvement of Solvency II software, annual financial statements (HGB, SII), process optimisation, pricing, SQL- and Python-based reports for AXA Deutschland, Cologne
• 2022–2023: Support with portfolio transfer (RAFM optimisation; impact on HGB balance sheet, SII, reinsurance; migration to msg.Life Factory) for Zurich Deutschland, Cologne
• 2021 and 2024: Redesign of Solvency II model, implementation in Python and model enhancements; testing and documentation for PK Rück, Zurich
• 2021–2023: Control calculations for policy maturity benefits; specification and testing of an administration system for product launch at Youplus, Liechtenstein
• 2021: a) Support in drafting a reinsurance contract: project management and analyses; b) Support with Solvency II reporting and multi-year planning for Allianz Leben, Stuttgart
• 2020–2021: Further development and optimisation of models with Risk Agility FM (RAFM), integration into the IFRS 17 reporting process with Unify for Allianz Slovakia and Bulgaria
• 2017–2023: Quality improvement of the RAFM model; methodology development; documentation; optimisation of reporting and planning processes; automation with Excel and Oracle SQL (on COR-Life); implementation of a life reinsurance contract; validation of mathematical figures in the administration system for SV Versicherung, Stuttgart and Mannheim
• 2015–2017: Project management and senior actuary in the development of an actuarial projection tool and in the IMAP process with the regulator; guidance of the reporting team; analyses; methodology development; process design; coordination with IT, asset management and risk management for Allianz Leben, Stuttgart
• 2016–2020: Review of cash flow models for investment projects for B Capital, Zurich
• 2015: Rebuilding of methodology for MCEV calculation based on MVBS; weakness analysis and support in addressing weaknesses for Allianz SE, Munich
• 2014: Solvency II risk capital reporting project: validation of data submissions; analyses for management and the regulator; tool development; process and documentation improvements; training of team members for Aegon Group, The Hague, Netherlands

• Clients: Central banks of the most developed economies in the world, German, Swiss, Luxembourgish, Monegasque, Singaporean, Japanese wealth managers and universal/private banks, world’s largest investment banks
• Accountable for managing the delivery of a portfolio of digital wealth and consumer relationship management initiatives
• Project managing portfolios of projects within CTO product and technology business area (cyber security, architectural changes, re-organisational transformation, 3rd party apps)
• Products: Kernel & Parametrisation for Core Avaloq Banking Platform; modules: CRM, client data management, wealth management, portfolio management (generating over 90% of company revenues)
• Key responsibilities:
• Reporting to Head of Disruptive Innovation Division; stakeholder to five product owners & two domain owners
• Accountable for delivery of annual themes and quarterly key deliverables
• Managing demand vs supply via QBR process: book of work, execution, reporting, risk management
• Directly managing around 40 external consultants (front-end/back-end engineers, BAs, designers)
• Hiring and managing resources in eight countries
• Running quarterly divisional closure meetings presenting achievements and challenges
• Resolving cross-team dependencies and internal/external conflicts
• Owning and controlling maintenance budget; planning, forecasting, execution; ensuring demand matches supply
• Identifying and staffing key roles with chapter leads
• Approach: Agile, Scrum of Scrums, QBR/OKRs
• Technology: Angular, PL/SQL, JavaScript, Confluence, JIRA (JQL)

• Project management: Implementation of SAP & EBX integration for master and reference data management and led development of AI supported services for data management and privacy-oriented solutions
• Business analysis: Executed in-depth requirement gathering and data analyzes for MDM implementation, supported service integration using REST APIs to enhance service interoperability, led the requirement gathering, analysis, and implementation of agent-based AI services
• Technologies: SAP BP & FICO & MM, Tibco EBX, n8n, custom AI development in Java, Python, RDBMS, cloud

• Participating in a strategic enterprise project to introduce a centralized customer data platform ("Single Source of Truth") to eliminate redundant data storage and accelerate digital services

• Analyzing and documenting business and system requirements for migrating large, heterogeneous data sets (ETL) and for continuous data synchronization between core systems and the new platform

• Close collaboration with business units, data engineers and architects to gather and validate requirements, and to ensure data quality, consistency and regulatory compliance

• Defining the migration strategy, specifying ETL processes and synchronization mechanisms, and documenting technical interfaces

• Developing and executing test cases for migration and synchronization processes, and performing defect analysis to ensure data integrity and system stability

• Technologies: SQL, Microsoft SQL Server, Azure DevOps, Confluence, UML, RESTful Services, Swagger, Postman

• Managing the Testing services for the Global IT Testing Centre of Excellence (TCoE) team, which is responsible for managing and supporting the Product & Project Testing Workstreams on various Regional Projects, especially in Pharmacovigilance, Digital Supply Chain, Clinical Practice and R&D, etc.
• Managing Client relationships, escalations and continuing to grow the project services globally, while also driving the testing efforts on Takeda’s AI, DevOps, Agile, and Digital projects.
• Led the implementation of a Quality Management System (QMS), ensuring compliance with GCP, GMP, and Swiss and EU regulations, resulting in a huge improvement in audit readiness.
• Overseeing projects for systems including ERP, EDGE, SAP ECC, SAP Transportation Management, S/4 HANA migration etc.
• Led an AI/ML PoC for AI implementation.
• Led a cross-functional team to ensure compliance with MDR, FDA regulatory guidelines and achieved successful project deliveries.
• Led and managed change management and communication for TCoE, keeping the Takeda organisation informed of change communication and practices, including presentations to various stakeholders.
• Ensuring TCoE outsource vendor resources adhere to regulatory, compliance and quality system standards and practices for GxP & non-GxP System Development Life Cycle (SDLC) including aSDLC and TCoE Global Standards.
• Translated the product vision, strategy and requirements into backlog items, which were prioritised based on potential business impact and customer value.

• Business analysis and requirements engineering
• Consulting technical mathematics and control theory
• Selling outsourcing software development projects to companies
• Project lead, controlling and automated testing
• Software design and support
• Developed control algorithm for a sensorless permanent magnet electric motor
• Solved control engineering problems for customers

• SAP Data Designer ETL, SQL Server, Docker for PharmaSuisse Data Warehouse Application (Application Manager and Developer)
• SAP Business Objects, ABAP on SAP HANA for the Police of the Canton of Bern (Application Manager and Developer)
• Avaloq Connectors to SAP BW for Banque Cantonale de Fribourg

• Awarded the degree of Doctor of Economics (Dr. oec.)
• Passed doctoral examination with the grade "good"
• Dissertation: Development of OR-based software systems – concepts for problem- and user-oriented design

Application ownership and further development of test user management (TUM)

Areas of responsibility: Application ownership (Application Ownership / ITSO), application management, incident management, deployment / release management, requirements management, prioritization, further development, automation, and interface management

Technologies: SQL Server, Python, GitLab, UC4, Lieberman, Linux

Responsible for the operation and continuous development of a central application for managing more than 5.000 technical test users and their data.

Gathered and assessed business requirements, independently prioritized further development, and planned and coordinated implementation using agile methods and PI Planning, in close collaboration with the relevant business units and IT teams.

Expanded the central SQL Server database with additional information about test and real users, and integrated further applications through defined interfaces. The modular application used Python-based processing components, with execution and workflows controlled through UC4. This enabled data from different source systems to be automatically transferred, processed, and made available, as well as new test users to be created automatically.

Ensured reliable application operations and continuously optimized and automated existing processes.

Application ownership, modernization, and migration of incident management (TRANT)

Areas of responsibility: Application ownership (Application Ownership / ITSO), application management, incident management, deployment / release management, requirements management, software modernization, migration, interface integration, and quality assurance

Technologies: UC4, Jira, SQL Server, Oracle, Java, Python, Lieberman, Linux, Jai

Responsible for the operation and development of an application that automatically records, processes, and forwards technical incidents in various test environments.

Automated the creation of Jira incident tickets when UC4 workflows were blocked, including routing them to the relevant application managers.

Modernized the application by migrating from Java to Python, moving the database from Microsoft SQL Server to Oracle, and replacing the Jenkins scheduler with UC4.

Integrated the Jira API and used the bank's internal AI solution Jai to support code migration and subsequent validation. Independently and critically reviewed AI-generated results for business and technical accuracy.

Shift lead for operations control in test environments

Areas of responsibility: Monitoring various test systems

Technologies: UC4, TSO, HOST, Azure-Cloud

Responsible for monitoring and controlling automated processing workflows in various test environments, including systems running in the Azure-Cloud.

Monitored UC4 and HOST workflows and analyzed and handled incidents. When processing workflows were blocked, Jira tickets were automatically created through TRANT and assigned to the relevant application owners. In coordination with them, affected jobs were restarted or stopped as needed. HOST processes were also monitored and controlled through OPC.

A multi-shift operation was introduced to ensure stable and as continuous as possible testing.

Test data anonymization manager

Areas of responsibility: Planning/anonymizing/publishing production data for test systems

Technologies: UC4, Informatica (PowerCenter and IDMC)

To ensure test environments could run with real data, production databases were cloned regularly. Production data had to be untraceable in test environments. For this reason, the cloned databases were first anonymized with Informatica PowerCenter and later with Informatica IDMC. Critical tables and columns in the various databases (Oracle, SQL-Server, MongoDB) had to be identified and analyzed at the data level. Rules for handling critical data were agreed with the application owners.

• Coordination of a scientific OpenSource project
• Administration of publication in the IEEE proceedings
• Presentation at the most prominent international conference for neural networks (WCCI IJCNN 2022)