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. Review the ideas to see which ones interest you. Join us Friday, April 23, from 10 a.m. – noon for a special Pitch Open House event via Zoom. The 2021 HWF planning committee will welcome you and pitch leaders will be available in breakout rooms within the Zoom session to discuss their pitch idea and answer your questions. Jump from room to room and find out all you need to know and decide which hack you want to join. A link to the open house will be available closer to the event.

1. Genetic Testing Prototype

Pitch Submitted By: Jeffrey Rosczyk

Category: Accelerating Research

Description:

Recently, genetic testing has come a long way in it's affordability. It's not just for the rich anymore. With genetic testing doctors are able to determine if a healthy person has a potential future risk for cancer. And 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/app for cancer patients that will allow them to inform their relatives of their need for genetic testing. How this project will function and work will be up for discussion. Is it an email system, or SMS messenger, or Facebook app, or ...? Bring your ideas and help build something that empowers cancer patients with the ability to save lives.

Who should join this pitch:

  • Developers - Mobile
  • Developers - Full-Stack
  • Developers - Middle-Tier
  • Developers - TBD
  • UI Designers
  • Presenter / Promoter / Cheerleader
  • Documentation Specialists

2. Establishing passwords for sponsored affiliates

Pitch Submitted By: Victoria Green

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.

Who should join this pitch:

  • Business Analysts
  • Developers - TBD
  • Documentation Specialists
  • Service Center Specialists

3. Denodo for report building using APIs

Pitch Submitted By: Kranthi Bandaru

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. Looking for enthusiastic minds. :-)

Who should join this pitch:

  • Business Analysts
  • Developers - Middle-Tier
  • Developers - Back-End
  • Presenter / Promoter / Cheerleader
  • Documentation Specialists

4. Development of Chartfield Change Request Web App

Pitch Submitted By: Mrunmayi Kokardekar

Category: Business Administration

Description:

The ITS Infrastructure team provides telecommunication and other IT services to departments across the University. These services are ordered via Service Request System (SRS) and billed at the department level through Pinnacle. When existing services need to be charged to a different account in a different department, both departments must approve the billing change. The current way of handling this process is through an Excel doc that gets emailed across the departments, finally making its way back to the ITS Infrastructure Billing group to process the change.

We are looking to develop an application that streamlines the workflow while electronically auditing the approval process. The application will allow departments to notify other areas of a billing change. The department can approve or decline a billing change, and if approved, will then notify ITS Infrastructure Billing group of the change.

Who should join this pitch:

  • Business Analysts
  • Developers - Front-End
  • Developers - Back-End
  • UX Designers

5. What is Power BI?

Pitch Submitted By: Sally Luoma

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. Please join if you have a use case or are interested in learning more.

Who should join this pitch:

  • Business Analysts
  • Systems Analysts
  • Project Managers
  • Presenter / Promoter / Cheerleader
  • IT Security Specialist
  • Data Scientists
  • Documentation Specialists
  • Service Center Specialists
  • Desktop Support

6. UM Google Chat Bot

Pitch Submitted By: Kinnothan Nelson

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

Who should join this pitch:

  • Business Analysts
  • Developers - Mobile
  • Developers - Middle-Tier
  • Presenter / Promoter / Cheerleader
  • IT Security Specialist
  • Documentation Specialists

7. Password manager for application integration

Pitch Submitted By: Kranthi Bandaru

Category: Cybersecurity

Description:

ITS staff majorly uses "password safe" as its main password repository. While its user friendly, it doesn't have application Integration features such as cli commands or APIs to fetch the userid/passwords directly into the application where we need the creds to connect to either a DB or service.

I'm looking to explore the features of either "Password safe" or any new password management tool like "CyberArk". If anyone across U-M already has this implemented, would like to learn from their experience as well. Thanks for reading.

Welcoming all application developers / dev ops people to collaborate and share the knowledge with others.

Who should join this pitch:

  • Systems Analysts
  • Developers - Back-End
  • Developers - TBD
  • IT Security Specialist
  • Dev ops or sysadmins to help us install certs etc!!!

8. Accommodation Workflow in Salesforce

Pitch Submitted By: Cole Motley

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.

Who should join this pitch:

  • Business Analysts
  • Systems Analysts
  • Developers - Front-End
  • UX Designers
  • UI Designers
  • Documentation Specialists
  • Service Center Specialists
  • Salesforce Folk

