William Z. Email & Phone Number

Redmond, Washington, US

Gray Systems Lab (GSL)

San Francisco, California, US

- Designed and integrated external UDFs with batching support- Prototyped and implemented a buffer pool design with io_uring

· Investigated information schema query execution inefficiencies and bottlenecks through perf/flamegraphs· Implemented numerous information schema query optimizations (observing >100x speed-up on client queries)· Extended execution engine to support new query shapes against columnstore tables for a future release

Pittsburgh, PA, US

Santa Clara, CA, US

· Collaborated across 4 teams to gather and synthesize feature requirements within an Agile process· Revamped frontend and backend of Regression Farm to support new Test configurations and machines· Implemented in SQL critical farm-wide logic for matching Tests (based on requirements) to machines· Boosted performance and improved abstraction of the Farm’s.

• Primary Responsibilities and Contributions:
• Oversaw an agile development team responsible for a C-based OPC Unified Architecture (OPC UA) Server
• Guided the product from internal development to certifiable and marketable status with key design decisions based on potential clients' use cases.
• Directed development of a client-requested module that periodically updates application data with changes from external ODBC-supported databases, a module satisfying two requirements: (1) the updated application data.
• Introduced an application-wide database scheduler that preserves the order of scheduled tasks relative to database tables. The scheduler balances tasks based on nominal frequency supplied by the client in order to.
• Engineered an OPC UA compliant multithreaded historical data system capable of servicing read/update requests from OPC UA-related services, other system modules, and proprietary client logic. A rigorous test battery.

Pittsburgh, PA, US

• Primarily contributed to Personalized Privacy Assistant Project led by Professor Norman Sadeh within the Mobile Commerce Lab. The Personalized Privacy Assistant Project's goal is to research and develop an.
• Migrated from MEAN stack to a stack utilizing AngularJS, Django, and PostgreSQL in order to resolve critical issues pertaining to application security, application usability, user authentication schemes, and data.
• Suggested and implemented crucial features relating to the user interface and Django data model
• Introduced comprehensive unit and integration tests to facilitate regression testing and for quality assurance
• Assisted colleagues with migrating to Docker and deploying Docker containers
• Embraced an Agile Methodology to the development processSecondary Contributions:

• Primary Responsibilities and Contributions:
• Consulted and delivered to a Japanese elevator company an end to end solution for improving their data acquisition capabilities during elevator accidents.
• Implemented an iOS cloud application in Objective-C that generates corporate reports based on answers from a dynamic Q&A system. The application interfaces against an AWS EC2 server for user access control and.
• Tweaked UI specifications and reevaluated implementation to improve client satisfaction and resolve ongoing feature requests from the client
• Directed overhaul of server with addition of new features, such as faster insertion speed and transaction support
• Optimized data synchronization algorithm to reduce synchronizing 200,000 records from Oracle database to the mobile device from ~24 hours to ~30 minutes on an iPhone 5

Doctor Of Philosophy - Phd, Computer Science

Bachelor Of Science - Bs, Electrical And Computer Engineering

High School Diploma, High School/Secondary Diplomas And Certificates