Data Science Projects in Columbus

Data Science Projects in ColumbusData Science Projects in Columbus

Cover image for I developed an AI-assisted document-intelligence

I developed an AI-assisted document-intelligence workflow for transportation-agency teams working with large collections of reports, standards, studies, scanned documents, and project records. The system combined document extraction, OCR, structured metadata, semantic retrieval, knowledge relationships, and grounded LLM responses. Analysts could ask questions in natural language, review the supporting evidence, inspect source citations, and approve, revise, or reject generated findings. The workflow was designed around human review, access controls, traceability, and safe failure rather than treating an LLM response as an unquestionable answer. Related work reduced decision time by approximately 60% and improved data accuracy by approximately 35%. The displayed architecture and interface are sanitized representations and contain no client documents, production data, proprietary prompts, or confidential system details.

0

117

Cover image for I engineered a large-scale package-network

I engineered a large-scale package-network intelligence pipeline using Azure Databricks and PySpark. The system joined approximately 4.5 billion historical records and transformed them into reusable fingerprint signals covering package movement and network behavior. I developed time-windowed feature logic using native Spark expressions rather than Python UDFs, preserving distributed performance at scale. The pipeline produced an approximately 200-million-row fingerprint dataset and a 22-million-row operational output that classified package activity along a cold-to-hot temperature scale. The resulting signals supported downstream monitoring, prioritization, and operational analysis. The architecture shown here is a sanitized representation; client identifiers, proprietary schemas, infrastructure paths, and business rules have been removed.

1

155