Aplicación web con chatbot para la digitalización de la gestión de tiempo y asistencia laboral en talento humano de la empresa pública Empresa Mercado Mayorista Ambato

Abstract

The manual management of leaves of absence, vacations, and route sheets by the Human Resources area of the Empresa Pública Mercado Mayorista de Ambato (EP-EMA) has generated administrative inconveniences, such as long response times, inflexibility, and difficulties in the storage of information. In order to solve these limitations, a web application was developed to automate these processes, allowing employees to generate requests according to their time availability and in compliance with internal institutional regulations. The solution integrates a chatbot based on natural language processing that guides the user through a chat, and the management, validation and tracking of requests through different user roles. The methodology used was Kanban and technologies such as React for the frontend, FastAPI in Python for the backend, Rasa for the conversational engine and MongoDB as database were used. The requirements were defined and managed according to the guidelines established by the ISO/IEC 29148 standard, ensuring traceability, clarity and verifiability. The tests performed comply with ISO/IEC 25010, evaluating quality characteristics such as efficiency, usability and resource usage. It showed a 79.2% reduction in the average time required to complete a request, a 65% reduction in human errors, and a score of 82.3 on the SUS usability scale. In addition, there was a significant reduction in paper usage and improved access to the process for all staff.