Bill Zhang Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

- Helped setup a new data pipeline to leverage airflow to transform, normalize, and validate (TNV) hundreds of GB of supplier data using a variety of Google Cloud Platform tools (from an existing pub/sub model). Tools used include Container Registry, Composer, Cloud Storage, Kubernates Engine, and Compute Engine.- Set up and documented a unit testing environment for DBT (SQL data transformation library) models, which found numerous bugs in the current data pipeline.- Developed data flow diagrams to visualize the current data pipeline and highlighted areas of improvement and concern.- Wrote and edited hundreds of lines of SQL for data transformations, in (1) original code and (2) converting BigQuery code to PostgreSQL.

San Francisco Bay Area

- Migrated of data from Google's Firebase DB to MongoDB. - Helped captain planning through information revealed from querying NoSQL and SQL DBs, and set up REST API endpoints for easy access of data.- Performed analysis in Jupyter of the referral system to unravel and flag dishonest uses and analyzed tens of GBs of text to find patterns in errors and uncover its causes.

Toronto, Ontario, Canada

- Queried Snowflake data using SQL to generate features from hundreds of millions of rows of driver data, and used Jupyter to discover insights from such data. - Built dashboards in Power BI reflecting project findings for the business team, allowing easy comprehension of technical material for all audiences.- Shared Scrum Master duties in an Agile work environment through coordinating Sprint Review and Backlog Refinement.

Gatineau, Quebec, Canada

- Researched graphs, proposed ideas, wrote, and ultimately presented to our federal branch’s Deputy General a pipeline in Python and other free-to-use software that visualizes the patent landscape of different fields.- Streamlined time needed to clean hundreds of thousands of records by several days by producing a script that identifies and groups all variations of an institution’s name from patent data using ML and fuzzy matching in Python.- Wrote a web-scrapper for (1) the European Patent Office’s website, and (2) the Canadian Federal Employee Database, to efficiently gather huge amounts of data on workshop attendees.

- Tutored foundational CS concepts in Racket for CS115.- Wrote and ran scripts that automated evaluation of students' code.- Made and presented course materials in weekly labs.- Managed and updated the course website using HTML.- Coordinated a team of graduate student markers in weekly marking meetings.

- Communicated daily with hundreds of potential and existing clients to create long-lasting professional relationships.- Managed a custom apparel business working with clubs and organizations at UofT and UW campuses.- Analyzed market situations, and adjusted strategy and priorities accordingly- Accrued thousands of dollars in sales.- Daily use of excel tools to organize client data and maximize revenue.

- Handled daily shifts in a very high pace environment.- Interacted with customers, persuaded them to play in games.- Worked with money, kept track of each player's tab. - Cleaned up game booth, took note of inventory.

Master Of Science

Bachelor Of Mathematics

Ontario Secondary School Diploma