William Hammond Email & Phone Number

Working on online services, game client integration, internal LiveOps tooling, and a smidge of console porting and netcode for Glowmade's title King of Meat

Seattle, Wa, Us

I worked on a competitive multiplayer game where I primarily contributed to systems that bridged the game client to the online services. Along with the technical work, I helped players through play tests, and contributed design feedback during weekly tests.All of the systems has been alpha tested by players, and mostly stressed tested in a controlled environment for up to 10,000 concurrent players.Primary Projects- Fixing a variety of issues that AOT compiled IL2CPP code has with serialization- Steam Rich Prescence features, like knowing if a friend as waiting in a queue- Player Inventory system to handle player stats, battlepasses, and unlocked content- Roslyn Analyzer to detect missing instantiated JSON serializers to prevent AOT issues- Forked Microsoft’s BitArray class to expose the underlying bit array for more performant serialization- Tooling to run unit tests against a full Unity build- Tests that integrated our game servers to our live service- Wrote the initial Orleans Hub to connect our game server to our live serviceI also worked on a lot of smaller fixes and improvements like - More graceful error handling for our ErrorBox UI- Improved error handling through more consistent use of CancellationTokens throughout our APIs- Fixed issues in the build pipeline- Fixed issues with our Auth client

I'm studying different computing problems, primarily game development, language design, and lower-level programming. You can take a look at my progress here https://www.williamhammond.me/portfolio and here https://github.com/williamhammond/

Cambridge, Massachusetts, Us

Embedded as an individual contributor on the Application Platform team. The App Platform team is responsible for the the core Users service, Portals service, supporting jobs and metadata for the those services, and some auth infrastructure including authorization filters and scopes.

Cambridge, Massachusetts, Us

I led a small (2-4) person team to enforce automated financial compliance using automation and tooling built on internal user feedbackBeam: A distributed financial logging tool that consolidated financially impactful logs from dozens of services to S3 to query using Athena. Beam ingests millions of logs per day while providing near real-time access. The architecture of Beam allows it to be easily queryable for HubSpot's billing team engineers and finance and compliance officers. It also provides for easy real-time export to other security tools. Finally, Beam can automatically detect what services need installed and automatically alert the team.Hawkeye: A discrepancy tracking tool that compares HubSpot's internal billing data to third-party systems like Zuora and Netsuite. Hawkeye allows analysts to investigate discrepancies and track the progress of remediations and acts as a source of data for automated tests. Review Bot: A set of https://semgrep.dev/ jobs that run at the time of a pull request to flag potentially financially impactful PRs for extra review. Billing System Registry: A simple service that tracks teams, endpoints, and services that should fall under the scope for compliance tooling. Multiple other compliance-related teams use this as a source of truth for what to be audited.FinAuth: An authorizer filter that allows System Analysts to get temporary access to sensitive endpoints using an approved Jira ticket.Hublets: Outside of regular team work, I led the FinTechs's group migrations to multiple datacenters. This was a smaller part of an engineering-wide effort. Some responsibilities included leading the discovery and design of architectural decisions the FinTech teams would have to make, giving updates on project status, pulling in non-engineering stakeholders, keeping the work focused and on schedule, and acting as a source of knowledge.

Cambridge, Massachusetts, Us

Billing Security and Compliance

New York, Ny, Us

Core Infrastructure:LDAP: I developed tooling to improve LDAP and aided in the architecture of LDAP.URL Shortener: Developed an internal URL shortener used throughout the company.DNS: Migrated environments off of Bind DNS to Power DNS.Security: I identified and solved a bug that caused internal credentials to be indexed in an Elasticsearch instance.Data Infrastructure:Kafka: Owned architecture decisions, developing tooling, and was the primary source of information for Apache Kafka.Kafka Cross DC Replication: Developed basic unidirectional cross datacenter replication for Apache Kafka.Monitoring: I deployed initial log ingestion and generic monitoring for Redis, RabbitMQ, Kafka, and Couchbase.Administration: I contributed to a 24/7 on-call schedule for every data system at Squarespace.Stewardship: Elicited feedback from product developers to improve infrastructure using surveys and by giving presentations in internal tech talks and round tables with product developers.Performance: I investigated and solved an issue where cache servers were deployed with a broken network interface. The root cause of this issue was unclear and would lead to frequent large response time spikes from Squarespace's origin servers.

Rochester, Ny, Us

Graded and tutored students in a Data Mining course that covered advanced statistics, agglomerative and hierarchical clustering, basic machine learning, data cleaning, data ethics, feature reduction and linear regression.

Rochester, Ny, Us

Computational Biomedicine LaboratoryApply statistical methods to better understand the electrophysiology of arrhythmic hearts. Wrote and maintain computational models of the heart. Primary Technologies: R, C++, Fortran, Matlab

Cambridge, Massachusetts, Us

Worked on the Data Infrastructure team focusing primarily on Apache Kafka by writing tools to automate operational tasks, patching and developing in-house Kafka build, and doing ad-hoc operational tasks.KafkaTasks: A service that safely automated tasks like rolling restarts by using Monit to make API calls to instances while considering performance statistics and the state of the cluster.Point-in-time Indexer: Worked around a bug in Kafka 0.8 where a feature to reset a consumer to a particular point-in-time would use the log file mtime rather than the time the log segment was produced to reset the offset. This led to the Kafka API resetting the offset to an earlier offset than intended in sufficiently large Kafka deployment. Our system indexed Kafka message offsets in Hbase and their creation time.Cleaner Kafka Bootstrapping: Improved ansible provisioning of Kafka to make new instance provisioning lower touch.MySql Linter: A framework lint MySQL queries for common mistakes. I could only partially get started on this before my internship ended.

Nashville, Tn, Us

Built data visualization of voter campaign finance data to help voter better understand where candidates funding comes from. I took data from its raw form, cleaned it, transformed it and then visualized it. Other duties include writing scripts that are used to ingest voter file data into databases.Primary Technologies: Javascript, D3.js, Angular.js, R, Python, MongoDB

Rochester, Ny, Us

Worked March 2014 - May 2014Maintained Linux systems used for researching the streaming of high resolution video in a research environment.Primary Technologies: Bash, Python

Victor, Ny, Us

Designed and developed in-house framework used for automated web GUI and web service testing. Logged application bugs and solved framework bugsPrimary Technologies: C#, .NET