CPPortrait of Carl Pestilos

Carl Pestilos

Senior Accounting Operations Specialist | Workflow Automation

Detail-oriented professional specializing in optimizing financial operations for Homeowners Associations (HOAs) and automating complex workflows. Proven track record of mitigating collection fees, liens, and legal actions while preventing significant monthly late fees for clients.

workflow_automation_pipeline.gs

Raw HOA Data

11,000+ Properties

Apps Script Pipeline

bypass_importrange()

Central Hub

Auto-Synced Every 30m

$100kMonthly Fees Prevented
80%Manual Entry Reduced

A system that keeps every property in good standing with its HOA

Every property we manage answers to an HOA, and every HOA works through its own channels and timelines. I built the tools that turn that into one automated workflow: requests go out, documents come in, files are named and uploaded, and the master file keeps itself current. Requesting, compiling and uploading used to be done by hand. Now we always know where each property stands.

Requests go out in minutes

Requests to HOAs and management companies no longer go out one email at a time. A custom mail merge sends individualized emails in about 20 minutes, a job that used to take over 80 hours. Phone calls and mailed requests cover the rest.

80+ hrs → 20 min
Requests outsending
HOA
HOA
HOA
Individualized emails

Every channel feeds one pipeline

HOAs respond through whichever channel they use: the portals we are already registered on, email, phone, or mail. Whichever one it is, the information is captured in the same place.

4 channels, 1 destination
Incoming
PortalEmailPhoneMail
Documents in receiving…

Each project has its own source of truth

Our spreadsheets are segregated by project. Whatever an HOA sends back is recorded in the sheet for that project, so every workstream stays organized.

One sheet per project
Project sheets
Project AProject BProject C
PropertyAskedGotStatus

One master file shows every property

A master file brings every project type into a single view. Apps Script updates it on a set interval and pushes each property's portal data alongside its record, so current status is always one glance away.

Auto-updates every 30 min
Master fileevery 30 min
PropertyProjectsPortal data

Consistent file names, built in

A tool I built renames each document the same way, every time. That consistency is what makes the next step possible: files can be uploaded without anyone sorting or checking them by hand.

Same naming, every file
Renaming tool
  • scan0042.pdf1042_Statement_2026-10.pdf
  • Document (3).pdf1042_Invoice_2026-10.pdf
  • IMG_2231.pdf2210_Notice_2026-09.pdf

A document lands. Five seconds later, it's live.

No batches, no backlog, nobody waiting to compile and upload. Every file is renamed, uploaded and logged within about 5 seconds of arriving, so the website always reflects what we actually hold. Depending on the project, that is 15,000+ documents kept current in real time, and none of them sit in an inbox long enough to turn into a late fee or a lien.

15,000+ docs · ~5 sec each
auto-upload
$ watch renamed/
✓ new file landed
✓ uploaded in ~5 sec
✓ sheet updated

Compliant properties, fewer fees and liens

Because we know each property's status with its HOA, we stay current and compliant, and our clients avoid liens and late fees. These tools are what make that visibility possible across 11,000+ properties.

$100k/month in late fees prevented
Property status
  • Account current✓
  • HOA compliant✓
  • Late fees avoided✓
  • Lien avoided✓
Manual work stopped. The syncing never does.

Work Experience

$100k
late fees prevented per month
9
person team, up from 2
15,000+
documents uploaded as they arrive
1,238
community members, up from 826

Darwin Homes

Aug 2025 – Present

HOA Senior Accounting Specialist - Communications

  • Developed SOPs and improved processes to process prepayments for over 11,000 HOA-governed properties, preventing $100,000/month in potential late fees.
  • Architected a data pipeline via Google Apps Script to bypass IMPORTRANGE limits, partitioning assignee datasets and auto-collecting every 30 mins.
  • Scaled departmental operations from a 2-person initiative to a 9-person team, increasing team output by 30% and mentoring 6 members into permanent roles.
  • Implemented data validation protocols securing a minimum 95% data entry accuracy rate and an initial check clearance rate of over 90% on complex HOA financial data.
  • Automated HOA registrations by engineering an "Auto-Pull" UI, cutting manual data entry by over 80%.

Darwin Homes

Aug 2024 – Aug 2025

HOA Accounting Specialist - Communications

  • Developed a custom Mail Merge system via Google Apps Script, dispatching thousands of individualized emails in 20 minutes (previously 80+ hours).
  • Managed the lifecycle of sensitive financial records by uploading 15,000+ critical HOA documents, each within about 5 seconds of arrival, directly mitigating collection fees and liens.
  • Acted as primary point of escalation for complex account discrepancies to aggressively expedite the resolution of billing disputes.
  • Proactively engaged with HOAs via email and phone, maintaining meticulous records in the Communication Sheet to ensure accuracy.

Moonton

Area Admin (Visayas)

Jan 2022 – Mar 2025

  • Programmed custom automation scripts eliminating 6 hours of weekly manual data entry.
  • Supervised and mentored moderators for large-scale user base initiatives.
  • Directed positive user engagement in high-traffic digital spaces.

Moonton

Moderator (Leyte)

Feb 2021 – Jan 2022

  • Managed guidelines to maintain a safe environment for thousands of members.
  • Supervised 12 monthly digital events, growing active user base from 826 to 1238 members in a month.

Moonton

Student Leader

Sep 2020 – Feb 2021

  • Developed automated workflow tools to coordinate volunteers, reducing setup time by 2 hours.
  • Facilitated community-building initiatives and events for local gaming interests.

Skills & Capabilities

95%
minimum data entry accuracy
90%+
initial check clearance rate
6
members mentored into permanent roles

Technical & Automation

Scripting & Architecture

Google Apps ScriptWorkflow AutomationData PartitioningSpreadsheet OptimizationData Validation Protocols

Tools

Google WorkspaceZendeskAdobe Creative SuiteMicrosoft Office

Operations & Leadership

Management & Admin

Team Supervision & MentorshipSOP DevelopmentScale-up OperationsHOA Financial ReportingDispute ResolutionDocument Lifecycle Management

Community

Engagement StrategyEvent CoordinationContent Creation

Education

Leyte Normal University

B.S. in Biology (Medical Biology)

Tacloban City, Leyte • July 2023

Cum Laude (1.47 GPA)Charles Darwin AwardBest in Case StudyPracticum Proficiency

ACLC College of Tacloban

ICT - Programming

Tacloban City, Leyte • April 2019

With Honors

Interests

Beyond workflows and pipelines, here is what keeps me engaged and inspired:

InclusivityTechnologyBiologyCommunity DynamicsInnovationEngagementGamesMusicFilmsBeachesTravel