Stephen Lillenberg Email & Phone Number

Denver, CO, US

Lakewood, Colorado, US

Denver, Colorado, US

Dallas, TX, US

• Run month-end financial results packages that measure Omni financial performance and are distributed out to Omni Leadership
• Created an automated retail scorecard that tells management how individual hotels’ retail departments are performing in revenue, cost, and profit compared to budget and last year performance
• Developed an automated excel pivot query that pulls Omni weekly and monthly revenue performance compared to the market and organizes the data in excel tables and line charts
• Perform ad-hoc financial analysis and modeling on property-level and company-level performance

Arlington, VA, US

• Lead Financial Analyst of $75M + Portfolio upgrading the Modular Mission Computer (MMC) for F-16-V Fighter Jets
• Analyze weekly EVMS program cost performance for various MMC Development programs ($70M + Portfolio) to reduce program variances and report External IPMR reports to USAF
• Lead analyst on Major and Minor F-16 Development program EAC’s (Estimate at Completion) which analyzes program execution and forecasts future financial and technical performance.
• Develop the monthly sales, bookings, profit and cash forecasts for F-16 Development Programs and identify financial metric risks and opportunities

Arlington, VA, US

• Estimate all costs for proposals at Raytheon Precision Manufacturing (RPM) through developing the proposal bill of materials (BOM) and working with planning managers and engineering to forecast labor hours.
• Develop the Basis of Estimate (BOE) for Truth in Negotiations Act (TINA) proposals to ensure proper policies and procedures were used for pricing compliance
• Present quotes to RPM Leadership team for all proposals over $750K

Arlington, VA, US

• Monitor the Mission Operations Solutions (MOS) Controllable Costs and develop variance analysis on budget performance that is distributed out to functional leaders
• Allocate MOS monthly facilities costs and send updated distribution to accounting for billing
• Analyze all expenses charged to MOS and perform proper cost transfers and other adhoc requests

Arlington, VA, US

• Track program cost performance for F/A-18 APG-65/73 Radar Repairs ($100M Sales Portfolio) and collaborate with the Integrated Product Team and Program Manager to identify potential program risks and opportunities
• Prepare F/A 18 Radar Repair quarterly Estimate-at-Complete (EAC’s) and update Program Manager on cash collection forecast and yearly net cash position.
• Created trend analysis of past F/A 18 Rader Repair EAC program performance and presented findings to Finance Managers and Program Manager

Arlington, VA, US

• Tracked the Platform Sustainment and Modernization (PSM) $20 - $45 million monthly accounts receivables to identify risks to the PSM cash collections forecast and presented findings to the PSM Business Finance Lead
• Identified potential at risk programs to the PSM Quarterly Forecast and worked with program business analysts and GBS to expedite billings
• Created historical analysis of PSM cash collections and outstanding billings

Gillingham, United Kingdom, GB

• Conducted a FCPA audit for a manufacturing plant in Paraisopolis, Brazil, analyzing all expense accounts that dealt with government interaction and testing the plants petty cash expenses.
• Tracked 75 Audit Reports in 2013 to ensure all reports were uploaded to Delphi’s accounting database and presented the data analytics findings and trends through Excel
• Gave a Competitive Analysis Presentation to Delphi’s Finance Executives

Dublin, IE

-Created a detailed competitor analysis of major countries strategy's in attracting Chinese international students to their higher education system.-Formulated a descriptive strategy to increase the number of Chinese students in Ireland. -Cleaned excel documents and organized the data into an easy-to-read spreadsheet

Des Peres, Missouri, US