Dave Vogel Email & Phone Number

Greater Milwaukee Area

Financial Analysis, Controller, Data Analysis, ForecastingDeployed and customized the accounting software for a construction company with $2 million in annual sales. Trained the office manager how to complete payroll, pay taxes, AR, AP, and job costing.I built a custom estimator for a construction client that produced a materials list, and developed a bid price based on variables the client could easily enter. This solution took into account hundreds of variables including… Show more Financial Analysis, Controller, Data Analysis, ForecastingDeployed and customized the accounting software for a construction company with $2 million in annual sales. Trained the office manager how to complete payroll, pay taxes, AR, AP, and job costing.I built a custom estimator for a construction client that produced a materials list, and developed a bid price based on variables the client could easily enter. This solution took into account hundreds of variables including dimensions, units, raw materials costs, labor, overhead costs, and profit margin to seamlessly develop a bid price. Show less

United States

Successfully supported an internal Sales compensation group of more than 200 sales reps, managers, and directors. Sales volume $6 Billion with a bonus volume of $20 million annually. Calculate Incentive Payments, Excel, MS Access, Visual Basic Development and Programming. Process and Continuous ImprovementConstructed numerous databases to calculate commission payments, manage incentive plans, and calculate bonusesDeveloped a data collection tool that delivered metrics… Show more Successfully supported an internal Sales compensation group of more than 200 sales reps, managers, and directors. Sales volume $6 Billion with a bonus volume of $20 million annually. Calculate Incentive Payments, Excel, MS Access, Visual Basic Development and Programming. Process and Continuous ImprovementConstructed numerous databases to calculate commission payments, manage incentive plans, and calculate bonusesDeveloped a data collection tool that delivered metrics (sales and retention) reducing time to completion by 90%Annual and period bonus maintenance and control of data for several database toolsTechnical support and administration. MS Access, VBA, SQL, ExcelManipulate source files to facilitate compatibility with developed toolsEnsure accuracy, efficiency, and reliability of data. Data scrubbingTechnical writing and documentation of completed databases and processes Show less

Fort Atkinson, Wi

• Technical resource responsible for the modification of existing reports in the ERP system, IFS• Developing new ad-hoc reports and implementing them into the ERP system• Developed several financial analysis tools utilizing expert Excel and MS Access skills• Responsible for data warehouse reporting, SAP query and relational database creation, reporting areas including sales, operations and finance

Waukesha, Wi.

• Supported assigned business units through performance of accounting functions such as month-end closing, reporting, analysis of operations and other financial analysis process-related activities• Developed, managed, and administered financial analysis tools• Expert Excel and MS Access level• Involved in ad-hoc reporting• Product line performance and profitability analyses, SAP BW• Prepared and facilitated annual and period budgeting, coordinated with product managers and… Show more • Supported assigned business units through performance of accounting functions such as month-end closing, reporting, analysis of operations and other financial analysis process-related activities• Developed, managed, and administered financial analysis tools• Expert Excel and MS Access level• Involved in ad-hoc reporting• Product line performance and profitability analyses, SAP BW• Prepared and facilitated annual and period budgeting, coordinated with product managers and senior management all aspects of budgeting for this $5 Billion global company• Prepared, presented, and delivered to senior and mid level management monthly analysis of performance to budget reporting and statistics• Recommended and implemented corrective action when necessary• Prepared journal entries and reconciled demand to supply, insured balance for efficient inventory, production, and backlog levels Show less

Brookfield, Wi

• Creating reporting, statistical analysis, budgeting and forecasting • Microsoft Access/Excel expert skill level• Developed and maintained a modeling tool for all budgeting and forecasting across company lines for this multinational company with $300 million plus in annual sales• Assisted all levels of management in areas of budgeting and forecast cycles• Monthly closing and reporting of corporate results and quarterly schedules related to tax• Developed and reported to… Show more • Creating reporting, statistical analysis, budgeting and forecasting • Microsoft Access/Excel expert skill level• Developed and maintained a modeling tool for all budgeting and forecasting across company lines for this multinational company with $300 million plus in annual sales• Assisted all levels of management in areas of budgeting and forecast cycles• Monthly closing and reporting of corporate results and quarterly schedules related to tax• Developed and reported to line managers’ monthly P&L statements, which tracked performance including actual vs. budget/forecast variance analysis• Performed ad-hoc reporting, troubleshooting, and analysis, as needed Show less

Master Of Business Administration - Mba

Certificate Of Completion, Computer Technology

Bachelor Of Business Administration - Bba