Conrad E. Muller
11614 40th Ave. South
Tukwila, WA 98168
206 388-6053
Email: conrad at databasezone dot com
http://www.databasezone.com
I have been in the computer field since 1985. I have developed Web/Database applications since 1995. Previous to that I was an independent consultant, managed university library automation systems, developed and ran university computer teaching labs, and taught computer applications and programming.
Qualifications
- Fifteen total years creating database applications including data conversion and data linking, queries, and reports.
- Nine years designing, building, and maintaining SQL Server databases, as well as designing, building, and maintaining ASP.NET, ASP, Access, and VB clients. Maintaining databases using SQL, and VBScript.
- One round of annual statistical reporting for the Alaska Division of Juvenile Justice. I was covering the Research Analyst position in addition to my development work.
- Ten years teaching the use and programming of Microsoft Access and Office applications, and database theory and practice, part time.
Platforms and Languages
- SQL Server Management Studio: Create databases (tables, views, stored procedures), Optimize databases (keys, constraints, indexes)
- Microsoft Visual Studio: ASP, ASP.NET, HTML, CSS, VB, C#, JavaScript
- Visual Basic, Microsoft Access
- Dreamweaver: HTML, CSS, PHP, JavaScript
Tools
- SQL Server Management Studio
- Microsoft Visual Studio
- Iron Speed Designer
- Adobe CS3: Acrobat, Dreamweaver, Flash, Photoshop, Illustrator
Timeline
Currently
Senior Project Database Specialist
Golder Associates, Redmond, Washington.Municipal Water Rights Management Application City of North Bend, Washington
Developed a Web/database application to manage water production for compliance with municipal water rights. Worked with stakeholders and Golder water resources consultants to develop the list of requirements. The Web application has role based authorization and automates the complex calculations needed to manage water rights. Simple reports are provided for daily water system operations and more complex reports are provided for city management and other stakeholders.WRIA 7 Geographic Response Planning
Washington State Department of Ecology Snohomish River, Washington
Designed an oil spill response plan management application for the Snohomish River Watershed (WRIA 7) in Washington State. 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 data for a specific area, customized for current weather and stream flow level. Managed design, construction, and deployment of the underlying database, and did most of the database programming.Global Acid Rock Drainage Guide (GARD Guide)
The International Network for Acid Prevention
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.Provided consultation for the development of the GARD Guide. Created a Wiki with role based security for development of the guide and eventual public access. Formatted and entered the original content. Trained editors in the use of the Wiki.
Facility Information System (FIS) Republic Services, Phoenix, Arizona
Upgraded the existing FIS application with maps based on Web services. Added a module for managing the transfer of surplus equipment between business units. Added news article publishing to the FIS Web site. Upgraded compliance tracking, expenditure approvals, and project management.Environmental Compliance Assurance Review (ECAR)
CSX Transportation, Jacksonville, Florida
Upgraded the existing ECAR application with maps based on Web services. Improved email notifications for project management and compliance monitoring.
January 2006
EDI (Electronic Data Interchange) invoice development using Microsoft Access, SQL Server stored procedures, and Gentran: Director. (810, 880, v4010, v5010)
November and December 2005
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.
July 2005 through October 2005
I was an independent Web and database developer in the Seattle area. One new 200+ page Web site (seamar.com) and a couple of Web site rebuilds.
January 2002 through April 2005
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 helped train and provide technical support to almost 400 staff as they learned the new system.
- Tasks included creating a staff database to track training 400+ staff on the new software.
- I also became the database manager for this Juvenile Justice client tracking application.
Projects completed at Juvenile Justice:
- An Access/SQL Server 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. The module contains about 1,200 lines of T-SQL in 21 stored procedures and about 2,000 lines of Visual Basic code in the client.
- A Web/SQL Server application to track 400 individual staff through the training process for a new client-tracking system.
- A Wiki allowing staff to post questions and answers to technical and procedural issues.
- A set of applications to track staff information for budgeting, communications, and training. The output includes a staff contact form on the Division of Juvenile Justice Web site.
- Both static and database-driven Web sites
January 2001 through December 2001
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 image files with display of related database records.
I taught Visual Basic, database design, and Microsoft Access.
March 2000 through December 2000
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.
December 1997 to March 2000
Partner in Alaska Document Services. Microsoft Office applications 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.
August 1996 to December 1997
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.
September 92 to December 94
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.
Awards
Employee of the Quarter for the first quarter of 2004 at the Alaska Division of Juvenile Justice.
Education
BA Thiel College, Greenville, PA.: Psychology major. Plus four years of undergraduate chemistry courses and calculus, biology, and physics.
Kent State University, Kent, Ohio: five quarters of graduate work in experimental psychology.