RL Rodolfo Lopez
About Work Skills Contact Resume ↓
Rodolfo Lopez
Operations · Analytics · Automation

Hi, I’m Rodolfo.

Operations and analytics manager who turns messy operational data into the dashboards and forecasts leadership runs on. Eight years owning seven-figure budgets and FP&A, building Power BI from the ground up, and automating the busywork in between, including AI workflows I build myself. Finance-minded, bilingual, and happiest where data meets decisions.

Get in touch Download resume
7-figure
Annual budget managed
$2.3M+
Revenue tracked in Power BI
100+
Interns on a $1M initiative

A bit about me

At FAU's Career Center I run a seven-figure budget and built our Power BI reporting from scratch. I also handle a lot of the behind the scenes work, process improvements, CRM, the things that keep a busy office running without drama.

What I like about the work is the variety. One day I am deep in a budget variance, the next I am building a dashboard or setting up an automation to take a tedious task off someone's plate. I am not just the person who reports the numbers. I build the systems that create them and the workflows around them.

I have a Lean Six Sigma Green Belt and an MBA, and I grew up speaking both English and Spanish.

Power BI & DAXFP&A & BudgetingProcess Automation AI WorkflowsWorkdayBilingual EN/ES

Capabilities

Analytics & BI

  • Power BI & DAX
  • Data modeling
  • Dashboard development
  • Advanced Excel
  • KPI & report automation

Finance & Ops

  • Budget management
  • FP&A & forecasting
  • Variance analysis
  • Cost optimization
  • Reconciliation

Systems & Automation

  • Workday (HRIS)
  • Handshake CRM
  • Process automation
  • AI tools (ChatGPT, Claude)

Leadership & PM

  • Lean Six Sigma
  • Process improvement
  • Stakeholder management
  • Change management
  • SOP development
Reports

Selected work

Real projects from my current role. Charts are illustrative representations using sample data, not confidential records.

Presidential Internship Analytics PlatformBusiness Intelligence
Designed and own · Florida Atlantic University

Built the end to end system that tracks every intern in a $1M institutional initiative. A Power BI dashboard plus Excel database logs each student’s hours worked, pay, position, and employer, turning scattered payroll records into one clear view leadership can act on.

100+
Interns tracked
16,600+
Hours logged
$300K+
Intern pay tracked
35
Employers
Power BIDAXExcelPayroll trackingWorkday data
Hours logged by internsample
21218015613210896 123456 Hours logged per intern · 100+ tracked
Illustrative · sample data
Budget Intelligence DashboardFP&A · Finance
Built and maintain · Florida Atlantic University

Replaced manual spreadsheet reporting with a real time Power BI dashboard that reconciles 4,000+ annual transactions across two source systems (TouchNet and Workday) and surfaces multi year variance across 90+ spend categories, giving leadership live spend versus budget visibility.

4,000+
Transactions / yr
90+
Spend categories
4 yrs
Variance history
Power BIDAXData modelingFP&ATouchNet + Workday
Budget vs. actualFY23 to FY26
FY23FY24FY25FY26 BudgetActual
Illustrative · sample data
Career Fair Revenue TrackerRevenue Ops
Built and maintain · Florida Atlantic University

Consolidated eight years of career fair revenue into a single Power BI model: $2.3M+ in gross revenue across 117 events, benchmarked against annual goals. One view for year over year trend, goal attainment, and per event performance.

$2.3M+
Revenue consolidated
117
Events analyzed
8 yrs
Trend history
Power BIGoal trackingTrend analysisExcel
Revenue vs. goal8-year trend
ActualGoal
Illustrative · sample data
AI Email-to-Task Automation & Project TrackerAutomation
Designed and built · Operations workflow

Built an automation that detects flagged action emails and creates structured tasks in a Notion project tracker, with no manual triage. It has grown into a real operational system: hundreds of tasks and projects captured with priority, category, status, and completion, giving me one source of truth for follow through.

297
Tasks captured
95%
Driven to completion
0-touch
Email to tracker
Workflow automationAPI integrationNotionAI toolingProcess design
Task completionn = 297
95% complete Done · 282 Not started · 3 In progress · 3 Recurring · 9
Live Notion data · names removed
Cooling Break: Sports Analytics LabIndependent Lab
Built and shipped solo · public data, open code

My personal sports analytics lab. The flagship project, Cooling Economy, tracked all 104 matches of the 2026 World Cup to test whether the mandatory cooling breaks changed match play, and modeled what the break airtime was worth in US ad money. An automated pipeline (ESPN and weather APIs into SQLite, refreshed twice daily by GitHub Actions) fed a bilingual dashboard where every figure is labeled as fact, estimate, or assumption.

104
Matches tracked
$351M+
Ad value modeled
2×/day
Automated refresh
EN·ES
Bilingual build
PythonSQLiteGitHub ActionsData pipelineChart.js

Visit the lab ↗

Goals around the cooling breaksreal data
5953 10 min before 10 min after Gap stayed within chance · verdict: no effect
Real tournament data · live dashboard

Let's build something that runs on data.

Open to operations, analytics, BI, and FP&A leadership roles across South Florida and remote.

rdflopez@gmail.com LinkedIn GitHub Resume (PDF)
Lake Worth, FL 33463