Ph.D. Candidate @ FIU • AI & Data Engineering

Esteban Schafir

AI Engineer / Data Engineer

Applied AI Researcher • Specializing in LLM Agents & Data Systems

I design and build agentic AI systems, scalable data engineering pipelines, and complex reasoning frameworks where accuracy, verification, and data reliability are foundational requirements. Combining 4+ years of academic AI research at FIU with 10 years of enterprise IT & security engineering.

Esteban Schafir - AI Engineer & Data Engineer
AI & LLMs
Multi-Agent Systems, RAG, Harnessing LLMs
Data Engineering
Pipelines, Vector DBs, SQL Architecture
Information Security
+10 Yrs Enterprise Defense
Research
Ph.D. Candidate @ FIU
Engineering Philosophy

Bridging Applied AI, Data Reliability & Systems Security

A high-rigor engineering mindset honed through 4+ years of academic research and 7 years in enterprise infrastructure.

Background & Expertise

I am an AI Engineer, Data Engineer, and Ph.D. candidate in Computer Science at Florida International University (FIU). My work spans large language models, multi-agent systems, retrieval-augmented generation (RAG), and end-to-end data pipelines.

Before diving deep into academic AI research, I spent over 10 years in enterprise IT, information security, and risk engineering at organizations like Equifax and Deloitte partners. That background shapes how I build AI today: not as brittle demo toys, but as hardened, deterministic systems with strict guardrails, transactional rollbacks, and measurable performance.

At FIU, I conduct research on hierarchical decomposition for Text-to-SQL, visual document retrieval via teacher-student model distillation, and graph neural network robustness, publishing in premier venues including AAAI, IEEE TPAMI, and the ACM Web Conference.

Core Specialization Domains

Large Language Models & In-Context LearningAgentic Workflows & Multi-Agent SystemsHierarchical Text-to-SQL & Complex Query RoutingInformation Retrieval & Distilled Sparse IndexesEnd-to-End Data Pipelines (ETL/ELT, SQL, Vector DBs, Python)System Hardening, Guardrails & Anti-Hallucination

Agentic AI & LLMs

Architecting multi-agent systems (LangGraph), DAG-based problem decomposition, and constrained generation with deterministic verification loops to prevent hallucinations.

Data Pipelines & SQL

Designing end-to-end ETL/ELT pipelines in Python and SQL. Integrating relational databases, vector embeddings, and building natural-language Text-to-SQL query compilers.

Empirical AI Research

Conducting Ph.D. research at FIU on sub-10ms visual document retrieval via teacher-student distillation, graph representation learning, and complexity-aware query routing.

Cybersecurity Foundation

10 years of enterprise risk modeling, vulnerability remediation, and ISO 27001 / NIST compliance at Equifax and Deloitte partners—ensuring data systems are secure by design.

Production Systems & Research

Featured Engineering Projects

Concrete implementations spanning multi-agent reasoning, hierarchical Text-to-SQL, voice assistants, and offline-first desktop systems.

AI & LLMsFeatured

DecoSearch

Complexity-Aware Routing & Plan-Level Repair for Enterprise Text-to-SQL

A cutting-edge research framework for Text-to-SQL that decomposes complex natural-language queries into dependency DAGs, routes them based on structural complexity, and refines query candidates using Monte Carlo Tree Search and database execution feedback.

> 70.5% EX
BIRD Benchmark
> 88.3% EX
Spider Benchmark
PythonText-to-SQLLangChainMCTS+3
Technical Deep-Dive
Multi-Agent SystemsFeatured

Resume Tailor AI

Multi-Agent LangGraph Pipeline with Strict Anti-Hallucination Guardrails

An autonomous multi-agent system that ingests resumes (PDF or LaTeX source) and job postings, runs gap analysis, and rewrites bullet points with an adversarial verification loop to guarantee no unsupported skills, tools, or metrics are introduced.

100% Guardrailed
Anti-Hallucination
5-Node Graph
Agent Pipeline
LangGraphPythonMulti-AgentTypst+3
Technical Deep-Dive
Data & Voice AIFeatured

Recepción IA

Multi-Tenant Voice AI Assistant for Medical & Dental Clinic Phone Reception

A production SaaS platform where clinics configure autonomous Spanish-speaking phone assistants via VAPI, with live Google Calendar two-way synchronization, AES-256-GCM token encryption, Supabase RLS multi-tenancy, and turn-by-turn transcript inspection.

Real-Time Voice
Response Latency
AES-256-GCM
Credential Security
Next.js 16React 19Tailwind v4Supabase RLS+3
Technical Deep-Dive
AI & LLMsFeatured

Lovecraft Multimodal Studio

LangGraph-Orchestrated Multimodal Suite: Lore Generation, Diffusion Art & Neural Voice Cloning

