
Bill Yang
Verified Expert in Engineering
Database Analytics Developer
New York, NY, United States
Toptal member since January 17, 2017
Bill is an expert in large-scale distributed systems and data analytics, with a wide range of experience ranging from web startups to consulting and enterprise to some of the biggest names in tech. Some of his work became part of the backbone supporting platforms like DoorDash and YouTube.
Portfolio
Experience
- SQL - 10 years
- C# - 8 years
- Database Analytics - 6 years
- Distributed Systems - 5 years
- NoSQL - 3 years
- Python - 3 years
- C++ - 2 years
- Node.js - 2 years
Availability
Preferred Environment
Node.js, Python, C++, C#
The most amazing...
...project I've built is a dynamic delivery fee model while working at DoorDash, that increased the company's revenue by 5% —around 100 million at the time.
Work Experience
Senior Software Engineer
- Worked on a database query engine powering YouTube Analytics, one of the largest analytics databases on the planet, to the tune of multiple exabytes.
- Improved predictability of query performance and overall system utilization by introducing dynamic throughput management to the query engine.
- Introduced automatic client usage attribution, which helps the company better manage its compute budget.
Senior Software Engineer | Tech Lead
DoorDash
- Led a cross functional team to expand restaurant availability via dynamic delivery fees, which ultimately led to a 5% or over $100 million increase in revenue by the end of 2020.
- Worked closely with several other technical leads to design our new microservice architecture and resolve cross-team architectural issues.
- Led several technical projects extracting various pricing logic from our Python and Django monolith into a new Kotlin and Kassandra-based service, forming a new engineering team around this new domain in the process.
- Led several other pricing-related projects to support more flexible pricing adjustment for both driving volume and response to regulatory changes.
Senior Software Engineer
TuneIn
- Took part of the team responsible for the majority of our core back-end platform, including systems powering homepage, search, player, and other content-related functions.
- Led a project from ideation, getting support to completion to improve homepage recommendations, resulting in a 3% increase in conversion.
- Investigated and mitigated distributed hacking attempts.
Lead Developer
Clevertech
- Created a message-processing system that can scale to millions of messages per day.
- Migrated our message queue technology from Azure MQ to Amazon SQS.
- Worked on a related front-end application based on React and Electron.
Senior Developer
Alberta Ministry of Education
- Developed a curriculum development application using Angular, C#/.NET, and SQL Server.
- Resolved various performance issues—primarily related to search and querying complex data.
- Participated in the Agile transformation of the team and the department.
Solution Consultant
DevFacto Technologies
- Delivered consistently successful software projects, sometimes under pressure.
- Provided technical advice to the clientc.
- Advocated engineering best practices like Agile to client teams.
Software Developer
Upside Software
- Developed new features and maintained the existing code base with a million lines of code.
- Provided technical support to implementation teams.
Programmer
Idea Market Design Inc.
- Developed new websites in the Joomla! Framework.
- Managed the Linux servers at the company and for some of our clients as well.
- Worked on a data gathering/processing initiative.
Programmer
Seneca College
- Patched an open source network tool for a specific security problem that we faced.
- Developed a project management website.
- Managed server farms and wrote the corresponding documentation for them.
Experience
Time Tracker
Curriculum Development Application
- Improving performance of a very complex search functionality.
- Creating a separate public-facing application to allow staged content publishing and a higher-performance consumer app.
- Modifying a TinyMCE editor to support math symbols.
Main technologies used: C#, AngularJS, SQL Server.
Shipping Middleware
My primary contributions include:
- Scaling the system to handle millions of messages per day.
- Migrating our message queue technology from Azure MQ to Amazon SQS.
- Tune-logging to find the optimal point for debugging and performance.
- Diagnosing some product issues under pressure.
- Mentoring other developers on the team.
- Managed client inquiries and requirement changes.
Main technologies used: Node.js, Microservices, Azure Message Queue, AWS SQS.
Google AI Challenge | Ants
https://github.com/analyst74/aichallenge-antsMain technologies used: Python, Numpy, Cython, Algorithms Design.
Soccer Field Search
https://github.com/analyst74/rec-searchMain technologies used: Node.js, MongoDB.
Construction Document Management System
Main technologies used: C#, SharePoint.
Upside Contract
Main technologies used: C#, SQL Server.
Education
Diploma Degree in Computer Programming and Analysis
Seneca College - Toronto, Canada
Skills
Libraries/APIs
Node.js
Tools
Git
Languages
SQL, Python, C#, JavaScript, C++
Storage
Elasticsearch, NoSQL
Paradigms
Microservices Architecture, Concurrent Programming
Other
Distributed Systems, Database Analytics
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring