Luis Franco

Built
different.
Think.

Director, Compensation. Ten years building HR strategy, and the tools to execute it.

The HR professional who doesn't just design the strategy, but builds the tools to ship it.

Based in USA · Open to the right conversation

About

Strategy meets
execution.

I've spent over a decade inside demanding multinationals in consumer goods, professional services, beauty, manufacturing, and energy, learning how compensation and HR operations really work, not just how they're supposed to work.

What makes me different isn't just the strategy. I build the tools to execute it. Interactive dashboards, AI agents in Teams, automated workflows that replace hours of manual work. I close the gap between compensation expertise and technology that most professionals never bridge.

0 Years in Compensation & HR
0 Organizations · 3 Countries
0 Languages (EN · ES · PT)
0 AI-Powered Tools Built
What I've built

Tools that do
real work.

← Drag to explore →
01

Job Leveling Automation (2,500 JDs)

Power Automate flow that runs each job description through prompts I authored and published in AI Builder, one per dimension of the global career framework, and writes the scored level with reasoning to a spreadsheet. Replaced about 25 minutes of manual scoring per role, roughly 1,000 hours across the set, with consistent first-pass results in days.

Power AutomateAI BuilderJob Leveling
02

Candidate Offer Benchmarking Tool

Three-tab Excel model (candidate / data / dashboard) that pulls bonus-target and equity exports from the HRIS and runs offer scenarios across base salary, annual bonus, and equity in seconds instead of a manual rebuild each time.

ExcelScenario ModelingOffers
03

Salary Range Recommendation Macro

Generates posting-ready salary ranges from market data using 25th to 75th percentile logic, with fallback rules for job codes that have no incumbents. Turns a recurring analyst request into a one-click, consistent answer.

VBAMarket DataStandardization
04

Interactive Benefits Enrollment Engagement Tool

Gamifies employee benefits education using a browser-rendered physics simulation (real collision, gravity, and momentum) layered over structured survey logic. Zero dependencies. Pure HTML5 Canvas and JavaScript.

HTML5Canvas APIPhysics
05

AI-Powered Job Evaluation Agent

Conversational AI agent that automates role evaluation against a global job architecture and leveling framework. Guides users through seven competency dimensions and returns a defensible band and level placement with reasoning.

Conversational AIJob LevelingJob Architecture
06

Personal Productivity Hub

Client-side resource management tool with Kanban drag-and-drop, localStorage persistence, and JSON import/export. Custom brand-compliant UI in raw HTML/CSS/JS. Single shareable file. No server, no install.

HTMLKanbanlocalStorage
07

Configurable Employee Onboarding Hub

Fully self-contained single-file web application for onboarding new hires across any team or department. Reusable across roles without developer involvement. No backend, no tooling required.

HTMLHR ToolingNo-Code
08

Workforce Analytics Dashboard

Monthly compensation reporting layer built on top of HRIS exports. Drag-and-drop file loading, cross-filtering charts, and dynamic column detection so it keeps working when the source file format changes. Power BI companion for leadership views.

Power BIChart.jsSheetJS
09

HR Workflow Automation Suite

Inbox triage with a 24-hour response KPI tracker, executive project summarization, and HRIS data-extraction prototypes (RaaS and SOAP/OAuth), built to remove repetitive handling from the team's day and make turnaround measurable.

Power AutomateAI BuilderKPI Tracking
Track record

Before the tools,
the work.

A decade of fixing how HR actually runs: building functions from scratch, mapping broken processes, and shipping the change across eight organizations in three countries. Employers are left unnamed on purpose; ask me about any of these.

2023-2026
Consumer goods multinational

Executive salary review & long-term incentive cycles

Owned the annual executive salary review, long-term incentive, and reference-salary processes for all full-time and expatriate employees end to end, from data preparation through leadership approval, partnering with Global Mobility and Payroll so delivery stayed seamless and tax-compliant.

Cycles delivered on time, every year
2021-2022
Healthcare recruiting startup · employee #4

Built a Global Mobility program from zero

Designed the complete program from a blank page: how people move, which visa applies, the benefits and allowances. Then mapped how every element flows into payroll and its tax treatment in the home country. Wrote the policies and procedures so the operation could run without depending on any one person.

From nothing to a documented, repeatable operation
2019-2021
Big Four consultancy

Payroll process diagnosis & automation for multinational clients

For a multinational manufacturing client whose expatriates were reporting incorrect pay, audited the payroll end to end, defined gross and net wage codes, and automated the calculation to eliminate manual processing, and the complaints with it. Separately led a project that cut international mobility costs by 15% through tax planning and payroll efficiencies.

15% mobility cost reduction · manual processing removed
2016-2017
Global beauty & cosmetics group

Established a formal Global Mobility function

Turned ad-hoc expatriate handling into a defined area. Working with the HR Director, wrote new policies for all of Latin America based on current market practice, set limits for benefits and extraordinary payments, and regularized payroll tax payments. One consistent framework instead of case-by-case decisions.

One policy set for all of Latin America
2014-2016
Industrial manufacturer

1,500+ person cross-border relocation program

When a new plant opened in Texas, coordinated the movement of the technicians needed to run it from Mexico: visa petitions, labor certifications, government audits, and requests for evidence. Moved over 1,500 people in two years while supervising the team's daily operations.

1,500+ relocations in 2 years
2014
Consumer & industrial goods multinational

Centralizing recruiting into a shared service center

Part of the team that moved Latin America recruiting from Brazil into the Mexico service center: mapped the current process, simplified it, and brought the operation live in its new home without interrupting hiring.

Regional process consolidated
2011-2013
Oilfield services multinational

Mapping and streamlining expatriate payroll

Documented and optimized the payroll and tax-compliance process for internationally mobile employees in Latin America, while leading regional talent acquisition projects, training and coaching teams on sourcing, screening, and relocating employees.

Expat payroll process standardized

Just exploring?

Let's keep it casual.

Browse around. No pressure. If something resonates, you know where to find me.

Say hello →
Just browsing
Ready to hire
Expertise

Where I
add value.

Compensation & Total Rewards
Salary StructuresPay EquityMerit CyclesJob ArchitectureMarket BenchmarkingIncentive DesignFLSA ClassificationCompa-Ratio AnalysisAnnual Bonus Plans
Global Mobility
Multi-Country PricingScope PremiumsExpat PayrollCost-of-Living AdjustmentsAssignment PoliciesImmigration Support
Technology & Automation
Power AutomateCopilot StudioAI BuilderPower BISharePointWorkdayHTML / CSS / JSVBA / Excel
HR Operations
HRIS AdministrationWorkforce AnalyticsHR Data ReportingPolicy DesignStakeholder CommunicationTrilingual (EN / ES / PT)
Process & Transformation
Process MappingCurrent-State AnalysisSOP DesignContinuous ImprovementKPI & Operational DashboardsChange ManagementCross-Functional DeliveryPilot & Scale
Contact

Let's have
a conversation.

If you're building a world-class HR function and need someone who can design the strategy, fix the process, and build the tools to execute it, reach out.

Connect on LinkedIn