Patrick Hirschi

Data Enthusiast

Software Engineer

Tech Lead

Patrick Hirschi

Data Enthusiast

Software Engineer

Tech Lead

Resume
Experience
2020 - Present
Team Lead Data Engineering
University Hospital of Zurich

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.

2018-2020
Datawarehouse Developer
University Hospital of Zurich

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.

2016-2018
Application Developer
University Hospital of Zurich

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)

2015-2016
Healthcare Consultant
emineo AG

Project Management and Requirements Engineering for Clinical Data Solutions. Programming and scripting with Microsoft .NET / ASP.NET / C# in Microsoft Visual Studio.

Education
2019-2019
Nanodegree, Data Streaming
Remote

Udacity

2019-2019
Nanodegree, Data Analysis
Remote

Udacity

2012-2015
Bachelor of Science in Medical Informatics
Switzerland, Biel/Bienne

Bern University of Applied Sciences

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
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