Robert F Pfeifer

Robert F Pfeifer EXCEL EXPERT | OPERATIONS PROFESSIONAL 20 Byron Drive, Phillipsburg, NJ 08865- PROFESSIONAL PROFILE More than three decades of management experience using advanced Excel in support of global publishing Supply Chain operations. A proven track record using advanced Microsoft Excel to develop data analytics, reports and dashboards that provide management with the tools it needs to make informed strategic decisions and drive process initiatives to improve operational efficiencies. I am a firm believer in the development and use of data, metrics and KPI's for effective management. I am a self-starter with a strong work ethic who works well independently but is also committed to meeting the needs of the team and its success through collaboration and communication. CORE SKILLS Advanced Microsoft Excel including Pivot Tables, Power Query, Power Pivot, macros, complex formulas and data visualizations. Detailed data analytics and reporting. KPI’s and Dashboards. Global Supply Chain and Logistics operations. AS400 Query, Qlikview and MS Office. Operational and strategic planning. Independent problem-solving. Strong interpersonal skills. CAREER SUMMARY March 2016 to PresentEXL Optimization Group Principal I provide Excel expertise in a consulting role for companies and individuals in need. I support the development of new tools that deliver accuracy and simplicity in the reporting of key data. I also provide troubleshooting when questions or problems arise. Key Responsibilities The creation of dynamic, user friendly dashboards and reports using advanced Excel tools such as pivot tables, complex formulas (vlookup, sumifs, index/match, etc.), macros, visualizations and Power Query/Pivot. Provide hands-on support and troubleshooting for individuals and companies in need. Key Achievements Developed Excel-based data look-up and analysis solutions for UK Supply Chain consulting and solutions provider on several client projects. Provided trouble shooting and modifications to crucial Excel reports for John Wiley & Sons Supply Chain. Developed service tracking and monthly invoice generating spreadsheets for major wine and spirits 3PL. Advised and trouble shot Excel based invoicing for proprietor of pet grooming operation. Created variety of financial, payroll and personal tracking spreadsheet templates for individual clients May 2014 to January 2016John Wiley & Sons Director, Operations Performance and Analytics Responsible for leading the collection, analysis and reporting of metrics and key performance indicators (KPI’s) for Global Operations with the goal of identifying trends and opportunities for customers, products and data. Key Responsibilities Charged with the maintenance and timely distribution of the Global Operations dashboard and numerous departmental management reports using advanced Excel. Directed the regular development of ad hoc Excel based analysis and reporting for all Global Operations in coordination with professionals, supervisors and senior management from all areas of Wiley. Collaborated with leadership on the development of the analytics supporting the annual Strategic Plan. Accountable for the performance my team and responsible for driving plans and priorities to address operational needs and challenges. Key Achievements Achieved normalization of activity/expense information reporting across all global Supply Chain operations for all 3rd party logistics vendors. Collaborated globally to develop key KPI’s and metrics for all Global Operations functional groups. Created and implemented Excel based Dashboard to organize and report KPI’s and metrics regularly. January 1997 to May 2014John Wiley & Sons Director, Global Customer & Product Support Operations Manage operational analysis to drive continuous improvement within Global Operations. Provided expertise and supervision to enable the advancement of Customer Service and Fulfillment capabilities to best in class levels. Key Responsibilities Managed regular reporting of supply chain metrics and KPI’s through a suite of comprehensive reports utilizing best data from corporate based sources. Collaborated on the development of strategic data and analytics used in the crafting and implementation of processes and procedures that advanced best practices and cost saving opportunities. Key managerial go-to for supply chain data and analysis requests from other Wiley departments. Managed EDI ordering function in collaboration with IT resources and trading partners. Supported the annual development of group Strategic Plan/Narrative and provided financial analysis. Key Achievements Pioneered accurate and reliable reporting of distribution metrics and KPI’s through development of a suite of comprehensive Excel reports utilizing best data from corporate AS400 sources. Collaborated on development of comprehensive restructure plan to reshape North American distribution operations from a fixed to variable cost model. Provided all Excel-based analysis. Developed analysis and reporting of inventory activity, obsolescence and storage costs. Supported due diligence and transition activities for over 50 Wiley publishing acquisitions including. Developed operational plans in support of company strategies for successful transition and integration. Collaborating with 3rd party consultants, IT and Supply Chain managers developed analysis and list of options for short term improvements and long-term solutions for optimizing distribution center operations. Member of European Operations Review Group charged with the development of new European distribution/systems strategies for Wiley operations in the GSA, UK and rest of Europe. March 1990 to January 1997Penguin Random House Manager of Fulfillment Operations Supported the Fulfillment Group and Vice President in development and implementation of processes and procedures that advanced distribution and customer service to best in class levels within budgetary guidelines. Key Responsibilities Managed the regular reporting of metrics for the Fulfillment Group and other stakeholders. Responsible for the daily management of staff of 13 and 3 functional supervisors Developed budgets and strategic plans for the group Regularly led annual physical inventory team at 3PL distribution facility in Canada. Key Achievements Achieving normalized reporting across thru development, implementation and control of weekly/monthly status reports in Excel. Collaborated on external design and implementation of new Automated Returns Processing system for DC. Supported launch of new EDI Order System for processing of orders from trading partners. EDUCATION MBA in Marketing and Logistics University of Notre Dame, Mendoza Graduate School of Business Dean’s List BA in Economics University of Notre Dame, College of Arts and Letters Economics Honors Society RECOMMENDATIONS “Rob and I collaborated on many multi-million-dollar real estate/facility projects at Wiley. Several included Rob developing financial and operating models for distribution strategies that included my global real estate inputs. This modeling and analysis helped us evaluate the financial implications of distribution center acquisition and divestiture strategies and formulate actionable recommendations. Rob's modeling designs were always comprehensive, well formatted and easy to use.” Robert Nowaczyk, Founder & Principal, Corporate Real Estate Consulting and Interim Management Services (Former Vice President, Global Corporate Real Estate & Services at John Wiley & Sons) "I can highly recommend Rob’s skills in first understanding complex distribution and operational scenarios and then his ability to develop complex yet user friendly modelling tools to allow a comprehensive evaluation of the options and their associated fiscal impacts." Charly Nobbs, Principal, Supply Chain Optimisation (Former Vice President, Global Supply Chain John Wiley and Sons) “Rob is skilled at explaining complex distribution and operations issues to colleagues outside these areas, and has a deep understanding of financial metrics and ramifications for proposed changes.” Mo Niazi, Senior Director, FP&A at Cognizant (Former Finance Director, Global Professional Development at John Wiley and Sons)