Mortgage Application Extractor: RAG for 200-Page Loan Files by Joe EstephanMortgage Application Extractor: RAG for 200-Page Loan Files by Joe Estephan

Mortgage Application Extractor: RAG for 200-Page Loan Files

Portfolio project
Joe Estephan
Turns scanned mortgage applications, often 200 pages or more, into one structured data model, with a confidence score on every field.
Textract reads the scans with the layout kept and the boilerplate dropped. A small file goes straight to the LLM. A large one is chunked, embedded and stored in Pinecone, so each field's query pulls back only the pages that matter before extraction. Partial results are merged by confidence. Prefect runs the 15 steps with retries and caching, Terraform builds the AWS side, and each step has its own tests.

0 likes · 2 views · Oct 20, 2026

Scanned mortgage applications of 200+ pages turned into one structured data model, with a confidence score on every field, through OCR, chunking and retrieval.

Tags