Description

Technical Data Analyst with expertise in SQL, Python, and ETL processes, delivering scalable data solutions and automated pipelines. Achieved 25% faster project timelines and 60% improved data processing efficiency. Consolidated tasks with 80% efficiency improvements, enhancing backend workflows. Developed Power BI dashboards and Big Data solutions to support decision-making. I am passionate about solving complex data challenges and transforming raw information into actionable insights

Industry field of expertise

Languages

Portuguese
Native or bilingual
Dutch
Basic
English
Conversational

Workplace preferences

Can work on-site

Amsterdam (up to 50km)

Banco do Nordeste do Brasil - BNB
Business Intelligence and ETL Developer
January 2021 - June 2023 (2 years and 5 months)
Fortaleza - Ceará, Brazil
• Improved English and Dutch skills by attending courses.
• Earned Microsoft certifications: AZ-900 and PL-300.
• Completed online technical courses (Azure, Python, Bash Linux, Advanced SQL, Databricks).
• Volunteering as a PHP web developer at Watkanikdoen.nl, contributing to community-driven projects.

Business Intelligence and ETL Developer - Banco do Nordeste do Brasil – BNB, Fortaleza, Brazil
Jan 2021 – Jun 2023

• Designed and implemented data modeling and ETL workflows to calculate a Risk Indicator required for deploying the newly acquired Market and Capital Risk management system, which resulted in a 30% increase in Operational Efficiency KPIs in the following quarter.
• Developed and tested ETL workflows to integrate 15 legacy system tables into the new ERP system for Human Resources, completing 100% of planned jobs and deploying 40% to production within two weeks, ensuring seamless data migration and meeting critical project deadlines.
• Designed and implemented a centralized tracking solution by integrating tasks from Azure Kanban, RTC business requests, and Service Orders into a Power BI dashboard, improving communication and negotiation with stakeholders and increasing the on-time completion rate of business demands by 20% within two months.
• Orchestrated the development of a Power BI solution for lead management, consolidating data from multiple sources. Achieved 40% lead database effectiveness in the first month, optimizing contacts and business opportunities.
• Collaborated in the development of a Power BI solution to download, process, and analyze nationwide survey data, replacing inefficient legacy workflows with Python (Pyodbc, psycopg2, zipfile, Pandas, Numpy), DataStage, and PostgreSQL within a Dockerized Linux environment. Improved data automation and processing efficiency, achieving a 60% reduction in data manipulation time.
BNB
CDD Analyst for Credit Risk Analysis
January 2020 - January 2021 (1 year)
Fortaleza - Ceará, Brazil
• Evaluated and approved a 200,000 reais credit proposal for a food distribution company during the pandemic, ensuring compliance, repayment capacity, and collateral adequacy. This contributed to 30% of the agency's monthly credit target and enabled the client to acquire a new truck.
• Conducted a thorough analysis of corporate constitutive documents for a medium-sized business, enabling the proposal to advance to the credit committee in just 2 days, compared to the expected 10, achieving an 80% improvement in credit approval time.
• Prepared a detailed technical report based on internal regulations, supporting the approval of a BNB investment card of R$ 500,000 for a medium-sized textile company. My analysis focused on compliance with internal guidelines, ensuring risk mitigation for the bank and facilitating the client's production capacity expansion by 25%
• Conducted a technical analysis for a R$ 300K credit operation, validating a R$ 20M property as collateral. Ensured legal compliance and risk mitigation while confirming the asset's capacity to support an existing R$ 2M operation and the new proposal.
Banco do Nordeste do Brasil - BNB
Business Intelligence and ETL Developer
October 2010 - January 2020 (9 years and 3 months)
Fortaleza - Ceará, Brazil
• Implemented a Balanced Scorecard-aligned Data Mart, improving KPI tracking and boosting branches exceeding expected results by 25% within six months,using IBM Cognos 10 Tools(Data Manager, Cognos Framework) and MSSQL to build.
• Designed and deployed ETL workflows to support profitability calculations, improving accuracy by 40%, using IBM Cognos 10 Tools(Data Manager, Cognos Framework) and MSSQL to build.
• Developed a profitability analysis Cube using Cognos Framework Manager, Cognos Transformer, and SQL Server, enabling detailed tracking of net margin (%) by customer, product, and branch. Delivered a 10% increase in overall profitability within six months of implementation.