📊 Financial Analyst Portfolio

Jamie Christian II
FP&A • Financial Modeling • Strategic Finance • Executive Reporting

---

👋 Overview

Welcome to my Financial Analyst Portfolio.

This repository showcases job-ready, real-world financial analysis projects demonstrating strong capability across:

• Financial Planning & Analysis (FP&A)
• Budgeting, Forecasting & Rolling Projections
• Variance Analysis (Actuals vs Budget vs Forecast)
• Profitability & Margin Analysis
• Financial Modeling & Scenario Analysis
• KPI Dashboards & Executive Reporting
• Strategic, data-driven recommendations for leadership

These projects reflect the level of work expected from:

FP&A Analysts • Corporate Finance Analysts • Strategic Finance Analysts • Consulting Analysts

---

📂 Featured Portfolio Projects

📁 01_FPA_Executive_Dashboard

FP&A Executive Performance Dashboard

• Revenue vs Budget vs Forecast analysis
• Expense breakdown & variance drivers
• EBITDA & operating margin tracking
• Executive KPI scorecard
• Built using Power BI + structured Excel financial model

📸 Screenshot:

Images/fpa_dashboard.png

---

📁 02_Amazon_Marketplace_Analytics

Marketplace Financial Performance Analysis

• Revenue, GMV, contribution margin analysis
• Unit economics (LTV, CAC, ROI)
• Segment-level profitability
• Executive-style financial storytelling

📸 Screenshot:

Images/amazon_dashboard.png

---

📁 03_Profitability_and_COGS_Analysis

Cost Structure & Margin Deep Dive

• Gross margin and contribution margin analysis
• COGS drivers & cost sensitivity modeling
• Pricing and profitability scenarios
• Excel financial model with real formulas

📸 Screenshot:

Images/cogs_analysis.png

---

📁 04_Executive_Financial_Performance

Executive Financial Review

• Financial trend analysis
• Performance vs targets
• Key business drivers
• Board-ready insights and recommendations

📸 Screenshot:

Images/executive_review.png

---

🧠 Skills Demonstrated

✔ Financial Analysis & Insight Generation
✔ FP&A (Budgeting, Forecasting, Rolling Forecasts)
✔ Financial Modeling (Excel)
✔ Variance & Trend Analysis
✔ ROI & Unit Economics
✔ SQL (Data extraction, KPI tables)
✔ Python (Analysis & automation)
✔ Power BI & Tableau (Executive dashboards)
✔ Executive-level communication & storytelling

---

📄 Executive Deliverables

📘 Financial_Analyst_Portfolio_Executive_Deck.pptx
Board-style executive presentation used for leadership decision-making

📄 Financial_Analyst_Portfolio_Investment_Memo.pdf
Consulting-style investment & performance memo

These mirror real-world deliverables used in:

Finance teams • Strategy teams • Consulting firms • Corporate leadership environments

---

📁 Repository Structure

financial-analyst-portfolio/
│
├── 01_FPA_Executive_Dashboard/
├── 02_Amazon_Marketplace_Analytics/
├── 03_Profitability_and_COGS_Analysis/
├── 04_Executive_Financial_Performance/
│
├── Images/                 → Dashboard screenshots
├── dashboards/             → Power BI / Tableau files
│
├── Financial_Analyst_Portfolio_Executive_Deck.pptx
├── Financial_Analyst_Portfolio_Investment_Memo.pdf
├── README.md

---

📬 Contact

Jamie Christian
🔗 LinkedIn: https://www.linkedin.com/in/jamiechristian2/
💻 GitHub: https://github.com/JamieChristian22

---

This portfolio reflects my commitment to producing executive-quality, real-world financial analysis aligned with professional finance teams.