Robert Ritchie Email & Phone Number

Lisle, Il

Develop sustainable data-driven decision-making reporting through existing BI modeling tools to measure the performance of North American Truck and Bus dealer channel sales penetration, new truck sales, service, used truck, and parts sales.• Created and delivered 2018 NA Dealer Truck Plans one month ahead of previous year.• Developed, streamlined, and published monthly dealer scorecard with key leading and lagging indicators.• Reduced cycle time on report generation by… Show more Develop sustainable data-driven decision-making reporting through existing BI modeling tools to measure the performance of North American Truck and Bus dealer channel sales penetration, new truck sales, service, used truck, and parts sales.• Created and delivered 2018 NA Dealer Truck Plans one month ahead of previous year.• Developed, streamlined, and published monthly dealer scorecard with key leading and lagging indicators.• Reduced cycle time on report generation by 65%, which utilized and Implemented existing business intelligence tool Power Pivot.• Designed automated bi-weekly NA Truck and IC Bus Sales and Slotted Order Report for Senior leadership team in SSAS with real-time, mobilized, drill-down capabilities.• Generated and automated 180 dealer market share penetration reports in less than a month for the President of Truck and Bus and his direct reports. Show less

Lisle, Il

Develop U.S. market pricing strategy for one billion dollar Global Bus Organization (GBO) through collaboration with sales, finance, marketing, purchasing and GBO Senior Management to ensure bus pricing is executed in optimal manner that drives margin and market share goals utilizing competitive market dynamics, customer behavior and value proposition.•Capture and review bid results and ensure IC dealers are competitive while avoiding discount levels that damage the IC brand or… Show more Develop U.S. market pricing strategy for one billion dollar Global Bus Organization (GBO) through collaboration with sales, finance, marketing, purchasing and GBO Senior Management to ensure bus pricing is executed in optimal manner that drives margin and market share goals utilizing competitive market dynamics, customer behavior and value proposition.•Capture and review bid results and ensure IC dealers are competitive while avoiding discount levels that damage the IC brand or financial position.•Solid understanding of IC dealer network, competition and market place trends.•Mine, analyze and summarize market registration data and use as a basis to recommend pricing strategies.•Ensure premium is collected on specifications where IC has a competitive advantage.•Actively participate in or lead periodic meetings with sales force and management to discuss pricing strategies.•Establish a relationship with dealer through and in-depth understanding of their business model/challenges and identify possible sales opportunities for mutual benefit. Show less

Responsible for sales analytics and reporting, budgeting and forecasting as well as developing, maintaining sales databases and calculating sales commissions for the KaVo North America, Danaher Special Markets and Pelton & Crane businesses. This role partners significantly with the sales teams, leveraging data to help execute sales strategies. Reports to VP of Finance with dotted line responsibility to Sales VP.Selected accomplishments include:•Subject matter expert… Show more Responsible for sales analytics and reporting, budgeting and forecasting as well as developing, maintaining sales databases and calculating sales commissions for the KaVo North America, Danaher Special Markets and Pelton & Crane businesses. This role partners significantly with the sales teams, leveraging data to help execute sales strategies. Reports to VP of Finance with dotted line responsibility to Sales VP.Selected accomplishments include:•Subject matter expert successfully developing and upgrading existing SQL commission program for special market sales teams from seven Danaher dental companies [$300MM North America Revenue] and third party dealer channel sources.•Achieved 75% more efficiency as a project manager working closely with consultants to create a SQL based sales commission program reducing the process from 40 to 10 hours.•Establishing customer sales Access database from ground up, resulting in monthly sales dashboards, standardized product line reporting, and overall greater attention to customer needs. •Developed management tool for marketing, resulting in profitable promotions for KaVo North America.•Identified operational issues and recommended proactive solutions and action plans. Show less

Responsible for month-end close, forecast, sales reporting, and final Hyperion B/S and P&L templates for environmental line companies. Collaborated with KaVo Controller in monthly close cycles and budgets.Selected accomplishments include:•Improved monthly process by 60% by designing and implementing a database in Access for automating the calculation and reporting of sales commissions for entire sales force.•Restored confidence with sales force by reducing deadlines for… Show more Responsible for month-end close, forecast, sales reporting, and final Hyperion B/S and P&L templates for environmental line companies. Collaborated with KaVo Controller in monthly close cycles and budgets.Selected accomplishments include:•Improved monthly process by 60% by designing and implementing a database in Access for automating the calculation and reporting of sales commissions for entire sales force.•Restored confidence with sales force by reducing deadlines for sales and commission reporting by over 50% (10 days) that allowed our sales team to be more responsive to customers needs.•Established Access database to track and report warranty costs which highlighted quality issues to senior management.•Selected as “Go to guy” for all ad hoc product line SKU performance, margin, and pricing analysis for all Danaher Dental VPs and senior management on a monthly basis. Show less

