Ian T. Flockhart

SUMMARY

Skilled database applications developer with over 10 years experience in Web interface development for high-throughput screening environments.

SKILLS SUMMARY

PROFESSIONAL EXPERIENCE

• Designed and implemented complete Bioinformatics/LIMS system using CGI/HTML, MySQL and an assortment of informatics tools.

• Wrote custom informatics and statistical analysis tools for LIMS system.

• Helped and advised visiting scientists with analysis of high-throughput experimental data.

• Instructed visiting scientists in the use of DRSC systems and general statistical and informatics methods.

• Assisted scientists in processing and storing data from extremely heterogeneous experiments.

• Designed, updated and maintained DRSC website. Maintained the Center's computer equipment including specialized equipment such as multi-terabyte RAID disk arrays.

• Designed, updated and maintained database of laboratory stock and experimental data. Wrote and maintained on-line sign-up and billing system for shared laboratory resources.

• Developed and taught graduate programming class (Perl and Python) as part of curriculum for Master's degree program in Bioinformatics.

  Senior Scientific Software Engineer - Bioinformatics
  AlphaGene Inc., Woburn, MA	8/98 to 5/02

• Created fast turnaround sequence data analysis solutions customized for a variety of specialized needs.

• Developed wide variety of in-house software tools as needed (in Python, some C).

• Enhanced and maintained corporate Bioinformatics/LIMS system with CGI/HTML, Oracle and specialized Bioinformatics tools

• Designed expandable CGI database for use with NEN's Gene Chip products (chips produced by AlphaGene)

• Supported hardware and software for a heterogeneous network of assorted Unix, MS Windows and Macintosh systems as well as specialized laboratory equipment.

• Managed transition to internal DNS name servers for the alphagene.com domain. Installed and configured primary and secondary Linux name servers.

• Functioned as System Administrator and Database Administrator for entire company, in addition to my regular duties, during periods when those positions were vacant.

• Administered and updated AlphaGene's Oracle database and managed corporate website.

• Trained and managed junior programmers. Taught internal class in C Programming

• Developed an application toolkit generation program to provide customized interfaces to the Faircom c-tree toolkit for individual databases.

• Developed a high performance call data retrieval system in C for a large-scale CTI system.

• Developed key components of a CORBA client/server toolkit in C.

• Created SQL database product and ported it from Informix to Sybase, Oracle and DB2.

• Wrote course materials, designed curriculum, then arranged, scheduled, and taught customer classes. Extensively reviewed and revised core documentation.

  Software Engineer
  The Cadmus Group, Inc., Waltham, MA	9/92 to 9/96

• Developed security problem solutions and computerized tracking systems in C, dBase and FoxPro.

• Developed and maintained a high speed OTC trading system interface using X Windows/motif. The interface involved both motif and custom widgets, customized application resources and multiple windows clients coordinated as a single X application.

• Ported X Windows/motif application to multiple UNIX platforms including SOLARIS and IRIX. This involved the resolution of many issues related to variations in widget implementations and resources.

• Independently developed C motif code generator program in awk to accelerate production.

• Developed and maintained Informix SQL server code as part of a team effort.

• Served as the principal developer of the Price Reporting System for the Commodities Exchange Center in New York.

• Developed client/server, OLTP, fault-tolerant, remote site disaster recovery, 24-hour/zero downtime systems.

• Translated C code to COBOL to reduce costs at Pacific Options Exchange.

• Developed in-house multi-user interactive communication/message system.

PUBLICATIONS

Flockhart I, Booker M, Hu Y, McElvany B, Gilly Q, Mathey-Prevot B, Mohr S. FlyRNAi.org—the Database of the Drosophila RNAi Screening Center: 2012 Update. Nucleic Acids Res. 2011 Nov 8. (epub ahead of 2012 Jan publication)

Hu Y, Flockhart I, Vinyagam A, Bergwitz C, Berger B, Perrimon N, Mohr S. An Integrative Approach to Ortholog Prediction for Disease-Focused and Other Functional Studies. BMC Bioinformatics. 2011 Aug 31;12(1):357.

Booker M, Samsonova AA, Kwon Y, Flockhart I, Mohr SE, Perrimon N. False negative rates in Drosophila cell-based RNAi screens: A case study. BMC Genomics 2011, Jan 20; 12:50

Ramadan N, Flockhart I, Booker M, Perrimon N, Mathey-Prevot B. Design and implementation of high-throughput RNAi screens in cultured Drosophila cells. Nat Protoc. 2007;2(9):2245-64.

Flockhart I, Booker M, Kiger A, Boutros M, Armknecht S, Ramadan N, Richardson K, Xu A, Perrimon N, Mathey-Prevot B. FlyRNAi: the Drosophila RNAi screening center database. Nucleic Acids Res. 2006 Jan 1; 34(Database issue): D489-D494.

EDUCATION

M.S. Bioinformatics, Brandeis University, Waltham, MA	05/01/09
The Genome Access Course, Cold Spring Harbor Laboratory, NY	5/2002
Oracle 8: Backup and Recovery Workshop, Oracle Training Center	6/1999
Oracle 8: DBA, Oracle Training Center	6/1999
Intro to Oracle for Experienced SQL Users, Oracle Training Center	5/1999
X Windows/Motif Training, Open Software Foundation	Fall 1992
UNIX Proficiency Certificate, UMASS Lowell	Summer 1992
B. S. Computer Science, UMASS Amherst	1989