Senior Data Engineer

8/2024 – 1/2025

Coordinated the migration and restructuring of the Data Warehouse from Redshift to Snowflake. Implemented automated ingestion pipelines with Fivetran and utilized Coalesce for incremental data modeling, integrating Git-based workflows to ensure version control and efficient production deployments.

Git, Google Cloud, Snowflake

1/2024 – 7/2024

Developed a dynamic data model in Azure SQL Database capable of generating the application's schema on the fly based on definitions received via the UI, enabling SQL code independence for end-users. Designed the model to handle DML (Data Manipulation Language) instructions dynamically.

Built Power BI dashboards to provide graphical visualization of the ingested data in the application, delivering key insights regarding RPO (Recovery Point Objective) and RTO (Recovery Time Objective).

Microsoft Azure, Power Bi, SQL

8/2023 – 12/2023

Developed database objects (tables, views, stored procedures, TVFs, and scalar functions) in SQL Server to optimize the recording and consumption of inventory movement data. Ensured transactional integrity for all warehouse stock operations.

Microsoft SQL-Server (MS SQL)

4/2022 – 3/2023

Developed tables and stored procedures in Oracle 11g to handle data ingestion from IBM BPM. Implemented logic to parse incoming JSON parameters and generate structured JSON responses, maintaining complex entity hierarchies to ensure seamless integration with the application layer.

SQL

4/2019 – 4/2022

Member of the design and development staff for the Data Warehouse area. My core responsibilities centered on aligning business requirements with technical execution and ensuring high-performance data processing. Next are the main activities I developed:

- Addressed stakeholder needs regarding new initiatives and regulatory mandates.
- Monitored the ongoing development of active projects to ensure delivery.
- Designed data flows in strict compliance with organizational Data Governance standards and complex business rules.
- Provided technical support to IT operational areas to resolve inconsistencies in regulatory reporting.
- Developed high-performance objects, optimizing SAP HANA queries and Informatica PowerCenter (IPC) workflows.
- Generated comprehensive technical documentation for both design and operational teams.

Data Warehousing, Governance, Informatica, SAP HANA, Technische Dokumentation, Unix-Administrator

8/2016 – 2/2017

Implemented survey data processing using NVIVO11 to provide a detailed analysis of participants in a national SME (Small and Medium Enterprises) program. Built visualization charts by categorizing results through string-matching algorithms, facilitating a clear and rapid understanding of the survey outcomes for stakeholders.

Data Analyst