Carolyn Sims

Senior Cost, Schedule and Controls Analyst/Control Account Manager at Raytheon
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Colorado Springs, Colorado, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Senior Cost, Schedule and Controls Analyst/Control Account Manager
      • Dec 2019 - Present

      • Monitor labor, materials, subcontracts and ODC costs and implement Waterfall and Agile methodology on projects and delivery orders with a combined value of $300M.• Create and maintain WBS, OBS, RAM, baselines, and EACs.• Implement proper EVM controls and FAR requirements throughout the duration of each program. • Lead initial and incremental baseline planning meetings and monthly ETC and EV metric meetings with PMs and CAMs.• Identify workflow issues between departments and… • Monitor labor, materials, subcontracts and ODC costs and implement Waterfall and Agile methodology on projects and delivery orders with a combined value of $300M.• Create and maintain WBS, OBS, RAM, baselines, and EACs.• Implement proper EVM controls and FAR requirements throughout the duration of each program. • Lead initial and incremental baseline planning meetings and monthly ETC and EV metric meetings with PMs and CAMs.• Identify workflow issues between departments and create solutions to increase efficiency and improve processes.• Participate in and present financial data to executives and management during program start-up, monthly ETC reviews, and BCR reviews.• Provide timely and accurate deliverables to the customer as well as internal reporting to PMs and CAMs.• Review SoW and contracts to make sure all financial terms and conditions are captured correctly based on discussions with customers.• Data mine large data sets to provide meaningful data and analysis to stakeholders using complex Excel functions, pivot tables and charts.• Conduct analysis of earned value metrics to identify and explain variances, trends and warning signs of deviations from cost and schedule plan.• Train CAMs and other analysts on proper project set-up, baselining, forecasting and EVM metrics. Show more Show less

    • Senior Specialist, Program Finance
      • Nov 2018 - Dec 2019

      • Establish and track baseline and EAC for newly awarded contracts.• Create and provide monthly reports to internal and external customers.• Work with Subcontracts Procurement department to establish subcontractor labor, material and travel estimates. Review and approve POs and PRs.• Reconcile deferred costs for billing. Review and reconcile monthly bi-weekly invoices.• Utilize PeopleSoft to create queries for the purpose of ad-hoc reports and validating COS and profit, as… • Establish and track baseline and EAC for newly awarded contracts.• Create and provide monthly reports to internal and external customers.• Work with Subcontracts Procurement department to establish subcontractor labor, material and travel estimates. Review and approve POs and PRs.• Reconcile deferred costs for billing. Review and reconcile monthly bi-weekly invoices.• Utilize PeopleSoft to create queries for the purpose of ad-hoc reports and validating COS and profit, as well as creating, opening, and closing charge numbers.• Update and analyze monthly revenue plan, orders, profit, and sales.• Lead program ETC meetings, and support project management team in meeting project financial goals.• Add value to internal customer deliverables by consolidating reports and making processes more efficient.• Create monthly deliverable for program managers with monthly ETC/ACWP/BCWS metric comparisons, and EVM charts and metrics.• Train rotational employees. Show more Show less

    • Project Financial Analyst II
      • Mar 2017 - Nov 2018

      • Track and analyze financials for over 30 programs totaling over $500M in contract value.• Establish budget based on historical data, vendor quotes and customer statement of work (SoW).• Generate project cash flow analysis, headcount summary, fee and ROS analysis, and potential risk summary for management and executive review. • Analyze program contracts to verify accurate period of performance dates, total contract cost, total funded cost, and contract type for each CLIN and… • Track and analyze financials for over 30 programs totaling over $500M in contract value.• Establish budget based on historical data, vendor quotes and customer statement of work (SoW).• Generate project cash flow analysis, headcount summary, fee and ROS analysis, and potential risk summary for management and executive review. • Analyze program contracts to verify accurate period of performance dates, total contract cost, total funded cost, and contract type for each CLIN and over-all program.• Implement burn rate and trend analysis, and utilize purchase order (PO), purchase request (PR), non-labor G/L, and outstanding commitments (OC), and accrual reports to adjust month-to-month estimate to complete (ETC).• Produce financial models and ad hoc analysis to provide management and executive teams with necessary data to understand the financial health of programs, including all aspects of analysis related to EVMS such as cost variance, schedule variance, variance at complete and other associated metrics (CV, SV, CPI, SPI, VAC, EAC, TCPI).• Review and adjust monthly orders forecast inputs to ensure potential revenue is correctly accounted for, and specific dates and dollars tie out so as not to double count revenue.• Retrieve and use reports from SQL, SAP, and Deltek Cobra applications for the purpose of creating pivot tables, charts and advanced functions for financial models and “what-if” scenarios in Excel.• Provide training to interns, rotational employees and new employees. Show more Show less

    • Project Financial Analyst
      • Jun 2015 - Mar 2017

      • Design and implement Excel workbook capable of tracking headcount, labor, and all direct expenses including travel, subcontractors and materials for 60 government and commercial projects.• Create an Excel spreadsheet to track backlog, opportunity, G&A and OH for three main offices.• Review contracts and modifications related to tasks to carefully monitor any changes in contracts relating to budget and reporting; request increase in funding and period of performance (PoP) extensions… • Design and implement Excel workbook capable of tracking headcount, labor, and all direct expenses including travel, subcontractors and materials for 60 government and commercial projects.• Create an Excel spreadsheet to track backlog, opportunity, G&A and OH for three main offices.• Review contracts and modifications related to tasks to carefully monitor any changes in contracts relating to budget and reporting; request increase in funding and period of performance (PoP) extensions from customer.• Generate expense authorizations, expense reports, purchase orders, and purchase requests as necessary.• Create and track POs and PRs; develop electronic tracking system to match POs and PRs to invoices when received.• Design and implement Excel workbook capable of tracking headcount, labor, and all direct expenses including travel, subcontractors and materials for 60 government and commercial projects.• Create an Excel spreadsheet to track backlog, opportunity, G&A and OH for three main offices.• Review contracts and modifications related to tasks to carefully monitor any changes in contracts relating to budget and reporting; request increase in funding and period of performance (PoP) extensions from customer.• Generate expense authorizations, expense reports, purchase orders, and purchase requests as necessary.• Create and track POs and PRs; develop electronic tracking system to match POs and PRs to invoices when received. Show more Show less

    • Regional Coordinator
      • Apr 2013 - Jun 2015

      • Create and track monthly, quarterly, and annual budget for regional office.• Produce and provide marketing materials to recruiters.• Build client relationships and provide excellent, quality customer service.• Manage office and handle materials purchasing, accounts payable and accounts receivable.• Lead annual audit.

Education

  • Colorado State University-Global Campus
    -
  • University of Colorado at Boulder
    -
  • Colorado State University
    -

Community

You need to have a working account to view this content. Click here to join now