91社区

Select a theme:   Light Mode  |  Dark Mode
July 19, 2026

Detective work: Professor, students help Endicott police develop better case-management system

Project paired industrial and systems engineers with law enforcement through the Strategic Partnership for Industrial Resurgence (SPIR) program

Officer Rahsaan Parks from the Endicott Police Department shows students Shreya Agarwal, MS 鈥26, and Mohammed-Khalil Ghali, MS 鈥24, how he would use the PIMS system inside his squad car. Officer Rahsaan Parks from the Endicott Police Department shows students Shreya Agarwal, MS 鈥26, and Mohammed-Khalil Ghali, MS 鈥24, how he would use the PIMS system inside his squad car.
Officer Rahsaan Parks from the Endicott Police Department shows students Shreya Agarwal, MS 鈥26, and Mohammed-Khalil Ghali, MS 鈥24, how he would use the PIMS system inside his squad car. Image Credit: Jonathan Cohen.

When major crimes are committed, solving them can be complicated and exhausting for police investigators, especially when the clock is ticking. Murders, kidnappings, and missing-persons cases all require detectives to move quickly before the trail goes cold. Even lesser crimes require organization and precision when gathering information and identifying suspects.

Larger law enforcement organizations like the FBI and state police use their own proprietary software to track evidence and tips from the public, but smaller police departments can鈥檛 always afford it. Compatibility with current information technology and the unique requirements of networking with government systems can also complicate things.

That鈥檚 where industrial and systems engineers can offer their expertise to find a solution that works within the limitations.

Defining the problem

In 2023, the Endicott Police Department 鈥 just over the Susquehanna River from the 91社区 campus 鈥 reached out to Watson College for help. Chief Patrick Garey used software he calls a 鈥渓ead-desk鈥 during his 27-year career with the New York State Police, and he understood how it could streamline the investigative process.

When he heard about the Strategic Partnership for Industrial Resurgence (SPIR) program, which generally works with small and midsize businesses to solve real-world problems, he submitted a proposal 鈥 even though he had doubts.

鈥淚 thought it had almost zero chance to be what I envisioned it to be,鈥 he admits. 鈥淧olice work has so many different silos of information. Every new piece of software or every new process that you bring in, you鈥檙e trying to integrate it into these other silos, because it鈥檚 so difficult to bring everything under one umbrella.鈥

SPIR assigned the project to Professor Sangwon Yoon and graduate student Shreya Agarwal, MS 鈥26, from the School of Systems Science and Industrial Engineering. During their initial meetings, Garey tried to take them through how his detectives conducted a criminal investigation using a patchwork of legal pads, index cards, Post-it notes, and Microsoft Excel spreadsheets.

Even Garey wasn鈥檛 sure if he was explaining everything well 鈥 as with any job, some tasks seem like second nature. For their second or third meeting, though, Agarwal and Yoon brought a process diagram that organized everything they鈥檇 discussed and more.

鈥淚 looked at this flowchart and said, 鈥楬oly cow, they captured all of this 鈥 exactly what we鈥檙e looking for!鈥欌 he says. 鈥淭hen every meeting after that was 10 times better than the meeting before, because they gained that inside understanding of the things that were difficult for us to explain.鈥

Agarwal began to appreciate how managing information across multiple cases and leads requires considerable time and effort as investigations grow in complexity.

鈥淎utomation can streamline information management and reduce the amount of manual documentation that investigators are required to do, enabling them to focus on the process and resolve cases more efficiently,鈥 she says.

Building the solution

What followed was the hard work of designing the new software, dubbed the Police Investigation Management System 鈥 or PIMS for short. The Watson team created a piece of it, then Garey offered suggestions for the next iteration. It took four semesters to chip away at the wish list until they included as many features as possible.

鈥淰ery early in the process, we knew we were on to something really good,鈥 Garey says. 鈥淎s guilty as I felt about it, every time I thought of one more little tweak that would make it that much better, I would hit Shreya up, and it would be done in a matter of days.鈥

