Especialización en Ingeniería de Software
URI permanente para esta colecciónhttp://hdl.handle.net/11349/1977
Examinar
Envíos recientes
Ítem Diseño de una base conocimientos para optimizar la gestión operacional del primer nivel de servicio de Tecnología de una entidad financiera de Bogotá mediante un modelo prototipos.(Universidad Distrital Francisco José de Caldas) Duran Hernández, Laura Marcela; Cortinez Osorio, José Jorge; Medina García, Víctor Hugo; Medina García, Víctor Hugo [0000-0002-0989-8676]The following project was developed based on the extensive amount of information that a first-level technology service analyst must be familiar with. The purpose was to structure a knowledge base and materialize it into a prototype that supports delivering clearer and more precise responses regarding the issues being addressed. Its primary function is to streamline incident management, ensure more accurate responses, and serve as guardians of critical information. The lack of knowledge due to the overwhelming volume of relevant data, along with inconsistent information, can cause delays in management processes and reduce service quality. Furthermore, high employee turnover can be significant, and the learning curve may take more than six months. The project proposed the following general objective: to design a knowledge base for the control and improvement of operational management carried out by first-level service analysts in the Technology division of a financial institution in Bogotá. Four specific objectives were defined: (1) gather existing information from the various consultation channels used to date; (2) classify the collected information based on priority, incident type, and solution category; (3) structure the knowledge base by identifying areas for management and indicator improvement; and (4) develop an interactive chatbot prototype to support the resolution of frequent errors. To carry out this project, key topics were addressed, such as knowledge management, the SECI model, and ITIL best practices for operating a Service Desk. The mission of the area and the strategic role of a knowledge base were taken into account, positioning it as a fundamental resource for effective incident resolution. Additionally, the ITIL definition of “incident” was analyzed, and the pair programming methodology was applied to foster collaborative teamwork. The project was developed within the context of a financial institution located in Bogotá, also considering relevant legal aspects such as personal data protection, restrictions on unauthorized website access, and information security policies. An exploratory study was conducted to understand the main knowledge gaps faced by first-level analysts and how these could be addressed through the design of a knowledge base. The research adopted an analytical approach, focusing on identifying evidence and recurring challenges in knowledge management within the Service Desk. Based on these findings, the optimal structure of a knowledge base was defined, and mechanisms for its integration into a chatbot were explored. The project began with data collection through interviews and surveys conducted with the service team, including Service Desk analysts and their coordinator. Based on the results, the planning of information systems was carried out following a layered architecture. It began with the organizational layer, where the purpose, mission, and business logic were identified. Then, the data layer was addressed to design entity-relationship models and properly structure the required database. Next, the procedure layer was developed, defining the operational workflows associated with integrating the chatbot into the work environment. Finally, the application layer was addressed, documenting the technical and functional development of the prototype. In this way, all the project’s objectives were successfully achieved.Ítem Análisis, requisitos funcionales y diseño UML de un sistma de nómina(Universidad Distrital Francisco José de Caldas) Gomez Guerrero, Brandon Stiven; Monroy Fernández, Alejandro; Coronado Sánchez, Paulo CesarThis project presents the analysis, definition of functional requirements, and UML design of a payroll information system aimed at improving the processes of J&J Instalaciones, a Bogotá-based company dedicated to the design and manufacturing of custom furniture. The main objective is to optimize payroll management, reduce payment errors, ensure regulatory compliance, and increase operational efficiency. The research begins with a diagnosis of the company’s current situation, identifying issues such as the lack of a specialized system, manual handling of information, errors in payroll calculations, and difficulties in meeting legal obligations. Based on this, technical solutions are proposed and translated into a structured system model documented in accordance with international standards. To achieve this, a methodology divided into three phases was applied. The first phase focuses on designing the conceptual data model, identifying the system’s actors, entities, and relationships. The second phase involves the detailed documentation of functional requirements for each key system module, including employee management, incidents, disabilities, and vacations. The third phase graphically represents the processes using use case diagrams, sequence diagrams, and activity diagrams, all modeled in UML and aligned with ISO/IEC standards. The result is a clear, verifiable, and traceable model that enables a safer and more effective technical implementation, minimizing ambiguity and errors. As both an academic and practical contribution, this work provides a solid methodology that can be replicated in similar projects within the field of software engineering applied to administrative systems.Ítem Migración de mapas de red de Cacti a un Dashboard en Zabbix para el monitoreo y autorremediación de redes en tiempo real en una empresa de telecomunicaciones(Universidad Distrital Francisco José de Caldas) Garzón Gamboa, Diego Julian; López Moya, Víctor Javier; Abuchar Porras, Alexandra; Abuchar Porras, Alexandra [0000-0002-7797-2874]This thesis focuses on the design and implementation of a network monitoring solution by migrating from Cacti to Zabbix in a telecommunications company. The main objective is to improve the availability of the monitoring system and reduce network downtime, addressing the shortcomings presented by the previous platform. Through a detailed analysis of operational needs, a more robust Zabbix-based architecture is proposed, enabling greater visibility, efficient alerting, and improved decision-making. Functional testing, comparative analysis, and integration with critical network services are included. The document also covers technical, economic, and operational aspects that justify the feasibility of the change. This initiative is presented as a strategic improvement for service continuity and technological efficiency within the organization.Ítem Implementación de servicios para simulación web en flujo laminar aplicado a tuberías mediante dinámica computacional.(Universidad Distrital Francisco José de Caldas) Cuadros Triviño, Valery; Baron Velandia , Julio; Baron Velandia, Julio [0000-0002-9491-5564]Experimental fluid mechanics is often constrained by the limited number of variables that can be analyzed in physical environments. In computational simulations, these limitations are transferred to the available processing capacity. However, two key challenges remain: limited accessibility for users with little experience in information technologies, and the high technical complexity of simulation tools. This study proposes and implements a simulation service focused on the analysis of laminar flow in a pipe, considering variations in relevant parameters. To achieve this, a client-server architecture is designed to encapsulate the installation, configuration, and operation processes of the simulation system. The solution is deployed as a web service in the cloud, accessible through an intuitive graphical interface that requires no advanced technical skills. As a result, an easily accessible application is obtained, which optimizes computational resource usage through a mathematical stability analysis. This strategy enables the elimination of redundant data, reduces wait times, and supports concurrent use by multiple users. The developed web environment significantly enhances the user experience by removing complex configurations and facilitating direct access to laminar flow simulations in an efficient, inclusive, and scalable manner.Ítem Modelado de bases de datos para un sistema de recopilación de proyectos de voluntariado comunitario como complemento a la iniciativa de responsabilidad social empresarial de una compañía de telecomunicaciones en Colombia(Universidad Distrital Francisco José de Caldas) Méndez Ariza, Daniel Felipe; Coronado Sánchez, Paulo CesarThis project proposes the design of a relational database model to organize and centralize information related to corporate volunteering projects of a telecommunications company in Colombia. The main problem identified was the dispersion of data across multiple formats, which hindered traceability, evaluation, and impact measurement of these initiatives. The project followed a structured technical methodology across six phases: needs diagnosis, requirements analysis, conceptual design, logical design, physical design, and model evaluation. Entities such as projects, activities, volunteers, intervention zones, participation, feedback, and documents were defined, applying normalization principles, data retention policies, and aligning with ISO/IEC 12207 and 25012 standards.The model enables historical traceability, assessment of social impact, and supports the future development of a robust information system. A 10-year data growth projection was made, showing no need for a complex infrastructure. While the system was not implemented, the model offers a solid technical foundation for future deployment.Ítem Prototipo de portal de autenticación contra directorio activo para una entidad financiera nacionalFlórez Novoa, Cristian Camilo; Aldana Caviedes, Camilo Andrés; Rincón Rojas, Edgar JacintoWe have an authentication portal that allows access to other internal systems of a financial institution. However, this authentication portal experiences constant outages, preventing access to the bank's various applications, specifically those within the Operational Process Management (OPM) module. Therefore, there's a need to develop a prototype of an authentication portal against Active Directory that will allow OPM applications (operational process management), currently accessed through the EPP (enterprise productivity portal), to operate independently.Ítem Implementación de un módulo de software para la exportación de reportes en Excel en el sistema Hermes componente de extensión, utilizando Oracle APEX(Universidad Distrital Francisco José de Caldas.) Álvarez Chirivi, Miguel Fernando; Romero Villalobos, Oswaldo Alberto; Romero Villalobos, Oswaldo Alberto [0000-0001-8308-3128]This project addresses the implementation of a new report generation module in Excel format within the Hermes system—an extension component used by the National University of Colombia. This initiative arose in response to the problems identified in the current module, such as high latency, difficulties with the CSV format, and dependence on asynchronous processes that negatively impact operational efficiency and user experience. The solution is developed using Oracle APEX and the APEX_DATA_EXPORT package, allowing the immediate generation of Excel files downloadable from the browser. A new optimized database schema is implemented as a data source for the reports, along with an automated transfer mechanism from the transactional schema, all within a three-tier architecture. Development is guided by the adapted RSSD methodology, including analysis, design, implementation, and validation phases. Features are designed that include report and column selection, date validation, access control, and log recording. The module seeks to improve efficiency, reduce response times to less than three minutes, and offer an intuitive and functional interface for administrative users at the university's various locations. The implementation of this module represents a significant improvement in the Hermes system's ability to meet its users' information needs, strengthening institutional processes and data-driven decision-making.Ítem Prototipo de aplicación móvil para enseñanza de uso de teléfonos inteligentes para adultos mayores aplicando técnicas de andragogía en ColombiaBallesteros Ballesteros , Paula Ximena; Abuchar Porras, Alexandra; Abuchar Porras, Alexandra [0000-0002-7797-2874]A report from DANE indicates that 83% of older adults in Colombia own a smartphone, with 95% of these devices being the only means of internet access for this population. However, a considerable percentage of them face difficulties using basic functions, which limits their communication and autonomy. (DANE, 2021) To help address this issue, the design and development of a mobile application prototype for Android devices is proposed. This prototype focuses on teaching the use of smartphones by applying andragogical techniques, facilitating learning for Spanish-speaking older adults in Colombia. Two surveys were conducted with 50 participants each: the first targeted older adults, and the second their caregivers. The goal was to identify the most important features, the most commonly used functionalities, and those requiring the most assistance. The results indicated that older adults require the most support with downloading apps from the device store, scanning QR codes, and using geolocation apps. However, they manage basic functions well, such as adjusting volume and using social networks. For the architectural design, requirements were initially gathered following the ISO/IEC/IEEE 29148:2018 standard. Based on these requirements, UML diagrams for packages, classes, and use cases were created, applying an MVVM architectural approach to define the behavior and implementation of the mobile application. The prototype development was carried out using Android Compose for the views, creating interfaces for registration and login, course lists, video playback, tests, and submission of suggestions and questions by users. Additionally, each screen allows users to increase or decrease the font size. For the backend, Google Firebase was used to enable remote content updates without requiring new app releases to stay up to date. Unit tests were conducted to ensure the application works as expected, with 235 unit tests performed, achieving 100% code coverage. The acceptance criteria for both functional and non-functional requirements were verified using the APK of the generated prototype, ensuring the prototype was built correctly in compliance with the specified requirements and technical specifications.Ítem Ingeniería de requerimientos para un data warehouse de un sistema Endpoint Detection and Response (EDR)Yosa Velásquez, Edinson Mauricio; Coronado Sanchez, Paulo CesarThis document describes the requirements engineering process for a Data Warehouse intended for an Endpoint Detection and Response (EDR) system. It primarily focuses on adhering to ISO 29148 and its guidelines for constructing System Requirements (SyRS). The process considers crucial aspects such as elicitation, prioritization, development, and defining acceptance criteria. The documented system provides support for monitoring the procedures in the formulation of requirements, with the goal of overseeing the process specified in the standard.Ítem Desarrollo de un prototipo de motor de búsqueda corporativo para optimizar el proceso de onboarding de personal de tecnologías de la información en medianas y grandes empresas(Universidad Distrital Francisco José de Caldas) Olarte Vargas, Óscar Duván; Puentes Camargo, Brayan Alejandro; Parra Peña, Jhon Freddy; Puentes Camargo, Brayan Alejandro [0009-0006-4521-5680]This thesis aims to develop a **corporate search engine** to optimize the **onboarding process** in medium and large companies. The project will begin with data collection through **interviews and surveys** to analyze the current state of the process and gather insights from information technology employees' experiences. Based on this data, the **requirements will be defined**, and the **system architecture** will be designed and implemented. Subsequently, the documentation of a simulated company will be created to populate the **search engine's knowledge base**. Finally, the system will be implemented in this simulated environment, and conclusions will be drawn based on the results obtained.Ítem Creación de un repositorio web para la agregación de precios de edificios residenciales para las ciudades de Bogotá y Medellín(Universidad Distrital Francisco José de Caldas) Cobos Prada, Daniel Leonardo; Abuchar Porras, Alexandra; Cobos Prada, Daniel Leonardo [0009-0000-6011-3443]; Abuchar Porras, Alexandra [0000-0002-7797-2874]By collecting different real estate data sources through different internal APIs, a centralized repository is created with the prices of residential real estate in the cities of Bogota and Medellin, this repository is a database that is then used as a data source for a web application where people looking for housing and appraisal specialists can access this information in a more convenient way. This work collects the whole process of building such a repository, from the requirements gathering to its deployment.Ítem Desarrollo de una guía práctica para el diseño de proyectos de software con implementación en Domain-Driven Desing (DDD)(Universidad Distrital Francisco José de Caldas) Acero León, Sebastián; Jaramillo Moreno, Beatriz Elisa; Acero León, Sebastián [0009-0000-0413-0214]This specialization graduation project in Software Engineering addresses the challenges associated with the design, implementation, and organization of software development projects, emphasizing the increasing technical complexity and advanced requirements that characterize these environments. It focuses on the Domain-Driven Design (DDD) architecture, renowned for its business-domain-centric approach and its ability to align software design with the organization's key processes. The primary objective is to develop a practical guide enabling professionals to effectively apply DDD, overcoming common challenges in complex projects while promoting scalable and coherent architectures. Through the analysis and evaluation of this methodology in case studies, this project aims to provide a useful and adaptable tool that fosters innovation and excellence in the field of software engineering.Ítem Arquitectura estándar para plataforma de pagos electrónicos de parqueaderos automatizados en BogotáPardo Moreno, Juan Camilo; Otavo Piraban, Andrés; Parra Peña, Jhon Freddy; Pardo Moreno; Juan Camilo [0009-0000-0135-8029]; Otavo Piraban; Andrés [0009-0000-7257-452X]This project addresses the need to centralize electronic payments in automated parking lots by proposing and implementing a standard architecture. Through an iterative methodology, a system was designed and developed that allows interoperability with different parking systems, guaranteeing scalability, security, and ease of use. The work included the analysis of factors that hinder the adoption of electronic payments, the definition of minimum architectural components, and the implementation of architectural styles and patterns suitable for integrating heterogeneous services. During development, a service-oriented architecture (SOA) supported by an Enterprise Service Bus (ESB) was implemented, facilitating integration with external APIs, such as payment gateways and parking systems. Advanced security measures were also adopted, including the delegation of authentication to an external provider and the encryption of data at rest and in transit. These technical decisions ensured a robust system that could adapt to future changes. The results obtained validated the effectiveness of the solution, managing to satisfy the functional and non-functional requirements raised. This work not only presents a practical solution for the digitalization of parking payments, but also establishes a replicable technical framework for similar projects in other sectors. Finally, future lines of research are proposed, focused on the evolution towards architectures based on microservices and serverless systems, as well as the integration of artificial intelligence tools to optimize the user experience.Ítem Plan estratégico de transformación digital y prototipo para la implementación de un sistema de gestión de datos para Interseguros LP LtdaViracachá Pava, Fredy Hernando; Veléz Zapata, Jaime Eliouth; Medina Garcia Victor Hugo, Victor Hugo; Viracachá Pava; Fredy Hernando [0009-0009-5109-1049]; Vélez Zapata; Jaime Eliouth [0009-0005-8524-6425]The organization Interseguros LP Ltda. is a small company dedicated to managing insurance sales. This project proposes optimizing the company's internal processes through a strategic plan for digital transformation, addressing current limitations such as data dispersion and manual processes that affect operational efficiency and customer experience. The solution includes progressive phases, starting with an organizational analysis to clarify its business model, followed by suggestions on how to update data management processes, improve their interaction with each area of the organization, and provide a perspective on the technological tools best suited to Interseguros LP Ltda. The project also includes staff training and the adaptation of the organizational culture to facilitate the transition to a digital environment. The expected impact includes a 40% improvement in operational efficiency and increased customer satisfaction. This initiative lays the foundation for Interseguros LP Ltda. to compete in an increasingly digitized market, ensuring sustainability and growth.Ítem Lineamientos de la arquitectura de software para un sistema de gestión de rutas, que permita obtener la ruta óptima y segura en la entregaGaona Toro, Xiomara Gaona; Cárdenas Quintero , Beitmantt Geovanni; Cárdenas Quintero, Beitmantt Geovanni [0000-0003-0293-0036]In the second quarter of 2024, the postal sector reported approximately 30 million local deliveries and 37 million national deliveries, reflecting significant growth driven by the rise of e-commerce. This increase presents challenges for the logistics systems of courier companies, which must evolve to become more robust and scalable. However, operational inefficiencies persist due to the lack of specialized tools for planning optimal and secure routes, leading to delays, error risks, and difficulties in ensuring standardized and efficient services. Currently, couriers rely on their personal experience and free applications such as Waze or Google Maps, introducing variability in delivery times and reducing companies’ ability to efficiently manage operations. To address this issue, this document proposes a software architecture design for the development of a tailored route management system. This system aims to optimize delivery times and enhance the safety of couriers and goods by incorporating variables such as traffic conditions, road status, and incident reports, providing a comprehensive solution to the sector's logistical challengesÍtem Diseño de un prototipo de software orientado al análisis de regiones nevadas de Colombia a partir de regiones en movimiento sobre bases de datos espacio temporalesPorras Martin, Camilo Andres; Parra Peña, Jhon FreddyThis document describes the construction and development of a software prototype aimed at the use of moving regions over spatiotemporal databases for the analysis of snow-covered areas in Colombia, using the Sierra Nevada de Santa Marta and the Nevado del Ruiz Volcano as case studies.Ítem Estado del arte de la regulación del uso de inteligencia artificial para el desarrollo de software en empresas colombianasManchola Camacho, Emersson; Coronado Sanchez, Paulo CesarIn the contemporary digital age, the rapid advancement of artificial intelligence has fundamentally transformed various aspects of our lives and agendas, from communication to interaction with technology and the world around us. The proliferation of A I solutions has created an ecosystem where technological innovation and ethical, legal and regulatory concerns converge in equal measure. It is important to have an understanding of how regulatory frameworks address these novel technologies, as well as their modifications as they incorporate changes in the technological and regulatory areas. This article will explore regulatory approaches in different countries, as well as debates around issues such as liability of legal entities, protection of personal data, ethics in development and implementation. It will also describe trends and possible future regulatory directions, with a view to providing a comprehensive overview of the ever-changing issue.Ítem Un método para evaluar el desempeño de los equipos de pruebas manuales en proyectos de software: Un enfoque hacia la calidad final del productoBorrero Romero, Laura Daniela; Rodriguez Bedoya, Iván René; Abuchar Porras, Alexandra; Abuchar Porras, Alexandra [0000-0002-7797-2874]The effectiveness with which the members of the organization achieve the goals, objectives and expected results of their position are evaluated through a systematic, formal and periodic process called performance evaluation (Ross, 2013). Performance measurement processes started in the 1980s when the concept was adopted by Spanish companies, which began to implement it in their operations and personnel to increase their productivity and competitiveness (Padilla, 2021). In the context of software development, performance is perceived as a process of continuous improvement that seeks to increase the quality and efficiency of processes in the delivery of digital products (Pressman, 2010). According to Kanner et al. (2001), the combination of performance evaluation, projects and test execution is crucial for the completion of any software project because quality is directly related to these factors, which means that if one of them fails, the others will also be affected. Due to their intriguing complexity and the presence of several actors and components, software projects require a careful approach to evaluate the performance of the participating teams (Pressman, 2010). This team is essential in manual test execution as it helps to continuously improve software quality by identifying and communicating bugs in time (Kaner et al., 2001). In a large percentage of software projects, methods are established to evaluate developer performance. However, for testing teams there is no specific measurement standard, and this lack of guidelines represents a significant challenge as it makes it difficult to accurately assess the productivity and effectiveness of the testing team.Ítem Modelo de arquitectura back-end basada en microservicios, como base para un futuro software de autogestión de logística compartida para microempresas en BogotáAbril Nieto, Christian Stiven; Ruiz Ovalle, Leidy Lorena; Romero Villalobos, Oswaldo AlbertoThis document, the specification of the architecture of a future software is made to create logistics self-management networks for microenterprises in Bogotá that allow them to share among several a vehicle for the delivery of their different products and/or merchandise, generating a considerable decrease in costs. operating costs and proper functioning of the logistics department of each one. For this, it was necessary as a first measure to raise the viability and acceptance of the application in the microenterprises of Bogotá. Subsequently, the requirements that the application would require were gathered and subsequently a software architecture model for the back-end based on microservices was proposed. , which allowed us to leave a development base for a future logistics self-management software for microenterprises in Bogotá.Ítem Diseño de un prototipo de aplicación web para la gestión de correspondencia en conjuntos residencialesNova Aguilar, Sergio Andres; Cárdenas Quintero, Beitmantt Geovanni; Cárdenas Quintero, Beitmantt Geovanni [0000-0003-0293-0036]Residential complexes are known for providing, in addition to housing, a series of benefits that arise from community life, with the aim of maximizing the quality of life to the greatest extent possible with the budget provided by all members of the property. For this reason, the administration as a central entity, must take advantage of the technological tools available to streamline and facilitate internal processes since there are often manual processes, whose errors create tension between the different actors in the community. As technology and systems evolve, the correspondence management process can be automated, significantly improving the efficiency and experience of residents, security personnel, and the administration of the complex.