RONALD INSOGNA
Canandaigua, NY 14424
********@*****.***
SUMMARY OF QUALIFICATIONS
Manager with 12 years of corporate financial planning, analysis and, reporting experience. Expertise in budgets, forecasting, implementing planning systems and streamlining processes to increase productivity. Manage small finance departments to achieve ultimate corporate goals.
PROFESSIONAL EXPERIENCE
Constellation Wines, Canandaigua, NY 2010 – Present
Manager, Financial Planning & Analysis
Managed the annual SG&A budget and forecast which exceeded $240M spread across over 100 business units. Prepared and consolidated the monthly CEO report for the operating company to include commentary on monthly and year-to-date performance. Utilized Hyperion Financial Planning and Reporting (FPAR) to manage annual budget and prepare all financial analysis.
• Implemented a monthly re-forecast process to assess monthly and year-to-date results versus the annual budget. Ensured compliance with established annual budget.
• Created a report to manage a $14M+ T&E expenditure to realize a projected savings of $2M.
• Created a report to track and monitor cost centers for up 900 employees.
• Designed a report that trended the components of gross margin for all products for three years.
Penn Traffic, Syracuse, NY 2008-2010
Senior Manager, Financial Planning & Analysis
Managed the annual budget process that included over 140 cost centers with annual sales over $1B.
• Improved existing excel-based budget by implementing a web-based financial budgeting package that reduced consolidation time, minimized errors, and increased accountability and ownership.
• Led FP&A team to develop corporate strategic plan to divest the wholesale business and outsource corporate procurement. Realized an additional $74M in cash.
• Implemented a monthly forecast process to transition from Excel to the new web-based financial budgeting package. Significantly increased accuracy and improved stakeholder preparation and reporting of data.
• Created a weekly sales report to capture details and ranking for over 90 locations and tracking metrics versus budget. Identified issues for management team to support informed business decisions.
Paetec Communications, Rochester, NY 2006-2007
Manager, Financial Planning and Analysis
Assisted the VP of FP & A in all aspects of creating the annual corporate budget. Consolidated and loaded budget templates for 200+ departments into corporate budget system. Re-installed and designed the corporate budget system (Oracle Financial Analyzer OFA) to include creating hierarchy, calculations, manager financials and forecasts. Prepared annual budget board reports to include balance sheet, cash-flow statement and various schedules.
• Created a new market model to determine profitability of building a new switch. Included detailed revenue, COGS, SG&A and headcount analysis.
RONALD INSOGNA
Page 2
PROFESSIONAL EXPERIENCE (Continued)
Paetec Communications (Continued)
• Designed a capital valuation model that compared proposed capital expenditures for the annual budget. CAPEX was ranked based on cash flow, NPV and IRR to assist in budget approval process.
• Managed the monthly sales management reporting process which measured new monthly recurring revenue versus quota by sales representative and sales office.
US Datanet Corporation, Syracuse, NY 2002-2005
Director, Financial Planning and Analysis
Reported directly to CFO. Developed and implemented annual budget of $45M. Collaborated with senior executives and leadership team to mentor and coach in budget development. Included HR, IT, Sales, Marketing, Customer Service, Accounting and Network Services. Identified areas for cost improvement.
• Summarized monthly operating results versus budget for senior management and provided conclusions and recommendations. Generated detailed reports.
• Created presentations and documents for potential investors and boards to attract M&A opportunities.
• Analyzed and provided recommendations on potential merger and acquisition opportunities,
• Conducted financial analysis on a current product lines to identify areas of profitability based on profit margins. Created and presented a new detailed business model that was ultimately accepted and became the company’s key product. Resulted in increasing revenue by 250%.
• Created and maintained daily and monthly reports for senior management detailing product results and statistics.
• Prepared financial summary including detailed analytics, graphs and commentary for monthly financial package.
Additional experience includes: US Army. Specialist; Material Control and Accounting
EDUCATION / PROFESSIONAL DEVELOPMENT
Lemoyne College, Syracuse, NY
Coursework toward MBA
SUNY Institute of Technology, Marcy, NY
BS, Accounting; Presidents List, Deans List
Computer Skills: MS Office Suite (Word, Access, Excel, PowerPoint), Oracle (Financial Analyzer, Financials and Discoverer), Hyperion (Financial Planning & Reporting.)