ETL Expert in Zurich

• Defined and launched a major European digital transformation program, leading a six-bidder RFP, overseeing solution blueprint development and co-developing the business case, roadmap and multimillion budget. Secured board approval within five months.
• Built and led a multidisciplinary delivery organization of nearly 50 people at peak, spanning internal teams and three external partners. Defined responsibilities, allocated resources, set priorities and oversaw vendor performance, coordinating 200+ stakeholders.
• Led the two-year delivery of a common Salesforce CRM and digital sales portals across four EU subsidiaries, integrating local systems through MuleSoft Anypoint. Connected to Databricks for reporting, and embedded Databricks-based pricing and credit checks into the sales processes. Applied an Agile, business-first approach to evolving business needs, achieving adoption in France, Italy and Spain and business-validated technical go-live in Germany, within budget.
• Established a sustainable post-program ownership and support model: appointed a Business Analyst as Product Owner and coached him over two years to take full ownership of the solution and the digitalization strategy. Built the functional delivery team, brought one of its Functional Analysts in-house as the business-side Application Manager to oversee functional management and future enhancements, and recruited two Salesforce Admins into Group IT for country-level user support and day-to-day technical operations.
• Enabled further group-wide expansion through a reusable, scalable platform, securing board approval for a rollout to Czechia & Poland. Initiated both rollouts before completing the assignment.

Led implementation of an Azure cloud-based, event-driven enterprise integration platform connecting Salesforce, Momentus(event) and ERP applications. Reduced overall costs by 60%, lowered operational errors to under 1%, and delivered on time.

• Led the full project lifecycle from initiation to delivery using agile and hybrid methods - platform vision, feasibility, technical blueprint, architecture, implementation, integration, testing, rollout and business adoption.
• Built the engineering team from the ground up, leading teams across Switzerland, Bulgaria and India using Scrum and Kanban; established Jira, Confluence, Asana and SharePoint for delivery and reporting.
• Established and managed frequent steering meetings, reporting that gave stakeholders transparency and drove key decision-making.

• Owned and managed the product roadmap and backlog for the Consumer Banker reporting framework, prioritising features and driving iterative delivery of banker scorecards and network performance reporting in an agile environment.
• Developed and iterated portfolio financial reporting on a weekly cadence based on stakeholder feedback, replacing manual PowerPoint packs and saving the program hours of effort weekly.
• Integrated Generative AI (MS Copilot) to automate data lineage documentation across a large legacy codebase, eliminating est. 6 months of analyst effort and accelerating data governance outcomes.
• Led a unified data delivery approach and standards across five UNITE initiatives (~CHF 115m portfolio) supporting consolidation of legacy systems into the Digital Banker platform.
• Led cross-functional delivery team of 3 while also drawing on BA and DA talent pools, coordinating analytical resource across workstreams to accelerate data, reporting & governance outcomes.

• Highest level achieved: Certified Mid-Level Angular Developer
• 13 technologies newly learned or refreshed with (re-)certifications
• Current: Docker, Azure, Quarkus

• 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

• Designed large-scale systems and APIs serving thousands of concurrent users.
• Refactored a 650k-LOC monolith and led full AWS migration for stable performance.
• Introduced SLO-based observability, improving reliability and recovery flow.
• Optimised cloud and databases, achieving significant cost and latency reduction.
• Delivered LLM, RAG, and document-automation pipelines adopted in production.

• Worked in mixed teams with several clients
• Performed requirement engineering, proposal and time estimation
• Developed ACLs, business rules, flows, workflows, catalog items, various scripts, UI actions, policies, scoped applications
• Customized mobile apps: Now Agent and Now Mobile
• Implemented integrations using the Integration Hub
• Coordinated continuously with clients during development
• Performed testing and helped clients with testing
• Deployed to production and applied main version upgrades and patches
• Managed CMDB, domain separation and asset management
• Integrated between instances at different clients
• Developed GlideScript: business rules, scripted REST endpoints, extension points, fix scripts, background scripts

• Supporting UBS Wealth Management as Senior Data Architect within a multi-year enterprise data mesh transformation.
• Guiding a strategic stream to design and implement a data product aligned with UBS’s enterprise-wide data mesh framework.
• Leading architecture definition, governance alignment, and cross-domain integration to ensure scalable, compliant, and reusable data products across global stakeholders.
• UBS – Global Wealth Management Data Product Architecture: Designed an enterprise-aligned data product spanning 26 countries, defining data contracts, metadata standards, and federated architecture patterns enabling cross-domain reuse across the bank.
• Defined cross-jurisdictional data policies and access controls to ensure compliance with regulatory requirements across multiple regions (EU, APAC, LATAM, CH).

• For the internal MIS, which gathers data in a complex, comprehensive system landscape and loads it into a central database via ETL, existing processes and packages had to be maintained and new KPIs analyzed, specified, and implemented.

• Supporting the implementation of a digitalization project in the area of nutrient balancing
• Analyzing complex business processes and interfaces to surrounding systems (data flows, dependencies)
• Designing processes for data retrieval, storage, and sharing, including plausibility checks and validation logic
• Creating and prioritizing user stories and guiding developers in agile sprints (clarifying acceptance criteria, conducting technical reviews)
• Supporting the Product Owner in defining functional and technical requirements
• Participating in the rollout process and delivering training for stakeholders
• Documenting processes, requirements, and interfaces (including records/changes for releases)

• Act as DBA SME for MS SQL Server and primary contact for MSSQL infrastructure and long-term technology roadmap in a critical 24/7 banking environment
• Maintain and evolve SQL infrastructure and monitoring system across development, test, UAT, and production environments (10 servers, 4 always-active Windows clusters, MSSQL 2014–2022 on VMs hosted by Inventix)
• Automate SQL operations using Brent Ozar scripts, PowerShell, and Inventix cloud script integration
• Build and improve ETL processes and BI applications (Power BI); plan resources and mentor BI team
• Participate in review, delivery, and deployment of database improvements across the software development lifecycle
• Migrate SQL Server instances from 2017 to 2019 and 2022
• Integrate new applications requiring MSSQL databases
• Manage and support on-premise and Azure SQL Server solutions; advise on industry standards, best practices, and creative database solutions
• Develop automation scripts for internal systems using PowerShell and Git
• Monitor systems with Splunk and Grafana; manage alerts, filters, data ingestion, and dashboard configuration
• Collaborate with operations, development, and business teams to identify and resolve operational and performance issues proactively
• Implement new SQL Server technologies such as Query Store, Extended Events, Tuning Advisor, and system traces
• Provide on-call support and regular maintenance during evenings and weekends
• Define and enforce system policies and standards; work closely with application managers, HR, and IT platforms in Switzerland and the UK
• Handle 2nd/3rd level support service requests; document resolutions and cooperate with vendors
• Use internal and external monitoring tools to detect performance trends and implement alerts and processes to prevent database issues
• Document and share knowledge to improve technical understanding across operations and development teams; administer Confluence (installation, configuration, document management, performance, upgrades)
• Work professionally in cross-functional teams to advise, influence, and coach development and operations teams on database topics

• Designed and delivered a practical real-time course on Flink and Hadoop with MapReduce, HDFS, Spark, Flink, Hive, HBase, MongoDB, Cassandra, and Kafka
• Gained extensive DevOps and CI/CD experience
• Created ETL/ELT pipelines with Apache tools and Pentaho
• Led projects in municipal software, financial services, and big data with Kafka
• Developed AI/NLP models and chatbots with RASA, Chatter, and Dialogflow
• Built and managed a TypeDB knowledge database
• Worked with OpenStack, Kubernetes, and Podman

• 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

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.