Francis G. Williams
9712 Digging Road
Montgomery Village, MD  20886
Phone:  [Send email to request phone number] 47-6541
Fax:  [Send email to request phone number] 47-4754
Email: [Send email using form at bottom]
CURRENT AND RECENT EMPLOYMENT
September 1999-June 2006 – Data Coordinator for American Association of
Community Colleges, Washington, DC. Refer to SKILLS AND EXPERIENCE DETAILS below
for duties performed.

July 2006 to present – Consultant to American Association of Community Colleges,
Washington, DC. Created and developed menu driven databases for the association
annual convention and special conference meetings; and imported web meetings and
events data.

SKILLS AND EXPERIENCE SUMMARY
More than 10 years of experience in database management for a non-profit
association utilizing an association management system with Microsoft Access 2003
& 2007 as the back end. Very strong skills in development of MS Access 2003 &
2007 separate databases with complete menu systems; in creation/maintenance of
macros, forms, queries, reports; and use of MS Word 2003 & 2007 and MS Excel 2003
& 2007 in extracting/outputting data. 
SYSTEMS PROFICIENCY
Hardware: Personal computers
PC Software: Microsoft Access 2003 & 2007, Excel 2003 & 2007, Word 2003 & 2007,
Internet Explorer

EDUCATION
B.A., Trinity College, Hartford, CT

SKILLS AND EXPERIENCE DETAILS
Management and coordination of multiple relational databases, including
maintenance of existing databases and creation of new relational databases to
adapt to changing data needs; database management support to evolving web based
data programs; development of relational database tools such as queries, macros,
and reports, for efficient and timely output of data to all publics served;
coordination of the operation of the association management system (AMS).

Creation of new, and revision to existing, MS Access 2003 & 2007 tables,
queries, forms, reports, and macros to meet the demands of user generated data
output requests (and then production of the desired data output), including
updates of data for membership directory; data and reports for web sites; data,
confirmation letters, reports, and badges for conventions/meetings.

Development in Access of stand-alone auxiliary databases with related tables,
menus, input forms, reports, queries and macros.

Coordination of association management system (AMS) operation with development
of reports, queries and macros for the AMS reports menu; and liaison with the AMS
vendor of software operation problems.

Import/Export and manipulation of internal/external data into and out of
Excel/Access formats; and merging of Excel/Access files with Microsoft Word for
output of letters and labels.

Development of utilities for maintenance of main database, such as automated and
semi-automated changes in certain field content; and automated updates of sets of
data.