Browsing by Author "Quisaguano Collaguazo, Luis Rene"

Now showing 1 - 2 of 2
  • No Thumbnail Available
    Item
    Sistema Desktop para la gestión de inventarios con analítica de datos y respaldo automático en la nube para la microempresa Jamilter Soluciones Tecnológicas, aplicando la metodología Scrumban
    (Universidad Técnica de Cotopaxi (UTC). Facultad de Ciencias de la Ingeniería y Aplicadas. Sistemas de Información, 2026-10-14) Jami Tercero, Gilson Ariel; Quisaguano Collaguazo, Luis Rene
    This graduation thesis, structured under the research project modality, details the development and implementation of a desktop application for inventory and workshop service management in the microenterprise Jamilter Soluciones Tecnológicas, employing the ScrumBan hybrid agile methodology. This proposal arises to address the deficiencies of the manual operating model based on paper and disjointed spreadsheets, which caused constant stock discrepancies, service delays, and data loss due to local computer hardware failures. With the implementation of the Jamilter FIX system, repair order entries were automated by graphically recording the devices' security lock pattern, and physical stock control was optimized through background visual alerts for minimum safety stock levels. The local SQLite database guarantees the response speed of the Java Swing user interface, while the analytics module with JFreeChart provides statistical reports, and the cloud component stores zip backup copies through the Google Drive API. Experimental statistical validation, carried out through the paired Student's t-test contrast, demonstrated the effectiveness of the solution by registering an average 35.00% reduction in service times of the operational flow, decreasing from 300.00 seconds in the manual method to 195.00 seconds with the implementation of Jamilter FIX. Additionally, the usability evaluation applied to the technical staff showed an outstanding average score of 90.83 points on the SUS scale, consolidating a user experience qualified as excellent and confirming the definitive acceptance of the tool in the workshop's daily environment.
  • No Thumbnail Available
    Item
    Sistema Web de menú virtual con códigos Qr para el registro, seguimiento y cierre de pedidos en el restaurante Freedom Lounge Latacunga aplicando la metodología Lean
    (Universidad Técnica de Cotopaxi (UTC). Facultad de Ciencias de la Ingeniería y Aplicadas. Sistemas de Información, 2026-10-14) Toaquiza Guanochanga, Luis Armando; Quisaguano Collaguazo, Luis Rene
    In this research project, a web-based virtual menu system with QR codes was developed for recording, tracking, and processing orders at the “Freedom Lounge Latacunga” restaurant, applying the Lean Software Development methodology. The research was practical, bibliographic, and field-based, using a mixed-methods approach that combined quantitative and qualitative techniques, drawing on surveys and interviews with customers and restaurant staff, in order to collect data that was analyzed and enabled the identification of the main shortcomings in the traditional order-taking and management process, such as delays in taking orders, communication errors, and a lack of control in order tracking. Based on this part of the research, the virtual menu web system with QR codes was developed as a technological solution to optimize the restaurant’s operational processes. The system was developed using technologies such as Django, Python, Bootstrap, and PostgreSQL, enabling a modern interface that adapts to different devices. The Lean Software Development methodology was applied during the project’s development, which allowed us to optimize processes, eliminate waste, and ensure deliverables focused on the restaurant’s actual needs. The results showed significant improvements in the speed of customer service, a reduction in order errors, and a more efficient and satisfying experience for customers, as validated through the SUS usability scale and a one-sample t-test.