I designed and wrote a complex, modular system for our office Intranet which manages Messages, Contacts, Jobs, and Reminders. Major functions such as listing, searching, viewing, displaying and saving are handled by code which is then referenced by each type of object. The system also sends critical Messages to a scrolling Adaptive LED sign via a simple backend Visual Basic program.

Earthworm Tunneling is the first to use a system I designed to allow content writers and site administrators access to website content without needing to know HTML. Each page is generated by code which looks for database content and displays it within a Macromedia Dreamweaver Template. An administrative backend allows the user to edit content, upload images and modify limited layout and design. As all non-existent pages are dynamic, the authorized user can create new pages just by creating a link to them.

The Hidden Hills website was refitted with dynamically generated content. Sponsors were given editable pages like the site above. User logins are handled by a session ID cookie which references login information in the database. The admin page to the left is an instance of a generic SQL Editor I designed to provide clients with a comprehensive yet conceptual hierarchical database editor.

The Polar Focus product catalog was the first major database-driven page I designed from scratch. I also wrote an administrative form which seamlessly integrates category, product and content modification with the upload of images, thumbnails and PDF files. The system also outputs Quark Express tags so that the online catalog can be easily outputted into a format which can be  quickly converted into their print catalog.

http://www.polarfocus.com/view.php?SH

http://www.berteraautooutlet.com/used/

The MassWheels website is a local online used car database and search engine. As part of a push to improve the usefulness of their website, I wrote them a new, more dynamic and flexible search engine. It searches their SQL database for words in specified fields and supports extended search functionality such as OR, NOT and parenthesis which are parsed and converted into SQL syntax. I also wrote a JavaScript-enabled search form which changes the right-hand image and description to the automobile in the left-hand list currently under the cursor.

I designed the ActionScript for the Sportek Calculator, an online floor space calculator for Sportek Surfaces. This Flash application provides a way for customers to get an idea of how much a project might cost by generating a simple estimate based on size and layout. The editable grid shown allows the user to draw the location(s) in their floor plan where they do and do not need tiling, via drag-and-drop functionality. Once the final price is calculated, a Perl script is called to email text and HTML versions of the specifications to both parties.

http://sporteksurfaces.com/flash/calculator.html

http://unistudios.eyenetics.net/

This Flash website was created for UNI Studios, a top-class recording studio. It was built on top of an already existing “shell” which allows different pieces of a Flash presentation to be loaded on demand instead of all at once. I extended this shell with my own navigation buttons, a method for the integrated display of full-size images, and the programming layout for paged text, thumbnail images, and a clickable floor map.

I designed the look and code for the website of Donna Estabrooks, a prolific local Northampton, MA artist with a constantly changing portfolio.  I created the design in Adobe ImageReady and programmed each portfolio page to pull its information from a PHP data file. Thus adding new paintings, setting categories and marking paintings as sold is as easily as adding or modifying a single line in a text file.

http://www.donnaestabrooks.com/

http://www.lmtgtm.org/

I designed The Large Millimeter Telescope Project homepage using Adobe ImageReady to create dynamic roll-overs for the clickable section titles and CGI to include a web counter I wrote in Perl. The page also has a hidden Internal Resources link which appears only to web browsers on the local network. I also maintained their UNIX web and mail servers, their Microsoft web and mail servers, their Windows domain, the hardware and software of their 10+ Windows Workstations and their Cisco network switch.

I programmed the navigation bar shown here to be dynamically inserted atop all LMT pages. It contains pull-down menus and a built-in search bar which overlays the title when activated. Integrated language translation was implemented using cookies to maintain each browser’s language. On the page shown to the right, each telescope section highlights on mouse rollovers, linking to dynamically maintained image slideshows relevant to each section. These slideshows are instances of a system I designed to simplify the display of image collections into a single text file.

http://lmtgtm.org/construction/subsystems/

http://www.lmtgtm.org/lmto/

The LMT Observatory webpage implements a cross-browser expandable list to compress the links and descriptions associated with each Working Group into a readable web page. Clicking on each  expands the section and replaces the image with a  which contracts it.  It is designed to work in Internet Explorer 4 and Netscape 4 and above. Cookies keep each section expanded or collapsed between visits.

I designed this incarnation of the Five College Astronomy Department homepage in Adobe Photoshop. I also designed and implemented Perl software to automate many website functions, such as extracting site statistics from log files and automating the addition of new documents into the site. I wrote a complex CGI script to provide browsing and rudimentary graphing for a large astronomical database, another to improve the conversion of documents with the program Latex2HTML, and another to perform site mirroring and link checking. I also helped maintain their network of Sun UNIX servers.