Fortalecimiento integral del Sistema de Gestión Ambiental del Ministerio de Hacienda y Crédito Público (MHCP)

Abstract

This internship report aims to strengthen the Environmental Management System of the Ministry of Finance and Public Credit through the monitoring of environmental programs, document updates, indicator optimization, and the development of a sustainability project. The methodological approach was based on a mixed framework that integrates both quantitative and qualitative data analysis, supported by tools such as Power BI, Excel, and the institution’s existing environmental documentation. Firstly, monitoring and control activities were carried out for several environmental management programs. This process involved the preparation of water and energy consumption reports, conducting inspections of waste storage areas, and developing a tool to calculate the CO₂ emissions avoided by the institution’s photovoltaic solar system. Secondly, the Hazardous Waste Management Plan and the Solid Waste Management Plan were updated. An initial diagnostic assessment was conducted to identify improvement opportunities in relation to the entity’s operational changes and current environmental regulations. Thirdly, the indicator model for the water and energy efficiency programs was optimized using Power BI. This required a data systematization process involving the grouping, classification, and transformation of information, which was then used to develop dashboards displaying consumption, cost, and savings indicators for each program. Finally, an environmental project was implemented at the MHCP San Agustín headquarters, promoting the reuse of residual water from employees’ containers after working hours. This initiative enabled the quantification of water savings by floor, providing a basis for establishing strategies aimed at improving the efficient use of water resources.