Power and Utilities Organization Consolidate Multiple CRMs to Target New Markets


VNB assisted a Power and Utilities Organization Consolidate Multiple CRMs into One Dynamics 365 CE to Target New Markets

Customer Profile

Customer delivers electricity to more than five million consumers in eleven states. It ranks among the nation’s largest generators of electricity, owning 38,000 megawatts of generating capacity in the U.S. It owns the nation’s largest electricity transmission system, a 39,000-mile (63,000 km) network that includes 765-kilovolt ultra-high voltage transmission lines, more than all other U.S. transmission systems combined.

Customer Situation

The customer has a vast network of electricity distribution in the US. Now, the customer is targeting to launch gas services along with their existing electric services in residential and commercial markets. Customer wants to integrate gas within their existing electric CRM using Dynamics 365 CE. VNB Apps & Integration Team reviewed the task and architected a low code operations platform based on Microsoft Dynamics 365 CE. This meaningfully extended their existing investments in Microsoft Dynamics 365 to integrate gas-related entities, and workflows and to include automation in Dynamics CE.

VNB Solution

Following a thorough analysis of the client's needs, VNB suggested using existing Dynamics 365 CE integrated with power platform tools such as Power Automate and Power Apps which will help to automate the overall process. VNB integrated the Gas Canvas app into a model-driven app that requests a small amount of data from the sales representative before triggering Power Automate, which then sends back a prediction of usage for the next 12 months to Dynamics CE so the sales representative can use it as needed. Excel was initially used to complete this procedure. Much automation was made to save sales reps time, including managing volatile days, making SharePoint files, auto-filling data fields, and computing fields. For the customer, address validation was a big problem. When a sales representative inputs an incorrect address, a lot of trouble follows. Therefore, we suggested using Power Automate custom connector using Smarty Street API, which gets a record's address and cleans, validates, and sends the revised address to the fields. By doing this, we have decreased process-related human mistakes in the sales rep data collection process. We also proposed an idea to use PCF components that auto-completes the address when the user types in the address field. This was possible using the Bing API key which saves sales rep time reduces typing errors. The design was meticulously thought out so that the integration and operation of the electric and gas would be smooth. A sales rep can easily enter records for accounts, addresses, contacts, and other information into the same forms, and depending on the commodity selected—gas or electricity—all the forms and fields will transition to the appropriate supplier type when the sales representative enters record specifics in the user interface. This was possible using JavaScript and C# codes in the backend for validations, switching forms, automation, etc. The overall solution is a complete transformation in the way their contact center advocates and sales representatives interact with customer data.

Customer Benefits

  • 1. Improved Customer Service: Sales representatives can now easily access all the necessary information related to a customer's gas and electricity services in one place, which helps them to provide better customer service.
  • 2. Increased Efficiency and Customer Satisfaction: Sales representatives no longer have to switch between different systems or manually enter data, which saves time and reduces the chance of errors. This increased efficiency leads to better customer service and higher customer satisfaction.
  • 3. Reduced Costs: No longer need to invest in separate systems for gas and electric services, and the automation of various processes has reduced the need for manual labor.
  • 4. Better Analytics: Sales representatives can now easily track user usage patterns and make informed decisions about their services. This can lead to better pricing strategies and more targeted marketing campaigns.
  • 5. Scalability: The solution provided by VNB is scalable, which means that it can accommodate the organization's growth and future needs. The organization can easily add new services or expand into new markets without having to worry about the limitations of their CRM system.
  • 6. Improved Compliance: The integration of gas CRM with electric CRM improved the organization's compliance with regulatory requirements. They can now easily track and report on gas and electric usage, which helps them to comply with various regulations related to the energy industry.

Related Case Studies

dynamics 365 customer engagement plan solution vnb consulting

Migration From A Legacy CRM (Maximizer) To Dynamics 365 Services For A Fitness Brand In Canada

VNB assisted a Canadian fitness brand move from a legacy CRM (Maximizer) to Dynamics 365 to improve customer service.

dynamics 365 sales vs customer service vnb consulting

Upgrade From Dynamics CRM 2013 To Dynamics 365 Sales For A Manufacturer

VNB assisted a global manufacturer upgrade its Dynamics CRM 2013 to latest Dynamics 365 Sales to improve sales processes.