Enterprise Solutions

• Investment Management [Third Security; 2007] Designed database and built web application to manage investor transactions and reporting for private equity funds. [MySQL; PHP; Linux, Windows]
• Database/Web Development [New City Media; 2005-2007] Designed databases to support a variety of highly interactive web sites. Built web based administrative interfaces to facilitate site maintenance by customers. Upgraded several databases to enforce referential integrity and enhance performance. Developed a variety of data migration procedures. [SQL Server, T-SQL, DTS, MySQL; PHP, Perl, CodeCharge, Subversion; Windows, Linux, IIS, Apache]
• Database Administration [US Army / ALTESS; 2004-2005] Senior data modeler and database administrator. Responsible for developing and implementing database designs for new and existing applications, and for providing ongoing support and technology R&D. Worked with application developers to refine requirements. Conducted code reviews of database objects. Responded to ad-hoc requests for data analysis. [ERwin, ModelManager; Oracle 9i, Discoverer, Workflow, PL/SQL; Perl; TOAD, XMLSpy, MapForce]
• Document Management [New River Pharmaceuticals / Third Security; 2003] Designed database to store legal documents and related metadata for complex holding company. Included reminder system to notify task assignees of upcoming deadlines and due dates. Built associated intranet to facilitate searching, maintenance, and reporting. Migrated data from existing application. Integrated external image viewers and spell checker. [PHP; SQL Server, T-SQL, DTS; Windows 2000/IIS]
• Survey Analysis [Carnegie Communications; 2002] Designed generic database (four tables) to store survey results, where a survey may consist of any number of questions, each with any number of possible responses. Built associated web site to dynamically construct queries and present results in graphical form. [Dreamweaver UltraDev, ASP; SQL Server; Windows 2000/IIS]
• Pharmaceuticals [New River Pharmaceuticals; 2001] Designed database to integrate data from government and other external sources with proprietary legal and scientific information related to the manufacturer of pharmaceuticals. Built associated web application for users to query and link to external data. [SQL Server, T-SQL; Visual InterDev; Windows 2000/IIS]
• College Search [Carnegie Communications; 2000-2002] Responsible for maintaining, debugging, and enhancing web sites designed to help high school students identify colleges and universities matching their requirements. Extensive use of DTS to migrate data from third-party sources. [SQL Server, T-SQL; Visual InterDev; Windows 2000/IIS] More info and links.
• Parts Catalog [Advance Auto Parts; 1999-2000] Designed model for a maintaining unified catalog of parts from a variety of vendors, including their application to specific vehicles. Intensive use of generic techniques. Built and administered database. Wrote numerous stored procedures and conversion scripts. [SQL Server, T-SQL, DTS; Windows NT/2000]
• Telecommunications Billing [Tascom; 1994] Reverse engineered model for existing application which monitors and bills for X.25 traffic in a multi-national environment.
• Real Estate [Planning Research Corporation; 1989-1991] Designed model for configuring complex multiple-listing application used by over forty independent real estate boards. Reduced setup time by two-thirds.
• Emergency Room Data Entry [Baxter Healthcare; 1987-1988] Designed and developed a highly interactive, pen-based system for managing medical supply records and patient information. [C, dbVista; MS-DOS, Linus WriteTop]
• Hospital Marketing [Fulbright & Jaworski; 1989] Reverse-engineered data models for two applications in connection with copyright infringement lawsuit. Evidence developed was deciding factor in case.
• Communications Network Planning [Bell Laboratories; 1983-1984] Graphics-based decision support system; designed, developed libraries to perform network selection, traffic rerouting, demand aggregation. [C, Ingres; UNIX]
• Inventory, Production, Revenue Accounting [J. M. Huber Corp.; 1980-1983] Designed and developed a variety of accounting systems; maintained and updated existing systems to meet new reporting requirements. [PL/I, MIMS; MVS]

Tools and System Software

• Flickr Interface [New City Media; 2006] Created library of stored procedures to interface with Flickr, enabling web developers to access photo metadata via conventional database methods. [SQL Server, T-SQL, REST, XML]
• Database Daemon [Computer Resource Team; 2000] Designed and constructed a daemon that accepts requests from a database to execute operating system commands and return results to calling process. [Perl; Oracle 8i; Linux, NT] Described in Perl for Oracle Developers.
• WWW/LDAP/X.500 Gateway [Worldtalk (acquired by Tumbleweed); 1997] Designed and implemented enhancements to existing product which allow users to modify public distribution lists residing in an X.500 directory. [C, HTML, LDAP; HP/UX]
• Messaging [Hewlett Packard; 1996-1997] Lead engineer on port of major enterprise messaging server and associated UNIX clients to DEC Alpha (64-bit); support for sendmail, UNIX, and X.400 gateways. [C; HP/UX, Digital UNIX]
• Client/Server [Anthem, Meridium; 1995-1996] Designed and developed several database and file transfer interface modules using various protocols, including TCP/IP sockets and CPIC(LU6.2). [C; AIX, VMS, Windows/NT]
• Query Generator [Tascom; 1995] Designed and developed query generator and associated database that dynamically produces SQL based on parameters collected by a PowerSoft front-end. [Oracle 7.1, PL/SQL]
• Handwriting Interface Libraries [Linus Technologies; 1987-1988] Developed the core of an object-oriented windowing system for pen-based computer; designed, developed handwriting interface. Taught courses. [C; MS-DOS]
• Message Queue [Planning Research Corporation; 1988] Designed and coded a C++ class which uses shared memory to implement a message queue for interprocess communication; avoids system call overhead. [C++; HP/UX]
• Data Conversion Utilities [ongoing] Developed a variety of utilities to facilitate database updates, including a general purpose conversion program. Designed and developed import language extensions. [Perl, DBI, C, lex, yacc; Oracle, MS-SQL, Unify, Informix, Raima; UNIX (various), NT]

Scientific Applications

• Genetics Formulated mathematical model; designed and developed system to investigate the nature of biological equilibrium when selection pressure is frequency dependent.
• Game Theory Formulated and solved problems dealing with the power of agenda setting; developed system to calculate fitness of multi-dimensional spatial voting model.