Andrew Franz Email & Phone Number

Milwaukee, Wisconsin, United States

Milwaukee, Wisconsin, United States

- Create and maintain a 10-year financial model of Harley Davidson, Inc. for executive leadership to understand how the firm's strategic plan translates into financial performance and growth; Model utilized to communicate strategic plan to shareholders - Establish new balance sheet and cash flow reporting and forecasting processes that reduce complexity, increased visibility, and enable better judgement on share buyback amounts, inventory control, and debt management- Drive insights into motorcycle margin analysis by building reports to calculate the impacts that volume, product mix, pricing, and foreign exchange rates are having on financial performance and margin accretion or erosion- Deliver a robust financial reporting package breaking down variance analysis across the income statement, balance sheet, and cash flow which is used monthly by internal leadership to drive decision making and external earnings releases with shareholders- Implement new capital expense reporting and forecasting practices to better align spend with overall strategic objective of the firm- Modernize financial policies across the company to drive efficiency with month end close resulting in Manual Journal Entries being reduced by 16% year over year.

Greater Milwaukee Area

- Developed $250 million volume-driven budgets and forecasts to accurately predict logistics’ network spend across the fiscal year - Completed accounting processes at each month end to provide fiscal performance metrics of Harley’s logistics costs for leadership to report company earnings - Constructed and pitched financial models exhibiting the impact of multimillion-dollar capital investments produced by Harley’s worldwide logistics network- Assessed the complexities of the logistics landscape including cleaner emissions, tariff legislation, and government regulations to understand the fiscal impacts these have to Harley Davidson- Facilitated plant controllers with standard costing to determine material prices for inventory evaluations- Created cost estimates for final products to drive company-wide forecasting, planning, and pricing activities across the globe- Streamlined company master data in order to drive increased efficiency for plant operations

Greater Milwaukee Area

- Collaborated with HR and legal leadership to develop financial models that drove strategic decisions for cost saving initiatives- Consolidated company-wide headcount and vacancy data to calculate and predict salary and fringe spend through the intricacies of corporate restructuring- Created invoice management processes to ensure outstanding invoices are approved and paid on time, reducing month end accruals by 40%- Refined company-wide financial reporting spreadsheets that assist leadership in understanding real time fiscal performance

Madison, Wisconsin

UW-Madison's Division of Information Technology's goal is to support the primary institutional missions of teaching, research and service with innovative and creative IT services.- Built financial models to understand the impact and return of implementing new systems for university course scheduling and online classes- Deconstructed historical data to provide table and graph spreadsheet analysis of budget trends and projections at month end- Prepared spreadsheets to be utilized for business inputs to develop annual budgets and forecasts of revenues and expenses

Greater Milwaukee Area

Harley-Davidson fulfills dreams through the experiences of motorcycling, by providing to motorcyclists and to the general public an expanding line of motorcycles and branded products and services in selected market segments.- Developed multiple financial models to determine customer-facing programs’ ROI and potential demand elasticities - Engineered a forecasting model to depict projected demand for hosting motorcycle demonstration events at dealerships that is still used by upper management and leadership to better understand the revenue these events generate - Converted raw data composed of cash flows and company assets from customer-facing events into easily understandable quantitative facts backed by research and accessible for potential use- Presented research findings to finance and marketing leadership on a weekly basis to evaluate future recommendations for programs and events - Collaborated with team members, manager, and executive leaders to more fully understand the role corporate finance plays as well as the responsibilities of the finance department

Madison, Wi

The Wisconsin Union, often referred to as "the heart and soul" of the University of Wisconsin-Madison, has enhanced the lives of members and visitors since it was founded in 1907, one student at a time. - Perform set up and dismantle of rooms and auditoriums for all events around the Union- Aid the Union in customer relations through answering questions and navigating customers throughout the buildings. - Manage a team of co-workers to ensure rooms are properly prepared for every event in the Union throughout the day.

Libertyville, Il

Our Goal is to help people Enjoy a Better Life by sharing unique financial strategies, delivered in a professional and exceptional full service environment; to increase our clients’ Clarity & Confidence about their future.- Perform research on company holdings, including mutual funds, stocks, and bonds- Assist in the creation of client presentations and client portfolio reports - Aid in the development of firm's website and social media - Help the company maintain client relations- Exercise networking skills

Palatine, Il

Curvy Road is a hassle-free smart way to use your money, while getting the most out of an exciting lifestyle.- Built websites from scratch using Wordpress to clarify the brand’s services - Managed Facebook, Twitter, Blogs, and Instagram in order to develop a strong partnership between customers- Wrote newsletters and announcements detailing the company’s events, future expectations, and membership news

Hinsdale, Il

Clairmont, Ltd. is a home remodeling firm delivering quality construction, outstanding design, and unparalleled customer service. - Filed corporate expense receipts for residential construction jobs using Sage 50 Accounting software- Tracked change orders and other activities allowing management to properly invoice each customer- Recorded project financial data into Excel so management could compare actual costs to budget

Master Of Business Administration - Mba, 4.00/4.00

Bachelor’S Degree, Finance, Economic, 3.89/4.00

Activities and Societies: Pi Kappa Alpha Fraternity, Humorology, Wisconsin Fishing Club, Hoofers Outdoor Club