Alonso Vives

- Development and optimization of a highly modular and scalable double ETL in Python, fully monitored and automated. - Complete migration of an environment based on Oracle and Business Object (SAP) to PostgreSQL and Power BI, reducing maintenance costs and unifying and simplifying access to information. - Design of a complete semantic model for all necessary personal and financial data used in reports. - Creation and standardization of reports using Power BI. - Collaborative work with financial teams and multidisciplinary developers to define objectives, estimate deadlines, and track progress. - Development of an SQL translator from Oracle SQL to PostgreSQL SQL using TypeScript and Google Sheets. - Documentation of the entire development process for internal and client use. - Orchestration of ETL execution using Control-M. - Implementation of an application to execute the ETL with endpoints and monitoring via Elastic. Technologies & Skills: Python, SQL, Power BI, DAX, M, GitHub, PostgreSQL, Oracle, TypeScript, Excel, Google Sheets, Control-M, teamwork, Scrum, Agile Methodology, Elastic, FastAPI, Flask, Pandas.

- Developed and managed databases and data entry tasks, ensuring accuracy and efficiency. - Supported internal communication processes and managed departmental documentation.

Desde el departamento de GRC (Governance, Risk y Compliance): análisis e interpretación de datos en los proyectos de riesgo y cumplimiento, asegurando la comunicación de conceptos técnicos a partes interesadas no técnicas. Propuestas para el refuerzo de la digitalización de la empresa mediante la aplicación de modelos de ingeniería de datos.