ING Bank - Amsterdam NetherlandsData Engineer Project / Allocation: CRLT - Data Mart - Loan Tape ProjectDate: Feb 2024 – PresentIn my role at ING Bank, I was responsible for designing and implementing a data pipeline to manage critical loan data (Loan Tape) from multiple banking systems, including Vortex. I led the development of automated data flows and pipelines using Azure Data Factory and CI/CD practices to ensure seamless data ingestion and transformation into a Postgres data mart.Key contributions include:Designing end-to-end data flows for Entity, Instrument, and Protection data, following the Loan Tape concept.Implementing CI/CD for streamlined pipeline deployment, ensuring continuous integration and automated testing.Loading and structuring data in Postgres to support analytics, reporting, and compliance requirements for the bank’s loan portfolio.NZA New Zealand Auckland – Amsterdam NetherlandsData EngineerProject: Microsoft Fabric Implementation : Sales, Traffic, and Stock Data Automation ProjectDec 2023 – February 2024At NZA, I played a key role in the automation of data loading prodata-loadingales, traffic, and stock data using Microsoft Fabric. This project was focused on increasing data processing efficiency and enabling real-time insights into key business operations.Key achievements:Implemented automated data pipelines using Microsoft Fabric, improving the accuracy and timeliness of data ingestion.Automated the loading of large datasets related to sales, traffic, and stock, reducing manual intervention and enabling real-time reporting.Improved data accessibility and visualization, leading to faster decision-making across various departments.

As an Azure Data Engineer, I specialized in developing robust data pipelines within the Azure ecosystem, empowering data-driven decision-making and enhancing business operations. My role encompassed the following key expertise:Azure Data Factory: Proficient in designing data pipelines for data quality and transformation.Databricks: Leveraged Azure Databricks for real-time data processing, machine learning, and data exploration.Data Transformation: Spearheaded data transformation, refining raw data into valuable insights.Medallion Architecture: Implemented a robust framework for structured data processing and analytics.DevOps: Ensured seamless integration and automation of data pipelines.ETL (Extract, Transform, Load): Designed and optimized ETL processes.Data Sources: Successfully integrated data from diverse sources, including SAP, flat files, SharePoint, and APIs.Data Lake: Managed and optimized data lakes for efficient data storage and retrieval.

Data Engineer, Azure Business Intelligence Full Stack Developer, Power BI Developer , SQL Server / Oracle Data Base DeveloperSolid experience in data modeling using SSAS tabular cube and multidimensional cube technologyExpertise in database technology with solid understanding and hands-on skills with SQL, T-SQL, SSISExperience with Cloudera, Hive , Impala , HDFS , Apache Spark and PythonExperience in large-scale clients and projects such as Cargill , Johnson & Johnson , Roche

Data Engineer specializing in ETL processes for extracting and transforming data from diverse sources using Python , SQL , HadoopProficient in developing structured queries utilizing various SQL/NoSQL data sources.Experienced in extracting, organizing, and modeling data within the Cloudera Big Data environment, including IMPALA, HIVE, HUE, and HDFS.Skilled in creating dynamic dashboards and paginated reports using MS Power BI and Power BI Report Builder.Proficient in crafting queries for various databases, including SQL SERVER, ORACLE, and PDW.Focused on the areas of Fraud, Risk, and Abuse Prevention, ensuring data quality and making informed decisions.

Support and Monitoring of various BI environments, handling service calls and improvement requests using SQL Server, SSIS, and SSAS.Monitoring and supporting incremental BI load processes.Development and maintenance of ETL projects for incremental BI loads using SQL Server Integration Services (2008/2012/2014/2016).Development of functional documentation for ETL / Business Intelligence projects.Development of loading procedures for Data Warehouse and Data Mart in SQL Server (2012/2014/2016).Multidimensional Data Modeling (Star Schema) with SSAS.MDX in SSAS: Proficient in creating complex queries and calculations.DAX in Power BI: Skilled in developing custom calculations and visualizations.SSIS Expertise: Comprehensive knowledge of developing, maintaining, and troubleshooting ETL processes.

