👋 Hi, I’m Andres Mercado
Backend Software Engineer
Async Python • FastAPI • PostgreSQL • Concurrency • Cloud Infrastructure

I build backend systems focused on reliability, async workflows, and real-world automation.

Most of my projects originate from firsthand operational problems I’ve experienced in aviation operations, real estate, and workflow-heavy environments.

AI-driven outreach and workflow platform focused on context-aware communication and personalized generation workflows.

• Multi-context architecture separating user, campaign, and relationship-aware context systems
• AI-powered personalization workflows for dynamic outreach generation and contextual messaging
• Async backend workflows supporting scalable prompt orchestration and data processing
• Backend-focused architecture designed for extensible AI-assisted communication systems

Built with FastAPI, Async SQLAlchemy, PostgreSQL, Docker, OpenAI

Backend-first document ingestion system for structured lease analysis and compliance workflows.

• GPU-backed OCR workers for document processing
• Async ingestion pipelines with background job workflows
• State-aware lease chunking and embedding-based semantic retrieval
• PostgreSQL-backed semantic search and AI-powered document querying

Built with FastAPI, PostgreSQL (async), PaddleOCR, Docker, AWS S3

🔗 Demo: https://propia-demo.vercel.app

Internal aviation operations platform.

• RESTful APIs built with Flask and SQLAlchemy
• Migrated MongoDB → PostgreSQL for relational integrity
• Integrated FlightAware and Weather APIs
• Dockerized and deployed on AWS EC2 with Nginx + TLS

Python, FastAPI, Flask, PostgreSQL, SQLAlchemy, Docker, AWS, GCP, OCR, OpenAI

📫 Contact

📧 andresam321@proton.me
🌐 Portfolio: https://andresam.netlify.app
💼 LinkedIn: https://www.linkedin.com/in/andres-merc/