John Mcclean Email & Phone Number

Gilbert, Az, Us

Mesa, Arizona, United States

• Responsible for site budgeting and forecasting, including current year plan and three-year Strategic Plan• Responsible for monthly financial close activities and reporting of results to parent company• Designed and implemented an updated business unit cost allocation file, which automates distribution of cost and revenue between multiple business units and saves multiple hours during the monthly close process• Assumed responsibility for completion of monthly management reports and utilization reports from Accounting, more appropriately aligning budget-to-actual cost reconciliation activities to Finance• Provide data and financial support to our annual internal audits completed by Ernst & Young• Provide supervision and mentorship for the Sr. Cost Analyst position

Mesa, Arizona, United States

• Worked with Program Management on a continuous basis to ensure accuracy of project cost and EAC (estimate at completion) data• Designed and implemented automated reports utilizing Costpoint Enterprise Reporting, including replacements/upgrades for existing sales, backlog, and bookings reports and numerous ad hoc financial reports• Designed and implemented a new Profit and Loss/Capital Employed report, significantly reducing time required to complete the monthly close and eliminating the need to create a manual flash report to compute interim results• Updated and maintained existing Excel-based financial models including the annual sales forecast and the weekly revenue monitoring workbook• Assisted the Site Controller with weekly and monthly Accounting close activities

Chandler, Az

• Facilitate all financial budget control activities for a multi-year U.S. Air Force (USAF) prime contract, providing a liaison between the project management team and the corporate accounting team.• Provide ongoing financial analysis to control project scope-related issues, including preparation and reporting of monthly variance analysis, and defining and communicating any required corrective action plans• Work with the budget managers for each functional department to establish and monitor department budgets, including development of Work Authorization Documents for release• Created an Excel-based Integrated Master Schedule (IMS) budget tracking model, enabling program management to have a single source through which to view program progress vs. schedule and budget• Designed and implemented monthly program management, financial controls, and contract funds status reports for USAF client presentations• As a member of the accounting department, assist where possible with financial process improvement reports and initiatives, examples include:• Created and implemented a Microsoft (MS) Excel Visual Basic (VB) macro-driven direct labor utilization report, providing senior management with customizable insights into corporate-wide direct labor utilization• Created and implemented an MS Excel and Word VB macro-driven Electronic Funds Transfer (EFT) notification mail merge process, eliminating the Accounting Department’s need to manually create email notifications for each processed EFT transaction

Greater San Diego Area

• Provided management, oversight, guidance, and training for all Forward Slope (FSI) financial services consulting engagements at the U.S. Navy’s Space and Naval Warfare Systems Command (SPAWAR)• Responsible for direct financial and programmatic support to the SPAWAR PMW 770 Business Financial Manager (BFM) including forecasting, cost performance analysis, process improvement plans, and new-employee training on multiple database, software, and spreadsheet-based reporting structures. • Initiated design, setup, testing, and implementation of a new PMW 770 Spend Plan database, providing the ability to perform significantly improved analysis of its spend plan and financial execution data and to create custom queries to drill down into its financial information• Reviewed and completely revamped PMW 770’s Microsoft Excel financial performance vs. benchmark graphs, financial Execution Sheet workbooks, and internal/external source of funds reporting. These updates created easily-understood error checks and resulted in considerable improvements to the speed with which the worksheets could be updated and the accuracy of the underlying computations.• Utilized multiple years of budget data to create a New Initiatives brief capturing significant additions to PMW770’s current and future financial operating authority. This information provided a clear illustration of the significant volume of new money being managed by PMW 770’s Program Management and Financial Management teams, and was included in presentations by PMW 770’s Lead BFM to the SPAWAR Commanding Officer.

Greater San Diego Area

• Provided direction, oversight and supervision to the following FSI Operations departments: Human Resources, Contracts, Facility Security, Project Control• Ensured Operations functions were aligned and optimized with Program Management and Corporate Finance• Continuously reviewed and evaluated existing Operations procedures to identify areas for improvement and increased efficiencies• Created and maintained detailed pro-forma financial planning and analysis models utilized as short- and long-term forecasting and planning tools• Provided ongoing design, programming, testing, and implementation support for financial software automation projects

Greater San Diego Area

• Primarily responsible for overall management of corporate Operations tasks, serving as the direct supervisor of the managers of the following departments: Accounting/Finance, Human Resources, Contracts, Facility Security, Project Control• Worked closely with Executive Team and other members of Senior Management to assist in setting AUSGAR’s corporate direction and ensure that the tasking completed by Operations was in alignment with that direction• Performed continuous review of Operations processes and structures, implementing efficiency-oriented changes where appropriate• Created and maintained extensive forecasting and budget-to-actual data models for corporate financial management, revenue/profitability analysis, proposal scenario analysis, and indirect rate projections• Performed the day-to-day management of operating working capital for the corporation• Completed overarching analysis of Operations department structure, resulting in organizational changes including the separation of Contracts from Accounting, and the institution of a Project Control function

Greater San Diego Area

• Responsible for corporate accounting processes, including accounts payable, accounts receivable, operating working capital management, and associated collections and discrepancy resolution• Ensured compliance with all Defense Contract Audit Agency (DCAA) regulations in regards to corporate cost accounting, also serving as the lead for all DCAA reporting• Provided level of effort estimates for continuing projects and reviewed/approved contract modifications• Supervised project control function, ensuring proactive monitoring of direct project expense vs. allocated funds• Created forecasting and budgeting models for macro- and micro-level financial management, including the monthly calculation and monitoring of the corporate indirect rate model• Provided ongoing design, programming, testing, and implementation support for financial software automation projects completed previously in a Senior Consultant role• Implemented new accounts receivable procedures which resulted in the reduction of average days outstanding from 63 days to 28 days during a period in which average quarterly revenue increased 255%• Centralized the formerly fragmented cost and contractual volume production for all FSI proposals

• Sr. Consultant and Financial Analyst for multiple U.S. Military defense contractors• Risk Management Analyst and Project Cost Analyst for multiple firms in the financial services industry• Expert user of Microsoft Excel, including design and implementation of Excel Visual Basic macros• Experience with SQL and other relational database programming