John Drescher Email & Phone Number

Chicago, Illinois, Us

Chicago, Illinois, Us

Naperville, Il, Us

Naperville, Il, Us

Chicago, Il, Us

Us

•Establish and expand pro-forma model KPIs to determine margin, merchandising, promotions, telesales program, commission, and external KPI performance•Implement and assess standardized end to end process for marketing and promotion initiatives•Interview team to identify needs, construct hypothesis, track real time performance. Summarize finding into actionable recommendations for management•Conduct detailed customer segmentation by quantitative and qualitative attributes. Develop unique profitability models and execute deep dive analysis to identify profitability levels across customer segments. •Support external metrics/datasets to verify report accuracy as well as gaining comprehensive business view through supplemental analytics •Create and continuously enhance the CRM Tool (Customer Relations Manager) which is an interface designed for the telesales team allowing users to access account performances and current activities•Build annual budget by analyzing sales, discounts, margins, and expenses down to EBIT. Tweak monthly budget forecast through financial metric trends as well as investigating inconsistencies •Act as liaison between operations and finance to ensure accuracy of financial reporting •Manage subordinates in relation to short and long term goals/projects. Train others on SQL, VBA, access, and excel accordingly.

•Streamline process to capture FPS (Facility Products and Services) performance. Incorporate FPS results seamlessly into OfficeMax’s financial key metrics such as current year P&L, forecast, budget and year over year•Construct and update P&L report for SMB (Small Market Business) key initiative by capturing current year performance of multiple product lines•Design and create interactive budget model that allow management to visualize cause and effect of different scenarios to optimize performance and long term planning•Fine tone core components of the FPS forecast which include product expansion, key customer performance, and actual vs. forecast gap •Support senior management strategies by providing insights generated from robust transaction level data mining•Increase department efficiency by originating a multi-dimensional drill down tool that allows the Financial Analytic team to customize daily sales result by product, market, customer, or business line •Collaborate with internal customers to identify specific reporting needs in order to product specialized tools that best fit their unique requirements•Subject matter expert of OfficeMax internal database, customer structure, billing system, vertical and workplace markets•Design server tables that roll up same account data to ensure accurate strategic reporting and master account structures

•Lead automation process of weekly, monthly, and quarterly reports for field and senior executive team •Designed and generated central database using transaction data for sales reporting of multiple business organizations •Studied, analyzed and reported sales market structure identifying margin degradation and strategies for improvements•Bench marked and assessed current and long term initiative to goal •Created the methodology to realign sales and margin allowing budgeting to be done with a re-positioning of regional and vertical markets•Planned and measured key account level performance for internal sales team •Identified improvements within the data tracking system then defined project parameters for IT to make enhancements

•Allocated commissions and recommended pay out system to ensure business sectors stay within financial budget and goals•Customized consultant quota model allowing greater flexibility for commission baseline•Updated reports allowing management the ability to see accurate customer purchasing behavior and trends•Trained Human Resource department on utilizing developed database created for performance appraisals, internal audits, and quota setting benchmarks

•Conducted competitor analysis on existing products to distinguish industry ranking, and suggested product enhancements•Researched market trend for future opportunities, then analyzed innovation product feasibility •Analyzed current guidelines and proposed changes to ensure most efficient underwriting process•Supported underwriting department in creating guideline training tools for new hires •Utilized established data to promote strong communication and close gaps between production teams

•Analyzed sales productivity and trends for VP level•Created, updated, and maintained all sales reporting queries, models, formulas and databases•Improved revenue performance through robust variance and forecast analysis •Prepared presentations for high level management by utilizing financial models and analytic tools •Developed new strategies to assist management in future business planning and decisions making