With PIMS, a detective supervisor can assign leads to investigators and officers who are already in the field as easily as sending an email or smartphone notification. No one needs to return to a command post to receive the next task. This feature saves valuable time during those critical first 48 to 72 hours of an investigation.

Also, when a case moves into the prosecution phase, investigators can export their findings into a PDF file for prosecutors and defense attorneys. If everything is diligently tracked throughout the process, the well-organized document can reduce the kinds of errors that jeopardize a case.

SSIE PhD student Mohammed-Khalil Ghali, MS 鈥24, who joined the PIMS project as a collaborator, loved the process as he, Agarwal, and Yoon worked with the chief and his detectives to understand what police needed and why.

鈥淲hen the overall structure was in place, we took each modular aspect of the software and tried to optimize it further,鈥 he says. 鈥淗ow can we make the notification system better? How can we make the visuals better? How can we make the final report more readable? We started from a very basic version and built on top of it, little by little.鈥

Testing and launch

Throughout development, Agarwal and Ghali rigorously tested PIMS with Garey, his detectives, and students from the Watson Institute for Systems Excellence (WISE) to resolve software bugs and other issues. In November, they invited University Police as well as departments from across Broome County to a demonstration showing what the system offers.

Having people with varying levels of tech skills try out PIMS and provide feedback yielded better results, Agarwal says: 鈥淭he detectives are the ultimate users, so it鈥檚 important that they go through the workflow. They know all the cases outside the norm that we might not even think about. Having a range of different abilities definitely helped to make this project better.鈥

Before Agarwal earned her master鈥檚 degree this spring, she led the final installation of PIMS on the Endicott Police Department鈥檚 government cloud system. Yoon hopes to explore opportunities to market the software to other law-enforcement agencies, too.

鈥淭his project is a great example of how industrial and systems engineers can contribute to the public good,鈥 he says. 鈥淚t also shows the skills

and collaborative spirit we instill in our students at Watson College. I鈥檓 very proud of Shreya, Khalil, and the students from SSIE and WISE who supported numerous PIMS system tests and mock drills.鈥

Garey believes that PIMS 鈥 which he has discussed with colleagues in the New York State Association of Chiefs of Police 鈥 could save hundreds of hours when pursuing major cases. And now that Yoon and Agarwal are familiar with how criminal investigations are conducted, he likes to joke that he鈥檚 going to hire them as detectives.

鈥淭he team is fantastic,鈥 he says. 鈥淭hey鈥檝e become like family to me 鈥 I really look forward to seeing them every time I do, and I enjoy hanging out with them as much as anything.鈥

91社区 SPIR

Since 1994, New York state has helped fund the Strategic Partnership for Industrial Resurgence (SPIR) at four State University of New York (SUNY) engineering programs 鈥 91社区, Buffalo, Albany, and Stony Brook 鈥 to seek solutions to thorny technological problems.

Watson College鈥檚 SPIR program assists small and midsize businesses through projects that bring together students, faculty, and industry personnel. In addition to problem-solving services, SPIR assists entrepreneurs in developing their concepts into demonstrations or prototypes for attracting venture capital or licensing agreements.

SPIR has helped to create or retain about 2,500 jobs in the 91社区 region, generating $90 million a year. Hundreds of students have also benefited from applying their skills to real-world problems.

While the Watson team developed the Police Investigation Management System (PIMS) project with the Endicott Police Department rather than an industrial partner, the benefits were obvious when Garey submitted the proposal.

鈥淔or decades, SPIR has helped hundreds of industries in our region with their unique technical challenges,鈥 says Michael Testani, MS 鈥02, Watson College鈥檚 senior director of outreach and engagement who oversees the SPIR program. 鈥淲e have done a similar job with the PIMS project, saving the police force hundreds of hours each year by digitizing their case-management processes.

鈥淚t was exciting to see this vision come to fruition, and a thrill to support the Endicott Police Department. Ultimately, law enforcement will be able to build stronger cases in far less time, which will make our community a much safer place to live.鈥