The Infosys Utilities Blog seeks to discuss and answer the industry’s burning Smart Grid questions through the commentary of the industry’s leading Smart Grid and Sustainability experts. This blogging community offers a rich source of fresh new ideas on the planning, design and implementation of solutions for the utility industry of tomorrow.

March 21, 2014

Need a frame work for up gradation of Oracle MDM V1.6 to MDM V2

Need a frame work for up gradation  of Oracle  MDM V1.6 to MDM V2

 

Overview : IT company need to come up with framework for oracle meter data management  upgrade to its new 2.0 version .This framework will provide utility  client a clear visibility into upgrade project ,include its scope, time and effort involved.

 

Meter data management : All the utilities ,whether electric ,gas or water deal with huge amount of data related to consumption of the underlying commodity .A meter data management system collects this information ,called meter data ,and perform the validation edit and estimation  operation, MDM stores and provides the data required for the downstream business processes e.g. Billing, settlement forecasting etc. .and therefore forms heart of the utility landscape. Oracle utilities MDM is one of the leading MDM systems and has large install -base across America, Europe and Asia pacific region.

 

Why need of upgrade: Oracle has released a new version of MDM, i.e. Oracle Utilities MDM 2.0 and therefore MDM v1.X is set to be phased out. Existing clients using MDM versions prior to 2.0 are looking to upgrade to the newer version. MDM V2.X offers plenty of benefits in terms of advanced functionality. It has a much easier navigation and user friendly GUI. MDM V2.X is completely different from V1.X as it is a completely new product all together. It has a totally new framework and would require a completely new skillset for upgrade and support. All in all it's a new re-implementation altogether if the customer decides to upgrade from the older versions to MDM 2.X.

Therefore the need for an upgrade framework which can effectively migrate maximum possible data as well as the configurations from the older version to the newer one is felt today by utilities.

 

       Migrating key set of data will reduce the time of implementation.

       Manual entry from old system to new, may create some data errors due to wrong entries resulting from Manual errors.

       It may be impossible to manually configure all the different sets of data manually within a short timeline.

       The effort involved may be too huge if this is performed manually.

There is a need of a tool that can be easily configured to the client system requirements which can handle migration of different categories of data and speed up the implementation. 

 

 

Up grating tool will be a breather for utility those are using Oracle MDM V1.6  

 

The objective is to develop a migration tool which can migrate data from different data categories in a reasonable time period. It should be easily customizable and maintainable considering that this could be used across multiple clients.  There are Administrative, Master and Transactional data categories, each having a different functional use and expected volume of data.

 

Ø  Administrative data is typically very low in volume but defines the setup of other application areas. Need to identify some key customizations in any typical MDM implementation which would require some admin data migration.

Ø  Master data includes entities such as Service Points and Meters that define physical and financial aspects of business operations. To support the integration of MDM V2 with CC&B, tools for "Initial Sync" migration of Master Data have already been built into MDM V2.

Ø  Transactional data from business operations, such as meter reads, is typically very high volume; therefore a direct to database approach has to be developed to minimize migration time.

 

October 29, 2013

Leverage consumption data to enhance rental house promotion

Another commercial use of smart meter data I can think of is in the rental websites for apartment and commercial buildings. Almost all house rental web sites provide detail description about house structure, amenities and ease of access to nearby facilities like school, hospital, freeways etc. House description includes floor plan, HVAC availability, thermostat, lighting that help the prospective tenant to choose best house/building space as per his needs. In addition to these house attributes, house owners and managers can place utility usage data and a minimum bill information on house/building advertisements. Utilities, through smart meters, are collecting and sharing the meter reads with their customers. Apartment owners can leverage analytical tools to determine seasonal minimum/average consumption and neighborhood comparison data, and utilize these metrics in advertising their house. Customers are getting sensitive about their utility bills and this information about site's basic electricity/water/gas cost will help them to make decisions on their budgetary planning. This consumption information's use in advertisement would also provide an opportunity for managers to highlight the savings in utility bills because of energy efficient techniques adopted like better house/building layout e.g. better natural lighting, low heat loss, solar protection, controlled ventilation and measures to reduce energy consumption by energy-efficient equipment installation, self-controlled switches etc. Including the usage data in house advertisements will also compel the owners to implement energy efficient measures on their houses and surrounding property to maintain the competitive edge. Along with adding these details with other house attributes, rental websites can add common search filters and side-comparison options on usage and billing data which will enhance their competitiveness with similar websites. Additional data like equipment age, maintenance schedule, replacement plan shall be helpful for long term occupants. These information may aid tenants to determine an approximate bill and may use it choosing energy supplier or site offering a cheaper tariff. Commercial tenants can plan their operations as per scheduled off-peak times to minimize consumptions during on-peak hours and hence saving on energy bill.

