Ingeniería de Sistemas
Permanent URI for this collection
Browse
Browsing Ingeniería de Sistemas by Title
Now showing 1 - 20 of 40
Results Per Page
Sort Options
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 companyItem Aplicación de algoritmos de clasificación como soporte al diagnóstico del cáncer de mama en unidades oncológicas(Universidad Santiago de Cali, 2020) García Restrepo, Diego Fernando; Rondón Otero, Leidy Viviana; Tavera Romero, Carlos AndrésBreast cancer is one of the diseases that cause a lot of deaths every year, it is the most common type of all cancers and one of the leading causes of death of women in the world and Colombia. In this article, we present the use of WEKA as a machine learning and data mining tool, applying different classifiers to a set of breast cancer data provided by the cancer unit with the objective of supporting the diagnosis and supporting the taking of decisions in the diagnosis of breast cancer. The results obtained show how researchers in the area of health can use both statistical analysis and data mining techniques to discover knowledge and make a better diagnosis of breast cancer and other diseases. In the document a comparison of the effectiveness of the classifiers and an analysis of correct classification, incorrect classification and precision are made, aspects that are of importance for researchers who want to use algorithms in other types of studies or with other attributes to diagnose if the values of these lead or not to conclude that a person has breast cancerItem 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 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 Aplicación móvil para seguimiento, monitoreo y control de rutas de vehículos. Caso de estudio: empresa línea comunicaciones S.A(Universidad Santiago de Cali, 2019) Landazuri Diaz, Diego Alexander; Priest Velásquez, Yana SaintThat companies of telecommunications subcontract persons who vehicles for the mobilization of its personnel and material of work, nevertheless, this situation does not allow to have a strict control on what really it happens with the vehicles and the material. There is proposed then the development of a technological program that tackles the subject-matter of intelligent labor mobility from the perspective of as the mobile programming and the systems of telecommunications, they allow the collection of data in real-time of factors such as: Distance travelled, Location of the mobile and route management. The structure of the application, named GeoLinea, it was developed from two ambiences coherently linked: In first stay and using the Java Programming Language the app was designed in the Android Studio environment. Currently the application is in the test with the staff of the company.Item 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 Automatización robótica de proceso, aplicada al proceso de cierre de seguros soat usando automation anywhere enterprise(Universidad Santiago de Cali, 2019) Fajardo Mayor, Jhonnathan Steven; Alomia Angulo, Dogildo Klinio; Rojas Montes, Javier SalvadorIn the present work, the development of a robotic process automation for the improvement of the Closing process will be presented, in which the total registered daily sales of Compulsory Insurance for vehicles that were loaded to the CSIS systems in the Morning Hours are concluded, which is made up of a routine that is executed daily, which can be executed on demand or programmed to be executed automatically, in the private company's service area. In addition, to perform automation, a robotic process automation (RPA) tool, called Automation Anywhere Enterprise (AAE), is used. Also, to determine the results of this process with the proposed technology, the concepts that cover this automation technology, the Cascade methodology and analysis that were applied for the development and implementation will be presented in order to obtain the best cycle time of the process and minimize errors by validation and manual information registrationItem Desarrollo de un aplicativo web, mediante metodología Scrum para la gestión y control de eventos relacionados en la Universidad Santiago de Cali(Universidad Santiago de Cali, 2019) Rivera González, Andrés Alexis; Dominguez Acevedo, Oscar Alberto; Loaiza Buitrago, Diego FernandoEn el presente documento se explica el diseño e implementación de una aplicación para dispositivos móviles que apoya la gestión de eventos realizados en la universidad Santiago de Cali., La principal motivación de este proyecto es la automatización , control y poder permitir mejorar la experiencia y seguridad de la totalidad de los asistentes a los eventos realizados en la universidad, principalmente los eventos de ceremonias de grado ya que los asistentes a estos no solamente son estudiantes si no también personas externas a la universidad que deben estar seguros en las instalaciones y adicionalmente llevarse una buena imagen corporativa después de asistir a los eventos. Esta iniciativa nace de la necesidad de la Secretaría General y contó con el apoyo, asesoría y mano de obra de la facultad de Ingeniería y del programa de Ingeniería de sistemas con el fin de automatizar procesos a través de sistemas de información reduciendo los altos niveles de complejidad y demanda de grandes cantidades de tiempo y esfuerzo administrativo por mantener la gestión. La aplicación se desarrolló con la metodología Scrum y el diseño es Web responsive lo que quiere decir que su interfaz es adaptativa a cualquier dispositivo móvil, tiene una interfaz intuitiva y fácil de manejar, La primera fase de la implementación de la aplicación se realiza para la gestión de eventos a las ceremonias de grado. Se podrá crear el evento con los estudiantes asociados por facultad, el horario y generar la cantidad de invitación por estudiante asociado a un código de QR que permitirá mantener el control y seguridad de los asistentes a las ceremonias.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 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 Desarrollo del sistema de Información de registro y control para programas de Comunicación Infantil y Adulto Mayor de Bienestar Universitario de la Universidad Santiago de Cali(Universidad Santiago de Cali, 2019) Orozco Hernandez, Juan Sebastian; Saint-Priest, Yana ElidaThe Ministry of National Education, Law 30 of 1992, requires that higher education institutions carry out university welfare programs. The Santiago de Cali University has an area of University Welfare that manages the Comunidad Infantil and Adulto Mayor programs. These programs have a manual data collection method, which implies greater operational load and exposure to information error. For this reason, decide to build the module "Gestión de Programas" that integrates the research project "Sistematización de los procesos de Bienestar Universitario de la Universidad Santiago de Cali" since it is based on a modular programming paradigm. For the construction of this module, the requirements must be analyzed, modeled a database and built a web application that allows the execution of the registration and control processes. The Scrum methodology and the AUP methodology are selected as they provide advantages in relation to time - quality; the technique of interviewing the client is used to take requirements. The construction is carried out in a total of 12 iterations, and the integration of the modules was handled through the GIT version control tool. The user validation modules and creation of courses previously built in the research project were coupled. The information is stored in the database that contains the integral and centralized information. With the proposed solution it is possible to systematize the key processes for the programs.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 Digitalización de instrumentos aeronáuticos para el simulador de vuelo X – Plane 11 y Air Manager(Universidad Santiago de Cali, 2019) Luna Espinosa, Jeffrey; Villada Luna, David; Tavera Romero, Carlos AndrésThe use of flight simulators is of great importance in an aviation course, they are a way to effectively and efficiently face, among others, aspects such as security, economy and coverage. But sometimes students are required to practice in an aircraft that is not on the simulator's predetermined list, it is then: 1) Acquire the manufacturer the aircraft that is needed, if it is already designed or failing to assume the costs of a development 2) use the most similar aircraft (moving the student away from an experience with the real airplane) or 3) select the aircraft that requires the least changes and adapt it to the pedagogical needs. This last possibility was the one that the Colombian Air Force and the Santiago de Cali University chose when it was needed that the Cadets of the Military Aviation School "Marco Fidel Suárez" were trained in a plane that is not one of the default options in the flight simulator program they use.Item Diseño de un prototipo de aplicación web para la gestión y control de salones para el departamento de servicios universitarios en la Universidad Santiago de Cali(Universidad Santiago de Cali, 2020) Silva Morales, Juan Esteban; Campo Pino, Juan Camilo; Vasquez, Rafael AntonioThe increase in demand for systematizing processes, in order to expedite the performance of activities and reduce their costs, has led small and large companies to create and implement information systems that allow controlling and managing all these activities. Therefore, this document presents an application of the concepts of data collection and analysis, process reengineering, software engineering and agile methodologies, in order to describe the processes, tools and actors involved, which interact with each other. , related to the management and control of classrooms of the Department of University Services at the University of Santiago de Cali, this is done in order to provide a basis for the formulation and design of a prototype management-oriented information system and control of processes that can be systematized. At the end of the project you will have the design of a tool that supports the daily activities carried out by the staff of the Department of University Services, to carry out the formulation of the prototype design, a methodological structure will be applied that will be the work tool throughout the project life cycleItem 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 Diseño e implementación de un dispensador remoto de alimento y agua para perros en la plataforma Arduino(Universidad Santiago de Cali, 2019) Quintero Chocue, Wilder; Torres Stuar, Eric Steven; Dussán Clavijo, Ciro AntonioThis project aims to ensure the feeding of our dogs, through a mobile device that remotely controls a dispenser, supplying water and food regularly according to the need. It has a food capacity corresponding to 3kg, the water is provided by the house by connecting the device to a tap and will be controlled by the user according to the need of the can, these specifications give us autonomy for 2 days of food supplies if the dog is of medium race. The project is executed under the cascade model, guaranteeing an orderly and sequential approach, rigorously following each of its stages. The device provides total freedom and tranquility to the owners of the dog allowing them to feed at a distance for several days, ensuring adequate nutrition and welfare of the pet with a product that is easy to use, provides services and is friendly to the environment his composition.Item Diseño y desarrollo de la app salsacali(Universidad Santiago de Cali, 2019) Buelvas Caceres, Liseth Biviana; Segura Angulo, Yennyfer Alexandra; Tavera Romero, Carlos AndresCali is internationally recognized as the world capital of salsa, however, despite this recognition, this musical genre has lost strength in the city. There are currently many people who are unaware of the cultural, social and economic value that salsa represents for Cali as well as all the development and evolution that this musical genre has had in the city. The emergence of new musical rhythms such as merengue, bachata and reggaeton, salsa in Cali has been overshadowed: through contact with youth it results in many young people not considering or not seeing in the sauce more than just one more genre, or even not important to attend such events. In order to carry out this research, the problem was studied based on the analysis of real and direct data (collecting user opinions) and some believe that this fact has degenerated the salsa identity and this has happened in the background. In order to contribute a little to the fact that the Salsa culture is still valid, “Salsa Cali” is an application oriented to mobile devices, the development of this one was raised to achieve greater dissemination of salsa events in Cali, and contribute a little to that the salsa culture remains in force in a striking way such as a mobile app. It was initially developed for Android mobile devices, a viable medium where development of this type of applications is generally started. It is usable in Smartphone, maintaining usability and aesthetics. Considering the portability, availability and use of mobile Apps, it allows organizers to socialize activities first hand, gives the user the opportunity to consult information about events and places related to salsa events, learn about the history of salsa and songs emblematic Users within the application have access, among other functions, to the creation of a user, information on scheduled events (place, price, public and time), you can also know in advance the details of the site where the event will take place, the people capacity and reservationItem Estado de implementación de la ley de protección de datos en 100 empresas representativas de los sectores público y privado de Cali(Universidad Santiago de Cali, 2019) Alcalde Mejía, Cristhian; Dussán Clavijo, Ciro AntonioCurrently, due to the technological era, information has become a very important asset for companies due to the benefits that can be obtained from its analysis, due to the large amount of personal, private and sensitive data that may affect the fundamental rights of people, the governments of the world have taken the initiative to create laws aimed at protecting this information, known as the data protection law. In this article we will talk about the data protection law of Colombia (Law 1581 of 2012) and about the state of its implementation in 100 representative companies of the city of Cali, from which it was concluded that 82% of the sample complies with the implementation of this law, demonstrating a considerable implementation regarding the data protection law on the representative sample taken from Cali, ColombiaItem 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 Implementación del modelo disaster recovery as a service - draas para la infraestructura it en servicios backoffice: caso estudio empresa sector giros postales(Universidad Santiago de Cali, 2019) Gutiérrez Campos, Anderson; Ramírez Giraldo, Jethferson; Dussán Clavijo, Ciro AntonioThe purpose of a DRaaS solution is to provide efficient and low-cost tools to technology departments based on providing availability to critical services of organizations that may be affected by disaster interruptions; At present, the DRP implementation initiative has a high priority and is a strategic need for companies; The present investigation tries to demonstrate that the implementation of the DRaaS allows to determine the indicators of compliance of the technology, as well as the fulfillment of the objective time of recovery and the objective point of recovery before incidents or catastrophes. A research methodology built from the measurement of the application availability indicator at critical time is implemented; Based on the analysis of the current state of the technological infrastructure, inventory of servers and critical services for BackOffice processes, evaluation of supplier proposals and cost evaluation of a DRaaS solution compared to a traditional DRP solution. Once the previous data has been collected, the risk assessment and the business impact analysis are carried out. The technical requirements that must be implemented in the DRaaS solution will be evaluated in order to meet the efficient operation of IT services. Finally, the implementation of the DRaaS generates significant savings in the renovation plan of the technological infrastructure equipment for the organization, as well as a model oriented towards the fulfillment of the strategic indicators.