David Gonzalez Hernandez

- ETL/ELT Management: Oversee and monitor daily batch processes in Azure Data Factory to ensure high data consistency and operational continuity. - Technical Enhancements & DevOps: Implement new features in SQL Server and Databricks, managing the full lifecycle through Azure DevOps with automated CI/CD pipelines. - Data Architecture: Deliver end-to-end solutions in Azure Synapse Analytics and build business-facing Power BI dashboards to improve KPI visibility. - Cloud Migrations: Lead technical assess

- Cloud Data Integration (Azure): Maintained and optimized end-to-end data ingestion and transformation workflows for large-scale banking datasets. Developed and managed robust pipelines using Azure Data Factory and SQL Stored Procedures (T-SQL) to ensure data reliability. - Monthly Reporting Operations: Orchestrated the financial reporting cycle in Power BI, implementing technical enhancements and rigorous data validation processes. Guaranteed the integrity of monthly banking KPIs for internal stakeholders

- SSIS Operations and Maintenance: Provided technical support for existing SSIS packages, ensuring the stability of daily data loads and troubleshooting execution failures in SQL Server environments. - Data Pipeline Monitoring: Monitored ETL workflows to ensure data consistency, performing minor SQL adjustments to improve the reliability of infrastructure reporting. Technical Stack: SSIS, T-SQL, Power BI

- Maintained basic databases in Microsoft Access to support data organization and reporting. - Designed and implemented automated data processing workflows in Microsoft Excel using Power Query, improving data preparation efficiency. Technical Stack: Microsoft access, Excel, Power query

Responsible for structural oversight on over 5 national-level projects, with a notable project being the Office Building on Avenida Camino de Santiago. My responsibilities included: -Structural calculations for building projects. -Oversight of construction plans. -Optimization of reinforcement techniques.