Summary
Overview
Work History
Education
Skills
Timeline
Generic

Spencer Williams

San Diego,California

Summary

Driven Business Management professional with 6 years of comprehensive financial planning and data analysis experience. Dedicated to understanding business needs and optimizing cost & scheduling to help drive a successful & profitable company. Adaptable analytical thinker with a strong work ethic and ability to thrive in a team-based or individually motivated setting.

Overview

7
7
years of professional experience

Work History

Principal Financial Analyst

Northrop Grumman
06.2023 - Current
  • Lead financial planner for the $2+ billion F35 CNI operating unit
  • Develop yearly 5-year annual operating plan and present to leadership
  • Present monthly financial forecast metrics with the business unit directors to review progress of our annual operating plan & monthly IF (awards, labor, ODC, cash flow, etc)
  • Prepare & send out weekly headcount, rate analysis, cash receipts, labor, and material costs
  • Conduct monthly detailed financial variance analysis on budget/forecast, performance/actuals, and forecast/annual operating plan

Principal Program Cost & Schedule Control Analyst

Northrop Grumman
06.2021 - 06.2023
  • Planned and budgeted logistics, manufacturing, material, supplier management, engineering, and program management office costs for the F35 $300+ million contract in Cognos TM1
  • Partnered with the program manager to accurately keep a valid risk and opportunities register to mitigate issues that arise.
  • Compiled data from 300+ networks/work packages to prepare annual/monthly financial models for internal/external reports and presentations.
  • Led weekly reviews with leadership to discuss drivers in cost & schedule variances and recommend corrective actions to avoid overruns and maintain positive cash positions.
  • Rolled up and analyzed the full program's finances to calculate earned value metrics and maintain key performance indicators.

Supply Chain Planning Analyst II

Northrop Grumman
11.2017 - 06.2021
  • Global supply chain financial planning lead and control account manager for the $300+ million JCREW contract.
  • Partnered with cross-functional leadership to perform detailed comprehensive estimates at complete and analytical models to drive accurate program progress.
  • Drove configuration management and bill of material reviews to accurately understand design cut-ins, customer furnished material, and pricing optimization with suppliers.
  • Performed weekly actual costs reporting, material/labor forecasts, quantifiable backup data, and earned value metrics to effectively maintain and drive the program in IBM planning analytics, Cognos.
  • Established understanding of full product lifecycle experience with the low rate and full rate JCREW production contracts.
  • Lead short-term and long-term initiatives to optimize material cost, schedule, and reporting through Microsoft excel models and tableau, which resulted in more than $500,000 in savings.

Data Analyst Intern

Empyr
07.2017 - 11.2017
  • Analyzed 200,000+ daily transactions through querying in SQL, R, and Microsoft Excel to provide reports and dashboards to key stakeholders.

Education

Bachelor of Science - Applied Mathematics

University of California, Davis
Davis, CA
03.2017

Skills

  • Strategic financial and operational planning in IBM planning analytics Cognos TM1 & Deltek Cobra
  • KPI & earned value management
  • Comprehensive financial modeling
  • Proficient in SQL, SAP, Excel & MS office, ERP & CRM, Salesforce
  • Effective communicator & presenter to leadership
  • Risk & opportunity management

Timeline

Principal Financial Analyst

Northrop Grumman
06.2023 - Current

Principal Program Cost & Schedule Control Analyst

Northrop Grumman
06.2021 - 06.2023

Supply Chain Planning Analyst II

Northrop Grumman
11.2017 - 06.2021

Data Analyst Intern

Empyr
07.2017 - 11.2017

Bachelor of Science - Applied Mathematics

University of California, Davis

Similar Profiles

CREATE PROFILE
Spencer Williams