Financial Analyst Senior

Bryan Mason

Professional Summary

Financial Analyst with over 10 years of Fortune 500 business unit, manufacturing, and pharmaceutical experience, actively managing and monitoring cost, creating accurate reports, and forecast to assist management in making decisions. Strong background in developing cost from ground up, creating financial models, analyzing cost and revenue drivers, EVMS, problem solving, attention to detail, using advanced excel, SAP tools and finance knowledge to create value for stakeholders.

EXPERIENCE

12/2022-Present Ipsen Biopharmaceutical Cambridge, MA

Senior Financial Analyst/Controller/Manager (Consultant)

FP&A General Administrative Functions

Create and manage Open/Close PO process for FP&A, which allowed for $1M to be transferred to company budget.

Create and Process Accruals to correctly account for vendor unpaid invoices.

Create and maintain actual expense reports utilizing MicroStrategy monthly to properly account for business transactions.

Created macro to create expense reports that increased report creation time efficiency and accuracy from 2.5 hrs. to 3 min.

Successfully worked as financial business partner to Business functions and FP&A directors to support all adhoc financial reports and request.

Create Allocation Tables to correctly spread product cost to IT/HR/Facilities business units.

Create and Manage reconciliation process of P&L and confirmation to ensure accuracy of Financials.

Created macro to reconcile P&L for US70 and US75 companies that improved reconciliation time efficiency from 4.5 hours to 10 min.

6/2022-11/2022 Amgen Biotech Thousand Oaks, CA

Senior Financial Analyst (Consultant)

IS Project Financial Support EEA and GIS (Remote)

Created/processed reclasses for EEA and GIS that resulted in cost hitting the correct accounts and budgets being maintained.

Created/processed Accruals to correctly account for vendor cost.

Created and Manage PRAs/Excel Supplemental Worksheets to get required funding for business unit.

Successfully worked as financial business partner with Program and Project Managers to support all financials.

Create/Update and Manage forecast report and POs to track and forecast future Spend that resulted in increased visibility of project profitability.

2/2021-5/2022 National Grid Waltham, MA

6/2016-1/2017 Senior Financial Analyst (Consultant)

IT Financial Planning & Analysis

Created and designed forecast workbook utilizing formulas, pivot tables, and projected average OPEX run rates to determine future cost, resulting in increased visibility into cost drivers and areas of improvement.

Created and designed improved Block Code process utilizing continuous process improvement model (PDCA), resulting in an 80% time and process efficiency increase.

Tracked budget vs forecast, analyzed Operational Expenses (OpEX) and Captial Expenses (CapEX), analyzed variances, providing drivers and corrective actions to leadership, driving management to maintain workforce levels and reduce capital expenditures to stay under budget.

Wrote and processed journal entries for accruals and reclassification of expenses, resulting in accurate financial statements.

7/2019- 1/2021 Collins Aerospace Westford, MA

Business Manager/Senior Financial Analyst (Consultant)

Domestic/International Air Products Finance

Create, manage, lead EAC Process for CHASM/Saudi Programs communicating business profitability to leadership

Analyze program risk and opportunities while managing Management Reserves to maintain gross margin and profit.

Work with PM and Scheduler to maintain and improve SPI and CPI metrics to ensure program is under cost and on schedule.

Created and Maintained Monthly CDRLs to update customer about financial position of the program’s cost and schedule.

Invoice accumulated actuals on a monthly and bi-monthly basis to improve cash flow, track, and present results to leadership.

Created weekly and ad hoc reports to track results and drive improved program performance.

2/2019- 6/2019 American Tower Corporation Boston, MA

IT Project Manager/Financial Manager (Consultant)

IT Project Management Office

Managed company’s Entire IT allocation process re-classing labor resources to expense and capital projects, which helped IT Executive Leadership team measure project performance and schedule.

Created and maintained portfolio dashboard that quantitatively and visually showed IT project performance, that assisted IT’s VP, Directors, and program managers easily identify the performance of each project.

Created Analysis file to track CAPEX and OPEX spend and performed reconciliation of expenses, identifying projects that were not re-classed properly from Accounting.

12/2017-1/2019 Schneider-Electric Boston, MA

Senior Financial Analyst (Consultant)

IT Finance Operations

Create and Reconcile accrual expenses to be accrued for unpaid expenses, analyzed variances vs plan, providing drivers, creating journal entries, accruals, re-classed expenses, and cross charges to support business profitability; accuracy

Manage and create prepaid expenses for the entire IT/Schneider-Digital Business and communicate with business partners in US and Internationally to help the company normalize expense periods

Created Consolidated T&E report and reporting schedule that helps to drive reduce Travel expenses for Schneider-Digital Business.

Created, Designed, programmed macro that automated Consolidated P&L increasing time and labor efficiency.

Manage and create journal entries to create cost transfers for the allocation of labor resources to move cost from people cost centers to project and program cost centers.

