iSchool Capstone

2021

Project Logo

SecViz: Simplifying Cyber Threat Mitigation

The security industry is rapidly developing and changing, creating a knowledge gap and skills shortage due to the challenging learning curve. Analysts and students struggle with the overwhelming amount of data that typical network analysis tools display, which leads to a time-consuming investigation process. The SecViz tool allows SecOps analysts to read and dynamically visualize packet logs, leading to faster identification, investigation, and mitigation of KPIs. In addition, the tool helps expedite the speed of identifying security gaps that may have been missed or taken a significant amount of time to come across.
Project Logo

SHP 2.0

The Worcester Public Library’s intranet, or SHP, is underutilized, outdated, disorganized, and not intuitive for its users. The absence of an effective, centralized communication and knowledge-sharing platform makes it difficult for staff to access the information they need to meaningfully assist and inform the community. We delivered a two-phase consultative report to guide redesigning the SHP, detailing best practices, user research findings, a redesigned intranet concept, and change and organizational management recommendations. Our project uncovered communication deficiencies and provided the WPL with a framework for redesigning and implementing a new intranet. Improved staff communication will facilitate overall community engagement.
Project Logo

Smartsheet Identity and Access Management Automation

The current quarterly access review process at Smartsheet comes with a myriad of challenges. Smartsheet’s access reviews are time-consuming and draw upon a lot of resources. There’s a large company-wide communication effort to track changes in employee structure. Our Identity and Access Management Dashboard presents the Smartsheet Compliance team with employee change metrics tracked with custom automation, a report containing highlighted daily employee changes, and visualizations used to present a historical timeline of changes in employee structure. With our dashboard, Smartsheet’s Compliance team will be able to save time and resources and have key actionable insights to employee changes.
Project Logo

Smartsheet System Administrator User Harbor - Evolving the user experience for admin users to track and use reports and bulk actions

Smartsheet is a suite of products that makes teams productive through cloud-connected tools. System Administrator users using Smartsheet manage their users and settings, and they use reports and bulk actions for auditing purposes and user management. In the current system, reports and bulk action statuses are sent via email. Thus, there is no possible way to audit or track these items, which causes unnecessary confusion. Through this project, we designed & developed a dashboard for users to enable managing reports and bulk actions conveniently. Through these new features, admin users gain more control and flexibility to do their jobs.
Project Logo

Sno-Cap: Data Migration, Consolidation & Visualization

The Sno-King Amateur Hockey Association collects and stores tens of thousands of registration and donation data entries across seven different platforms each year. With their data storage not being centralized, accessing their data has become increasingly difficult as the organization has grown and more data continues to flow in. For our Capstone project, we were tasked with creating and filling a centralized database, and then making analyses based on that data. From the work we have done, our sponsor will be able to make their own analyses to make better marketing decisions for its adult and youth hockey programs.
Project Logo

Sound Sustainability: Online Hearing Education

Currently, there is not enough information available to the public when it comes to hearing health, and this is creating a stigma where people are reluctant and even refusing to wear hearing aids. Hearing Education, working with Sound Sustainability, focuses on increasing awareness of the importance of hearing health by providing helpful resources all in one location. Our team, along with two other student-led teams, hopes to destigmatize hearing loss by teaching people about their own hearing and helping them engage in the hearing community.
Project Logo

Sourcing additional information on private equity transactions

The world of private equity (PE), already formidable in size, is expected to see continued rapid growth in the coming years. Global PE assets under management are forecast to reach US$5.8 trillion by 2025. PitchBook tasked us with identifying additional sources of private-market info to supplement their robust information-architecture. Specifically, PitchBook requested publicly available, granular information pertaining to the investments made by an individual fund of an investor, known as deal-to-fund tagging.
Project Logo

Spin It Again: Digitizing Vinyl in the Seattle Pacific University Archive

The Seattle Pacific University Archives contain a range of recorded sound objects, including vinyl phonographic discs of performances by university music groups. I digitized this collection of vinyl discs using a USB-enabled turntable and Audacity software, creating WAV and MP3 recordings. The purpose was to increase ease of access for the archivist, the SPU community, and other researchers to this collection. I created a workflow outlining my steps when digitizing and gave this document to the SPU archivist, to aid further digitization efforts and supplement training for future workers.
Project Logo

SSCode: A Google Docs Like Experience for Code Editing with your Team

The pandemic has caused us to start shifting towards a more remote workspace for students and industry workers. Software developers have the tools to be able to work in this condition, but the experience is not always great. Developers in teams have trouble working together on projects because the current tools available make it difficult. Most of the issues lie in the fact that code is not easily shareable and requires slightly tedious tasks to do so. That is why we have made SSCode—an online programming platform that allows developers to create programming scripts online and script synchronously with others.
Project Logo

StoryBond

Everyone is a book filled with their own life stories. How much do we actually know about them? StoryBond is a social media app that encourages people to share and exchange stories, and these stories have the power to turn acquaintances into friends. Our app is a place to know more about the people you have met through the exchange of stories. The story can be an idea, a personal anecdote, or an experience. StoryBond provides a way that helps people connect on a deeper level. Hopefully, our users can make true bonds through writing and exchanging stories.