Design a document drawer and intake workflow for Vista that centralizes all monthly claims submissions and prepares data for automated dashboards. Mployer Vista is a claims reporting and budget tracking platform for brokers and employers, analyzing medical and pharmacy claims, high claimants, and plan performance. Until now, the data behind these dashboards depended on manual Excel and PowerQuery processes, scattered files, and ad hoc email follow-ups. My role was to translate a detailed PRD into a coherent end-to-end experience that supports clients and internal teams with clear statuses, consistent file requirements, and a foundation for automated pipelines.