a solo-dev personal tech stack on a single oracle VPS — composed of traefik, dokploy, plain docker compose, and a homegrown lake of state files and event streams — orchestrated remotely from anywhere in the world via telegram and anthropic remote control. agentic memory and interface provided by claude, with scheduled digests and per-project state snapshots.
raphael palmer. data engineering & fullstack — 13 yrs, brasília.
Currently leading data engineering at Rupa Health / Fullscript — acquisition attribution, workflow automation, and invoice pipelines that saved hundreds of thousands annually. Post-acquisition data migrations across Snowflake, Looker, Streamlit.
Before that, a long arc through BI for pharma R&D (Pfizer, Merck via Edetek), industrial automation (Unilever, P&G via SMI), telecom (Claro, Sodexo), and the Brazilian public sector — Tableau, Power BI, Quicksight, OBIEE, the full Oracle stack. Started 2011 at a premium Oracle partner, never quite stopped.
This site is the side of the work that's mine — twelve services on a single box.
International contractor for Rupa Health — led data engineering projects to enhance acquisition channels attribution analysis and workflow automation using Python and Airflow, while handling ongoing ad-hoc analytics requests via Metabase and DBT SQL models.
Owned automation of invoice generation pipelines using Python, resulting in cost savings of hundreds of thousands of dollars annually.
After Rupa Health was acquired by Fullscript, focused on data migration projects to support users and platforms transitions — Snowflake, Streamlit, Looker, GitLab and adjacent tooling.
stackpython · airflow · dbt · snowflake · metabase · looker · streamlit · gitlab
Architected and developed a new Business Intelligence platform for clinical R&D / medical-industry company Edetek. Working with business analysts and data engineers, contributed a solution that aggregates diverse sources into customized dashboards — delivering faster, more reliable analytical insight to premier pharmaceutical clients including Pfizer and Merck.
Pipeline: AWS Redshift → AWS Quicksight dashboards, embedded into an Angular application. Later phase redesigned around D3.js custom charts, extending the platform's capabilities beyond conventional BI tools.
stackredshift · quicksight · angular · d3 · sql
Consultant engagement: enhanced the overall functionality of Tableau dashboards — workflow upgrades, bug fixes, UI redesign, interactive navigation. Applied data analysis best practices and Tableau internals to clean up and reorganize the implementation, leaving the client with a refreshed, high-performance dashboard suite.
stacktableau · sql · ETL
Developed sophisticated analytical dashboards for industrial engineering & automation company SMI. As Head of Data Visualization, owned dashboard customization with custom UI design and complex ETL logic, meeting the requirements of industry-leading clients like Unilever and P&G.
Built advanced Power BI dashboards reading from intricate Power Query ETL pipelines — providing detailed analysis of floor-plant product flow, individual machinery maintenance, and automated monitoring report generation via Power Apps.
stackpower bi · power query · power apps · sql server
Multiple projects across diverse sectors — from car-rental companies to large media agencies. Tailored dashboard construction and data visualization to distinct client needs using Tableau and Power BI, integrating data from AWS Redshift, MySQL, and Oracle.
stacktableau · power bi · redshift · mysql · oracle
Designed and deployed analytical dashboards for big-company clients — telecom giant Claro and cardholder Sodexo. Blended technical depth with client-facing finesse: led data visualization tasks end-to-end, including client interviews, dashboard design, data modeling, and semantic-layer maintenance.
stacktableau · oracle BIEE · power bi · sql server · looker · qlik sense
As Head of Data Visualization, collaborated on a robust BI solution for São Paulo's Public Ministry. Enhanced front-end UX and analytical capability through OBIEE, Oracle BICS, and Oracle Cloud Analytics.
Involved at every stage of the BI project lifecycle: information gathering, dashboard prototyping, scope definition, plus direct work on data modeling and ETL workflows in ODI, Oracle Database, and Weblogic Server. Materially improved internal workflow within the client's division.
stackobiee · oracle bics · oracle cloud analytics · odi · oracle db · weblogic
Worked across multiple projects and implementations — from architecting complex security solutions on Weblogic Server, to analytical dashboard development on OBIEE 12c.
stackweblogic · obiee 12c · oracle db
Five formative years at CDS, a premium Oracle partner — built seniority across a wide BI toolset: OBIEE 11/12, BICS, Data Visualization Desktop, ODI 11/12, Oracle Database, Oracle OLAP, Weblogic Server, Balsamiq, Administration Tools.
Specialized in complex OBIEE dashboards, visually customized to each client's identity. Led data-visualization teams on dozens of pioneering projects — including the first Oracle BICS implementation in Brazil at PGE, the TJSP data revolution and Oracle Suite implementation (database to dashboards), and complete OBIEE UX customization across SEFAZ-SC, SEFAZ-MA, SEFAZ-SP.
Project & team leadership for SEBRAE, VALEC, CAIXA, MEC, APEX, ALEP, TERRACAP, DATASUS, METROPLAN, TECBAN, and Grupo PAN.
stackobiee 11/12 · bics · odi · oracle db · oracle olap · weblogic · dv desktop
Bachelor's degree, Computer Engineering — Centro Universitário de Brasília.
Twelve services share one Oracle ARM box, fronted by Traefik with wildcard TLS, orchestrated by Dokploy, observed by a custom lake of state files and event streams.
The fleet runs lean — no Kubernetes, no managed databases, no analytics, no funnels. Every project on this page is something I use myself, or something I built to learn a tool I wanted to know better.