An end-to-end multimodal suite for classic literature combining stateful LangGraph orchestration, local Ollama lore generation (gemma4:e2b), int8 quantized diffusion cover art (Z-Image-Turbo), and zero-shot Vincent Price voice cloning (CosyVoice3).

68 Full Stories
Corpus Size
CosyVoice3 0.5B
Audio Model
LangGraphPythonFastAPIOllama+3
Technical Deep-Dive
Systems & Geospatial

Smart File Organizer

Offline-First Desktop App with an AI Proposal Engine & Self-Defending Filesystem Harness

A private local desktop application that categorizes unstructured file collections and suggests organized directory structures, executing moves and renames through a sandboxed, fully reversible filesystem harness.

Zero / 100% Offline
Telemetry & Cloud
Isolated Harness
Safety Engine
ElectronReactTypeScriptNode.js+3
Technical Deep-Dive
Systems & Geospatial

Mighty Path

Autonomous DJI Drone Waypoint Mission Planner with Dynamic Terrain-Following

An ultra-premium desktop mission planner for DJI drones featuring Google Maps visual flight path plotting, dynamic Google Elevation API terrain-following, cinematic shape generators, and native DJI WPML v1.0.2 export.

DJI WPML v1.0.2 KMZ
Mission Standard
Dynamic Terrain Follow
Altitude Control
ElectronGoogle Maps APIElevation APIDJI WPML+2
Technical Deep-Dive
Data & Voice AI

TracepAI

Local-First Dockerized Financial Analytics Hub with On-Premise Receipt OCR

A private personal finance tracking platform running in Docker that parses receipts, invoices, and bank CSVs locally using Tesseract OCR, offering real-time budget analytics with zero third-party cloud data exposure.

Dockerized Local Stack
Deployment
Tesseract (EN & ES)
OCR Engine
Next.js 16FastAPIPythonDocker+3
Technical Deep-Dive
Systems & Geospatial

Flowdeck

High-Performance Multi-Board Kanban Desktop App for macOS & Modern Web

A multi-board Kanban productivity desktop and web application built with Next.js, Electron, and TypeScript, featuring smooth drag-and-drop card physics, rich-text markdown notes, and local file persistence without user accounts.

macOS .app & Web
Deployment
Zero / Local Storage
Cloud Dependency
Next.jsElectronReactTypeScript+3
Technical Deep-Dive
Academic Publications

AI & Computer Science Research

Peer-reviewed research conducted at Florida International University on LLM reasoning, Text-to-SQL, visual retrieval distillation, and graph neural networks.

35+
Google Scholar
View Citation Profile
arXiv Preprint (2026)First Author · AI & Databases

DecoSearch: Complexity-Aware Routing and Plan-Level Repair for Text-to-SQL

E. Schafir, X. Zheng, H. A. Salehi, Z. Chen, M. Sha, W. Cheng, D. Luo

Proposes an agentic Text-to-SQL framework using hierarchical question decomposition into dependency DAGs, complexity-aware query routing, and plan-level repair with MCTS to achieve high execution accuracy on BIRD and Spider benchmarks.

arXiv:2606.17821Read Publication
Proceedings of the ACM Web Conference 2024 (2024)12 Citations

The Matter of Captchas: An Analysis of a Brittle Security Feature on the Modern Web

B. Ousat, E. Schafir, M. A. Tofighi, D. C. Hoang, C. V. Nguyen, S. Arshad, A. Kharraz

Presents an extensive empirical analysis of modern CAPTCHA implementations across top web domains, identifying architectural brittleness and training CNNs/vision models to demonstrate automated bypass vectors.

DOI: 10.1145/3589334.36...Read Publication
DIMVA 2024 (Detection of Intrusions and Malware, and Vulnerability Assessment) (2024)8 Citations

Constructs of Deceit: Exploring Nuances in Modern Social Engineering Attacks

M. A. Tofighi, B. Ousat, J. Zandi, E. Schafir, A. Kharraz

Analyzes evasion strategies and multi-channel cognitive triggers in state-of-the-art credential harvesting campaigns and modern enterprise social engineering attacks.

DOI: 10.1007/978-3-031-...Read Publication
IEEE Transactions on Pattern Analysis and Machine Intelligence (TPAMI) (2026)IEEE TPAMI · Premier Journal

Addressing Structural Distribution Shift in Explanations for Graph Neural Networks

Z. Chen, H. A. Salehi, E. Schafir, X. Zheng, J. Zhang, H. Wei, J. Ni, F. Shirani, D. Luo

Develops theoretical frameworks and algorithms to mitigate distribution shifts when generating faithful, robust sub-graph explanations for Graph Neural Networks (GNNs).

DOI: 10.1109/TPAMI.2026...Read Publication
Proceedings of the AAAI Conference on Artificial Intelligence (AAAI) (2026)3 Citations

