Dmitriy B.

Project:  Marketing website for the Pittsburgh Riverhounds

Dates(s):  Spring 2014

Students:  Mandy Kendall, Jacob Mangone.

Programming languages/platforms/technologies:  PHP, MySQL, Bootstrap, HTML5

Description:  iSchool students worked closely with a group of undergraduate students from the University of Pittsburgh Business School to develop a website for a marketing campaign for the Pittsburgh Riverhounds soccer team.

Project:  First draft of a data standard for obstetrics and gynecology electronic medical records (EMR) system for Magee Women’s Hospital.

Date(s):  Spring 2014

Students:  Joshua Howell, Naveen Srivastava, Ayla Gounder, Clinton Wojick.

Programming languages/platforms/technologies:  MySQL, Java, Python

Description:  Most off-the-shelf EMR systems do not offer data fields specific to obstetrics and gynecology.  For example, it is impossible to print a birth certificate from any of the existing EMR systems.  A group of physicians from Magee Women’s Hospital spearheaded the effort to create a standardized database schema that would contain all the fields required by OB forms and reports with the hope that this new standard will be adapted by EMR developers.

iSchool students developed an E-R model based on the data provided by Magee Hospital physicians and build a working prototype of an OB EMR database.

Project:  SQL Tutor

Dates(s):  Spring 2014

Students:  Jordan Feldman

Programming languages/platforms/technologies:  PHP, MySQL, jQuery, HTML5

Description: SQL Tutor is an online tutoring system for Standardized Query Language (SQL).  SQL Tutor works with any relational database and teaches students to write complex SQL queries through a series of assignments, puzzles and quizzes.

Project:  Resume and Portfolio Management System

Dates(s):  Spring 2014

Students:  Jordan Feldman, Mandy Kendall, Naveen Srivastava

Programming languages/platforms/technologies:  Java, GlassFish, MySQL, jQuery, RESTful web services, Bootstrap, HTML5

Description: The goal of this project is to develop a prototype for a Resume and Portfolio Management system that would be used by the University of Pittsburgh School of Information Sciences students to connect with potential employers and to showcase their work.  This prototype will be further developed into a production system throughout the 2014-2015 academic year.

Project:  Marketing website for Mazda USA.

Dates(s):  Fall 2014

Students:  Jordan Feldman, Corbin Powlus

Programming languages/platforms/technologies:  PHP, HTML5

Description: iSchool students worked closely with a group of undergraduate students from the University of Pittsburgh Business School to develop a website for a marketing campaign for Mazda USA.  This project has won the Mazda national competition.