Alion Science and TechnologyManager Financial Planning & Analysis
Feb. 2011 - May. 2015Direct the monthly reporting for an $800 million defense technology contractor, including analysis and research for variances to budget and forecast. Maintained five year strategic financial plan (IS,BS,CF), including sensitivity analysis and presentation to executive management and outside investors. Manage annual budget process, including training, daily status meetings, communication with business units, plan guidance, and consolidation of plan reporting. Perform ad hoc analysis for senior leadership, ranging from rate change impact, stock price growth, revenue pipeline stability, and working capital analysis. Perform quarterly debt covenant calculation for SEC filing, review MD&A for 10-K/Q. Utilize SAP BPC tool for reporting and development of new budgeting/forecasting tool. Key Accomplishments:
• Developed array of sensitivity models for valuation, goodwill impairment, and revenue growth.
• Designed and built centralized reporting site for FP&A team and budget site for all business units.
• Managed short term and long term cash flow analysis, including sensitivity around performance.
• Created compliance model for bond indenture restricted payments, including forecasting capabilities.
• Ensured process compliance to internal audit and SOX standards, passing all standards.
• Member Joint Application Development team for updated forecast system (design, requirements, test).
• Provided budgeting and guidance on government rates, including sensitivity analysis for rate structure changes.