As a Robotic Process Automation Developer at Lakeside Book Company, I design and deploy end-to-end UiPath automations that eliminate repetitive manual workflows across production reporting, vendor communications, and data distribution. By replacing multi-step human processes with scheduled, unattended bots, I reduced task completion time by 85% — from 30–45 minutes down to under 5 minutes — saving the business 15+ hours of manual work every week.
September 2025 – Present · Crawfordsville, IN
Processes that previously took 30–45 minutes per run now complete in under 5 minutes with zero manual intervention.
Across all deployed automations, the team reclaims over 15 hours of productive time every week.
A suite of daily and hourly bots running before business hours, ensuring data and reports are ready at the start of each shift.
Production Reporting · Daily · Mon–Fri
A fully automated reporting pipeline that monitors an email inbox for a daily production data extract, applies business logic to filter out irrelevant records (future ship dates and on-hold jobs), consolidates duplicate entries by summing remaining hours, and produces a formatted, pivot-ready Excel report — all delivered to production stakeholders before the workday begins.
Vendor Management · Scheduled
Automates the entire purchase order follow-up workflow — from logging into a web-based plant management system and pulling an overdue PO line items report, to grouping results by vendor, looking up contact emails, and dispatching personalized follow-up emails with vendor-specific Excel attachments. Handles edge cases where vendor contact data is missing by notifying plant contacts directly, ensuring no vendor falls through the cracks.
Logistics Reporting · Hourly · Queue-Based
A scalable two-bot architecture built on UiPath's ReFramework with Orchestrator queues. The Dispatcher reads a Google Sheet config to determine which of 17 billing and logistics report types to run, and calculates dynamic date ranges (Prior Day, Month-to-Date, Prior Week, and custom work day logic). The Performer processes each queue item by connecting to a legacy AS400 terminal, selecting the correct report, and routing outputs to the right recipients — with full transaction-level error handling and automated failure alerts.
✔ 7 production bots across reporting, logistics, and vendor workflows
✔ 85% reduction in process time: 30–45 min tasks now under 5 min
✔ Scalable Dispatcher + Performer architecture handling 17 report types
✔ Dynamic date range logic (Prior Day, MTD, Prior Week, Work Day Calc)
✔ Full exception handling with automated alerts to support team
✔ Credential automation via UiPath asset store
✔ Google Sheet-driven config for zero-code scheduling adjustments