9. Scholarships Come to You

Pitch Submitted By: Tong Sun

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.

Who should join this pitch:

  • Business Analysts
  • Developers - Mobile
  • Developers - Full-Stack
  • Developers - Front-End
  • UI Designers
  • Project Managers
  • Data Scientists
  • Documentation Specialists

10. IT Mentor Matching On Demand

Pitch Submitted By: Dan Stanish

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

Who should join this pitch:

  • Developers - Mobile
  • Developers - Full-Stack
  • Developers - Front-End
  • Developers - Back-End
  • UX Designers
  • Presenter / Promoter / Cheerleader
  • Documentation Specialists
  • Salesforce Administrators

11. Freshness Sampling

Pitch Submitted By: Derrick Tietz

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

Description:

Check a data warehouse for freshness. Is there a set of data that has not been refreshed as scheduled? Maybe the process did not run at all or it failed.

Automatically send an email warning to those responsible so they are aware and can get the data refreshed.

Who should join this pitch:

  • Presenter / Promoter / Cheerleader
  • Documentation Specialists
  • Informatica Developers

12. Creating a website of resources for anyone teaching and learning over 50-55.

Pitch Submitted By: Irene Knokh

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

Description:

Ageism is still rampant-create a website or a repository or a web scraper of resources or open resources site to maintain opportunities for professional growth-50 plus and especially 55 plus. I would like this to be inclusive for everyone.

My inspiration is this site: baba-deda.ru (Russia), and AARP (U.S.)-there have to be different options, both sites are built for over 50's (doesn't necessarily make this group grandparents). :=)

My thoughts: either a mentoring or a fully professional development and growth site for UM specifically, as a start, and growing beyond UM. I am curious what other countries are doing for their over 55 population in training and development and wonder if we can learn from that experience.

It may be that I just need initial development/mentoring experience to start such a site or even a dashboard? Web scraper of available resources (vs. going on yet another Teams or Slack channel).

Who should join this pitch:

  • Developers - Mobile
  • UX Designers
  • UI Designers
  • Project Managers
  • Presenter / Promoter / Cheerleader
  • Documentation Specialists
  • Service Center Specialists

13. Withdrawn

Pitch withdrawn.

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

Pitch Submitted By: Patrick Steffes

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.

Who should join this pitch:

  • Business Analysts
  • Developers - TBD
  • Presenter / Promoter / Cheerleader
  • IT Security Specialist
  • Documentation Specialists

15. HIPAA Compliant IM Chat

Pitch Submitted By: Torrey Talifer

Category: Business Administration

Description:

Have you ever had a toothache or needed your wisdom teeth removed? Did you make sure to hold onto that small, yet deeply important, piece of paper so that you could be properly referred? Studies have shown that paper referrals not only can result in the delay of care but that they also may not even contain the pertinent information necessary for quality care when received. We hope to optimize this process by making it completely digital, refining the communication channels between providers, and ultimately increasing access to dental care. An instantaneous messaging system will allow for more accurate diagnoses, lessen complications and aid in the overall well-being of the patient. We are looking to create an encrypted chat feature as a part of our platform, in which protected health information can safely be exchanged about certain patient cases between providers within HIPAA guidelines.

Who should join this pitch:

  • Systems Analysts
  • Developers - Mobile
  • Developers - Full-Stack
  • Developers - Front-End
  • Developers - Back-End
  • UX Designers
  • UI Designers
  • IT Security Specialist

16. Instrumenting Education

Pitch Submitted By: Christopher Brooks

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!

Who should join this pitch:

  • Developers - Mobile
  • Developers - Full-Stack
  • Developers - Front-End
  • Developers - Middle-Tier
  • Developers - Back-End
  • Developers - TBD
  • Presenter / Promoter / Cheerleader
  • IT Security Specialist
  • Data Scientists
  • Documentation Specialists

17. Gather Town Proof of Concept

Pitch Submitted By: Chris Eagle, Jane Zhao

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!

Who should join this pitch:

  • Business Analysts
  • Systems Analysts
  • UX Designers
  • UI Designers
  • Project Managers
  • Presenter / Promoter / Cheerleader
  • Documentation Specialists
  • Service Center Specialists
  • Desktop Support