2021 Hacks with Friends Pitches

Hacks with Friends 2021 - May 7, 14, & 21

All pitches submitted for the 2021 Hacks with Friends are displayed below.

Index of Pitches

  1. Genetic Testing Prototype - WINNER 1st place
  2. Establishing passwords for sponsored affiliates - Honorable mention
  3. Denodo for report building using APIs
  4. X - Withdrawn
  5. What is Power BI?
  6. UM Google Chat Bot
  7. X - Withdrawn
  8. Disability Services Accommodation Workflow
  9. Scholarships Come to You - 2nd place
  10. IT Mentor Matching On Demand - 3rd place
  11. X - Withdrawn
  12. X - Withdrawn
  13. X - Withdrawn
  14. Cosign retirement - create repository of sample code for SAML and OIDC integrations
  15. X - Withdrawn
  16. Instrumenting Education
  17. Gather Town Proof of Concept
  18. X - Withdrawn

1. Genetic Testing Prototype - WINNER 1st place

Team Members:

  • Jeffrey Rosczyk (Pitch leader), Michigan Medicine Center for Health Communications Research (CHCR), Rogel Cancer Center
  • Diane Egleston, Michigan Medicine CHCR, Rogel Cancer Center
  • Amanda Wright, Michigan Medicine HITS
  • Mike Nowak, Michigan Medicine CHCR, Rogel Cancer Center
  • Ian Moore, Michigan Medicine CHCR, Rogel Cancer Center
  • Jill Solomon, Michigan Medicine CHCR, Rogel Cancer Center
  • Swetha Nettem, UM-Ann Arbor ITS Infrastructure & Sys Ops
  • Kevin Jeong, UM-Ann Arbor ITS Enterprise App Svcs
  • Penny Yang, Michigan Medicine CHCR, Rogel Cancer Center
  • Liz Bacon, Michigan Medicine CHCR, Rogel Cancer Center
  • Shelly Chang, Michigan Medicine CHCR, Rogel Cancer Center
  • Colleen Leh, Michigan Medicine CHCR, Rogel Cancer Center

Category: Accelerating Research

Description:

Recently genetic testing has come a long way in affordability. It is not just for the rich anymore. Doctors are able to determine if a healthy person has a potential future risk for cancer using genetic testing. Patients with cancer are in the unfortunate but unique situation to help inform their relatives and save lives.

Our goal for this project is to build a platform or application for cancer patients that will allow them to inform their relatives of their need for genetic testing. The project’s functionality will be open for discussion. The possibilities of this project may include an email system, a SMS messenger, a Facebook app, a video chat, etc. Bring your ideas and help build something that empowers cancer patients with the ability to save lives.

Back to top

2. Establishing passwords for sponsored affiliates - Honorable mention

Team Members:

  • Victoria Green (Pitch leader), UM-Ann Arbor ITS Sec Svcs ID & Access Mgt
  • Abdulrahman Ateya, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt (Intern)
  • Elizabeth Barrieault, UM-Ann Arbor ITS Support Services
  • Frank Wang, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt (Intern)
  • Kyle Cochrane, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt
  • Sheila Sanders, UM-Ann Arbor ITS Support Services
  • Adria Shines, UM-Ann Arbor ITS Enterprise App Svcs (Intern)
  • Cindy Wang, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt (Intern)
  • Tamariah Davis, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt (Intern)

Category: Business Administration

Description:

Most newly-created UMICH identities establish their own passwords but uniqnames created through the Sponsorship System must have their passwords conveyed to them by the Sponsor Administrator (or, sometimes, the ITS Service Center).

While an elegant, fully-baked solution is outside the scope of this hack, we think in short order we can build a behind-the-scenes bridge to enable newly-created sponsored affiliates to use forgotten password recovery functionality to set their own passwords. If it goes well, we could deliver real value in production.

This work needs a pretty small team and maybe just a single developer with experience with U-M's identity data and infrastructure. It would be a good opportunity for someone interested in learning more about business analyst work (requirements, testing, communications with stakeholders) to partner up and try new things.

Back to top

3. Denodo for report building using APIs

Team Members:

  • Kranthi Bandaru (Pitch leader), UM-Ann Arbor ITS Information Quest
  • Peggy Lai (Pitch leader), UM-Ann Arbor ITS Information Quest
  • Pushyami Gundala, UM-Ann Arbor ITS Teaching and Learning
  • Steven Harrow, UM-Flint ITS Institutional Analysis
  • Gail Lift, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt
  • Edith Mei, Michigan Medicine HITS
  • David Perhne, LSA MIS Business Intelligence

Category: Business Administration

Description:

Several U-M departments use API Directory APIs to fetch the data and create a local repository so they can create a report by mixing and matching the data. I want to explore the same option using the Denodo tool. Denodo is a Data Virtualization software that ITS recently launched for the entire university. It has some great features yet to be discovered. This may be our chance to explore that.

