Virginia Smith

Connected creator, campaign, and CRM APIs to a shared relational model and built a retrieval-augmented research workflow with tool calling and structured outputs. Reduced recurring import failures by 28% through improved validation and error monitoring.

Integrated APIs to move campaign and performance records among creator platform, CRM, and finance applications. Implemented staged SQL tables for safer reconciliation and wrote cleanup scripts to requeue partial jobs.

Standardized creator, audience, and campaign records from relational databases and partner APIs. Built an authenticated Python endpoint for internal research and improved pagination and response structure for large searches.

Validated campaign files and API payloads before writing relational tables, returning row-level errors for investigation. Cut a typical weekly reporting check from 2 hours to about 45 minutes with SQL reconciliation queries and a missing-record monitor.

Bachelor of Science in Computer Science with a focus on Software Engineering, completed in 2018.