Mario Yepes Goenaga

Microsoft Fabric consultant in the educational sector.

Design and develop ETL processes using Python, relying on Jupyter Notebooks.

Data modeling and architecture oriented towards Power BI.

I designed and executed ETL processes using Microsoft SSIS and Microsoft Fabric, performing the extraction, transformation, and loading of data from multiple heterogeneous sources, ensuring data quality and consistency. I programmed and optimized scripts in SQL, Transact-SQL, PySpark, and SparkSQL to accelerate business key indicator calculations, improving data processing efficiency. I led the design, creation, and management of data architectures, including Lakehouses, Data Warehouses, and Data Marts, in Oracle, SQL Server, and Microsoft Fabric environments. I built data models following star and snowflake architectures, improving organization and performance in business analysis systems. I developed key performance indicators (KPIs) and interactive visualizations using Power BI and DAX, driving strategic analysis and data-driven decision-making.

I developed and supported PL/SQL solutions in Oracle and SQL Server databases, optimizing performance and ensuring data integrity. I designed, programmed, and executed batch processes on Unix servers, automating critical workflows and improving operational efficiency. I performed data modeling and visualization using Power BI, facilitating strategic decision-making through interactive dashboards and dynamic reports. I designed and developed ETL processes using Microsoft SSIS, ensuring accurate data integration aligned with business requirements. I programmed Python scripts for data analysis, transformation, and management.