Building decision-ready financial models & analytics.

Excel financial models, Power BI dashboards, and SQL analytics. Built on real company data and designed for how finance leadership actually reads.

budget_variance.sql
SELECT d.department_name, SUM(b.amount) AS budget, SUM(a.amount) AS actual, SUM(a.amount - b.amount) AS variance, ROUND( (SUM(a.amount) - SUM(b.amount)) / SUM(b.amount) * 100, 1 ) AS var_pct FROM budget_plan b JOIN actuals a USING (dept_id, period) JOIN departments d USING (dept_id) WHERE b.period = '2025-Q4' GROUP BY d.department_name ORDER BY variance DESC; -- 4 rows · 11ms
BvA_2025Q4.xlsx
E8 =IFERROR((D8-C8)/C8,"")
Department Budget Actual Variance Var %
Sales & Mktg 4,750 6,128 +1,378 +29.0%
Research & Dev 3,240 2,630 (610) (18.8%)
Operations 5,180 5,312 +132 +2.5%
G&A 1,380 1,356 (24) (1.7%)
Total 14,550 15,426 +876 +6.0%
Executive Overview
Revenue $4.2M ▲ 12.4% vs PY
Gross Margin 41.3% ▼ 1.8pp vs PY
EBITDA $680K ▲ 8.6% vs PY
Revenue by Quarter ($K)
Power BI
SQL
Excel

Modeling, querying, visualizing financial data.

I turn raw financial data into models, queries, and dashboards that help teams see what's actually happening in the business.

  • Financial modeling, valuation, and variance analysis
  • Querying and structuring relational data for financial reporting
  • Interactive dashboards and DAX-driven KPI analysis

Why Financial Analysis?

I've seen what happens when a business has it, and when it doesn't.

Quick Summary
Core Philosophy Financial analysis isn't just modeling numbers. It's providing visibility for business leaders.
Working Style
  • Learn by building, not just studying
  • Uses AI as a development partner to build practical tools
  • End-to-end: SQL → Excel → Power BI

My family ran a café in Taiwan, and I helped manage operations for a stretch. That's where I first understood what financial visibility really means. Not as a concept, but as the difference between catching a cost problem early and missing it entirely. Budget vs. actual, variance by cost center, month-end commentary: I didn't learn why FP&A matters from a textbook. I learned it from watching what happens without it.

That experience is why I wanted to formalize the skill, not just rely on instinct. When I came to the U.S. to pursue my MSF at the University of Arizona, I made a rule: learn by building, not just studying. That habit didn't stay inside finance. Whenever I found a gap, I built a solution, from an automated job search tracker and a market monitor to this portfolio. Using AI as a development partner, I've learned to reach for the right tools to solve the problems in front of me.

That's why I chose financial analysis: not for the numbers, but for the visibility they give a business.

Open for Full-Time Roles

Interested in discussing financial modeling, FP&A opportunities, or potential collaboration?

Target Roles: Financial Analyst · FP&A Analyst · Financial Data Analyst

Available From January 2027