— ポートフォリオ · PORTFOLIO —
Cesar Lopez
Business analyst · turning data into solutions for the businesses that need them most
— 01 · ABOUT
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 · 日本語
— 02 · FEATURED WORK
Legacy Analytics
Giving family-owned businesses the analytics tools that only corporations used to have — so they can compete on the same level.
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
— 03 · SKILLS
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
— 04 · GET IN TOUCH