Conrad E. Muller
12222 78th Ave., S
Seattle, WA 98178
Email: conrad at databasezone dot com
I retired from full time work in 2014, since then I have been working on small projects for existing customers. My recent projects have included:
- Updating a SQL/ VB.net application and moving it into the cloud on Microsoft Azure.
- Updating a SQL/C# Web application.
- Updating a Mediawiki Wiki on FreeBSD http://www.gardguide.com
I am available to work on projects remotely. I can help turn project requirements into database and UI designs.
I have managed software development projects with teams of up to four developers and projects with budgets over $100,000.
Every one of my clients considered their project successful. Most of my projects developed over the past ten years, or updated versions of them, are in daily use.
My real value to a project is my ability to cut through the fog, find out what the users really need, and design a practical solution to the real bottlenecks. I follow this up by making change control a core part of the development process. I see change as a healthy and necessary part of any project. Client collaboration and constant course correction are at the heart of Agile Development, and I implement as many Agile processes as are appropriate for each project.
My other core skills are communications and documentation. I work hard to keep the users involved in the project and the developers clear on the goals and progress of the project. All of my projects are extensively documented.
Core Competencies include:
- Business analysis/requirements analysis
- Project management
- Database design
- Web application/workflow design
- Software development
- Technical writing
December 2011 through May 2014
Department of Commerce, State of Alaska, Seattle, Washington
- I rebuilt and expanded three ASP.NET Web applications in C# on SQL Server. These are mission critical applications for a state regulatory agency. I added authentication based on an external Web service.
- I designed and improved several SQL Server databases, as well as documenting many others.
- I created and updated MS SQL Server reports.
- I finished a contractor developed Web application to display information about Alaskan communities.
- I Designed and built a database segment for US Census data and provided detailed US Census data which I accessed using the Census Bureau Web API.
- I have converted parts of a very large Department of Commerce Web site into DotNetNuke. I worked with templates and hundreds of pages, and I created one module in C#.
- I delivered a couple of internal Web/database projects based on SQL Server and VB.NET using MVC 3 with Repository Pattern, Entity Framework, and DbContext.
- I did some development on Oracle databases, plus some maintenance programming in Oracle Forms and Reports, and classic ASP.
- I migrated data from some old Oracle databases to a new SQL Server 2012 consolidated database.
June 2011 through October 2011
Senior User Interface Designer
Contractor at Washington State Ferries, Seattle, Washington.
June 2010 through May 2011
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).
February 2006 through May 2010
Senior Project Database Specialist
Golder Associates, Redmond, Washington.
Monitor Control System (MCS); Contract Compliance Application - Golder Associates
This Web forms/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 Web forms application was developed in ASP.NET 3.5. 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 forms/database application to manage the city utilities 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 more than 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
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 Web 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)
November and December 2005
Chief Database Specialist
I was chief database specialist for a data cleaning and database merging project that included database development, analysis, and SQL 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. 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.
January 2002 through April 2005
Department of Health and Social Services, State of Alaska in Juneau Alaska
I developed database applications for the Division of Juvenile Justice. I was involved in the entire development process, from building a business case to maintenance.
Projects completed at Juvenile Justice:
- Detention Assessment Instrument (DAI) An online application that assesses the need to commit an accused juvenile offender to secure detention based on data from the client-tracking database. Details are displayed, scores are saved and reports can be printed. This application featured eight data entry forms and five reports. The business logic behind this application was very complex.
- A set of Web and Access applications to track staff information for budgeting, communications, and training.
- A complete redesign of the DJJ Web site to add content, and to meet new state design standards and to be U.S. Section 508 compliant for the visually impaired.
Platforms and Languages
- Microsoft Visual Studio: ASP, ASP.NET, MVC , Entity Framework,
POCO classes, dbContext, T4 Templates, Repository Pattern,
- SQL Server Management Studio: TSQL: tables, views, stored procedures, indexes, triggers
- SQL Navigator; Oracle 10: PL-SQL: tables, stored procedures, triggers
- Source control: Subversion, VSS, GIT
- DotNetNuke Pro/Enterprise
- VISIO 2010: database documentation, workflow diagrams
- Adobe CS5 Photoshop
- Iron Speed Designer versions 7 through 10
- Google Maps v3
- Internet Information Services (IIS) Manager
- Microsoft Access
- Association for Computing Machinery (ACM)
- American Association for the Advancement of Science (AAAS)
Employee of the Quarter for the first quarter of 2004 at the Alaska Division of Juvenile Justice.
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.