Post Job Free

Resume

Sign in

Financial Analyst Cost Accounting

Location:
Ontario, CA
Posted:
April 11, 2024

Contact this candidate

Resume:

Hector Gonzalez

Cell: 909-***-****

ad4x48@r.postjobfree.com

An energetic, dependable leader with solid finance/cost accounting experience in multiple industries. Able to adapt quickly to changing environments with the ability to communicate effectively with all levels of the organization. EDUCATION

Stanford Graduate School of Business, Stanford University, CA M.B.A., June 1990. Emphasis in Finance / Cost Accounting Harvey Mudd College, Claremont, CA

B.S. Engineering May 1986. Major: Electrical Engineering. Minor: Economics. EXPERIENCE

Amrep Wastequip / Inland Empire Health Plan / Other Ontario, CA Sr. Cost Accountant 12/2021 – 11/2023

• Daily sales and profitability analysis and reporting

• Excel modelling to develop financial projections.

• Raw material pricing sensitivity analyses to enable “quick-to-the-bottom line” forecasts

• Ad Hoc reporting / data mining / analysis to support strategic business decisions VACCO Industries South El Monte, CA

Program Financial Analyst 03/2016 – 07/2020

• Program controls and analysis for all aspects of contracts and associated subcontracts $10M - $165M

• Pricing analysis for new contracts or additional scope for active contracts utilizing complex Excel macro driven models.

• Weekly status reporting, processing using advanced Excel functions,

• Monthly Contract Profitability packages prepared for senior business leaders to be used in strategic business decisions

• Financial modelling to support senior executive corporate forecasts, what-if sensitivity analysis, and staffing requirements by function: Manufacturing, Quality Control, Engineering, Program Management, Other

• Final contract close-out performance

• Cost and Schedule variance analysis to identify potential overruns/underrun projections :

• Revising Pricing/Costing models to ensure models are up to date with current rates and corporate profitability projections Northrop-Grumman El Segundo, CA

Financial Analyst 4 11/2008 – 3/2015

• Controller for $4.5B budget.

• Importing and processing weekly and monthly actuals from SAP into planning software

• Cost and Schedule variance analysis for all items per contractual requirements

• Improved Estimate at Complete review and forecast processes to validate and ensure all changes have been approved by Sr. Management resulting in accurate forecasts for future planning

• Roll-up and consolidation of management reporting to guarantee consistency across organizations, including all formats, reporting hierarchies, explanations in line with reported variances and forecasts

• Reconciling contractual financial reporting data with SAP transactional accounting data

• Providing user access USER ID / Password control to prevent security breaches

• Improved process for submitting forecasts and invoiced amounts to US Gov’t DCMA compatible with required software. This required working with other analysts, providing detailed instructions and specialized training to ensure accuracy for future forecasts

• Created process for forecasting and preparing and submitting Contract Funding Status Reports to ensure timely customer payments

• Implemented working process to identify departmental responsibilities and due dates to streamline processing time

• Monthly Contract Profitability packages prepared for senior business leaders to be used in strategic business decisions

• Financial models to support senior executive corporate forecasts Southern California Edison Rosemead, CA

Sr. Business Analyst 3/2004 – 10/2007

• Roll-up and consolidation in Transmission and Distribution Business Unit to support external SEC, California Public Utilities Commission (CPUC), and all periodic Sr. Management reporting

• Monthly reporting by Area of Responsibility – including variance analysis, labor-manpower trending/forecasts including: Power Transmission & Distribution Training Group, Strategic Asset Management, Safety & Environmental Services, Business Process & Technology Integration, Oversight & Quality Assurance

• Roll-up and consolidation in Transmission and Distribution Business Unit to support external SEC, California Public Utilities Commission (CPUC), and all periodic Sr. Management reporting

• Budget / KPI development and maintenance to provide early warnings to potential overruns

• Forecasting – including detail documentation for all cost drivers and assumptions

• General Rate Case preparing data packages and analysis for CPUC witness testimony ViewSonic Corporation Walnut, CA

Sr. Financial Analyst 3/2001 – 8/2003

