José Noel Mendoza

Data Engineer

Inter-American Development Bank•  June 2017 - May 2021

- Created a Tableau dashboard providing a complete overview of a billion-dollar active technical cooperation portfolio and the administrative budget for the Executive Team. - Designed and built 50% of the data pipeline related to human resources, budget, and finance, using Talend Studio, guaranteeing up-to-date data for the self-service BI. - Designed and modeled ~200 structures for different data marts that worked as curated data sources for 50+ BI products. - Monitored the master SQL Server database hosting two main data marts (~150GB) using SQL queries and Tableau dashboards. - Resolved query runtime performance issues by rewriting queries, boosting query execution time by up to 500%. - Discovered and fixed data inconsistencies to ensure data quality in our data marts.