← Back to Case StudiesEnterprise Digital Transformation

ONGC Consume IQ

Enterprise Infrastructure Consumption Intelligence & Automated Billing Platform

Consume IQ is an enterprise consumption intelligence platform designed to monitor IT infrastructure utilization across ONGC's Data Centre (DC) and Disaster Recovery (DR) environments. The platform collects infrastructure data through APIs, processes device-level consumption using business rules, consolidates consumption data, integrates committed capacity and pricing masters, and generates automated billing summaries and operational analytics.

Client

Oil & Natural Gas Corporation (ONGC)

Role

Business Analyst / Application Design

Duration

Multi-release Project

Industry

Oil & Gas

Enterprise Solution

Enterprise Infrastructure Consumption Intelligence & Automated Billing Platform

The Business Problem

Turning fragmented infrastructure data into a reliable business view.

ONGC required a centralized solution to monitor infrastructure consumption across distributed Data Centre and Disaster Recovery environments.

Consumption data originated from multiple infrastructure sources and required validation, device-level processing, capacity reconciliation and pricing integration before it could be used for billing.

The solution also needed controlled synchronization between DC and DR while keeping database communication within the organization's internal infrastructure.

Multiple Infrastructure Sources

Inconsistent Consumption Data

Manual Validation & Reconciliation

Complex Billing Calculation

Business Objectives

Centralize

Bring infrastructure consumption from multiple sources into one controlled platform.

Standardize

Apply consistent validation and device-level business rules to incoming data.

Measure

Track installed, requested, committed and utilized infrastructure capacity.

Automate

Convert validated consumption into billing-ready information using master data.

Synchronize

Maintain controlled data synchronization between Data Centre and Disaster Recovery environments.

End-to-End Solution

From infrastructure telemetry to billing intelligence.

Consume IQ establishes a structured processing pipeline that transforms raw infrastructure consumption into validated, consolidated and billing-ready business information.

01→

Source Systems

Infrastructure consumption data collected through APIs.

02→

Raw Data Ingestion

Incoming API data inserted into raw consumption tables.

03→

Device-Level Rules

Validation and business logic applied according to device and consumption category.

04→

Staging

Validated and processed records moved into the staging layer.

05→

Consumption Summary

Consumption across devices consolidated into a standardized summary.

06→

Master Integration

Committed capacity and pricing masters applied to consumption data.

Billing Summary

Final billing calculations and business-ready summaries generated.

Processing Logic

Raw Consumption→Device Rules→Validated Consumption→Capacity + Pricing→Billing Summary

Consume IQ product, workflow and DC/DR overview

Consume IQ — Product, Workflow & DC/DR Overview

Product Capabilities

Consumption Intelligence

Monitor infrastructure utilization across servers, storage and network components.

Device-Level Processing

Apply category-specific business rules and validation before consumption is consolidated.

Capacity Management

Compare actual utilization with installed, requested and committed capacity.

Cost & Billing

Integrate consumption with pricing and committed capacity masters to generate billing summaries.

Operational Analytics

Provide dashboards and reports for consumption, utilization and cost visibility.

DC / DR Synchronization

Synchronize critical application data between DC and DR using the internal enterprise network.

Product Experience

Consumption, utilization and cost — brought together.

The platform provides operational visibility across infrastructure utilization and translates consumption data into actionable cost and billing information.

Infrastructure Visibility

A centralized view of infrastructure consumption across servers, storage and network components.

Utilization Monitoring

Track actual utilization against installed, requested and committed infrastructure capacity.

Consumption Intelligence

Transform raw infrastructure measurements into standardized consumption information.

Billing Visibility

Connect validated consumption with pricing and committed capacity information.

Operational Reporting

Provide business and operational teams with consolidated information for monitoring and decision-making.

Controlled Data Processing

Maintain traceable movement from raw data through validation, staging and summary layers.

Secure DC / DR Architecture

Synchronization within the enterprise network.

Consume IQ required controlled synchronization between the Data Centre and Disaster Recovery environments.

Database synchronization was performed using internal replication IPs within the organization's local infrastructure, keeping the communication path within the controlled enterprise network.

Database communication was not directly exposed to the public internet.

Primary

Data Centre

Consume IQ Database

⇄Internal Replication
Network / IP

Recovery

Disaster Recovery

Consume IQ Database

Business Rules & Data Processing

Making raw infrastructure data business-ready.

A key part of the solution was translating technical infrastructure measurements into standardized business information that could support reporting and billing.

Collect infrastructure consumption through source APIs.

Insert incoming information into controlled raw data tables.

Validate records and apply device-specific business rules.

Move processed information into the staging layer.

Consolidate all device consumption into a standardized summary.

Reconcile consumption against committed capacity.

Apply applicable pricing master information.

Generate billing-ready summaries and operational reports.

My Role as Business Analyst

Discovery

✓Stakeholder workshops
✓Requirement gathering
✓Business process analysis
✓Requirement clarification

Solution Design

✓Functional requirements
✓Business rule definition
✓Data flow design
✓KPI definition

Delivery

✓Sprint planning
✓Backlog refinement
✓SQL/data validation
✓Requirement walkthroughs

UAT & Release

✓UAT coordination
✓Business validation
✓Defect clarification
✓Release support

BA Perspective

The most important part of Consume IQ wasn't simply building another monitoring dashboard. The challenge was translating infrastructure metrics into business-ready information.

I worked across the boundary between infrastructure teams, business stakeholders and application teams to understand how raw consumption should be interpreted, validated, consolidated and ultimately converted into billing information.

Key Design Considerations

Centralized Consumption Model

A standardized consumption model was established so data from different infrastructure sources could be brought into a consistent business view.

Business Rules Before Billing

Raw infrastructure measurements were not directly treated as billable data. Validation and device-level processing occurred before consolidation.

Master-Driven Billing

Pricing and committed capacity were maintained as controlled master data, allowing billing calculations to remain configurable and traceable.

Internal DC / DR Synchronization

Database synchronization was designed around the organization's internal network architecture, avoiding direct exposure of database communication to the public internet.

Business Outcomes

Centralized infrastructure consumption monitoring

Automated monthly billing calculation

Device-level consumption validation

Improved reporting accuracy

Reduced manual billing effort

Secure DC/DR data synchronization

Improved operational visibility

Consolidated business and infrastructure analytics

Technology & Skills

Business AnalysisApplication DesignDatabase DesignMySQLAPI IntegrationSQLAgileRequirement EngineeringDC/DR Replication

What I Learned

Data Quality Is a Business Problem

Infrastructure data quality directly affects billing, reporting and business decisions. Validation therefore needs to be treated as part of the business process, not only as a technical activity.

Business Rules Need to Be Explicit

Device-level calculations reinforced the importance of clearly documenting business rules so requirements, implementation and validation remain aligned.

Architecture Affects Business Outcomes

Working across DC and DR environments demonstrated how infrastructure architecture, synchronization and security constraints directly influence application requirements.

Automation Starts With Process Understanding

Effective automation begins by understanding the existing process, identifying decision points and standardizing business rules before automating them.

Great digital transformation begins with understanding the problem — and succeeds when people, process and technology move together.

Consume IQ

From infrastructure consumption to actionable business intelligence.

A multi-release enterprise transformation initiative combining business analysis, application design, data processing, automated billing and secure DC/DR synchronization.