Title: UW Athletics CRM Project Description: The University of Washington (UW) Athletics department has long been seeking a tool that has the ability to store and filter all of the data that they collect at various sporting events. Our solution is a Customer Relationship Management (CRM) system that the UW Athletics marketing department/analysts can use to increase sales on game day. Examples of searches that users will be able to conduct include: fans that have used the WiFi, fans that live in Bellevue, and fans that have been season ticket holders for 10 years. Our project will make a difference in the UW Athletics department by being able to conduct targeted searches on fans. The athletics department will have information on every fan that has ever been to a sporting event at the UW. By having access to this information, it will make the customer data more transparent and thus increase sales for the department. Team Members: Kevin Le and Mitchell Klein Program: Informatics

Enterprise Intelligence Dashboard using Troux ReST API Jorge Borunda (Full Time MSIM) As the second largest retail chain in the world and operating in 9 countries with over 600 warehouses, Costco produces an unceasing amount of data. Costco is widely recognized and respected for its business practices but making critical business decisions with its data analysis processes are not easy tasks. As each Costco department employs a specific application, their data gathering is being done in different silos and the need of an enterprise portfolio has become necessary. Troux, an enterprise portfolio, is a robust and complex application and this project will serve as a self-service information portal intended for Executives, Enterprise and Solution Architects to integrate and align the business overall and make critical business decisions more efficiently. This solution will increase the utilization of Troux as information asset and also to maintain the flow of information among departments to create effective and meaningful reports.

Game Graph is a video game metadata graph database and web application that provides an easy and extensible way to create, store, and retrieve metadata about video games. Building upon the work done at the Seattle Interactive Media Museum (SIMM) and the Game Metadata Research (GAMER) Group, this application envisions every possible point of information within a property graph database framework. By utilizing the graph database model, users are able to easily explore the relationships of video games. The goal of this project is to provide a useful tool for cataloging video game metadata, while assisting research into video games as information objects. As a component to a larger system, Game Graph provides the structural foundation for digitally cataloging video game collections.

Healthcare costs in the U.S. have skyrocketed from $1.4 trillion in 2000 to $2.9 trillion in 2014 according to Centers for Medicare and Medicaid Services. Our project – All-Payer Claims Database (APCD) Healthcare Cost Transparency, sponsored by the Washington Health Alliance (WHA) – may be a solution in healthcare cost containment and service improvement. APCDs collect de-identified medical claims data including clinical, financial, and utilization data. Several states have already passed a law to mandate an APCD, and Washington State is on the verge of passing the same law. WHA has the opportunity to be selected as the lead organization as the state authorized APCD administrator. Our project evaluates hosting options – in-house versus the cloud – and builds a functional but scaled-down APCD in Azure cloud to determine its feasibility. The result of this project will be to arm WHA with the knowledge to make informed decisions on the best APCD hosting option.

Jumo: We’ll log your hours Auditing is an important component to UW Athletics because this determines whether or not athletes can compete for their university’s athletic success. The current system is quite complex and inefficient; coaches struggle with logging practice hours for their athletes due to a cluttered interface, poor user experience, and having to deal with a lot of manual inputs. Additionally, the current system does not provide coaches with any sort of review process, which represents a lack of compliance checking. Jumo aims to solve these concerns by utilizing RFID technology to accurately log hours for coaches, reducing manual input and human errors. Simultaneously, Jumo checks for compliance in the back end to ensure NCAA bylaws are met. With Jumo, we do the heavy lifting for the UW Athletics. Team Members Howard Lin | Informatics Kevin Ly | Informatics Tuvshin Tulga | Informatics Kevin Yang | Informatics

Callison Architecture specializes in designing built environments, including projects in retail, hospitality, healthcare, and mixed-use. Headquartered in Seattle, it employs over 1,000 architects, designers and support staff worldwide. Yet despite its large size and the complexity of its projects, Callison has never centralized its project information into a single dedicated location. Recognizing the opportunity to assist in knowledge organization efforts, this project captures and collects data that is a) currently scattered across various internal servers or b) has remained unrecorded. This carefully curated data is critical in launching the beta mode of Callison’s first project database. As a master repository of project information, the database presents a quick snapshot of any given project within the firm. This is essential in saving the time of the architects and the staff who support them and, on a broader level, ensuring that the institutional knowledge of the firm’s forty-year history is preserved in one authoritative location.

MediSync: A Safer Way to Schedule Medicine Nina Dang (Informatics), David Gutierrez (Informatics), Troy Griffiths (Informatics), Brett Yamada (Informatics) According to the Centers for Disease Control and Prevention, prescription drug overdose is the leading cause of injury death in the United States. Among them, about 80% are unintentional. When drug overdose occurs, it is typically contributed to a medication regimen with conflicting side effects, insufficient spacing of time in-between consumption, or the addition of over-the-counter drugs. MediSync, a mobile application, helps prevent these situations with careful scheduling and monitoring. With the touch of a button, users are reminded to take their medication at the proper times. Additionally, when adding a new drug to their regimen, the user will be alerted if a harmful interaction is detected against their existing schedule. MediSync’s provided awareness of prescription drug intake is the next step towards healthier habits and saving lives.

If you needed surgery today, do you know how much your insurance would cover and how much it would cost you? Chances are, it would take several phone calls, using a lot of confusing jargon, and up to three business days to get an answer. We want to change that. MedPath proposes to change that process by creating a mobile application that will allow for instant searching to verify insurance policy coverage. This project consists of two parts: a metadata framework, which is the foundation for designing a central database repository, and a wireframe design of the front end mobile application. It is a prototype of a fully functioning application that can change the way insurance coverage is currently understood and used in the US. It will allow consumers to verify their insurance policy coverage in real-time, therefore giving them the power to receive the quality care without paying unnecessary costs or wasting time.

Students who want to improve their skills, learn new skills, or build social network may feel frustrated when they cannot find someone to help. On the other hand, a large amount of on-campus activities or resources are sometimes underutilized due to poor-information conditions. To fill the gap between resources and demands, we developed ‘Skill Swap’, an iOS mobile application that allows UW students to build their own profiles, find a partner from whom they can learn or to whom they can offer help, and stay informed of on-campus events that are of their interests. In addition, our app encourages students to share skills, minimize training costs, and build social network. Willing to share skills and learn something new with no expense? Come and try our Skill Swap App!

Our project is part of the Game Metadata Research (GAMER) Group’s Crossmedia Advisory Services based on media appeal factors, which investigates common appeal factors across multiple media formats to better support advisory services in the 21st century. Appeals Factory aims to develop a framework for recommending games to users based on preferences regarding selected factors: Story, Character, Setting, Visual Style, and Mood. Traditional mechanisms for game recommendation rely on a user’s gaming history as well as strict subject and genre metadata, but through our appeals methodology, users with any level of experience can find games suited to their taste based on what draws them to stories in general and games in particular. Our project provides a foundation for game and interactive media advisory for researchers, teachers, librarians, parents, and gamers.