Dan Butcher Email & Phone Number

Pottstown, Pa, Us

Philadelphia, Pa

Provided operational insights and data analytics driving Continuous Improvement for Tier 1 KPI CAIDI on track for the first time in over five years. Innovated, designed, and implemented the Storm Live Interactive and CAIDI Analytics Platform integrating data from key systems to visualize key performance indicators driving operational decisions. Built the bi-weekly Scorecard to track performance by region and job type providing field supervisors timely feedback keeping performance on track. Placed in top three at Exelon’s Innovation Expo three out of four years with Business Intelligence solutions for Storm Restoration and Outage Validation Bot replacing manually intensive processes. Created two new operation metrics to measure effectiveness relative to expectations based on job complexity and efficiency. Primary tools included Qlik Sense, Microsoft Excel, Power BI, Agile Outsourcing, SQL and Power Point.

Philadelphia, Pa

Forecast Bad Debt, Supplier Billings, Accounts Receivable, Net Charge-offs and Reserve monthly and 5-year plan annually for $4 billion business. Won second place award at 2017 Exelon Innovation Expo with Storm Live Interactive Qlik Dashboard and lead implementation to improve storm response metrics CAIDI, SAIFI, ETR. Perform Bad Debt variance analysis and present to Senior Management monthly. Create and distribute Credit and Collections Performance Indicators deck monthly. Work closely with FP&A and Revenue Accounting to ensure a good working relationship, quality work and healthy communication. Performed Regression analysis and implemented findings to improve Accounts Receivable, Call Center Call Volume and Supplier Billings forecasting accuracy. Developed two innovative analyses on complex phenomenon in Bad Debt Reserve due to abnormal weather patterns to provide perspective and visibility to upper management. Primary tools included Microsoft Excel, SQL, Access, Visual Basic, Hyperion, Qlikview and Power Point.

: Accountable directly to CEO, CFO, Controller and Regional VPs for strategic negotiations for potential acquisitions, Greenfields, and negotiating deals with vendors by leveraging buying power for 70 location, $400M distribution company. Created and developed sophisticated Price Volume Mix model at the lowest level of detail which was used to drive margins higher. Created downturn productivity analysis, generated cost cutting initiatives and negotiated deals with vendors which saved over $750K annually to bottom line. Handled all stock transactions in sale of $400M business with over 450 shareholders. Modeled and analyzed ten potential acquisitions with one completed through due diligence and integration into SPI. Modeled eight Greenfield opportunities implementing four. Managed 250 vehicle fleet which expanded to 700 after the sale of SPI including tractors, trailers, boom trucks, flatbeds with piggy back, box trucks, small trucks and forklifts in all aspects including specifications, ordering, graphics, licensing, fuel efficiency, and safety. Managed all cell phones negotiating deals worth over $100K in annual savings. Performed many monthly reports to management including a “book” of all reports from inventory turns to direct customer profitability to HR. Primary tools included Microsoft Excel, Access, Visual Basic, InfoPath and Power Point.

Lead a team of eight volunteers and over sixty teenagers to run weekly activities, monthly events and annual trips. Organized and lead a team of fifty-five volunteers to replace five rooftops in a week in Mississippi to help recover from Hurricane Katrina. Raised funds to provide all the materials and labor at no cost to the home owners. Developed and managed budget for all activities. Served on the board.

Translated business cases to measured benefit to value deal between AT&T and Accenture using financial models. Analyzed data to uncover a $60 million error. Performed ad hoc regression analysis and found that a leading indicator for lock box payments is autoregressive to A/R balance with a one-month lag. Created consumer pricing models, ad hoc reports and scenario planning analysis. Primary tools included Microsoft Excel, Access, Visual Basic and Power Point.

Managed Affiliate expenses worldwide for the Product Realization division. Created the quarterly forecasts and annual plans for internal and external expenses. Reported monthly detailed results and reports of actuals versus quarterly forecasts and plans. Posted journal entries to SAP monthly. Created tool to encourage proper coding of invoices and distributed via an eRoom. Wrote business requirements and implemented streamlined processes. Primary tools included Microsoft Excel, Access, Visual Basic, Project and PowerPoint. Investigated Cognos, Hyperion, etc.

Dallas, Tx, Us

Forecasted the $7 Billion AT&T Data Services Business volumes and revenue which directly impacted AT&T guidance to Wall Street on a quarterly basis and helped to deliver on financial commitments. Integrated detailed results into the planning process to facilitate a more accurate and consistent revenue view of AT&T Data Services. Created monthly current-year revenue and volume outlooks and 5-year plans. Forecasted using linear, logarithmic, and quadratic regression methods as well as accounting for normalizations, seasonality, and leading indicators. Primary tools included Microsoft Excel with emphasis on Pivot Tables, Microsoft Access, Visual Basic, and Microsoft PowerPoint.

Dallas, Tx, Us

Modeled and analyzed the AT&T One Rate 7 Cents offer which has been a huge success. Created complicated ad hoc models under extremely short deadlines to analyze the impacts of new consumer long distance pricing actions. Analyzed the impacts of Sprint and MCI offers on AT&T, and provided analyses to executives on our strategic responses to our competitors’ pricing actions. Used Excel extensively to create these dynamic, efficient models. Served as a Microsoft Access expert for our team for databases that we used.

San Francisco, Ca, Us

Created business and technical content for the new AutoCAD compatible diagramming software solution, Actrix, using Visual Basic code. Trained several partners around the world on how to create intelligent ActiveShapes content for Actrix. On this leading-edge software design team, I was responsible for some of the most complicated content to hit the technical diagramming industry.

Dallas, Tx, Us

Produced business plans, income statements, strategic information and economic analyses for local connectivity to AT&T executive decision-makers. Created 10-year forecasting models for local connectivity architectures in Excel and VBA. Designed, stabilized, and tested a sophisticated state-of-the-art economic model in Access and Visual Basic which dynamically optimizes the local connectivity architectures for all 60,000 locations. Performed sensitivity analyses of critical variables to evaluate strategy, deals and partnerships to aggressively pursue entry into the local telecom industry. Promoted to manager after 5 months, managed 2 people, and led a team of 6 others.

Dallas, Tx, Us

Performed release, migration, and special project coordination roles for the installation of the Low and Middle Markets Business Long Distance customers billing system for 13 out of 21 projects as a member of the Installation group. Promoted to associate member after 13 months and given the role of project leader after 3 years in this organization. Used legacy mainframe systems and SQL. Led a team of 5 people

Ms Operations/Supply Chain Management And Logistics, Operations Management And Supervision

Bachelor Of Science - Bs, Computational Mathematics

Bachelor Of Science - Bs, Computational Mathematics