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 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 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.

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.

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

PFIP Tracking System: Developed a web-based interface for tracking information related to the Provost’s Office Faculty Initiative Program.

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.

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.

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.

734.929.0431

Support