Keith Williams

Experience

• 

  The Endocrine Society

  Aug 1984 - Aug 1999

  • Aided in assessing and acquiring computer needs for the Society staff which grew from 4 to 45 persons• Managed the operation of the DEC MicroVAX 3190 computer system using the VMS operating system and all modules of the Smith, Abbott & Company’s (SACO) character-based AMS • Provided all aspects of system and database management, trained staff on use of the AMS and other Windows-based software, desktop & software troubleshooting, installation/upgrading approved software, Windows NT 4.0 network/server administration, MS Exchange Server 5.5 administration, , maintained regular backups, set computer usage policy and procedures and advised on all computer-related purchases • Computed statistical information based on database data • Aided production of the Membership Directory and Directory of Key Society Members • Responded to help desk requests for all hardware/software and assisted staff when necessary in the production of reports, mailing labels, word processing merge files, and file exports from the database • Wrote user manuals, usage guidelines, and tips/tricks sheets for staff on various software • Aided in converting the Society from the VMS system to a Windows NT Server/Windows 95 client-based system and converting from the SACO AMS system to Data Management Group’s DMG4 system; oversaw data conversion from Autopro to Unidata (DMG4’s database) • Aided in migrating the Finance dept to Great Plains Dynamics, as well as advising on other software uses/products • Arranged for rental and installation of computer equipment for use by staff and attendees during the Society’s Annual Meeting, as well as reconciled monies taken in during the conference, manned the Society’s exhibit booth and demonstrated the Society’s web page to attendees, answered general questions about the Society and helped attendees resolve registration issues Show less • Acted as a staff liaison to the Membership Committee • Processed membership applications for review by Membership Committee, including corresponding with applicants on application status• Entry and upkeep of member and non-member databases; entry of data for Training Opportunities in Endocrinology directory • Liaison with contracted subscription/dues processing service personnel to assure accuracy of dues/subscription information • Processed requests for rental of society mailing lists • Entry of data for the Annual Meeting Program and Abstracts Guide and aided the Program Committee with scheduling abstracts for presentation • Created a registration system in dBase II/III+ for use of Society’s smaller (up to 300 attendees) meetings; system was used for several years until purchase of SACO integrated AMS Show less

  • Systems Manager

    Oct 1989 - Aug 1999

  • Data Entry Operator/Membership Processor

    Aug 1984 - Oct 1989
• 

  Assisted Living Federation of America

  Aug 1999 - Jun 2002

  • Managed national trade association database, iMIS Millennium/Adaptive Server Anywhere AMS• Set data entry standards and ensured data consistency • Provided statistical reporting and analysis • Supported Windows NT servers, Windows 95/98/NTWS desktops, MS Office and assorted Windows-based software• General maintenance of network and computers, managed network accounts and Exchange mailboxes, managed MS Exchange 5.5 Server and ensured regular backups completed • Installed and maintained peripherals such as printers and scanners • Wrote user manuals, usage guidelines, and tips/tricks sheets for staff • Trained or arranged for training of staff in use of approved software• Provided general Help Desk support and managed Help Desk requests • Assisted with analysis of hardware/software to support purchasing decisions • Acted as primary contact/liaison to IT vendors • Reviewed resumes and helped interview candidates for technology-related positions Show less

  • Director of IT

    Dec 2000 - Jun 2002

  • Database Manager

    Aug 1999 - Dec 2000
• 

  DataMax Solutions

  Sept 2002 - Nov 2009

  Client Technology Specialist

  • Provide database and technical support to Association clients • Assist with management, reporting from and general use of databases including multiple versions of the iMIS AMS and custom Access databases • Provide general database administration, including periodic maintenance routines, writing reports using Crystal Reports, adding data elements, writing instructions for various tasks, creating SQL stored procedures and views when necessary, and some training of staff and clients in use of iMIS • Led several major upgrades of iMIS, as well as helping to re-engineer associations’ membership structure and how to implement in iMIS • Aid in answering client’s member requests and general processing Show less

• 

  Irrigation Association

  Dec 2009 - Aug 2017

  • Manage national trade association IT operations• Provide network, server and workstation maintenance and support• Create and manage IT budget• Manage multiple vendors and ensure projects are completed in timely manner• Manage phone system• Manage iMIS AMS database• Create SQL stored procedures and views as needed• Set Data entry standards and ensure data integrity/consistency• Install and maintain peripherals such as printers and scanners• Create documentation for IA use of IT systems and policies as needed• Train or arrange training for staff in use of approved software• Create reports using various reporting tools including iMIS IQA, TSQL, Crystal Reports, etc.• Manage various cloud based services, including hosted Exchange server• Provide support as needed for hosted website issues and Informz• Provide general Help Desk support and manage Help Desk requests Show less • Manage national trade association IT operations• Provide network, server and workstation maintenance and support• Create and manage IT budget• Manage multiple vendors and ensure projects are completed in timely manner• Manage phone system• Manage iMIS AMS database• Create SQL stored procedures and views as needed• Set Data entry standards and ensure data integrity/consistency• Install and maintain peripherals such as printers and scanners• Create documentation for IA use of IT systems and policies as needed• Train or arrange training for staff in use of approved software• Create reports using various reporting tools including iMIS IQA, TSQL, Crystal Reports, etc.• Manage various cloud based services, including hosted Exchange server• Provide support as needed for hosted website issues and Informz• Provide general Help Desk support and manage Help Desk requests Show less

  • IT Director

    Mar 2015 - Aug 2017

  • Senior IT Manager

    Dec 2009 - Mar 2015
• 

  AAMI

  Sept 2017 - Apr 2019

  Database Administrator

  Responsible for the use, setup, maintenance and reporting of the iMIS AMS database. Work with SQL to automate processes and data exception reports.. Other responsibilities are • Ensure data remain consistent across the database and perform data clean-up as necessary• Ensure the database reflects the needs of users, the organization and enhances the member experience• Document design and configuration of the database• Create and design reports and queries• Install and test new database modules• Reconfigure existing database modules• Ensure seamless integration of the database with the AAMI website and other third party tools• Work closely with IT and web project managers, external database and web development support providers, and internal stakeholders/clients (staff)• Liaison with vendor on design enhancements or database modifications to meet new business needs• Manage staff user rights and related Db training• Coordinate training of IMIS to users • Perform database tasks as needed in support of AAMI day to day operations• Stay up to date on new modules and products for iMIS• Maintain and enforce the organization’s electronic records retention policy• Document/maintain iMIS policies and procedures in accordance with the organization’s business rules and industry best practices Show less

• 

  AAMFT

  Apr 2019 - Aug 2024

  IMIS Operations Manager

  • Responsible for the use, setup, maintenance and reporting of the iMIS AMS database. • Work with SQL and Process Automation Plus to automate processes and data exception reports.• Ensure data remain consistent across the database and perform data clean-up as necessary• Ensure the database reflects the needs of users, the organization and enhances the member experience• Create and design reports and queries• Install and test new database modules• Reconfigure existing database modules• Work closely with IT and web project managers, external database and web development support providers, and internal stakeholders/clients (staff)• Liaison with vendor on design enhancements or database modifications to meet new business needs• Manage staff user rights and related database access• Manage third party tools such as iDMS, iAppConnector, Higher Logic Communications Professional, and PropFuel• Coordinate training of iMIS to users • Review and recommend any add-on products/services for iMIS• Stay up to date on new modules and products for iMIS• Maintain and enforce the organization’s electronic records retention policy Show less

• 

  Association for Career and Technical Education

  Sept 2024 - now

  IMIS Database Manager