Explanation-Preserving Augmentation for Semi-Supervised Graph Representation Learning

Z. Chen, J. Ni, H. A. Salehi, X. Zheng, E. Schafir, F. Shirani, D. Luo

Introduces explanation-preserving data augmentations for semi-supervised graph representation learning, demonstrating superior node and graph classification performance under label scarcity.

DOI: 10.1609/aaai.v40i2...Read Publication
arXiv Preprint (2025)2 Citations

LM2otifs: An Explainable Framework for Machine-Generated Texts Detection

X. Zheng, Z. Chen, E. Schafir, S. Chen, H. A. Salehi, H. Chen, F. Shirani, M. Sha, W. Cheng, D. Luo

Proposes a graph-perspective explainable framework to detect machine-generated text by analyzing structural motifs and syntactical dependency patterns.

arXiv:2505.12507Read Publication
arXiv Preprint (2024)4 Citations

In-Application Defense Against Evasive Web Scans Through Behavioral Analysis

B. Ousat, M. Shariatnasab, E. Schafir, F. S. Chaharsooghi, A. Kharraz

Presents a behavioral analysis engine embedded inside web applications to dynamically detect, delay, and neutralize evasive automated vulnerability scanners and malicious crawlers.

arXiv:2412.07005Read Publication
IEEE Central America and Panama Convention (CONCAPAN XXXIV) (2014)6 Citations

e-Health: An Introduction to the Challenges of Privacy and Security

H. R. Jara, E. Schafir

Early foundational research surveying electronic healthcare record vulnerabilities, regulatory compliance challenges, and cryptographic privacy primitives for patient data.

DOI: 10.1109/CONCAPAN.2...Read Publication
Career History

Professional & Research Experience

10+ years of combined experience across applied AI research, data engineering, and enterprise information security.

Research
Apr 2022 — Present

Graduate Research & Teaching Assistant

Florida International University•Miami, FL, United States

Leading applied AI research on agentic Text-to-SQL decomposition, visual document retrieval, and graph neural network robustness.

Engineered DecoSearch (arXiv:2606.17821), an agentic Text-to-SQL engine employing DAG question decomposition, complexity routing, and plan-level MCTS repair over relational databases.
Achieved sub-10ms visual document search by developing a teacher-student distillation framework that compiles online multi-step LLM reasoning into offline visual sparse indexes.
Designed and maintained end-to-end Python data pipelines (Pandas, NumPy) that clean, transform, and augment multi-source datasets for ML benchmarking.
Key Impact & Metrics
• > 70.5% Execution Accuracy on BIRD benchmark and > 88.3% on Spider for Text-to-SQL.
• Sub-10ms visual document retrieval via LLM distillation into sparse indexes.
• 8 publications and 35+ citations in premier AI and security venues.
PythonPyTorchHugging FaceLangChainLangGraphFastAPIPandasNumPyPostgreSQLSQLiteDocker
Industry
Sep 2017 — Nov 2021

Information Security Officer

Equifax Argentina SA•Buenos Aires, Argentina

Led enterprise-level information security, vulnerability remediation pipelines, compliance programs, and executive KPI reporting across corporate infrastructure.

Consolidated and cleaned data from vulnerability scanners, audits, and third-party vendor reviews into unified analysis datasets.
Maintained centralized tracking databases of risks, findings, and remediation milestones, enabling audit-grade accountability over time.
Built recurring executive KPI dashboards, metrics reports, and risk status models for senior leadership.
Key Impact & Metrics
• Slashed critical infrastructure vulnerabilities by over 50% through data-driven remediation programs.
• Established 100% compliance alignment across vendor risk assessments and corporate security reviews.
• Automated weekly risk and vulnerability posture reporting for executive leadership.
Data IntegrationVulnerability ManagementISO 27001NISTSplunkExcel DashboardsIAMRisk Modeling
Industry
Mar 2016 — Sep 2017

Information Security Analyst

Puente Hnos•Buenos Aires, Argentina

Managed security monitoring, access controls, audit finding remediation, and core security infrastructure tooling for a major financial institution.

Compiled and analyzed telemetry from SIEM, ITSM, and Identity & Access Management (IAM) systems into automated management reports.
Tracked internal and external audit findings in a central tracking database to systematically eliminate vulnerabilities.
Implemented and maintained SIEM monitoring, ITSM workflows, and Privileged Access Management (PAM) tools.
Key Impact & Metrics
• Drove a 70% reduction in internal audit findings through central tracking and workflow automation.
• Earned executive leadership recognition for leading a rapid, zero-disruption security migration.
SIEM (Splunk)ITSMPrivileged Access Management (PAM)Data NormalizationSecurity Auditing
Industry
Oct 2014 — Mar 2016

Information Security Analyst

