SQL
SQL (Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS). It is used to perform tasks such as retrieving, updating, inserting, and deleting data from a database. SQL is also used to create and modify database structures, such as tables, views, and stored procedures. It is a powerful language that can be used to query, analyze, and manipulate data.
Projects (22)
Denver Schedules API
2014, Contributor
JSON API that provides access to Denver activities that impact the residents of Denver.
Alaska Gasline Development Corporation
2013 – 2014, Technical Lead
Web application that provides Alaska Gasline Development Corporation (AGDC) with documentation, reporting, and querying tools for their vast GIS data and infrastructure.
Please
2012 – 2014, Author
Please is a set of commands useful for maintaining software projects.
AHFC Integration
2013, Technical Lead
Backend services that integrate Alaska Housing Finance Corporation (AHFC) datasets with the Alaska Energy Authority (AEA) datasets.
Systems Portal
2013, Technical Lead
Internal web application for tracking data used by Resource Data, Inc. (RDI) systems administrators.
Energy Efficiency Map
2012 – 2013, Technical Lead
Web application that allows the Alaska Energy Authority (AEA) to monitor and administer data from their statewide energy saving programs.
ScrambleScore
2012 – 2013, Project Manager
Mobile web application that allows golfers participating in scramble golf tournaments to record their scores and monitor the tournament leaderboard.
Scrum Tools
2012 – 2013, Technical Lead
Internal project management tool with iteration-based, story-driven agile planning and tracking.
Quality Bank
2010 – 2012, Technical Lead
Rewrite of the Trans-Alaska Pipeline's $1B/month invoicing system, treating business rules as versioned data to give the client full control over constant, retroactive changes.
Consumption Views
2009, Lead Developer
Comprehensive set of database views that provide water consumption information that feeds into reporting tools used by Anchorage Water & Wastewater Utility's (AWWU) to make business decisions.
Service Order Mobile Dispatch
2009, Technical Lead
Mobile web application that allows Anchorage Water & Wastewater Utility service workers to query and record service information while in the field.
AWWU Database Synchronization
2008, Technical Lead
Backend service that synchronizes Anchorage Water & Wastewater Utility's (AWWU) Oracle databases to provide redundant data for reporting and analysis.
AWWU Intranet
2005 – 2008, Technical Lead
Web application that contains Anchorage Water & Wastewater Utility's (AWWU) reporting and querying tools, systems status, and custom applications.
SAR Reports
2007, Lead Developer
Custom reports built from synthetic aperture radar (SAR) datasets.
TrainBuilder
2007, Developer
Windows Presentation Framework (WPF) application used by the Alaska Railroad to plan and schedule structure of their trains.
CIS Data Capture
2006, Technical Lead
Console application that captures monthly snapshots of Anchorage Water & Wastewater Utility's (AWWU) customer information system (CIS) data and loads it into a data warehouse.
AWWU Job Scheduler
2005 – 2006, Technical Lead
Framework for creating background processing jobs that migrate, synchronize, and transform data throughout Anchorage Water & Wastewater Utility's (AWWU) integrated systems.
AWWU Systems Integration
2005 – 2006, Technical Lead
Backend services that integrate Anchorage Water & Wastewater Utility's (AWWU) customer information system (CIS) with other internal systems.
Employee Suggestions
2005, Lead Developer
Oracle Forms application that allows Anchorage Water & Wastewater Utility's (AWWU) employees to submit suggestions for improving the AWWU workplace.
SIF Agent
2004 – 2005, Lead Developer
State of Oklahoma's first Schools Interoperability Framework (SIF) compliant reporting agent, securing our company's position as the dominant market provider for over 500 school districts.
Wen-GAGE Accounting
1999 – 2004, Lead Developer
Suite of desktop applications used by schools in Oklahoma to manage all their school accounting responsibilites.
Wen-GAGE Student Information
1999 – 2004, Lead Developer
Suite of desktop applications used by schools in Oklahoma to manage their student information such as enrollment, attendance, and grades.
Jobs (3)
Independent Programmer and Consultant
2014 – present, Independent Programmer and Consultant
Independent Programmer and Consultant, building next-generation education technology and partnering with select clients to architect high-impact software solutions
Resource Data, Inc.
2005 – 2014, Technical Lead
Technical Lead for Resource Data, Inc. (RDI), a consultancy specializing in custom database, web, and GIS programming services
Municipal Accounting Systems, Inc.
1999 – 2005, Lead Programmer
Lead Programmer for Municipal Accounting Systems (MAS), a leading provider of student information and accounting software for school districts throughout Oklahoma