One of the most prestigious institutions of higher learning in the United States, Cornell University in Ithaca, NY prides itself on the diversity of both its student body and the educational experience it offers. Incorporating 11 undergraduate, graduate, and professional schools, Cornell is world–renowned for its specialized programs in hotel administration, industrial and labor relations, and veterinary medicine. A dedicated faculty and support staff are essential to carrying forward Cornell's mission, and FileMaker Pro 7 is a valued tool for the university's administrators.

Business Challenge

With thousands of employees, documenting job performance and determining appropriate compensation for Cornell's staff is a complex task. At Cornell University's College of Engineering, currently ranked by U. S. News and World Report as one of the top ten graduate engineering programs in the nation, Programmer Analyst Senior Paul Davis develops solutions to meet that challenge. "I gather a lot of data for our faculty data summary," explains Paul, "for the dean and the department chairs to use in quantitatively measuring faculty effort each semester. This information is used in helping directors, chairs, and the dean in determining performance levels."

The information is also important in the classroom itself — where documenting the number of course hours taught helps in allocating the number of teaching assistants assigned to each class.

There was a time when this information shuttled from office to office and desk to desk in clumsy emailed spreadsheets — and not only was this an inefficient method of conveying information, it could also leave sensitive data open to unauthorized access. Clearly, there was room for major improvement.

Successful Solution

FileMaker Pro is widely used around the Cornell campus and Paul has been using the software for many years. He was looking for greater efficiency, greater flexibility, and the ability to build a more comprehensive system by migrating to FileMaker 7. He was delighted with what he found he could do.

Paul's system is made up of 19 FileMaker Pro tables, containing thousands of individual records. It fulfills three major functions — gathering recommendations for compensation, documenting contract hours taught by faculty members, and the preparation of an overall faculty data summary. Administrative officials throughout the College of Engineering are able to key in the necessary information, submitting the raw data Paul uses to generate the necessary reports.

With FileMaker Pro 7's SSL encryption across the wire, we can know who's logged in and we can track that and attach it to our logging. This will save us a lot of effort in managing security. FileMaker Pro 7 has delivered a much more secure platform for us, and that just can't be underestimated in our context.

— Paul Davis, Programmer Analyst Senior, Cornell University (College of Engineering)