Index of Pitches
- Pitch 1: Tabular not Cubular
- Pitch 2: MPressive Support (GETTING HELP: By a Push of a Button!) - WINNER
- Pitch 3: Automated Symbolic Analysis of Binary Code
- Pitch 4: Visualizing UM Bias Incidents Data
- Pitch 5: Create a hardened, UMich configured Ubuntu setup
- Pitch 6: Shifting Left: Automatic IT Servicing
- Pitch 7: Uniqname Change Notifications via Service Bus
- Pitch 8: Privacy-Preserving API for Research
- Pitch 9: Incentivizing Spirometry - 2nd place
- Pitch 10: IT Support Dashboard - Michigan Medicine (Combined with Pitch 21)
- Pitch 11: Free/Busy Helper for People Who Support Faculty
- Pitch 12: Tracking Student Engagement (combined with Pitch 14)
- Pitch 13: HALO - Human Attentive Locational Observer (withdrew from event)
- Pitch 14: Robotic Process Automation (combined with Pitch 12)
- Pitch 15: LSA Inventory Management
- Pitch 16: Improving patient experience using AWS IOT Button
- Pitch 17: Screen Cloaker
- Pitch 18: Stroke Alert - 3rd place
- Pitch 19: Automation with University APIs
- Pitch 20: IT Staff New Employee Orientation
- Pitch 21: Splunkers United (Combined with Pitch 10)
- Pitch 22: Enterprise Apps (An Library of Relationships: Capturing and Visualizing Our Enterprise Applications) - 4th place
- Pitch 23: Test Active Directory authentication for Oracle client connections
1.
Team Members: Derrick Tietz
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
Convert an existing Sql Server Analysis Service multi-dimensional data cube to the Sql Server Analysis Service tabular model. Also, test the Analysis Services Databases Synchronize process and explore DAX queries vs MDX queries.
Team members: Derrick Tietz, IQ, Developer; Bryan Hartman, IQ, Data Modeler; Jeff Wixon, IQ, Developer; Jane Chou; IQ; Developer
Back to top2.
Team Members: brian cors
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
Sometimes you need help RIGHT AWAY! Conference rooms are a perfect example of this. When Audiovisual system problems happen, they can derail a critical meeting. Using IoT device(s), Service Now and Slack, we will create a way for conference room users to simply push a button to notify the ITS Service Center of a problem - allowing for rapid response, and ensure that proper info is captured and tracked.
Team members: Greg Benn, ITS - Service Mgt, ServiceNow Coding; Will Burns, ITS - EIS Mobile/Web, Hack Presenter; Brian Cors, ITS - Infrastructure, Hack Coordinator; Brian Hobbs, ITS - Service Mgt, ServiceNow Coding; Jeff Kopmanis, ITS - MiWorkspace, IoT Button Coding; John Simpkins, ITS - Infrastructure, IoT/WiFi Assistance; Aaron Stark, ITS - eReasearch, Slack Integration; Chris Stockbridge, LSA - Research Support, IoT Button Coding; Steven Kolasa, ITS - Infrastructure, AWS; Matthew Chess, ITS - Infrastructure, AWS
Back to top3.
Team Members: Michael Grube
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
Symbolic execution is typically used for advanced analysis of a binary. Using the valgrind binary instrumentation framework and a virtualized instruction set via the angr python library, we'll be investigating our ability to automate the analysis of binary applications for exploitable vulnerabilities. We will also be designing our application to work at scale using Apache Spark.
Team members: Michael Grube, Information Assurance, Developer; Brett Miller, Information Assurance, Developer; Dale Faye, Information Assurance, Developer; Scott Bolak, Security Operations, Developer
Back to top4.
Team Members: Husnu Kaplan
Category: Diversity, Equity and Inclusion (DEI)
Description:
Last October, UM began an online log to share information about each incident of bias reported to the university's Bias Response Team (BRT). A bias incident is conduct that discriminates, stereotypes, excludes, harasses or harms any member of the university community based on such identity factors as race, color, ethnicity, national origin, sex, gender identity or expression, sexual orientation, disability, age or religion.
Bias Incidents reported to BRT are published at https://deanofstudents.umich.edu/bias-incident-report-log as raw public data.
Designing and representing this raw data can be quite impactful. Telling a visually compelling narrative will be a lot more appealing and engaging to students, faculty and staff. It has been shown that you will remember 60% something when you learn it with imagery versus 6% without and this effect increases by age. Having this data visualized will allow UM community to analyze it easily and make inquiries or take actions as appropriate.
Team members: Pushyami Gundala, TL, ITS, Developer; Jamie Estill, HITS -Research Applications & Advanced Computing, Business Systems Analyst Lead; Christopher Gardner, ITS - IQ, Senior Business Intelligence Analyst; Imani Tarpeh, ITS - Infrastructure, EAS, Student Intern, UX Analyst; Adam Robinson, ITS - IS, Virtualization and Cloud Infrastructure Senior; Husnu Kaplan, HITS, Sr. Systems Analyst/Programmer; Shun Han, CLaSP, Sr. Application Programmer; Ryan Henyard, HITS, Education Informatics & Technologies Analyst; Justin Hite, Ross School of Business, Sr. Research and Data Analyst; Sinji Yang, LSA IT, Business Intelligence Analyst Sr
Back to top5.
Team Members: Bennet Fauber
Category: Research
Description:
A lot of scientific software is developed on Ubuntu. It would be valuable to have a protocol for hardening Ubuntu and integrating it into the UMich environment. This protocol would be applicable to physical and virtual installations.
Team members: Bennet Fauber, ARC-TS & Neuroimaging Initiative, Hack Coordinator; Christopher Eckmeter, CAEN, Desktop Support Specialist; Mark Irwin, ITS, UNIX/Linux Systems Administrator; Irwin Estes, ITS, UNIX and Linux Systems Administrator; Richard Merkle, HITS, Desktop Hardening; Keane Wolter, ARC-TS, Developer; Jim Kenyon, HITS, Documentation / Coordination; Scott Paschke, ARC-TS, Research Cloud Solutions Designer; Darren Britten-Bozzone, CLaSP, Systems Administrator; Martin Sager, ITS, Information Systems Manager
Back to top6.
Team Members: John Walsh
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
Let's work on a framework incorporating IT operation APIs with ServiceNow to give customers a consistent framework for requesting and operating on infrastructure in a safe, secure, and reliable way.
Team members: John Walsh, Health Information Technology & Services, DevOps Engineer; Breanne Melow, Health Information Management, Business Systems Analyst; Christerfer Frazier, William Davidson Institute - Ross School of Business, IT Project Manager
Back to top7.
Team Members: Patrick Steffes
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
Currently, units are informed about uniqname changes via email. It would be beneficial to switch to a service bus model where we publish these changes from MCommunity to subscribed consumers. This sort of pub/sub notification system would also be a proof of concept for numerous other MCommunity events related to provisioning and deprovisioning. Technology discussed has involved the IBM ESB or AWS SNS/SQS.
Team members: Patrick Steffes, ITS, Team Lead; Gail Lift, ITS, Team Member; Luke Tracy, Office of the CIO, Team Member; Edie Van Hoosear, ITS, Honorary Team Member
Back to top8.
Team Members: Kris Steinhoff
Category: Research
Description:
This hack will create a proof-of-concept API that will give researchers the ability to run queries on sensitive data while preserving the privacy of the subjects in the data. We will start by creating a large set of dummy data, and then build interfaces to give users access to the data while applying differential privacy concepts such as a "privacy budget".
(This work will be directly usable by the PrivaScope project which is building research infrastructure to allow faculty to do research on operational data from ITS.)
Team members: Kris Steinhoff, ITS, Lead ; Sally Luoma, Information Quest, Developer / Documentation; Lance E Sloan, ITS, Developer; James Ostrander, ITS, Developer; David Nowell, Information Quest, Architect; Dan Stanish, F&O IS, Documentation
Back to top9.
Team Members: Michael Burns
Category: Healthcare and BioSciences
Description:
The incentive spirometer (IS) is a common device used in hospitals to improve the respiratory function of patients with lung illnesses and all patients following operations. The device is designed to incentivize patients to take deep slow breaths several times an hour. To quick or too low a breath is inadequate. Utilization of the device is often suboptimal requiring constant reminders and instruction. For our hack we want to incentivize use by creating a game played with the IS device. We envision using light sensors to capture extent of use and transmit the information real-time into a videogame that incentivizes proper use of the device. This project falls into the broader category of the internet of things (IoT) and will focus on the capture and, processing, and distribution of data that previously was inaccessible. The broader vision is to extend the design to other applications within the hospital and beyond.
Team members: Shawki Atassi, LSA CS (student), Game Design; Paul Bigler, DART, EAS-ITS, Integration; Michael Burns, Anesthesiology, MPOG, Game Design; Mikele Garrett, Anesthesiology, Hardware; Jay Jeong, Anesthesiology, MPOG, Integration; Tomas Medina, Anesthesiology, Office of Research, Game Design; Luke Palnau, Office of University Development, Integration; Abbey Roelofs, LSA, IT, Game Design; Anik Sinha, Anesthesiology, MPOG, Hardware; Sheetal Sonar, DART, EAS- ITS, Integration; Nancy Waters, SPECS, Office of University Development, Game Design; Amanda Wright, Health Information Technology Services, Game Design
Back to top10.
Team Members: Nathan Haley
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
We will build a new set of dashboards to provide targeted and detailed knowledge for Desktop, Service Desk and IT support staff using Splunk. Our SIEM has an extensive amount of information pouring in from our network, inventory, and other sources that we can use to extract metrics and detailed data from our environment and display it in better ways to more quickly diagnose and solve problems.
Team members: Wei Wang [email protected], HITS Ent Cont & Data Host Svcs; Kun Deng [email protected], HITS Ent Cont & Data Host Svcs; NathanHaley [email protected], HITS Networking & Comm Svcs; Will Thacker [email protected], HITS CIO Administration; Aubrey Theisen [email protected], HITS CIO Administration; Denise Kabisch [email protected], HITS SVM ITSM
Back to top11.
Team Members: Britain Woodman
Category: Teaching and Learning
Description:
We can help IT, and other staff who support teaching faculty, more effectively serve them by quickly visualizing the faculty's teaching schedule on the support staff's calendar, making appointments and other time-sensitive activities easier to schedule with fewer back-and-forth messages.
This could be a live GCal feed of an instructor's teaching schedule, or, more realistically, translating the times from the RO schedule to an iCalendar format file for the current term. I envision a self-service web interface (input instructor and current term, get their teaching times in iCalendar format to import into your calendar).
This will only involve publicly visible teaching times from the official course schedule; not sharing the instructor's personal time; requiring no action by the faculty (although they could certainly use it to quickly fill those times in on their own calendar).
Please join me! I'm not much of a coder but I love talking.
Team members: Britain Woodman, ITS Teaching and Learning, Team Captain, Cheerleader; Breanna Hamm, University Library, Graphic Design, Documentation; Gonzalo Silverio, ITS Teaching and Learning, Developer, Front-End/UX; Heather Miller, VP for Development, Documentation; John Gallias, LSA Info. Technology, Developer and Systems Administrator; Phil Cameron, LSA Language Resource Center, Developer; Philomena Meechan, LSA Language Resource Center, Documentation
Back to top12.
Team Members: Scott Berkley
Category: Diversity, Equity and Inclusion (DEI)
Description:
I suggest that we build a quantitative engagement score in the salesforce crm platform that can be used in reporting and to trigger other actions, including interventions for high-risk groups.
Team members: Scott Berkley, Ross, Salesforce developer; Tong Sun, College of Engineering, Salesforce developer, bot developer; Angela Hall, Student Life, Salesforce developer; Stephen Weinberg, Ross, Marketing mastermind; Shelly Turner, ITS - IQ, Data Integration; Zhen Qian, ITS - Teaching and Learning, Data Integration; Sam Solovyev, ITS - DART, developer
Back to top13. Pitch 13: HALO - Human Attentive Locational Observer (withdrew from event)
Team Members: Dakota Lambert
Category: Healthcare and BioSciences
Description:
Our goal is to create a solution for research labs, hospitals, schools, nursing homes, and other venues which need a secure cost effective people tracking system. Due to the often hectic nature in these locations, our idea is to create a system that could be easily scaled utilizing wireless technologies paired with cameras and other low cost devices such as wristbands to track individual movement within a predefined location.
This tracking would then be expanded upon with the inclusion of specific information present on the “ID” such as name, role, and could even include vital information, e.g. heart rate. In the event that a person entered the location without an ID the system would flag that individual, alert necessary personal, and begin tracking their movement in the location using facial recognition and heatmaps. This simple and cost-effective idea aims to provide a human hands-off approach to location security.
Back to top14.
Team Members: Tong Sun
Category: Academic Innovation
Description:
If you repeatedly download spreadsheet, make changes then upload to another system such as Salesforce or other CRM, if you find yourself fill out the same form for your faculty more than once or twice in a week, let's work together to explore the possibility to automate these routine business processes using RPA tools. RPA software such as BluePrism, UIPath and AutomationAnywhere can mimic the ways that people interact with software applications. The goal of this project is to implement a solution and train the bots to automate manual processes.
Team members: Scott Berkley, Ross, Salesforce developer; Tong Sun, College of Engineering, Salesforce developer, bot developer; Angela Hall, Student Life, Salesforce developer; Stephen Weinberg, Ross, Marketing mastermind; Shelly Turner, ITS - IQ, Data Integration; Zhen Qian, ITS - Teaching and Learning, Data Integration; Sam Solovyev, ITS - DART, developer
Back to top15.
Team Members: Dan St. Pierre
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
Implement a single system to efficiently manage U-M IT assets. Develop and adopt consistent processes around the entire lifespan of an IT asset (creating, maintaining, and decommissioning). Increase visibility of U-M IT assets actively supported. This project is currently ongoing and close to implementation in LSA by IT. We could provide a demo and discussion around the tool\application we are demoing if it fits within Hacks w/ Friends. We have integrations with SCCM an Izzy for data queries with APIs.
Team members: Margarita Barvinok, LSA Dean: Information Technology, Developer; Vance Smith, ITS Strategy & Planning, Business Process Consultant; Steven Moser, LSA Dean: Information Technology, UI/UX Expert/Business Process Consultant; Dan St. Pierre, LSA Dean: Information Technology, Project Lead/Developer
Back to top16.
Team Members: Kirti Karia
Description:
AWS IOT button is an affordable programmable Wi-Fi device. Our idea is to use this device to improve patient experience and capture patient feedback.
Use case 1: Place these devices in restrooms in hospital/clinical areas. When a restroom needs cleaning or maintenance, our customers/patients can press that button, which would automatically send out a notification to environment services.
Use case 2: Place these devices in restrooms in clinical areas. When a restroom needs cleaning or maintenance, our customers/patients can press that button, which would automatically send out a notification environment services so that they can clean it
Use Case 3: Use five of these buttons to capture patient experience/satisfaction/rating at Michigan Medicine hospital.Create a box using 3d printer to house this button with one of the 11 HCAHPS publicly reported measures or overall satisfaction star rating. https://www.cms.gov/Medicare/Quality-Initiatives-Patient-Assessment-Instruments/HospitalQualityInits/Downloads/HCAHPSstarratingmethodology.pdf http://www.hcahpsonline.org/
Team members: Kirti Karia, Service Operations Support - HITS, Business Analyst; Kalpesh Unadkat, Enterprise Infrastructure - HITS, Solutions Architect; Jinan Li, Clinical & Operational Applications, Developer
Back to top17.
Team Members: Kyle Harr and Leif Myklebust
Category: Teaching and Learning
Description:
Have you ever sat in a public place with your laptop and worried about others seeing the information on your screen, such as your grades, exam results, or writing something private? We propose to build Screen Cloaker, a combination of a web library and a mobile viewer, where a part of the web page is obscured, and can only be viewed through the mobile viewer, which can be used in a headset such as Google Cardboard. Sit anywhere and read or write on your laptop without anyone being able to snoop on you!
Team members: Leif Myklebust, Medical Education Software, Chief Visionary; Kyle Harr, Medical Education Software, Chief Amazement Officer; Sam Brow, Faculty Life Cycle Management Software, Director of Cogitation; Elliott Richards, Clinical Software, Director of Dream Fulfillment
Back to top18.
Team Members: Gloria Kim
Category: Healthcare and BioSciences
Description:
There’s an app for ordering food, there’s an app for calling a car, there’s a wide variety of apps that make life easier. But what if we made an app that actually changed lives? In the US, someone has a stroke every 40 seconds and someone dies of a stroke every 4 minutes. There is a life-changing medication available called tPA, but this medication is only effective when administered within 4.5 hours of the first symptoms of stroke. Too often people who suffer a stroke aren’t eligible for this treatment because they did not seek medical attention soon enough. An app that uses facial recognition technology can detect whether someone may be having a stroke even before they are aware of symptoms and alert the patient to go to the nearest Emergency Room or Stroke Center. This proactive identification of individuals with possible stroke would make more individuals eligible for tPA therapy.
Team members: Gloria Kim, Michigan Medicine, Project manager; Dan McClenaghan, HITS Desktop Support, Brainstormer, designer; Ramya Kommareddi, Office of University Development, Brainstormer, developer; Charlene Eagle, ITS Strategy and Planning, Brainstormer, analyst, user experience; Ben Ibach, HITS MiChart, Brainstormer, user experience; Ajitha Devarajan, Office of University Development, Brainstormer, developer
Back to top19.
Team Members: Dave Perhne
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
As UM developers build custom applications and acquire cloud applications, there is more of a need to integrate those applications with our Enterprise Applications, like PeopleSoft. Historically, the integration strategy has been to simply replicate data into those remote systems. However, this has left business processes fragmented and require staff to work in multiple systems, sometimes duplicating effort. There needs to be a better way to automate some common tasks.
A few potential ideas for APIs:
- Retrieve/Update Degree Checkout Status from applied to Pending
- Retrieve/Update Advisor/Advisee relationships
- Retrieve/Update Student Group memberships
- Retrieve/Update Placement Test scores
The first API alone could potentially save LSA 40 hours of work each year. Imagine the efficiencies we could gain if we had a large catalog of APIs.
Help us design, and build APIs to retrieve and update data in the PeopleSoft Student System.
Team members: Dave Perhne, LSA - MIS, BI Lead; Anne Rickert, LSA - MIS, DeveloperDeveloper; Nicole Urbain, ITS -Student Admin Sys, Developer; Kranthi Bandaru, ITS - Information Quest, Developer
Back to top20.
Team Members: Linda Cox
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
Too often new IT staff start new jobs and don’t get a very organized or comprehensive orientation to their new department, roles, and teams. This can be a major source of dissatisfaction and limits the new staff member's ability to effectively and efficiently contribute to the team. We want to use SharePoint to create a customizable, role-specific program where orientation tasks can be assigned and tracked for each new hire. Additionally we want to create a place to house orientation materials, resources, and tools. A significant portion of this hack will be devoted to designing orientation functions, features, content ideas, processes, and roles so that we design the site and any related tools to serve the correct needs. We don't have to limit ourselves to creating static web content and tracking lists. We welcome anyone with an interest in helping new IT staff thrive in our environment and we are hoping to get creative ideas from diverse voices.
Team members: Linda Cox, HITS, IT Project Senior Manager; Melissa Blom, HITS, IT Business Manager; Andrew Staley, HITS, Web Server Administrator; Paul Stancato, HITS, App Sys Analyst/Prgm Sr; Ryan Crockett, HITS, Technical Trainer; Brian Adams, HITS, Solution Architect Inter; Edmond Kole-James, HITS, IT Project Senior Manager; Chris Hedly, HITS, Graphic Designer
Back to top21.
Team Members: Kun Deng
Description:
Using splunk to accomplish any one of the tasks and demonstrate its flexibility as an operations intelligence platform for the organization.
Is there any significant difference in ticketing performances between remedy and servicenow? Can we develop a few reasonable KPIs using data in splunk to empirically answer this question?
Team members: Wei Wang [email protected], HITS Ent Cont & Data Host Svcs; Kun Deng [email protected], HITS Ent Cont & Data Host Svcs; NathanHaley [email protected], HITS Networking & Comm Svcs; Will Thacker [email protected], HITS CIO Administration; Aubrey Theisen [email protected], HITS CIO Administration; Denise Kabisch [email protected], HITS SVM ITSM
Back to top22.
Team Members: Michael Sheppard
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
This project will build an application that inventories our ITS Enterprise Applications and create visualizations to describe the relationships them.
Team members: Michael Sheppard, Information Quest, The Glue; Chris Rowland, Information Quest, Developer; Jeff Jenkins, Information Quest, Developer; Amber Madden, Infrastructure System, The Glue; Leticia Valdez, Information Quest, Developer; Mark McManamay, Enterprise Application Systems, Developer; Mandie Chapman, Information Quest, Analyst; Brandon Swickerath, Systems Support, Developer
Back to top23.
Team Members: Dave McLaughlin
Category: IT Operations (Improve quality or efficiency of existing IT processes)
Description:
We want to authenticate Oracle users through Active Directory (and Kerberos) so that users don't need as many passwords and to reduce the overall burden of password management.
Team members: Dave McLaughlin, ITS Infra Sys Srvcs & Ops, Database Admin; Kasthuri Ilankamban, ITS Infra Sys Srvcs & Ops, Database Admin; Brian Rahn, ITS Infra Sys Srvcs & Ops, Active Directory
Back to top