Browsing by Author "Cordero Saquinga, Christian Marcelo"

Now showing 1 - 1 of 1
  • No Thumbnail Available
    Item
    Diseño de un sistema automatizado para el control y seguimiento de vacunación en mascotas
    (Universidad Técnica de Cotopaxi (UTC). Ciencias de la Ingeniería y Aplicadas. Industrial, 2026-10-14) Berrazueta Salguero, Andres Sebastián; Cordero Saquinga, Christian Marcelo; Andrango Guayasamín, Raúl Heriberto
    This research addresses the operational inefficiency in monitoring and tracking vaccination schedules at the Sira Pets veterinary clinic (Rumiñahui canton), caused by manual processes that lead to appointment absenteeism and administrative overload. The main objective was to design an automated system for comprehensive vaccination management. The methodology applied a mixed-methods approach with a descriptive-propose scope under the Kaizen philosophy, executed in three stages: process diagnosis, software architecture design, and validation through a functional prototype. The diagnosis revealed a 36% dissatisfaction rate regarding record updates and a notification coverage of only 30%. To solve this issue, a Python web application was developed using Streamlit, structured into three layers (operational, analytical, and predictive). The tool integrated transactional data processing with an interactive notification module via Gmail SMTP, an immutable accounting stock registry, and a Random Forest predictive model ($k=5$) to estimate the risk of non-compliance with the vaccination schedule. The pilot test demonstrated that the system reduces reminder management time from 3–5 minutes to under 5 seconds per transaction, achieving 100% coverage for patients due within 30 days. Additionally, the predictive model reached an overall accuracy of 83%, operating as a Decision Support System (DSS) for the veterinary staff. In conclusion, automation optimizes sanitary traceability, enhances customer service, and eliminates manual data entry errors without incurring software licensing costs.