Using Denodo for generating reports this way avoids data redundancy and these reports can be shared with UM community easily using Denodo authentication.

Back to top

4. X - Withdrawn

Pitch withdrawn.

Back to top

5. What is Power BI?

Team Members:

  • Sally Luoma (Pitch Leader), UM-Ann Arbor ITS Information Quest
  • Phillip Kocher, UM-Ann Arbor ITS Information Quest
  • Samuel Russell, UM-Ann Arbor School of Public Health
  • Zini Brace, UM-Ann Arbor ITS Information Quest (Intern)
  • Heather Zimmerman, UM-Ann Arbor ITS Information Quest (Intern)
  • Ben Andries, UM-Ann Arbor ITS Infrastructure
  • Payal Dangi, UM-Ann Arbor ITS Information Quest
  • Mengyun Zhai, UM-Ann Arbor LSA - Student
  • Jeffrey Wixon, UM-Ann Arbor ITS Information Quest
  • Kristin Kovarik, UM-Ann Arbor ITS Information Quest
  • Erica Ackerman, UM-Ann Arbor ITS Enterprise App Svcs /eResearch
  • Ning Tsui, UM-Ann Arbor ITS Enterprise App Svcs

Category: Business Administration

Description:

Do you have a need to connect, integrate multiple data sources, and analyze your business data? Are you wondering what Business Intelligence functions and capabilities Power BI Pro has to offer? A license to campus is available for a small annual fee. Michigan Medicine’s licensing of Microsoft 365 will include Power BI application for free. Our hack will explore the pros and cons and possible uses of this tool.

Back to top

6. UM Google Chat Bot

Team Members:

  • Kinnothan Nelson (Pitch leader), UM-Ann Arbor School of Nursing
  • Sinji Yang, UM-Ann Arbor LSA Technology Services
  • Thomas Stockwell, UM-Dearborn ITS Applications Team
  • Tom Pickren, UM-Ann Arbor Office of University Development

Category: Business Administration

Description:

Develop a UM Google Chat Bot framework that has an initial feature set that includes the ability schedule chat messages, and send messages to and receive messages from email addresses and Slack channels

Back to top

7. X - Withdrawn

Pitch withdrawn.

Back to top

8. Disability Services Accommodation Workflow

Team Members:

  • Cole Motley (Pitch Leader), UM-Dearborn ITS
  • Ethan Savage, UM-Dearborn ITS
  • Joy Hearn, UM-Dearborn ITS CRM Team
  • David Schmitke, UM-Ann Arbor ITS Enterprise App Svcs
  • Felix Partington, UM-Ann Arbor ITS Enterprise App Svcs
  • Justin Harrington, UM-Ann Arbor ITS Enterprise App Svcs
  • Stephanie Henyard, UM-Ann Arbor ITS Infrastructure
  • Marta Bauer, UM-Dearborn Undergraduate Admissions
  • Greta Valmassoi, UM-Dearborn ITS CRM Team

Category: Diversity, Equity & Inclusion (DEI)

Description:

The students at UM-Dearborn who have special accommodations to support their coursework are in need of a process and system upgrade! Help design a streamlined workflow process for the students, staff, and faculty to request, process, and approve accommodations. We plan to utilize Salesforce and FormAssembly to get this process off of paper and email.

Back to top

9. Scholarships Come to You - 2nd place

Team Members:

  • Tong Sun (Pitch Leader), UM-Ann Arbor CoE-IT/CAEN
  • Karen Saito, UM-Ann Arbor CoE-IT/CAEN
  • Reinhard Wilmer, Student Statistics, College of LSA
  • Alyssa Bigley, UM-Ann Arbor ITS Infrastructure - Networking (Intern)
  • Victor Ogundipe Jr., UM-Ann Arbor CoE CAEN
  • Bryan Hartman, UM-Ann Arbor ITS Information Quest
  • Jeffrey Jenkins, UM-Ann Arbor ITS Information Quest
  • Brian Awood, UM-Ann Arbor ITS Infrastructure
  • George Blichar, UM-Ann Arbor CoE-IT/CAEN
  • Tianyu Jiang, UM-Ann Arbor Undergraduate student, College of LSA
  • Ran Yan, UM-Ann Arbor Department of Applied Statistics
  • Joshua Charles, UM-Ann Arbor ITS Enterprise App Svcs

Category: Diversity, Equity & Inclusion (DEI)

Description:

Parents and students, tired of searching through Umich websites to look for scholarships? Lack the resources to know if you are eligible? Scholarships Come To You will automatically match scholarship opportunities based on your eligibility and proactively contact you - no efforts required on your side! For example, when a new scholarship for UM students from Hawaii and Washington is added to a database hosted by a department, we will identify the list of eligible students via a data visualization tool (Denodo) and launch a Salesforce Campaign to notify the students; after three months we’ll send you a Qualtrics survey so you can rate the scholarship and give feedback based on your experience. Future features include the Go Blue Scholarship Explorer web app that will allow students to control their own scholarship search experience, and regular scans of all scholarships to remind eligible students three months before the deadline.

