JS

Jesse Sherman

Financial Analyst II · Ingram Micro

Huntington Beach, CA

Work Experience

Financial Analyst II

Ingram Micro

2014 – Present

Analysis and reporting of sales and profitability data for large computer hardware reseller. Compiling forecast data for business units. Weekly, monthly, quarterly and ad hoc reporting for sales and profitability information for co-workers of varying seniority. Monthly accrual calculations for participating vendor rebate programs, and assigning producer rebates in accordance with contractual agreements. Maintaining data sources used by partner groups for sales reporting.

Financial Analyst

Nordstrom

2014 – 2014

Analysis, forecasting and reporting of Gross Margin and its component metrics. Data modeling scenarios for vendor negotiations and management initiatives. Created management presentations for half-yearly divisional budget meetings. Analysis and forecasting of markdowns to aid management in consideration of changing sale calendar.

Merchandise Reporting Analyst

Nordstrom

2012 – 2014

Produced and maintained suite of daily, weekly, monthly, quarterly, and event-specific sales reporting for Women’s Apparel division, ensuring accuracy and relevance to management and business partners. Improved performance of existing reporting by creating more efficient data extraction, improving use of formulas, and creating macros to aid in report navigation, automate production, and reduce errors. Created ad hoc reporting to aid in analysis of current business. Collaborated with partner reporting group to ensure SLAs are maintained and issues are promptly addressed. Acted as primary contact for reporting resources and management. Administered divisional SharePoint site. Developed comprehensive daily reporting for Anniversary using several different data sources which allowed management to easily identify business issues that needed to be addressed during the event.

Education

BA

University of Washington

1997 – 2001

BA

Industries

OutdoorHealth & FitnessFashion