- 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)
Patrick Hirschi
Data Enthusiast
Software Engineer
Tech Lead
Resume
Experience
2020 - Present
Team Lead Engineering – Clinical Data Platform for Research
University Hospital of Zurich
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#/.NET90%
-
Python / Java85%
-
SQL100%
-
HTML / CSS75%
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
Basketball Player, Business Man, Role Model