The Caspio Low-Code Platform
All the Tools and Support You Need
Unlimited Users With Every Plan
August 29, 2019
Volunteer State is home to 6.7 million Tennesseans who benefit from comprehensive
programs by the Tennessee Department of Health (TDH).
department runs disease-specific campaigns like its drive against tuberculosis;
conducts health inspections of restaurants, pools and other facilities; handles
the distribution and allocation of thousands of grants; and so much more. TDH operates
in 100 locations in 95 counties and employs over 3,000 nurses, doctors and
of citizens under their care, public servants at the Tennessee Department of
Health have their work cut out for them.
They’re using Caspio’s low-code platform to get the job done.
Schedule a demo to see how Caspio helps the public sector.
volume of citizens and the variety of tasks represent a handful of challenges
for the state’s health agency, particularly when it comes to managing
the public sector, having information silos is not uncommon. But these silos
have a negative impact on the way we provide services,” said Alfredo Ramirez, director
of operations analysis for TDH. He and his team are in charge of identifying
opportunities for improvement within the business side of the department.
Ramirez pointed out that prior to using Caspio, staff “managed” data with various tools, including Microsoft Access databases and Excel spreadsheets. Unsurprisingly, reconciling information proved to be difficult.
“Data was taken from three or four spreadsheets and is being managed by multiple employees. It was difficult and very time-consuming,” he said.
evaluating all their existing processes, Ramirez and his team set a goal: Create
a more integrated workflow across their budget, procurement, accounts and
records management teams.
department also wanted to:
who was brought in specifically to investigate all the information silos that
had appeared across the department, believed he needed help from IT to address their
data management challenges.
IT resources were already dedicated to fulfilling bigger state projects that
directly impact health services.
department then looked at the various options available to them. They evaluated
Microsoft SharePoint and PeopleSoft, an Oracle product used by the state’s
wanted a solution where they can convert
spreadsheets into online databases, as well as migrate
existing MS Access databases to a centralized cloud location. Since IT
would not be building the solution, he also needed a visual application builder
to create web forms and other custom apps without coding.
the end, it was Caspio that checked off all of his requirements.
requirements aside, there’s the budget concern. Most of the vendors they
considered charged on a per-user basis. Since over 3,000 people would be using
the applications, that would require quite a lot of taxpayers’ money.
Thankfully, Caspio’s pricing model allows unlimited users, making it a scalable, cost-effective and worthy investment for TDH.
Using Caspio, Ramirez and his team started building an invoice tracking system. The process was previously managed across multiple spreadsheets and was handled by three or four people. It was the first of many online database applications they created.
also launched a cost allocation and documentation app that tracked millions of
dollars’ worth of hours rendered by local health departments. Another custom-built
application focused on the management and monitoring of thousands of grants which
TDH receives annually.
also developed a sophisticated inventory control system that monitors the
department’s 20,000 assets. The project had been in development with IT for 18 months, costing
the department upwards of $100,000. Using Caspio, the app was completed within
system automates asset assignment, approval workflows, user-level access, email
notifications, and even includes a helpdesk ticketing system. Through the app,
all users receive an email twice a year to reconfirm if they still have the
company’s assets on hand. This gives TDH 97% visibility of their assets.
decision to build on Caspio resulted not only in better data management for the
department, but also cost savings for the state.
“Another way Caspio saved taxpayers’ money can be measured by employee time. For example, work done by eight employees is now performed by just two, thanks to our contract tracking application.”Alfredo RamirezDirector of Operations Analysis, Tennessee Department of Health
“Another way Caspio saved taxpayers’ money can be measured by employee time. For example, work done by eight employees is now performed by just two, thanks to our contract tracking application.”
the end, the agency achieved their goal to centralize data and eliminate information
silos within the department. They also gained visibility into asset, budget and
expenditure information at the granular level they require. They accomplished
all of this without having to take critical IT resources off major healthcare
programs that directly benefit the people of Tennessee.
too can create custom apps without having to write code. Caspio works
with many government agencies
to meet and exceed government compliance requirements.
to streamline operations while ensuring cost efficiency?
Schedule a demo today to learn more on using Caspio for the
Caspio is the world’s leading cloud platform for building online database applications without coding. Start a free trial today and experience the power of no-code.
© 2023 Caspio, Inc. Sunnyvale, California. All rights reserved.