r
ronaldomaldonad

Ronaldo R

@ronaldomaldonad

Data Engineer SQL, Oracle DW and Power BI Specialist

Brasile
Portoghese, Inglese
Alcune informazioni sono riportate in lingua inglese.
Chi sono
I design and rebuild data systems that companies depend on daily. I'm the sole data engineer behind a corporate data warehouse built from scratch: Oracle, Medallion architecture, Star Schema (Kimball), SCD Type 2. One optimization cut a critical execution cycle from 33 minutes to 4. What I do: fix and optimize SQL queries, design dimensional models for BI, build ETL/ELT pipelines with Python and Airflow, and turn raw data into Power BI dashboards executives actually use. If your database is slow or unreliable, message me with your case.... Continua a leggere

Competenze

r
ronaldomaldonad
Ronaldo R
offline • 

Consulta i miei servizi

Progettazione e ottimizzazione
I will fix, optimize or write sql queries for your database
A partire da15 USD / progettoMaggiori dettagli

Esperienza lavorativa

Expert_Restaurantes Empresariais Ltda

Data Engineer

Expert Restaurantes Empresariais Ltda • Full time

Mar 2026 - Present • 6 mos

Promoted to a technical role after structuring the data department from scratch, unifying 3 heterogeneous systems and eliminating 120 hours/month of manual work for 5 executive leaders. Designed and implemented the corporate DW from scratch, without a support team, using Medallion architecture (Bronze/Silver/Gold) on Oracle, applying Kimball methodology, Surrogate Keys, and SCD Type 2. Migrated orchestration from Pentaho to Apache Airflow (Docker), redesigning 111 tasks into a single DAG running 3x/day, reducing the DW cycle from 33 to 4 minutes. Implemented automated validations and load monitoring in pipelines, including failure handling and SCD consistency checks. Developed integration pipelines with 4 heterogeneous external sources, Zeev (REST API), PagBank (REST API), Uber (SFTP), and Universidade Expert, expanding the DW's analytical coverage to processes, payments, expenses, and training. Responsible for dashboards (Power BI, DAX) used daily by directors and managers, featuring payroll, costs, overtime, and turnover metrics. Processed millions of records with a focus on performance optimization. Key Technologies: Oracle, Apache Airflow, Docker, Medallion Architecture, Kimball, SCD Type 2, Power BI/DAX, REST APIs, SFTP