Role Deep-Dive · Industry Experience

Software Developer (RPA), Lakeside Book Company

Engineering and maintaining 25+ production UiPath automation workflows across Finance, HR, Operations, Customer Service, Production, and Supply Chain, replacing manual, multi-step processes with scheduled, unattended bots that cut process times by up to 90% and reclaim 70+ hours of manual work every week.

September 2025 – Present Crawfordsville, IN UiPath Studio & Orchestrator
01

impact

Up to 90% Time Reduction

Manual processes across 6 business units re-engineered into unattended workflows, cutting process times by up to 90%.

70+ Hours Saved Weekly

Across all deployed automations, the business reclaims 70+ hours of manual work every week.

25+ Bots in Production

A portfolio of daily and hourly bots spanning Finance, HR, Operations, Customer Service, Production, and Supply Chain.

<1 Correction / Week

Exception handling, input validation, and automated retries cut manual corrections from 7–9/week down to fewer than 1 across most workflows.

02

bot_pipeline

The LogPro Reports bot pair, in motion: the Dispatcher loads config and queues work, and the Performer drains the queue one item at a time.

Dispatcher
Orchestrator Queue
Performer
Report Delivered
Prior Day Month-to-Date Prior Week
03

automations

Production Reporting · Daily · Mon–Fri

Late Press Titles Report

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, delivered to production stakeholders before the workday begins.

IMAP EmailExcel / XLSXGoogle SheetsPivot TablesData Filtering
Vendor Management · Scheduled

MVP1 PO Follow-Ups

Automates the entire purchase order follow-up workflow, starting with 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 missing vendor contact data by notifying plant contacts directly, so no vendor falls through the cracks.

Chrome AutomationWeb App InteractionExcel ExportPer-Vendor EmailsException Handling
Logistics Reporting · Hourly · Queue-Based

LogPro Reports: Dispatcher & Performer

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.

ReFrameworkOrchestrator QueuesAS400 TerminalGoogle Sheets17 Report Types
04

stack

RPA Platform
UiPath Studio & Orchestrator, bot development, scheduling, deployment
Architecture
ReFramework, queue-based architecture for scalable transaction processing
Config & Control
Google Sheets API, dynamic configuration and dispatcher control
Legacy Systems
AS400 / TN3270 Terminal automation via System I Navigator
Web Automation
Chrome & web automation for browser-based plant management systems
Reporting
Microsoft Excel / Access, report generation, formatting, database queries
Messaging
IMAP / SMTP, automated email monitoring and distribution
BI
SAP Business Objects, BI report refresh and export automation
05

highlights

✔ 25+ production bots across reporting, logistics, and vendor workflows ✔ 90% 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