raphael palmer

Migration analytics: own end-to-end migration analytics (Snowflake, dbt, Airflow, Metabase) — cohort logic, account-owner readiness, and post-migration revenue/retention reporting for 1,600+ accounts.

Validation at scale: built and audited two large migration/cohort dashboards in Metabase with a full query-check validation pass across dbt models.

Automation: took over monthly lab-invoice automation and trained a business user to run it — projected six-figure annual savings.

AI-assisted tooling: apply Claude/Cursor agents to accelerate analytics work, and built an internal Slack command (n8n + dbt semantic layer) that surfaces metric definitions on demand.

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.