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. Extensive use of Cascading Style Sheets, Client-Side Javascript and JQuery. Within Microsoft SQL Server, designing and developing database tables, views, stored procedures, triggers, functions, rules, DTS packages, SSIS packages, apply security, setup and implement backup, restore, and replication routines and much more.
Oregon Dept. 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 Dept. 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 NF,   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
President / Director for NMTA
(Northwest Marine Trade Association)
206-634-0911
Star Dale
Flowers
Oregon State Marine Board
  - Law Enforcement Division
Salem, OR
Law Enforcement Coordinator
503-378-2613
Star Jeff
Trejo
Oregon State Parks & Recreation
  - OHV/ATV Division
Salem, OR
OHV/ATV Coordinator
503-986-0585
Star Rick
Mills
Office of Aircraft Services (OAS)
Boise, ID
Information Systems Director
208-433-5050
Star Ron
Splonski
Prier Pipe & Supply Wholesale
Salem, OR
General Manager
503-363-1434
Star Bob
VanderLinden
On-Point SEO & BoatEscape.com
Albany, OR
Owner
541-791-3784

My Interests
Our Children Lacrosse Our Dogs Pickleball Boating/Camping
Scuba Diving Computers Photography Travel / Ireland Paying It Forward
  Networks / Chapter Tool  

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.

  
Oregon State Marine Board Law Enforcement Activities
www.OSMBLE.com

This site is pretty much ALL driven from a SQL Server database on the backend. All Agencies, Agency Employees (program managers, officers, cadets, volunteers) add their Daily Activities, Citations/Violations given out, Training Education Classes, Boating Incidents and much, much more. This application was developed in .NET and is entirely password protected and uses SSL for encryption of data. If you are interested in viewing, call and I can walk your through it and all the features it has.

  
Oregon State Parks and Recreation OHV/ATV LE Activities
www.OPRDLE.com

This site is also pretty much ALL driven from a SQL Server database on the backend. All Agencies, Agency Employees (program managers, officers, cadets, volunteers) add their Daily Activities, Citations/Warnings/Violations given out, Training Education Classes, OHV/ATV Incidents and much, much more. This application was developed in .NET and is entirely password protected and uses SSL for encryption of data. If you are interested in viewing, call and I can walk your through it and all the features it has.

  
Chapter Tool
www.ChapterTool.com

Here is a SQL database-driven web application that is a life saver for Networking Groups around the country, including Letip Chapters. TipMasters, Secreataries, Vice Presidents and Presidents of networking groups can save themselves a LOT of time by using/subscribing to ChapterTool.com. This site was originally developed in late 2009 for Letip Chapters in the US and Cananda where referals (or what the Letip members call "Tips") are passed between businesses within their chapter. Collecting, managing, and reporting on those weekly submitted tips can be an overwhelming task for the TipMaster position in each chapter. I have been a Letip member since 1999 and know the needs of the TipMaster position. Now there is an online solution where chapters can easily and securely enter and manage their chapter's tips online. This is a subscription fee based web site and is an excellent resource for ALL Networking Groups, especially inclduing LeTip Chapters in the North America. The Web Site was released in Jan / 2010.

 
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.  We also developed a Visual Basic member application which tracks their brands and activities, membership dues, invoicing, boatshow space and payments and much, much more.

Also Check-Out... www.SeattleBoatShow.com   www.EverettBoatShow.com  www.DiscoverNWBoating.com  and www.DicoverNWFishing.com   

 
Willamette Valley Multiple Listing Service
www.WVMLS.com

The Willamette Valley Multiple Listing Service web site is a centralized housing for all Real Estate Listings in the Willamette Valley (Oregon).  Their members are all the Real Estate Offices and Agents in the Willamette Valley. This site has a SQL Server Database with many, many, complex tables, stored procedures, triggers, DTS packages, views and reports. I have been working for WVMLS since 2005.

 
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, Campers, and Anglers in Oregon. It contains a comprehensive, searchable SQL Server database of information on ALL Oregon Lakes and Rivers, ALL Campgrounds (private, city, county, state and multiple federal), and ALL Marinas. It also contains a searchable Business Directory with over 1450 boating, camping and fishing related businesses in Oregon and vicinity. We also received a grant to build the realtionship of the species of fish to each body of water in Oregon. Now users can search Oregon lakes and rivers for specific fish species in a certian area and then find the near by campgrounds and even make campground reservations where available. Boat Escape provides complete boating and recreation information, in one spot, tailored to the needs of the boaters, campers and anglers in the northwest. Our goal is to build these same friendly searches for Washington, Idaho and Northern California.

 
Oregon High School Lacrosss Association (OHSLA)
www.OHSLA.net   

