- 2018 StrangeLoop Software With a Mission: From Coder to Bureaucrat (co-presenter)
- 2018 FiveCollege Stats and Data Science Research Bytes: Columnar Data Storage and the Separation of Compute and Storage
- 2018 Western MA Full Stack Meetup: The Humble Dataframe
- 2017 DATA Act Summit: Leveraging Technology to Modernize Government (panel)
- 2017 DATA Act Training: Why the DATA Act Matters: New Uses for Standardized Spending Information
- 18F Tech Talk: Data Munging With Python and Pandas
- 2014 NERD Summit: Intro to IPython Notebooks
- 2012 Association of Public Data Users: Transitioning to Open Government Data
- Wharton Computing Tech Talk: Elegant and Efficient Database Design
DATA Act: USAspending API
Led the buildout of an API that presents, for the first time, a unified view of U.S. spending data. In addition to being available for public use, the API powers usaspending.gov.
- Source code: https://github.com/fedspendingtransparency/usaspending-api
DATA Act: Data Model, Ingest, and Validation
Prototyped and served as the initial tech lead for the “DATA Act Broker,” a product that federal agencies use to submit and validate their spending data to the U.S. Department of the Treasury. Over a period of two years, the broker evolved from a series of Python scripts to a Jupyter notebook, and finally to a mature, API-driven data ingest site that performs hundreds of validations on incoming files and is used by dozens of federal agencies.
- https://broker.usaspending.gov/ (login required)
- Source code: https://github.com/fedspendingtransparency/data-act-broker-backend
Pandas is a powerful data analysis toolkit. But sometimes you just need a quick reference for doing common data cleaning and munging tasks.
Because a single source of federal spending data was not available back in 2015, I designed a website that pulled together many disparate data sources to tell the story of how federal dollars flow into and out of states. In addition to writing the narrative, I researched the best sources for the required information (making some hard decisions along the way) and coded the ETL (extract, transform, and load) needed to power the site.
- Source code: proprietary
Hack for Western Mass
The inaugural National Day of Civic Hacking happened in 2013. Rather than travel to New York or Boston to participate, I gathered a team of local technologists to organize our own Western Massachusetts-flavored hackathon. I served on the organizing committee in 2013 and 2014 before passing the torch.
Computers are for People
A technical blog that I haven’t updated in years. I keep it around as evidence that I can write. Some favorite (if somewhat dated) posts: