RL Rodolfo Lopez
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.

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

Let's build something that runs on data.

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

Lake Worth, FL 33463