Rodney Eberle Email & Phone Number

Warren, Mi

Hyperion Administration including rule management and report buildingConsolidation of financials of stores into regions and regions into corporate totalsAllocation of corporate expenses to store levels to maintain store profitability reportingConsolidation of corporate departments into corporate total reportingDetailed weekly reporting of sales and components (store traffic, close rate, average ticket, etc.)Creation and maintenance of MS Access Databases for sales reporting… Show more Hyperion Administration including rule management and report buildingConsolidation of financials of stores into regions and regions into corporate totalsAllocation of corporate expenses to store levels to maintain store profitability reportingConsolidation of corporate departments into corporate total reportingDetailed weekly reporting of sales and components (store traffic, close rate, average ticket, etc.)Creation and maintenance of MS Access Databases for sales reporting dataResearching spend on certain P&L lines or with certain vendors for variance explanation purposesProducing highly detailed revenue forecasts that include affects of holidays, marketing campaign changes, and external market forcesMonth end close support including accrual and journal entry preparationCreation of ad-hoc reporting for C-Suite to assist decision making and company direction processes Show less

Responsible for the budgeting and forecasting on an account with $28M in annual expensesResearch and produce monthly explanations of variances from budgets or forecastsGenerating weekly and monthly reports to ensure prompt invoice paymentSemimonthly reporting of PO inclusion on invoices for presentation to Sprint FinanceCreation of ad-hoc reporting to ensure proper application of expenses and financial performanceCreation and submission of monthly accrual and journal entries

Temporary assignment to assist company with year end close activity and reorganization of electronic filing systemProduced all Federal 1099 documents for company vendorsComplete reorganization of company file systemsCompiled and organized companies W-9 system for current vendors

As Regional Sr. Finance Analyst | Lenexa, KS | 2009-2012Subject matter expert for Midwest regional team regarding new customer and student retention forecastingSubject matter expert for Midwest regional team for all questions related to Excel and HyperionActed as business partner to assist campus and regional leadership in obtaining goals and objectivesIn depth leads to sales modeling and trendingProduced monthly income statement based financial forecastsPreparation of… Show more As Regional Sr. Finance Analyst | Lenexa, KS | 2009-2012Subject matter expert for Midwest regional team regarding new customer and student retention forecastingSubject matter expert for Midwest regional team for all questions related to Excel and HyperionActed as business partner to assist campus and regional leadership in obtaining goals and objectivesIn depth leads to sales modeling and trendingProduced monthly income statement based financial forecastsPreparation of regional and executive level operating plansComplete accounting oversight and budgetary control for six campusesAs Regional Analyst | Lenexa, KS | 2006-2009Monthly income statement variance analysisCreated several Macro and VBS Scripting based functions that significantly reduced the time and effort necessary to produce recurring reportsSupporting regional Vice-President and Directors team with recurring reporting, ad hoc reporting, and decision supportDetailed modeling and forecasting of new and existing students in support of executive level annual budgetary planAs Call Center Supervisor | Troy, MI | 2000-2006Managed team of five marketing coordinators to support Enrollment Managers with recurring reportingTrained Marketing Coordinators in excel skills necessary to provide recurring and ad hoc reports to Enrollment ManagersDeveloped and delivered training to all new Enrollment Advisors on proprietary lead management systemCreated and authored several standard operating procedures for marketing coordinators and enrollment advisersPartnered with Campus Director and Director of Enrollment to provide recurring reports, ad hoc analysis, and decision support Show less