PeriodMay 2023Aug 2016 – May 2023Cancún, Quintana Roo, Mexico
Universidad del Caribe
Bachelor's in Engineering in Data and Organizational Intelligence
Connect · Universidad
Joan Méndez Pool
I design systems with a long-term perspective — prioritizing clarity, observability, and operational resilience over short-term gains.
I believe real expertise in engineering is not defined by years of experience or novelty, but by the systems that continue to perform, adapt, and remain understandable over time.
Based on internal analysis · Cloud Business Solutions Architect & Data Engineer
Read the Story01
Profile Overview
About Me
Currently leading technical architecture at AISG, aligning backend, infrastructure, data, and UI layers to support scalable airline ground operations under IATA Standard Ground Handling Agreements.
I'm an Organizational Intelligence and Data Engineer focused on end-to-end systems, spanning backend and frontend development, cloud automation, and infrastructure-as-code on AWS.
My background in GNU/Linux and command-line environments strongly influences how I approach system design — pragmatic, observable, and built to scale from day one. I've worked across environments where reliability, maintainability, and clear ownership are essential, shaping solutions that can be operated and evolved over time.
Today, my work centers on building and maintaining platforms that connect data, automation, and people through reliable architecture, with a strong emphasis on clear documentation, reusable code, and operational efficiency.
Snapshot
Designs systems with operational clarity
Prioritizes documentation as a first-class artifact
Optimizes for maintainability over novelty
Bridges engineering, data, and product concerns
Builds platforms meant to be run, not just shipped
02
Academic Registry
Education
Formal foundations for systems thinking and architectural rigor.
03
Experience Index
Career Timeline
“A chronological index of architectural contributions and engineering leadership.”
Information Technology Architect
Jan 2025 – Present (Promotion from IT Project Coordinator)
AISG Aviation Integrated Services GroupView Company Profile
- Lead the organization’s technical architecture across backend, cloud infrastructure, data pipelines, and UI systems.
- Designed scalable AWS architectures integrating VPC, Lambda, API Gateway, DynamoDB, S3, CloudFront, and RDS.
- Built ETL pipelines and operational dashboards using AWS Glue, Redshift, Athena, Lake Formation, QuickSight, and Power BI.
- Developed dynamic user interfaces using Next.js 15 and Tailwind CSS, documented in Storybook with clsx and Framer Motion.
- Expanded automation processes using CloudFormation and Serverless Framework to standardize deployments.
Information Technology Project Coordinator
Dec 2023 – Dec 2024AISG Aviation Integrated Services GroupView Company Profile
- Led cloud infrastructure and backend development projects, coordinating Dev and Data teams.
- Orchestrated CI/CD pipelines using GitHub Actions for automated testing and deployments across Dev, QA, and Production.
- Implemented advanced project management controls using GitHub Projects and GitFlow.
- Authored Markdown documentation, Postman collections, and architectural diagrams as code.
- Managed user authentication and security through IAM roles, Cognito User Pools, and CloudWatch monitoring.
Web Developer
Apr 2022 – Oct 2023Oasis Hotels & ResortsView Company Profile
- Developed and maintained internal web applications using Laravel, React, and Next.js.
- Improved internal workflows and enhanced UX consistency across departments.
- Supported automation initiatives and optimized web integration processes.
04
The ToolkitTechnical
Technical
Arsenal
Platforms, Frameworks and tooling that keep delivery fast and reliable
Interface Systems
User Interface & Interaction
Pixel-precise experiences built with modern React tooling and cinematic motion design.
Frameworks & State Management
- React
- Next.js 15
- Zustand
UI & Motion
- Tailwind CSS 4
- Radix UI
- Framer Motion
Data Fetching & Documentation
- TanStack Query
- Axios
- Storybook
01Interface SystemsInterface Systems
User Interface & Interaction
Interface Systems
User Interface & Interaction
Pixel-precise experiences built with modern React tooling and cinematic motion design.
Frameworks & State Management
- React
- Next.js 15
- Zustand
UI & Motion
- Tailwind CSS 4
- Radix UI
- Framer Motion
Data Fetching & Documentation
- TanStack Query
- Axios
- Storybook
02Service EngineeringService Engineering
Service Layer Engineering
Service Engineering
Service Layer Engineering
Reliable APIs and data contracts powering orchestrated workflows and automation.
Frameworks & APIs
- FastAPI
- Django
- Laravel
API Contracts & SDKs
- OpenAPI
- Boto3 (AWS SDK for Python)
ORMs & Data Modeling
- SQLAlchemy
- Pydantic
- SQLModel
Testing
- Pytest
03Cloud ArchitectureCloud Architecture
Cloud Platform Architecture
Cloud Architecture
Cloud Platform Architecture
End-to-end AWS operations across networking, security, analytics, and observability.
Networking & Delivery
- AWS VPC
- AWS API Gateway
- AWS CloudFront
Identity & Security
- AWS Identity and Access Management (IAM)
- AWS Cognito
- AWS Secrets Manager
- AWS Key Management Service (KMS)
Infrastructure as Code
- AWS CloudFormation
- AWS Cloud Development Kit (CDK)
Monitoring & Management
- AWS CloudWatch
- AWS CloudTrail
- AWS Config
Compute Platforms
- AWS Lambda
- AWS EC2
- AWS ECS
- AWS ECR
Analytics & ETL
- AWS Glue
- AWS Athena
- AWS QuickSight
- AWS Lake Formation
04Analytics & MLAnalytics & ML
Analytics & Business Intelligence
Analytics & ML
Analytics & Business Intelligence
Pipelines, warehousing, and ML experimentation turning datasets into playbooks.
Data Engineering
- Apache Airflow
- AWS Glue
- AWS Lake Formation
- ETL Pipelines
- Data Warehousing
Data Processing (Python Ecosystem)
- Polars
- Pandas
- PySpark
Data Visualization & Analytics
- Streamlit
- Seaborn
- Plotly
- AWS QuickSight
- Power BI
Cloud Data Platforms
- AWS Athena
- AWS Redshift
- AWS Glue
- AWS Lake Formation
Machine Learning / Advanced Analytics
- Scikit-learn
- SageMaker
- TensorFlow
05Persistence LayerPersistence Layer
Persistence Systems Stores
Persistence Layer
Persistence Systems Stores
Operational and analytical stores engineered for resilience and fast retrieval.
Operational Stores
- AWS RDS
- AWS DynamoDB
NoSQL
- AWS DynamoDB
- MongoDB
Relational Databases
- MySQL / MariaDB
- PostgreSQL
- MSSQL
Analytics Warehouses
- AWS Redshift
Query Engines
- AWS Athena
06Delivery & OpsDelivery & Ops
Delivery & Automation
Delivery & Ops
Delivery & Automation
Secure release rituals with IaC, CI/CD, and observability baked into every deploy.
Automation & CI/CD
- GitHub Actions
- Serverless Framework
- Docker Compose
- CI/CD Automation Bash Scripting
Version Control & Workflow
- GitHub Projects
- GitFlow
- Github Organizational Administration
Security & Automation
- AWS SSM Agent
- AWS Systems Manager Parameter Store
- AWS Secrets Manager automation
07Knowledge SystemsKnowledge Systems
Knowledge Systems
Knowledge Systems
Knowledge Systems
Documentation stacks and visual modeling that make decisions traceable and teachable.
Knowledge Management
- Markdown GitHub Wikis
- MkDocs
API & Testing
- Postman Collections
Architecture Visualization
- Diagrams (Python)
08Operating SystemsOperating Systems
Operating Systems
Operating Systems
Operating Systems
Unix-first workflows, automation, and version control discipline for fast iteration.
Environments
- GNU/Linux
Version Control
- Git
Command-line Tooling
- AWS CLI
- GitHub CLI
- Command Line & Bash Scripting
09Cultural FluencyCultural Fluency
Multilingual Delivery
Cultural Fluency
Multilingual Delivery
Human collaboration across English and Spanish for workshops, documentation, and delivery.
Communication Channels
- English — C1 (Advanced)
- Spanish — Native
05
Project IndexProject
Project
Index
Yearly delivery highlights with detailed implementation notes.
06
Section 06Deployment
Deployment
Log
“Anchoring milestones that shape architecture, data, and delivery focus.”
2025
JanuaryMilestone
Refactored the Operations API and Timesheets with data-engineering optimizations
Standardized backend terminology from flights to operations, modularized project and test structures, and migrated timesheet processing logic from Pandas to Polars, significantly improving performance, memory efficiency, and scalability of operational analytics.
FebruaryMilestone
Built and deployed the CCS foundation (Next.js + CloudFront)
Delivered the first production-ready CCS application using Next.js, Tailwind CSS, and a CloudFront + S3 deployment pipeline. Established the baseline UI architecture, routing, core data surfaces, and CI/CD workflows required to scale the platform throughout 2025.
MarchMilestone
Re-engineered AWS Glue into a fully governed Data Warehouse platform
Recovered transformation logic directly from AWS Glue production jobs and rebuilt the BI platform using Infrastructure as Code. Implemented CloudFormation-managed Glue jobs, crawlers, workflows, triggers, and Data Catalog resources, and standardized a Bronze–Silver–Gold architecture feeding Redshift and Athena—transforming Glue from a manual console workflow into a versioned, auditable, reproducible data platform.
AprilMilestone
Delivered the service assignment engine for Operations API
Implemented structured service assignment schemas, validation rules, and endpoints, enabling formal and extensible linkage between technicians, services, airlines, and operational context.
JulyMilestone
Scaled the Timesheets Platform to support multi-company operations
Refactored data access, filtering, and UI layers to support dynamic company and station selection, improving query reuse, performance, and analytical flexibility across multiple operational entities.
AugustMilestone
Established centralized API security and RBAC framework
Introduced a Cognito-backed API Security platform with bearer authentication middleware and normalized role-based access control models, enabling consistent authorization across AISG services.
SeptemberMilestone
Expanded CCS into AISG’s flagship contract + capability platform
Delivered the major CCS expansion: advanced multi-parameter filters, interactive capability maps, API-driven content, and automated email workflows. Integrated Google Analytics/Tag Manager and Open Graph metadata to support measurable adoption, sharing, and SEO readiness—positioning CCS as AISG’s central customer-facing portal.
2024
JanuaryMilestone
Established the core Operations API foundation
Designed and implemented a modular FastAPI backend integrated with MSSQL on AWS RDS, Cognito-IDP authentication, and core operational entities. The architecture established the foundation for AISG’s operational systems and enabled future extension using DynamoDB and S3 for document storage, references, and auxiliary data.
MarchMilestone
Introduced monitoring and operational state APIs
Expanded backend services with monitoring endpoints, normalized schemas, and operational state abstractions, enabling real-time visibility and lifecycle tracking across stations.
AprilMilestone
Adopted automated testing and CI pipelines
Integrated pytest, Postman collections, and GitHub Actions workflows, transforming backend services into test-validated, continuously integrated systems with reproducible deployments.
JulyMilestone
Launched the Operations Timesheets Platform
Delivered the first analytics platform for operational timesheets, rankings, and summaries, combining optimized MSSQL queries with Python-based data transformations and visualizations, exposed through an authenticated Streamlit application.
AugustMilestone
Automated flight data synchronization using a serverless architecture
Implemented the Flight Sync Lambda using the Serverless Framework and GitHub Actions CI/CD pipelines, enabling autonomous, multi-environment synchronization of flight data across AISG systems.
OctoberMilestone
Provisioned Cognito user pools using Infrastructure as Code
Created CloudFormation templates and Bash automation to replicate and manage Cognito user pools, automate bulk user migration, overcome AWS console limitations, and apply AISG branding to the Cognito Hosted UI.
07
Engagement Overview
Professional Engagement
Availability · Contact · CollaborationThe
The
Directory
Status: Available
“Open for architecture leadership, data strategy, and platform enablement mandates.”
Base of operations
Based in Cancún, México 🇲🇽
Start a conversation
Interested in collaborating on high-performance architecture, data orchestration, or platform modernization? Let’s outline the next release together.
jjmendezpool@gmail.com→
ArchitectureData EngineeringCloud Ops