
Fabio Bressler
Verified Expert in Engineering
Data Engineer and Developer
Porto Alegre - State of Rio Grande do Sul, Brazil
Toptal member since June 24, 2020
Backed by an MBA in strategic leadership for business, Fabio is a certified blockchain expert with a professional development and architecture background. He brings several years of experience in database modeling, data handling, and performance tuning related to data ingestion and extraction, along with blockchain data design and implementation. Furthermore, Fabio specializes in AWS cloud architecture—being a fan of cheaper serverless implementation and infrastructure as code deployments.
Portfolio
Experience
- SQL - 20 years
- Data Engineering - 20 years
- Relational Databases - 20 years
- Database Architecture - 20 years
- SQL Stored Procedures - 15 years
- ETL - 10 years
- PostgreSQL - 6 years
- Data Build Tool (dbt) - 4 years
Availability
Preferred Environment
Database Architecture, Data Architecture, Amazon Web Services (AWS), SQL, Solidity, TypeScript, Blockchain, PostgreSQL, Serverless, Infrastructure as Code (IaC)
The most amazing...
...thing I've built recently from design to implementation is a full database and back-end app to store, calculate, and retrieve crypto wallet risk score analysis.
Work Experience
Senior Data Engineer and Data Architect
Foothold Technology
- Handled PostgreSQL data structures for schema conformance on 470+ databases with application roadmap rollout alignment.
- Implemented PostgreSQL replication with IaC using Pulumi, Ansible, and Fivetran for a faster and more reliable analytics ELT pipeline.
- Organized and reviewed the analytics data pipeline design with activity dependencies. Aligned with the product and application teams on the OLTP source side for pre-transformation adjustments for a better sequence rollout of the pipeline.
- Reviewed the analytics data build tool (dbt) transformation process and suggested changes for better automation while migrating from the old to a newer enhanced process.
Senior Blockchain Data and Back-end Solutions Architect
Webacy Inc.
- Defined and implemented data structures for a back-end application for crypto wallet risk analysis and PostgreSQL infrastructure and statements for fast bulk insert of blockchain transactions and their related metadata.
- Defined and implemented back-end code to store and retrieve on/off-chain risk data for crypto wallet holders, merging multiple data sources and proprietary risk analysis into a single data schema for several ways to expose it from API endpoints.
- Created better code rollout automation for multi-environment deployment stages from development to production and GitHub Actions to handle validations and code build and push into AWS private registry aiming Git branch-related stages.
- Used AWS CDK v2 for fault-tolerant infrastructure stack deployment and maintenance through code (IaC) to spin up a production-like environment from scratch from a single CLI command or GitHub Action.
- Created Slack command actions for relevant information for the marketing team to get statistics on risk score API usage and created other scheduled AWS Lambda handled services to monitor and report application usage.
Lead Pipeline Data Extraction/Analytics Engineer
Measure Protocol Limited
- Orchestrated and developed pipeline data extraction modules for major tech data providers (Google, Meta, TikTok) sources and ensured data standardization for analytics generation.
- Performed continuous alignment with leadership to ensure correctness, align next-step improvements, and suggest data quality on the raw data to be transformed.
- Implemented tests to ensure code execution conformance and maintain quality control in data extraction processes.
Senior Blockchain Data Engineer and Solutions Architect
Nethermind
- Built an end-to-end blockchain data app for opportunity trading analysis for decentralized finance lending and borrowing pools, handling data, test suites for validation, orchestration (Airflow), and deployment to cloud environments.
- Led team in software release best practices, test code coverage, and GitHub automation pipeline validations. Instructed on data handling practices to prevent future bottlenecks, optimizing targeted data products for future commercial opportunities.
- Provided consulting and overall systems design on company internal products like pipeline data extractions for HR, data structure refactoring for best performance, and data usage and AWS serverless implementation guidelines.
Principal Technology Architect (CTO Group)
ADP
- Oversaw and implemented a successful integration of a large-scale Influx data pipeline to PostgreSQL data structures; built a GraphQL layer for enhanced API data outputs and application performance for the entire company's CI/CD internal processes.
- Led the implementation of software development best practices, testing strategies, coverage analysis, automation processes, and deployment procedures, aligning with the company's digital transformation objectives over legacy development processes.
- Collaborated directly with the company's headquarters CTO group to assess and communicate the organization's maturity level in several areas, providing visibility to C-level through custom implementation dashboards.
Database Architect and Back-end Solutions Architect
Inveniam Capital Partners, Inc.
- Delivered the requested technical documentation and action plan for a blockchain app architecture with client onboarding, blockchain oracle node integration (Chainlink and API3 Airnode), and marketplace for client data focused on real estate.
- Implemented a Web3 end-to-end POC application for building air quality IoT data persisted on-chain as certificates using Ethereum testnet with the tech stack Solidity, TypeScript, Ethers.js, and Hardhat.
- Handled the creation of serverless API using the AWS stack (with API Gateway and Lambda code) as a real estate challenge for a Chainlink hackathon, including usage instructions for the event.
- Initiated a project to automate off-chain integration with Oracle nodes using the open source API3 Airnode stack and onboard the clients on real estate tokenization. A spin-off was later absorbed by the main corporation.
Database Expert and Integrations Specialist
Seaber Oy
- Ensured application security by implementing row-level security on PostgreSQL to enable proper data visualization and enhanced performance for application clients/users. Also created an audit process for compliance reporting.
- Identified database performance bottlenecks, adjusted indexes to remediate such issues, and added automated checks to the existing CI automation pipeline to prevent future performance gaps from coming into the application rollout process.
- Planned and implemented a back-end API integration with external partners using TypeScript and GraphQL to fetch and load data into the application database.
- Implemented a web scraper using Python for open source ship data information and loaded into a side data store for fast validation of application inputs.
Technical/People Leader and Software Architect
ADP
- Managed a cross-country, 16-member team for the corporate reporting tool integration, bringing more organization and improvements on legacy application components into containerization and microservices with better deployment process automation.
- Served as the technical architect and engaged the team in following best practices on componentization for cloud readiness, breaking down monoliths per each integration module, and following microservices decoupling with API-first design.
- Oversaw the data streaming system evolution to deliver better orchestration on fast data handling of systems data and metadata and provided architectural design recommendations for developers to achieve the best performance results in data refreshes.
- Engaged with the corporate custom reporting application team for lift and shift databases to AWS cloud infrastructure as the first step for application modernization using AWS CloudFormation to handle it as IaC.
Data Engineer/DBA and SQL Expert
ADP
- Optimized very large data reports for enterprise ADP clients, resulting in 99% performance improvement on multiple use cases by rewriting custom-built SQL on demand.
- Identified and resolved application query bottlenecks, implementing modifications like indexing, data arrangements, and clean-ups for successful application enhancements rollout.
- Performed database administration engagements like cloning, backup, restorations, and data optimization by transposing specific modules to better-suited structures.
- Engaged with the corporate custom reporting application team for lift and shift databases to AWS cloud infrastructure as the first step for application modernization using AWS Cloud Formation to handle it as IaC.
Lead Data Engineer and Back-end Developer
ADP
- Led a team of developers in designing and implementing a data and metadata integration process as an entry point for the main reporting application and helped evolve integration handling with version control and automated data sync processes.
- Implemented complex Java/Oracle database ticketing interactions to process asynchronous SOAP calls for heavy back-end calculations on external systems.
- Oversaw software evolution and team performance evaluation, accommodating more integration partners for the reporting tool integrations, handling multiple data transformations, and handling each use case scope.
Data Engineer and Back-end Developer
ADP
- Developed an application to manage the metadata catalog for external systems to be integrated with a reporting system.
- Tracked and fixed bugs logged into a clear quest tool for the main system.
- Synchronized the application version upgrades along with metadata mapping for external applications integrating version upgrades, dealing with multiple integration scenarios for the reporting application to work successfully.
System Analyst | QA
ADP
- Analyzed the requirements needed by the pre-employment screening system in the development stage and engaged developers in coding properly according to the business rules.
- Helped with database definitions and relationships to accommodate proper table structures and relationships.
- Contributed to QA activity, helping to capture defects or missing requirements to enhance and evolve the application.
Developer
UNISINOS
- Collaborated on building the university website using PHP and scripting for content management.
- Built a distance learning environment for university classes using Perl scripting and a PostgreSQL database.
- Made a web file storage system for students that enabled their files to be available from everywhere using Perl scripting and server storage management.
- Integrated company system of records on PeopleSoft ERP as part of the new structure implementations.
Experience
Data Streaming Application
As a result, it automated the dynamic event-driven application in the same pattern as other reporting integrations.
Custom Reporting Application
https://support.adp.com/adp_payroll/content/hybrid/VerA/@runcomplete/doc/pdf/Custom_Reports_How_to_Guide.pdfI also enhanced the capability to handle multiple systems of record integrations with version control and deployment script automation.
Crypto Pools Dashboard Analytics
I delivered a high-quality data extraction application with release version management, full coverage tests, cloud deployment, and dashboard dynamic view.
Pattern Data Extraction Modules
I also handed over testable modules to be loaded into a larger framework for mass data extractions for further pattern-finding analysis.
Crypto Wallet Risk Full Back-end Service
https://www.webacy.com/I also added another revenue stream from API pricing offerings.
Analytics Data Pipeline Revamp
I completed database adjustments and enabled data replication to the target data warehouse with a 15-minute latency, overcoming previous replication nightly jobs.
Education
Master of Business Administration Degree in Strategic Leadership
The Superior School of Advertising and Marketing (ESPM) - Porto Alegre, Rio Grande do Sul, Brazil
Bachelor of Science Degree in Computer Science
The University of the Sinos Valley (UNISINOS) - São Leopoldo, Rio Grande do Sul, Brazil
Certifications
The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero
Udemy
ClickHouse – A Fast Open-source OLAP DBMS
Udemy
AWS Certified Data Engineer
Amazon Web Services
Dbt: Crie e Execute Pipelines de Engenharia de Dados
Udemy
Machine Learning A-Z: Al, Python & R + ChatGPT
Udemy
HIPAA Training
Proofpoint, Inc.
Formação Data Warehouse com Redshift, BigQuery e SnowFlake
Udemy
Build a Secure Data Lake in AWS using AWS Lake Formation
Udemy
Certified Blockchain Expert
Blockchain Council
Ethereum and Solidity — The Complete Developers Guide
Udemy
The Complete Node.js Developer Course (Third Edition)
Udemy
Oracle Database 12c: Install & Administration
Oracle University
Agile Project Management (Scrum)
ADP In-house
Skills
Libraries/APIs
Pandas, REST APIs, Node.js, NumPy, SQLAlchemy, Web3.js
Tools
Microsoft Excel, GitHub, Excel 2016, Bitbucket, Git, Apache Airflow, Amazon Athena, Amazon CloudWatch, Sqitch, Jenkins, Apache, Erwin, AWS CloudFormation, AWS Glue, Retool, Notion, Amazon Elastic MapReduce (EMR), Amazon EKS, AWS IAM, Amazon Virtual Private Cloud (VPC), BigQuery, Terraform, dbt Cloud, Prisma, AWS Cloud Development Kit (CDK), Amazon Elastic Container Service (ECS), AWS Step Functions, Amazon Simple Queue Service (SQS), Grafana, Google Sheets, Amazon Elastic Container Registry (ECR), Tableau
Languages
SQL, Python, TypeScript, XML, HTML, JavaScript, Snowflake, PHP, Java, Perl, Stored Procedure, Solidity, GraphQL, ECMAScript (ES6)
Paradigms
ETL, Database Design, Data-driven Design, Scrum, Agile, Agile Project Management, Business Intelligence (BI), DevOps, REST, Microservices, Management, Good Clinical Practice (GCP), Dimensional Modeling, HIPAA Compliance, Oracle Database Architecture
Platforms
Linux, Docker, Oracle, Amazon Web Services (AWS), Windows, Blockchain, Google Cloud Platform (GCP), Amazon EC2, Oracle Database, Ethereum, AWS Lambda, Blockchain Platforms, Apache Kafka, Kubernetes
Storage
Oracle PL/SQL, PostgreSQL, Database Modeling, Database Transactions, Relational Databases, SQL Stored Procedures, Oracle RDBMS, Databases, Database Architecture, SQL Performance, Data Integration, Amazon S3 (AWS S3), RDBMS, JSON, Database Structure, Database Performance, SQL Triggers, Oracle DBA, MySQL, Database Triggers, Amazon Aurora, API Databases, Redis, Data Lakes, MongoDB, PL/SQL, Database Administration (DBA), Amazon DynamoDB, Data Pipelines, NoSQL, Redshift, InfluxDB, ClickHouse
Frameworks
Flask, Spark, Apache Spark
Other
Shell Scripting, Data Engineering, Query Optimization, Debugging, Data Analysis, Data Modeling, Data Architecture, APIs, Data Processing, Scripting, ADP, Data Migration, ETL Tools, Scripting Languages, Data Warehouse Design, Data Warehousing, Architecture, Relational Database Services (RDS), PL/SQL Tuning, Unix Shell Scripting, CI/CD Pipelines, Data Transformation, Transactions, Data, ELT, API Design, Slack App, Performance Optimization, Technical Leadership, Performance, Deployment, Solutioning, Custom Solutions, Data Feeds, Business Requirements, System Architecture, Data Structures, Software, Software Architecture, Product Delivery, Business Analysis, Reports, Large Data Sets, API Integration, Back-end, Technical Design, Technical Drawing, Database Optimization, IT Business Analysis, Ethers.js, Amazon RDS, Data Processing Automation, CSV, System Design, Server Migration, BPM, Scalability, Big Data, Message Queues, Exploratory Data Analysis, Data Science, Networks, Web Scraping, Data Build Tool (dbt), Crypto, Serverless, Supabase, GitHub Actions, Data Analytics, Data Warehouse Testing, Data Scraping, Dashboards, Data Mining, Quality Assurance (QA), Analysis, Performance Tuning, AWS Cloud Architecture, Leadership, Business, Data Visualization, AWS Lake Formation, Statistics, Google BigQuery, Telemetry, Big Data Architecture, Infrastructure as Code (IaC), Cryptocurrency, Pulumi, Fivetran, ECS, OpenID Connect (OIDC), Star Schema, Data Reporting, Reliability, CTO, HIPAA Electronic Data Interchange (EDI), Amazon Kinesis, Amazon Managed Workflows for Apache Airflow (MWAA), AWS Secrets Manager, PeopleSoft, System Integration, Machine Learning, Artificial Intelligence (AI), Amazon Redshift, Data Strategy, Parquet, Dagster
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring