Business Planning and Analysis Specialist with Over 15 Years Experience Serving Complex Organizations SUMMARY
Budget Administration, Performance Reporting, Product/Customer Profitability, Statistical Sales and Inventory Forecasting, NPV Analysis, Business Intelligence Systems, Benchmarking, Process Improvement.
PROFESSIONAL EXPERIENCE
P3 CONSULTING 2002- 2007
Entrepreneur/Consultant to trade association, publishing, fulfillment, testing, construction, and real estate businesses. Clients include NYFIX, Scholastic, Advertising Specialty Institute, and Educational Testing Service.
Solutions. Improved Entity Controls, Clarified information with new charts of accounts, constructed budget systems. Accelerated month end close. Improved commission systems Systems. Budget system construction, System installations, MAS500, GREAT PLAINS, FORECAST PRO, POWEROLAP, FRX, ADP, MS-ACCESS, EXCEL development
THE NEW YORK TIMES, New York, NY 1980 - 2002 Manager Finance Planning and Analysis and Internal Consulting
The Times is a complex $2 billion decentralized business unit with about 5,000 employees, hundreds of nationwide operations selling to both consumers and businesses, and over $500 million in manufacturing costs scattered across 10 facilities.
Managerial Responsibilities. Administered Budgeting/ Planning, and Forecasting, Interviewed hired, coached and developed permanent and project staff. Two awards for exceptional project performance. Solutions. Streamlined and accelerated budget and financial reporting processes, Mergers and Acquisitions, Improved Performance measures, new products and evaluation, and access to information. Systems. Hyperion Essbase, PEOPLESOFT, SAS, Software Selection, Report Writing, Systems Enhancements
PENNSYLVANIA DEPARTMENT OF LABOR, Harrisburg, PA 1972 - 1976 Statistician/Programmer
ADJUNCT TEACHING EXPERIENCE
THE COLLEGE OF NEW JERSEY, Ewing, NJ & MERCY COLLEGE, Dobbs Ferry, NY Taught classes in Business Strategy, Corporate Finance, and Economics, 2001-2006
EDUCATION
NEW YORK UNIVERSITY, New York, NY Advanced Graduate Studies in Economics, Statistics, and Information Technology 1981-1993
PACE UNIVERSITY, New York, NY MBA, Economics/Finance, 1980
SHIPPENSBURG UNIVERSITY, Shippensburg, PA BS, Management, 1971
ACCOUNTING CERTIFICATION THE INSTITUTE OF MANAGEMENT ACCOUNTING, MONTVALE, NJ CMA Certificate in Management Accounting, 1999
ACCOMPLISHMENTS
MONTHLY RESPONSIBILITIES Staffing. For over 20 years interviewed, hired, coached, and evaluated staff. (NYT Administered budget workflow. For over 15 years, developed procedures, schedules, assumptions, presentations and customized templates. Continuous improvements of processes using Hackett benchmarking recommendations. (NYT, P3) Projects. Team leader and member for projects for over 20 years that included corporate officers, operating VPs and staff. Two awards from NYT Publisher for exceptional Project performance. Contact me for a full list. Short term Rolling Financial forecast. For over 15 years, created four re-forecasts each month. (NYT) Cash Forecasting. For over 15 years, developed short term and 3 year cash budgets and forecasts. (NYT) Long term plans. For over 15 years developed 3-10 year plans including capacity expansions (NYT). Business plan narrative. Organized structure and narrative for annual corporate reporting requirement of NYT Newspaper. 3rd Business Day Financial Closing. Prepared basic financial statements using automated system showing variances to budget, forecasts, and prior periods. (NYT, P3) Performance Reporting. Each month, created and automated 100 page performance package. Each year prepared measures including economic outlook and business plan (NYT, P3) Incentive Programs. Maintained data for executive and sales force compensation plans. (NYT) Daily and weekly performance reports. For over 15 years, forecasted and reported on over 1,000 production and statistical measures for each day or week of the year. Became part of automated EIS. Compared actual to budget, history, and standard. Prepared news summary for senior staff. (NYT) Statistical report. By 8th day, prepared reports on detailed sales, operations, staffing, project performance, and competition. (NYT, P3) Revenue Forecasts. By 8th day, Prepared statistically based revenue forecasts with explanations of variance from trend (NYT, P3) Product profitability. Prepared detailed weekly, monthly and annual profitability reports. (NYT) Report packages. Over 15 years experience assisting with SEC, tax, audit, management, and special analysis for corporate communications reports to external stakeholder groups. (NYT)
METHODS Database Development. Hyperion Essbase- 7 years, PEOPLESOFT, FOCUS, SAS, SIMPLAN, ADP, MAS500, FRX, TIMS, GREAT PLAINS, MS ACCESS and EXCEL Planning Process Design. Created budget systems for major departments including Financial, Circulation, Advertising, Production and Corporate (NYT, P3)). Chart of Accounts Design. Participation in three chart of account redesigns to simplified and accelerate forecasting and accounting. Special emphasis on payroll, revenue, and major vendor reporting. (NYT and P3) Standard Cost Method of Product Profitability. Uses expert knowledge or statistical inference to create costs for each line item sold to customers as quickly as possible. Calculates total standard costs for all invoices. Compares to actual costs and revise or interpret as necessary. (NYT) Statistical Sales Forecasting. For over 15 years, managed econometric and statistical models of advertising markets to create scenarios for various sections and editions using national and regional economic statistics. Used SAS and FORECAST PRO FOR WINDOWS (NYT, P3) Enterprise model. Initiated and led development of enterprise-wide modeling project to develop scenarios and perform risk analysis. Connected financial measures to non-financial business drivers used throughout the organization. Contained over 1 million line of financial model code. Used to analyze policy and risk and create performance metrics for over 17 years (NYT) Benchmarked Measures. Familiar with many benchmarking groups. Participated in newspaper benchmarking group that included the Times, Boston Globe, Chicago Tribune, Washington Post, Los Angeles Times, and Philadelphia Inquirer. Participated in Hackett benchmarking of back office functions. Used for financial reengineering and collective bargaining. (NYT) Economic reports. Prepared annual economic outlook. Maintained econometric models and wrote reports for US advertising spending. Used by NYT executives for budget setting and for presentations to external stakeholders. (NYT, P3) Industry Analysis. Maintained econometric models of advertising spending for all media for budget reviews and company presentations to external constituencies (NYT) Customer and Competitive Analysis. At NYT and P3, created and maintained databases to report on Advertising customers and competition.
RESULTS OF SPECIAL PROJECTS Automated forecasts and annual GL budget process. Three migrations from GL and spreadsheets to database packages at $1.5 billion NYT newspaper. Includes use of Hyperion Essbase. For P3 Clients, created Excel based budget system. Created budget applications for operating departments highlighting Payroll data, customer data, processes, and major vendors Payroll Budgeting and reporting. To assist operating departments, created separate weekly budgeting and reporting for over 2,000 separate persons and 17 unions with separate benefit plans at NYT. Developed payroll reporting for P3 Clients. Financial closings. Used FOCUS and Hyperion ESSBASE to accelerate month-end financial closing (NYT) Software selection. At P3 and NYT, gathered requirements and participated in software selection and implementation for Financial and Analytic systems including HYPERION, PEOPLESOFT and TIMSS International Expansion. Research, analysis, and presentation of economic, demographic, and media data for over 100 countries. Included company research of international publishing businesses. (NYT) Product Development and Redesign. Helped determine redesign needs by monitoring product profitability over time to identify products with low or declining profitability. Accelerated product development by using News standards to create hypothetical new products. (NYT, P3) Mergers and Acquisitions. Research, scenario analysis, and valuation using DCF-based financial models of acquisitions and divestitures of magazines, newspapers, newsprint mills, and Cable Television properties. Resulted in 4 purchases of over $400 million combined. Pricing and Customer Negotiations. Some NYT products cost over 1,000 times that of others. Sales persons and pricing coordinators were able to use standard cost matrix developed in the Advertising system to assure that customer contracts were profitable. Using benchmarking data was able to determine if some costs were higher than competitor costs. Advertising Profitability. Designed and managed standard cost based system for over 900 Advertising components of the Times and included the associated selling costs. Extensive use of statistical inference to create standard costs. Used Standard Direct and Actual selling costs in Hyperion Essbase. Able to determine profitability by sales person, office, customer, and price point. Managed for 4 years. (NYT) News Costs. Determined news costs by each type of column for approximately 20-30 desks with different support areas (NYT) Product Profitability. Combined News, Advertising, and Fixed costs to determine profitability for over 40 sections, regional editions, and day of the week. Report requests were quarterly, annually, and weekly. Able to segregate Advertising and News components of products. Used Hyperion Essbase and Access with inputs from 12 subsidiary systems for over 7 years. (NYT) Vendor Contracts. Able to renegotiate vendor contract to be assure profitability. Evaluated vendor contracts to determine profit impact of rollouts to different areas. Recognized savings of $10 million over 5 years (NYT) Plant Capacity and Nationwide Expansion. Statistical forecasting and scenario analysis to determine capacity shortfalls and capital requirements for 12 plants for each day over 10 year period. Persuaded NYT management to avoid $100 million in unnecessary capital expenditures. Inventory Control. Given responsibility statistical modeling of short and long term needs for all materials for all plants. (NYT) Collective bargaining analysis. Extracted historical data, gathered benchmarks, ran scenarios and statistical models, and presented results to change work rules for 10 year contracts. Circulation Processes. Determined Activity Based Management System for each copy sold by region, city, and distribution method across 8 legal entities. System included over a dozen different distribution methods and several thousand carriers. It required calculation for other products carried by the different distribution systems. Used Hyperion Essbase and Access with inputs from over 10 systems from multiple legal entities. Used Actual costs but required defining of chain of services. Managed for over 3 years. (NYT) Employee Flexible Benefit Plan. Analyzed employee claims history and researched best practices to reduce employee benefits costs. (NYT) Accounts Payable. Developed programs to audit and reduce improper payments on PeopleSoft system. Recognized savings of over $60K in one department. Program used company wide. (NYT) |