The current tenants must be convinced for sharing utility data ensuring them of guarding their privacy concern by anonymous, secure use and by inferring a basic bill cost without disclosing the actual figures. Moreover the house advertisement would use 'derived' minimum/average consumption and comparisons data on a particular type of house, withholding consumption pattern and end users details. Key to success of this idea is to develop the analytical tools that can extract meaningful value from historic usage and energy efficiency features of the house and present it in form that makes that house attractive for occupation.

Benefits for Apartment Owner -

  1. Showcase the energy/water/gas saving features in house and their impact on tenant's energy bill.
  2. Increase in tenant leads.
  3. Prominent listing in "Consumption" based search on rental website.
  4. Appear in rental website promotions for new attribute.

Benefits for Tenants -

  1. Would-be renters get additional attribute in form of approximate average utility bill to decide on the apartment.
  2. Helps the tenants to plan for buying electrical equipment.
  3. Helps the commercial house tenants in planning operational cost.

Benefits for Renting portals -

  1. This house usage information with other comparison analytical tools would attract more visitors to their site.
  2. It provides advantage over competitors and increases portals popularity.
  3. With data in hand, house owners will try to utilize these portal features for their house advertisement and hence contributing to portals revenue.

September 4, 2013

Using 4G technology in Smart Grid

Smart grid initiatives are helping electric utilities to improve operational efficiency, improve power reliability, data analytics, decision making and much more. Communication plays a key role to achieve true value out of smart grid applications. With the deployment of smart meter a huge amount of bi directional data is flowing across the grid network and handling of this data is a real challenge for utilities. For this utilities are focusing on new and innovative technologies that can help them in developing a fast, robust and secure communication infrastructure so that network and data traffic can be managed effectively.

Smart grid applications require fast, effective, secure and reliable communication technology for real time bi directional data transfer across the network. Utilities do not want transmission of smart grid data coming from various sources on such a network that is shared by other customers. On the other side fourth generation wireless technologies provides better control and security unlike other technologies like GSM/GPRS, Wi-fi, RF etc. it also provides real time application support including voice and video with two way communications.  With 4G it is quick to find and restore outages remotely hence increases grid reliability.

Utilities will have following advantages if they choose 4G:

·         Fast and reliable network with advance traffic management tools which are under control of utility which is under control of service providers while using other networks.

·         Low latency due to which real time application support including video and voice data.

·         Provides support to applications like mobile workforce, SCADA, demand response and HAN which requires real time data.

·         Highly secure network allows utility to rest assure about confidentiality.

·         Availability of Wide range of frequency spectrum.

·         Backhaul connectivity with other networks

However 4G being a new technology also has some drawbacks like it is highly capital intensive and infrastructure setup cost is very high. Technical expertise is needed to setup and maintain the network if utility choose to deploy its own network. If we consider the long term vision then using 4G will result in huge ROI.

 

June 19, 2013

Are water utilities actively engaging their customers?

 Is it innovative for a Utility to have active customer engagement? I think the answer historically is that it would be.

However, there have been significant changes to customer perception and expectations on how they would want to be engaged. A key factor driving change in the water utility sector is the change in the regulatory environment - specifically the penalties and incentives for customer service captured in the Service Incentive Mechanism (SIM). Another regulatory impact is the move towards 'retail' separation which is starting with non-domestic customers in the form of ability to select supply contracts.