Cybsec by Deloitte•Buenos Aires, Argentina

Delivered technical vulnerability assessments, penetration testing, and security hardening audits across diverse enterprise client environments.

Merged and enriched technical assessment outputs (Nessus, Nmap, Wireshark, Metasploit) into structured datasets and client deliverables.
Conducted compliance reviews and system hardening across varied client operating systems, databases, and network architectures.
Collaborated closely with corporate clients to design and verify customized risk mitigation strategies.
Key Impact & Metrics
• Cut client audit findings by 60% through targeted hardening programs.
• Delivered dozens of enterprise vulnerability assessments on schedule.
NessusNmapWiresharkMetasploitVulnerability LifecyclesCompliance Hardening
Technical Capabilities

Categorized Technical Skills

Structured competency matrix spanning frontier LLM agent orchestration, high-throughput data engineering, and enterprise cyberdefense.

AI & Machine Learning

Deep learning models, neural graph architectures, and statistical evaluations.

PyTorchHugging Face (Transformers, PEFT)Graph Neural Networks (GNNs)Scikit-learnTensorFlowExplainable AI (XAI)Model DistillationBenchmark Evaluation (BIRD, Spider)
5 primary specializations8 skills total

LLMs & Agentic Systems

Multi-agent workflows, in-context reasoning, and deterministic verification harnesses.

LangGraphLangChainAgentic Workflows & Multi-Agent DAGsRetrieval-Augmented Generation (RAG)Text-to-SQL (DecoSearch)Anti-Hallucination GuardrailsIn-Context Learning & Prompt EngineeringOllama / Local LLM Inference
6 primary specializations8 skills total

Data Engineering & Databases

Scalable data ingestion, relational schema modeling, and vector search systems.

SQL (Complex Queries, Optimization)PostgreSQL & SupabasePython Data Pipelines (Pandas, NumPy)ETL / ELT Pipeline ArchitectureSQLite & MySQLSQL Server & Oracle PL/SQLMongoDB (NoSQL)Vector Databases (Chroma, Pinecone)
5 primary specializations8 skills total

Languages & Frameworks

Production software engineering across web, desktop, and backend services.

PythonTypeScript / JavaScriptNext.js (App Router)ReactFastAPIJavaC#Tailwind CSS
5 primary specializations8 skills total

Systems, Cloud & Tools

Containerization, cross-platform packaging, and developer automation.

Docker & ContainerizationElectron (Desktop Apps)Git, GitHub & GitLabLinux / macOS Shell ScriptingAWS (Cloud Fundamentals)Vitest & Playwright TestingRESTful API Design & OpenAPITypst & LaTeX Document Compilation
4 primary specializations8 skills total

Cybersecurity & Governance

Defensive engineering, compliance frameworks, and system hardening.

ISO 27001 & NIST FrameworksVulnerability Management (Nessus, Nmap)Threat Modeling & Application DefenseIdentity & Access Management (IAM / PAM)SIEM (Splunk, Security Telemetry)Penetration Testing & HardeningCryptographic Storage (AES-256-GCM)Security Auditing & KPI Reporting
4 primary specializations8 skills total
Academic Background

Education & Credentials

Advanced academic training in Computer Science and Cybersecurity from Florida International University and Universidad Nacional de Quilmes.

2024 — Present
GPA: 3.97 / 4.0

Doctor of Philosophy (Ph.D.)

Computer Science
Florida International University
Miami, FL, United States
Dissertation focus on Agentic Large Language Models, Hierarchical Text-to-SQL Decomposition, and Graph Neural Network Explanation Robustness.
First author of DecoSearch (arXiv:2606.17821) and co-author of publications in AAAI, IEEE TPAMI, and ACM Web Conference.
Graduate Research Assistant & Teaching Assistant.
#01
2021 — 2023
GPA: 4.0 / 4.0

Master of Science (M.S.)

Cybersecurity
Florida International University
Miami, FL, United States
Graduated with a perfect 4.0 GPA.
Specialized in web security vulnerabilities, automated CAPTCHA analysis, threat intelligence, and enterprise network defense.
Conducted empirical research published at the ACM Web Conference 2024 and DIMVA 2024.
#02
Graduated 2017

Bachelor of Science (B.S.)

Computer Programming
Universidad Nacional de Quilmes
Buenos Aires, Argentina
Rigorous foundations in algorithms, data structures, relational database management, and object-oriented software engineering.
Dual focus on systems programming and network fundamentals.
#03
Connect • Recruit • Collaborate

Let's Build Together

Open to AI Engineering and Data Engineering opportunities. Reach out directly via email or professional networks.

Direct Channels

Location
Hollywood, FL, United States (Miami Metro Area)

Profiles & Dossier

Connect on professional platforms or download my comprehensive AI & Data Engineer resume for recruitment review.