📋 Book Free Audit
Open to Work · Available Now
Revenue Operations · Systems Builder · Iloilo City, PH

Louis Roy
Sebastian

I help BPO teams scale using custom-built systems — without expensive software vendors.

10+ years managing 50+ agents across live campaigns. Every tool I built replaced a broken manual process. I don't just run operations — I engineer them.

10+
Years in BPO Ops
50+
Agents Managed
7
Systems Built
$0
Vendor Cost
Louis Roy Sebastian — BPO Systems & Operations Manager
Scroll to explore

Why Your Operation
Is Struggling

Most BPO operations bleed hours, money, and performance every single day — not because the team is bad, but because the systems are broken. Sound familiar?

⏱️
Attendance is tracked manually

Spreadsheets, paper logs, and morning headcounts eat 2–3 hours of manager time daily — and still produce errors that hit payroll.

📉
You don't know why a campaign is failing

DPH is down, TPH is tanking — but there's no structured system to diagnose the root cause in real time, so you guess and react instead of fix.

💸
Software bills keep climbing

You're paying for attendance software, scheduling tools, and analytics platforms that don't talk to each other — and still require manual workarounds.

🔍
No real-time floor visibility

Managers walk the floor to get headcounts. There's no live dashboard showing who's active, who went home early, and which campaign is underperforming.

📋
Scheduling is chaos

Day-off requests come through chat messages. PTO tracking is in someone's personal sheet. Nobody has a single source of truth.

🤷
Agent performance is a mystery

You know who's hitting goal at end-of-day. But by then it's too late to coach, adjust, or intervene. You need hourly visibility — not a daily report.

If any of these hit home — your operation needs a system audit.

Get Free Audit →

How I Fix It

01
Diagnose the real problem

I audit your current ops — attendance flow, campaign performance, scheduling, and reporting — and identify every hour being wasted on manual processes.

02
Build a custom system

I design and code tools specific to your floor — not off-the-shelf software. HTML, JavaScript, Google Workspace. Fast to deploy, zero vendor lock-in, zero ongoing cost.

03
Automate the daily grind

Attendance syncs automatically. Payroll data flows to sheets. Scheduling enforces its own rules. Your team stops managing processes and starts running campaigns.

04
Give managers real visibility

Live dashboards show floor status by campaign in real time. Campaign diagnosis reports identify root causes within minutes. Decisions get faster and more accurate.

Typical Results After System Build
Time saved on attendance daily2–3 hrs
Payroll error reduction~80%
Software vendor cost replaced$0
Campaign diagnosis speed< 1 min
Manager floor visibilityReal-time
System deployment time2 days

Real Systems,
Real Results

01
Attendance System
Attendance Kiosk v2
3h
Saved Daily
80%
Fewer Errors
$0
Vendor Cost
+
❌ The Problem
  • Attendance tracked with paper logs and manual headcounts every shift
  • No visibility into who was active, who went home early, or campaign-level attendance
  • Payroll discrepancies caused by manual entry errors every biweekly period
  • Night differential calculation done manually — slow and error-prone
⚙️ The Solution
  • Built a browser-based kiosk with QR scan + manual ID entry for time in/out
  • Auto-calculates billable hours and night differential (EST-based) on clock-out
  • Groups agents by campaign in real time — manager sees full floor in one view
  • Syncs directly to Google Sheets, supports shift close with archive and CSV export
  • PIN-protected manager config panel with date/week selector for payroll accuracy
✅ The Result
  • Eliminated 2–3 hours of daily manual timekeeping work
  • Payroll errors dropped by ~80% in the first biweekly cycle
  • Managers gained instant real-time floor visibility for the first time
  • Night differential disputes resolved automatically — no manual recalculation
  • Zero vendor cost — replaced paid attendance software entirely
📸 Live Screenshot
Attendance Kiosk v2 — Live interface running on the operations floor
Attendance Kiosk v2 — Live interface running on the operations floor
Attendance Kiosk v2 — Live Floor View
18
Active Now
5
Timed Out
2
Sent Home Early
2023-2061Alanan, Rexie B.PAC OVS AA10:02 AM● active
2024-1309Dumago, Aisha K.PAC OVS AA09:58 AM06:01 PM✓ done
2025-0338Butal, Jhan L.New Donors10:05 AM● active
Floor Attendance Progress25/25
JavaScriptGoogle Apps ScriptjsQRJSONPGoogle Sheets
02
Management Command Center
Manager Dashboard
Live
Floor View
30s
Auto-Refresh
All
Campaigns
+
❌ The Problem
  • Managers had no single view of all agents across all campaigns simultaneously
  • Floor walks required to get attendance status — wasted manager time every hour
  • No way to filter active vs. done agents or search by name/ID in real time
  • Shift data lost at end of day — no archive for payroll or performance review
