Hi there! Welcome to my website. My name is Han Zhang. I'm a data geek at heart and a lifelong learner. I earned a Master's degree of Computer Science from Bishop's University in Canada in 2020 and previously a Master's of Intelligent Transport Systems from Linköping University in Sweden. The fields I’m interested in including (but not limited to) data model developing & analytics, data engineering, business intelligence and machine learning. I started my work as an Enrolment Data & Process Analyst of the Registrar's Office at Bishop’s University (BU) in Feb. 2022.
Over the past 4 years at BU, academic data collection, cleaning, analytics and management have been key parts of my routine. I have contributd to several KPI analysis and reporting projects, including funnel analysis on # Applications-# Offers-# Enrollments; Graduation / Retention analysis; Admission Reporting; BCI reporting, etc. (by writing advanced formulas, pivot tables + VBA in Excel). In 2023, I participated in a project of RO to optimize the course withdrawn process. During this project, I self-learned the MS Power Automate, and I have contributed to optimizing the workflows by adding variables and conditions.
From Jul. 2024, I maintain and update a legacy faculty database of Business School and export the data to Power BI to create faculty reports. In addition, I have used Python to partially automate the work of unstructured data collection & transformation - traverse tons of documents such as course outlines in PDF or Word format in network drives, extracte the key wrods, then convert and save in Excel for further analysis. This saved me numerous hours of manual work.
In addition to the projects at my workplace, I’m also conducting my personal ones, for example, an ETL process for Job Market Analysis (RestAPI-SQL Server-PowerQuery-PowerBI); a live web traffic analytics by Google Analytics 4 & Looker Studio (Google Data Studio); and the DIY of this website. For more information about my other personal projects, please click here.
Canadian CS Teaching Experience
I was a computer science teacher at CDE college (now Cestar College) in Sherbrooke, QC, from 2020 to 2021. The courses I have given include:
- Older Operating System – a general introduction to the vintage OS (Windows XP), the file system, the CMD command line to manipulate the file system, and the batch file scripting.
- Application Software (MS Office) – a general guide to the basic functionalities and manipulations of the Microsoft Office suites, including the MS Word, Access (A demo database will be created and manipulated.), Excel (creation of formulas, pivot tables, basic Macros by VBA).
- Intro. to Databases – an introduction to the Database Management Systems (DBMS), especially the intro. to relational DBMS, the ER-Model, Schemas, various Keys, INNER JOIN, OUTER JOIN, etc. And the creation and manipulation of a sample database in MySQL by utilizing the DDL, DML and DCL of SQL.
- Programming Utility Software – It's a guide to the programming of basic utility software by Visual Basic, a simple app with UI will be made. This course will lay a solid foundation for those who will work in VBA.
- Computer Networking: Access Management & Resource Sharing – This course is an introduction to the computer networking in layered architecture, which includes the OSI model, the TCP/IP model, the protocols of each layer. Furthermore, the basic concepts and features of Server Roles, Domain Controller, Active Directory, Group Policy will also be touched. The Windows Server 2012 R2 will be installed in a virtual environment and be palyed around.
Canadian IT Experience
From the summer of 2019 to 2020, I worked as IT Service Desk Technician at CGI Inc. in Sherbrooke. My main job was to troubleshoot the issues of hardware (PCs, laptops, tablets, printers,etc.) and
software (more than 50% issues are related to Windows OS and utility software on top of Windows; around 20% issues are about VPN or banking software), and then created the tickets. The main tool we used back then was ServiceNow.