• Monthly P&L planning and forecasting, channel, region, product group

• S,G&A expenditure budgeting by cost center, and international region

• Complex modelling to link region, channel, product group, and cost center information to provide instantaneous answers to

“what if” scenarios and validate P&L forecasts

• Oracle Financial Analyzer system administrator

• Maintaining user password security, and individual specialized training,

• Importing-Exporting data (Actuals, ProForma Forecasts, Budget)

• Creating new rollup hierarchies

• Customized reports for Sr. Management

• Ad-hoc Pricing

• Income Statement / Balance Sheet Financial Projections Model linking regional (Americas, Asia, Europe) information to consolidated corporate summaries

• Created original Unit Repair cost financial model using advanced Excel functions to determine warranty liability resulting in

$3M Earnings for 2001, $10M for 2002

Boeing Satellite Systems (Acquired Hughes Space and Communications El Segundo, CA Sr. Financial Planning Specialist, 9/1996-2/2001

• Lead Analyst for Integrated Cost and Schedule planning and analysis on $70M+ contracts using Earned Value measurement with variance calculations and driver based predicted cost / estimate at complete forecasts,

• Manpower / Indirect cost process team – developing new enterprise planning, forecasting, and tracking tool

• Expenditure planning & variance analysis for Indirect Cost, Internal Research & Development Costs – allocating budgets, calendarizing, and tracking against plans,

• Consolidation of the monthly review package presented to Sr. Management – this includes establishing all standard templates/formats and checking the work of others to ensure consistency,

• Maintaining database for all potential risks, savings, and opportunities to serve as an early warning system to help identify mitigation plans,

• Consolidation of bids for new business proposals and analysis for all areas deviating from standard bid model,

• Process Management – Generating process “road-maps” documenting the weekly and monthly business cycle to clarify accountabilities, due dates, and information flows,

• Cost Management Team –Participated in cost management team during transition to Y2K financial system. This required in depth Net Present Value analysis on all projected cash flows, savings, cost avoidance, when compared to legacy cost system,

• Business Assessment Team – Telecommunications industry research and competitor analysis to identify potential threats and opportunities resulting from mergers and acquisitions. This required extensive research into satellite industry to investigate both horizontal and vertical alignments. Hughes Space and Communications El Segundo, CA

Payload System Engineer – Satellite Telecommunications, 1/1994-8/1996

• Developed Satellite performance budgets to ensure contractual requirement flow-down

• System level payload testing and analysis to verify technical specifications are met

• Prepared recommended operating procedure manual for in-orbit satellite controls, Hughes Space and Communications Group El Segundo, CA Financial Planning Specialist 6/1990-12/1993

• Monitoring program budgets and schedules against actual expenditures and commitments and performing variance analyses as required

• Forecasting, planning, and detailed variance reconciliation for $110M overhead budget

• Developed indirect cost models to support Sales & Earnings forecasts

• Manpower / staffing requirement budgeting, forecasting, and tracking against plans.

• Analyzing budget impacts of internal mergers / reorganizations and supporting recommendations to management Lockheed Aeronautical Systems Company Ontario, CA

Systems Engineer – Electronics 6/1986 – 8/1988

• Performed subcontractor labor distribution and cost/pricing fact-finding inquiries and analysis on $5 million contract in support of contract negotiations, and worked with subcontractors to develop contractual Statements of Work

• Created format for project hardware Interface Control Document and established stream-lined review process with senior engineers to ensure compliance with all contractual / military specifications,

• Presentations to support contract reviews and analysis for US Air Force committees

• Coordinated manpower utilization plans to forecast man-hour requirements, and task scheduling COMPUTER SKILLS

Word, PowerPoint, Excel (Pivot Tables, compound IF statements, SUMIF, COUNTIF, VLOOKUP, HLOOKUP, DSUM, DGET, SUMPRODUCT,GoalSeek). Systems experience includes: Oracle Financial Analyzer, Hyperion, SAP, Business Warehouse, Control, WinMPM, Essbase, winSight, EVMS.



Contact this candidate