Browsing by Author "Alvear Alvear, Oscar Patricio"

Now showing 1 - 14 of 14

a discretized approach to air pollution monitoring using uav-based sensing
(2018) Alvear Alvear, Oscar Patricio
Recently, Unmanned Aerial Vehicles (UAVs) have become a cheap alternative to sense pollution values in a certain area due to their flexibility and ability to carry small sensing units. In a previous work, we proposed a solution, called Pollution-driven UAV Control (PdUC), to allow UAVs to autonomously trace pollutant sources, and monitor air quality in the surrounding area. However, despite operational, we found that the proposed solution consumed excessive time, especially when considering the battery lifetime of current multi-rotor UAVs. In this paper, we have improved our previously proposed solution by adopting a space discretization technique. Discretization is one of the most efficient mathematical approaches to optimize a system by transforming a continuous domain into its discrete counterpart. The improvement proposed in this paper, called PdUC-Discretized (PdUC-D), consists of an optimization whereby UAVs only move between the central tile positions of a discretized space, avoiding monitoring locations separated by small distances, and whose actual differences in terms of air quality are barely noticeable. We also analyze the impact of varying the tile size on the overall process, showing that smaller tile sizes offer high accuracy at the cost of an increased flight time. Taking into account the obtained results, we consider that a tile size of 100 Ã— 100 meters offers an adequate trade-off between flight time and monitoring accuracy. Experimental results show that PdUC-D drastically reduces the convergence time compared to the original PdUC proposal without loss of accuracy, and it also increases the performance gap with standard mobility patterns such as Spiral and Billiard. Â© 2018, Springer Science+Business Media, LLC, part of Springer Nature.
Análisis de impacto de la implementación de indicadores en el desempeño y calidad del desarrollo ágil de software en la industria de Retail
(Universidad de Cuenca, 2021-12-10) Arias Zhañay, María Belén; Alvear Alvear, Oscar Patricio
The activities that are generated in the retailers use technology to automate and enhance the sales and distribution processes. This is why the need for custom software development is presented by the IT area to meet the requirements of the different areas. Under this context, the managements are forced to invest in IT development. The analysis of the software development process of the IT area of a retail identified high delivery times and low quality of the requirements, generating a bad perception on the part of the other retail areas. Based on this, this project proposes the implementation of performance control indicators of the software development process in the Information Technology (IT) area of a retail. For this, SCRUM was implemented as an agile development methodology, Cycle time for the continuous improvement of the process and Balanced Scorecard (BSC) as its control methodology. After the implementation and stabilization stage of the proposed methodology, there was evidence of a change from 74.27% to 81.82% in the average attention to requirements, this with a growth of 7.55%. Also, the customer satisfaction rate increased from 65.10% to 92.56%. Regarding the cycle time of the software development process in average days, it was realized that it decreased from 50.86 days to 48.88 days. The requirements quality rate rose from 68.30% to 91.90%. Under this context, the notable improvement in the software development process is determined by implementing these indicators that allow continuous improvement of the IT area.
Análisis del resultado de la implementación de SCRUM, LEAN Y BSC en el proceso de desarrollo de software en la industria del Retail
(2022) Alvear Alvear, Oscar Patricio
The objective of this article is the analysis of the implementation of performance control indicators of the software development process of the Information Technology area of retail X. For this, SCRUM was implemented as an agile development methodology, Lead Time for continuous improvement of the process and Balanced Scorecard as a methodology for continuous improvement. After the stage of implementation and stabilization of the proposed methodology, a growth of 7.55% was evidenced in the average requirement attention. Likewise, customer satisfaction reached 92.56%. As for the Lead Time of the software development process in average days, it decreased by 2.42 days. The quality part of the requirements reached a rate of 91.90%. Under this context, the notable improvement in the software development process is determined by implementing these indicators that allow the continuous improvement of the Information Technology area.
Desarrollo de un prototipo de solución de business intelligence para la consulta externa del Hospital Humanitario
(Universidad de Cuenca, 2023-03-17) Orellana Bravo, Aida Karina; Alvear Alvear, Oscar Patricio
The Humanitarian Hospital - Fundación Pablo Jaramillo Crespo is a private, non-profit institution that, together with companies such as Indurama and Marcimex, belongs to the Consenso business group; and orients its health care benefits, as a priority, to low-income people, for which it provides medical services at affordable prices. This document details how a Business Intelligence system was implemented for the outpatient area of the Pablo Jaramillo Humanitarian Hospital, in order to better manage the productivity indicator; which is currently prepared manually and can only be viewed when the month has ended, requesting a report in spreadsheets to start its tabulation. The productivity indicator is specific to the Humanitarian Hospital and is used to refer to the number of patients treated over a period of time, by specialty and doctor. The purpose of the business intelligence system to be developed will be the daily and automatic update of the information necessary to obtain this indicator and present it graphically, on a specialized data analysis tool. In this way, timely monitoring and control of the care that doctors provide to patients can be given. In the theoretical framework, a description of the basic concepts used in this document was made, as well as an investigation of what is currently documented about the use of business intelligence related to the management of health homes. The implementation carried out is detailed and the results and improvements that it represents in the management of the area are validated, the main benefits being the elimination of the time required to obtain the results of the indicator, the rapid analysis of the indicator and the great variety of information obtained. from a single board.
Elaboración de un manual de procesos para el departamento de producción de la empresa Gráficas y Suministros Grafisum Cía. Ltda.
(Universidad de Cuenca, 2021-08-19) Espinoza Guamán, Richard Gabriel; Alvear Alvear, Oscar Patricio
The production department of the company Gráficas y Suministros Grafisum, has not defined the business processes to perform internal activities, so these are performed empirically, without a specific order and omitting important steps or tasks in each process. This problem has existed since the company started operations, generating communication problems, lack of coordination among its collaborators, inefficiencies in daily production, defective work, and material waste. Consequently, this degree project proposes the development of a process manual for the production department of the company, to reduce the errors and problems diagnosed in each of the procedures involved in this area of the organization. The development of this integrative project includes four chapters that encompass all the topics to be developed. The first chapter includes the background of the work and general information about the company. In the second chapter, a bibliographic review is carried out to elaborate a theoretical framework with information regarding BPM Methodology, BPMN Notation, and Process Manuals. The third chapter is based on the explanation of the methods and techniques used in this project for the information gathering and elaboration of the process manual. The fourth chapter shows the development of the work, obtaining as main result the elaboration of the process manual for the production department of the company. Finally, the fifth chapter summarizes the conclusions and recommendations of the study.
Envisioning the Future of Emergency Management focused on Artificial Intelligence
(ISCRAM, 2024) Alvear Alvear, Oscar Patricio; Núñez Ávila, Ana Gabriela; Parra González, Luis Otto; Núñez Ávila, Ana Gabriela
Artificial Intelligence (AI) in Emergency Management integration has become crucial to improving crisis response efficiency and effectiveness. AI presents new paradigms for responding to emergencies but poses technical and operational challenges, ethical considerations, and the need for robust regulatory frameworks. The study examines various AI applications in emergency scenarios and employs a systematic literature review methodology to identify solutions and future directions for ethical and effective AI integration. The findings highlight the critical balance between leveraging AI capabilities and ensuring safety, privacy, and ethical compliance. Understanding AI's full scope and potential in this critical field is essential as we navigate technological advancements. The article contributes to understanding AI's potential to transform emergency management practices and emphasizes the importance of ethical considerations and regulatory frameworks.
Estudio de la factibilidad de plataformas Low-Code/No-Code en Pymes de Cuenca para la digitalización de procesos administrativos y análisis de datos
(Universidad de Cuenca, 2025-09-24) Muñoz Tufiño, Steven Marcelo; Peñaloza Espinoza, Guido Alexander; Alvear Alvear, Oscar Patricio
This study analyzes the feasibility and impact of Low-Code/No-Code platforms on the digitalization of administrative processes and data analysis in SMEs in Cuenca, Ecuador. Through a literature review, structured interviews, and a case study at the University of Cuenca, the main challenges, needs, and opportunities for technology adoption in local microenterprises and SMEs are identified. The results show that although there is interest in digitalization, barriers such as limited resources, lack of technical knowledge, and absence of clear strategies still persist. Low-Code/No-Code platforms emerge as a viable alternative to overcome these limitations, enabling the agile development of customized solutions, task automation, and data integration without requiring significant investments. The case study demonstrates that, through the use of these tools, it was possible to implement a solution for inventory data entry and visualization in an institutional environment, facilitating report generation and data-driven decision-making, which contributed to improved efficiency and transparency. It is concluded that the adoption of Low-Code/No-Code technologies can accelerate the digital transformation of SMEs, provided it is accompanied by training, support, and proper change management. Finally, recommendations are proposed to strengthen the digital culture and ensure the sustainability of the implemented solutions.
PdUC-D: a discretized UAV guidance system for air pollution monitoring tasks
(Springer Verlag, 2018) Alvear Alvear, Oscar Patricio; Calafate, Carlos; Zema, Nicola Roberto; Natalizio, Enrico; Alvear Alvear, Oscar Patricio
Discretization is one of the most efficient mathematical approaches to simplify (optimize) a system by transforming a continuous domain into its discrete counterpart. In this paper, by adopting space discretization, we have modified the previously proposed solution called PdUC (Pollution-driven UAV Control), which is a protocol designed to guide UAVs that monitor air quality in a specific area by focusing on the most polluted areas. The improvement proposed in this paper, called PdUC-D, consists of an optimization whereby UAVs only move between the central tile positions of a discretized space, avoiding to monitor locations separated by small distances, and whose actual differences in terms of air quality are barely noticeable. Experimental results show that PdUC-D drastically reduces convergence time compared to the original PdUC proposal without loss of accuracy. © ICST Institute for Computer Sciences, Social Informatics and Telecommunications Engineering 2018.
Propuesta de actualización y digitalización del proceso de pagos, aplicado a la Intendencia de Contabilidad de la Empresa Eléctrica Regional Centro Sur C.A.
(Universidad de Cuenca. Facultad de Ciencias Económicas y Administrativas, 2025-10-02) Muso Vega, Jordan Patricio; Vivar Peñafiel, Daniela Paola; Alvear Alvear, Oscar Patricio
This integrative project aims to update and digitize the payment process of the Accounting Department of Empresa Eléctrica Regional Centro Sur C.A., through the design of a comprehensive proposal aimed at its modernization and subsequent digital transformation, framed within a technical evaluation of the current internal control system. The study will begin with an analysis of various operational issues that hinder process efficiency, such as staff workload and the absence of technological tools for document validation. To overcome these limitations, the application of the Business Process Management (BPM) methodology will be proposed, supported by the Bizagi tool. This approach will enable the modeling and structuring of workflows, strengthen information traceability, and ensure regulatory compliance within the public sector context. Furthermore, a pilot evaluation of the entity’s internal control system will be carried out to allow a deeper analysis and to identify specific opportunities for improvement.
Propuesta de estandarización del proceso productivo de brownies y trufas en la empresa Dulco Dulce Compañía Cía. Ltda.
(Universidad de Cuenca, 2025-09-29) Bernal Aucapiña, Jessenia de los Ángeles; Sarango Armijos, Nancy Lizbeth; Alvear Alvear, Oscar Patricio
Dulco Dulce faces variability in quality, timing, and efficiency due to a lack of standardized processes. The purpose of this research was to propose a standardization of the production process for brownies and truffles at Dulco Dulce Compañía CA. Ltda., implementing Business Process Management (BPM) techniques and process modeling tools. To this end, a time study, direct observation, and interviews with production staff were used to collect information on the processes. This revealed bottlenecks in cooling and baking. The diagnosis identified the cooling and baking of brownies as the main bottlenecks, affecting the continuity of the process. Standardization and automation through BPMN are proposed, optimizing critical phases and reducing production times by 25% to 30%, improving efficiency, quality, and response to demand. Performance indicators were proposed to evaluate efficiency, downtime, defects, production compliance, and variability in key processes. Monitoring these indicators will ensure sustainable improvements in time, cost, and quality.
Propuesta de manual de procesos para el departamento de producción de hacienda cucaracha, dentro del periodo 2020-2021, basado en la metodología BPM (Business Process Management)
(Universidad de Cuenca, 2021-10-13) Coronel Solís, Celso David; Alvear Alvear, Oscar Patricio
The Production Department of Hacienda Cucaracha has a problem caused by poor performance of activities by workers in the area. Unfortunately, this problem has been an issue for several years and no alternatives have been proposed to correct it. For this reason, this work raises the proposal of a Process Manual, based on the BPM Methodology (Business Process Management) to establish an operational guide, where all the activities, policies, documents, instructions and those responsible for the execution of the different production processes. In this way, prevent workers from continuing to make mistakes due to ignorance of any of the aforementioned topics. In this project, the objectives are first established that will allow setting the path to where you want to go, to solve the problem. Subsequently, in order to have the necessary knowledge of the subject to be discussed, a bibliographic research was carried out; which serves as the basis to constitute the theoretical framework. For this section, aspects related to Process Manuals and the BPM Methodology were mainly considered. Third, as a research and information gathering method, the BPM Methodology was used, with it the competent processes for animal production were raised, managing to identify shortcomings and their alternative solutions. Finally, based on the results obtained, the proposal for the Process Manual for the Production Department of Hacienda Cucaracha was prepared.
Propuesta de manual de procesos para las Unidades de Presupuesto, Contabilidad, Tesorería y Control Interno de la Dirección Financiera de la Universidad de Cuenca con base en la metodología Business Process Management
(Universidad de Cuenca, 2024-07-31) Pineda Carrión, Kevin Eduardo; Alvear Alvear, Oscar Patricio
Universities are structured as organizations that develop within a complex social environment, whose relationship is transversal both internally and externally, i.e. the elements that integrate it interact, change and adjust to the needs of other elements so that the whole system works together. In this sense, the University of Cuenca must continuously evaluate its performance and identify the areas that require improvement based on strategic objectives. To this end, the present work proposes a process manual for the Financial Management that follows three phases. The first consists of characterizing the processes and the macro-process based on unstructured interviews applied to the collaborators of this area, information recorded by means of characterization sheets with their respective objectives, scope, inputs and outputs of each process. The next stage involves detailing the processes and sub-processes through mapping and standardization. Finally, the Bizagi tool is used for process modeling and compliance with the BPM nomenclature. The financial management macro-process is thus established, consisting of 52 processes and sub-processes framed in budget, treasury and accounting management.
Rediseño de procesos en los departamentos de producción, empaque y ventas de la empresa Géneros Ecuatorianos Ecuagenera Cía. Ltda., basado en la metodología BPM (Business Process Management)
(Universidad de Cuenca, 2023-06-23) Lituma Ramón, Jessica Aracely; Seminario Urgiles, Ariana Daniela; Alvear Alvear, Oscar Patricio
In this integrative project, a proposal was made to redesign critical processes belonging to the production, packaging, and sales departments of the Ecuadorian Géneros Ecuatorianos Ecuagenera company. Currently, the company does not have a business process management system in place, which has made it difficult for employees to execute processes efficiently, leading to waste of resources, operational errors, and incorrect information management, thus complicating decision-making and continuous process improvement. Thus, the first four stages of the Business Process Management methodology were implemented, which involved identifying, discovering, analyzing, and redesigning processes. Through techniques such as observation, interviews with employees and department heads, data gathering, analysis, and evaluation, the processes were modelled "as is" and problems and opportunities were identified that contributed to the proposal's development. Following this, the seven critical processes on which the redesign was focused were identified and analyzed, focusing on the digitalization and optimization of activities, resulting in improved times, formats, and activities. Finally, a proposal for a Processes Manual was designed for the departments under study, aiming to standardize the processes and contribute to their proper execution.
Un prototipo de business intelligence para consulta externa del Hospital Humanitario
(2022) Orellana Bravo, Aida Karina; Alvear Alvear, Oscar Patricio
This article explains the implementation of a Business Intelligence system to manage the productivity indicator of the outpatient area of the Pablo Jaramillo Humanitarian Hospital, which is part of a corporate group of companies. The productivity indicator refers to the number of patients seen in consultation in a period of time, by specialty and doctor. Currently the indicator is generated manually and only when the month ends and for this a flat report is requested that has to be tabulated in spreadsheets. To solve this problem, a Business Intelligence system was created that daily and automatically updates the information required to feed this indicator and is presented in a specialized tool for BI with information cut off the previous day. The implementation was carried out using its own methodology and the official tools of the group were used. After implementation, the results and benefits they represent for the hospital are validated, both in terms of delivery time and in resources used prior to and after implementation. The main benefits are: the elimination of the time required to obtain the indicator results, the rapid analysis of the indicators and the great variety of information obtained from a single dashboard