MDM Product Development and Benchmark Testing
The Client
The client is a leading provider of solid-state meters and advanced metering solutions for utilities - electricity, water, gas, collection/communication systems. The company provides enterprise-wide software platforms, project management, installation and consulting services to global utility clients.
Business Needs
- New features added in the product enhance the product's market value
- The product can be integrated seamlessly with multiple collection systems and billing systems
- The product can handle a huge volume of meter data and validate, edit and estimate the meter data segregating the meter data related business logic from the billing system
- Improve customer satisfaction
- Benchmark the scalability of the enterprise Meter Data Management product on SQL Server 2005 to handle a high volume of meter data import, export, validation, editing and estimation (5 million interval meters)
- Benchmark the throughput of the product
Our Solution
- Analysis, design and development of new features in the MDM product and testing of components
- Installation and configuration of the product on SQL Server 2005 and Oracle 10g
Phase 1
- Analysis and design of the stored procedures that handle a high volume of imports
- Development and testing of components
Phase 2
- Installation and configuration of the product on SQL Server 2005
- Data set-up for benchmark tests
- Execute benchmark tests for a high volume of imports