⚙️ The Solution
  • Built a secure authenticated dashboard grouped by campaign with live status
  • Auto-refreshes every 30 seconds — managers see floor in real time from any device
  • Filter by status (active/done/early) and search by name or employee ID
  • Shift close archives all records to a named Google Sheets tab automatically
  • Auto-complete feature handles agents who forget to time out
✅ The Result
  • Eliminated floor walks — managers manage from desk with full visibility
  • Shift archiving created a reliable payroll audit trail for the first time
  • Campaign-level grouping let managers spot attendance issues by team instantly
  • CSV export replaced manual end-of-day attendance reports entirely
📸 Live Screenshot
Manager Dashboard — Live floor view grouped by campaign
Manager Dashboard — Live floor view grouped by campaign
Manager Dashboard — Campaign View · Live
18
Active
5
Timed Out
1
Auto
1
Early
25
Total
📢 DIRECT PAC OVS AA · 16 agents · Active 14 · Done 2
2023-2061Alanan, Rexie B.10:02 AM● active
2024-1309Dumago, Aisha K.09:58 AM06:01 PM8h✓ done
JavaScriptGoogle SheetsJSONPReal-time
03
Business Intelligence Tool
Campaign Diagnosis System
<5m
Diagnosis Time
100%
Offline
$0
Backend Cost
+
❌ The Problem
  • When a campaign underperformed, root-cause analysis took 30–60 minutes of manual review
  • Managers relied on gut feel — no structured diagnostic framework
  • Challenges were identified too late in the shift to course-correct effectively
  • Action plans were inconsistent across managers — no standardized response playbook
⚙️ The Solution
  • Built a fully offline rule-based diagnostic engine in a single HTML file
  • Managers input live metrics (DPH, TPH, answer %, HUG/HUMP/NIMP, objections)
  • System runs a rule engine to identify high/med/low priority challenges instantly
  • Outputs a prioritized action plan with urgency tags and owner assignment
  • No API, no backend, no login — works on any device with a browser
✅ The Result
  • Diagnosis time reduced from 30–60 minutes to under 5 minutes per campaign
  • Managers across all shifts apply the same diagnostic framework consistently
  • Mid-shift corrections became standard practice instead of reactive guessing
  • New team leads trained 60% faster using structured action plans as coaching guides
📸 Live Screenshot
Campaign Diagnosis System — Real input form and live diagnosis engine
Campaign Diagnosis System — Real input form and live diagnosis engine
Campaign Diagnosis System — Diagnosis Report
CRITICAL — IMMEDIATE ACTION REQUIRED
Direct PAC OVS AA · 2nd Hour
$17.40
DPH (goal $20.40)
0.48
TPH (goal 0.56)
16.4%
Answer Rate
HIGH PRIORITY CHALLENGES
Critical greeting failure. 22% HUG rate — prospects hang up before value delivered.
Phone channel resistance. Multiple card-over-phone objections — trust barrier detected.
JavaScriptRule EngineOfflineSingle File
04
Analytics Dashboard
Agents Performance Tracker
Hourly
Visibility
25+
Agents Tracked
7
Report Sheets
+
❌ The Problem
  • Agent performance only visible at end of day — too late to coach or intervene
  • No structured way to identify top vs. bottom performers during a live session
  • Raw data from the RXR dialer system had to be manually reformatted before analysis
  • No hourly DPH/TPH breakdown by agent — managers flew blind mid-shift
⚙️ The Solution
  • Built a multi-sheet Google Sheets system with 7 interconnected tabs
  • Structured RXR data intake pipeline — paste raw data, system maps and calculates automatically
  • Hourly DPH and TPH breakdown per agent with color-coded goal indicators
  • Auto-sorted leaderboard ranks agents by running DPH — top and bottom performers visible in seconds
  • KPI summary sheet shows campaign-level totals, hitting/not-hitting counts, and attainment rate
✅ The Result
  • Managers identified underperforming agents within 30 minutes of the shift start
  • Real-time coaching interventions became standard — not just end-of-day reviews
  • Campaign attainment reporting to clients became faster and more accurate
  • Replaced three separate manual tracking processes with one integrated system
