Relational Databases

MassMutual Financial Group - Involved with Corporate Database Adminstration for a variety of projects, including E-Mail Push. Worked with eBusiness Database Administration on design and implementation of content management databases.

V-Technologies - ShipGear product (integrated 30 accounting systems with "n" shipping systems) middleware architecture. Designed and implemented a database containing "attribute description" rows which were used to fetch actual database attributes from specific accounting system rows per request by combining and executing arbitrarily complex SQL. Combined SQL was optimized by using special techniques to recognize which statements referred to the same database tables. SQL statements were generated at run time and could be SELECT, DELETE or INSERT/UPDATE depending on request type. Product was developed with DBMS independent "attributed description" database and was used with dBase, Interbase and SQL Server. It could also work with any ODBC / ADO compliant accounting system databases. Tested with SQL Server and Btrieve.

PetroVision - PVMapping product line architectures (geographic information systems with route planning), designed and developed to be DBMS independent. Retargeted to SQL Server from dBase with only minor programming changes. Designed and implemented sequencable "bin" tables which could be reordered. A record could be in 0 or more bins as needed. Product allowed use of owner-specific domains for product code, status and other attributes.

Heberger and Associates - Designed and implemented dBase database for appraisal data; accessed using Codebase API.

Anocoil Corporation - Designed and implemented order, manufacturing, resource planning and purchasing databases. Pick Operating System DBMS.

Wheeler Group - Designed and implemented mail order fufillment ("manufacturing") databases. Pick Operating System DBMS.