Daniel Blanchard Email and Phone Number

• Developed new features for the Coiled platform and website• Implemented CI pipeline improvements to increase developer productivity• Worked to ensure code was of high quality and limit tech debt• Co-owned environment synchronization code• Provided insightful and detailed code reviewsNotable Achievements• Migrated CI from GitLab to GitHub with CIRun-powered runners, which unified dev experience and cut costs• Added support for ARM to our environment synchronization tool• Added support for inviting users to workspaces when creating accounts

• Debugged data quality issues for customers• Wrote and refined SQL queries for complex data analysis• Implemented new data analysis tasks working via Django and Celery• Provided insightful and detailed code reviewsNotable Achievements• Halved test runtime of CI system by improving dependency caching• Added support for custom SQL-powered reports to customer dashboards• Developed SQL for market basket analysis report that can scale to even our largest customers with many thousands of products and even more buyers

• Came up with company-wide guidelines for handling unicode names and addresses, and implemented those changes for membership code. Assisted other teams that ran into Unicode issues.• Served on the Python Language Council, which helped set Python standards for the company as a whole.• Contributed to efforts to migrate the membership team's code from the monolith to a service.• Helped improve team workflow through process improvement• Provided insightful and detailed code reviews

• Mentored other engineers• Fixed particularly elusive bugs relating to Python, Elasticsearch, Apache Storm, Kafka, and Cassandra• Ensured that technical debt does not build up• Helped improve team workflow through tool development and process improvement• Wrote exemplary Python code• Provided insightful and detailed code reviews• Lead development of major projects• Contributed to open source project development (e.g., streamparse and chardet)• Participated in on-call support rotation• Managed weekly software releasesNotable Achievements• Wrote Python tool to migrate over 63TB worth of partially source-less Elasticsearch data from 1.7 to 6.8, because there was no existing tool. This migration lead to AWS bill reductions of ~$120k per year, and saved months of compute time vs rebuilding the data from our raw logs.• Wrote Apache Storm-based web crawling system to replace older Scrapyd-based one. This lead to a significant reduction in crawl latency.• Migrated all of our existing Python code from 2.7 to 3.6• Wrote a tool to restore functionality to an Elasticsearch 1.7 cluster that failed in a very unusual manner with no noticeable data loss, ending a ~8 hour customer-visible outage.

• Mentored more junior employees• Fixed particularly elusive bugs relating to Python, Elasticsearch, Apache Storm, Python, and Cassandra• Ensured that technical debt does not build up• Wrote exemplary Python code• Provided insightful and detailed code reviews• Lead development of major projects• Contributed to open source project development (e.g., streamparse and chardet)• Participated in on-call support rotationNotable Achievements• Rewrote the system for generating our Audience Overview report to use Apache Spark instead of Pig. This project lead to greatly improved reliability and added the flexibility to generate historical data.• Refactored several Storm topologies to all read from a new preprocessor topology to cut down on duplicate work. This allowed us to reduce the size of the Storm cluster by 20%.• Wrote Elasticsearch-based webpage metadata store to replace an older one using Solr and MongoDB. This simplified the architecture by relying on a single data store, and allowed us to cut machine costs as well.

• Implemented ideas proposed by research scientists and conduct experiments in Python and Java.• Prepared research prototypes for use in production (especially for use with the e-rater essay scoring system).• Provided consultations with people inside and outside of the group on how to write elegant and efficient Python code.Notable achivements:• Lead major code modernization effort for the e-rater essay scoring system to use Apache Storm. This was particularly challenging as there were ~100 legacy modules written in Java, Perl, and Python that all had very different APIs.• Reduced running time of Washington State ProTeach Portfolio similar detection system from 3.5 days to 2 hours.• Lead development of SciKit-Learn Laboratory (SKLL), an open-source tool for simplifying the execution of common machine learning tasks with scikit-learn.• Overhauled/forked an existing open-source library for mapping Python code onto a DRMAA-compliant cluster to make it much more reliable and support Python 3.

• Implemented ideas proposed by research scientists and conducted experiments in Python and Java.• Readied research prototypes for use in production (especially for use with the e-rater essay scoring system).• Provided consultations with people inside and outside of the group on how to write elegant and efficient Python code.Notable achivements:• Designed the architecture and implemented the scoring methods for the scoring system for written items for the Test of English For Teaching• Co-invented a process for scoring short written items that allows for considerable response variation using context-free grammars.• Developed an efficient, parallelized system for response similarity detection for the Washington State ProTeach Portfolio program. • Helped design a unified architecture for preposition, determiner, comma, and hyphen error detection.• Developed a system for determining an author's native language based on English writing samples.

• Developed and maintained database and web management tools for assessment data.• Moved existing related websites to Drupal.

• Facilitated CISC 181: Introduction to Computer Science• Provided engaging learning opportunities for students to learn the basics of object-oriented programming in C++.

• Utilized insights from infant language acquisition research to improve unsupervised word segmentation models.• Maintained Phonology/Phonetics lab Mac OS X server and clients.

• Advised prospective undergraduate researchers and senior thesis candidates so that they successfully completed publishable research.• Developed a dynamic website in C#/ASP.NET that effectively processed student program applications, event administration, senior thesis review process, and user-created web forms.