Herramientas de gestion para la gerencia

Abstract

This degree project was developed within the framework of the professional internship carried out at the Agrifood Division of the Export Vice Presidency of ProColombia, an organization responsible for promoting the internationalization of Colombian companies and strengthening their participation in international markets. Based on the assessment conducted during the internship, opportunities for improvement were identified in the organization and management of information, the monitoring of business opportunities and calls for participation, the dissemination of commercial opportunities, and the execution of manual and repetitive processes that could generate rework and affect the division’s operational efficiency. In response of these needs, an improvement plan was designed and implemented to strengthen promotion, information management, and support processes for advisors. As part of the proposal, Excel – based tools were developed for the consolidation and monitoring of calls for participation, technical fact sheets containing relevant information for companies, an activity calendar to facilitate event planning and dissemination, improvements to account maps using Excel and Power Query, and a model for automating export certification processes. These tools were designed to facilitate access to strategic information, improve activity monitoring, and reduce the time required for operational processes. To evaluate the usefulness of the implemented tools, a survey was conducted among advisors from the Agrifood Division. The results showed a favorable perception of their usefulness, particularly in terms of improving the organization and availability of information, monitoring calls for participation and companies, optimizing response times, and reducing rework. In this regard, the project demonstrates the importance of integrating information management, commercial analysis, and technology tools to strengthen the efficiency of internal processes and support the international promotion activities carried out by ProColombia.