Submit a Support requestWant to know what software and other computer resources are available to you? Check out the Faculty of Science
IT Support and Biology's Computing Facilities and Help.
Current and Ongoing Projects:Online Publications Database. This provides an updated lists of publications for members of the department. The public can view complete lists of publications (Switch tdwillia in the URL to any other Biology Faculty computing ID) as well as Selected Publications of any faculty member. Individual faculty and researchers can add and edit their publications as well as authorize other individuals to update their publication lists. The current version uses Filemaker as the database and Apache/PHP for the web interface, while we have working version using a MySQL database based on Bibliograph. Teaching Assistantships System. Online Applications, Offers, Acceptance, TUG forms, Workload Review, and Evaluations. Uses PHP, Filemaker
and SFU's Central Authentication Service (CAS). Booking of Rooms, Equipment, and Undergraduate Advisors. I modified the open source MRBS for our needs. It uses PHP, mySQL as well as CAS authentication. Students' booking are confidential and they are reminded of their appointments by email through a nightly cron task. Updating
Filemaker. All online and departmental databases are now in Filemaker 16/17, and
use PHP/ Apache to serve web forms and data. The webserver is a Redhat VM and the database server is a Windows VM. Previously everything was served by a Mac mini (regular hardware/ OS, not the server version), Filemaker server version 11, and we first transitioned just the Apache web server from the mac mini to the Redhat VM, then later on upgraded the databases to Filemaker version 16 with no problems.
Web Sites: PUBLICATIONSPROFESSIONAL EXPERIENCESystems Consultant, Simon Fraser University, 1996-Present.Computing Advisor for the Biological Sciences Department and the Dean of Science. Responsible for database development, networking, and web design. Courtesy Faculty, Oregon State University, Corvallis. 2011-12. (Disclaimer: Totally courtesy of OSU- I continued to concentrate on my work for SFU) Visiting Scientist? /Associated Person, Duke University, Durham, North Carolina. 2003-4. Visiting Scientist, Umeå University, Sweden. 1997-1998. Post-Doctoral Fellow, Simon Fraser University, 1994-1995. Sequencing DNA and phylogenetic analysis Training personnel in PCR and sequencing techniques Manager of Molecular Laboratory for Dr. Bernard J. Crespi Research Assistant, University of California, Davis, 1989-1993. Sequencing DNA of Holometabola for phylogenetic analysis (UC Berkeley) Systematic study of the Trigonalidae (Hymenoptera) Responsible for computer accessibility and databases of Bohart Museum Teaching Assistant, University of California, Davis. Insect taxonomy/field ecology (1992), Biogeography (1991, 1992), Parasitology (1989). Research Assistant, Oregon State University, 1985-1988. Studied yellowjackets and their associates. Created and organized computer databases of Trigonalidae and Symphyta literature, and Lepidoptera host plants. Research Assistant, Washington State University Cooperative Extension, Seattle. Part time, Oct. 1984-May 1985. Root weevils, with Sharon Collman. Entomologist, Basseterre, St. Kitts (West Indies) Integrated Pest Control Unit, 1982-1984. Biological Control, with Everton Dolphin, Trevor Blanchette, and Conrad Kelly. Science and Agriculture Teacher, Bumbuna, Sierra Leone, West Africa, 1980-1982. (Peace Corps Volunteer, 1980-1984.) Research Assistant, Washington State University, Pullman, 1978-1980. Laboratory and field research of yellowjacket behavior and life history. EDUCATION 1993. Ph. D. Entomology, University of California, Davis. A generic revision of the trigonalid wasps (Hymenoptera) and a molecular study of 18S rDNA and the holometabolous insects. 1989. M.S. Entomology, Oregon State University. Corvallis, Oregon. Biology of the yellowjacket parasitoid Bareogonalos canadensis (Harrington) (Hymenoptera: Trigonalidae). 1980. B.S. Entomology and B.S. Biology. Washington State University, Pullman, Washington. 1975. Argenta Friends School, Argenta, British Columbia. (All 8 of our graduating class were in the top 10!)
SPECIAL TRAINING |