Daniel Hou Email & Phone Number

Vancouver, British Columbia, Canada

• Regularly maintained the ETL pipeline scraping data from various multinational retail corporations for 20+ clients and transforming it into Alloy’s data model stored in BigQuery using Python.• Worked closely with the client-solutions team to design, build and/or reimplement 30+ scrapers and extraction models for the ETL pipeline using Python’s Selenium, Requests, Pandas, and built-in libraries.• Identified and implemented enhancements to the data pipeline, from more accurate detection of erroneous files based on file size, format, content, and encoding to optimized usage of Google’s geocoding API using Python and Java. • Increased the traceability of scraped files by automating the assignment of data sources to each file using Python’s SQLalchemy, and PostgreSQL.• Experienced working with SFTP, Electronic Data Interchange (EDI), React, Google Cloud Platform (GCP), and Jenkins.

Implemented new features and performed maintenance on HEPS (Healthcare Equipment Planning System), Navidata’s custom-built equipment tracking software and database infrastructure built using JavaScript, TypeScript, SQL, Vue.js, and Node.js and hosted on Microsoft Azure based on client requirements.• Designed new webpages and features utilizing RESTful APIs and stored procedures s to performCRUD (create, read, update, delete) operations on the Microsoft SQL Server Database.• Successfully integrated user permissions into the web application controlling the visibility and access of features and web pages.

Vancouver, British Columbia, Canada

Worked on a research project for the UBC Natural Language Processing Group exploring different methods of visualizing Transformer Neural Network predictions on long documents (1500+ words). - Designed novel visualizations to help interpret machine learning model behaviour using Matplotlib, Plotly, and Pandas.- Adapted and modified existing visualization methods designed for small documents to handle visualizations on long documents- Trained state-of-the-art Transformer Neural Network models for long document text classification using the Pytorch framework on custom datasets made using Pandas.- Followed software development best practices through proper maintenance, documentation of code and version control.

Vancouver, British Columbia, Canada

• Assisted with two unique sections of COGS 401, a seminar-based course exploring the applications of Cognitive Systems in industry and research. • Helped with lesson planning and organizing relevant documents for both sections respectively.• Aided the professor in each section with grading a variety of assignments (essays, video projects, presentations)

Richmond, British Columbia, Canada

- Assisted customers by finding items quickly.- Rotated grocery products ensuring that expired or spoiled items were immediately removed and adhered to the "first in, first out" rule.