Financial Analyst · FP&A

Christian
Pean.

I turn enterprise-scale financial data into forecasts, models, and reporting that leadership actually acts on — built on five years across Fortune 500 FP&A and startup operations.

Portrait of Christian Pean
$9B+
Enterprise ops supported
$31M+
SG&A spend owned & analyzed
50%
Faster reconciliation turnaround
$7M+
Cost savings identified

About

I'm a Financial Analyst with two years of Fortune 500 FP&A experience supporting $9B+ in enterprise operations, plus three years leading operations for an e-commerce startup. My strengths sit at the intersection of financial modeling, Excel automation, and KPI reporting — I build the systems that turn raw transactional data into forecasts and dashboards leadership can act on. I'm looking to keep streamlining reporting, delivering insight to executives, and supporting day-to-day financial initiatives, all grounded in GAAP principles. Based in Raleigh, NC, and open to relocation.

Experience & Education

MAY 2024 — APR 2026
Advance Auto Parts
Fortune 500 · 4,000+ stores
Advance Auto Parts logo
shop.advanceautoparts.com
Financial Analyst, FP&A
  • Key contributor to the SG&A operating plan, monthly forecast, and outlook for assigned cost areas across a $9B+ retailer, producing executive-facing reporting through a large-scale transformation
  • Automated and standardized enterprise sales reporting covering $1B+ in revenue and $300M+ in SG&A using SQL, Power Query, and advanced Excel modeling — cutting reconciliation turnaround by 50% (3 hours)
  • Ran independent P&L analysis across Revenue, COGS, and SG&A, surfacing trends, variances, and risks through dashboards built for executive, regional, and store-level leadership
  • Owned $24M+ in Security Services and $5M–$9M in Telecom spend, preparing and communicating monthly variance-to-plan reporting that shaped cost-reduction decisions
  • Identified $7M+ in enterprise-wide savings for Project Gold, a 500+ store restructuring initiative, through ad-hoc financial analysis
JUN 2021 — APR 2024
Delta House Raleigh & Circle Freaks LLC
E-commerce · ~$100K/mo revenue
Delta House Raleigh logo
Delta House Raleigh · LinkedIn
Senior Operations Analyst
  • Supported budgeting, planning, and cash management for a $100K/month revenue e-commerce startup
  • Independently implemented process improvements to manage 500+ SKUs, improving inventory management accuracy by 20%
  • Analyzed customer, product, and funnel data to identify trends that helped drive a 38% repeat-customer rate through high-engagement communities
  • Created Standard Operating Procedures (SOPs) and spreadsheets for customer service resolution and refund reconciliation
  • Worked closely with senior management to address cost determination, optimize inventory valuation, and enhance product pricing strategies
AUG 2022
Florida Atlantic University logo
fau.edu
Bachelor of Business Administration, Finance
Florida Atlantic University — Boca Raton, FL

Skills

Programming & Tools

SQL (Snowflake) Excel (Power Query, XLOOKUP, Advanced Formulas) Power BI Tableau Oracle ERP QuickBooks AI Tools (Claude, CoPilot, ChatGPT)

Financial Planning & Analysis

Forecasting Variance Analysis SG&A Analysis Budget Allocation P&L Reporting KPI Reporting Cost Optimization Pricing Strategies Valuation Metrics (EBITDA, EBITAR) CapEx Segmentation

Certifications

Google Advanced Data Analytics Certificate Google Data Analytics Certificate Codecademy — Learn SQL Codecademy — Learn Tableau for Data Visualization

Areas of Expertise

FP&A

Forecasting & Planning

Monthly forecasts, operating plans, and outlook processes aligned to enterprise financial objectives.

Reporting

Executive Dashboards

Power BI and Tableau reporting built for executive, regional, and store-level decision-making.

Analysis

Variance & Cost Optimization

P&L, SG&A, and spend analysis that surfaces risk, opportunity, and clear paths to savings.

Automation

SQL & Excel Automation

Standardized, automated reporting models that replace manual processes and cut turnaround time.

Let's connect.

Open to relocation and always glad to talk FP&A, financial modeling, or reporting automation.