Case Studies
Real projects, real results - Discover how we help businesses transform with technology
Data Collection Platform
Our Client
The Company operates in North America and has been the leading provider of strategic data and analytical solutions for the agriculture, crop protection and animal health industry for almost 30 years.
The Challenge
They were using and maintaining multiple legacy systems and custom applications to collect, cleanse and analyse sales, product, and customer data from thousands of sources across the US and Canada.
These systems consisted of hundreds of databases, over 20 web portals and countless SSIS packages, stored procedures and custom workflows which were maintained and operated by multiple teams in 3 different geographic locations.
Those systems were storing and processing redundant data and contained duplicated inefficient manual processes for transforming and cleansing incoming data resulting in costly data quality issues.
An enormous amount of time had to be spent to integrate, modify and support those systems. Onboarding new customers required creation of new databases, configuration changes in multiple systems and applications and the process was taking weeks. Initial historical data loads could take days.
Identified Challenges
- Multiple legacy systems
- Custom manual workflows
- Data quality issues
- Slow customer onboarding process
Our Solution
Our solution begins with clarifying business requirements, advising in software architecture and day to day development, on both, backend and frontend technologies. The key objective is keeping consistent agile processes.
The solution consists of a single data integration platform replacing all existing tools, websites and processes. It is based on 10+ scalable Microservices hosted on Azure Service Fabric cluster which allows asynchronous processing with multiple service instances making processes faster and efficient.
Results
File Processing Time
Decreased from days to minutes
Customer Onboarding
Reduced from weeks to days
Geo-Independent Tool
Aided expansion to multiple locations and industries faster
Reduced Costs
Lower maintenance and support costs, reduced resources for data extraction
Improved Data Quality
Enables sound business decisions and new market opportunities
ERP Purchase Requests Module
Overview
Our customer provides enterprise-scale ERP systems. Their business need was to build an additional module that would introduce new functionality into their current system.
This module's development was the first step in migrating their entire on-premise system to the cloud. Therefore, our goal was to design an architecture that would provide seamless communication between new and legacy system components and enable their migration to the cloud in the future.
The Challenge
Our customer provides enterprise-scale ERP systems. They wanted to start migrating their services to the cloud and asked us to help them build one of the modules in the ERP ecosystem.
Currently running on-premise legacy systems needed to cooperate with the new solution. There are many business customers, and their data needs to be separated.
The Solution
We implemented this new module as a separate multi-tenant and scalable service, integrated with old parts of the system, with easy further cloud migration of other parts of the system in mind.
The architecture ensures seamless communication between new cloud-based components and existing on-premise systems, while maintaining data isolation for different business customers.
Energy Assets - MHHS Project
Overview
Energy Assets Group is a leading utilities firm managing over 1.8 million assets across Britain. They specialize in innovative metering services, data analysis products, network construction and ownership solutions, and low carbon utilities.
Energy Assets collaborated with Clever Grapes to implement the Market-Wide Half-Hourly Settlement (MHHS) system, a national UK initiative targeting zero emissions by introducing accurate half-hourly energy consumption tracking.
The Challenge
Historically, energy meters provided infrequent readings, limiting billing accuracy and energy efficiency. The MHHS aims to transition to a more detailed energy consumption model, capturing data every half hour from potentially hundreds of thousands of meters daily.
Our Solution
The MHHS system comprises multiple services and processes:
- Metering Points (MPAN): Represents contractual points for energy readings, essential for data collection and billing
- Appointment Management: Initiates energy data collection processes for MPANs with various agreements and consent specifics
- Metering Service: Handles physical meter installations, maintenance, and direct data readings
- Flow Processor: Centralizes complex business logic, data aggregation, and handles missing data estimations
- Read Processor: Manages direct meter readings and sends data to the Flow Processor
- Adapters and Gateways: Integrate with external data sources (Connexo and Multidrive)
- DIP Adapter: Interfaces securely with the central data hub
- Service Bus & MassTransit: Advanced messaging for asynchronous data processing
Key Technical Implementations
- Estimation algorithms for missing half-hourly consumption data based on historical patterns
- Azure Service Bus for efficient messaging and scalable operations
- Extensive system monitoring and telemetry for ongoing process improvement
Results
Enhanced Accuracy
Achieved highly accurate half-hourly data tracking, critical for precise billing and optimal energy grid management
Operational Scalability
Built robust infrastructure capable of seamlessly scaling with growing number of meters and data points
Strategic Impact
Facilitated Energy Assets' commitment to national emissions targets and enhanced market competitiveness
Energy Assets - AMOPS Integration
The Challenge
Energy Assets needed to exchange operational and metering data with the central AMOPS system (owned by ESG). Historically, this was done manually, using Excel files and ad-hoc SQL scripts:
- Manual data entry led to frequent errors and delays
- Reports were generated and shared manually, requiring reformatting
- Each MOP message type had different logic, making consistency difficult
- Failed processes required reruns, blocking downstream reports
Our Solution
We built a Blazor-based integration platform to automate the end-to-end data exchange:
Automated Data Processing
- Data collected into standardized staging table
- Custom serializer transforms data into required AMOPS format
- Files automatically placed in output folders and transferred via FTP
Multiple MOP Types Support
- MOP 04: Daily meter events reported automatically
- MOP 02 & 03: Work order requests from AMOPS
- MOP 05-07: Additional event types being implemented
Error Handling & Validation
- Valid rows processed, invalid ones isolated for review
- Automatic email notifications for SQL or connectivity issues
- User-friendly web interface with real-time monitoring
Results
Time Savings
Previously manual process requiring Excel manipulation now fully automated
Error Reduction
Automatic validation and partial processing reduce system-wide failures
Scalability
New MOP message types can be added with minimal development effort
User Adoption
Business teams can trigger and monitor processes without technical intervention
Calisen (Lowri Beck) - Mobile App Optimization
Client & Challenge
Lowri Beck, a UK-based gas metering service provider, required improvements to their mobile application used by technicians for service order management.
Key challenges:
- Stabilizing the application with performance and reliability issues
- Developing new features to improve technician workflow
- Refactoring existing codebase to enhance efficiency
Our Solution
- Optimized Android-based mobile app built with Xamarin Forms
- Implemented real-time communication between mobile devices and backend
- Performed extensive refactoring to resolve performance bottlenecks
Results
Application Stability
Significantly increased stability and performance of the mobile application
Technician Efficiency
Enhanced field technician efficiency through new functionalities
Real-Time Data
Seamless real-time data exchange on Zebra mobile devices
Enercon - Wind Energy Platform
Client & Challenge
Enercon, Germany's leading wind turbine manufacturer and the third-largest globally, needed a developer to enhance data management, simulation, and automation for wind energy operations. The goal was to transition from desktop applications to web-based solutions to improve wind farm planning efficiency.
Our Solution
- Dedicated .NET Developer assigned to the project
- Developed data management platform for wind energy components
- Built tower engineering and optimization tools to streamline operations
Technology stack:
Results
Improved Data Accessibility
Streamlined data management and improved accessibility across teams
Faster Planning
Accelerated windmill model creation and optimization processes
Operational Efficiency
Increased overall operational efficiency within Enercon's workflow
Danish Pharmaceutical Company - Cloud Migration
Client & Challenge
A large Danish pharmaceutical company needed to migrate hundreds of on-premise applications to the cloud to improve infrastructure standardization, security, and authentication. The migration had to follow best CI/CD and Infrastructure as Code (IaC) practices.
Our Solution
- Chose Microsoft Azure as the cloud platform
- Used Bicep (Azure's domain-specific language) for IaC
- Implemented Azure DevOps & Git for version control and deployment
- Designed modular infrastructure for flexible and reusable components
- Ensured compliance with Azure Well-Architected Framework
Results
Standardized Deployment
Faster infrastructure deployment using pre-built modules and blueprints
Easy Adoption
Teams adopted solution without extensive training due to high standardization
Future-Ready
Scalable infrastructure with plans to expand module coverage
Construction Project Management Platform
The Challenge
A construction project management platform needed to modernize its monolithic architecture, which made development slow and risky.
- Monolithic system difficult to maintain and scale
- Code conflicts and long development cycles
- Lack of flexibility in implementing changes
Our Solution
- Transitioned from monolith to six independent microservices
- Developed backend using Azure Functions for cost-efficient scalability
- Implemented event-driven architecture with Azure Service Bus and Cosmos DB
- Built automated reporting, email notifications, and push notifications
Results
Faster Development
Independent microservices enabled faster, non-conflicting development cycles
System Flexibility
Seamless scaling and feature updates without breaking dependencies
Automated Workflows
Improved operational efficiency through automation
Ready to Transform Your Business?
Let's discuss how we can help you achieve similar results
Contact us