📸 Live Screenshot
Agents Performance Tracker — Google Sheets dashboard with real campaign data
Agents Performance Tracker — Google Sheets dashboard with real campaign data
Agents Performance Tracker — Live Campaign View
AV81 7000 DIRECT PAC OVS AA — NEW DATA · 2nd Hour
AgentStatusHrsSalesDPHTPH
Dumago, Aisha K.Tenured87$53.130.88
Pineda, Cryzyl F.Tenured810$41.881.25
Masiado, AldrinTenured61$4.170.17
$24.07
Running DPH
0.83
TPH
4
Hitting Goal
21
Not Hitting
Google SheetsFormulasData PipelineKPI Tracking
05
Agent Self-Service Suite
Agent Portal + Scheduler
2
Modules
50+
Agents
Auto
Rule Check
+
❌ The Problem
  • Agents messaged managers directly for every time-in/out query and PTO request
  • Scheduling was tracked in someone's personal spreadsheet with no enforcement
  • Day-off slot caps (Live: 3, Non-Live: 4) constantly violated — no system to enforce rules
  • Managers spent 30+ minutes daily handling scheduling admin instead of coaching
⚙️ The Solution
  • Agent Portal: self-service time in/out with auto billable hours + night diff calculation
  • Scheduler Portal: agents submit day-off and PTO requests directly — system enforces rules
  • Built-in rule blocks prevent Sunday/Tuesday PTO and enforce slot caps by group
  • All data routes to Google Sheets automatically — manager reviews, not processes
  • Motivational messaging on time-in/out — small UX touch with real morale impact
✅ The Result
  • Manager scheduling admin time dropped from 30+ min/day to near zero
  • Slot cap violations eliminated entirely — system enforces rules automatically
  • Agents became self-sufficient for routine requests — managers focus on coaching
  • PTO approval process standardized and trackable for the first time
📸 Live Screenshot
Agent Portal — Login screen agents use to clock in/out for every shift
Agent Portal — Login screen agents use to clock in/out for every shift
Agent Portal — Shift Complete View
👏
Great shift, Rexie!
Every shift counts — see you!
8h
Billable
7h
Night Dif
JavaScriptGoogle Apps ScriptMobile-firstRule Engine
06
Automated Email System
Agent Campaign Newsletter
Auto
Weekly Send
50+
Agents Reached
$0
Email Tool Cost
+
❌ The Problem
  • Weekly bonus reports, HR announcements, and campaign updates were sent manually via group chat — easily missed or ignored
  • No consistent communication channel between management and all agents
  • Agents had no visibility into their peers' performance or weekly campaign highlights
  • Shift schedules, secrets for earning more, and success stories had no structured delivery format
⚙️ The Solution
  • Built a fully automated weekly newsletter system using Google Apps Script
  • Personalized per agent — each email opens with the agent's name pulled from the roster
  • Covers weekly bonus reports, top performers, HR updates, shift schedules, and campaign news
  • Formatted as a rich HTML email with branded sections — sent directly to each agent's Gmail
  • Zero manual effort each week — script runs on a scheduled trigger automatically
✅ The Result
  • Every agent receives a consistent, professional communication every week — no one misses updates
  • Bonus transparency increased agent motivation and healthy competition on the floor
  • Management communication load dropped significantly — no more manual group announcements
  • Zero email platform cost — built entirely on Google Apps Script and Gmail
📸 Live Screenshot
Agent Campaign Newsletter — Real email delivered to agents every week
Agent Campaign Newsletter — Real email delivered to agents every week
Agent Campaign Newsletter — Weekly Send · Gmail
📢 DP OVS AA REMINDERS
Campaign
Newsletter
Week of Mar 16 – Mar 21, 2026
Hello Alanan, Rexie Basadre,
Welcome to this week's campaign newsletter — highlighting top performers, HR updates, announcements, shift schedules, secrets for more money and inspiring success stories.
💰 Weekly Bonus Report (Mar 16 – Mar 21)
Monday
• Herwin – $6.50  •  Pamela – $3.60
• RonaMae – $3.60  •  Vince – $3.20
Google Apps ScriptGmail APIHTML EmailAutomated TriggersGoogle Sheets
07
Automated Payroll Email
Biweekly Agent Dial Hours Report
Auto
Per-Agent Send
2-Week
Breakdown
Zero
Manual Work
+
❌ The Problem
  • Agents had no personal record of their dialed hours or night differential per pay period
  • Payroll disputes arose because agents couldn't verify their own hours
  • Generating individual hour summaries manually for 50+ agents every two weeks took hours of admin work
  • No transparent communication between payroll data and the agent who earned it
