Brian
Platz
The Web Doctor
Internet Consultant
Website Design & Development
Database Driven Web Applications
(503) 373-4728
Salem, Oregon
www.DBWebDoctor.com |
 |
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
|
|
Northwest Marine Trade Association
Seattle, WA
Contract Administrator for NMTA.net Site |
206-634-0911
|
|
|
Office of Aircraft Services
Boise, ID
Information Systems Director for OAS |
208-433-5050
|
|
|
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. |
| |
| |
|