2020 Hacks with Friends Pitches

Hacks with Friends 2018

Index of Pitches

  1. 1. UMichCTF 3rd Place Judges Award
  2. 3. Golden Grants
  3. 4. A Pangeo State of Mind: Developing a Python Stack and Repository for Access, Analysis, and Management of Big Data
  4. 5: Salesforce Appointment Scheduler HWF 2020 Collaboration Award
  5. 6. Improve the ServiceNow Mobile Experience
  6. 8. Research Contribution and Data Storage in Private Blockchain
  7. 9. Mapping Inclusivity 1st Place Judges Award & Broadest Reach Award (Public Voting)
  8. 10. MiPark - Michigan Medicine Parking Reservation System Honorable Mention Judges Award; People’s Choice & MacGyver Award (Public Voting)
  9. 13. CAPS Faculty Toolkit App
  10. 14. Review Ready
  11. 15. Do You Need Anything? The U-M DYNA App.
  12. 16. Hands Free Ticket Creation 2nd Place Judges Award
  13. 17. MiFeedback
  14. 19. Containers, Clusters, Operators, Oh My

1. UMichCTF
3rd Place Judges Award

Team Members:

  • Hugh Briggs, CAEN and ITS
  • Sam Brow, HITS/Michigan Medicine
  • Dale Fay, HITS/Michigan Medicine
  • Matt Janik, HITS/Michigan Medicine
  • Kesha Vardhan Kondam, HITS/Michigan Medicine
  • Keanu Lee Chip Sao, HITS/Michigan Medicine - Pitch Leader
  • Brett Miller, HITS/Michigan Medicine
  • Carlos Olivas, ITS
  • Jake Huang, Student

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

Finding and hiring the right skill for a role is difficult. A resume, even if written honestly and accurately, may not be sufficient to evaluate the skill level of a candidate. Second, we may not have a big pool of candidates with a desired skill when actively recruiting. Third, at times it seems that expensive training methods do not result in more skilled employees. Our solution: Capture The Flag (CTF) competitions! Organizations create a large number of “gamified” micro-challenges representative of skills they care about. Participants obtain points based on the number of challenges they solve. This allows us to train for skills we need, recruit top performers while increasing the number of individuals who have the skills. This project allows building relationships in our community. Finally, opening this platform to the whole state will enable us to serve the people of Michigan by providing free training.

Team 1 Videos: 3-Minute Pitch10-Minute Presentation to Judges

Back to top

3. Golden Grants

Team Members:

  • Jeanette Balaze, ITS
  • Ramya Kommareddi, Devlopment
  • Peggy Lai, ITS
  • Gail Lift, ITS
  • Derrick Tietz, ITS - Pitch Leader
  • Mengyun Zhai, Student

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

U-M Data Warehouse - create a recurring process that compares the privileges that should be granted to the current privileges granted. Include a notification of mismatches and a process to re-grant or revoke access. Write the process in Informatica, as it is the tool most familiar to those supporting the U-M Data Warehouse. The goal is to keep the U-M Data Warehouse refreshed with the proper access. Grant statements give privileges (like select) to a specific user or role to perform actions on database objects. Example: Grant select on address to m_def_sel.

Team 3 Video: 3-Minute Pitch

Back to top

4. A Pangeo State of Mind: Developing a Python Stack and Repository for Access, Analysis, and Management of Big Data

Team Members:

  • Kyle Cochrane, ITS
  • Greg Kostin, Library
  • Srinivas Perumandla, ITS
  • Lance Sloan, ITS
  • Joeseph Smith, SEAS-CIGLR - Pitch Leader
  • David Wolfe, LSA

Category: Research Storage

Description:

Pangeo is an open-source community committed to the development of open-source tools and Python code for analyzing big data in the geosciences. These tools, however, could also be applicable to other subjects. Modules used in a Pangeo ‘State of Mind’ include xarray and dask, the latter of which enables connection to high-performance computing infrastructure and schedulers. Jupyter notebooks can additionally be used for interactivity with big data.

This Hacks With Friends project would work on developing a repository of scripts necessary to explore large data sets available to the University's broad research community. Products of this project will be deposited in a GitHub repository of the group’s choice.

Having code available, as planned here, will ensure the value of large research data and its storage is sustained, as data left inaccessible, untouched, an not maintained has no value.

Team 4 Videos: 3-Minute Pitch

Back to top

5: Salesforce Appointment Scheduler
HWF 2020 Collaboration Award

