2021 Hacks with Friends Pitches | Office of the VPIT-CIO

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

Index of Pitches

Genetic Testing Prototype - WINNER 1st place
Establishing passwords for sponsored affiliates - Honorable mention
Denodo for report building using APIs
X - Withdrawn
What is Power BI?
UM Google Chat Bot
X - Withdrawn
Disability Services Accommodation Workflow
Scholarships Come to You - 2nd place & People's Choice
IT Mentor Matching On Demand - 3rd place
X - Withdrawn
X - Withdrawn
X - Withdrawn
Cosign retirement - create repository of sample code for SAML and OIDC integrations
X - Withdrawn
Instrumenting Education
Gather Town Proof of Concept
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.

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.

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.

4. X - Withdrawn

Pitch withdrawn.

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.

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

7. X - Withdrawn

Pitch withdrawn.

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.

9. Scholarships Come to You - 2nd place & People's Choice

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.

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

11. X - Withdrawn

Pitch withdrawn.

12. X - Withdrawn

Pitch withdrawn.

13. X - Withdrawn

Pitch withdrawn.

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.

15. X - Withdrawn

Pitch withdrawn.

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!

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!

18. X - Withdrawn

Pitch withdrawn.