Provided direct financial support to Strategic Account Sales VP and Segment Directors for $330MM business. Prepared sales and base cost reporting to management.Selected accomplishments include:• Prepared $13MM annual base cost forecast on a quarterly basis and communicate to management. Analyzed and provided commentary on monthly base cost performance to forecast.• Performed monthly sales and base cost analysis determining variance drivers.• Prepared monthly operating… Show more Provided direct financial support to Strategic Account Sales VP and Segment Directors for $330MM business. Prepared sales and base cost reporting to management.Selected accomplishments include:• Prepared $13MM annual base cost forecast on a quarterly basis and communicate to management. Analyzed and provided commentary on monthly base cost performance to forecast.• Performed monthly sales and base cost analysis determining variance drivers.• Prepared monthly operating report on the performance of strategic accounts compared to company KPIs and made recommendations.• Work closely with Sales VP to develop annual topline and CM% quotas for Strategic Account incentive calculations. Show less

Key business analyst for $140 million Retail Products Division of two billion dollar public Schneider Electric. Responsible for product customization, creation of data mining, and ad hoc query creation to yield business intelligence solutions for critical programs. Selected accomplishments include:•Implemented $5MM+ price increase to the retail channel resulting in “Risk Taking and Results” award.•Managed and negotiated stock price of major retail big box customers (i.e… Show more Key business analyst for $140 million Retail Products Division of two billion dollar public Schneider Electric. Responsible for product customization, creation of data mining, and ad hoc query creation to yield business intelligence solutions for critical programs. Selected accomplishments include:•Implemented $5MM+ price increase to the retail channel resulting in “Risk Taking and Results” award.•Managed and negotiated stock price of major retail big box customers (i.e. Home Depot, Lowes, Menards, etc.) for Retail Products Division.•Estimated impact of major pricing decisions using price realization, sales, operating margins, and break-even analysis.•Drive alignment of wholesale and retail pricing to minimize pricing conflicts between retail and wholesale channels.•Presented overall retail pricing strategies to third party outside sales representatives and Field Channel Price Group to better service our customer.•Budgeted and forecasted all customer programs and incentives. Show less

Responsible for management of pricing and incentive programs for all retail accounts, breakeven, sales, and margin analyses to assist senior management with key account strategies. Provided analysis with new product launches and market specific initiatives to increase sales and margins. Selected accomplishments include:•Created a computer-based interactive decision support system for competitive Home Depot E-bid saving $1.3MM in price loss for the company. •Created a price… Show more Responsible for management of pricing and incentive programs for all retail accounts, breakeven, sales, and margin analyses to assist senior management with key account strategies. Provided analysis with new product launches and market specific initiatives to increase sales and margins. Selected accomplishments include:•Created a computer-based interactive decision support system for competitive Home Depot E-bid saving $1.3MM in price loss for the company. •Created a price rationalization tool instrumental in implementing price increase for Home Depot. Price increase was applied and a $500-$600K price gain was realized.•Spearheaded analysis of customer service agreements that netted the company over $100K.•Developed special order process in which the retail channel could competitively support special orders, resulting in better service to our customer and taking business away from our competitors.•Project manager for upgrading pricing application software. Show less

Supported Sales & Marketing by providing base cost reporting, identifying cost variance drivers, tracking marketing programs, and analyzing applicable balance sheet accounts.•Highlighted base cost variance drivers on a month-end basis for Sales and Marketing organization.•Provided base cost reporting and respond to various inquires relative to cost issues.•Developed and implemented project tracking process for Sales & Marketing programs.

•Implemented automated foreign affiliate A/R system.•Managed corporate fixed assets and forecasted depreciation expense.•Trained marketing/finance personnel on fixed asset/project tracking software.•Analyzed balance sheet variances.•Analyzed and prepared quarterly management reports.•Coordinated mid-year and preliminary year-end audits by Arthur Andersen.

•Analyzed and prepared financial statements for eight divisions. Performed variance analysis on results of operations.•Integral part of Accounting team that improved monthly close cycle by ten days.•Assisted CFO with rental expense budgets.•Prepared sales and property tax returns for multiple states.•Maintained fixed assets on Best FAS2000.

•Compiled and reviewed balance sheet and income statement accounts utilized in preparing financial statements.•Performed project accounting which included maintenance of job cost details and verification of expenditures for capital projects.•Managed and analyzed balance sheet account activity.•Maintained Account Analysis books for Ernst & Young year end audit.•Processed payroll for over 200 employees and created all monthly G/L JEs.