Ingeniería de Sistemas

Permanent URI for this collection

https://usc.scimago.es/handle/20.500.12421/51

Browse

Now showing 1 - 20 of 40

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, Simena
Organizations 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.
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 Camilo
The 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.
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ío
Integración por software de las plataformas Nagios y OTRS para automatizar el registro de incidentes en la empresa STR
(Universidad Santiago de Cali, 2019) Alvarado Girón, Juan Manuel; Ospina López, Orlando
The needs of business and everyday life have asked the information systems are integrable, i.e. an information system can interact with other information systems. In this paper, a particular case of STR Company (Smart Technology for Receiving) was worked. STR is headquartered in Santiago de Cali. STR operates technological transport equipment, between these, collection equipment. The particular case was the manual record of incidents due to equipment failure, which affected the level of service provision. The proposed solution was an automation of the incident registration process by the exchange of data through SOAP Web Service. This implied the development of a software component, which required the solidity of a relational model and the consistency of a class diagram. Also, studying Nagios API and WSDL of OTRS Web Service was necessary. For measuring the impact of the solution, several variables were defined, these variables were fed by the above software component. So, the problem could be quantified and the improvement of the level of service provision could be seen (in terms of time reduction).
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 Antonio
The 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.
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 Antonio
This 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.
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 Salvador
In 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 registration
Sistematización de la asignación del recurso humano ingenieril y técnico, para proyectos de tecnología. Caso de Estudio: Spectra Ingeniería Ltda
(Universidad Santiago de Cali, 2019) Potes Buenaventura, Diego Javier; Priest Velásquez, Yana Saint
The activity of associate task to the employees of a company or human resource allocation, for organizations that base their operation on projects, could be more agile if their having tools that allows centralize the information, to get access to the information to a practice way, getting that the management of the allocation of the resources be optimal and become efficient during the execution of the required projects. It is proposed then, the development of a software tool that allow make the assignment of the human resource to the projects, having in a count the capabilities or knowledges of the staff, getting too a control of the times and activities, to finally get an adequate management of the human resource assignment to the projects. Through the application of the prototype methodology, is achieve systematize the assignment of the engineering and technical human resource, to the projects of the Spectra Ingeniería Ltda. company, obtaining as a result an application that allow give fluidity to the process of the personal assignment. The tests performed on the application through the management of 25 projects, including the respective assignment of activities and personnel to each one, produced the expected results during the investigation. The development of the application allowed to identify additional processes that affect the times of the projects and that could be included as modules that will offer development improvements
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 Fernando
Currently 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.
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 Saint
That 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.
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és
This 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.
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 Fernando
This 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.
TDM: dispositivo educativo para aprendizaje de las tablas de multiplicar en 3ro de primaria caso de estudio: colegio bilingüe san José campestre
(Universidad Santiago de Cali, 2019) Pitto Giraldo, Johann Fernando; Cuero Cortés, Alex; Saint-Priest, Yana Elida
Learning the multiplication tables in some elementary school children has always been a pedagogical problem for third grade primary school students. This has motivated several researchers to look for alternatives to find the right solution, this being the aim of the present project. It is proposed to include TIC in the teaching of multiplication tables through a technological tool focused on autonomous and dynamic learning in a didactic and entertaining way; using an interactive web resource that includes a candy dispenser that will reward the good results obtained by motivating children in learning. It is a hardware component, device, and software tailored to the students' taste and to the teachers' requirements to facilitate learning. The TDM device was designed with a layered architecture and uses a controller view model as a design pattern, allowing it to be adaptable to changes, improvements and expansions that are generated over time. The resulting design became an important tool for teaching multiplication tables in the school, being novel and didactic as a methodological system
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, Simena
The 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”.
La importancia del sistema de gestión de la seguridad de la Información en el comercio electrónico empresarial
(Universidad Santiago de Cali, 2019) Lozano, Alexander; Velásquez, Rafael Antonio
The economic opening generated by the globalizing processes has allowed the information systems technology to speed up the commercial, administrative and financial processes of the companies, facilitating payment systems and communication processes with customers, suppliers and employees. However, it is wagered on stage information security as an element of great importance for customers. That is why the information security management systems in electronic commerce, becomes a vital tool for those companies that carry out business by this means, since there are designed policies and strategies that allow to plan reliable commercial systems for users and Internet users In this order of ideas, this paper seeks to identify the arguments that allow demonstrating the need to implement information security systems in companies that conduct electronic commerce, since there are still Colombian companies that in this area are doing business in means of informatic informality, without considering aspects that are essential for their safety and that of their clients.According to the above, the present work was developed in three sections, which begins with a general description of the importance of electronic commerce in companies, since here we seek to contextualize the issue to make it understandable when addressing the main risks facing the sector, an aspect shown in the following section, where the main computer threats that are envisaged in this type of trade are attempted to be put in context. Subsequently, it concludes with a section that recounts the importance of implementing the Information Security Management System in these organizations to offer greater confidence to their clients and interested parties in the commercial activities that are developed in these business models.
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 Elida
The 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.
Nutricom: aplicación que recomienda alimentos saludables a partir de reconocimiento de alimentos en imágenes para evitar enfermedades
(Universidad Santiago de Cali, 2019) Manyoma Navia, Javier Andres; Priest Velásquez, Yana Saint
The poor nutrition and feeding has become one of the great problems of modern life, causing a number of diseases and accelerating the transformation process. It is proposed to solve the problem with the implementation of a mobile application, based on artificial intelligence, which employs visual recognition of images suggested food intake or not, according to the user's profile including diseases, eating habits. The objective of the project was to classify the foods present in an image and calculate their caloric value to suggest healthy and nutritious foods. The methodology used was in cascade or life cycle, since it is the most common and oldest software development, and is widely used. The NUTRICOM mobile application can be integrated with the Watson API, visual recognition of food images, taking advantage of its ability to recognize more than 2,000 foods and "train" with it. Through the application, people can learn to eat well according to their profile. In conclusion, it can be said that for the visual image recognition API to have a correct operation, you must carry out a training or learning of at least 50 images per food
Diseño y desarrollo de la app salsacali
(Universidad Santiago de Cali, 2019) Buelvas Caceres, Liseth Biviana; Segura Angulo, Yennyfer Alexandra; Tavera Romero, Carlos Andres
Cali 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 reservation
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 Antonio
Currently, 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, Colombia
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 Fernando
One 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

Browse

Browsing Ingeniería de Sistemas by Issue Date

Results Per Page

Sort Options