UPenn Supports Labratory Functions with Custom Low-code App
The new state-of-the-art “nanotechnology” laboratory complex the University of Pennsylvania is opening this year will rival any research facility in the world.
But some of the IT applications supporting the venture are years, if not decades, behind what peers are using. Scheduling for the systems is done using an old conference room calendaring application. Billing was done using Excel, some records were still entered on paper logs, and changes in user authorizations had to be done manually.
This posed multiple challenges for the University. If a research institution wanted a progress report on charges its researchers had incurred half-way through the month, it would take three days to tabulate.
If the director wanted to decertify a user’s privileges, he’d have to do it one machine at a time. And if he wanted analytics on which groups were undertaking different kinds of projects, he simply couldn’t produce them.
“I couldn’t fathom moving forward, facing this new group of faculty and researchers with what we had in place,” Clay said.
Solution
Clay, a former lab leader at Cornell and Harvard, had had experience working with more advanced billing, calendaring and analytics functions – and he set out to upgrade the apps at Penn.
He looked into off-the-shelf software, but the customization needed would have been cost prohibitive and time-consuming. Internal IT developers at Penn could have created apps that performed the functions, but it would have taken several years. And, since his staff of 15 – five researchers, five grad students and five contractors – included no advanced coders, he couldn’t do the work in house. Clay needed another solution.
Clay turned to the Mendix development platform to create one omnibus app that would run all billing, equipment reservation and analytics for the lab. The app would replace all the legacy systems that handled these functions. He needed to move quickly, to get the new system up and running when his lab moved into a new central location in the spring.
The team built the app in February, ran tests in March and had it deployed by early April. He also needed to have it fit into a tight budget.
Results
A team of three non-technical laboratory pros on Clay’s staff conducted all of the development of the new app using Mendix.
“They’ve really taken to it,” Clay said. “The platform is intuitive, easy to use and chockfull of features they can use to create the app that suits our needs. They’re easily adding in all the customization in the system that they’ve ever wanted. I have three scientists acting like kids in a candy store, building exactly what they have wanted for years.”
One new feature they’ve created is a way to easily analyze the ongoing condition of the equipment in the lab.
For example, Clay said, the team may want to keep a close eye on a critical temperature or level of vacuum in an electron microscope. Other solutions typically require a database querying program, rigid internal coding or software for this added functionality. Clay’s team is planning to set up unique dashboards in the app that they can review each morning, allowing them to be more proactive in addressing process problems areas as well as equipment maintenance.
The biggest benefit the department will realize, Clay said, is saving at least a week of one professional’s labor costs every month. Instead of taking a week to reconcile invoices, the new automated app can churn out an invoice with a push of a button.
Clay added that the analytics he can produce for deans inside the college and leaders of sponsored research projects outside the college will help Penn generate more grants and more work for the lab. Clay said he plans to work with other departments inside the university to explore other projects that can be facilitated by Mendix.