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