PhDs at Work

A Professional Network for PhDs across Industries

  • About
    • About PhDs At Work
    • Impact
    • Contact
  • Week in the Life
    • About Week in the Life
    • One Year Later
    • Explore Guest Bloggers
      • Company
      • Work Sector
      • Degree Field
      • Author
  • Podcast
  • Events
    • Upcoming Events
    • Event Albums
  • Opportunities

Alison Fisher (Mon)

December 17, 2013 By Alison Fisher

As I sit down at my desk, tea and muffin at my side, I am reminded of my favorite saying among parents with young kids: Monday morning is the new Friday night! After a weekend of family time, I am ready to fully engage and focus.

I check my calendar and email to see if anything new has come up. As usual, I have a few requests from ongoing clients to make changes, to create reports, and to schedule meetings for later in the week. After responding to each of the emails, I tackle the requests that won’t take much time. I put the ones that are going to take longer (hour or more) in my queue.

My first project of the day is to create a new database application. Last week we had a kick-off call with a new client. During the meeting, we went over the specifications for a new database and the requirements for the user interface. The client has experience with the platform so she was very specific about what she wants. This is not common. Usually we take time to describe options and potential features by demonstrating similar applications.

For those less familiar with databases, here is a definition I found online: a structured set of data held in a computer, esp. one that is accessible in various ways. Even if you have never built one, we all have experience with databases. When you enroll in school, your personal and academic information go in a database. When you search for gifts on Amazon, you are searching through their online database.

To build a database, you need to know the type of information that will be entered and how the pieces of information relate to each other. For example, a simplified database that holds student data may have a table for student information (first and last name, student ID),  a table for classes (English 101, Biology 1A) and a table for test grades. In this example, the tables would be  related to each other such that each student takes one to many classes and for each class, the student earns one to many grades.

I start building the database from scratch. First, I use diagramming software to draw a visual map of the design. When everything looks good, I create tables and their fields and the relationships between tables using a point-and-click interface. This is a small application, so this stage takes a few hours.

In general, I build databases with radically different usage patterns. Some will be used frequently by the same people while others will be used infrequently by many different users. The one I am working on today belongs in the latter category. The user experience needs to be clear and intuitive. I create ‘smart forms’ so that fields become required at the correct time, fields show and are hidden as needed. An application consists of multiple layers of logic. After the structure is built I test, make changes, and re-test to make sure the logic is correct.

My science background was good preparation for this, though not directly. Describing a research program is analogous to telling a story. First, introduce the characters. In my research these were plant and fungal species. Next, describe how the characters are manipulated. Lastly, describe the results. With a large list of characters and multiple plots (experiments) it is important to give the audience the information they need when they expect it. Collecting data using a dynamic form (one that changes depending on the data entered) is the same. The format should be intuitive and the user should be prompted for input in a logical sequence.

I work on the application into the early afternoon and then take a break to answer some of the requests that have come in by email.

Next I have a client call. It is scheduled for an hour and we have a lot to cover. This is the first time the client is viewing their new application (a different application than the one I was working on earlier). We do a ‘walk-through’ to make sure we’ve met the specifications. We brainstorm to determine if we have all the use cases covered. Towards the end, we discuss the different types of users that will be accessing the database and what permissions they will need.

Tonight is our company holiday party so I head out to pick up my kids so we can go to the family-friendly event together!

Alison Fisher | CloudBase Services
Alison Fisher (Tues)

Pay it forward. Share and help someone else find this resource!

  • LinkedIn
  • Twitter
  • Facebook
  • Tumblr
  • Pinterest
  • Reddit
  • More
  • Pocket
  • Print
  • Email

Related

Questions? Share your thoughts! Cancel reply

  • Email
  • Facebook
  • Google+
  • LinkedIn
  • Twitter

Alison Fisher, PhD

Database Developer & Account Manager
CloudBase Services

PhD, Plant Biology

The Ecology and Genetics of the Ergot Pathogen (Claviceps purpurea)

University of California, Davis, 2004

Connect with Alison

The best career advice I ever received:

Most people find jobs through networking.

Alison's "Week in the Life"

  • Alison Fisher | One Year Later
  • Alison Fisher (Fri)
  • Alison Fisher (Thurs)
  • Alison Fisher (Wed)
  • Alison Fisher (Tues)
  • Alison Fisher (Mon)
  • Alison Fisher | CloudBase Services

Which is more important: luck, smarts, or know-how?

It’s important to know how to use your smarts to take advantage of a lucky situation.

If I had to do it all over again, I would …

... have minored in computer science.

More Corporate Bloggers

  • Benjamin Levitt | Birkhäuser (Springer)
  • Nanette Fornabai | PwC
  • Peter A. Bacevice | HLW International
  • David Hardtke | LinkedIn
  • Aviad Eilam | Rosetta Stone
  • David Craig | CannonDesign
  • Maria Irchenhauser | DWPub
  • Alison Fisher | CloudBase Services
  • Kevin Eckerle | Accenture
  • Adam Capitanio | Berghahn Books
  • Chris Humphrey | Triodos Bank
  • Patricia Fann Bouteneff | Citi
  • Tse-Sung Wu | Genentech

Looking for something specific?

Copyright © 2011-2021 PhDs at Work, All Rights Reserved

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.