LucasLeal

Data Engineer

Data Architect / Technical Governance

4Data Driven - Technology and Engineering Division (TED):

• Implemented GitHub and code governance, avoiding previous version control via Google Drive
• Created a private Python library to accelerate project development
• Developed MVPs, reducing project maintenance time by 25%
• Developed a monitoring system for project executions and status using Python, Cron, SQL, Looker, and SH
• Wrote the documentation for the Data Map and Information Security Policy
• Standardized the SWOT analysis, documentation, and project health hub for requirements gathering and client alignment

MSD/Merck:

• Assisted in mapping needs and objectives to understand the company'sstandard requirements

---
Technologies: Python • SQL • Linux • Looker • Power BI • Git/GitHub • Cron/Crontab • VS Code • DBeaver • Loop • Teams • Collibra • SCRUM • Windows Server • UML

Data Engineer / Automation

Spotify (Brazil, Latin America) • 99 (Pay, Rides) • Renner • TENA • Tecban:

• Built solutions for extracting millions of public metrics from Instagram, TikTok, Twitter, and YouTube (likes, comms, shares...)
• Implemented methods for collecting retroactive metrics from hundreds of social media posts
• I developed integrations with social media, email reporting, and public platforms
• Automated ETL processes for adtech platforms (Brandwatch, Stilingue)
• Designed data ingestion routines and ensured data quality
• Designed medallion and dimensional architectures for data management
• Enabled Power BI and Looker reporting

---
Technologies: Python • SQL • GCP • BigQuery • Cloud Storage • Compute Engine • APIs • IAM • Requests • cURL/Wget • Web Scraping • Selenium • PyPi • Linux (CentOS)

Data Engineer / Cloud Architect

99 Rides • DiDi Global • Mercado Livre • Heineken:

• Managed Azure Data Factory and MongoDB ingestions
• Created data architecture for millions of records
• Star Schema dimensional modeling
• Tabular management with SSMS and SQL Server
• Procedure automation with T/SQL
• Data availability for BI and reporting

---
Technologies: Azure • Data Factory • MongoDB • SQL Server • SSMS • T/SQL • Python • Active Directory • DBeaver • VS Code • Windows Server

IT Assistant

Computer Resource Center (CRC):

• I managed over 5k users, controlled bandwidth, and handled the firewall using pfSense/The Dude
• Administered hundreds of Linux/Windows servers for the entire university
• Automated tasks using Bash/PowerShell
• I created a WhatsApp chatbot with NLP (Natural Language Processing) to improve customer service

---
Technologies: Firewall (pfSense) • Linux Servers • Windows Server • Linux (Mint, Debian) • TCP/IP Servers (The Dude) • Hardware & Software • Bash & PowerShell • UI • JavaScript

Academic Monitor - Computer Science

I assisted professors in theoretical and practical classes, laboratory work, and providing support to students with:

• Calculus • Hardware and Software • 3D Modeling • Algorithms and Data Structures...