Financial Analyst · Energy & Forecasting

Kells
Koch

I build data-driven models that turn volatility into strategy — focused on energy markets, forecasting, and operational finance.

KK

Photo coming soon

Energy

Energy Model

Commodity price forecasting and variance analysis built for energy operations — translating market volatility into actionable financial insight.

Finance

Flight Finances

Financial planning and budget management web app built for flight clubs — tracking dues, expenses, and fleet costs where precision matters.

Pricing

PA-Pricer

Dynamic pricing engine with scenario analysis and sensitivity outputs — built to support data-driven pricing decisions under uncertainty.

Turning complex
data into decisions.

Aerospace engineer by training, financial storyteller by choice. I built my career to be the bridge between the technical side of business and the managerial side — translating complex systems into decisions that leadership can act on.

Currently Senior FP&A Analyst at Energy Transfer, supporting a $60B+ midstream enterprise. Previously spent five years at L3Harris Technologies in defense manufacturing finance.

Financial

  • Modeling
  • Forecasting
  • Budgeting
  • Variance

Technical

  • Excel
  • Power BI
  • SQL
  • Alteryx

Industry

  • Energy
  • Defense
  • Strategy
  • Operations

Professional Profile

Kells Koch

"Finance is the art of storytelling."

Senior FP&A Analyst at a $60B+ energy enterprise. Aerospace engineer by training, financial storyteller by choice. My bosses' go-to when there's a hard problem to solve.

Career Journey

2013
SLU Aerospace
2017
TCU MBA
2018
L3 Intern
2018
L3Harris Data Analyst
2021
L3Harris Sr. Associate + Archon
2022
L3Harris Specialist
2023
Energy Transfer
$60B+
Enterprise supported at Energy Transfer
$8M
Revenue recognition accelerated at L3Harris
75hrs
Monthly reporting saved via Tableau consolidation
40%
Profit margin improvement on FFP programs
Experience
Energy Transfer
Senior FP&A Analyst
Aug 2023 — Present
Dallas, Texas · Full-time · On-site

Senior Financial Analyst in the FP&A function supporting a $60B+ midstream energy enterprise. The reporting cycle structures the month: week one is close and variance analysis, week two is forecast updates and operations meetings, week three is management reporting, week four is margin and commercial reporting. Every week tells a different part of the story.

  • Build and maintain dynamic financial models for monthly forecasts, annual budgets, and 5-year strategic plans
  • Deliver variance analysis and executive commentary identifying performance drivers and actionable insights for senior leadership
  • Partner with business unit leaders to validate forecasts and align financial plans with field operations
The engineering instinct here was to decompose a complex signal into its components before forecasting — the same way you'd analyze a system. Strip out the noise. Model the physics. Then predict.
FP&AFinancial ModelingForecastingVariance AnalysisEnergy
Archon Drones
Co-Founder · CFO & Chief Pilot
Apr 2021 — Present
Dallas, Texas · Self-employed · Hybrid

Co-founded Archon with three partners during COVID-19 — a drone services company serving commercial real estate clients across DFW. CFO handling all financial planning, forecasting, and business modeling, and Chief Pilot overseeing all flight plans and UAV operations. Built everything from zero: business development, market research, process design, and financial infrastructure.

I learned more in the first year of Archon than I did in my MBA. The MBA gave me the pedigree to bridge engineering and finance — Archon taught me what it actually costs to run something.
EntrepreneurshipStrategic PlanningOperationsFinancial ForecastingUAV
L3Harris Technologies
Specialist, Program Finance
Jul 2022 — Aug 2023
Plano, Texas · Full-time

Elevated to Specialist handling higher-complexity defense programs across FFP and CPFF contract types. On FFP programs — where you bid a contract value and keep or absorb any variance — every margin improvement is real money.

  • Accelerated $8M in revenue recognition through strategic accruals on a $17M FFP program
  • Built a statistical forecasting tool achieving 10% improvement in forecast accuracy organization-wide
  • Generated scenario analysis and cash flow profiles for a $500M strategic pursuit
  • Identified an at-risk program and developed risk mitigation strategies that protected program profitability
Defense FinanceFFP ContractsScenario AnalysisCash FlowRisk Mitigation
L3Harris Technologies
Senior Associate, Program Financial Analyst
May 2021 — Jul 2022
Plano, Texas · Full-time

Managing a $100M+ program portfolio while leading a data infrastructure overhaul. The margin improvement work was methodical: review contract type, audit cost and manpower schedules against bid assumptions, then work directly with PMs and functional leads to find execution efficiencies.

  • Managed 6 active programs worth ~$100M across two program groups
  • Improved profit margins 9–40% on FFP programs by identifying execution efficiencies below bid
  • Established earned value framework and control account management for a 13-project franchise program ($100M+)
  • Led data infrastructure modernization: migrated to SQL/Snowflake, implemented Power BI and Alteryx
The 9–40% improvement came from asking questions that weren't being asked. Most people accept the bid as fixed. The real question is: can we execute this more efficiently than we planned?
Portfolio ManagementEarned ValueSQL · SnowflakePower BIAlteryx
L3Harris Technologies
Data Analyst · Interim Segment Lead
Aug 2018 — May 2021
Plano, Texas · Full-time

Joined during the L3-Harris merger. Almost the entirety of my original team was laid off or departed. Pivoted, landed in a compensation data role, and gained rare exposure working in a leadership office — watching how executives navigate a 50,000-person merger from the inside.

  • Reduced reporting from 32 manual reports to 1 Tableau dashboard — saving 75+ hours/month ($36K annually)
  • Led storyboarding and data definition for a New Business Pipeline Dashboard tracking 5-year contract lifetime value
  • Served as Interim Segment Lead: facilitated vendor transitions and supported 10+ executive relocations
  • Resolved $2M in aged subcontractor invoices through cross-functional partnership
Most analysts at this career stage don't get leadership office exposure. Watching how executives navigate a major merger shaped how I think about organizational finance at scale.
Business IntelligenceTableauM&A IntegrationData Visualization
TCU Neeley School of Business
Neeley & Associates Principal Consultant
May 2018 — May 2019
Dallas-Fort Worth · MBA Program

Selected as Principal Consultant — leading MBA teams on real client engagements including a semester-long project with Lockheed Martin, and serving as team lead and coach for first-year MBA consultants. The consulting work was where the bridge between engineering and finance was actually built and tested.

ConsultingTeam LeadershipClient ManagementLockheed Martin
Engineering Foundation
Project Vedrfolnir — UAV Senior Capstone
Aug 2016 — May 2017 · Saint Louis University · Aerospace Engineering

Designed and built a deployable UAV for surveillance and search-and-rescue. A rocket launched to 30,000 feet deploys a canister containing the quadcopter UAV, which descends and begins autonomous operations. Ran from theoretical design through fabrication, testing, and critical design review before industry professionals.

This is where the problem-solving methodology was formed. Systems thinking, hard constraints, designing under uncertainty. I still use this approach every time I build a financial model: identify the system, decompose the variables, solve for the unknowns.