Back to top

10. IT Mentor Matching On Demand - 3rd place

Team Members:

  • Daniel Stanish (Pitch Leader), Michigan Medicine – Pediatrics
  • Stefanie Horvath, UM-Ann Arbor ITS Communications
  • Ed Thierbach, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt
  • Will Burns, UM-Ann Arbor ITS Enterprise App Svcs
  • Aubrey Theisen, Michigan Medicine HITS
  • Chris Stockbridge, UM-Ann Arbor LSA Tech Services
  • Ryan Vis, UM-Ann Arbor ITS Enterprise App Svcs
  • Abbey Roelofs, UM-Ann Arbor LSA Technology Services
  • Rachael Wojciechowski, UM-Ann Arbor ITS Communications
  • Ajitha Devarajan, UM-Ann Arbor Office of University Development

Category: Diversity, Equity & Inclusion (DEI)

Description:

Mentoring is a valuable opportunity, and we need to do more of it. Since the initial pilot in 2017, nearly 200 Michigan IT staff members have participated in the Michigan IT Mentorship program. Our current program involves a time-consuming manual matching process, which limits our reach to matching once per year. This pitch is to create or identify a platform to help IT mentors and mentees find each other “on demand.” This could potentially broaden the participation and also provide near-realtime matching and confirmation of mentors and mentees, as well as allow the mentorship program to be available year-round.

https://it.umich.edu/community/mentor-program

Back to top

11. X - Withdrawn

Pitch withdrawn.

Back to top

12. X - Withdrawn

Pitch withdrawn.

Back to top

13. X - Withdrawn

Pitch withdrawn.

Back to top

14. Cosign retirement - create repository of sample code for SAML and OIDC integrations

Team Members:

  • Patrick Steffes (Pitch Leader), UM-Ann Arbor ITS Sec Svcs ID & Access Mgt
  • Bob Harold, UM-Ann Arbor ITS UMnet
  • Ali Alrubaiee, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt
  • Sam Sciolla, UM-Ann Arbor ITS Teaching & Learning
  • Ramya Kommareddi, UM-Ann Arbor Office of University Development
  • Tevon Hastings, UM-Ann Arbor ITS Sec Svcs ID & Access Mgt

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

Description:

In order to drive the retirement of cosign IAM would like to identify recommended and commonly used SAML/OIDC (IAM's recommended SSO protocols) implementations and create sample repositories that others can use as a reference when determining how to move away from cosign.

Back to top

15. X - Withdrawn

Pitch withdrawn.

Back to top

16. Instrumenting Education

Team Members:

  • Christopher Brooks (Pitch Leader), UM-Ann Arbor School of Information
  • Travis DePrato, UM-Ann Arbor College of Engineering EECS-ECE
  • Jacob Shreve, UM-Ann Arbor School of Information
  • Lance Sloan, UM-Ann Arbor ITS Teaching and Learning
  • Zhen Qian, UM-Ann Arbor ITS Teaching and Learning
  • Brian Duck, Guest

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

Description:

Did you know that UM has a repository for educational telemetry data with millions of records? Let's get together and hack it by adding new applications from the UM learning ecosystem or building new inquiries into student use of data tools - and let's document the process and turn this into standard operating procedure!

Back to top

17. Gather Town Proof of Concept

Team Members:

  • Chris Eagle (Pitch Leader), UM-Ann Arbor ITS CIO Strategy and Planning
  • Jane Zhao, (Pitch Leader) UM-Ann Arbor ITS Enterprise App Svcs
  • Jingcong Hu, UM-Ann Arbor ITS - Infrastructure
  • Luke Palnau, UM-Ann Arbor Office of University Development
  • Mrunmayi Kokardekar, UM-Ann Arbor ITS - Infrastructure
  • Nan Godwin, UM-Ann Arbor ITS Infrastructure
  • Michelle Zuelke, UM-Ann Arbor ITS Enterprise App Svcs
  • Rick Getchell, UM-Ann Arbor ITS Service Center
  • Jeff Weatherup, UM-Ann Arbor School of Music, Theater, Dance
  • Jennifer Klink, Michigan Medicine
  • Alison Diefenderfer, UM-Ann Arbor CEDER/School of Education

Category: Business Administration

Description:

This hack is to explore opportunities to enhance the social environment for people working remotely. Gather Town is one of the first tools that goes beyond a Zoom Call and attempts to create a virtual environment that can be a proxy for a physical office environment. Come join Chris Eagle and Jane Zhao from ITS and create a fun and interactive virtual environment. Coding skills are not needed - creative thinking about interpersonal interactions is!

Back to top

18. X - Withdrawn

Pitch withdrawn.

Back to top