Financial Reporting Data Analysis

Scott Langenberg

#* ********* ***** ******* *******, Kansas 67220 Primary: 316-***-****

**********.*****@*****.*** Cell: 316-***-****

Solutions Oriented * Analytical * Thorough * Organized * Strong Work Ethic

Career Profile

Hard working, detail-oriented, multi-tasking Analyst with 10+ years of experience in financial and data analysis, budgeting and forecasting, research and financial modeling, presentations and reporting, and business management. Demonstrated track record of leading and collaborating with cross-functional teams on projects to improve productivity, processes, and procedures. Excellent communicator, team builder, and problem solver that gets the job done in high pressure or time-sensitive environments.

~ Areas of Expertise ~

General Ledger Accounting Accounts Payable / Receivable Account Reconciliation

Budget / AOP Preparation Cost Accounting / Analysis Revenue Recognition

Data Mining & Management Research / Variance Analysis Ad Hoc Analysis

Audit Preparation/Relations Financial Statements / GAAP Project Management

Skilled in MS Office (Outlook, Word, Excel, PowerPoint, Project), SharePoint, & Teams

Additional experiences with SAP, Oracle, Epicor, QuickBooks, Hyperion, & Essbase.

Relevant Job Experience

Cobham/Viavi Solutions Wichita, Kansas

Cost Accountant II February 2017 to March 2025

Responsible for cost / valuation / disposal of inventory, monthly closing tasks, financial reporting for plant mgmt, providing cost & billing info for Fixed Bid projects, assisting with audit requests from internal / external auditors, and produced monthly reports / presentations (COS+OPEX) for Corp. Finance. I was also part of the team doing quarterly Excess & Obsolete (E&O) reviews.

Textron Airland/Cessna Wichita, Kansas

Program Planning & Control Lead February 2012 to September 2016

Recruited by the Chief Engineer to join a secret ‘Start Up’ project (aka Scorpion). Contracted to assist in program management and engage in project processes / procedures with various groups (BD/Engr/Exp/Finance/HR) to define / schedule / achieve program goals. Additional tasks included business development / planning, schedules for drawings / parts, labor tracking, invoice processing and account analysis, project forecasts and proposals, producing various weekly / monthly financial reports, management presentations, program risk management, building coordinator, and helping with “On-Boarding” of new employees (paperwork, badges, workstation setup, system access).

Scott Langenberg Page Two

The Boeing Company Oklahoma City, Oklahoma

Business Planning Analyst June 2011 to February 2012

Coordinated with engineering / schedulers to develop baselines for new work packages, did weekly reviews, quarterly EACs, and monthly earned value performance metrics on government contracts.

Boeing Silver Medallion certified in Earned Value Management System

Airbus Americas Engineering Wichita, Kansas

Senior Program Analyst September 2009 to July 2010

Contracted to lead collaborative team in the development and implementation of an on-site Earned Value Management System (EVMS) for all North America company-wide projects.

Hawker Beechcraft Corporation Wichita, Kansas

Financial Analyst February 2003 to September 2009

Applied my accounting / finance knowledge towards analyzing / preparing financial data, monthly detail reports, dept. expenses (OPEX), product line estimates, work order setup and tracking, account analysis / reconciliations, journal entries, inter-company transfers, and manual invoices.

Managed / updated a Microsoft Access database to track budgets, actuals, and forecasts for the entire engineering department (400+ heads).

Provided project leadership and active participation in Six Sigma projects…some examples include company accounting changes, SAP upgrades, and company transition from Raytheon Aircraft to Hawker Beechcraft Corporation.

Bombardier Aerospace Wichita, Kansas

Design Change Proposal (DCP) Focal July 2000 to February 2003

Processed / tracked DCPs, coordinated changes between engineering and program management, prepared status reports, did presentations, and managed a Microsoft Access database for DCPs.

Raytheon Aircraft Corporation Wichita, Kansas

Program Analyst March 1997 to July 2000

Responsible for make / buy reviews and schedule / cost variance analysis on Hawker 4000 program. Prepared weekly / monthly reports on man hours and expenses (Budget vs. Actuals). Did program Estimates at Completion (EAC), helped develop an EAC database, and was part of several teams responsible for company-wide SAP implementation. Assisted in the development / implementation of Earned Value Management System (EVMS) software for the Hawker 4000 program.

College Education

John Brown University Siloam Springs, Arkansas

Bachelor of Science in Accounting; Minor in Computer Science GPA: 3.50/4.0

Volunteer Work

Treasurer, Crestview Lakes HOA, Wichita, Kansas, 2010 to Present.

Treasurer, Boy Scouts of America, Wichita, Kansas, 2007 to 2010.

Contact this candidate