Brian Platz
The Web Doctor
Internet Consultant
Website Design & Development
Database Driven Web Applications

(503) 373-4728
Salem, Oregon

www.DBWebDoctor.com 
Brian Platz

Work Experience

Computer Consultant 1991-Present
Since 1991 I have consulted to a number of individuals, small businesses and State and Federal Government. During this time I have developed computer applications written in Active Server Pages, Visual Basic Script, SQL Server, Access, and Oracle. Since March / 96, I have spent the majority of my consulting hours developing custom Internet Web Sites integrating ADO & ODBC compliant databases with Active Server Pages over the Internet. I have extensive experience in the Microsoft Family of Products including, but not limited to Windows Server Family, Internet Information Server (IIS), SQL Server, Transaction Server, Visual Studio and the entire Microsoft Office Family of Products (Word,Excel,Access,PowerPoint,Publisher,Outlook) Experience with software outside of the Microsoft arena include: Dreamweaver, Photoshop, Acrobat, Illustrator. My communication skills, both in writing and orally, are excellent. I am a team player and am known for prioritizing my tasks well, meeting deadlines, and keeping my customers very happy. More recently, typical duties would include: Design, Development, and Maintenance of Business Web sites and Design and Development of complex databases and integrating them dynamically over the Internet. Within Microsoft SQL Server, designing and developing database tables, views, stored procedures, triggers, functions, rules, DTS packages, apply security, setup and implement backup, restore, and replication routines and much more.
Oregon Department Of Education,  1/ 98 - 10/30/99    Web Master
At Oregon Department of Education (ODE) my title was "Web Master". I developed, maintained, and administrated the agency's Internet and Intranet sites. In addition I developed web applications using straight ASP, Microsoft Interdev, Dreamweaver, Home Site, VB Script, Java Script, MS Office, and SQL Server. Our Internet shop was practically all Microsoft products with three NT Servers running Internet Information Server (IIS), Index Server, Transaction Server, Site Server, and SQL Server to name a few. I organized, developed, and oversaw an agency web development team, comprising of persons from each division of the organization. I conducted monthly training for the ODE Web Team to increase their skills in all aspects of web development. Oregon Department of Education's web site, when I left in '99 consisted of over 9000 pages and 23 database web applications.
Oregon Department Of Corrections,  1/ 96 - 1/98   Systems Analyst / Web Master
The duties of my System Analyst position at Corrections was to design, develop, and implement client server computer applications using Visual Basic and tying them into our very complex Criminal Information System (CIS), residing in numerous Oracle and DB400 databases on AS400, Unix and NT platforms. During my employment at Oregon Deparment of Corrections (DOC), I was also the Team Leader / Project Manager / Webmaster for the Agency's Internet/Intranet Development, which includes but is not limited to Planning, Designing, Developing, Managing and Supporting DOC's Internet and Intranet sites. I was also our backup Oracle Database Administrator.
U.S. Forest Service, Siuslaw National Forest,   1989 - 1/96   Computer Specialist
My Position on the Forest was that of a zoned Personal Computer (PC) Manager. The duties of that position were to manage and support all the PCs on the Siuslaw National Forest. The position encompassed: technical support, standardization of hardware and software, training needs, security issues, procurement, and futuring. At the time, there were approximately 110 PCs across 6 counties, which were connected at both LAN/WAN levels, using TCP/IP protocol connected to our T-1 lines throughout the Forest. I was also a System Administrator for a Data General Mini (MV-15000), and GIS Workstations. I was  an Oracle DBA (Database Administrator) for 5 of the years I was employed by the Forest Service and have Supervisor Experience and Training.

Education

Bachelor of Science (B.S.) in Computer Science with minors in Natural Resources & Business Humboldt State University; Arcata, California  - 1988

References
Star George
Harris
Northwest Marine Trade Association
Seattle, WA
Contract Administrator for NMTA.net Site
206-634-0911
Star Rick
Mills
Office of Aircraft Services
Boise, ID
Information Systems Director for OAS
208-433-5050
Star Kris
Damsgaard
Office of Aircraft Services
Boise, ID
National Interagency Training Director
208-433-5090

My Interests

My Children Lacrosse My Dogs
Scuba Diving Computers Photography


Sites I've Enjoyed Developing:

Interagency Aviation Training - Training Registration, Online Modules, and Online Testing
www.IAT.gov

This is a national in scope, multi-federal, multi-state web based application that tracks ALL Federal Aviation Training Courses of all Aviation Personnel throughout the US. It is written in Active Server Pages (ASP)  with a Microsoft SQL Server Database on the backend. It was originally developed in 2004. It also provides online registration for classroom courses, online courses and ACE week-long training modules. Students are able to securely login and sign-up for course, take online courses, take online, randomly generated 10-50 multiple choice question tests, view current training schedule, view past training record, print certificates and more…

