— ポートフォリオ · PORTFOLIO —

Cesar Lopez

Business analyst · turning data into solutions for the businesses that need them most

Download resume

A Business Analytics student at the University of Texas Rio Grande Valley, studying at the Robert C. Vackar College of Business & Entrepreneurship. I focus on turning small business data into practical decisions.

Bilingual in English and Spanish, currently learning Japanese. Membership Director on the 2026 Side Hustle Society Board of Directors at UTRGV.

STATUS
Available
LOCATION
Edinburg, TX
LANGUAGES
EN · ES · 日本語
Legacy Analytics
2026 · rgvlegacy.com
Giving family-owned businesses the analytics tools that only corporations used to have — so they can compete on the same level.
Legacy Analytics main dashboard showing business health score
Business Health Score with 8 operational vitals
◦ PROBLEM
Family businesses run on gut instinct because enterprise analytics tools are built for corporations — expensive, complex, and out of reach. Meanwhile, chains use data to outmaneuver them at every turn.
◦ APPROACH
Interviewed local RGV business owners to understand how they actually make decisions. Designed tools around the data they already have — not the data enterprise software expects them to collect.
◦ SOLUTION
A bilingual platform with 7 essential tools — sales, cash flow, expenses, taxes, funding, succession, reviews — in one place. Simple enough for a first-time user. Powerful enough to compete.
◦ IMPACT
Created a pathway for small business owners who want to level up but never had the tools. Pivoted from gated tiers to a 14-day free trial after user feedback revealed conversion friction was the real barrier — not price.
◦ TECH STACK
Next.jsTypeScriptSupabasePostgreSQLRechartsTailwind
Data & Analytics
SQL, Excel (advanced), Tableau, Power BI, Python, R
Databases
Supabase (PostgreSQL), Microsoft Access, Data Modeling, Data Cleaning
Development
TypeScript, Next.js, Recharts, Git
Analytical
Business Insights, Pattern Recognition, KPI Development, Dashboard Reporting