// News
Hello, I'm

Flavio Calado

Data Specialist · Data Engineer · Data Scientist · Analytics Innovator · BI Architect

Turning raw data into decisions — across the full stack, from SQL pipelines to executive dashboards and intelligent automation.

Tech Stack

Data & AI

Python
SQL
OCI
Databricks
BigQuery
Prompt Eng.

BI & Visualization

Power BI
Fusion
NSAW
Looker
Tableau
QuickSight

Databases

Oracle
MySQL
PostgreSQL
SQL Server
SQLite
MongoDB

Cloud & Infra

AWS
Azure
Linux
Docker

ERP & Platform

NetSuite
Process Analyst
Data Arch.

Engineering

n8n
Git
Spark
Airflow
Hadoop
SQL Developer
Data Engineer
BI Strategy

How I Work

Snapshots of culture, challenges, and approaches from recent environments.

Oracle ERP Environment · NetSuite + Analytics · n8n · AISenior Data Engineer — 2024 – Present

Even with prior experience in AI, Oracle products, and emerging technologies, this is where process automation reaches another level, through pipelines and workflows using tools like Oracle Fusion, n8n, Celigo, Power Automate, and Airflow, just one piece of how we use generative AI daily to boost efficiency with OCRs, sentiment analysis, LLMs that consume documentation, and bots that support our teams, and it is not just about connecting data, but delivering value and integrity to the dashboards used across all departments.

Data Engineering · Databricks · BigData · SAS · SparkData Specialist | Data Scientist — 2021 – 2024

When it comes to high efficiency and security in the financial environment, this is where we manage and integrate the highest volume of data across systems using SAS, on-premise Big Data solutions, and Azure Databricks to migrate environments and develop not only dashboards but entire platforms that deliver the required level of accuracy, backed by documentation, optimal architecture, and modeled access for analysis and insights powered by SQL and PySpark scripts running in efficient pipelines.

Software Engineer · Web Developer · AWS · ETL · BI & AnalyticsSoftware Engineer — 2019 – 2021

In a highly analytical project for a popular online publisher, a cloud BI solution was built from scratch, blending Google Cloud products with AWS architecture where the ETL (AWS Glue) efficiently retrieved streaming data from AWS Athena to generate powerful insights for ad campaigns and manage the internal CRM, with visualizations primarily in Looker Studio and Amazon QuickSight, plus integrations with NetSuite Invoices and globally recognized recurring payment platforms such as Hotmart and Vindi.

Projects

Oracle NetSuite Analytics Warehouse Governance Layer

Designed and deployed a multi-subject-area NSAW schema with row-level security, automated refresh schedules, and a self-service semantic layer used by 40+ stakeholders.

  • Oracle NSAW
  • Oracle Fusion
  • SQL
  • Data Modeling
  • NetSuite
  • Prompt Engineering

Multi-Source Cloud Data Integration

Python-based ELT pipeline pulling from REST APIs (Amazon Seller API, Shopify, FedEx, BambooHR, 8x8, NetSuite API, Salesforce CRM API) into both MySQL and Oracle warehouses. Incremental loads, idempotent inserts, and alerts on failure.

  • Python
  • SQL
  • MySQL
  • REST APIs
  • Oracle
  • Cloud Solution
  • n8n
  • Power Apps
  • Generative AI

Data Migration from OnPremisse Solution to Azure Databricks

Documented all rules from the source and recreate the entire process of migrating data from an on-premise solution to Azure Databricks.

  • Spark
  • SQL
  • SAS
  • BigData
  • Airflow

Executive KPIs Dashboard Suite

End to end design of a C level dashboard suite from data model to visual language covering Sales, Credit Recovery, Planning, Operations, Supply, and Finance domains with drill through and what if parameters.

  • Power BI
  • Looker Studio
  • Amazon Quick Sight
  • Oracle Fusion
  • Oracle NSAW
  • SQL
  • Data Architecture
  • Python
  • Generative AI

Latest in Data & AI

Get in Touch

Have a data challenge, a BI project, or just want to talk AI? Send a message.

Or reach me directly at contact@fcalado.com