🇺🇸 English | 🇧🇷 Português
Data professional with experience in Business Intelligence, Analytics, and Process Automation, specializing in dashboard development, data modeling, ETL processes, and automation solutions for commercial and operational teams.
Currently, I work at Grupo Condumax | Incesa, developing solutions using Power BI, SQL, Power Query, VBA, and Python to transform data into strategic insights that support business decision-making.
Over the past year, I have been transitioning my career toward Data Engineering, building personal projects with Databricks, PySpark, and Microsoft Fabric while applying modern concepts of data architecture, ETL/ELT pipelines, and Data Warehousing.
- Data Engineering
- Apache Spark
- Databricks
- Python
- AWS
- Git
- Apache Hop
- Cloud Computing
- Linux
- Networking
- Docker
- Medallion Architecture
- Data Quality
- 🚀 Experience in Business Intelligence and Analytics
- 📈 Development of strategic Power BI dashboards
- 🛢️ SQL development, data modeling, and ETL processes
- ⚡ Process automation using Python, VBA, Power Automate, and n8n
- 📦 Building solutions aligned with Data Engineering concepts
- 📚 Continuous learning in Databricks, Apache Spark, and Microsoft Fabric
✔️ Power BI dashboard development
✔️ Dimensional data modeling
✔️ ETL / ELT processes
✔️ SQL development
✔️ Power Query transformations
✔️ Python automation
✔️ VBA solutions for enterprise processes
✔️ Systems integration
✔️ Business Intelligence solutions
Enterprise dashboard designed for both strategic and operational monitoring, used daily by managers and executives to track key business and sales performance indicators.
Beyond executive reporting, the solution supports the operations team by monitoring the sales order backlog, revenue, delivery lead times, and operational performance, enabling faster, data-driven decision-making.
The project is continuously evolving, with new KPIs, reports, and features being added according to business needs.
Stack
Power BI • SQL • DAX • Power Query
Automation built with n8n to streamline the processing of sales orders received via email.
The workflow automatically monitors incoming emails, identifies purchase orders, extracts information from PDF files using Artificial Intelligence, validates the extracted data, and executes a customized report in the Protheus ERP. The report was designed to replicate the native ERP interface, making order validation and processing easier for the commercial team.
Stack
n8n • Python • Artificial Intelligence • Outlook • PDF Extraction • Protheus ERP
Operational dashboard developed to monitor the sales order backlog, providing visibility into open orders, delivery lead times, delays, bottlenecks, and commercial and logistics performance indicators.
The solution is actively used by the operations team as a management tool and is continuously improved with new KPIs, analyses, and business metrics.
Stack
Power BI • SQL • DAX • Power Query
Personal learning environment dedicated to developing Data Engineering projects while exploring modern concepts such as data architecture, ETL/ELT pipelines, distributed processing, and the Medallion Architecture.
Stack
Databricks • PySpark • Microsoft Fabric
🐙 GitHub: https://github.com/gabriel-melo2