John Kelley Hinsdale

Last updated: July 2, 2007

John Kelley Hinsdale
38 Quaker Road
Princeton Junction, NJ 08550-1650
Personal Email: hin@alma.com
Work Phone: +1 609-638-1713
Fax: +1 866-601-7952

WORK EXPERIENCE

Alma Mater Software, Inc., Princeton Junction, NJ

February, 1995 - Present

Consultant.. Independent contractor designing, implementing and managing mission critical applications for Web, database, scientific, and publishing companies.

Bristol-Myers Squibb Co., Hopewell, NJ May 2005 - February, 2007
Bioinformatics Developer. Oversaw the development and enhancement of large systems for genomics and sequence curation, several LIMS systems, and the entire High Content Screening imaging environment. Major projects included:

High Content Screening (HCS)
Oversaw support for the Cellomics and GE HCS infrastructure, including robotic plate scanners and all associated software. Managed content of two site databases (NJ, CT) with over 13 billion rows of data. Led development of custom in-house Web database application to perform quality control and assay design on top of the imaging environment, tying activities to knowledge bases for drug programs in various disease areas.
LIMS Systems (2)
Designed LIMS system for automation of request and results workflow for new centralized mouse genotyping facility. All information flow was automated, starting with sample gathering by veterinary scientists, through genotyping lab experiments, then publishing and tracking of results.
Continued support for similar LIMS automating requests and results gathering for in-house DNA sequencing group, analyzing DNA samples with Applied Biosystems (ABI) sequencing platform.
Genomics Curation System
Continued support and enhancement for genomics curation platform that allows researchers to record annotations electronically, with full audit tracking. System integrates the NCBI Reference Sequence (RefSeq) collection, also annotatable in-house, so that there is "one stop shopping" for all knowledge on a genomic basis. System is also integrated with company drug program tracking systems.

Also supported infrastructure for software development tools, and served as software development advisor to Ph.D. scientist coders as to best practices in software projects, e.g., code management, architecture, & data modelling.

Alma Mater Software, Inc., Tarrytown, NY October, 1999 - May, 2005
Software Developer. Independent contractor designing, implementing and managing mission critical applications for Web, database, scientific, and publishing companies. Did major projects at the following clients:

Bristol-Myers Squibb Co., Hopewell, NJ. (1997-1998, 2000-2002)
Web-based database applications for DNA sequencing and analysis. [projects]
Content Directions, Inc. (2001)
Electronic content tagging for the publishing industry [projects]
Little Sisters of the Assumption, New York, NY (2001-2002)
Pro-bono computer support for East Harlem women's clinic. [projects]

In addition to client work, also maintain an open source Oracle interface library at SourceForge.NET, publish articles and give talks from time to time.

@Plan, Inc., Stamford, CT September, 1998 - October, 1999
Director of Information Systems. CIO of the leading Internet market research company. Managed entire technical operations and development through successful IPO and product profitability. [projects]

Alma Mater Software, Inc., Tarrytown, NY February, 1995 - September, 1998
Software Developer. Independent contractor designing, implementing and managing mission critical applications for Web, database, scientific, and publishing. Did major projects at the following clients:

John Wiley and Sons, Inc., New York, NY (1998)
Electronic content tagging for the publishing industry
WNET Channel 13, New York, NY (1996)
Online program guide for major PBS stations.
Hearst Corp., New York, NY (1995-1996)
Web sites and search engines for popular American magazines.

In September, 1998, I temporarily suspended my work as a contractor to take up the full time position of CIO at @Plan, Inc. in Stamford, CT.

Goldman, Sachs & Co., New York, NY May, 1993 - February, 1995
Quantitative Strategist. Designed and developed securities trading and risk management software, including scheduling and optimization.

Responsible for development, maintenance, testing, installation, administration, and training for object-oriented trading database serving approx. 200 users worldwide. System is written in C++ runs on Solaris (server) and PC client. Used combination of proprietary and commercial database software.
Built first companywide risk of loss system for currency and fixed income derivatives markets. Continuously running (24 hr.) simulations estimate potential profit or loss given current trading strategies and past market movements. System used C, perl and reporting tools to generate reports of current financial position and statistical analysis of simulated profits and losses. Expanded system across other divisions to cover other fixed income and equities markets. Built automatic monitoring system to notify operators worldwide immediately of any outages. Profiled and tuned system efficiency.
Designed and wrote synchronization tool to feed trading data from four sites in U.S., Europe and Asia.

JYACC, Inc., New York, NY June, 1992 - May, 1993
Software Developer. Return to industry after graduate school. Wrote GUI software development tools for Unix.

McKinsey & Company, Inc., Cambridge, MA January, 1986 - July, 1991
Systems Architect Developed systems for and advised clients in financial, manufacturing, and airline industries.

Touch Technologies, Inc., Escondido, CA June, 1984 - August, 1984
Programmer. Developed educations software for school use.

EDUCATION AND RESEARCH EXPERIENCE

Columbia University, New York, NY	September, 1991 - May, 1995
School of Engineering and Applied Sciences

Master of Science in Computer Science, May, 1995. GPA: 4.0/4.0. Research in object-oriented databases done under the direction of Prof. Gail E. Kaiser.

Massachusetts Institute of Technology, Cambridge, MA September, 1981 - December, 1985
Bachelor of Science in Computer Science and Engineering, 1986. Research in cryptography done under the direction of Prof. Ronald L. Rivest.

Pre-college education

PUBLICATIONS

Oracle Library for CLisp

June, 2002

Oracle software Interface for CLisp language interpreter.
A DBI-like interface that allows programs to access Oracle. See http://clisp.cons.org/impnotes/oracle.html

World Wide Web Artist's Consortium, New York, NY June, 1997
Creating Custom Database Driven Web Sites.
Paper and presentation on techniques I developed for building high-performance Web-based database applications. Presented in New York City to the Special Interest Group on Database Systems.

OOPSLA Conference April, 1992
Schema Evolution in Object Oriented Databases. With G. Kaiser and I. ben-Shaul.
Describes algorithms and implementation techniques for migrating changes to the structure of an Object Oriented database, automatically mapping legacy data.

EuroCrypt '85 June, 1985
Is DES a Closed Cipher? With R. Rivest, A. Sherman and B. Kaliski.
Results of probabilistic tests for the closure property on the US government standard cipher. Results of thesis work at MIT.

MEMBERSHIPS, CERTIFICATIONS AND AWARDS

Member, Association for Communications Machinery (ACM)

1995 - present

The oldest professional association for computer scientists.

Member, Institute for Electrical and Electronic Engineers (IEEE) 1992 - present
The oldest insititue for electronic and computer engineering.

Oracle Performance Tuning Summer, 1998
Techniques in optimizing Oracle servers for speed.

MIT Scholarship Award September, 1981 - May, 1985
Financial scholarship award.

Top