Scott McCann MBA
Moon Twp.,PA
Summary
Dynamic financial professional with Big 4 experience and a strong background in public and corporate finance, accounting, and supply chain management. Expertise in leveraging advanced technology skills, particularly in Microsoft Excel, for conducting complex analyses through multi-tab and multi-workbook automation, utilizing pivot tables, lookups, and conditional statements for insightful reporting. Proficient in various financial software, including NetSuite, SAP, Oracle 11.5i, and Microsoft AX, GP, and Sage, with strong capabilities in financial planning, budgeting, and forecasting. Proven leader with a track record of driving teams toward implementing innovative financial solutions that optimize processes and enhance organizational performance.
Overview
26
26
years of professional experience
Work History
Controller & FP&A
ADDEV Materials Converting
05.2022 - Current
- Created daily / weekly analysis of revenue and margin by business unit, by sales representative, by customer to show performance against budget and forecast and to project month / quarter end landing utilizing actual performance and layering in backlog.
- Provide detailed customer and part-level detailed analysis for sales leadership to show sales representative and part-level performance.
- Execute month end close, and compile financial data by utilizing advanced Excel spreadsheets, Great Plains ERP.
- Perform monthly, quarterly and yearly forecast of sales and margins in total and by customer and resulting cash flows.
- Prepare ad-hoc financial analysis of profitability by customer and part to show which products are being priced properly or are having production issues and researching what changes need to be affected make them profitable again – Price increases or production cost updating or both.
- Instituted year end cost roll process to better account for production overhead and labor rates down to the production cell level to facilitate enhanced price quoting at the part level.
Controller
West Penn Wire / Belden Inc.
04.2020 - 07.2022
- Execute month end close, and compile month-end total financial data by utilizing advanced Excel spreadsheets, and BPCS.
- Perform monthly, quarterly and yearly forecast of sales, costs and cash flows.
- Prepare ad-hoc financial analysis and direct the creation of ad-hoc analysis to three direct reports including Accounting Manager for X-Mark (additional Belden plant in Washington PA).
- Developed new year end cost roll process to better account for production overhead and labor rates to include fringe.
- Created and maintained Key Performance Indicators and provided analysis to explain variances to those KPI’s.
- Automated the daily sales and manufacturing performance scorecard creation and distribution processes.
- Remained as the last employee to close the location and facilitate the move of production from the Pittsburgh location to another Belden facility in Mexico.
Controller
TROY Group, Inc.
08.2017 - 04.2020
- Execute month end close, and compile month-end total financial data by utilizing advanced Excel spreadsheets, and Oracle Netsuite. Perform monthly, quarterly and yearly forecast of sales, costs and cash flows.
- Manage and coordinate the yearly budget process. Prepare ad-hoc financial analysis. Three direct reports including Accounting Manager.
- Developed new monthly reporting to reflect profitability by all sales departments, Sales reps and product line.
- Redesigned daily sales reporting to show revenue and margin versus forecast and budget to include all backlog breakout and individual salesperson performance versus current month budget.
- Established customer performance reporting to show history of customer sales and profitability in total and by product.
- Played pivotal role in implementing NetSuite conversion from Microsoft Dynamics. Moved all historic data, established new GL structure and consolidated accounts and departments to create a more logical and streamlined ledger using very advanced excel spreadsheets. Transacted successfully on day one of Netsuite implementation and established newly automated closing and reporting procedures and processes.
Sr. Financial Analyst
Carpenter Power Products (Carpenter Technology Corp.)
11.2014 - 07.2017
- Created an excel based pricing model for all products from all US locations including all material costs, production costs, and overhead costs. This allowed the commercial organization visibility into what expected margins and stable profits should be at various price points. It also has functionality and the flexibility to show what the pricing should be at required margin% and at different volume levels. Used, in coordination with market data, it helped establish price sheets for standard products company wide. Brought sales margins to their highest historical levels.
- Established weekly cadence for coordination of the commercial group efforts to achieve their monthly targets by providing real time data showing results by customer by part and what orders are in the backlog to help identify any shortfalls. Created new weekly, monthly and quarterly excel based reporting to show actual results against forecasted sales results to give volume, revenue, sale price and margin dollars down to the customer and part level detail.
- Managed Bridgeville PA finance and supply chain with 5 direct reports: production scheduler, purchasing, receiving, shipping, and a production systems coordinator. Established weekly S&OP meetings to assure coordination and expectations between sales and operations relative to customer deliveries. Developed and managed excel based production schedule for 3 furnaces at Bridgeville and one in Athens AL. Developed multiple analysis to show expected production performance against actual performance to highlight where inefficiencies and higher costs came through to identify and provide recommendations for corrective actions.
- Managed all US based CPP customer service with 3 direct reports. Established new “sales flow” protocol to streamline the customer quoting process and capture historic data for better forecasting and production planning. Created new reporting around weekly, monthly, quarterly and yearly bookings and quotes.
Sr. Financial Analyst
Education Management Corporation
06.2012 - 11.2014
- Standardized and optimized processes for 10 locations: developed new metrics that were actionable, measurable and reportable across all locations; created daily dashboard that allowed for early detection of those Key Performance Indicators that strayed from agreed upon levels; and spearheaded an overall 10% reduction in operating costs across all locations.
- Fostered a more business like environment than the one that had been predominantly academic where little attention had been paid to economic consequences of business practices: instituted weekly KPI calls with each location to review metrics and discussed paths towards improving, maintaining and exceeding targets; dollarized existing and new metrics to highlight financial impact of missing or exceeding targets.
- Directed the creation of expanded and updated monthly quarterly and yearly forecast of costs and cash flows: utilized advanced excel spreadsheets and Cognos Impromptu to help locations compile data to use in forecasting and planning.
Financial / Supply Chain Manager
Pittsburgh Glass Works. (PPG)
02.2010 - 06.2012
- Optimized inventory levels to achieve required customer fill rates and projected cash flow assumptions through tracking and inventory level targeting. Assured inventory was currently and projected to be at the optimum levels to attain and sustain required customer service fill rates and have the greatest possible positive effect on cash flow. Drove a 30% reduction in inventory while increasing fill rates through integration of inventory management and production planning processes.
- Facilitated Weekly KPI call between production facilities, value add facilities, raw glass providers and main distribution center. Facilitated communications within the supply chain and between finance, outside auditors, raw glass providers, sales and customers to bring about a conduit for facilitating discussions. Created and compiled ad hoc financial and production analysis for COO. Created template for improved tracking of weekly reported KPI’s. Performed monthly and strategic forecast of costs, and cash flows. Forecasted monthly inventory in cooperation with facility operations personnel.
Senior Financial Analyst
Sapa Extrusions Inc. (Alcoa)
10.2007 - 02.2010
- Lead corporate finance team in due diligence effort for acquisition of Sapa’s largest competitor Indalex. Established and maintained process for tracking and reporting projected synergies between Sapa and Indalex. Adapted Indalex daily, weekly, monthly KPI reporting methodology to the Sapa model by integrating their existing reporting procedures and systems with Sapa’s. Trained Indalex Controllers on all Sapa’s procedures, reporting requirements, timelines, and Sapa’s Hyperion reporting system (HFM).
- Executed month end close, consolidated and compiled financial data. Carried out the corporate headquarters monthly, quarterly and yearly close. Prepared monthly tracking and comparison analysis for review by CFO. Consolidated and reviewed North America results for reporting to global head office. Performed daily, weekly, and monthly KPI reporting for all North America locations. Performed monthly, quarterly, yearly and strategic forecast of sales, costs, and cash flows. Synchronized with all North American locations on procedures, requirements, and timelines for each planning process.
- Established procedures around and accounted for all North American capital spend. Built systems used for financial justification of capital spend, identifying where projects were in the approval process, and monthly reporting. Confirmed adherence to required financial metrics and approval levels for all capital requests for use in a bi-weekly briefing of both the CFO and CEO on Capex status.
Sr. Financial Analyst
EMD- Curtiss Wright (Westinghouse)
12.2004 - 10.2007
- Executed month end close, and compiled month-end total financial data utilizing advanced Excel spreadsheets, Oracle Discoverer and Oracle Applications 11i. Performed monthly and yearly forecast of sales, costs, margins and cash flows. Prepared ad-hoc financial analysis utilizing Oracle Discoverer and Hyperion Retrieve.
Sr. Financial Analyst
Fisher Scientific
05.2001 - 10.2004
- Assisted in the complete reorganization of Research business unit from a customer volume-based reporting structure to a regional / industry-based structure. Established and maintained controls for the new organization structure. Developed all new reporting and analysis for each individual sales VP, Manager, and Representatives to reflect their performance against their forecast / historical data. Trained new analysts brought on to handle increased volume of information analysis.
- Created customer based financial analysis including, pro-forma, post audit, contract compliance, and customer specific operating improvement initiatives. Responsible for establishing communication between legal, sales, finance and operations to ensure effective assessment and capitalization of incremental profit dollars resulting from customer specific financial analysis. Maintained a database of account findings and summary results utilizing both standard and ad-hoc reporting.
Audit - Staff Accountant
Deloitte & Touche, LLP
09.1999 - 05.2001
- Coordinated year end audit, quarterly / yearly tax filings, and corporate compliance. Acted as primary point of contact and liaison between plants, shared services, and external auditors. Assured federal and state income taxes were submitted accurately and timely. North American corporate compliance officer.
Education
Masters of Business Administration -
Robert Morris University
01.2007
Bachelors of Science - Business Administration (Finance)
Robert Morris University
01.1999
Skills
- Preparing financial statements
- Financial statement review
- Financial management
- Risk management
- ERP systems expertise
- Budget development
- Financial strategy management
- Attention to detail
- Cash flow management
- Staff management
- Financial forecasting
- Budget preparation
MILITARY HISTORY
United States Marine Corps Camp Pendleton CA Sergeant May 1992 – June 1996
Timeline
Controller & FP&A
ADDEV Materials Converting
05.2022 - Current
Controller
West Penn Wire / Belden Inc.
04.2020 - 07.2022
Controller
TROY Group, Inc.
08.2017 - 04.2020
Sr. Financial Analyst
Carpenter Power Products (Carpenter Technology Corp.)
11.2014 - 07.2017
Sr. Financial Analyst
Education Management Corporation
06.2012 - 11.2014
Financial / Supply Chain Manager
Pittsburgh Glass Works. (PPG)
02.2010 - 06.2012
Senior Financial Analyst
Sapa Extrusions Inc. (Alcoa)
10.2007 - 02.2010
Sr. Financial Analyst
EMD- Curtiss Wright (Westinghouse)
12.2004 - 10.2007
Sr. Financial Analyst
Fisher Scientific
05.2001 - 10.2004
Audit - Staff Accountant
Deloitte & Touche, LLP
09.1999 - 05.2001
Bachelors of Science - Business Administration (Finance)
Robert Morris University
Masters of Business Administration -
Robert Morris University