Team Members:

  • Scott Berkley, Office of Diversity, Equity and Inclusion
  • Angela Hall, University Career Center
  • James McLane, ITS
  • Cole Motley, UM-Dearborn ITS - Pitch Leader
  • Jeanine Novak, Ross IT
  • Ethan Savage, ITS
  • Kristen Tranchida, Student Life Technology Solutions
  • Shelly Turner, ITS
  • Ryan Vis, ITS
  • Shih-Wen Wu, Rackham
  • Sinji Yang, LSA Technology Services
  • David Schmitke, ITS

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

We will attempt to build out an appointment scheduling tool for students to book appointments with folks across the university. We will try to utilize Salesforce Communities and all the fun automation tools with Salesforce to complete this hack!

Team 5 Video: 3-Minute Pitch

Back to top

6. Improve the ServiceNow Mobile Experience

Team Members:

  • Shanelle Boluyt, HITS/Michigan Medicine
  • Roger Burns, HITS/Michigan Medicine - Pitch Leader
  • Mohan Reddy, HITS/Michigan Medicine
  • Jarrod Sandel, HITS/Michigan Medicine
  • Eric Weimer, HITS/Michigan Medicine

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

ServiceNow's legacy mobile client is being deprecated. Enabling the new mobile experience will allow us to enhance both agent and customer experience.

Team 6 Video: 3-Minute Pitch

Back to top

8. Research Contribution and Data Storage in Private Blockchain

Team Members:

  • Ben Balk, ITS
  • Matthew Demerath, HITS/Michigan Medicine
  • Michele Goci, CAEN
  • Wei Shi, HITS/Michigan Medicine - Pitch Leader

Category: Research Storage

Description:

A private blockchain can be used to store research contributions and data. Each research contributor maintains a duplicated secured copy on his/her node (computer) with timestamped data. All stored data is immutable. Each node can be easily distributed using Docker image. An interface can be exposed to institutional dataset catalog for research study summary.

We'll develop the application on ethereum Blockchain. Blockchain application development will use language Solidity, which is a Java-like language. Docker image will be built. We also need to look into blockchain security.

Team 8 Video: 3-Minute Pitch

Back to top

9. Mapping Inclusivity
1st Place Judges Award & Broadest Reach Award (Public Voting)

Team Members:

  • Crystal Borgman, ITS
  • Caitlin Dickinson, LSA Technology Services
  • Husnu Kaplan, HITS/Michigan Medicine
  • Abbey Roelofs, LSA Technology Services - Pitch Leader

Category: Diversity, Equity & Inclusion (DEI)

Description:

The current online Campus Map site doesn’t include information on accessible or gender-neutral restroom locations; this information is in text and Google map format across various University sites. We’ll use the existing information and ArcGIS tools to make a mobile-friendly web map and navigation application to easily find the nearest accessible and/or gender-neutral restroom on campus and explore ideas for other resources that could be added in the future.

Team 9 Videos: 3-Minute Pitch10-Minute Presentation to Judges

Back to top

10. MiPark - Michigan Medicine Parking Reservation System
Honorable Mention Judges Award; People’s Choice & MacGyver Award (Public Voting)

Team Members:

  • Amulya Kodari, HITS/Michigan Medicine
  • Swetha Kulkarni, ITS
  • Joe Lipa, HITS/Michigan Medicine
  • Leif Myklebust, HITS/Michigan Medicine
  • Jeffrey Rosczyk, HITS/Michigan Medicine
  • Michael Sheppard, HITS/Michigan Medicine - Pitch Leader
  • Andrew Staley, HITS/Michigan Medicine
  • Dan Stanish, HITS/Michigan Medicine
  • Leticia Valdez, ITS
  • Jared Walfish, ITS
  • Sally Luoma, ITS

Category: Parking

Description:

Michigan Medicine (MM) patients and staff face the daily challenge of locating a parking space near the health system. The purpose of this pitch is to design and build a parking reservation system that will give patients the option of reserving a parking space prior to their arrival. The parking reservation system will ensure that patients have a specific parking space assigned and available when they arrive at the hospital system.

Team 10 Videos: 3-Minute Pitch10-Minute Presentation to Judges

Back to top

13. CAPS Faculty Toolkit App

Team Members:

  • Christine Asidao, CAPS
  • Maggie Davidson, ITS
  • Whitney Dye, LSA
  • Elizabeth Fomin, LSA
  • Henry Hedly, HITS/Michigan Medicine
  • Brian Miller, ITS
  • Samuel Sciolla, ITS
  • Todd Sevig, CAPS
  • Jackie Wolf, HITS/Michigan Medicine
  • Jessica Wolking, LSA
  • Nancy Herlocher, LSA
  • Chris Stockbridge, LSA - Pitch Leader

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

