Pat Johnston

Internet Information Systems Developer/Manager
82 Corey Road, Aromas, CA 95004          Pat@MelroseCenter.com           (831) 726-2311

Internet Applications Developer/Manager

• Developer of interactive information applications for the Internet that interface to backend relational databases and messaging systems, using HTTP, client/server, and multi-tier platforms.
• Webmaster, database and systems developer experience on LAMP and Windows platforms.
• Extensive programming background including Java, Perl, PHP, VB, C++, C#, JavaScript, AJAX, XHTML, CSS, jQuery, ASP, .NET, XML, and SQL.
• Production relational database experience with SQL Server, MySQL, MS Access, Oracle, Informix, and Ingres. Extensive database management, design, data mining, and data analysis experience.
• Experienced applications/systems developer on Windows, Linux, and Unix platforms.
• GIS experience with ArcGIS, Google Earth, and Google Maps.

Recent Employment

MBARI, National Ocean Economics Program, Moss Landing, Ca.

• Full website and database development and management responsibilities.
      CSUMB, 2003-2006
• Data research and collection; database design; data transformations, imports, and validations; data analysis; website design, development, and management; creation of tables, graphics, and maps for publication.
• Interface with MBARI IS operations, NOAA Coastal Services Center, and other coastal and ocean services agencies.
• Expertise in: XHTML, JavaScript, CSS, MS-IIS, SQL-Server, ASP, VB, C#, .NET, MS-Access, JSP, Java, Perl, jQuery, Webalizer, Excel, PowerPoint, Word, DreamWeaver, PhotoShop, ArcGIS, Google Earth, Google Maps, R.

Successful Consultant Projects

HawaiianHuts.com, Aromas, CA

• Complete design and development of a vacation rental listing service, HawaiianHuts.com.
• Development of XHTML interfaces, CGI processing, internet based account and listing management, backend database and email components, search engine placement (SEO), and lots of graphics.
• Management of website hosting, customer relations, database management, and operations.
• Expertise in: XHTML, JavaScript, CSS, Perl/DBI/CGI, MySQL, PHP, ImageMagick, Apache, Linux, RealtyManager (InteractiveTools.com), PaintShop Pro.

Cisco Systems, San Jose, CA

• Design and development of Object Oriented Perl CGI programs and utility modules in support of EMAN (Enterprise Management) client services applications, including cellular, paging, audio-conferencing, IP phone quality, and billing.
• Development of XHTML interfaces, CGI processing and backend database and email components.
• Expertise in: Perl/DBI/FTP/MIME/Win32, Oracle, MySQL, Apache, Solaris, Win2K, Latitude, sendmail, SMTP, MobileSys MX, TogetherJ.

Hewlett-Packard IBS, Santa Clara, CA

• Design and development of Perl CGI and utility modules for B2B order status reporting system.
• Developed a Perl module for generating Adobe Acrobat (PDF) document files, and a command processor for updating databases.
• Expertise in: Perl/DBI/FTP, Informix, HTML, JavaScript, HP-UX.

ClockWare, Sunnyvale, CA

• Web page development for collecting elapsed time, and Java functions to update database files.
• Expertise in: HTML, JavaScript, Netscape Application Server (Kiva) and Java.

Hewlett-Packard CLF, Santa Clara, CA

• Design and development projects supporting reverse logistics functions.
• Various Perl and Java based information systems in support of HP Corporation’s Reverse Logistics (returns) operations including inspection and disposition information, and returns inventory processing, and accounting with interfaces to SAP, relational databases, and different warehouse inventory systems.
• Designed and developed dynamic ecommerce web pages with data validation, XML data transfer files, and a Netscape plugin program.
• Expertise in: Perl/CGI/DBI, Java, JavaScript, HTML, XML, EDI, Visual C++, MS IIS, MS Access, MS SQL Server (including TransactSQL and extended stored procedures), Ingres, Informix SPL, and HP’s Virtual Vault firewall software.

Hewlett-Packard, Palo Alto, Mountain View, Sunnyvale, CA

• Various projects at corporate offices and labs developing internal logistics and testing systems.
• Expertise in: COBOL, Perl, Java, C, C++, HTML, JavaScript, NetDynamics, SQL, Ingres, Image 3000 databases.

Other Significant Employment

• 1985-86 INTEREX, international HP users group, Sunnyvale Ca; Manager of Technical Services
• 1981-85 Stanford University, Information Technology Services; Applications and Systems Specialist
• 1978-81 Santa Rosa Junior College, Santa Rosa, CA; Senior Programmer Analyst, Instructor

Education

• 1987-95 U.C. Berkeley and U.C. Santa Cruz extensions — Computer Science coursework in Unix, Windows, computer languages, and software development technologies
• 1976-77 Santa Rosa Junior College — coursework in computer languages and data processing
• 1968-70 University of West Florida — B.A. in Mathematics and Statistics
• 1965-67 Spring Hill College — undergraduate courses in Music and Physics