Development and maintenance of ETL projects for incremental BI loads using SQL Server Integration Services (2008/2012/2014/2016).Development of functional documentation for ETL / Business Intelligence projects.Development of loading procedures for Data Warehouse and Data Mart in SQL Server (2012/2014/2016).Multidimensional Data Modeling with SSAS.Development of dashboards and analytical reports using SQL Server Report Builder, SQL Server Reporting Services, SQL Server Mobile Report Publisher 2016 (DataZen), SSRS Web Portal, and MS Power BI.Maintenance and development of Business Intelligence solutions using the Microsoft BI Stack: SQL Server (2005 to 2016), SSIS (Integration Services), SSRS (Reporting Services), SSAS (Analysis Services), and MS Power BI.

Over 5 years of experience working as a Business Intelligence developer in agile teams. Great ability developing BI solutions with rich user-friendly interfaces, advanced dynamic reports, and custom rendering components. Recently, as a Business Intelligence developer for an investment bank (Banco Safra SA.) located in São Paulo building dashboards and complex reports solutions using Microsoft Business Intelligence Stack such as SSRS 2016, SSIS, SQL Server, SSAS and Power BI consuming data from Microsoft SQL Server and other databases sources.

Maintenance and Development of Business Intelligence solutions using Microsoft technologies (versions 2008, 2012, 2014) and tools such as SSIS (Integration Services), SSRS (Reporting Services), and SSAS (Analysis Services).Development of Graphical Dashboards and Analytical Reports utilizing MS Power BI Desktop and Reporting Services Mobile Publisher.Support Ticket Management for Business Intelligence and SharePoint solutions.Implementation of Cloud Infrastructure on Azure, including Virtual Machines configuration, Cloud Services, Azure SQL Database, and migrating on-premises databases to Azure DB Cloud.Configuration of Azure AD for organizational use, SQL Server authentication, and SharePoint.Administration of Office 365 Portal.Development and Maintenance of BI/SharePoint solutions for large clients such as Coca-Cola (FEMSA), Grupo Odebrecht, and Heineken.Development and Maintenance of Business Intelligence solutions for global clients, such as Price Waterhouse Coopers, providing bilingual support to clients in Australia.Administration of SharePoint solutions (2007, 2010, and 2013), including permissions management, user maintenance, and governance of lists and libraries.Maintenance and Development of Business Intelligence solutions using Microsoft technologies (versions 2008, 2012, 2014) with tools like Integration Services, Reporting Services, and Analysis Services.

B3 - Brazilian Stock Exchange -Alocação Física-Desenvolvimento de procedures e queries para utilização em rotinas de ETL em MS SQL 2005,2008R2 e 2012Desenvolvimento e manutenção de pacotes utilizando MS Integration Services 2005,2008 e 2012Elaboração de especificação técnica/funcional de projetos ETL.Desenvolvimento de soluções ETL para carga de Data WarehouseImplantação de pacotes e subida para ambientes de homologação e produçãoElaboração , customização e analises de relatórios de negócios utilizando SSRS ( Reporting Services).

Administração e manutenção de sistema proprio ERP (Depto. Pessoal, Vendas, Financeiro)Desenvolvimento de queries para consultas em banco de dados SQL Server 2008R2 Administração, criação e atualização de banco de dadosExtração de relatórios customizados utilizando ferramenta Microsoft Reporting ServicesAdministração de rede local, login, privilégios, acessos e permissões

Suporte técnico de informática nível 1,2 e 3 aos alunos e staffing da universidadeAdministração da rede interna utilizando Active Directory, atualizando logins e senhas, disponibilizando dados e garantindo privilégios de sistemas e rede interna.Instalação, manutenção e suporte de softwares e periféricos em geral

Coordenação da área técnica de informática em geralImplementação e customização do sistema administrativo ERP (Compras, Vendas, Financeiro)Manutenção e instalação de computadores e perifericos em geralAdministração de banco de dados com MS SQL2005Extração de relatórios customizados utilizando ferramenta Crystal Reports e SSRSAdministração de rede local, login, privilegios, acessos e permissõesPlanejamento e elaboração de novos projetos e implantação de processos de tecnologia.Suporte técnico e treinamento aos usuários de sistema e redeInstalação, manutenção e suporte de software e hardware