Because the bulk of this application is Username and Password protected, using SSL encryption, I am unable to make a direct link to the password protected section, where administrators can Add/Edit/Manage Courses, Classes, Tests, run numerous online, dynamic reports and much more.
Safecom System
www.Safecom.gov

The Safecom system is also a national in scope, multi-federal, multi-state web based application that fulfills the Aviation Mishap Information System (AMIS) requirements for aviation mishap reporting for the Department of Interior agencies and the US Forest Service. Categories of reports include incidents, hazards, maintenance, and airspace. The system is written in Active Server Pages (ASP)  with a Microsoft SQL Server Database on the backend. Safecoms report any condition, observation, act, maintenance problem, or circumstance with personnel or the aircraft that has the potential to cause an aviation-related mishap.
There is a Public Submit and Search section of this site, but much more of the advanced features and coding are Username and Password protected.

  
BuildingSearch.com
www.buildingsearch.com
This site has a MS SQL database driven commercial real estate property listing search in the Greater Bay Area. The results of a query will present pictures, floor plans, maps, driving instructions and numerous attributes about an individual property listing. 
  
North West Marine Trade Association (NMTA)
www.nmta.net
The Northwest Marine Trade Association is the largest Marine Trade organization of its kind in the Nation. Among other things, this web site has a searchable and updateable membership database on the back end.  Also Check-Out... www.SeattleBoatShow.com   and  www.EverettBoatShow.com
 
Prier Pipe and Supply Inc
www.PrierPipe.com
Prier Pipe is a pipe and plumbing wholesale supplier in Salem, Oregon. They have an internal Point of Sale (POS) system based in a SQL Server Database, that we replicate pieces of it on an automated daily schedule (job) that exports data out to their web site for the purpose of an online ordering system for their current customers. This site was developed with ASP pages and a SQL Server Database on the back end.
 
Oregon.com
www.Oregon.com
I am a partial owner of Oregon.com and the development of this site has always been a passion of mine. Our goal has been to connect Oregon interactively, that is to provide content for each city in Oregon without it being a monumental task of updating. We have now partnered with numerous newspapers that are now online to help accomplish this goal. This is the beginning of something potentially big, always has been.
 
BoatEscape.com
www.boatescape.com
Boat Escape is the Ultimate Internet Resource for Boaters and Campers in Oregon. It contains a comprehensive, searchable SQL Server database of information on ALL Oregon Lakes and Rivers, ALL Campgrounds, and ALL Marinas. It also contains a searchable Business Directory with over 1450 boating, camping and fishing related businesses in Oregon and vicinity. Boat Escape provides complete boating and recreation information, in one spot, tailored to the needs of the boater, camper and angler. 
 
Oregon Lacrosse
www.OregonLAX.com
Oregon Lacrosse Web Site is a fully functional database driven web site that provides, Teams, Coaches, Game Schedules, Standings, Official's Assignments, Ratings of Officials By Coaches, Payment of Officials and much, much more. This web site was also developed to be expandable, so what was initially developed for Boys High School (BHS) can also be used for Girls High School, Girls and Boys Youth, Mens and Womens Club, etc. This site has administrative areas for Overall Admin, for Assigning Officials, and individual logins for coaches to update "their" coach and team information as well as submit rating of officials on their games. This site is a GREAT example of how a Database Driven Web Site can make ones life MUCH EASIER !!!
 
School Synergy
www.schoolsynergy.org
This site is for two friends from my Oregon Department of Education Days that went out on their own and started their own company. They came to me and only me, knowing what I did for Department of Educations, while I was there and my people skills and Getting The Job Done.
  
Oregon Department of Education (ODE)
www.ode.state.or.us
I was the "Web Master" for the Oregon Department of Education for two years. At the time I left there were over 9000 web pages and 23 databases delivering content to a 1999 daily average of 49,000 hits a day. I built numerous database driven web applications that allow central input or querying out of various data sets of the agency (MS Access and SQL Server).

Oregon Department of Corrections (DOC)
www.doc.state.or.us
Previous to working at Department of Education, I worked at the Oregon Department of Corrections, where I wore a couple of hats, one of those being the department's "Web Master".  As in any state agency, there are many pieces to this one. While I was there, it seemed to grow exponentially by the day. Illinois State Corrections was the first State Corrections website, in the nation, to have a search utility on the public information of all their criminals; I was strongly encouraging one for Oregon while I was there! I have offered my services when they get ready to work on such a project. This site is over 1300 web pages. While I was there I also developed a web team, similar to Department of Education.
 
Copy Cats Northwest
www.copycatsnw.com
A Salem and McMinnville Printing and Copying Company. There is a cool FTP File Upload piece that I developed on this site, where it requires registration with email verify and then tracks all projects and file uploads in a SQL backend database.
 
Stone Clinic
www.stoneclinic.com
The Stone Clinic and Stone Foundation. Dr Kevin Stone's practice with special interests in research and advanced techniques for orthopaedic joint surgery. The Stone Clinic is located in downtown San Francisco, CA. A very informative web site
 
