Broc Bonham

Broc Bonham

Business Analyst · VIAIR

Garden Grove, CA

Work Experience

Business Analyst

VIAIR

2022 – 2022

· Responsible for the daily analysis and execution of forecast for all assigned items using combination of statistical forecasting methods and business intelligence · Collaborate with other key departments to understand strategic directions and provide business insight when purchasing and maintaining appropriate inventory levels · Extract and consolidate several data sets into databases to generate reports to maintain forecasts, ad-hoc reports, and dashboards in support of the business · Review and ensure data accuracy · Develop forecast strategies for special events, seasonal items, and new item transitions · Communicate regularly with multiple departments within the organization to identify and resolve supply chain issues · Research forecast error reports to identify items that require forecast adjustments · Develop new metrics and reports to track forecast accuracy and sales trends · Collaborate with teams to build and monitor forecasts for new items · Analyze impact of advertising, new item introduction, price elasticity, and other factors on an items sale rate · Participate in project meetings; summarize process and system improvements for successes or concerns · Prepare item summaries for executive review on sales and forecast patterns

Allocation Analyst

5.11 Tactical

2021 – 2022

· Create, validate, prioritize and track KPI’s using Power BI, AX, Lightspeed & Excel, to measure Allocation effectiveness and support Manager in evolving the monthly S&OP presentation & meeting. · Socialize, prioritize, and align with cross-functional partners on KPI measures and data logic. · Effectively communicate root causes and business narrative found in the quantitative analysis. · Leverage data, tools, and systems to further enhance the allocation process and ways of working that effectively prioritizes constrained inventory & communicates key fill dates to sales channel leaders, and coordinates execution in the system with customer service and IT · Understand and optimize order management systems to ensure it is executing to business priorities in partnership with IT. · Develop and execute allocation strategies through analyzing reports and making independent decisions that support financial plans and sales channel priorities. · Create and analyze ad-hoc reporting as needed to drive allocation and business decisions. · Analyze forecast and promotional assortment plans, collaborating with the Demand & Supply team to ensure their vision is aligned with allocation needs.

INTL Sales Operations Analyst

Fox Racing

2019 – 2022

· Evaluated and organized data to optimize reporting; managed internal monthly sales reporting while tracking sales vs budget and prior year to acquire an in-depth understanding of the health of the business and customers. · Proactively identified areas of improvement by defining problems, reviewing root causes, assessing data and patterns, generating alternative solutions, and offering innovative solutions to senior management. · Supported sales planning by constructing Excel-based financial modeling analysis and developing interactive dashboards to visualize key performance trends and provide actionable business insight for partner review. · Provided high-level, monthly executive summaries to senior management including the CEO and CFO. · Optimized data analysis for the $38M annual department, building a data scrubbing tool to account for all financial, sales, and marketing report needs. · Implemented new processes for all booking orders, creating dedicated order forms in Excel for distributors.

Inside Sales Representative / Customer Care Representative

Fox Racing

2015 – 2019

· Responsible for leading sales processes and resolving account inquiries for 350+ Fox accounts, including invoice requests, sales reports, order input, promotions, etc. · Delivered sales presentations to existing and potential customers to provide information on company products and services, resulting in increased sales and revenue generation. Personal sales totals equaled roughly $1.7m. I sold on my own and with the outside sales reps. It was a collaborated effort for some that is a little harder to measure. · Applied in-depth product knowledge to offer quality solutions in alignment with account needs; pinpointed and resolved inquiries to drive customer satisfaction. · Created and integrated informative training material for incoming customer service representatives, boosting performance and compliance with best practices.

Customer Service Representative

Oakley

2013 – 2015

· Fostered and managed professional relationships with customers; proactively identified customer concerns and inquiries to develop an understanding of all needs and issues and provide high-quality solutions. · Maintained accurate records of customer interactions, processed customer accounts, and filed documents. · Oversaw beta testing of new CRM software for introduction into global Oakley organization; leverage existing customer call knowledge to reenact standard situations and perform necessary duties along with using live calls.

Education

Irvine Community College

Industries

BikeLifestyleMoto & PowersportsOutdoorStreetwearHealth & Fitness

Connections