Jeppesen ForeFlight
NLP Engineer — Capstone Project
- Built and shipped an end to end LLM extraction pipeline that turns noisy transcripts into 11 structured fields, replacing a manual reporting process, covering data preparation, prompt engineering, evaluation, and productionization.
- Built the data foundation: designed ETL pipelines on Databricks following Medallion Architecture (Bronze, Silver, Gold), ingesting raw data from three sources into Bronze, applying quality filters, normalization, and deduplication into Silver, and merge upserting curated results into Gold Delta tables (PySpark, Spark SQL, Delta Lake).
- The extraction engine is a three layer extraction cascade regex → dictionary lookup → LLM fallback that parses structured emergency event fields from noisy ASR/OCR/subtitle ATC transcripts in a Databricks pipeline
- Designed a LLM agent with three stages(Spotter, Classifier, Linker) with prompt chaining for entity recognition, role assignment, and relationship extraction.
- Deployed it as a FastAPI REST service on Databricks Apps against a live LLM serving endpoint, owning architecture through production.
- Added RAG grounding plus validation against a 5,000+ record reference dataset to cut hallucinations and catch bad output before release.