Helps us improve the mental health of UM Students. Counseling and Psychological Services (CAPS) produces excellent resources and guides for faculty that enable them to help undergraduates. Let's turn their Faculty Handbook into an app so that it can reach a wider audience: GSIs, Staff, and anyone else who works closely with students.

Team 13 Video: 3-Minute Pitch

Back to top

14. Review Ready

Team Members:

  • Ryan Hoffer, Law
  • Tianyu Jiang, Student
  • Rachel Leggett, CAEN - Pitch Leader
  • Edwin Tang, CAEN

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

Staff who lead review processes for applications to student programs (and who can't or don't want to use a third-party vendor's software) often ask for custom Google App Scripts to parse their Google Form responses into human-readable summary spreadsheets and applicant summary documents. These scripts are brittle and repetitive. Let's build a tool outside of the Google ecosystem where these folks can import a CSV, choose fields for summary sheets and documents, then export those summaries to use in their review processes.

Team 14 Video: 3-Minute Pitch

Back to top

15. Do You Need Anything? The U-M DYNA App.

Team Members:

  • Erik Barroso, Academic Innovation
  • Paris Phou, HITS/Michigan Medicine - Pitch Leader

Category: Sustainability and Carbon Neutrality

Description:

In the year 2020, we can have almost anything delivered to our front door – groceries, home decor, takeout meals; almost anything imaginable. But for the drivers that have to navigate Ann Arbor’s congested streets, their cars and trucks emit CO2 on every trip they make. The U-M DYNA (Do You Need Anything?) App would strive to make the 5 different students ordering what they need in one night into one combined delivery to the same dorm- requiring only one trip for the driver for 5 deliveries and thus reducing the overall amount of emissions produced. By using tech to combine and reduce delivery trips to and from the dorms, we can begin to lessen the university’s carbon emissions by reducing the amount of car trips needed around campus.

Team 15 Video: 3-Minute Pitch

Back to top

16. Hands Free Ticket Creation
2nd Place Judges Award

Team Members:

  • Kranthi Bandaru, ITS - Pitch Leader
  • Kevin Bechard, ITS
  • Mandie Chapman, ITS
  • Rick Getchell, ITS
  • Matthew Jones, ITS
  • Mark McManamay, ITS
  • Luke Palnau, Office of University Development
  • Rob Pfeiffer, ITS
  • Chris Rowland, ITS
  • Kristine Towne, ITS

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

I'm looking at exploring the options of improving customer support which involves any ITSM product.

From Michigan App or any standalone app on mobile, User speaks to the mobile device and says "Please create a ticket to ABC group" with the following description "Printer not working in Building X, floor Y, room Z"

Based on the input, the mobile app connects to TDx/ITSM APIs, and creates a ticket. This will improve the customer satisfaction and explore new ways of handling support.

Team 16 Videos: 3-Minute Pitch10-Minute Presentation to Judges

Back to top

17. MiFeedback

Team Members:

  • Diana Perpich, Library
  • Adam Roehm, ITS
  • Hema Shah, ITS - Pitch Leader
  • Nathan Shepherd, Student
  • Aubrey Theisen, HITS/Michigan Medicine
  • Carrie West, Shared Services Center

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

To hear the voices of students, parents, faculty, staff, alumni, and the public through feedback surveys and open responses which will be collected into a centralized database location at University of Michigan. This data will be used to create, analyze, and prioritize critical changes which, when implemented, will bring the University of Michigan closer to achieving it's mission and becoming the leading University in the world. The ability to monitor feedback at the University level will enable widespread improvements, while enabling effective and focused responses to any systemic issues which are detected across various campus areas. Advanced feedback trends and patterns which would otherwise go unnoticed through the current campus feedback reporting structures, would be rapidly acted upon for quicker remediation on behalf of all individuals who interact with the University.

Team 17 Video: 3-Minute Pitch

Back to top

19. Containers, Clusters, Operators, Oh My

Team Members:

  • Michael Shen, HITS/Michigan Medicine
  • John Walsh, HITS/Michigan Medicine - Pitch Leader
  • Ross Bryan, HITS/Michigan Medicine

Category: Other: Your own original idea related to a specific discipline, the university, or its mission.

Description:

We wanted to experiment with Kubernetes controllers/operators and build an artifact repository in Nexus.

Team 19 Video: 3-Minute Pitch

Back to top