Software DeveloperSão Paulo, Brazil

From operations to code.

I started my career in logistics, transitioned into data analysis, and now build the systems that move the operation.

Portrait of João Pedro Lourenço David

About

I did not move into tech from the outside. I started my career as a transport intern, learned the operation from the people running it, and drifted toward code as I realised how much of it could be automated.

As a data analyst I spent two years building logistics cost indicators and automations in Python and SQL. One of them became a messaging system that reaches over a thousand customers a day. That is where programming stopped being a tool and became the job.

Today, I work as a developer, building APIs and management systems using Java, interfaces with Angular, and integrations between internal systems, ERPs, and external services. My previous experience in operations continues to be a key strength: before thinking about how to write the code, I try to understand the problem it needs to solve.

Education
Bachelor's Degree in Computer ScienceUniversidade do Sul de Santa Catarina Jan 2023 — Jul 2027 (expected)
Languages
Portuguese — C2
English — B1
Spanish — A1

Stack

What I work with day to day, grouped by where it applies.

Backend
JavaSpring BootSpring Data JPAHibernateJakarta EEJSFMavenGo
Frontend
AngularReactTypeScriptNative FederationJavaScriptHTMLCSSNext.js
Data & BI
OracleSnowflakeSupabaseSQLPower BIExcelVBA
Python
PythonFastAPIFlaskPandasLangChainGenAI
AI
Claude EcossytemCodexCursor
Process
GitScrumKanban

Projects

Projects with their own repository and demo, outside the Cassol experience.

AI Weather Forecasting

An API that estimates the weather for a Brazilian city on a chosen date, based on historical INMET data, using FastAPI and LangChain on the back end.

  • Python
  • FastAPI
  • LangChain
  • OpenAI
  • Supabase

Experience

Cassol Centerlar

Jun 2022 — present

  1. Full-Stack Developer Current

    May 2025 — present

    • Full-stack development on Cassol Centerlar’s ERP. I work on both sides of the platform: the legacy Java monolith and the move to a new architecture built on micro-frontends and microservices.
    • Legacy ERP (Java EE on WildFly, Oracle): a layered monolith with JSF/PrimeFaces screens, a Business/DAO layer and JPA/Hibernate mappings; a JAX-RS REST API that the new front ends use for login, branches, configuration and contracts.
    • New platform (Cassol Hub): Angular 21 micro-frontends (standalone, zoneless, OnPush) joined by Native Federation under a shell that handles login, layout and menus; a shared design system published as an internal npm library for components and auth guards; Identity and access management on Keycloak; Spring Boot microservices taking over modules from the monolith while sharing its Oracle database.
    • Spec-driven development with OpenSpec, and AI-assisted coding with Claude Code for planning, implementation and code review, with a QA approval step before every merge.
    • Java
    • Spring Boot
    • Jakarta EE
    • Go
    • Angular
    • TypeScript
    • Python
    • FastAPI
    • Oracle
  2. Data Analyst

    Apr 2023 — May 2025

    • Developed and monitored KPIs focused on logistics and delivery costs using Excel and Power BI to support strategic decision-making, cost reduction, and service level improvement.
    • Created and optimized SQL queries to extract, manipulate, and analyze large datasets, ensuring fast and accurate reporting through dashboards and management reports.
    • Automated processes with Python to validate delivery data and communicate with customers, reducing returns and lowering logistics costs while enhancing service levels.
    • Implemented a messaging system to send satisfaction surveys based on the NPS model, reaching over 1,000 customers per day with minimal costs.
    • Built custom Excel tools integrated with SQL and VBA to streamline data from multiple platforms, automating operational tasks and enabling faster, more accessible analytics for the team.
    • Provided technical mentoring to new team members by sharing knowledge in SQL, Excel, business rules, and app development, accelerating onboarding and improving team productivity.
    • Python
    • Pandas
    • SQL
    • Oracle
    • Power BI
    • Excel
    • VBA
  3. Transport Intern

    Jun 2022 — Apr 2023

    • Supported logistics operations by managing data and creating preliminary reports.
    • Gained hands-on experience in analyzing transportation and logistics data, strengthening foundational skills in business intelligence and operations.
    • Excel
    • SQL

Other work

Full-Stack Developer Current

Ita Calçados

Sep 2026 — present

  • End-to-end development of Ita Calçados’ e-commerce platform for clothing and footwear, from architecture to the production launch. It has an async Python/FastAPI backend (SQLAlchemy, Pydantic v2) on PostgreSQL/Supabase, and a React 18 + TypeScript storefront and admin panel.
  • Checkout and payments built on the AppMax gateway: credit card with configurable installments, Pix, and antifraud review handling; payment-state rules that keep a customer from being charged twice; atomic stock reservation under concurrent purchases.
  • Delivery options: Correios shipping quotes, and in-store pickup scheduling calculated from the store’s opening hours and time zone.
  • An admin area with access control by module, covering: orders and invoices; a product catalog with images per color; coupons and an influencer program; shipping, checkout and site settings; a sales dashboard.
  • Performance and reliability: Redis caching, CDN caching with a purge on every admin save, serverless deployment on Vercel, structured logging, and load tests of the full customer journey.
  • Security and compliance: database hardening (Row-Level Security, Data API locked down); versioned privacy-policy consent under the LGPD; every schema change shipped with backup and rollback scripts for production.
  • SEO through server-rendered product pages and a dynamic sitemap.
  • Quality assurance with automated tests: Pytest unit tests, plus integration tests against a real PostgreSQL database (about 95% backend coverage); Vitest/MSW for the frontend and Playwright for end-to-end tests.
  • Spec-driven development with OpenSpec, and AI-assisted coding with Claude Code for planning, implementation and code review, with a QA approval step before every release.
  • Python
  • FastAPI
  • React
  • Supabase

QA Tester (freelance)

Vetto AI

Mar 2026 — Jun 2026

  • My primary responsibility involves analyzing AI-driven conversations based on predefined personas and contextual scenarios. I assess whether the AI responses are accurate, coherent, and aligned with the user’s intent, while also verifying the model’s ability to properly interpret and adapt to different personas.
  • LLM
  • QA

Web Developer

Freelance

Dec 2024

  • I delivered a Next.js web application: login authenticated against the client’s API, an interactive table report, and Excel export.
  • Next.js
  • JavaScript
  • HTML
  • CSS

Contact

Open to conversations about opportunities and projects.