◈DATA ENGINEERING·DBT·LLM·CI
Olist Customer Intelligence
end-to-end batch platform / verifiable claims
A batch platform over the Brazilian e-commerce dataset: time-sliced replay into BigQuery, dbt marts with Type 2 history and an as-of join, LLM review enrichment, and a natural-language-to-SQL agent behind a parsed SQL guard and a budget priced before the call. One dbt codebase, two warehouses.
ONE FAILURE MODE, FOURTEEN TIMES
The README is generated from the data, and it catalogues fourteen bugs that shared one shape: a status reported by something other than the thing being measured. The DuckDB runner ships with a startup self-attack that tries the attacks and raises if any of them succeed.
dbtDuckDBBigQueryAirflowTerraformGeminisqlglotStreamlitGitHub Actions
Enterprise Data Warehouse
PostgreSQL / integration core
3NF integration core plus dimensional marts, loaded by PL/pgSQL ETL with validation and referential-integrity enforcement, documented with architecture diagrams, data-flow and model specifications.
PostgreSQLPL/pgSQLETL3NFStar schemaSnowflake schema
Financial Performance Dashboard
Power BI / executive analytics
Multi-entity financial dashboard covering the income statement, balance sheet and executive KPIs, with MTD/YTD reporting and benchmark analysis against budget and prior year across profitability, assets, liabilities and G&A expenses.
PostgreSQLPower BIDAXPower QueryStar schemaTime intelligence
▨DATA MART·POWER BI·STAR SCHEMA
Sales Analytics Data Mart
star schema / commercial insight
Star-schema mart and executive dashboard covering revenue, profit, customer behaviour and payment analytics, with drill-through by geography, product category and seller.
Power BIDAXPower QueryPostgreSQLStar schema
IUT Community Platform
backend & data
Designed the relational schema behind multiple university services and built Airflow-orchestrated background data workflows across relational and document stores, in a multi-developer Agile team.
FastAPIPostgreSQLMongoDBRedisRabbitMQAirflowDocker