The client is a food and beverage manufacturing company and is the creative culinary force behind retail brands such as Panera and Legal Sea Foods. They run a chain of outlets across the United States of America. They are headquartered in Massachusetts, with production facilities in Texas and Oregon.
The client used an incident management application to capture injury and incident data across their production and safety teams. These teams use different form types to track their respective data. However, they soon realized their current incident access database had limitations, with storage and visibility issues hampering accurate metrics. As a result, they sought to replace it with a centralized web-based tool that captures injury and incident data making it easier to share with the Blount management team. The client also wanted to ensure these records were reliably secured in a data warehouse which would allow for enterprise analytics. Challenges identified:
PreludeSys experts devised a simple, automated incident management process. The team analyzed the client’s needs and designed a Canvas Power Apps application that helps production and safety teams create forms based on the nature of their work and safety guidelines. With this application, users from multiple facilities can log in, select their facility and input the required information. The data is stored in a centralized SQL Server database and because of that, the incident management system now facilitates enterprise analytics. This encouraged them to track employee well-being and ensure a safe and healthy workplace. The Power Apps application securely stores all the incident reports and enables access to view, edit and delete. The solution included: