Back to Home

My Portfolio

Automation projects that transformed manual processes into streamlined solutions— saving thousands of hours and eliminating errors across enterprise teams.

Filter:
Returned Payment Automation Suite
Enterprise RPA
Production

Returned Payment Automation Suite

UiPath bot that processes returned payment accounts by navigating Credit Manager, updating settings across multiple screens based on scenario matrix, writing calculated comments, and logging all changes.

17 scenarios
One Codebase
Before → After
3-5 min/account14-16 sec/account
UiPath StudioXExcelDataikuVB.NET
Expedia Remit Processor
Web Application
Production

Expedia Remit Processor

Web app that scans folders of remittance Excel files, compares values against source files, flags mismatches with warnings, and writes to shared log matching existing documentation process.

87%
Time Reduction
Before → After
15 min/task2 min/task
Google Apps ScriptSheetJSHTML5/CSS3JavaScript
TriBrand Analyzer / Fleet List Processor
Process Automation
Production

TriBrand Analyzer / Fleet List Processor

VBA automation where users drop raw export files into input folder and double-click to process. Auto-detects file types by name/content and creates formatted output.

Drop & Run
Single Click
Before → After
HoursMinutes
VBAExcelWindows Automation
OTR Issue Report Tool
Web Application
Production

OTR Issue Report Tool

Web app that processes financial adjustment requests in a single click, producing both Google Sheet documentation and database INSERT statements with rollback and verification queries.

Single Click
Full Process
Before → After
10-20 min<2 min
Google Apps ScriptHTML5/CSS3JavaScriptSQL
Third Party Billing KPI Processor
Process Automation
Production

Third Party Billing KPI Processor

Browser-based automation that transforms 5 PeopleSoft GL exports into a formatted KPI Excel workbook with preserved formulas, integrated validation, and real-time processing logs.

95%
Time Reduction
Before → After
~40 min<2 min
JavaScriptHTML5/CSS3SheetJSPython
SAS Tax Reports Dashboard
Business Intelligence
Production → Company-Wide

SAS Tax Reports Dashboard

Personal dashboard built to collect tribal knowledge about undocumented SAS reports. PowerShell monitoring led to real-time job tracking. Identified critical gap → passed to senior leadership → absorbed into company-wide IT system.

Company-Wide
IT Adoption
Before → After
NoneReal-time
Power BIPowerShellSQL ServerSAS
LQA Automation Suite
Process Automation
Production

LQA Automation Suite

VBA automation that produces monthly QA reports for largest client by processing hundreds of source files with complex transformations. Rolling 3-month, 6-month, and yearly aggregations.

27 languages
3 Major Clients
Before → After
2-6 hours/monthSingle click
VBAExcelData Processing
📁
Process Automation
Adopted Company-Wide

QA Report Splitter

Macro that splits batch QA reports from new system into individual language files matching legacy format. Identified company-wide gap after system change caused hours of overhead across all QA teams.

Company-Wide
Tool Adoption
Before → After
Hours10 min
VBAExcelData Processing
8
Total Projects
7
In Production
2
Company-Wide Adoption
17+
Technologies Used