Business Partner Financial Analyst

SCOTT HAMBROOK

704-***-**** Charlotte, NC

**************@*****.*** www.linkedin.com/in/scotthambrook

Summary

Strategic and results-oriented Senior Financial Analyst with over 10 years of experience in forecasting, budgeting, variance analysis, and financial reporting. Proficient in leveraging advanced tools like Excel, Tableau, and ERP systems (Oracle, SAP) to drive data-informed decision-making. Skilled in developing KPIs, dashboards, and financial corrective initiatives that enhance organizational efficiency and profitability. Recognized for leadership in cross-functional projects, delivering operational cost savings, and optimizing financial processes.

Core Competencies

Strategic Financial Planning & Analysis

Budgeting & Forecasting

Advanced Data Analytics (Excel, Tableau, Hyperion Essbase)

ERP Systems (SAP, Oracle, Workday)

KPI Development & Performance Dashboards

Process Improvement & Cost Optimization

Leadership & Cross-Functional Collaboration

Professional Experience

Consultant/Sr. Financial Analyst (Various Consulting Groups) Charlotte, NC October 2009 - Present

Implemented Marketing program budgeting and financial performance tracking tools. Created systems for recording revenue, customer claim submission and billing.

Created process and performance reports including budgets, variance analysis and forecasts with all

levels of management utilizing visualization tools such as Excel, Power Point and tableau.

Employed Hyperion Essbase, SAP, Spreadsheet Server and MicroStrategy to create routine (weekly, monthly, quarterly and annual) analysis reporting of KPIs, Metrics and Dashboards.

Spearheaded dynamic team from IT, finance and production to create 4 new on time labor productivity measuring tools from the plant utilizing OIL, SAP and workday platforms. Realized labor spends reductions of $686K in contract and $448K of overtime.

Conducted a labor analysis using labor tracker, excel and Oracle BI tools to discover a $ .7M labor allocation error and a $1.2M labor allocation errors

Manage wide spectrum of financial activities for multi-phase clinical studies under different Therapeutic Areas, including forecasting, study budgets development, supplier contract financial terms validations, vendor management, quarterly accrual confirmations and variance analysis.

Perform high volume of financial activities with numerous clinical service providers (CRO, Specialty Labs, Imaging, Biomarkers, etc.) which requires strong attention to detail, a high level of organization, and aptitude to understand and utilize multiple financial systems and tools.

Earned several service excellence recognition awards while ser4ving on corporate culture and leadership committees

Reduced obsolete inventory reserves 25% and consolidated 3 inventory warehouses by providing supply chain and inventory analysis from data exported out of Epicor and other ERP systems.

Developed tools utilizing advanced excel capabilities, logic and pivot tables to enhance business leader’s decision-making process. Enhanced sales quoting process and improved invoicing accuracy.

Key Clients: Medtronic, Biogen, DaVita Clinical Research, Siemens Energy, Wells Fargo, Lending Tree

Davita Clinical Research: Minneapolis, MN November 2004 – October 2009

A DaVita ($44B) subsidiary. Renal Phase I-IV clinical trial site and site management organization (SMO). Provides quality, timely, and cost-effective clinical trials services.

Director of Finance (2007-2009) / Business Manager (2004-2007)

Executed and coordinated corporate level financial reporting tools by moving financial data from Access and Excel databases into Oracle

Developed forecasts, budgets, variance analysis and business metric reports.

Directed multi-year department initiative to evaluate ROI on new contracts which increased project profitability 10% and added $300K in project profitability.

As a front-end Oracle user mined financial data using Hyperion Essbase and Excel to perform executive reporting including financial benchmarking, dashboards, and key performance indicators.

Eliminated financial policy and procedure redundancies and increased productivity by integrating old business financial reporting systems into the existing corporate environment.

Created cash forecasting tools and facilitated corporate re-allocations which improved department cash position by $5.0M.

Served as liaison across the parent corporation for promoting organizational change. Influenced initiative for adopting corporate operational standards.

Folded a cash run business into a sophisticated accrual-based operation.

Led multi-year initiative and recovered $1.3M in operational losses by correcting missed billing opportunities.

Dixie Electric, Inc. Plymouth, MN October 2003 – May 2004

U.S. Distribution arm of a Canadian based manufacturer. Dixie provides of a full range of re-manufactured and new alternators, generators, starters, and their components.

Business General Manager

Spearheaded P&L management and operational functions. Also managed office administration, customer service call center, warehousing, and distribution.

Discovered key operational efficiencies and led global cost saving initiatives which improved the bottom line and returned the U.S. operations to profitability.

Uncovered administrative duplications and led cost saving initiative for reducing administration G&A by 35% and restored $350K to the bottom line.

Identified $1.0M savings in shipping costs and formulated strategic plan to realign inventories, warehousing, and support staff for U.S. electric motor automotive market.

Technical Industrial Sales Chanhassen, MN May 1999 – May 2003

Manufacturing representative and distributor of services and products, including valves, controls, and instrumentation.

Administrative Assistant, Controller, Financial Manager

Recruited, hired, trained and managed office staff. Prepared and analyzed financial data. Coordinated benefit changes and enrollment. Processed payroll and filed taxes.

Provided contract analysis, pricing tables, measured margin rates.

Managed inventory reduction efforts which identified a 30% reduction of inventory and improved cash flow by $1.0M.

Maintained buyer compliance files such as W9’s, EFT forms, DUNS, contract updates etc.

Improved efficiencies in daily operations and reduced annual expenses $189K by eliminating wasteful spending.

Reduced health and benefits costs 45% by designing and implementing a new comprehensive benefits program.

Provided computer training on multiple programs, including custom programming implemented to enhance customer service.

Education

Master of Business Administration – DeVry University – Milwaukee, WI

Bachelor of Science Health Education –Moorhead State University of Minnesota – Moorhead, MN

Contact this candidate