Texas Legislative Council
Did various tasks related to redistricting for the Texas Legislature. Did various tasks related to redistricting for the Texas Legislature. From 1999 to 2007 supervised transition from a Unix/AML based system for maintaining GIS data as coverages to a more modern system that stored the data in ArcSDE-enabled databases and which used Microsoft SQL Reporting Services (SRS) for reporting. This involved converting thousands of lines of Arc Macro Language (AML) scripts to Python which could be used in ArcGIS server as geoprocessing tools. Since 2007, enhancing and expanding systems to add mobile interfaces, and using service-based architectture whereever possible.
Designed and coded systems that use GIS technology to draw legislative districts, and provide statistics and reporting about those districts. Publicly facing projects include District Viewer (http://gis1.tlc.state.tx.us/) and Who Represents Me (http://www.fyi.legis.state.tx.us/Home.aspx). Architected and was lead programmer for the application that the Texas Legislature used to draw districts in 2011.
Comfortable with mentoring and leading team members using Agile methodology, including automated testing, scrum, and continuous integration. Knowledge of Microsoft C#, SQL Server, various scripting languages, including Python and SAS. Extensive knowledge of GIS technology including ESRI ArcGISServer, ArcSDE, and Open Source GIS tools. Retired on October 1, 2013.
Winner of 2013 ESRI SXSW Hackathon (http://www.esri.com/events/sxsw) where my team wrote a location-aware mobile app to warn users when they approached a location with a registered dangerous dog.