Ann Arbor Chamber of Commerce
A2Chamber iPhone App: A comprehensive listing of businesses in the Ann Arbor area with simple, fast contact features built in.
Institute for Social Research: Project IDEAL, University of Michigan
Distance Learning Data Collection System: Converted the existing CDML-based FileMaker 6 system to a PhP-based FileMaker 8 system. Instructional time and student test data are entered into the web interface by teachers who are involved in adult distance education programs across the country.
L’eft Bank Wine Company
Sales Order Management System: Developed a web interface for initiating and tracking sales orders. Integrated data with FileMaker-based Genesis accounting system.
Medical School Dean’s Office, University of Michigan
Mail & File Tracking System: Developed a web-enabled MySQL database to manage the Dean’s Office contact database and its mail and file tracking process.
News & Information Services, University of Michigan
Work Order Management System: Developed calendar software to allow NIS Photo Services staff to initiate new customer appointments and manage photographer calendars.
Developed web application to manage daily work orders and invoices.
News Office, University of Chicago
Clips Management System: Developed a web interface for accessing University of Chicago-related media mentions that are entered into a MySQL database by office staff. Users receive a daily e-mail that contains links to the articles via the website.
Office of Academic and Multicultural Affairs, University of Michigan
Student Grant Application System: Converted an existing CDML-based FileMaker system to a PhP-based FileMaker 7 system. Created web interfaces for student applicants, faculty recommenders, committee reviewers, and grant administrators.
Office of the General Counsel, University of Michigan
GCFileTrack Case File Management System: Developed a web interface to log the location and ownership of case files in the main office and the Health Systems branch office.
Office of the President Office of the Vice President for Communications, University of Michigan
Presidential Outreach System: Developed web interface to track the media appearances of the University President.
Office of the President, University of Michigan
Mail & File Tracking System: Developed a web-enabled MySQL database to manage the President’s Office contact database and its mail and file tracking process.
Office of the President, University of Michigan
Honorary Degree Nomination Tracking System: Developed a web interface for managing information about nominees for honorary degrees issued by the University at graduation.
Office of the Provost, University of Michigan
Mail & File Tracking System: Developed a web-enabled MySQL database to manage the President’s Office contact database and its mail and file tracking process.
Office of the Provost, University of Michigan
PFIP Tracking System: Developed a web-based interface for tracking information related to the Provost’s Office Faculty Initiative Program.
Office of the Vice President for Communications, University of Michigan
Newsclips System: Developed a web interface for accessing University of Michigan-related published articles that were entered into a MySQL database by office staff. Users receive a daily e-mail that contains links to the articles via the website.
Office of the Vice President for Development; Office of the Vice President for Communications, University of Michigan
Major Gift Campaign Tracking System: Developed web interface to track publicity related to the Development Office’s Major Gift Campaign.
Office of the Vice President for Research, University of Michigan
M-Prime/eResearch Project: Converted data from a legacy Filemaker system to a new SQL-based eResearch product. Using calculations and scripts, “massaged” the Filemaker data into a format compatible with the SQL table structure. Developed a Filemaker interface to automate these tasks and simplify the final conversion.
Office of the Vice President for Research/MAIS, University of Michigan
eRPM Proposal Management Data Conversion: Converted data from a legacy Filemaker system to a new SQL-based Click Commerce eResearch product. Using calculations and scripts, “massaged” the Filemaker data into a format compatible with the SQL table structure. Developed a Filemaker interface to automate these tasks and simplify the final conversion.
Office of the Vice President of Research, University of Michigan
IRB Application Management System: Developed a CDML web interface and FileMaker 6 database to manage applications to the Behavioral Sciences and Health Sciences institutional review boards (IRB) from faculty and students who want to use human subjects in their research projects. Using branching logic, the system guides applicants through more than 200 possible questions, presenting only those that are relevant to their research.
Science Learning Center, University of Michigan
Study Group Registration System: Developed a web-based interface for managing study group registrations and wait list choices.