Let’s talk

MIGUEL RODRIGUEZ / DATA, CODE & DESIGN

I turn messy datainto useful tools.

Senior data analyst. Automation builder.
A designer who can also build the tool.

View résumé

Alteryx billing workflow~9 hours → 20 minutes/month

Alteryx · Python · Power BI · React / TypeScript
Reported 2023 result · initial setup separate

01 / BILLING AUTOMATION

Follow the record.
Find the difference.

DEMO-104 · A $160 mismatch, ready for review.

01 / Vendor export.xlsx
DEMO-104North Co $2,140
RecordVendorBilled
DEMO-102 Juniper LLC$1,080
DEMO-103ALDER-co$1,200
DEMO-104NORTH_CO $2,140
DEMO-105 Juniper LLC$1,440

Different names. Different date formats.

02 / Map the fields
NORTH_CO → North CoJan-26 → 2026-01
NORTH_CO North CoJan-26 2026-01DEMO-104 stays with the row.

A consistent schema for the next file.

03 / Match the records
One record.Export and ledger
key = vendor + period
    + invoice_id

join(export, ledger, key)
delta = billed - expected

Simplified logic · source stays attached.

04 / The exception
+$160Flagged for review
DEMO-104
Billed$2,140
Expected$1,980
Difference+$160

Flag the difference for analyst review.

05 / Review coverage
12 records checked
Hover, focus or tap a point
0 checked12 checked

9 matches. 3 items that need a decision.

06 / Review queue
3 exceptionsEvery source attached
104 Amount mismatch107 Duplicate key109 Missing account

The three exceptions, with their sources.

LOCKTON · BILLING AUTOMATION

One monthly task.
Hours given back.

The exception is visible. The monthly rebuild is gone.

Monthly processing timeLower is better
≈96%

less monthly
processing time

THE HIGH-LEVEL IMPACT

8 hours 40 minutes back per monthly run.

Clean the inputs, consolidate invoices, surface discrepancies—and put the recovered time into client decisions.

Reported in my Alteryx Day presentation, 2023. One workflow example; initial setup is separate. All invoice cards use fictional sample data.

Scroll to follow the record
Skip story

From the problem to the next useful step

One way of thinking.
Different kinds of work.

I connect research, software, and design so a clearer picture becomes something people can use. Choose a direction to see how that takes shape.

Make the evidence useful.

Python research, Power BI comparisons, and executive reporting—connected into three repeatable employee sentiment offerings.

Explore the analytics story
Employee sentimentResearch → Report
01Collect & structure
02Compare & explore
03Explain & share

Python research Power BI exploration Executive reporting

Employee sentiment intelligence · workflow illustration

There’s more behind each direction.

Browse all projects Try an interactive story

A good place to start.

For recruiters & teams

See the experience behind the work.

Explore my background in operations, analytics, and building tools—then follow the projects that fit the role you have in mind.

View résumé Get to know me

For businesses & collaborators

Bring a problem worth solving.

A recurring manual task, a clearer customer journey, or an idea that needs a useful interface. See where I can help and how we can begin.

Explore solutions Discuss a project