History


  • Docket Systems, LLC Developed DocketWorks, an Access database, using VBA, DAO and SQL. Database was used for managing legal dockets, and included modules for managing clients, matters, contacts, tracking foreign and domestic laws, time-keeping, scheduling, billing, forms, and automated SMTP e-mail.
  • Bauman Rare Books Designed, developed and maintained rare books Access database, using VBA, DAO, SQL and T-SQL. Ported database from Access to SQL Server and administered SQL Server database (performed maintenance and backups, and developed stored procedures, schemas, views, and triggers). Accessed SQL Server data through ODBC linked tables and pass-through queries. Developed and maintained customer, book inventory, cataloging, invoicing, and other modules, and provided customer support for the database. Developed module for generating fully-formatted Word documents, using Rich Textbox controls within an Access form, and used Automation with Word and Outlook for other tasks. Created automatic SMTP e-mail notification system using CDO for Windows. Set up system to automatically update corresponding Web database on a nightly basis, and perform other nightly tasks. System was used by over 50 users in 3 locations using Remote Desktop Connection.
  • Remark Capital Group Developed Access database for managing customer solicitations, including reporting, letter generation, etc., using VBA, DAO and SQL.
  • Dart Business Accessories Developed Access database for developing and managing customer quotes for products, using VBA, DAO and SQL.
  • Internet Resources Developed Access database for gasket manufacturing company, using VBA, DAO and SQL. Database tracked all aspects of business, including orders, materials acquisition, parts manufacturing, customer information, inventory, and invoicing. Wrote user’s guide for database in Word.
  • JC Penney Enhanced lease tracking system developed in Access, using VBA, DAO and SQL. Provided functionality to create extract of estimated invoice information for entry into accounts payable system; developed module to archive data; significantly enhanced reporting, data entry, and lookup table features.
  • Tripp Consulting Provided enhancements to Access book inventory database to create catalogs of inventory items, print invoices, and to create inventory descriptions as Word documents created through Automation and linked to database via OLE. Also provided functionality to create catalog documents and inventory lists in Word through Automation. Used VBA, DAO and SQL.
  • Centex Corp/CTX Mortgage Developed Access database to track employee performance cards, using VBA, DAO and SQL. Employee list and other lists were generated from ADP system export, with defunct data automatically archived. Developed Access database to schedule employee training classes and to assign employees to classes. Complex reporting options were provided for both systems.
  • Akin, Gump, Strauss, Hauer & Feld Modified previously-developed Access database to export records to and import records from Microsoft Outlook using Automation, as well as to automatically generate e-mail in Microsoft Outlook. Also enhanced functionality for document creation in Microsoft Word through Automation. Provided additional reports and enhancements. Used VBA, DAO and SQL.
  • Aloe Commodities International Provided enhancements to Access database used to track product sales and commissions, using VBA, DAO and SQL.
  • De La Porte & Associates Developed Access database for use with leadership development program, using VBA, DAO and SQL. Database tracked 360 feedback scores, employee development responses, personal goals, counseling sessions, and course work. Database provided extensive reporting.
  • First Tennessee Mortgage Led team of Access developers in converting a series of applications from Paradox to Access. Applications used Oracle as a back end and accessed data through ODBC linked tables and pass-through queries. Wrote modules that were used globally throughout the applications, implemented Access security, coordinated project details, and acted as a resource for other developers. Used VBA, DAO and SQL.
  • Goodall Distributing Enhanced existing Access database used for purchasing and invoicing. Added Access security to the system and documented the security. Used VBA, DAO and SQL.
  • Akin, Gump, Strauss, Hauer & Feld Designed and developed contact management database for law firm using Access, using VBA, DAO and SQL. Database interfaced with Microsoft Word through Automation and with Banyon BeyondMail through DDE to automatically generate letterhead documents, envelopes, labels, e-mail messages, etc., for one or for a list of contacts. Database also managed client matters, tracking matter contents and storage information, and associating client matters with contacts. Wrote user's guide and administrator's guide for the database in Word for Windows, and provided hypertext version of user documentation. Completed series of databases for Word Processing department pertaining to job tracking, time card tracking, and emergency notification information, using VBA, DAO and SQL.
  • PrimeCo Personal Communications Maintained and enhanced existing sales compensation management system using Access, using VBA, DAO and SQL. System was used to pay sales commissions, quarterly bonuses, etc.
  • GE Capital Real Estate Maintained and enhanced existing asset management system using Access, with Oracle back end data accessed through ODBC linked tables and pass-through queries. System was used to track property and loan assets. Redeveloped financial forecasting module, and provided documentation. Used VBA, DAO and SQL.
  • Remington Hotel Corporation Completed Access database application for tracking room and catering contracts, booking goals, sales contacts and goals, etc., for various hotels, using VBA, DAO and SQL. Application included sophisticated querying and reporting, and was used in a multi-user environment, using the Access runtime on a Citrix WinFrame server running Windows NT 3.51.
  • Electronic Data Systems Converted a series of databases from Q&A for DOS format to MS Access 95. Provided user documentation and trained users.
  • Dallas County Schools Designed and developed database application consisting of modules for tracking bus routes, extracurricular trips, and payroll using Microsoft Access, using VBA, DAO and SQL. Bus route module tracked route hours, driver assignments, budget information, etc., and fed information to payroll module. Extracurricular trip module scheduled extracurricular trips, assigned drivers, completed trips, wrote driver hours to payroll module, and invoiced client. Payroll module reported driver hours by budget code, calculated adjustments from prior periods, and notified extracurricular trip module of any overtime hours for additional invoicing. All modules employed Access security in a multi-user environment, using the runtime version of Access on a Citrix WinFrame server running Windows NT 3.51. Wrote user documentation using Word for Windows.
  • Exxon Corporation Designed and developed database application for Records Management Department using Microsoft Access, using VBA, DAO and SQL. System tracked cartons of records that were checked out, checked in, destroyed, etc., and employed Access security in a multi-user environment. System also provided various reports, batch processes, and other administrative tools. Wrote user documentation using Word for Windows.
Designed and developed database application for Procurement Department using Microsoft Access, using VBA, DAO and SQL. System consisted of various modules pertaining to the generation and tracking of purchase orders, entering and validation of receipt and invoice data pertaining to each order, and maintenance of vendor data, and employed Access security in a multi-user environment. System allowed for change orders and archiving of previous versions, as well as reports, batch processes, and other administrative tools. Wrote functional specs and user documentation using Word for Windows.