John Veenker Email & Phone Number

Tulsa, Oklahoma Area

Create business models to reflect the metrics that help our business grow and run more efficiently. Responsible for Month End close and the calculations that support the reporting of the Sales and Margins of our products. Look at historical product and revenue trends to help develop targets for DSO, A/R, and Sales.Accomplishments:• Developed a new scorecard reflecting ten metrics for each of our 250 branches. These metrics help the branches keep their business in check so that it… Show more Create business models to reflect the metrics that help our business grow and run more efficiently. Responsible for Month End close and the calculations that support the reporting of the Sales and Margins of our products. Look at historical product and revenue trends to help develop targets for DSO, A/R, and Sales.Accomplishments:• Developed a new scorecard reflecting ten metrics for each of our 250 branches. These metrics help the branches keep their business in check so that it runs more efficiently.• Created a conversion formula that converts gas units from one phase of matter to another phase of matter which consist of weights, liquids, solids, and gases.• Responsible for monthly Key Metrics presentation covering A/R, Collections, DSO.• Develop and analyze the Churn Model in identifying certain areas in our business that may be contributing to our customers leaving and addressing those issues to decrease our Churn rate and improve our customer experience with Airgas.• Created 5 Power BI Dashboard reports that replaces 8 Excel reports that emphasizes monthly trends for Revenue, Costs, and Margins for all our products and customers.• Member of the Corporate Power BI Superuser Council. Show less

Tulsa, Oklahoma Area

Prepare historical reports and forecasts on revenues and costs for Local Voice (LV) Products. Created and refined business models to measure relevant metrics in the LV business. Prepare presentations on historical trends and forecasts for senior management. Prepare annual, quarterly, and monthly budgets and forecasts. Accomplishments:• (A/R) Developed and responsible for corporate Cash Forecast for rolling 12 months. Responsible for monthly DSO metric calculations from Business… Show more Prepare historical reports and forecasts on revenues and costs for Local Voice (LV) Products. Created and refined business models to measure relevant metrics in the LV business. Prepare presentations on historical trends and forecasts for senior management. Prepare annual, quarterly, and monthly budgets and forecasts. Accomplishments:• (A/R) Developed and responsible for corporate Cash Forecast for rolling 12 months. Responsible for monthly DSO metric calculations from Business Groups to individual collectors.• (A/R) Created and responsible for intensive weekly Business Group reports showing Aging A/R Metrics and Disputes. Also responsible for monthly forecast cash deposits.• Created a user friendly excel tool used for depicting varies types of revenue for each of our LV customers. This tool combined a couple of excel macro pull-down menus that would refresh for each product chosen. The LV products I was responsible for were Managed Modem, Local Inbound, Enhanced Local Service, and e911.• Develop monthly forecasts and explain variances of actuals to forecast and budget for the monthly management review. Lead discussion on Voice Finance presentation with Senior Management. Show less

Tulsa, Oklahoma Area

Responsibilities include monthly and quarterly incurred costs. Daily Cash Flow forecasting and analysis, including Yearly, by day, Cash Flow Plan. Detailed Profit and Loss analysis on a quarterly basis. Forecasting was out seven years due to contract accounting. Variances analysis of the various metrics in costs and revenues. These metrics would include Direct Labor, Indirect Labor, Materials, and Fringe Benefits, by Products.Accomplishments:• Designed and implemented an excel… Show more Responsibilities include monthly and quarterly incurred costs. Daily Cash Flow forecasting and analysis, including Yearly, by day, Cash Flow Plan. Detailed Profit and Loss analysis on a quarterly basis. Forecasting was out seven years due to contract accounting. Variances analysis of the various metrics in costs and revenues. These metrics would include Direct Labor, Indirect Labor, Materials, and Fringe Benefits, by Products.Accomplishments:• Designed and implemented an excel template to capture all metrics for incurred costs. What used to take six days to update quarterly results now takes only 1 day. • Developed the 2007 Daily Cash Flow Forecast model.• Developed a weekly forecasting tool used for Incurred Costs with MTD and YTD totals.• Developed a new system to forecast Direct Labor rates on a quarterly basis. This has saved the company approximately $40,000 from having to backfill this position. Show less

Tulsa, Oklahoma Area

Prepared historical reports and forecasts on revenues and costs. Created and refined business models to measure relevant metrics in the business. Prepared presentations on historical trends and forecasts for senior management. Prepared annual and monthly budgets and forecasts. Analyzed variances of actual annual and monthly performance versus plan, forecast, and prior years. Developed complex ad hoc database analyses of historical traffic and access costs for use in profitability studies… Show more Prepared historical reports and forecasts on revenues and costs. Created and refined business models to measure relevant metrics in the business. Prepared presentations on historical trends and forecasts for senior management. Prepared annual and monthly budgets and forecasts. Analyzed variances of actual annual and monthly performance versus plan, forecast, and prior years. Developed complex ad hoc database analyses of historical traffic and access costs for use in profitability studies, prospective customer acquisition, billing disputes and vendor selection. Managed ongoing and ad hoc assignments for a broad range of internal customers. Accomplishments:• Designed and implemented a billing solution for a portion of our voice wholesale customers, which increased our revenue by approximately $5.7M annually. • Developed and continued to update Voice Pricing to match or beat what the market is offering.• Created a weekly forecasting tool used for voice revenue that redirected company resources and enabled business unit to achieve monthly plan.• Performed Price & Quantity analysis that determined the causes of fluctuation in voice product revenues and enabled the business unit to make better forecasts and decisions.• Developed a Financial Profile report depicting current financial and forecasting information for each of our customers. • Developed Plan and Monthly forecasts for the $1.1 billion Voice business and explained variances of actuals for monthly management review. Lead discussion on Voice Finance presentation with Senior Management.• Provided Customer level forecasting and trending reports for the 4+ billion monthly MOUs. Show less

Bs, Management

Mba, Statistics, Finance, Operations Research