Created and automated FP&A report for Senior Finance Manager to analyze projected cost and profits for the IT Business, which help create increase report production efficiency of 90%.

2/2017-11/2017 Johnson & Johnson Raynham, MA

Senior Financial Analyst (Consultant)

Depuy Synthes Division

Tracked Budget vs forecast of over 40 businesses, analyzed operation and capital expenses

Created Budget with business partners utilizing run rates and operation expenses, which help business partners make better decisions managing their budget(s).

Created and designed improved Budget vs Operational expense analytical process utilizing continuous process improvement model (PDCA), excel pivots, and VBA programming, that resulted in reduced production time, 97% process efficiency increase; projected cost savings of $750K over 10 year useful life

6/2015-5/2016 Shire Pharmaceutical Lexington, MA

Senior Operations/Financial Analyst (Consultant)

Material Management Operations

Designed, created, and maintained Material Exception analysis package in excel that calculated and graphed material exceptions, supplier efficiency, buyer efficiency, and cost of the material weekly, reducing monthly exceptions by 41%

Designed, created Pareto Charts, and performed analysis on exceptions using PDCA (Plan-Do-Check-Act) approach, resulting in improvement plan to continuously reduce exceptions

Created daily report illustrating vendor timeliness performed trend analysis and identified root-cause of problems, improving identification of areas where suppliers were not on-time and needed improvement.

1/2015-5/2015 Measured Progress Portsmouth, NH

Senior Financial Analyst (Consultant)

Operations

Created and analyzed ROI & NPV financial models for business units evaluating cash flows generated by investment in competing products, resulting in increased revenue for the company and acceptable ROIs over asset’s expected life.

Created excel spread sheet models evaluating the budgeted gross margin vs. actual gross margin sales, performing gap analysis and deep dives into the data to determine rational for variances driving leadership to improve low margin sales

Created advanced level Gantt chart in excel identifying production bottle necks and manpower capacity issues, reducing bottlenecks in production schedule.

2/2014-11/2014 Cobham Exeter, NH

FP&A Manager (Consultant)

Analyzed P&L statements and performed root-cause analysis on low margin sales, provided detail and findings to CFO, VP, and business directors, resulting in reduced reoccurring loss margin orders and improved gross profit to forecast

Created and analyzed Late delivery Burn down report to track and measure monthly burn down of late deliveries, presented results of material burn down on monthly basis to CFO and VP that improved forecast and shipment of product

Created and analyzed report to track material Scrap cost, showing monthly trends that resulted in 20% reduction in scrap

Created and analyzed report that tracked rework to show material, labor and overhead trends over time working with leadership

Analyzed P & L statements to create warranty repair reports, measured warranty return rates and worked with Operations and leadership improving quality issues

2006-11/2013 Raytheon Company Andover, MA

Senior Financial Analyst

Manufacturing Operations (2011 – 2013)

Acted as Finance lead for Power Rex Value Stream operations resulting in reduced material production per unit hour, increased worker efficiency, and reduced material cost of 15%

Tracked manpower hours and material production that accrued on various programs, presented findings at

weekly meetings that resulted in lower manpower cost of 10%, material production issues, and reduced material rework of 50%

Automated and maintained weekly Efficiency K-factor reports utilizing excel Macros and analyzed reports to find areas of weakness by using gap analysis that resulted in increased employee efficiency of 33%

Kuwait and Korea Business Unit (2010 – 2011)

Acted as finance lead for both Kuwait and Korea programs forecasting monthly-yearly sales and profits that resulted in units being delivered to customers on schedule and 10% under cost

Tracked weekly profitability, material cost and builds, manpower levels, and presented findings to senior management that improved product builds and production schedules

US Spares Program Business Unit (2009 – 2010)

Achieved improved efficiencies of 200% and reduced cost by $80K by utilizing Excel Macros to automate reports

Created ad hoc reports utilizing pivot tables for program/finance manager that increased visibility of hours, cost, and revenue

Engineering Services Business Unit (2006 – 2009)

Reduced Finance department’s cost by $95K implementing Six Sigma processes

Presented cost reduction strategies to management utilizing the NPV, IRR, Payback period, and Breakeven analysis resulting in increased employee efficiency and report accuracy

SOFTWARE SAP BPC & GUI, Tableau, Blackline, SAP, C++ programming, VBA Programming with Excel Macros, Oracle, Power BI, MicroStrategy, IBM TM1, P2P Purchase to Pay, Pivot tables, V & Xlookups

EDUCATION WAYNE STATE UNIVERSITY Detroit, MI

Wayne State University School of Business

Master of Business Administration

Emphasis in Accounting and Finance

NORTH CAROLINA A&T STATE UNIVERSITY Greensboro, NC

Bachelor of Science in Electrical Engineering (Dual Degree Program), Cum Laude

Bachelor of Science in Mathematics (Dual Degree Program), Cum Laude

Bryan Mason 978-***-**** ***********@*****.***

Contact this candidate