Diseño e implementación de herramientas para sistematizar las actividades administrativas que ejecutan los servidores públicos en la Umata de la Alcaldía Municipal de Junín Cundinamarca

Abstract

Over time, With the passing of time, the Administrative Record has become a very important methodological tool for the improvement of efficient information gathering techniques in the development of the mission functions of public organizations of the State, according to [6] created for fiscal, administrative, social, internal control and political purposes; therefore, its collection is systematic and continuous, based on the MIPG regulations.

Following this order of ideas, the present project of social character, was executed in order to benefit public officials of the UMATA of the municipality of Junín Cundinamarca, in which, according to [6], the record in the two implemented tools, allows to respond to requirements of intersectoral or territorial public policy (for example, The project was designed to provide two useful tools that would allow the municipality to improve the agricultural and rural information system of the municipality at the time of implementation.

The elaboration of the six stages allowed the design phase, installation, implementation and training of the administrative staff of the UMATA unit, these stages consisted of developing a series of activities, which resulted from a preliminary stage, which allowed the recognition of the skills and abilities in the work of administrative registration, as well as its characterization of technical knowledge, for the use of administrative engineering tools, in the domain of computer software.

For the development of the first objective, it was necessary to evaluate and analyze the methodology in the registration of administrative activities, executed in the provision of agricultural services by the UMATA of Junín, where data collection techniques were used through group interviews, analysis of 2020 results in the performance of the fifth dimension of the MIPG and participatory observation with UMATA officials.

For the development of the second objective, it was necessary to identify the causes in the administrative process of the UMATA of Junín, which hindered the registration system of agricultural services provided to users, so the previous information was taken into account to proceed with the diagnosis of the social situation.

For the development of the third objective, it was necessary to propose improvement actions to improve the methodology for recording information on the mission functions of UMATA of Junín Cundinamarca, for which the reconstruction of the first tool was proposed and on the other hand, the new construction of the second MRP tool, since they did not have it and it was necessary and indispensable for the complementary registration of their mission functions of the UMATA of Junín.

For the development of the fourth objective, it was necessary to build an automated database, with the application of advanced Microsoft Excel code programming, called Visual Basic for applications and also the application of Macros to facilitate repetitive tasks that generated the registration of users and services of the UMATA of Junín Cundinamarca.

Organizations need to procure materials and inputs for the development of activities in the provision of services. These supplies accumulate in the companies and must be managed for their correct handling and conservation, [27] therefore; for the development of the fifth objective it was necessary to build a tool more appropriate to the requirements in the administrative registration of supplies and materials used in the mission functions of the technical assistance provided daily by public officials to the users of Junín, so it was worrying that the UMATA unit lacked a tool for such an important MRP management; Therefore, we investigated about the methodologies for inventory registration and in the end we defined a successful model that manages the company BIND ERP, for inventory management in microenterprises, which later served us as a great help, in order to design the most automated and customized database for the registration and inventory management of UMATA; It is important to mention that the concept was refined by creating a complete tool and at the same time very practical and intuitive to use, allowing public officials, at the time of implementation, to master it in just a few hours, contributing to the important work of systematizing valuable information, for the traceability of management of the same unit before the comptroller and Internal Control, in order to deliver transparent, truthful and updated management reports.

The social project designed and implemented 2 tools of great potential and complementary, to systematize the administrative activities carried out by public servants in the UMATA of Junín Cundinamarca, proposing a focus on compliance with the administrative record, with statistical channeling as suggested by the regulations in dimension five (5) of the MIPG, in order to deliver reports with graphs and pivot tables that facilitate the interpretation of the reports to be submitted to date, where finally to demonstrate the capabilities in the implementation of the tool E. R.P of the UMATA, the student elaborated a Dashboard by economic sector, to demonstrate the usefulness of analyzing the traceability of the Administrative Record by sector in the UMATA of the municipality of Junín.