Joseph Brosnan
Hoffman Estates,IL
Summary
My passion is helping companies realize their strategic potential and maximize ROI through innovative, sustainable, data-driven solutions in a team environment. I do this by providing actionable data to management to spot opportunities and help drive EBITDA. My long-term goal is to become a leader in the field of corporate finance while broadening my experience and skills in multiple business functions.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Financial Analytics Manager
US Foods
Rosemont, IL
04.2017 - Current
- Completed Level 1 and Level 2 Anaplan Model Building
- Performed Anaplan Administrator responsibilities including Forecast Roll-over, List Changes, Time Setting Changes, User Access/Security, and troubleshoot model issues
- Managed large-scale implementation for Finance Team conversion from Hyperion to Anaplan for standard reporting and ad-hoc analysis.
- Led User Acceptance Testing for Finance organization for reporting requirements in the FP&A Reporting Model
- Provided and presented to CFO monthly cost variance analysis for the corporate finance departments
- Served as Corp FP&A Team Lead for reporting questions and developing Q&A processes for outgoing reports
- Process manager of calculating organic and acquisition case growth that was used in SEC Quarterly filings
- Hosted and conducted web and skype trainings for Microsoft Excel, Merlin, and Anaplan
- Owner of the Routine Scorecard that tracks performance of output metrics and activity assessments for key company initiatives
- Created and managed the Consulting Dashboard in tableau that provides insight into consulting spend by function, department and vendor.
Senior Financial Analyst
US Foods
Rosemont, IL
08.2014 - 04.2016
- Created Focus Market reports for leadership to discuss and address action plans to turn poorly performing markets around
- Prepare month end and quarterly board decks for high level executives and field leadership
- Streamlined the Capital Expenditure Proposal process by simplifying the complex model
- Collaborated with other functional teams and field leadership on Capital Expenditure Models
- Prepare, audit, and edit financial reports using NVision and Peoplesoft
- Publish financial metrics of actual results versus previous year results and annual operating plans which include financial metrics, accounts receivable metrics, bonus true-ups, and inventory metrics
- Train new team members on systems, Microsoft Excel, VBA Macros, and team procedures
- Prepare and complete month-end close activities.
Financial Analyst III
US Foods
Rosemont, IL
03.2013 - 07.2014
- Streamlined Alert Date Report by building a macro to increase efficiency of the field teams and replenishment teams by saving time and highlighting products that might spoil before they are sold to customers
- Increased accuracy and transparency of Flash reporting
- Owned Acquisition Reporting which includes ROI Analysis on Quandt’s Customers
- Became team source for NVision data pulls and edits
- Prepared SEC financial reporting for pending merger between US Foods and Sysco
- Provided financial and sales information for insurance claim for the Jackson Division disaster.
Sales Analyst
Cars.com – Classified Ventures
Chicago, IL
01.2008 - 03.2013
- Collaborated with Cars.com senior management to develop and implement actionable Key Performance Indicators, resulting in increased benchmarking, forecasting, and budgeting capabilities throughout the organization
- Improved Rate Increase/Contract Renewal process and reporting in 2008 and 2009 which resulted in an 8% decline in cancels and a 5% increase in average contract increase
- Built custom objects in salesforce.com that reduced the Contract Analysts processing time by over 80%
- Developed a cancel trending and warning analysis that helped lowering customer churn from 9% to less than 6%
- Led Project Team to reconcile and populate contract signed and expiration dates in salesforce.com for over 5,000 customers
- Audited and verified reports for accuracy and consistency while supporting a sales team responsible for $500 million annual revenue
- Streamlined Affiliate Market Summary reports that save Affiliate Sales Managers 1-2 hours in preparing data for a market visits.
Education
B.S - Finance
University of Illinois At Urbana-Champaign
Skills
- Advanced skills in Microsoft Excel
- Anaplan Certified Model Builder
- Intermediate skills in VBA
- User Acceptance Testing (UAT)
- Anaplan Dashboard Design
- Financial Analysis
- Budgeting
- Sales Analystics
- ROI Analysis
- Pricing Analysis
Certification
Anaplan Certified Model Builder
Timeline
Financial Analytics Manager
US Foods
04.2017 - Current
Senior Financial Analyst
US Foods
08.2014 - 04.2016
Financial Analyst III
US Foods
03.2013 - 07.2014
Sales Analyst
Cars.com – Classified Ventures
01.2008 - 03.2013
B.S - Finance
University of Illinois At Urbana-Champaign
Similar Profiles
Aleni NuualiitiaAleni Nuualiitia
Territory Manager at US FoodsTerritory Manager at US Foods
Mario WalkerMario Walker
Warehouse Forklift Operator at US FoodsWarehouse Forklift Operator at US Foods
Manuel GarciaManuel Garcia
Warehouse Worker at US FoodsWarehouse Worker at US Foods
Camilo CardenasCamilo Cardenas
Order Selector at US FoodsOrder Selector at US Foods
Amy JoAmy Jo
Private Piano Teacher at Self-employeedPrivate Piano Teacher at Self-employeed