William Marr Email and Phone Number

Manages the review and confirmation of trades, ensuring the portfolio is accurate and up to date.Creates, manages, and leverages reports that analyze and help maintain proper risk margins.Builds ad hoc proof of concept reports to establish blueprints and confirm proper functionality.

Manages monthly pricing process for four ISO's while interacting with Supply, Finance, Operations and Sales to develop pricing recommendations for new and existing customer plans.Leverages internal systems and models to develop financial forecasts which are used to support business decisions.Generates monthly PowerBI reports highlighting monthly market movement, cost driving factors, as well as providing suggested sales strategies.Generates and maintains a daily pricing matrix for Commercial sales.Works with Settlements to quality-check forecasts and updates internal models to ensure accurate components.

Upon acquisition of Crius Energy by Vistra EnergyAided in creation of new product platform to incorporate multi-channel multi-brand landscape.Sorted through thousands of products and helped highlight key product information to generate default products needingto migrate to new platform.Analyzed and assessed new product template model.Ensured accuracy of product data for 17,000 active customers in billing system with product data in back-end SQL tables.

Nov 2017 - Sep 2018 - Enrollments Analyst I: Communicating with utilities via billing system software to ensure customers received correct rate plan enrollments, drops, and service location switches. Loading large batches of customer enrollment data to initiate customer enrollments.Sep 2018 - Dec 2018 - Promotion - Enrollments Analyst II: Analyzing monthly Large Commercial enrollments to ensure proper and timely service start dates. Compiled comparative data for all commercial enrollments in a dynamic report to track timeliness/accuracy and develop more efficient methods.Dec 2018 - 2020 - Transition - Rates Analyst II: Created and maintained monthly price changes for every brand and utility, involving Excel validations between multiple data sets.Analyzed and remediated daily utility-rejected customer enrollment/renewal rate changes.Maintained back-end table renewal mapping to ensure customers would roll over onto correct rates at end of term.Ensured every commercial deal with customized price was correctly implemented with utility.