Honeywood Winery
www.honeywoodwinery.com
This is a site I developed in 2002 with a Database driven shopping cart with all their wines and gift baskets.
 
Letip of Salem
www.LetipofSalem.com
Letip is an International business networking organization. It has a searchable database of all "Letip of Salem" members, searchable by a number of different criteria. In addition each member can update their own information with a unique username and password.
 
Fiber Fab
www.FiberFab.com
Builder of Showers, Tubs, and Bathroom accessories. The products you see on this site are driven from a Products Database behind the scenes. The owner, with a username and password can manage their own products and not have to call me.
 
Water Ready
www.WaterReady.com
Builder of Catarafts, Boats. Excellent Service and Repair of Boats and RVs of all sizes in Lyons, Oregon. Owner Bruce Bitler can Add, Edit, Delete his products through a Web Admin interface that communicates to an Access Database file, so he controls his own products, inclduing uploading new photos that are used both as thumbnail and full image for a single product. This database and its Admin interface is the way to go for owners that wish to have control of their products, not not learn all the HTML junk.
 
Kilkee Photos
www.kilkeephotos.com
Kilkee, County Clare, Ireland is where I lived for 2 years back in 1980, 81, and 82 and have visited numerous times. Kilkee will always be a very special place in my heart. Click here to view the story behind me and Kilkee.  me and KilkeePhotos.com
 
Pembertons Flowers
www.pembertonsflowers.com
Fellow Letip members had a web site and wanted to add a Shopping Cart of the arrangments they sell. The shopping Cart is driven from 2 Access Databases on teh backend, one for Products and one for Orders.
  
Tedrows.com
www.Tedrows.com
Best Auto Detailer in the Salem area. Master Auto Detailer Steve Kenyon is the man!!
 
Inside Oregon Enterprises
www.insideoregon.com
Oregon State Correction's Private business of keeping Oregon inmates working and contributing back to society. Such programs are Prison Blues
 
All American Canopies
www.allamericancanopies.com
Canopies, Trailers, and Truck and SUV Accessories. What a Boy's Toy Store... 
 
BC Towing
www.bctowing.com
A Salem, Oregon towing company serving the Willamette Valley.  Very simple web site with justa couple of pages.
 
Carl 'B Klean Car Wash & Gift Shoppe
www.carlbklean.com
A local Salem, Oregon Car Wash. Very Simple, but clean looking site.
 
Greenwood Products
www.greenwoodproducts.com
Greenwood Products is a large company, based out of Oregon that specialize in various wood products.  
 
KilnStickers.com
www.kilnstickers.com
KilnSticker.com is a company that produces those little sticks that go between the big stacks of lumber in lumber yards or mills. It is a business within or under Greenwood products. Hard to image there is a thriving company that makes those little sticks, but there is... 
 
Dependable Printer Support
www.dpsnw.com
This was a make over job. They had a web site but felt they could do better.
You be the judge...
 
Viking Ice
www.vikingice.com
Synthetic Ice is in popular demand right now. This site was publicly announced in Sept/2000 and after submitting them to the search engines they were immediately getting 2-4 price inquires a day from across the world. Phase two of this site is a database piece that will help manage the inquiries and allow salespersons to centrally update the online leads. 
 
 
 

Visual Basic Client-Server Applications I have written:
 
ICARS - Incident Cost And Reporting System
This application is used on Large Incidents (Fires, Earthquakes, Hurricanes, etc) to track, report, and graph estimated total costs of a Forest Fire or Fire Incident. I originally wrote it Paradox while working for the Forest Service in 1995, but have recently re-writing the application, under contract with the US Forest Service, in Visual Basic 6 with an Access2000 Database in the back end. One of its many forte's is its ability to split costs amongst multiple agencies (Cost Apportionment Module) and its many Reports and Graphs. 
 
Central Records 3x5 Card Application
This application was developed in Visual Basic 4 and Oracle v7.3 for the Oregon Department of Corrections. Prior to this application, Central Records had over 1.3 million 3x5 cards that held microfiche information about Oregon offenders. Now all this information is on-line and ties into our Criminal Information System (CIS). This application uses Oracle's Objects for OLE and Oracle's AS400 Gateway product to read and write to both DB400 on an AS400 and Oracle tables on a Unix Server. The department wishes to replace the microfiching of offender's records with a document imaging system, which this application would be the stepping stone to a much larger application.
 
Parole Board Reporting
This application was developed in Visual Basic 4 and is used to assist Parole Board staff with daily, weekly, mid-month, monthly and quarterly reports. Prior to this application, staff were required to manually execute dozens of individual reports passing identical parameters for each. This application was a great time saver for the Parole Board staff.
 
Inmate Assessment Application
This application was developed in Visual Basic 4 and Oracle v7.1 for the Oregon Department of Corrections. This application is used during an offenders initial evaluation and assessment. It is a three-tier client server application as the client piece is on a Windows 95 machine and it writes to DB400 and Oracle tables.