⚙️ The Solution
  • Built a Google Apps Script that reads biweekly attendance data from Google Sheets
  • Generates a personalized HTML email for each agent showing their full two-week breakdown
  • Displays: Grand Total dialed hours, Night Differential, and a daily breakdown table
  • Sent directly to each agent's registered email — branded, professional format
  • Runs on a scheduled trigger every two weeks — zero manual effort after setup
✅ The Result
  • Payroll disputes eliminated — agents verify their own hours before payday
  • 50+ personalized emails generated and sent in seconds, not hours
  • Agents became more engaged with their own attendance and night differential tracking
  • HR admin burden for hours verification reduced to near zero
📸 Live Screenshot
Biweekly Dial Hours Report — Actual email sent to agents showing their hours breakdown
Biweekly Dial Hours Report — Actual email sent to agents showing their hours breakdown
Biweekly Dial Hours Report — Agent Email · Mar 16–29, 2026
● DP OVS AA REMINDERS
Agent Dial Hours
Two-Week Report
Mar 16 – Mar 29, 2026
Hello Alanan, Rexie Basadre,
Here is your dialed hours summary for the past two weeks.
Total Dialed Hours
71
Night Differential
59
Google Apps ScriptGmail APIHTML EmailGoogle SheetsScheduled Triggers
Your team deserves
systems that actually work

Every tool above was built for a real floor, solving a real problem. I can build the same for yours.

Trusted by the People
Who Use It Daily

Roy built systems that saved us hours every single day. The attendance kiosk alone eliminated our biggest payroll headache — we haven't touched a paper log since.

Floor Manager
BPO Operations, Iloilo City

The campaign diagnosis tool changed how we run our shifts. We used to spend 45 minutes figuring out why a campaign was underperforming. Now it takes 5 minutes and we have an action plan.

Campaign Supervisor
Outbound Sales Team

What Roy builds actually works on the floor. It's not over-engineered. It's exactly what you need, nothing more. And he built it himself — no vendors, no delays, no excuses.

Team Lead
Direct PAC Campaign

Clear Offers,
Clear Outcomes

🔍
Offer 01
Free Ops Audit

A structured 60-minute review of your current operations — attendance, performance tracking, scheduling, and reporting. I'll tell you exactly where you're bleeding time and money.

  • Full operations assessment call
  • Written breakdown of inefficiencies found
  • Priority action list with quick wins
  • Custom system recommendation
Book Free Audit →
🚀
Offer 03
Full Ops Overhaul

End-to-end transformation of your BPO operations. I come in, assess everything, rebuild your systems from scratch, and train your team to use them — in 30 days or less.

  • Complete ops audit & diagnosis
  • Full system suite build (all modules)
  • SOP documentation & playbooks
  • Manager & agent onboarding
  • Ongoing consulting retainer available
Fix Your Ops in 30 Days →

The Manager Who
Also Builds

I'm Louis Roy Sebastian — a BPO Team Manager with 10+ years of floor operations experience based in Iloilo City, Philippines. I've managed teams of 50+ agents across multiple concurrent campaigns, driving performance at scale in high-pressure outbound environments.

My edge is simple: most operations managers run systems. I build them. Every tool in this portfolio was created by me, for a real operational problem, using HTML, CSS, JavaScript, and Google Workspace — at zero vendor cost.

I'm currently open to full-time remote opportunities in Operations Management, Sales Management, or Team Lead roles. I'm also available for consulting and custom system builds through SBSTN, my consulting brand.

  • BS Information Technology — University of San Agustin
  • Cisco CCNA Certified
  • Red Hat System Administrator Certified
Operations
Team LeadershipBPO ManagementCampaign DiagnosisPerformance CoachingSOP DevelopmentWorkforce PlanningSales Coaching
Development
HTML / CSSVanilla JavaScriptGoogle Apps ScriptGoogle SheetsREST APIs / JSONPQR Integration
Platforms
Google WorkspaceNetlifyGitHubClaude CodeCisco CCNARed Hat Linux

Let's Build
Something That Works

⚡ Response within 24 hours

Open to full-time remote roles in Operations Management, Sales Management, and Team Lead positions. Also available for consulting engagements and custom tool builds.

📋 Book Free Ops Audit