Patrick Hirschi

Data Enthusiast

Software Engineer

Tech Lead

Patrick Hirschi

Data Enthusiast

Software Engineer

Tech Lead

Resume
Experience
2020 - Present
Team Lead Engineering – Clinical Data Platform for Research
University Hospital of Zurich
  • Key Highlights:
    Team Lead for 8-10 internal engineers and 3-5 associated virtual employees
    Responsibility and decision-making competence regarding methodology, technology, and architecture of the
    clinical data platform
  • Key Responsibilities:
    Architecture, development, maintenance and administration of the clinical data platform and its underlying
    data lake, databases, and data marts
    Manage capacity and workload of the clinical data platform, including planning for additional large data
    sources, and their impact on the underlying infrastructure
    Manage support and development activities with software suppliers
    Responsible for the internal technical work packages related to the Swiss Personalized Health Network
    (SPHN) for building an infrastructure to enable nationwide use and exchange of health data for research, as
    well as the work packages of all clinical research projects associated
    Responsible for the technical implementation of interfaces from USZ to The LOOP Zurich Biomedical
    Informatics Platform (BMIP) to allow for translational data-driven research across Zurich hospitals
    Member of multiple decision-making bodies including the Information Security Board, as well as the Software
    Advisory Board and the Change Advisory Board
    Provide expert guidance to users in the clinical research domain, who include data science specialists, data
    analysts and the wider business such as physicians, nurses, and data managers regarding the data
    availability, clinical and other terminologies (ICD, CHOP, UCUM, SNOMED-CT, LOINC, etc.) as well as the
    data governance, data protection and IT security
    Project management (effort estimates, offers, invoices), resource allocation and customer communication
    Technical and use case documentation (security concept, operating concept, user manuals)
2019-2020
Clinical/R&D Data Platform Specialist – Research Data Service Center
University Hospital of Zurich
  • Key Highlights:
    Developed solution for enterprise-wide distribution of general consent data from patients to ensure the data
    governance and the conformity to applicable internal directives, laws, and regulations (Web Application and
    API based on .NET Core)
    Developed backend and data delivery processes for national SPHN research projects Swiss Personalized
    Sepsis Study and Population Wide Screen
    Member of the hospital-wide expert panel for clinical and research projects
  • Key Responsibilities:
    Architecture, development, and maintenance of the data integration layer especially the ETL processes from
    clinical and administrative source systems to the Research Datawarehouse
    Aggregation, cleansing and masking of clinical data to fulfill the requirements of internal and external
    research projects
    Architecture, development, and maintenance of processes to provide encoded and encrypted health-related
    data to SPHN (Swiss Personalized Health Network) and internal researchers
    Support the technical development and evolution of master and reference data models for specific data
    domains
    Provide domain expert guidance and specialist technical support to users in the research domain
    Technical and use case documentation (security concept, operating concept, user manuals)
2018-2019
Datawarehouse Developer – Research Data Service Center
University Hospital of Zurich
  • Key Highlights:
    Developed solutionfor automated data encryption and delivery with PGP and LiquidFiles
  • Key Responsibilities:
    • Architecture, development, and maintenance of the data integration layer especially the ETL processes from
    clinical and administrative source systems to the Research Datawarehouse
    • Aggregation, cleansing and masking of clinical data to fulfill the requirements of internal and external
    research projects
    • Architecture, development and maintenance of processes to provide encoded and encrypted health-related
    data to SPHN (Swiss Personalized Health Network) and internal researchers
    • Support the technical development and evolution of master and reference data models for specific data
    domains
    • Technical and use case documentation(security concept, operating concept, user manuals)
2016-2018
Application Manager / Developer – Clinical Data Management
University Hospital of Zurich
  • Key Highlights:
    Developed backend for a near-real-time care dashboard rolled out enterprise-wide and used by 1000+ users
    (physicians, nurses, etc.) a day
    Developed solution for traumatology to prefill a case report form for the Swiss and German trauma registry
    with data from the clinical data platform, as well as a yearly XML export to the registry providers
  • Key Responsibilities:
    Maintenance, second-level support, and coordination of third-level support for clinical data management
    applications, interfaces, and solutions
    Testing and Rollout of the developed applications and interfaces
    Project management
    Analysis of source systems and interfaces
    Implementation of ETL processes from clinical and administrative source systems into the Clinical
    Datawarehouse (Caradigm Intelligence Platform)
    Technical specifications for data management and data warehouse applications and interfaces
    Programming and scripting with Microsoft .NET / ASP.NET / C# in Microsoft Visual Studio
    Writing complex T-SQL queries, views, procedures, triggers, and functions (MSSQL)
    Intensive use of database management and development tools incl. Business Intelligence (SQL Server
    Integration Services and SQL Server Reporting Services)
    Technical and use case documentation (security concept, operating concept, user manuals)
