Trabajos de Titulación - Ingeniería de software
URI permanente para esta colecciónhttps://dspace.ucacue.edu.ec/handle/ucacue/45
Examinar
Envíos recientes
Ítem Acceso Abierto Desarrollo del backend para un sistema de automatización de la gestión de proyectos de vinculación en la universidad católica de cuenca utilizando metodologías ágiles e inteligencia artificial(Universidad Católica de Cuenca., 2025) Guaicha Vásquez, Kevin Oswaldo; Cuenca, Juan Pablo; 0105886949This research presents the development of a backend that automates the management of outreach projects at the Catholic University of Cuenca. The platform takes the information requested by the institutional format F-VS-41, verifies budgetary coherence, and generates the official Word document using dynamic templates and HTML blocks via the altChunk technique. Annexes are stored centrally in AWS S3, and natural language queries are resolved with Oracle Select AI on controlled views in Oracle Autonomous Database, preventing users from having to manually review the entire document. The system's structure followed a hybrid methodology based on Scrum and complemented by elements of the Rational Unified Process (RUP). It was developed in eight sprints covering authentication with JWT, persistence with JPA, dynamic document generation, attachment management, and artificial intelligence integration. Requirements engineering and solution evaluation were supported by the FURPS+ model. Functional (Postman) and load (JMeter) tests with 100 and 200 concurrent users demonstrated acceptable performance within the environment's limitations. In individual measurements, authentication operations (registration and login) respond in the order of hundreds of milliseconds; under sustained load, latency can increase to a few seconds due to the use of free versions of the database, S3, and the deployment platform. The generation of the F VS 41 document varies around 20–30 s when simulating 100 users and approaches 50 s with 200 users. Despite this, test coverage reaches 82%, and no discrepancies were observed between the amounts stored and those reflected in the final file. The developed system eliminates transcription errors, prevents rework, and accelerates the creation of the F VS 41, while also establishing a scalable foundation for incorporating extensions such as electronic signatures, a web interface, and social impact analytics. This automation contributes to strengthening traceability and transparency in the management of outreach projects, allowing for the demonstration, with verifiable data, of the social relevance of university initiatives.Ítem Acceso Abierto Plataforma web para monitoreo y visualización de parámetros ambientales en café mediante sensores IoT(Universidad Católica de Cuenca., 2025) Cedillo Illescas, Ángel Ariel; Encalada Arévalo, María Mercedes; Pazmiño Piedra, Juan Pablo; 015009736; 0104903950The main objective of this study was to design and develop a web platform for real-time monitoring of air and soil parameters in coffee plantations. The research was carried out at Hacienda La Papaya, Saraguro, Ecuador. The software development methodology used was SCRUM, which is oriented to the creation of fast and adaptable solutions to change. For data collection, an IoT sensor network was implemented using LoRa e32 modules that allowed wireless communication over long distances in areas without internet. The sensors used were: RS485 for the soil (measuring NPK, humidity, temperature, salinity, conductivity, and pH variables) and AM2302 for the air (temperature and humidity). An HLK-RM08 gateway was used for data transmission. For data processing, a backend was structured in Node.js, in charge of receiving and validating the data coming from the sensors and then storing them in the PostgreSQL database. For the visualization of real-time information, Grafana was used to create interactive panels,which allowed a more in-depth analysis of the data. The results obtained demonstrated the functionality and reliability of the platform, the processing and data storage capacity was validated for the end users' needs, which was 500 readings/hour, with a latency of less than one minute in the dashboard. This solution was validated as a viable and low-cost tool that optimizes agronomic management, thus boosting agriculture and creating a base from which it can be expanded with the implementation of predictive modules, georeferencing, and even artificial intelligence.Ítem Embargo Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca., 2025) Solano Arpi, Danny Steven; Barbecho Pineda, Robinson Josué; Gaona Pineda, Jheyson Steven; 0107831562; 0105307961Ítem Embargo Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca., 2025) Guillermo Benavides, Eddison Steven; Quevedo Sacoto, Sebastián; 0107266488Ítem Acceso Abierto Desarrollo de una aplicación móvil para el control de un robot autónomo que resuelve cubos Rubik 3x3 utilizando impresión 3D y algoritmos de visión computacional(Universidad Católica de Cuenca., 2025) López Rojas, Boris Adrián; Pazmiño Piedra, Juan PabloCurrently, many technological advancements are reaching their peak objectives: to simplify human life, solve problems, and provide insights into their use and benefits in an increasingly automated society. For example, we undertook this project to address the lack of capabilities in individuals with disabilities, whether related to learning or their extremities; that is, the inability to perform movements requiring motor assistance, such as the fingers when solving a 3x3 Rubik's Cube. To that end, we chose to develop this prototype using the V-Model + SCRUM methodology, with results considered correct when the device is used to solve our 3x3 Rubik's Cube. Our objective is to get feedback from the users, including those with disabilities such as missing limbs or other setbacks that prevent them from fully completing the Rubik's Cube puzzle, resulting in a solved Rubik's Cube by simply placing it in the prototype in front of a webcam and pressing a button.Ítem Acceso Abierto Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca., 2025) Ponce Morocho, Mauricio José; Sañay Sañay , Segundo Isael; 0107064248Ítem Acceso Abierto Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca., 2025) Pesantez Alvarado, María Cristina; Cajamarca Criollo, Olger Antonio; 0302016720Ítem Acceso Abierto Proyecto de Titulación embargado con fines de publicación de impacto(Universidad Católica de Cuenca., 2025) Morocho Yunga, Luis Esteban; Poma Japón, Diana Ximena; 0106544018Ítem Acceso Abierto Prototipo de arquitectura de microservicios para sistemas transaccionales financieros con keycloak(Universidad Católica de Cuenca., 2025) Santacruz Erraez, Luis Fernando; Poma Japón, Diana Ximena; 0107024259In a financial environment where security, scalability, and regulatory compliance are essential, an advanced microservices architecture prototype is presented, designed to enhance the efficiency and resilience of transactional systems. The proposed solution integrates Spring Boot, Spring Cloud, Eureka, Keycloak, and Docker, enabling centralized authentication, load balancing, and high availability, with a scalable approach based on inheritance and efficient load distribution. Given the growing demands of the financial sector, such as low latency, high resilience, and the need for compliance with current international regulations (ISO 27001, PCI DSS, Fintech Law), the study introduces a modular infrastructure with an API Gateway based on Spring Cloud, ensuring interoperability with traditional banking systems through REST, gRPC, and WebSockets protocols. Performance and security tests validated the system’s efficiency, achieving response times below 100 ms in critical transactions, secure authentication via OAuth2 and MFA, and centralized monitoring using Spring Boot Admin. The architecture demonstrated the ability to handle up to one million daily transactions without degradation, ensuring its suitability for high-traffic financial environments. This study confirms that a well-structured microservices architecture provides greater flexibility, security, and scalability than monolithic systems. Its implementation in digital banking and fintech ecosystems can enhance user experience, reduce operational costs, and strengthen financial cybersecurity, ensuring seamless adaptation to evolving regulations and emerging technologies.Ítem Embargo Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca., 2025) Mora Cabrera, David Esteban; Sañay Sañay, Segundo Isael; 0105599385Ítem Embargo Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca., 2025) Argudo Piedra, Miguel Ángel; Campoverde Molina, Milton Alfredo; 0104801030Ítem Embargo Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca. Unidad Académica De Informática, Ciencias De La Computación E Innovación Tecnológica, 2025-02-19) Valladarez Briones, Carlos Alberto; Sañay Sañay , Segundo Isael; 0105599385Ítem Embargo Proyecto de Titulación embargado con fines de publicación de impacto(Universidad Católica de Cuenca., 2025-02-07) Sagbay Samaniego, Bryan Stalin; Quevedo Sacoto, Andrés Sebastián; 0106098981Ítem Acceso Abierto Software de monitoreo y control de flujo de personas en tiempo real con IA y visión computacional.(Universidad Católica de Cuenca., 2024) Loaiza Barrios, Segundo Isael; Sañay Sañay, Segundo Isael; 1104475346This document presents the development structure of a "real-time monitoring and control system for people flow using artificial intelligence and computer vision." Designed for a furniture company, this system enhances the efficiency, safety, and optimization of commercial spaces, surpassing manual counting methods. The project employs the FURPS+ model to thoroughly evaluate the requirements (Araujo Sandoval, 2020; Yungan Gualli et al., 2019) and follows the Unified Process for iterative development (Sumano, 2012; Hernández González, 2017). Technologies such as Python, OpenCV, PyTorch, and Laravel are essential for its implementation (Itseez, 2018; Paszke et al., 2019; Otwell, 2020). The project results show a minimal difference compared to manual counting, with an error margin between 0.97% and 22.39%. It supports each detection with images and segments by age and gender, providing valuable data for strategic decision-making.Ítem Acceso Abierto Desarrollo de un sitio web para la gestión de cobranzas de la cooperativa de producción y mercadeo SBE de la ciudad de Cuenca(Universidad Católica de Cuenca., 2024) Zhunaula Lucero, Michelle Andrea; Campoverde Molina, Milton Alfredo; 0107417875In the production and marketing cooperative Señor de la Buena Esperanza (SBE) in Cuenca, Ecuador, collection processes and data processing are carried out manually. Therefore, this research aims to develop a website for managing collections and printing receipts using the programming languages PHP, JavaScript, and the RawBT API. The methodology used was SCRUM with two-week sprints and a client-server architecture. The results present the product backlog, the elicitation of functional and non-functional requirements, the MySQL database design, and the programming stage of the various forms. Also, the implementation of the website in hosting is presented, and the usability tests are performed over three weeks, continuing with the modification of the necessary components and ending with the training of the users. Finally, it is concluded that the website reduces the time spent on collections and doubles the number of collections.Ítem Acceso Abierto Desarrollo de un sitio web que sistematice el proceso de ventas de las joyerías en Chordeleg. Caso estudio joyería LOFAR.(Universidad Católica de Cuenca., 2024) Bravo Soria, Iván Fernando; López Farfán, Bryam Mateo; Poma Japon, Diana Ximena; 0104738703; 0104902531Digital transformation is the path that small and medium-sized enterprises are considering to maintain competitiveness. Implementing a digital platform that allows the jewelry sector in Chordeleg, Azuay province, to have an online presence is feasible. A study was conducted through targeted surveys separately administered to both customers and business managers, gathering 32 responses from managers and 29 from users. For the analysis of the responses, the statistical software SPSS was used. Given that the sample size obtained for both groups was less than 50, the Shapiro-Wilk test was conducted to identify parametric and non-parametric data. Additionally, the reliability of the responses was evaluated using Cronbach's Alpha coefficient, which revealed that one question directed at customers and two questions directed at administrators scored below 0.729, confirming that the remaining five questions are reliable. This process revealed that 75% of jewelry store managers in this sector are interested in showcasing their products online, and 80% of customers believe that buying jewelry online allows them to view the entire catalog and facilitates easy purchasing. Therefore, this article presents the development of a website that systematizes the sales process for jewelry stores in Chordeleg. As a case study, "La Joyería Lofar" was considered. The objective is to design and develop a website that informs, communicates, and sells the variety of products offered by the jewelry store. The waterfall methodology, consisting of four phases, was used for this purpose: 1. Requirements Stage, 2. Design Stage, 3. Development Stage, 4. Implementation and Testing Stage. After developing the site, several tests were conducted for usability, performance, maintainability, and portability. As a result, the website is expected to enable the artisan jewelers, who have their small and medium-sized enterprises in Chordeleg, to offer, market, and sell their products online.Ítem Acceso Abierto Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca., 2024) Orellana Guamán, Juan Pablo; Quevedo Sacoto, Andrés Sebastián; 0105435457Ítem Acceso Abierto Proyecto de Titulación embargado con fines de publicación de impacto.(Universidad Católica de Cuenca., 2024) Álvarez Sarmiento, Pedro Fernando; Quevedo Sacoto, Andrés Sebastián; 0106620222Ítem Acceso Abierto Dinámica y flujo de información de redes complejas a través del análisis de su modularidad(Universidad Católica de Cuenca., 2024) Portilla Portilla, Felipe Santiago; Moscoso Bernal , Santiago; 01500273670This project compared several methodologies for analyzing the structure of various ecological and institutional networks by creating modules or groups to study complex network communities. This was done by applying these methods in the Spyder tool and the Python programming language. From this process, the graphs of each network were obtained with a customized presentation to differentiate communities and nodes. Additionally, with the data acquired from implementing these methodologies, it was possible to mention each network's best and worst node clustering methods. This was done by presenting the results in a series of tables showing various values of the network structure. Finally, a series of recommendations were made regarding the issue of community creation methods and their use and the link between the data types to be subjected to structural processes and analysis due to the discussion generated from the results obtained and the comparison with other works.Ítem Acceso Abierto Implementación de un sistema de inventario para la empresa trompo-mobiliario infantil(Universidad Católica de Cuenca., 2024) Largo Anguisaca , Alex Paúl; Japón, Diana Ximena; 0107088569In the dynamic furniture market, operational efficiency is the driving force behind competitiveness. In this context, Trompo-Mobiliario Infantil took the initiative to implement an inventory system that will enhance its ability to meet operational challenges and stay at the forefront of the industry. The imperative need to optimize asset and product management led Trompo-Mobiliario Infantil to seek technological solutions. The lack of visibility and control over inventory levels generated shortages and lost sales opportunities. Therefore, the objective of this project is to optimize product and asset management by implementing an "Inventory System" based on modern software tools. This system will be designed with the purpose of improving operational efficiency in the management of its resources, allowing detailed tracking of products in stock, inventory movements and asset status. With this solution, the company will be able to manage its inventory more effectively, optimizing processes and ensuring better control of its resources, which will result in a significant improvement in its operations and competitiveness in the market. The methodology adopted was based on a waterfall development approach, covering crucial stages such as requirements analysis, database design, system architecture, system development and implementation. Each phase was carried out with precision and following recognized guidelines in software development, from the identification of requirements to the deployment of the system in production. In the development of the system, modern tools and technologies were used. In the Backend, the hexagonal architecture pattern was adopted with Nest.js and Node.js, while the Frontend was built with Flutter and Dart, allowing a multiplatform application. The choice of MongoDB as the database management system was based on its adaptability and flexibility, fundamental for a dynamic business environment. The results obtained reveal the innovation in the inventory management of Trompo-Mobiliario Infantil. Functional and non-functional requirements were identified and effectively addressed, allowing for everything from product and customer registration to an informative dashboard. The designed database supports the functionality of the system, and the implemented architecture guarantees flexibility and scalability. The Backend and Frontend, developed with advanced architectural patterns, provide an intuitive interface and an efficient user experience. After the implementation of the inventory system, an exhaustive evaluation was carried out through manual and user tests to validate its operation. Ten representative users from different areas of the company participated. User interface, functionality and security tests were conducted to ensure consistency, efficiency and data protection. Subsequently, the focus was on ongoing maintenance of the system, with iterative improvements based on user feedback. These improvements were made in response to the needs and difficulties reported by users, thus ensuring a stable and satisfactory system that met quality standards and user expectations. This article provides a complete overview of the process undertaken, starting from the identification of the need to optimize product and asset management in the children's furniture market, to the successful implementation of an inventory system designed with this purpose in mind. The different stages of the implementation process are detailed, including the evaluation of the system through manual and user testing, as well as the focus on ongoing maintenance to ensure optimal performance.
- «
- 1 (current)
- 2
- 3
- »
