David Scott Holdren
scott@holdren.com
1184 Cedar Hill Road
Kingston Springs, TN 37082
615.441.5906
EMPLOYMENT HISTORY
July 2004 - Present
Sitening - Strategic Open Source Nashville, TN
Co-Founder
- Sitening provides strategic open source consulting for small and medium sized businesses.
July 2002 - July 2004
Independent Consulting
July 2001 - July 2002
Nukote International - Imaging Supplies Franklin, TN
Programmer Analyst
- Design visual reports and charts for examining trends in supply chain and sales data.
- Relate sales data to 1990 and 2000 census figures for demographic analysis.
- Create and maintain PHP extranet and intranet sites for generating reports on vendor sales and inventory on the store, part, group, distribution center, and vendor level. Used PHP and GD libraries to create graphs.
- Maintain PostgreSQL database of historical sales and inventory data for creating live and pre-processed reports.
- Monitor weekly import of vendor data.
- Track all changes to PHP and Perl code using CVS-Concurrent Versions System.
February 2000 - July 2001
Freelance Programming
- Created online ballot for the National Federation of Independent Business (NFIB) with PHP and MySQL. Using this tool, the administrator regularly generates customized emails to all of their 85000 online members. Members can then access the HTML ballot and cast their vote. The adminstrator then exports the data
for use with their paper ballot system.
- Updated online location database for TravelCenters of America using PHP and MySQL.
- Updated content management system for MyBusiness magazine using PHP and MYSQL.
- Created import and search tool for COMTEX news feed using Perl, PHP and MySQL. Support for category and keyword searches. Automatic expiration of old entries. Custom Perl script for importing COMTEX file format, including support for rejecting irrelevant stories.
February 2000 - July 2001
Monster Labs, Inc. - Internet Software Nashville, TN
Technical Lead
- Starting with a concept in February 2000, responsible for designing and implementing the Application Service Provider division SiteMason to provide dynamic Web site elements for Web developers.
- PostgreSQL, OO Perl, Apache, mod_perl, XML, XSLT with Sablotron, HTML, WML, CVS for version control, LVS for load balancing, and C, all operating under Linux.
- Hired and coordinated six team members, actively participating in all aspects of development, including hardware and software selection, installation, database and application design, billing and account management system, definition and implementation of business rules, and performing as a Perl and database programmer. SiteMason launched on schedule, January 1st, 2001, and currently has over 2000 users, serving 25,000 dynamic requests daily. Development continues as new tools are added to the SiteMason framework.
- Designed distributed development environment using CVS, with isolated test servers for each developer. After initial testing, developers could commit changes to the central development server for final testing. Code could then be deployed to the production servers. Created testing programs to analyze code changes before final deployment. Also created monitoring tools to guarantee service on the production servers.
- Designed all SiteMason modules to output XML, which was then translated into HTML and WML by various XSLT templates. This allowed enough flexibility to support wireless browsers and other languages without modification to the modules.
- Modified Apache Web server in C for customized server-side caching of module output.
- Created Apache module in Perl for creation and color modification of GIF images. The module would dynamically alter the color table as the image was output to the browser.
- Also worked on the Web Site Hosting division Moses.com by installing and customizing a Perl/Mysql billing and provisioning system and setting up different aspects of the Apache configuration to provide hosting services.
June 1998 - February 2000
Lara Consulting Group - Web Management Firm Salem, MA
Senior Systems Analyst
- Senior programmer responsible for design, implementation, and support of internet software for a select group of corporate clients.
- Perl5, Apache, MySQL, Microsoft IIS, SQL Server, Visual Basic, Oracle, Dynabase.
- Sites include: Cannondale, Harvard Executive Education, Osram Sylvania, BBN / GTE Internetworking, Genzyme, Beth Israel Radiology, Grubb & Ellis, eMarketer, Tuthill, Air Jamaica, Salem Five Cent Bank
- Create secure site for online mortgage applications, including rate calculations and saved sessions. Applications were provided to the bank in a format compatible with existing forms and software so they could be easily incorporated into their mortgage system.
- Designed online radiology database using ASP, VBScript, and SQL Server 7.0. Records consisted of several images from different equipment, plus symptoms, diagnoses, treatment, and follow-up. Site included a user and group administration system, allowing doctors and teachers to assign specific case files to their students, and restricting student access to particular fields and images. Students would then be required to deduce the missing information. Stored images directly in database, as well as thumbnail versions, which were automatically generated when they were uploaded over http. File upload and image manipulation was accomplished using third-party libraries from Software Artisans. All data was managed through a Web interface.
- Added international support in five languages to a product catalog site using Apache's XSSI and language specific request headers from the client's browser.
- Created online job search with Dynabase and Oracle. Built import tool with Perl to import data into Oracle database on a scheduled basis. Designed relational Oracle database to optimize searching and browsing of jobs. Programmed interface in Dynabase, which is similar to ASP with VBScript. Included Perl script to email relevant jobs to registered users as they were posted, to be run daily.
- Created a contact database in Access using VB for Applications, including a third party module to allow bidirectional syncing to Palm Pilot address books.
- Designed import functions in Perl to update Web content and product databases using AS/400 exports and Excel spreadsheets.
- Interfaced Goldmine database with Web registration forms.
- Set up remote Web cam to upload snapshots to Web server, then compiled snapshots into MPEG movie files of a two day conference.
- Built online store for selling access to pdf and html files. The system managed customer accounts, billed credit cards through CyberCash, then maintained a secure online area for customers to view and download their purchased files. Optionally sent documents as email attachments to customer at time of sale, and submitted fulfillment requests for hard copies. Included tools for cross-sell and up-sell marketing, as well as promotions and subscriptions.
- Created import and Web interface to find flight information for different airports and times.
- Provide technical expertise and business analysis for sales presentations and project specifications.
September 1996 - June 1998
Shore.Net - Internet Service Provider Lynn, MA
Software Developer
- Used mod_perl for integrating Apache Web servers with a Sybase SQL server in order to create a secure Web site for customers to access and edit account information.
- Also used this environment to create Web-based tools for manipulating the internal billing database.
- Responsible for creating scripts for Web-based reports, displaying usage statistics, and other typical Web site applications.
- Used Perl5, Apache, mod_perl, Sybase Transact SQL, Java1.1, and C, primarily with Solaris 2.5.1.
September 1995 - August 1996
Telalink Corporation - Internet Service Provider Nashville, TN
Web Services Administrator
- Developed and installed generic server-side software tools for client Web sites using Perl
(i.e. search, mail, form processing, chat rooms, counter).
- Also developed maintenance and administration tools for virtual host clients (i.e. listserv, htaccess, virtual mail).
- Assisted with technical support for Windows and Macintosh dial-up clients.
June 1995 - January 1996
Telasar Corporation - Macintosh Consulting Firm Nashville, TN
Primary Consultant
- Consulted approximately 20 small businesses, 4 medical research facilities, and several
individuals with Macintosh networks and workstations.
- Services included wiring, internet
connectivity, hardware upgrades, software installation, and software support including Photoshop, Freehand, QuarkXPress, Word, Filemaker Pro, Excel, Suitcase, Quickmail, Microsoft Mail, Claris Emailer, CCMail, Eudora, Netscape, Now Contact, Now Up-to-Date, and Appleshare File Server.
August 1994 - June 1995
High Five Entertainment - Multimedia Production Company Nashville, TN
Network Manager
- Installed, configured, maintained, and upgraded 40 Macintosh workstations, wide area network,
and AT&T Merlin Legend phone system.
- Also installed on-site phones and computer networks
for large productions.
PERSONAL PROJECTS
Visual Basic 5 and 6 and VB for Applications
- Slideshow - reads a cdrom containing tiff files and a text index of picture titles and descriptions. Provides slideshow interface, as well as browsing and searching.
- Resistor codes - Graphical resistor color band decoder. Select the colors of the resistor bands and it will calculate the resistance, or enter the resistance and it will display the colors.
- Yahtzee - plays yahtzee.
- Address book - simple contact database using JET.
- Robotics - provided simple interface for controlling a homemade robot. Also created simulators for a simple robot with proximity sensors to try out various navigation algorithms.
- Pong - plays pong.
- RCX - reverse engineered Spirit.ocx, used by Lego Mindstorms to program and communicate with the Lego RCX computer. Provided sample VB code and documentation on my Web site until Lego was able to release the official documentation to the public.
- Breakout! game for an Access database
- Pong game for an Excel spreadsheet
EDUCATION
SUNY, College of Technology, Delhi, NY
Majors
Associate in Occupational Studies Degree, May 1993.
Automotive Mechanics, GPA 4.0, Honors List.
Associate in Applied Science Degree, May 1993.
Individual Studies.(College Transfer Preparation program).
Received Delhi's Promising Scholar Award, 1992-1993.
References and examples furnished on request
Last Updated August 27th, 2002
©scott@holdren.com