2015-2016
Healthcare Consultant
emineo AG
  • Key Responsibilities:
    Project Management and Consulting of Hospitals
    Analysis of clinical source systems and interfaces
    Technical implementation of interfaces, reports, applications / solutions for various clinics (traumatology,
    infectiology, emergency department)
Education
2022-Present
Certificate of Advanced Studies in Machine Learning
Swiss Distance University of Applied Sciences FFHS (Switzerland, Zurich)

Concepts of Machine Learning Technologies & Methodologies (Information Retrieval, Natural Language
Processing, Recommender Systems)
Classification of data (Naive Bayesfilter e.g. Spam-Filter, Decision Trees, Random Forests, Support Vector
Machines, Neural Networks)
Feature engineering and preprocessing of data

2022
Certificate of Advanced Studies in Big Data
Swiss Distance University of Applied Sciences FFHS (Switzerland, Zurich)

Concepts of Big Data Technologies & Methodologies (such as Apache Hadoop, Apache Kafka, Apache
Cassandra, Apache Solr, Apache Spark), NoSQL, Document Stores, Object Stores
Setup and Configuration of a small Big Data Cluster (Hadoop/YARN, Cassandra, Spark, Zeppelin) on a local
MacBook with Parallels and 5 virtualized Ubuntu Server machines.
Implementation of a real-time data stream from the Twitter API v2 with pyspark into a mongoDB to assess the
tweet behaviour during governmental, environmental, or social crises.

2012-2015
Bachelor of Science in Medical Informatics
Bern University of Applied Sciences (Switzerland, Biel/Bienne)
  • Computer Science, Statistics, Programming, Mathematics, Medical Terminologies and Classifications, Project
    Management, Ethics, Anatomy and Pathology, Hospital processes and patient pathways
  • Achievements:
    “Prix d’excellence” for the best degree “Silver” in 2015
    “Prix d’excellence” for the best concept in the bachelor thesis in supply chain management (medication)
Other Relevant Courses
2021
Performance Tuning and Optimizing SQL Databases (5 days)
Trivadis Training (Switzerland, Zurich)

Official Microsoft Course (M-10987)
Performance Monitoring, Scheduler, Wait Types, Indexing, Query Plan, Caching, Query Optimizing, I/O
Concepts, Concurrency, Transactions, Isolation Levels

2020
Leadership & Communication (7 days)
University Hospital of Zurich (Switzerland, Zurich)

Communication skills, pressure handling, conflict resolution, employee engagement, delegation, feedback culture, change management, resource/time/budget planning

2019
Implementing a SQL Data Warehouse (5 days)
Trivadis Training (Switzerland, Zurich)

Official Microsoft Course (M-20767)
Introduction to Data Warehousing, Planning / Designing / Implementing a Data Warehouse, ETL Solutions, Data Quality, Master Data Management, SQL Server Integration Services

2019
Nanodegree Data Analysis (2 months, 5-10 hrs/week)
Udacity (online)

Practical Statistics Apply inferential statistics and probability to important, real-world scenarios, such as analyzing
A/B tests and building supervised learning models
Data Wrangling, gathering, assessing, and cleaning data. Use of Python to wrangle data programmatically and
preparing it for deeper analysis.
Data Visualization with Python. Apply visualization principles to the data analysis process. Explore data visually
at multiple levels to find insights and create a compelling story.

2019
Nanodegree Data Streaming (2 months, 5-10 hrs/week)
Udacity (online)

Fundamentals of stream processing, including how to work with the Apache Kafka ecosystem, data schemas, Apache Avro, Kafka Connect and REST proxy, KSQL, and Faust Stream Processing
Build real-time analytics applications
Understand the dimensions of Spark streaming, ingest streaming data to Apache Spark Structured Streaming, and integrate Spark streams into Kafka

2018
Good Clinical Practice (3 days)
University Hospital of Zurich (Switzerland, Zurich)

• Concepts, principles, regulations, and guidelines for designing, conducting, and reporting (e.g., safety data, accrual reports, study status, protocol deviations, unanticipated problems, or final data) clinical trials and other clinical research projects.

Skills
Coding
  • C#/.NET
    90%
  • Python / Java
    85%
  • SQL
    100%
  • HTML / CSS
    75%
Knowledge
  • Data Processing
  • Data Streaming
  • Query Optimization
  • Python Services & Applications
  • ASP .NET Core Web Applications
  • Microsoft Business Intelligence Stack (SSIS, SSRS, Power BI)
Front-end
  • ASP .NET Core
  • ASP .NET
  • HTML / CSS / JS
Languages
  • German
  • English
  • French
Quote
I've missed more than 9,000 shots in my career. I've lost almost 300 games. 26 times, I've been trusted to take the game winning shot and missed. I've failed over and over and over again in my life. And that is why I succeed.
Michael Jordan
Michael Jordan
Basketball Player, Business Man, Role Model