Oregon Lacrosse Web Site is a fully functional database driven web site that provides, Teams, Coaches, Game Schedules, Standings, Official's Assignments, Officials Accepting Assignments, Ratings of Officials By Coaches and Officials, 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 and officials 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 !!!

 
Odd Moes Pizza
www.OddMoes.com

Local (Salem, OR) Pizza Company, serving Pizza, Wings, Ribs, Salad, Ice Cream and Pop. Includes an online ordering system, a cool flash cartoon commercial module and more. Great owners and care about the community. Franchise opportunites available.

 
Humboldt Lacrosse
www.HumboldtLacrosse.org

I played Lacrosse at Humboldt State University and the team needed a web site, so I donated my time to build them a web site and have had fun reconnecting with previous players/alumni from years back. Great Lacrosse Tournament (Harvest Tournament); apprximately third week in October; Good Times!

 
Denny Stevens - Luthier
www.DWStevensGuitars.com

This site is a tribute web site to a Great Man and Phenominal Luthier (guitar maker) - Dennis Wayne Stevens, commonly known as "Denny". Denny lost his battle with ALS (Lou Gehrig's disease) on June 22nd 2009. Denny's wife, Karen, wanted to develop a web site for his second anniversary of death for friends, family, and DW Steven's Guitar Owners to enjoy for years to come.

  
Gamberetti's Italian Restaurant
www.Gamberettis.com

This site is for a fellow LeTip member Treva Gambs. Gamberetti's is a great italian restaurant located in Salem Oregon. Two fantastic Banquet Rooms, Full Bar, Great/Affordable Food, Super Atmosphere. There are two small databases where the owner can manage/control their Specials and Events via a web based Admin area of the site..

  
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 Education, while I was there and my people/communication 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 and headed up the Internet division. 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.

 
Fitzpatricks Bar/Pub in Kilkee, County Clare  Ireland
www.FitzpatricksKilkee.com

Owner Jimmy Fitzpatrick is a friend and owner of Fitzpatricks Pub and En-Suite Accommodations in Kilkee, County Clare Irleland; one of my favorite places in the world. Live Music during the summer months and need a place to stay? - they have two rooms upstairs above the bar in the heart of Kilkee.

 
Green World Now
www.GreenWorldNow.com

Green World Now is dedicated to meeting the market demand for eco-friendly products. Their expertise is uniquely focused in connecting sustainable products with consumers through large retail chains.

 
HedgeHog Welfare Society
www.HedgeHogWelfare.org

A national association tending to hedgehog's welfare around the country. A couple of SQL Databases on the backend tracking various pieces of this site and 4-6 different online forms that submit to those databases and send emails.

 
Networks of Salem
www.NetworksofSalem.com

Formally a Letip Chapter; our networking group decided to seperate from Letip International and do it on our own; now Networks of Salem. I have been a member of this networking group since 1999. This site has a searchable database of all "Networks 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. We also store and track all tips (referals) members give and receive. That piece is password protected, but would be happy to provide a temp password to view this piece; its pretty cool.

 
The Trout Master
www.TheTroutMaster.com

Franz Dutzler, award winning Austrian born Oregon fish sculptor, carves fish with a passion. He has become known for his exquisite scenes of fish. His attention to detail and the uncanny realism of each carved fish has become the unmistakable hallmark of his work. Franz's meticulously carved, native wild trout wood sculptures are so exacting that they look like when you first hold it in your hand, “Fresh from the Stream”. We developed a SQL Server database on the backend where Franz can add/update his carvings that are then displayed under the various carving categories.

 
Jim Lemmon - Speciality Carpenter
www.JimLemmon.com

Jim Lemmon is a Specialty Carpenter and Commerical Finish Carpenter in Salem Oregon, though works all off the northwest. With over 40 years of exeperience, this man does some really nice work.

 
Fiber Fab
www.FiberFab.com

Builder of Showers, Tubs, and Bathroom accessories. The products you see on this site are driven from a Products SQL Server Database behind the scenes. The owner, with a username and password can manage their own products and not have to call me. Again, providing control to the web site owner to manage their website content/products.

 
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.

 
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

 
LastChanceClub.org
www.LastChanceClub.org

A donated site for the development and hosting for one of my heros: Dr Arlene Brooks. Arlene does SO MUCH Volunteer work in providing medical care for small animals where this might be their last chance. The Last Chance Club focuses on bringing medical care to as wide a rescue population as is possible on a routine basis. Aided by "bare bones" costs for supplies and donated professional time for vet services, animals with treatable conditions can be helped and adopted rather than being euthanized. This web site also has a small database where Dr Books can track her Cases and have them dynamically displayed on this web site.

 
Santana Village Park - Salem Oregon
www.SantanaVillagePark.org

A Local Neighborhood Owned Park in Salem Oregon. Once owned and maintained by Marion County Parks and Rec, it is now owned and WELL maintained by the Santana Village Neighborhood Association, Non-Profit / Charitable Organization 501(c)(3) corporation.

 
Tedrows.com
www.Tedrows.com

Best Auto Detailer in the Salem area. Master Auto Detailer Steve Kenyon is the man!! No databases on this one, but a nice look and feel to his site.

 
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. There is a small database on this site to collect visitor's information for future communications.

 
All American Canopies
www.AllAmericanCanopies.com

Canopies, Trailers, and Truck and SUV Accessories. What a Boy's Toy Store... 

 
City View Funeral Home and Cemetery
www.CityViewFH.com

City View Funeral Home and Cemetery is a local, independent, family-owned and-operated business. There is a small database piece on this web site that allows the owners to manage the Obituaries section of the site. That piece of their business is constantly changing so verses (1) learning HTML or (2) having to work with me as their Web Master each time someone passed; this database piece allows them to easily manage new obituaries that they are notified of - They LOVE IT.  I build web solutions that allow owners to better manage their web site.

 
Carl 'B Klean Car Wash & Gift Shoppe
www.CarlBKlean.com

A local Salem, Oregon Car Wash. Very Simple, but clean looking site. An Online Gift Card purchase piece was added onto this site in 2009. Secure Transactions.






Visual Basic Client-Server Applications I have written:
 
Northwest Marine Trade Association (NMTA) Member Application

This application tracks NMTA's membership base, inclduing renewals and invoicing, boat show and exhibitor information, brands they sell, multiple levels of contacts and multiple store locations. This is a Visual Basic application with a SQL Server backend. There are stored procedures that replicate data out to their web site and Boatshow Kiosk application(s).  

 
Houston Boat Show Member Application

This application tracks all of Houston Boat Show membership base, inclduing renewals and invoicing, boat show and exhibitor information, brands they sell, multiple levels of contacts and multiple store locations. This is a Visual Basic application with a SQL Server backend. Phase 2 would be to build similar routines as NMTA (above) to replicate some public data out to their web site and for search capabilities.  

 
Northwest Marine Trade Association (NMTA) Touch Screen Kiosk Application for Shows

Developed a touch screen, Flash based, kiosk system for the Seattle Boat Show. A high percentage of the application was dynamic content, relient on an Access database on the backend for the Kiosk machines and a MySQL database for the Online version. Thee were 9 kiosk computers evenly distributed around the Seattle Boat Show. The data that populated the tables came from NMTA's SQL Server Membership database and we built DTS packages to export the data and update the local copies when needed.

 
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 in Paradox while working for the Forest Service in 1995, but later re-wrote the application, under contract with the US Forest Service, in Visual Basic with an Access Database on 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 and Oracle 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 wished 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 with an Oracle backend 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 and Oracle 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 box and writes to DB400 and Oracle tables.

   
       
Chapter Tool Manages ALL Letip Chapters Data A Proud Member of Networks of Salem