Jorge G.

Team Management and Leadership: Led teams within projects, from gathering requirements and presenting the main solution to clients, to managing key tasks within the team. End-to-End Development of Business Intelligence (BI) Solutions: Delivered comprehensive BI solutions in Power BI using various data sources (SQL Server, Snowflake, API/JSON formats, Web, Azure Environment) from data extraction to visualization. Optimization of ETL Processes: Designed and implemented Dataflows integrated with parameters and M language to ensure an efficient ETL process and optimized data modeling. API Integration for BI Solutions: Developed and managed complete BI solutions through API requests, integrating and automating data analysis processes. Power BI Dashboard Automation: Created and automated Power BI dashboards for reporting analysis, leveraging the PBIP (JSON) file format for configuration and customization. Complex DAX Query Development: Built advanced DAX queries, applying summarization, iteration, and time intelligence functions for comprehensive data analysis. Database Management and Advanced SQL: Managed databases and developed complex SQL queries (CTEs, temporary tables, stored procedures) to optimize data retrieval and processing