Case Study

Conversational AI Agent Turns Refinery Data into Instant Answers

A large energy company in South America had the data it needed inside its AWS Lakehouse, but getting answers out still meant building a custom dashboard or waiting for the technical team to run a query. Netrix Global built a Generative AI agent on Amazon Bedrock that lets refinery users ask questions in plain language and get accurate, visual answers in seconds, delivered through Microsoft Teams.

95%
POSITIVE USER FEEDBACK
100%
SQL QUERY ACCURACY
Seconds
FROM DAYS TO INSTANT DATA ACCESS
Teams
INTEGRATED DELIVERY VIA MICROSOFT TEAMS

The Client

The customer is a large, integrated private energy company headquartered in South America, operating across oil, gas, fuels, refining, chemicals, transportation, distribution, and renewable energy. With more than 21,000 direct and indirect employees and operations across multiple Latin American markets, the organization has significant regional scale and complex downstream analytics requirements.

The Challenge

The customer operates a Lakehouse data platform on AWS. Within it, the Downstream Business Line had built multiple data models calculating a wide range of business-critical KPIs across its units. The problem: making that modeled information accessible to business users required building a custom, ad-hoc dashboard for every individual use case. That meant significant investment indesign, development, and implementation time before any value could be extracted from the data.

This dashboard-per-use-case approach meant that unlocking insights was slow and resource-intensive. Business users without direct technical support often had to wait hours, sometimes days, for a dashboard to be built or for the technical team to run a query and interpret the results on their behalf. As the number of KPIs and use cases grew, this model of data access became a bottleneck rather than an enabler for decision-making.

The Solution

Netrix Global implemented a Generative AI conversational agent powered by Amazon Bedrock, connected directly to the client's existing Lakehouse data platform on AWS. The agent allows business users to query production, consumption, crude oil runs, materials profit and loss, planning metrics, and other refinery indicators entirely in natural language.

  • Business-aware reasoning: The agent reasons over each user's question, mapping it to the underlying business context, logic, and rules embedded in the data model, not just the raw schema.
  • Governed SQL generation and execution: It translates natural-language questions into SQL queries executed directly against the Lakehouse platform, returning accurate answers in the same vocabulary the business already uses.
  • Dynamic visualization: When useful, the agent generates charts on demand to enrich its responses, giving users visual context without any manual dashboard work.
  • Delivered through Microsoft Teams: To maximize adoption, Netrix integrated the agent as a Microsoft Teams bot, meeting users inside the collaboration tool they already use every day. AWS-native AI infrastructure paired with a Microsoft-native user experience.

The Implementation

Netrix Global delivered the full solution from architecture through go-live, engineering both the AI layer and the integrations that make it useful in practice.

  • Generative AI conversational agent built on Amazon Bedrock, connected to the client's existing AWS Lakehouse platform
  • Business context engineering: data modeling documentation, table and column descriptions, a business glossary, and response-rule design to ground the agent in real business logic
  • SQL generation and validation pipeline with retry logic to guarantee query accuracy
  • On-demand data visualization capability integrated into the agent's responses
  • Microsoft Teams bot integration for frictionless, native delivery to end users
  • Feedback instrumentation (like/dislike and comments) to monitor and continuously improve response quality

The result is a scalable, reusable way to unlock insight from the Lakehouse. Rather than building another dashboard, the client now has an agent that answers questions directly, with near-perfect query accuracy and response times measured in seconds.

The Results

Outcome AreaDeliveredUser Adoption & Feedback

  • 95% positive or neutral feedback: of 129 rated responses, 122 received a like or no negative feedback
  • Only 7 responses (5%) marked as dislike
  • Successful integration with Microsoft Teams for conversational, daily-workflow access

Speed & Accuracy

  • Data access time reduced from hours or days to seconds
  • 100% correct SQL query generation through table-context injection, strict generation rules, and built-in validation and retry logic
  • On-demand data visualization through natural-language requests

Data Access & Scale

  • 6 core Lakehouse tables connected, contextualized with modeling documentation, business glossary, and defined response rules
  • Eliminated the need to build a custom dashboard for every new use case
  • Scalable foundation for expanding to additional business lines and KPIs

The Transformation

BEFORE
AFTER
  • Custom dashboard required for every use case
  • Business users waited hours or days for answers
  • Technical team bottleneck for queries and interpretation
  • Insight locked inside the Lakehouse

  • Natural-language access to refinery data via AI agent
  • Answers delivered in seconds through Microsoft Teams
  • 100% SQL accuracy with built-in validation

Netrix Global + AWS Partnership Advantage

Netrix Global combines AWS Premier Tier expertise with end-to-end consulting and managed services to help organizations move from strategy through implementation and ongoing optimization.

  • Validated AWS expertise across Generative AI, Data & Analytics, Machine Learning, Migration & Modernization, DevOps, and Security.
  • AWS Managed Service Provider capabilities for end-to-end cloud operations, lifecycle management, and continuous optimization.
  • Participation in the AWS Well-Architected Partner Program to improve security, reliability, performance, operational excellence, and cost efficiency.
  • Service delivery experience spanning Amazon Connect and AWS Glue, supported by cloud, data, AI, application, security, and managed services teams.
  • Access to AWS programs and commercial pathways, including the Migration Acceleration Program, AWS Marketplace, and Consulting Partner Private Offers, subject to customer and project eligibility.
  • Global delivery coverage across the Americas, Europe, and India, supporting flexible, scalable, and cost-efficient execution.
AWS Premier Partner AWS Solution Provider Program AWS Managed Service Provider AWS Migration Competency Amazon Connect Service Delivery AWS Generative AI Competency AWS Public Sector Partner AWS Machine Learning Competency AWS DevOps Competency AWS Well-Architected Partner Program AWS Immersion Day AWS Data Competency AWS Partner Badge AWS 100 Certified
AWS
Artificial Intelligence
Cloud Platform
September 15, 2026

Turn Your Data Platform into a Conversation

Stop building dashboards for every question. Netrix Global builds AI agents that connect to your existing data platform and give your team instant, accurate answers in the tools they already use.