MapLight, Berkeley, CA - 5/2011 - 6/2018 - Systems and Database Administrator, Developer

Sets up and maintains servers and services. Design, develop and maintain databases, applications, and internal process scripts.

• Designed, developed and implemented an in-house system for researchers to work with various databases and to manage many internal reports and scheduling of the data processing saving hours of technical team development and creating the ability to generate just in time delivery of reports for the research department.
• Built an in-house system to help keep the software development flow in order and easier for various developers to manage their changes saving many hours of developer time and allowing for less queuing and wait time for code pushes.
• Developed a PHP/MySQL/JavaScript/HTML/CSS3 application used by the State of California for searching and accessing millions of candidate contribution records.
• Analyzed a variety of large data sets and designed large, relational databases to easily manage, access and develop from data sets containing millions of records.
• Collaborated to create both user and technical specifications for technical projects within the organization.
• Worked in all areas of the technical department from user support to full stack development.

National Institute on Money in State Politics, Helena, MT - 12/2000 - 4/2011 - IT Director, Developer

Developed and maintained all data applications in the organization. Developed and managed external website along with a suite of in-house tools for researchers to manage a large dataset of campaign finance data from all 50 states.

• Analyzed campaign finance data from dozens of different sources and created a large MySQL relational database to manage tens of millions of records with millions of new records added each year and thousands of daily changes.
• Developed an in-house web based system for researchers to group and edit this large database from a variety of different computers as both PCs and Macs were used by office personnel increasing greatly increasing their efficiency and "turn around" times.
• Developed the dynamic side of their website with PHP and SQL queries from a set of static html and css files which had been designed by an outside firm.
• Designed and developed a series of public REST API methods with a variety of security controls and limitations and internal user administration system.

Project Vote Smart, Corvallis, OR; Boston, MA; Philpsburg, MT - 2/1992 - 11/2000 - IT Director, Developer

Developed the company's first in-house program enabling phone operators to look up data and grew it into a full-featured website with a large data management system.

• Designed and developed an internal data management tool that allowed dozens of volunteers to maintain an extensive database on thousands of politicians in all 50 states, making this information available to voters.
• Drove the organization's move to an online presence and continued that growth through rapidly changing technologies.
• Developed a full membership and donation tracking system for their nearly 50,000 members.
• Served on the board as a member of the Executive Committee from March 2000 until December 2006.