Stephanie Avila Díaz Email & Phone Number

Bogota, D.C.

Colombia

Main tasks:• Extracting data from various sources, such as databases or files, and transforming it into a usable format for analysis or storage.• ETL (Extract, Transform, Load) Process: Implementing ETL processes to integrate data from multiple sources, transform it according to business requirements, and load it into target systems or data warehouses.• Assisting in the development and maintenance of data pipelines to automate data workflows, ensuring efficient and reliable… Show more Main tasks:• Extracting data from various sources, such as databases or files, and transforming it into a usable format for analysis or storage.• ETL (Extract, Transform, Load) Process: Implementing ETL processes to integrate data from multiple sources, transform it according to business requirements, and load it into target systems or data warehouses.• Assisting in the development and maintenance of data pipelines to automate data workflows, ensuring efficient and reliable data processing and integration.• Identifying and resolving issues related to data processing, database performance, or ETL processes to ensure data operations.• Documenting data engineering processes and workflows for future reference and knowledge sharing within the team. Show less

Bogotá, Distrito Capital, Colombia

Colombia

Main tasks:• Ensured data quality in area-related tables by utilizing SQL through the Snowflake data warehouse and integrating external data sources such as Gsheets.• Developed, maintained, and supported Power BI dashboards to derive valuable insights for the involved areas.• Created a framework and template with UX standards for financial dashboards establishment.• Orchestrated ETL processes using Airflow to streamline data integration and… Show more Main tasks:• Ensured data quality in area-related tables by utilizing SQL through the Snowflake data warehouse and integrating external data sources such as Gsheets.• Developed, maintained, and supported Power BI dashboards to derive valuable insights for the involved areas.• Created a framework and template with UX standards for financial dashboards establishment.• Orchestrated ETL processes using Airflow to streamline data integration and transformation.• Implemented CI/CD methodology using the BitBucket service to ensure efficient development and deployment of code. Show less

Colombia

Information management ESG - https://merosystem.contreebute.com/Main tasks:• Parametrization of the ESG information structure, highlighting usability, data centralization and creation of value connections with stakeholders.• 1:1 support with Mero customers to improve the customer experience in the system.• Promote ideas of continuous improvement using environmental and technological guidelines that allow for a friendly panorama between both topics.• Generate… Show more Information management ESG - https://merosystem.contreebute.com/Main tasks:• Parametrization of the ESG information structure, highlighting usability, data centralization and creation of value connections with stakeholders.• 1:1 support with Mero customers to improve the customer experience in the system.• Promote ideas of continuous improvement using environmental and technological guidelines that allow for a friendly panorama between both topics.• Generate instruments to define management follow-up indicators within the tool, prior to the development of dashboards for data analysis. Show less

Colombia

Main tasks:• Geodatabase Development: Creating geodatabases using ArcGIS Desktop to manage and organize environmental monitoring data for air, water, noise, and soil matrices.• Performing data cleaning and validation tasks to ensure the accuracy and quality of the collected environmental data from various sources such as flat files and xlsx files.• Creating maps and graphical outputs using ArcGIS Desktop to visually represent monitoring points and locations, aiding in data… Show more Main tasks:• Geodatabase Development: Creating geodatabases using ArcGIS Desktop to manage and organize environmental monitoring data for air, water, noise, and soil matrices.• Performing data cleaning and validation tasks to ensure the accuracy and quality of the collected environmental data from various sources such as flat files and xlsx files.• Creating maps and graphical outputs using ArcGIS Desktop to visually represent monitoring points and locations, aiding in data interpretation and communication of results.• Compliance with Standards and Regulations: Following the guidelines and standards set by entities like IGAC (Instituto Geográfico Agustín Codazzi) and ANLA (Autoridad Nacional de Licencias Ambientales) to ensure compliance with environmental regulations in data management and reporting. Show less

Bogotá, Distrito Capital, Colombia

Main tasks: • Creation of templates in Excel, integrated data into a geodatabase (GDB), and associated products using ArcGIS software. Managed environmental monitoring data for water, air, soil, noise, and radiation, ensuring adherence to ANLA's data model.• Providing support for graphic outputs using ArcGIS, including georeferencing and spatial analysis, to meet specific requirements.• Conducting training sessions on general topics of basic cartography to the data… Show more Main tasks: • Creation of templates in Excel, integrated data into a geodatabase (GDB), and associated products using ArcGIS software. Managed environmental monitoring data for water, air, soil, noise, and radiation, ensuring adherence to ANLA's data model.• Providing support for graphic outputs using ArcGIS, including georeferencing and spatial analysis, to meet specific requirements.• Conducting training sessions on general topics of basic cartography to the data processing team, enhancing their understanding and skills in cartographic principles and techniques.• Training and implementation in the management and transformation of data to different coordinate systems, following Resolution 471 of 2020 issued by the IGAC for basic cartography products. Show less

Bogotá D.C., Colombia

Main tasks:• Updating and reviewing environmental logs at IPS facilities.• Planning and conducting training sessions for medical staff focused on the PGIRASA (Integrated Waste Management Plan for Healthcare Facilities). • Preparation and monitoring of monthly comparative reports on waste generation and collection by authorized handlers.• Assisting in the registration of Special Waste (RESPEL) with IDEAM (Institute of Hydrology, Meteorology, and Environmental… Show more Main tasks:• Updating and reviewing environmental logs at IPS facilities.• Planning and conducting training sessions for medical staff focused on the PGIRASA (Integrated Waste Management Plan for Healthcare Facilities). • Preparation and monitoring of monthly comparative reports on waste generation and collection by authorized handlers.• Assisting in the registration of Special Waste (RESPEL) with IDEAM (Institute of Hydrology, Meteorology, and Environmental Studies), SIRHO (Water Resources Information System) for the SDA (Environmental Authority), and characterization of discharges with EAAB (Bogotá Aqueduct and Sewerage Company).• Conducting environmental assessments and providing support in updating the PGIRASA (Integrated Waste Management Plan for Healthcare Facilities). Show less

Habilidades De Programación De Misión Tic 2021 Con Profundización En Desarrollo De Aplicaciones Web., Engineering

Ingeniera Ambiental, Nature Appreciation

Diplomado En Estrategias Para La Reducción De Impactos Ambientales Con Enfoque Sustentable, Engineering

Tecnologa En Administración De Hoteleria Y Turismo, Hospitality Administration/Management