Analyst/Programmer
Department of Commerce, State of Alaska, Juneau Alaska

I am developing ASP.NET applications on Oracle databases, plus some maintenence programming in Oracle Forms and Reports, and classic ASP.

Senior User Interface Designer
Washington State Ferries, Seattle, Washington.

I did User Interface Design for a consolidated account management system, a new Web store, and a vehicle reservation system(VRS). My major tool was MS Visual Studio 2010. I developed a demonstration Web site based on HTML, CSS, JavaScript, and jQuery. Although there was no data access, navigation and forms worked, which allowed us to nail down work-flow and page layout.

I was an independent Web and database developer in the Seattle area. Besides ASP.NET and SQL Server projects I did a little Unix system work (not programming).

Senior Project Database Specialist
Golder Associates, Redmond, Washington.

Monitor Control System (MCS); Contract Compliance Application - Golder Associates
My most recent Web/database project includes managing field inspectors using laptops remotely, call center reporting, internal messaging and external email, document management of several varieties, task management, news, help, some GIS, and, of course, management reports. This application is being developed in ASP.NET 3.5. Currently there are over 200 forms and reports built on 63 tables. The database runs on SQL Server 2008. I am the designer and primary developer.

• The core system went production in June 2009 after twelve weeks of very intensive development.
• By fall 2009 another part-time team member had been added and a large number of reports, including maps with overlays had been implemented. Automatic email notifications were implemented at this time.
• By early 2010 management sections had been added for both the service providers being monitored and for the government oversight agency. Waste flow reporting was also implemented at this time.

Municipal Water Management System (MWMS) - City of North Bend, Washington
I designed and built a Web/database application to manage water production and purchase for compliance with required stream flows and municipal water rights. I worked with stakeholders and Golder water resources consultants to develop the list of requirements. The application automates the complex calculations needed to manage municipal water. Simple reports are provided for daily water system operations and more complex reports are provided for city management and other stakeholders. Developed in ASP.NET 2.0 with over 70 forms and reports built on over 30 tables. The database runs on SQL Server 2005. I am the sole designer/developer.

Global Acid Rock Drainage Guide (GARD Guide) - The International Network for Acid Prevention (INAP)
INAP is an organization of international mining companies dedicated to reducing liabilities associated with sulphide mine materials. Members: Anglo American plc, Barrick Gold corp., BHP Billiton plc, Freeport McMoRan Vale Inco ltd, Newmont corp., Rio Tinto ltd, Xstrata plc. I am the sole designer/developer.

The GARD Guide is a Wiki (MediaWiki which uses PHP and MySQL on BSD) with role based security for development of the guide. I formatted and entered most of the content. I trained editors in the use of the Wiki. http://www.gardguide.com

WRIA 7 Geographic Oil Spill Response Planning application
Washington State Department of Ecology - For the Snohomish River, Washington
I designed an oil spill response plan management application for the Snohomish River Watershed (WRIA 7) in Washington State. Up-to-date response plans including maps are available on the Web.

I worked with stakeholders and Golder consultants to collect information on the requirements for data storage and presentation; developed a database and a data management tool to allow for quick and easy updating of multiple geographic response documents; integrated the data management tool with a complex spatial Web site which allows the user to create a series of reports that contain the most recent oil spill response plan for a specific area, customized for current weather and stream flow level.

I managed design, construction, and deployment of the underlying database, and did most of the database programming. Another developer did the GIS/Web programming. This application is built on SQL Server 2005 and ESRI ArcGIS Server 9.x. This front end section of the application is in Microsoft Access 2003.

Facility Information System (FIS) - Republic Services, Phoenix, Arizona
I added maps based on Web services to the existing FIS application. I added a module for managing the transfer of surplus equipment between business units. I added a news article publishing module to the FIS Web site. I upgraded compliance tracking, expenditure approvals, and project management.

Environmental Compliance Assurance Review (ECAR) - CSX Transportation, Jacksonville, Florida
I added maps based on Web services to the existing ECAR application. I improved email notifications for project management and compliance monitoring.

EDI (Electronic Data Interchange) invoice development using Microsoft Access, SQL Server stored procedures, and Gentran: Director. (810, 880, v4010, v5010)

I was chief database specialist for a data cleaning project that included database development, analysis, and programming. I used SQL Server 2000, Enterprise Manager, Query Analyzer, and Microsoft Access 2003. I wrote SQL scripts and DTS packages, and documented the use of the scripts and packages for the analysts.

I was an independent Web and database developer in the Seattle area. I created one new 200+ page bilingual Web site for Sea Mar Community Health Centers and did a couple of Web site rebuilds on sites I had originally created: Austrian Ballet Company - Tokyo and Austrian Ballet School - Tokyo.

I developed database applications for Juvenile Justice in the Department of Health and Social Services, State of Alaska in Juneau, Alaska. As an Analyst/Programmer IV I was involved in the entire development process, from building a business case to maintenance.

My first task at Juvenile Justice was to provide support for the rollout of a new statewide client tracking system. I created a Web/database application to track training and certification for 400+ staff, and created a Wiki to post answers to trainees questions.

Other projects completed at Juvenile Justice:

• An online application that assesses accused juvenile offender for secure detention based on data from the client-tracking database. Details are displayed, scores are saved and reports can be printed.
• A set of applications to track staff information for budgeting, communications, and training.
• A complete redesign of the DJJ Web site: http://www.hss.state.ak.us/DJJ/

I was an Analyst/Programmer working with Visual Basic and SQL Server, and ASP Web pages using IIS and SQL Server.

Two of the applications I created combined display of file-system image files with display of related database records.

I taught Visual Basic and database design.

Analyst/Programmer IV for the Division of Administrative Services of the Alaska Department of Environmental Conservation.

SQL Server, IIS, and ASP Web pages, Visual Basic, JavaScript, CSS, HTML, and SQL.

I created a prototype Web enabled data warehouse with 33 SQL Server tables and 35 forms. The final application was designed to provide a gateway to the databases of seven internal DEC programs.

Microsoft Office application VBA programming, training, and consulting, Web site design, construction, and repair, SQL Server and Microsoft Access database applications, technical writing, document preparation, and computer graphics.

I was an instructor at the non-profit Alaska Vocational Institute, Juneau, Alaska. I taught computer applications, and installed, maintained, and administered a Novell 4.1 network, a Microsoft network, and a leased line 56k TCP/IP link to the Internet. Some of my classes were taught in a standard classroom, some were taught in a maximum-security prison.

I was Coordinator (Director) of the Western North Carolina Library Network, Appalachian State University, Boone, North Carolina. I administered a library computer department serving five libraries on three university campuses.

I maintained an LS2000 Data General system, while coordinating the design, procurement, installation, and migration to a new system running INNOPAC under UNIX on a DEC Alpha computer. I was responsible for adding a Web interface to the specifications for the new library systems.