NSO Press Inc. , Denver, CO  -- 2006 to 2010

£ Brought in to get a Microsoft Access (ver. 2003, 2007) tool working that was highly code dependant, appropriately replaced code with queries and new code (VBA).  The tool collects data from an Excel order sheet on a daily basis, and also collects information from PDF files for order reports.  The tool has been revised into another product for a similar customer. £ Complimentary to the tool is a developed Excel Add-in which conditions the data prior to importing to Access.

State of Colorado, Alcohol and Drug Abuse Division (ADAD)  Denver, CO --  2003 to 2009

£ Replaced 100+ page-based directory of Colorado treatment providers and institution with automated State web page directory  --(http://www.cdhs.state.co.us/ohr/adad/treatment/directory.asp)

 developed using MS Front Page, linked to a full MS Excel (ver. 2000) automation of listings, using expert design, and VBA/macros.  Work included Front Page customization using JavaScript and HTML coding. Tool operations were variously designed for multi-browser use.  £ Normalized and converted two MS Access  (ver. 2000)  databases into full automation, including ADO, and ADOX commands for transfer and management of SQL Server tables. Implemented full security to HIPAA standards.   £ Utilized 100-step process for MS Access data protection, including VB6 deployment.

TechAmerica, Lakewood, CO  -- 2008 to 2009

£ Brought in to add functionality to existing Access  (ver. 2003) tool for this parts and service provider to 15,000 McDonalds restaurants.  The tool improved ordering and tracking and directly interfaced with a third party tool based on SQL Server.

Headington Oil Co., Lakewood, CO -- 2007 to 2008

£ Developed two tools from ground up.  One tool was for well production measurements of over 100 wells, replacing three manual systems.  The other tool was a prototype for rig management.  Both tools involved highly-automated entry and reporting using Microsoft Access (ver. 2003, 2007), with in-program VBA outputs to PDF, and formatted Excel (ver. 2003, 2007) reports, including graphs.

Synergistic Software Solutions  , Minneapolis, MN  -- 2006 to 2007

Remote contract.  £ Developed Access portion of MAS 500 Production Management Extensions for Light Manufacturing tool, utilizing Microsoft Access adp database front end to MAS500 (Sage MAS 500 ERP system based on Microsoft SQL Server, Visual Basic and Microsoft Office) .  This tool allows production managers to perform various automation tasks; among them to drill down to SQL records, release production line items and run MRP updates.  A work center screen provides production stage coding and time sequence automations for line items, brings up a standard MAS 500 entry form from within Access, in addition to other automation visual conveniences.   

AT&T Broadband,    Littleton, CO  -- 2000

£ Performed all database administration and new development operations on a very active and large Access 97 database which tracked rebuild and upgrade status for all North America cable TV, broadband internet, and telephony holdings, including ongoing acquisition and divestiture data.  Database directly served 5 operations managers, top management, all field offices (20+) and various ad-hoc corporate requirements.  Responsible for database ownership, security and user rights assignment over Microsoft NT network. Developed event-driven user forms, which controlled a variety of functions, including report generation, data export, data import, accounting reconciliation and testing, and verification.  Imported data from and exported data to Oracle OLAP, Sybase, Excel, MapInfo and other applications.