Ingeniería de Sistemas
Permanent URI for this collection
Browse
Recent Submissions
Item Migración de un sistema de información para la administración de las relaciones con los clientes al entorno STACK MERN(Universidad Santiago de Cali, 2024) Romero Gaitán, Daniel Alejandro; López Parra, Jhusef Alfonso; Marín Romero, Franciny; Sanclemente Castro, Jair EnriqueThis research aims to design, construct, deploy, and analyze the performance of an information system for customer relationship management, using the "MEAN" development Stack as a basis and updating it to the "MERN" development Stack due to the high processing rates and algorithmic complexity that come with using tools from the first mentioned stack, such as AngularJS, thereby demonstrating that there are equally attractive alternatives, bringing ReactJS into play. Concurrently, with the business goal of using a coffee shop for the software construction, the use of a web prototype developed through the Personal Software Process (PSP) methodology and performance analysis techniques based on system testing in deployment and locally is proposed. This approach provides a broader and more detailed understanding of the changes made when exchanging technologies in development and optimizing customer relationship management. Similarly, it will allow for the appropriate measurement and control for each software functional requirement. The prototype will enable measurement of the change implied by contrasting two technologies within the same technological field but with different coding structures. This will result in a differentiation in terms of computational performance and software response. The prototype will be deployed in a web environment to facilitate its connection and will allow usability according to the roles provided for users, optimizing space in each of its modules. The analyses generated by this system will focus on providing answers aimed at performance analysis and its differentiation regarding the use of the aforementioned technologies. With this, the aim is to obtain a complete view of the impact and effectiveness of the choice in the development of the CRM system, thus allowing for a more detailed and objective view in terms of technological improvement and user satisfaction, based on an analysis focused on the advantages and disadvantages of the initial tools and the developed target system in questionItem Aplicación web para la predicción del comportamiento de la población vinculada a una compañía de seguros funerarios(Universidad Santiago de Cali, 2020) Solarte Martínez, Omar; Cruz Gómez, Carlos Andrés; Saint Priets, Yana ElidaThe business core of the company Servivir is based on services from the sale of exequial plans. In their rocess, they perform data analysis to: for example, a population concentration was found in three associated entities, which generates a financial risk in the event of understand customer behavior, however, they do not have the specialized tools for data analysis that make the process more efficient and reliable; it’s for this that the idea of building a web application was born that allows data analysis and presents the results through graphic reports. The project was designed under the incremental methodological structure of software development, guidelines and artifacts of the SCRUM methodology were also implemented. The results showed relevant information on the behavior of those associated with Servivirretirement. In the end it is concluded that the application reduces the information analysis times by 99.98%, with what is considered highly functional.Item Gestión de cambios en proyectos de software.(Universidad Santiago de Cali, 2020) Sandoval Llantén, Jhon Fredy; Riascos Satizabal, Erick Mauricio; Ospina Lopez, OrlandoThe purpose of this article is to carry out a bibliographic review about change management as an essential part of a software project. Changes are spontaneous activities that can arise at any stage of the development of a project and can become a challenging process if it is not properly and appropriately managed for said requirement, often generating a risk that may jeopardize the integrity of the project. In terms of cost, time and functionality, it is therefore important to identify, determine, plan, implement and evaluate the different changes that can be surgical in the process. This allowing an organized process to be carried out, which guarantees the user the minimization of errors and the success of the project. In this article we have listed and compared some of the methodologies used today, from which we conclude that for success you need flexibility to change, fast decision making and an optimal communication channel.Item La gestión del riesgo en proyectos de TI(Universidad Santiago de Cali, 2020) Aguiño Cárdenas, Harry; Mejía Hernández, Douglass Noé; Restrepo Castillo, Edgar AlirioThe objective of this article is to carry out a bibliographic review of risk management oriented to information technology (or IT) projects. Companies today are more and more frequent of the great impact that IT-related risks can cause, identifying that different sectors of the economy are frequent victims of failures and attacks on their internal services, significantly affecting their reputation and financial area. Through the management and the exhaustive analysis of the risks, the corporate community is encouraged to implement, in all its projects and ventures, methodologies and good practices related to risk management as a vital process for all their development, and not only as a forgotten stage in the project phases, thus significantly guaranteeing the success rate in all its executions.Item Medición del éxito en proyectos de software: una revisión de criterios y factores(Universidad Santiago de Cali, 2020) Loaiza Quiñonez, Estefann; Ortega Garcia, Kevin Fernando; Loaiza Buitrago, Diego FernandoThis research focuses on presenting the criteria for measuring the success of software projects supported by the review of different research works on what criteria are taken into account when assessing the success of a project according to the area for which it is developed. Through a theoretical and interpretive work, the general parameters for measuring success in projects will be reviewed. The affected parameters will also be reviewed or points that not be taking into account to measure the success of a project. The article is made up of three parts: the first presentation of the basic concepts and in general about what the projects are. The second one talks about the success of the projects and shows the different criteria that are currently in place to measure the success of the projects in general and in the last part some recommendations are given for the measurement of the success of the software project so that all the That you read the article can make better decisions compared to the measurements you make based on the evaluation criteria.Item Sportart: aplicación móvil de inscripción de grupos y consulta noticias de bienestar universitario universidad Santiago de Cali(Universidad Santiago de Cali, 2020) Otero Carabali, Daniel Alejandro; Saint Priets, Yana ElidaThe University Well-being area of the Santiago de Cali University is in charge of supporting the comprehensive training of the student during their stay at the University. As part of this offer there are workshops in different areas: Training Sports, Art and Culture and Promotion and Human Development; that can be taken by the Santiaguina community, however, currently the registration in the groups is done manually. University Welfare has stated that the lack of an information system leads to staff attrition due to the time invested in subsequent digitization, which also introduces errors due to the difficulty in reading to transcribe. In addition, on many occasions the information is not available when it is needed. In accordance with the above, the opportunity to develop a multiplatform mobile application in the Ionic framework was identified to automate and facilitate the registration of users to the services of the University Welfare area, representing an attractive, portable solution adapted to the needs of users. with the integration of new technologies, positively affecting the belonging factor of the new members to the University. In the development of the project, the prototype software methodology was used due to the continuous participation of the app client. The application has a 90% satisfaction rate from users in the consolidated tests, in terms of Usability, design and performance.Item Modelo de evaluación de gobierno electrónico para las alcaldías de los municipios del departamento del valle del cauca – caso de estudio: alcaldía de candelaria.(Universidad Santiago de Cali, 2020) Peña Caicedo, Carlos Fernando; Cuatin Larrahondo, Cristian Fernando; Almeida Delgado, RicardoThe technologies of information and communication (technology ICT) has changed many aspects in the ways of living and acting of people and their organizations. In the home, school, business and even in the fields of Government, where the modernization of public management has required to deliver public goods and services to citizenship, governance and others. So, for today's public organizations is essential the implementation of ICT and particularly digital Governments, since these constitute a basic tool of institutional or business management. Although, according to information from the (DANE, 2017), 40 of the 42 municipalities in Colombia, have electronic Governments that optimize processes and contribute to saving time and resources. However, the use that is given to electronic government, does require a permanent evaluation of these media. By what this study proposes a model of evaluation of eGovernment for the...Item “Desarrollo de una plataforma para la gestión de documentos investigativos de la universidad Santiago de Cali”.(Universidad Santiago de Cali, 2020) Lucumi Mosquera, Christian David; Tavera, Carlos AndrésThis article describes a proposal that allows the management of the products resulting from research at the Universidad Santiago de Cali. The objective is to develop a platform for the management of investigative documents from the Santiago de Cali University. To fulfill it, the methodology: “A Methodology for building the IoT” was implemented. Subsequently, the appropriate activities were carried out to fulfill the six steps of the methodology (Cocreate, IDEATE, Q&A, IOT OSI, Prototype and Deployment). Among the findings, the variety of common and characteristic metadata of each type of research product was identified. Consequently, a database design was defined in which the storage of the metadata of a product was covered by two tables linked by a common identifier.Item Determinación y desarrollo de un concepto de control aplicado a un sistema distribuido para gestión de dispositivos y objetos en espacios mediante iot(Universidad Santiago de Cali, 2020) Mosquera, Christian Andrés; Minotta Rodríguez, Nicolás; Veléz Varela, FernandoIn recent years, the Internet has been a tool that has allowed to place in convergence absolutely everything, what it involves to apply technologies in different scenarios, objects and situations; This has allowed to integrate and give solution of different problematics, which benefit both users like companies. There is the purpose to apply the concept of IoT (Internet of Things), to solve problematics that are presented in the local context; In this process that was addressed, it was built a prototypal model applied to a distributed system, which allows to manage the times that are provided to users who have to share a concept of space and of media using a service or functionality; associating this as an objective, to improve the control of said users, and in turn to ease the work of the managers of said space to improve the service and the business; the example of application of this was done on a skating rink. For this achievement, it was designed a wireless device that was incorporated in each one of the helmets that must to bring the users of the scenario, which is integrated by a hearing device which reports that the time has been requested has finished and a lighting device that notifies the supervisor or manager of said scenario (clue), to identify the users who have this condition. These helmets, are managed by means of a Web platform, since it allows the easy integration of the same, in addition for its usability, in which the can be taken advantage of presence of widgets , with which can be added functionalities, which implies more ease to adapt and operate; The above is thinking about the treatment of the end user. In this document will explain the design and development of the prototype, the impact on the time management of users on the skating rink with the use of the device created.Item Aplicación móvil para promover el deporte en los gimnasios públicos y senderos de Cali, (GymGo! Cali)(Universidad Santiago de Cali, 2019) Salgado Blanco, Wilson Stiven; Vásquez Estrada, Diego Fernando; Zúñiga Cañón, Claudia LilianaThe trails and bioparks are free spaces designed for the use of population in physical activities and welfare; however, there is ignorance of the proper use and location of them. GymGo! Cali is a mobile application to promote recreation and sports, contributing in this way to the improvement of the quality of life of the people of Cali. Through interactive components, GymGo! Cali allows locating and knowing the outdoor spaces arranged by the municipality for recreational and sports activities. The application requires user registration, which includes some basic aspects of their physical condition and provides a series of routines appropriate to the body mass index of each user, accompanied by an instruction for the proper use of exercise machines. Additionally, it has a space for social interaction where you can share training routines, create sports groups or simply interact with people who are close to the user. This application will be free to use and accessible to all citizens who have a smart mobile device with Android operating system, regardless of age and socioeconomic limitations, but taking into account that any physical activity that you make using the instructions. This will be under the responsibility of each user and should always be accompanied by good nutrition and hydration to obtain satisfactory results.Item Software de gestión administrativa de seguridad social para cooperativas de trabajo asociados y empresas afines(Universidad Santiago de Cali, 2019) Valencia Bonilla, Walter; Lozada Gutiérrez, John Jairo; Dinas, SimenaThe Associated Labor Cooperatives (CTA), are defined as “non-profit associative companies, which link the personal work of their associates and their economic contributions for the production of goods, execution of works, or the provision of services in a self-managed way” (Farné, 2008, p, 262). Within the framework of Law 100, they are the means by which independents make contributions to the Comprehensive Social Security System, which is done manually, which generates errors in the individual liquidation of each contributor, such as errors of personal data, double payments for the same user, user payments without receiving the respective advance collection, making user contributions to the wrong EPS and AFP and making payments for greater value or less value. The article consists of the development of an Integral Social Security Management and Administration System for the adequate liquidation of social security contributions called “SISSI” “Information System on Integral Social Security”. The methodology used for the development of “SISSI” is “XP” (Extreme Programming), it is a software development discipline based on simplicity, communication, feedback and continuous refactoring of code, which involves the end and maximum user Group work. Before the implementation of “SISSI” when evaluating 3 companies with a monthly average of 100 affiliated contributors, an average of 13% of errors in individual settlements were presented, generating cost overruns and administrative reprocesses, then reduced the margin of error to 2% in its operations, with a benefit of 92% for the use of the “SISSI”.Item Inteligencia de negocios como apoyo a la gestión del transporte masivo en la ciudad de Cali-Mio(Universidad Santiago de Cali, 2019) Vásquez Ramírez, Neider; Dinas, SimenaOrganizations use technology as a solution to improve efficiency and optimize their operational processes. One of its greatest inefficiencies and opportunities for improvement is hidden in the ability to manage and present the data stored in its databases. Mobility in the city of Cali has as one of its axes the integrated mass transport systems, these systems are applied to a series of means of transport, to move people in short times. They are composed of Mio Cable and Mio. This document describes how through the systems of Business Intelligence and the analysis of large volumes of data in the fields of mass public transport, efficiency in data management and analysis can be improved to make better decisions regarding the operation and service provision. The central focus of the work was to consult various academic articles on the aspects of implementation of a Business Intelligence system in the processes and activities of providing the mass transport service and how to improve their competitiveness to make better decisions through analytical reports, strategic and operational dashboards, designed to visualize and transmit the information to the directives of the entity and users that require it.Item Sistema experto como propuesta de mejora orientado al diagnóstico y reducción de problemas de software y hardware que se presenten en la Cooperativa de Loteros(Universidad Santiago de Cali, 2019) Gil Gutiérrez, José David; Saint-Priest Velásquez, Yana ElidaGenerally, small businesses do not have a technology department that addresses software or hardware problems, causing loss of business continuity; since, having no internal technical support, it takes too long to solve or mitigate these failures. This article presents the implementation of an expert system for the diagnosis and reduction of software and hardware problems in the Cooperativa de Loteros. The use of the Systemap is intuitive and the proposed solutions are conceived from technical support at home to a business technical level. The Buchanan methodology was used to build the system, its phases are: problem selection, construction model, formalization and implementation. The proposed system contains knowledge, information and experiences of the provider that provides the technological devices to the company, to make the diagnostic process efficient and provide solutions. The expert system is integrated into the way small businesses operate, facilitating the identification of problems and the formulation of strategies to reduce the problems that arise, in addition to mitigating the costs associated with specialized external consultancies.Item Modelo de plan de continuidad para un sistema de almacenamiento y comunicación de imágenes diagnósticas(Universidad Santiago de Cali, 2019) Aquite Bedoya, Jorge Armando; Nañez Encalada, Isaac Hernán; Loaiza Buitrago, Diego FernandoCurrently the most efficient and safe way to have control and record large volumes of diagnostic images that are performed in a health institution is through a picture archiving and communication system known as PACS (Picture Archiving and Communication System). Being this a system that is supported in the technological infrastructures, it is necessary to have procedures that allow to continue the normal flow of the operation of the service, preventing or mitigating the adverse events that may occur and also allowing a recovery of the normal state of the operation. These procedures will be consigned in a continuity plan that will be designed based on some of the subprocesses of Risk Management and Continuity Management, both processes from Service Design from ITIL V3. Under this methodology, the risks were evaluated according to their level of impact and probability of occurrence, achieving to develop a more concise plan focused on the containment, management and recovery of an adverse event.Item Transformación Digital aplicando E-Marketing al proceso de ventas de la empresa Mikino Moda Fashion(Universidad Santiago de Cali, 2019) Belalcázar Hurtado, Magda Cecilia; Cubillos Mena, Andrés Felipe; Alzate Sánchez, Juan CamiloThe use of mobile applications has become part of the daily life of people, in this era where digital transformation is necessary for businesses that want to remain in force, as customers who are digital, use their mobile devices every day to see videos, request food or transportation, listen to music, pay bills, etc. In this article, you can find a comparison of other applications of digital electronic commerce (m-commerce) that has become a new economic mode, especially with the increase in online shopping [9]. The agile Scrum methodology was used to obtain the development of a mobile application prototype for the Mikino Moda Fashion store sales process, in the planning phase, which allows the product owner to have a functional version of the product that adds value.Item Desarrollo de una plataforma web para la gestión de proyectos de grado para la Universidad(Universidad Santiago de Cali, 2019) Albarracín Arroyave, Andrés Felipe; Peña Soto, Alejandro; Loaiza Buitrago, Diego FernandoThis Project aims to develop a web platform to management of degree projects taking into account the identified need of the Faculty of Engineering of the University of Santiago de Cali, as it does not have a control or management of the degree workers developed within the program in terms of process agility, evaluation, systematization and automation; therefore, an analysis of the process and current state of the university is executed, obtaining as a result the need to develop software using artifacts from the agile methodology of development "Scrum" that allows to go directly to the fulfillment of the objectives. To do this, comparative tables are initially exposed in which the main characteristics of each of the models / tools are visible and why the software with which the research is carried out is chosen. It also shows the phases of development executed in the program, the advantages, qualities, contributions and developments that the university can access with the use and implementation of the platform.Item Tecnología IOT/IOE y su aplicación en los negocios(Universidad Santiago de Cali, 2019) Castillo Muñoz, Carlos Andrés; Muñoz Bonilla, Iván DaríoItem Diseño de un prototipo para el Control de Acceso y Seguridad usando IoT(Universidad Santiago de Cali, 2019) Gallego Angulo, Larry Jhoan; Tavera Romero, Carlos AndrésThis article presents the prototype design of a system for access control and security using IoT (Internet of Things), taking into account the case study of the Santiago de Cali University laboratory of block 4 floor 3. This design is It consists of a web portal hosted on a web server for administration, two readers, the central and an input module and a web server. The objective was to design a system that allows us to control the entrance and exit of the laboratories through the UUID (universal unique identifier) of the Tag or RFID Card (radio frequency identification), this is consulted from the reader or by the EEPROM memory or in MySQL database. EEPROM memory guarantees the operation of the system, if the reader is not connected to the network to authenticate in the database hosted on the server, the input readers are made with an Arduino card and the central reader with a board Nodemcu; The central reader has nodemcu board and RFID reader, the door reader has an Arduino card, RFID reader, RGB LED, Reset button. The communication of this system is via Wi-Fi, achieving productivity in the execution of the processes. This article will show the operation of the modules connected to the server via Wi-Fi and the input module in the EEPROM, to design the web portal it was necessary to create an Apache server on a Raspberry PI board and, the web portal was programmed with PHP and HTML5, CSS in a Bootstrap 4 Framework to have a Dashboard.Item Aplicación del internet de las cosas (IoT) en la gestión de almacenes - una revisión de nuevas propuestas(Universidad Santiago de Cali, 2019) Morales Sarria, David Felipe; Silva Leal, Jorge AntonioThe Internet of Things (IoT) is a key concept of the fourth industrial revolution and is considered one of the most promising areas for controlling and improving supply chain performance. This manuscript is an exploration of new proposals for Internet of Things applications in warehouse management over the past five years. A review of the academic literature published between 2015 and 2019 was conducted, with the goal of providing a full description of the cumulative state of research on this topic. Warehousing operations were investigated in the context of five main functions: reception, storage, picking, packing, and shipping. Contributions associated with the use of radio frequency identification (RFID) in reception operations and the use and integration of the Warehouse Management System (WMS) for the support of storage activities and optimization of safety conditions and product profiling are noteworthy. Also, proposals related to Automated Guided Vehicle (AVG) and database management systems to minimize search, travel time, and to avoid picking errors, design of automated packaging systems for packing operations, and a tracking system for the delivery of goods in shipping operations, are highlighted as well. Finally, this synthesis reveals that these types of proposals continue to be a topic of interest in research concerning supply chain management, offering reliable bibliographic support that can be used as a starting point in the consultation and formulation of new initiatives for future researchers or professionals in this field.Item Análisis y diseño de sistemas de información para la gestión, seguimiento y control en tiempo real de las ventas realizadas en microempresas(Universidad Santiago de Cali, 2019) Zambrano Castillo, Jhorman Alexis; Loaiza Buitrago, Diego FernandoOne of the main disadvantages for Micro-entrepreneurs is not having a tool that allows them to keep themselves well informed about the fundamental activities of their business in a timely manner, which allows them to make sound decisions that add value to their business. The purpose of this article is to present the analysis and design of an integrated web information system coupled with a mobile application for an application (APP) cell phone and tablet compatible which will allow the entrepreneur to manage, track and control information in real time (24/7); providing management indicators for decision making. To achieve these results, an agile methodology of Scrum projects was used through the process of collecting information pertaining to the needs and new ideas of the small companies, which then was used to design the system. This will ensure that micro-entrepreneurs have immediate access to minute-by-minute information of all critical processes, decrease loss of sales when viewing products to replace, or existing in warehouse, to exercise control over existing inventories, increase sales closing rates through managing potential customer’s point of contact, in addition to having a powerful tool to generate proper reports and queries of vital information of the company