wenwenguo.me

Wenwen GuoFinance + Data + Execution

Financial Data Analyst · FP&A · Decision Support · Accounting

Financial Analyst & Accountant with three years of experience in accounting and financial reporting. My work spans month-end close, reconciliations, AR/AP analysis, cash flow management, and financial reporting.

During audit prep, I've identified revenue gaps and expense recovery discrepancies that had gone undetected — that's where I tend to add the most value.

I also build VBA and Python tools to automate manual, rule-based workflows, cutting down on repetitive work and the errors that come with it.

View selected workpanel.fyi ↗
FP&AForecastingFinance SystemsPanel.fyiAutomationDecision SupportOps IntelligenceFinancial StorytellingAP/ARAccountingFP&AForecastingFinance SystemsPanel.fyiAutomationDecision SupportOps IntelligenceFinancial StorytellingAP/ARAccounting

Signature Project

panel.fyi

A modular command center for operations and finance: cash flow, people, properties, and execution in one unified workflow.

Open panel.fyi

What I Do

Financial clarity that drives decisions

Clean books, accurate reports, and the analysis behind them — built to give ownership and management a clear picture of where things stand.

Portfolio coverage

0+ assets

On-time payment improvement

0%

Core domain

FP&A · Ops Finance

Selected Work

Internal Finance Collaboration Workspace

2026

Designed a finance-oriented internal workspace that connected cash flow, calendar, people, properties, and accounting context in one operational view.

  • • Reduced communication friction between finance and operations teams.
  • • Improved decision speed by standardizing how context and updates were shared.
  • • Defined next-phase roadmap for task ownership and execution tracking.

Panel.fyi Product Experience

2026

Built and launched panel.fyi as a modular operations control room that unifies people, properties, cash flow, and daily execution into one workspace.

  • • Designed a customizable module-based interface for different operational priorities.
  • • Integrated workflow automation concepts to reduce repetitive coordination overhead.
  • • Shaped product narrative and UX to bridge finance logic with team execution.

Website: panel.fyi

View project
Experience

Tripalink Corp

Financial Data Analyst

Jun 2023 — Mar 2026

Los Angeles, CA

  • • Led portfolio-level financial and operational analysis across 350+ assets and multiple entities.
  • • Built monthly variance reporting frameworks to identify leakage, improve controls, and accelerate follow-up actions.
  • • Automated late-fee charging workflows, contributing to a 25% improvement in on-time payments.
  • • Supported M&A diligence through trend analysis, unit economics, and scenario modeling.

Tripalink Corp

Business Operations Intern

Oct 2021 — Dec 2021

Los Angeles, CA

  • • Supported tenant and vendor billing workflows with reconciliation across operational and accounting records.
  • • Assisted accounts payable documentation and expense tracking under internal control requirements.

FP&A

  • • Forecasting & scenario planning
  • • Budget vs. Actual variance analysis
  • • Unit Economics and KPI diagnostics
  • • Executive-ready financial storytelling

Data & Systems

  • • Financial modeling (Excel)
  • • Python automation
  • • Power BI dashboards
  • • Workflow automation (Power Automate & Excel VBA)