OVERVIEW:

With over 20 years experience developing FileMaker® Pro solutions, Robert has become a trusted developer for Corporations, Creative Businesses, Medical Device Manufacturers, and Universities.   His client's regularly commend him on his ability to understand their requirements, communicate clearly, meet deadlines and keep projects on budget, to develop user friendly interfaces, and to employ efficient and creative programming techniques. 

Robert develops FileMaker solutions and extends the capabilities of existing systems, following the accepted development practices, including clear program code documentation. Each particular system needs to be customized to very specific dimensions and variables in order to function accurately and productively. The job is certainly complex and requires a great deal of expertise and state of the art vision for problem solving but most of it to make user friendly database systems that become simple at-hand tools. Robert has acquired this expertise with continuous practice that began in 1989 when he started developing FileMaker solutions.

Robert is a respected member of the FileMaker developer community.  He participates in FileMaker user groups, developer conferences, continuing educations programs, as well as working with other local developers to learn new development techniques.

SELECTED PROJECTS:

The Center for Interdisciplinary Brain Sciences Research (CIBSR) at the Stanford University School of Medicine:

Developed a solution for converting and storing 80 SQL database tables that stored family demographic and research data. 

-Developed a household demographic data entry and reporting process that guides the user through the process of adding demographic information for families involved in DNA research and other studies.  The existing SQL database required the data to be input by senior research staff, who understood the data entry rules and variables.   The resulting FileMaker solution guides the user though the process, with a step by step flowchart diagram, posing questions and guiding the user throughout the process.  This resulted in allowing additional staff and research assistants to effortlessly enter and maintain family demographic data, reduce errors and orphaned records, and presented users with an interface that summarized the current and historical family data, and to easily find related family members in other households.

- Developed a standard interface for data entry and reporting of research data.  By scanning and overlaying the research questionnaire forms into FileMaker, Research Assistants could more easily enter data directly from the paper form, without having to know the actual data field names.  In addition, it was required that the research data be validated by blindly reentering the data and alerting the user when a data field did not match. A process was developed that accomplished the validation without storing a duplicate of the data.  In addition, HIPPA requirements were programmed into the system that disallowed most users from seeing names or from navigating to specific layouts.

Franklin Templeton Investments Creative Services Reporting Solution:

Developed a data reporting tool employing the data interface separation model.  The company maintains a FileMaker project management, time tracking, and reporting system.  The Creative Services department required an interface to report on project and time data.  This was achieved by creating a FileMaker interface reporting file.  The reporting file stores report layouts and program code, but does not store data. The solution provides the user with navigation screens that interface with the live network data.  This file can be maintained by individual users, or hosted on the server.  If changes are required only one file must be replaced, without importing current data. 

Publicis Technology Advertising Time Tracking and Billing:

Designed and developed a multi user time entry and reporting system. This solution integrates with a custom Filemaker job tracking system, allows each user to see a list of job numbers and to validate their data entry for accuracy. The system also includes separate preferences for each user numerous reports is included as well as a link to the billing system.

Stanford University Business School "Facebook Project":

Developed a solution that stores student photos and biograpical information.  Managed the input of data and phtography of students.  Digital files with photos and data were sent to a printer for creation of film that was used to print "Facebooks" that were distributed to students.  The solution also allowed professors to input the student name/ID number into a layout that represents the fixed seating arrangements of each classroom. The entry of the name/ID causes an automatic lookup of the student's picture and biographical information onto the classroom layout. This layout is then printed by the professor which allows them to easily identify a student while in their class.  This database project was maintained from 1996 - 2001 with yearly photo and biographical updates.

Medical Device Unit Service Call and Maintenance System:

Designed and developed a multi-user system for tracking multiple medical device units at hospitals by Boston Scientific Corporation.  The system allows the phone support and field service staff to view a device by serial number or location.  System includes tracking of contact management, service calls, field service work order generation, history, RMA, maintenance and service contract management, replacement parts and accessory tracking.