Today, through our Water UK partnership, we are participating at their Innovation Hub day focused on Active Customer Engagement - many executives and managers from key UK water companies will be there along with other interested and influential parties such as CC Water, regulators etc. (http://www.water.org.uk/events/view_event.php?eventid=73&setstyle=&dateid=45)

I will be posting updates later based upon discussions held throughout the day.

Business Process Optimization in Asset Management

Enterprise Asset Management (EAM) focuses on optimizing life cycle of an Asset such as plant equipment, facilities etc. as used in production or delivery of services. Assets in EAM are defined as those physically traceable components that have significant criticality in the business processes - especially for asset intensive organizations. With more and more focus on Asset reliability and return on investment, the Asset management processes are becoming critical for every asset intensive organization. They help in delivering more value to the business and its customers and create an upper edge in the competition while satisfying all regulatory and statutory needs. These reasons collectively positions Asset management program a strong candidate when it comes to picking entities for a business process optimization program

Continue reading "Business Process Optimization in Asset Management" »

June 12, 2013

Winning with Volt-VARs - How to do it the smart way?

Winning with Volt-VARs - How to do it the smart way?

 

I've written about the benefits of volt-VAR optimization in my previous blog. An important question that has to be answered by the utilities which are looking for implementation of such a program is "How do we do it?"

Utilities looking for dynamic reactive power and voltage optimization, if it is a new network expansion, should initially consider revisiting the design of their power distribution networks. It should be ensured that the network has adequate transformer sizes for reducing losses, minimal feeder splice points and optimal conductor sizes enabling efficient flow of power. This should ensure reduced energy losses and reactive power losses from physical assets point of view without any major capital investments.

As a next step for the new networks  (and also for the existing power networks) , utilities should consider conducting a complete engineering analysis using network analysis software to ensure optimal sizing, quantity, and placement of capacitors and regulating devices that will optimize voltage management and VARs across individual feeders of the distribution area. With the advanced engineering analysis software available these days, it is possible even to determine the optimal step sizes of the compensation devices.

After choosing the best configuration from engineering analysis, the compensation devices with intelligent controls and communications can be installed onto the system with interface to central analytical software to decide the capacitor control device and distributed voltage regulator settings throughout the network based on the dynamic load data.

Installing such an advanced Volt-VAR control system can help mitigating the impact of the penetration of renewables on the grid. Especially, plug-in electric vehicles and photovoltaic penetration can dramatically impact the system's voltage profile, thus affecting the quality of service.

Another key factor is to have analytics applications for sensing when high penetration renewables come online. This feature of renewable energy forecast will give insight into what's happening with the bi-directional power flow and will help in arriving at more accurate estimates of the volt/var compensation devices required for the system.

The accuracy of sensing data is also significant since voltage is normally managed within much stringent norms. Adequate Communication bandwidth and low network latency are also vital factors that utilities should ensure for obtaining quality data in near real-time for accurate control decisions.

Please share your views on the possible ways and necessary steps to implement smart volt/var systems in the grid.

 

May 22, 2013

UK Parliament All Party Parliamentary Water Group Innovation event May 2013

Yesterday I went to the UK Government All Party Parliamentary Water Group evening meeting on securing sustainable water resources for the future. This short event was chaired by Nia Griffith, Member of Parliament for Llanelli, with talks by Dr Dan Osborn, NERC (National Environment Research Council) and RCUK (Research Councils UK) lead at Living with Environmental Change and Chris Phillips, Chief Marketing Officer, i2O Water.

Dr Osborn talked about the World Economic Forum identifying water supply crises as one of the largest global risks, thus with many new challenges and markets appearing: this from a global market of £500 billion, and about £120 trillion in assets. UK research bodies had budgets of £120 million in this area, with for example Councils spending £13 million on drought research.

Mr Phillips described the world wide success i2O were achieving with their innovative pressure management solution and their close links to research (they are based in Southampton Science Park). He felt that, if properly established, UK water industry competition could lead to a boost in research funding.

A number of interesting discussions were then held. A large number felt that the cyclic, and sometimes short term, nature of work in the UK water industry made innovation difficult for the supply chain, as with tight margins and fluctuating workloads such investment was not feasible. Many felt that the UK needed to increase innovation, and learn from other countries, however generally it was perceived that UK expertise was still valued. Others highlighted the achievements of SMEs in the world water market, indeed UK SMEs, as well as contractors and consultants, were quite successful in the other countries. One gap identified was that the UK was not always as successful in turning research into effective solutions for the market, and more government and industry support was needed in this area. The only negative note was when Nia Griffiths asked if anyone from the utility companies had any comments: no-one from a utility had attended the event!

The official event concluded promptly as Nia Griffiths had to vote, however informal discussion carried on for some time. Overall I found the event very helpful, and believe such meetings should be encouraged in the industry.

May 20, 2013

Competition in the Water Industry part 5 (final in series)

To successfully manage the issues I described in my previous blogs will require companies selling water to:

  • Deliver accurate and timely bills at frequencies demanded by customers;
  • Ensure customers feel in charge of their own information;
  • Engage with customers effectively using multi-channel communication.

Many customers are familiar with and use IT based communications, mobile, internet, social media, etc., however others prefer more 'traditional' methods, such as phone or letter. All must be seamlessly integrated to ensure customer satisfaction. Effective systems will also help to reduce costs. Undoubtedly smart meters will help, but who should pay for these?

Infrastructure providers must successfully:

  • Reduce service impacts year on year;
  • Manage the risk of ageing assets;
  • Reduce running costs whilst continuing to enhance to environment;
  • Continually demonstrate the value they provide.

For all of the above issues the companies who effectively gather and mange information (about assets, customers, environment, etc.) will be best placed to offer value, and hence have sustainable success in a competitive water sector.

May 17, 2013

Competition in the Water Industry part 4

The potential benefits of competition change in the UK water industry are similar to those achieved in the Energy sector (although that has not been without some issues), in that customers will be given choice between suppliers, and prices should be reduced. Customer services should also be improved, as that will be another way to attract customers.

There are however a few issues and challenges. For many commercial and practical reasons (such as installation costs and practicalities) any property is only ever likely to have one set of supply pipes and sewerage, and related treatment and pumping facilities. Thus the customer will have no choice as to who provides their infrastructure, even if the incumbent is sold, or sells off the area as an inset. The cost per property for that infrastructure will be variable, depending on location factors such as:

  • The availability and treatment cost of water;
  • The environmental constraints on discharge;
  • Geographical factors (e.g. terrain, population density);
  • The metres of pipe required to service each property (usually more in rural areas);
  • The age and condition of the existing infrastructure.

The competition regulation thus needs to be carefully constructed to ensure such issues do not create unreasonable cost differences between areas.

I will discuss how companies could achieve success in my final blog.

Competition in the Water Industry part 3

In my last 'competition' blog I looked at some of the proposals in the UK. I will now consider what these may mean to industry and customers.

'Vertical separation' (meaning the accounting and often business separation of parts of a company's business) will mean in the case of a water company that elements such as customer services and billing could be open to full competition. In this regard it would be similar to the Energy market. At present the proposals for competition are limited to commercial customers (all supplied above a yet to be finalised daily volume).  Insets would be fully open for any customers with any supplier purchasing water and sewerage services from the incumbent Water Company at a common price, including the commercial arm of that incumbent Water Company.

This may lead to a number of significant changes, some of which are already being seen in practice:

  • Large national customers, such as supermarkets, may choose to use one supplier only;
  • Water Companies will seek to win commercial customers in other areas;
  • Other companies (e.g. other utilities, supermarkets, etc.) may enter the market.

Business (and potentially in the future domestic) customers will thus be able to choose their supplier, and this should drive down prices. However as well as benefits, there are issues and challenges with this change, that I will discuss in future blogs.