You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Léo MendesLM

Léo Mendes

Data Analyst

€145/day
Valencia, ES
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Léo

Hello! :) I'm Léo, a Data Professional with a solid background in Software Development and Business Intelligence (BI). I have proven experience in multi-billion dollar companies in the Industrial and Retail sectors.
• Technical Specialties: Extensive hands-on experience with the technology stack: Python, SQL, Snowflake, PostgreSQL, MySQL, Power BI, QlikSense, Excel, Google Sheets, Power Automate, Office Scripts, and a solid 5-year track record working with VBA.
• Key Results: Optimization of critical processes with large data volumes. I have managed to reduce processing times in Financial, Accounting, and Tax flows (such as Budget Modeling, Forecast, Capex, Actual vs. Budgeted Variations, Management Income Statements/DRE, medical payments, and variable compensation) from several days to just a few hours using Python, SQL, and VBA. I also have experience in automating Brazilian tax processes (DIRF, ISS, ICMS, INSS, IRRF, PCC).
• Integrations and Automation: Development of system integrations through REST APIs with optimized pipelines, reducing data collection times from several minutes to just 5 seconds. Expert in RPA automation development and data modeling/manipulation.
• Soft Skills: Recognized for high adaptability, resilience, and clear, fluid day-to-day communication.
  • Portuguese

    Native or bilingual

  • Spanish

    Fluent

  • English

    Basic

Remote only
Primarily works remotely

Experience

  • Grupo CAOA
    Junior Data Analyst
    AUTOMOBILE
    January 2026 - Today (7 months)
    São Paulo, State of São Paulo, Brazil
    Strategic support to FP&A (Financial Planning and Analysis) areas through data intelligence, focusing on:
    • Dashboard Development: Creation of executive views in Power BI to support decision-making by management and the CFO.
    • Data Engineering & ETL: Structuring complex data flows and database manipulation (SAP, IBM Cognos, and Protheus), ensuring data integrity and accuracy.
    • Automation and RPA: Development of solutions for optimizing routine processes and highly complex tasks.
    • Stack used: Excel, Power BI, SAP, IBM Cognos, Protheus, Oracle DB, VBA, and Python.
    SQL Microsoft Power BI Python Microsoft Excel Macro VBA Excel
  • Grupo Petz Cobasi
    Data Planning and Performance
    RETAIL (SMALL BUSINESS)
    May 2025 - January 2026 (8 months)
    São Paulo, State of São Paulo, Brazil
    • Routine Automation: Implementation of scripts with Python (pandas, openpyxl, selenium, pyautogui), VBA, and Office Scripts, significantly reducing manual effort in critical organizational processes.
    • Data Mart Maintenance: Management of the FP&A Data Mart through the implementation of multidimensional modeling in the Snowflake Data Warehouse.
    • ETL Pipelines: Development of data integration, cleaning, and loading flows using Python, Excel, Power Query, and Power Automate.
    • Business Intelligence: Construction and maintenance of dashboards in Power BI, applying data modeling, DAX, and integration of multiple information sources.
    • Technical Documentation: Preparation of PDS and STD specifications and technical documentation.
    • Stack used: Python, SQL, Power BI, Snowflake, DBeaver, Excel, BotCity, Fivetran, QlikSense, QlikView, Qlik Cloud, Power Automate, TOTVS Protheus.
    Microsoft Power BI Microsoft Excel SQL
  • Portoreal Alimentos
    Developer
    RAW MATERIALS INDUSTRY
    December 2024 - May 2025 (5 months)
    São Paulo, State of São Paulo, Brazil
    Code & Low-Code Development: Creation of custom applications and workflows with AppSheet and App Script; integration of GAS to VS-Code using Clasp to optimize delivery processes. API Integration and Development: Consumption and development of RESTful APIs on the backend using Node.js, integrating external systems and AppSheet. Use of tools like Postman and Thunder Client for CRUD operations (GET, POST, PUT, DELETE) within the VS Code environment.
    • • Version Control and Best Practices: Code management with Node.js, Clasp (for GAS integration), Git, and GitHub to ensure versioning, documentation, and project reliability.
    Microsoft Excel Python SQL AI Vercel

Recommendations

Be the first to recommend Léo

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Educación Superior (Grado)
    Unicsul - Universidad Cruzeiro do Sul
    2026
    Educación Superior (Grado)
  • Administración
    Senac Brasil
    2022
    Administración

Categories