image
Patrick Hirschi
Data Engineer
Backend Developer
Medical Informatics Enthusiast

Patrick Hirschi

Download CV

What I Do

Networking

Always keen to meet new interesting people to discuss business ideas especially in the medical informatics area.

Consulting

Technical Consulting regarding all aspects around databases, datawarehouses and corresponding services.

Blogging

Love to share ideas, thoughts and knwoledge through illustrative blogposts.

Coding

Got an interesting project and need implementation help? Please contact me.

Testimonials

Resume

5 Years of Experience

Experience

2020
University Hospital of Zurich, DFL-IT

Team Lead Engineering DFL-IT

  • Team Lead for five data engineers and five virtual employees
  • Deputy Platform Responsible Clinical Data Platform
  • Deputy Domain Architect Data at USZ
  • Member of the hospital-wide expert panel for clinical and research projects
  • Responsibility and decision-making competence regarding methodology, technology and architecure of the data platform and its underlying data lake, databases, and data marts as well as the data integration layer, especially the ETL processes from clinical and administrative source systems to the Research Datawarehouse and the subsequent encoded and encrypted transfer of health-related data to SPHN (Swiss Personalized Health Network) and internal researchers

2019
University Hospital of Zurich, Research Data Services Center

Clinical/R&D Data Platform Specialist

  • Member of the hospital-wide expert panel for clinical and research projects
  • Responsibility and decision-making competence regarding methodology, technology and architecure
  • Architecture, development, maintenance and administration of the platform and its underlying data lake, databases, and data marts as well as the data integration layer, especially the ETL processes from clinical and administrative source systems to the Research Datawarehouse and the subsequent encoded and encrypted transfer of health-related data to SPHN (Swiss Personalized Health Network) and internal researchers
  • Intensive use of database management and development tools incl. Business Intelligence (SQL Server Integration Services and SQL Server Reporting Services)
  • Programming and scripting with Microsoft .NET / ASP.NET / C# in Microsoft Visual Studio
  • Ensure the conformity of enterprise data protection to the corresponding laws (e.g. human research act)
  • Provide domain expert guidance and specialist technical support to users in the research domain, who include data science specialists, data analysts and the wider business such as physicians, nurses and data managers
  • Manage capacity and workload of the shared data platform, including planning for additional large data sources, and their impact on any underlying infrastructure

2018
University Hospital of Zurich, Research Data Services Center

Datawarehouse Developer

  • Architecture, development, maintenance and administration of the platform and its underlying data lake, databases, and data marts
  • 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
  • Intensive use of database management and development tools incl. Business Intelligence (SQL Server Integration Services and SQL Server Reporting Services)
  • Programming and scripting with Microsoft .NET / ASP.NET / C# in Microsoft Visual Studio -- Toolset for automated data encryption and delivery with PGP and LiquidFiles
  • Support the technical development and evolution of master and reference data models for specific data domains
  • Technical and usecase documentation
  • Ensure the conformity of enterprise data protection to the corresponding laws (e.g. human research act)
  • Provide expert guidance to users in the research domain, who include data science specialists, data analysts and the wider business such as physicians, nurses and data managers
  • Provide specialist technical support to physicians, data managers, data scientists and data analysts in the use of the securely shared data sets
  • Manage the configuration of the data platform and any changes required
  • Manage support and development activities with the software suppliers
  • Manage capacity and workload of the shared data platform, including planning for additional large data sources, and their impact on any underlying infrastructure
  • Provide technical support in cataloguing of data sources

2016
University Hospital of Zurich, Clinical Data Management

Application Developer

  • 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 datamanagement and datawarehouse 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 usecase documentation

2015
emineo AG

Healthcare Consultant

  • Project Management and Consulting
  • 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 datamanagement and datawarehouse 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 usecase documentation

Education

2019
Udacity

Nanodegree, Data Streaming

  • Fundamentals of stream processing, including how to work with the Apache Kafka ecosystem, data schemas, ApacheAvro, 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

2019
Udacity

Nanodegree, Data Analysis

  • Questioning, wrangling, exploring, analyzing, and communicating data
  • Use of Python libraries like NumPy, seaborn, Pandas and others
  • 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

2012-2015
Bern University of Applied Sciences

Bachelor of Science, Medical Informatics

  • Informatics, Statistics, Programming, Mathematics
  • Medical Terminologies and Classifications
  • Hospital processes and patient pathways
  • Organisation of hospitals
  • Quality and project management
  • Ethics and law
  • English and French focused on the healthcare environment

Tool Skills

SQL Server Management Studio

100%

Microsoft Business Intelligence Suite (SSIS / SSRS)

95%

MS Office

95%

Microsoft Visual Studio

95%

Oracle SQL Developer

80%

Oracle Data Integrator

50%

Coding Skills

MSSQL

100%

Microsoft .NET / C#

90%

HTML / CSS

80%

JavaScript

75%

PHP

70%

Java

70%

Python

60%

Portfolio

My Works
freizweit.

freizweit.

Leisure
Udacity – Data Analysis

Udacity – Data Analysis

Education

Blog

My Diary

Contact

Get in Touch

Dübendorf

mail@patrick-hirschi.ch

Freelance Available

How Can I Help You?