|
|
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
President / Director for NMTA
(Northwest Marine Trade Association) |
206-634-0911
|
|
Oregon State Marine Board - Law Enforcement Division
Salem, OR
Law Enforcement Coordinator |
503-378-2613 |
|
|
National Business Center - Aviation Div.
Boise, ID
Information Systems Director |
208-433-5050
|
|
|
National Business Center - Aviation Div.
Boise, ID
National Interagency Safety Manager Administrator |
505-433-5070
|
|
US Forest Service - National Interagency
Fire Center (NIFC) - Boise, ID
National Interagency Safety Manager |
208-387-5285 |
|
Prier Pipe & Supply Wholesale
Salem, OR |
503-363-1434 |
|
On-Point SEO & BoatEscape.com
Albany, OR
Owner |
541-791-3784 |
My Interests
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) 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. |
| |
| BuildingSearch.com |
| www.BuildingSearch.com |
| This site has a SQL Server database driven commercial real estate property listing search in the Greater Bay Area and growing. 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. 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 !!! |
| |
| Chapter Tool |
| www.ChapterTool.com |
| Here is a web based application that is a life saver for Letip Chapters, including TipMasters, Secreataries, Vice Presidents and Presidents around the United States and Cananda. Letip is a Networking Organization 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 LETIP Chapters in the North America. The Web Site was released in Jan / 2010. |
| |
| 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. |
| |
| 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. This is a main piece to their web site, where their clients can easily upload their work to be printed and store that information by client, by project. |
| |
| Cemetery Association of Oregon |
| www.CemeteryAssociationOfOregon.com |
| A fairly simple but eye appealing site. This is for the Association of all Oregon Cemeteries. There is a database piece on this site that manages all their Members and Suppliers. In addition, that same database is able to control the dynamic content for the Board Members page. |
| |
| Schroeders Guest House Restaurant |
| www.SchroedersGuestHouse.com |
Schroeders is a great place to eat and they wanted the ability to run their own coupons and specials, but did not wish to learn HTML or Web Page editing software, so I built them a small password protected database app that allows the owners to ADD/EDIT/DELETE restaurant and lounge coupons and specials. The home page also has a very flexible Flash module, where the plates of food rotate through on the home page. The selection of images is taken from an XML file on the site, so very flexible and easy to swap out new or old plates. |
| |
| 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. |
| |
| Letip of Salem |
| www.LetipofSalem.com |
| Letip is an International business networking organization. I have been a member of Letip of Salem since 1999. This site 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. 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. |
|
|
|
Oregon Corrections 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 which I also web host that 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... |
| |
|
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. 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. |
|
|
|
|