Lockheed MartinFinancial Analyst
Sep. 2008 - Nov. 2015• Maintain all budgets, internal forecasting and reporting duties associated with over 50 contracts
• Ensure invoicing and revenue recognition on all contracts is accurate and GAAP compliant
• Develop Discoverer Plus reports to more efficiently pull month-end data, consolidating approximately 30 files, into one, easy to use file, significantly reducing the amount of time required to report month-end numbers
• Synchronize cost data between CostView, Hyperion, and SAP
• Manage S&ES Overhead ($1.5M), S&ES/SES Management Service Center ($2.7M), and S&ES Capital Budgets ($2M); develop proposals for Management Service Center rates and complete monthly variance analysis
• Automate Quarterly Financial Review reporting files using Essbase data retrieval, easing the reporting process and increasing data integrity
• Calculate EBIT and ROS; recommend booking rates for assigned contracts
• Complete Quarterly Finance Review package; forecast Orders, Sales, EBIT and Cash for the 5-year Long Range Plan
• Submit Monthly Operating Report and weekly short-term cash forecast • Migrate and validate the comprehensive cost data of nine projects from CostView to a new cost database Cobra
• Track and manage all overhead costs associated with a line of business to ensure an annual $4.5M budget is met
• Analyze monthly overhead transactions and prepare internal variance reports
• Prepare cash flow forecasts • Assist with the five-year plan associated with Sales, Orders, EBIT, Profit and Cash Flow and present quarterly financial plans to upper management
• Provide monthly and quarterly inputs associates with actual costs and expected contract growth to accurately forecast future financials
• Track weekly labor charges associated with a line of business
• Recommend cost savings ideas to upper management in an effort to lower overhead and administrative costs
• Manage $2M annual capital budgets, ensuring all programs have adequate funds to purchase required equipment