CHRISTINA PAYNE
Financial Analyst
Chicago, IL · c.payne@email.com · (555) 214-7783
Summary
Financial analyst with 5+ years supporting FP&A and strategic planning for consumer goods companies. Built forecasting models that improved budget accuracy by 18% and identified $2.3M in cost-saving opportunities.
Experience
Financial Analyst · Procter & Gamble
2021 - Present
- Built a rolling 18-month revenue forecast model in Excel/VBA that reduced forecast variance from 12% to 4%
- Partnered with brand managers to analyze a $180M product portfolio, identifying $2.3M in cost-saving opportunities
- Automated monthly variance reporting using Power BI, cutting close-cycle reporting time by 6 hours per month
- Leads scenario analysis on commodity pricing, quantifying a $4.5M margin impact across 9 SKUs
- Presents monthly KPI packs to a 12-person leadership team covering revenue, margin and spend
Financial Analyst I · General Electric
2018 - 2021
- Supported the quarterly budgeting process for a $450M business unit, consolidating inputs from 8 department heads
- Built variance-analysis dashboards in Tableau that flagged $1.1M in overspend across three quarters
- Assisted in due diligence for a $40M acquisition, modeling pro forma financials
- Wrote SQL queries against the data warehouse to replace 5 manual extracts in the reporting pack
- Prepared 30+ ad hoc analyses for the CFO office, including a pricing study of 22 contracts
Finance Intern · Eli Lilly and Company
2017 - 2018
- Reconciled 400+ monthly vendor accounts in SAP, resolving 60 aged items ahead of quarter close
- Compiled weekly spend summaries in Excel for a $12M marketing budget reviewed by two directors
- Documented a 15-step month-end checklist adopted by the shared-services team of six analysts
Education
B.S. Finance — Indiana University · 2018
Skills
Financial Modeling, Excel/VBA, SQL, Power BI, Tableau, Forecasting, Variance Analysis, Budgeting, GAAP, SAP, Scenario Analysis, KPI Reporting
Certifications
Passed Level II of the CFA Program, CFA Institute
Financial Modeling & Valuation Analyst (FMVA), Corporate Finance Institute
Microsoft Certified: Power BI Data Analyst Associate, Microsoft
Key Achievements
Named FP&A Analyst of the Year, Procter & Gamble North America finance, 2023
Cut budget cycle time from 6 weeks to 4 through a redesigned template set
Selected for the GE Financial Management Program from a pool of 900 applicants
Languages
English (Native), Spanish (Professional working proficiency)
Interests
Long-distance running, Chess, Personal finance education, Jazz piano
