Case Study | Hi-Tech | Products and Platforms

90% faster access to financial insights with an AI-Powered FP&A Agent

Governed self-service access to 132 FP&A reports, delivering answers in seconds.

Download as PDF 7th September, 2026
element
element

At a glance

  • The client was Brillio’s internal Financial Planning & Analysis organization, decision-support engine for a global IT-services P&L across six legal entities: India, the United States, the United Kingdom and EU, Mexico, Canada and Romania.
  • The objective – to meet insight demand across the full reporting estate, so each persona could self-serve the packs they run, within access policy, instead of waiting on analyst extracts.
  • Finn Copilot, a multi-agent FP&A assistant on the ADAM platform, was embedded in BrilliAI and covering all 132 signed reports rather than a flash-and-P&L subset.
  • Finn binds to the same BDP Synapse tables that feed official packs, enforces fail-closed row and column access control, and answers only through a metric registry and parameterized queries keyed to signed report IDs.
  • The outcome? 80% of manual pack-assembly effort released, with the 132-report estate remaining self-serve for leaders.

46% of FP&A time absorbed before the analysis begins

FP&A is increasingly expected to operate as a real-time decision partner while still carrying manual report assembly. The 2025 FP&A Trends Survey reports that roughly 46% of FP&A time remains absorbed by data collection, reconciliation and preparation, while high-value insight and decision support has fallen to around 31%. Artificial intelligence adoption in FP&A rose from single digits in 2024 to roughly 41% to 47% in 2025, yet most of it remains spreadsheet-based assistants rather than governed, metric-contracted, role-based agents serving flash, P&L, people-productivity, forecast reconciliation and board packs from one platform.

Brillio’s own FP&A mirrored the pattern at operating-pack scale. The monthly cadence spans Revenue Flash, company, practice and geo P&L, people-productivity through Extended PP, forecast and sold-versus-delivered in Phase 2, and governance, MIP and board packs in Phase 3. Performance is cut across six verticals and six practices, down to account, project and location type, and under strict role-based access control to resource-level views, with country overlays for Romania state aid and Mexico foreign exchange.

Answers lived in disconnected Excel families, and a dedicated team of ten assembled and answered the estate across all six entities. Every cycle, different personas hunted different workbooks. Leaders repeated the same questions inside each pack, definitions of revenue, DM%, FTE, sold-versus-delivered and unbilled could drift across tools, and access to allocations and compensation data was inconsistently enforced. The constraint was insight demand across the whole estate, not a shortage of data.

Governed answers, not an ungoverned chat interface

Brillio undertook the transformation internally, using its own FP&A function as the reference implementation for ADAM Agentic AI in decision-support Finance. ADAM offered reusable, purpose-built agents, composable orchestration, contextual memory, explainability and human-in-the-loop policy governance, all mandatory when the payload is the company P&L, resource-level margin and board packs.

Ungoverned large-language-model interfaces were insufficient here. Finn binds to BDP Synapse presentation tables, the same governed data as the official packs, enforces Azure AD and policy-based roles with fail-closed row and column access control, and uses a metric registry and parameterized queries for signed report IDs rather than unconstrained SQL. Report owners sign off wave by wave, so the assistant cannot silently redefine a pack. Embedding Finn in BrilliAI places it inside the workflow employees already use. BDP on Azure Synapse remains the analytical system of record and NetSuite the ledger; formal reporting continues to live in Excel packs and Power BI.

One assistant across 132 signed reports

Authorized employees ask natural-language questions and receive governed answers with metric, period and scope cited, from the same platform used for formal reporting. The signed estate sits in one stakeholder catalogue: Revenue Flash (10 reports), P&L (36), Extended PP (26), Phase 2 (21) and Phase 3 (39).

Coverage runs from the Monday flash call to the board deck. The CFO office and vertical leads spot forecast misses by account; controllers and geo finance explain margin movement and watch SG&A; practice heads, delivery managers, talent acquisition and country finance recover below-threshold people margin and cut bill-days leakage; practice finance and the deal desk close CRM-to-flash-to-PP gaps and stop sold-versus-delivered leakage; board, CEO, CSO and MIP owners run governance, control travel and re-forecast the corporate P&L.

Users authenticate with Azure AD and ask in the language of their own pack. Answers export to Excel or PDF, voice input supports meeting use, and role-based access ensures two users asking the same question receive appropriately scoped results.

Fail-closed access on every resource-level answer

A query supervisor routes intent across the report families, and specialist tools serve each family through template-driven queries behind metric contracts. Access control enforcement is fail-closed, including on resource-level and compensation-sensitive reports. Query guardrails, answer audit and insight synthesis complete the pattern, with atomic agents under a single orchestrator.

The supporting estate: an enterprise web interface in BrilliAI; API services on Azure App Service; Azure OpenAI; LangGraph orchestration; session persistence; Synapse BDP for flash, allocations, people-productivity and performance walks; governed prompt and glossary storage; and policy-based access control. The intelligence layer covers pattern routing, the metric registry, parameterized queries keyed to signed report IDs, and answer validation.

Owner sign-off as the acceptance baseline

Deployment was a finance-led, phased program with report owners as stakeholders, not a data-platform replacement and not a flash-only release. Discovery inventoried the Excel and email packs in the monthly cycle, mapped personas to packs, reviewed the Synapse data foundation, and ran access control and personally identifiable information review with security, particularly on resource-level people-productivity and allocations.

FP&A owns the metric contracts, and waves were locked through formal owner sign-off. Delivery sequenced core Flash, P&L and walks first, then Extended PP, Phase 2 reconciliation and forecast, then Phase 3 governance packs, with the full estate in scope from program start and engineering waves released incrementally. Build covered domain pipelines per report family, BrilliAI integration, access administration, validated question sets per wave and an operational runbook. Validation ran by persona, with owner sign-off as the acceptance baseline.

The operating model changed in parallel: analysts moved from pack assembly to metric ownership, leaders consume self-serve reporting within access policy, and engineering cannot redefine core finance metrics without owner approval. Month-end and flash close windows were respected. Salesforce remains the system of record for commit and reconciliation, which Finn reconciles against rather than replaces.

Answers in seconds across all 132 signed reports

  • 80% of manual pack-assembly effort released, with 20% of prior headcount retained for governance
  • Approximately 13% of total assembly effort released per legal entity on an even split, governed by two shared approvers
  • Roughly 90% faster time-to-answer on signed report IDs, template-class answers returned in seconds rather than meeting-length spreadsheet hunts
  • Approximately 80% fewer “pull flash by vertical” requests from the CFO office and vertical leads
  • Share of team time on insight advancing past the 31% industry benchmark reported by the 2025 FP&A Trends Survey
  • 100% RBAC deny correctness on the audit sample for people-productivity and salary-sensitive reports
  • Adoption growth across the initial May to August 2026 rollout: interactions up 3,600%, sessions up 1,850% and active users up 250%
  • A reusable ADAM FP&A agent pattern, with the 132-report estate delivered in signed waves

Forward-looking thoughts and compelling stories

Life Sciences

Case Study

  • Life Sciences

A redesign for seamless integration of domain-specific clinical trials

A redesign for seamless integration of domain-specific clinical trials Read more  

Case Study

  • Retail and CPG

AI self-service transforms support for 3,500 employees

AI self-service transforms support for 3,500 employees Read more  
leveraging ai to automate merchant

Case Study

  • Banking and Financial Services

AI-Powered Cheque Processing Automation | Brillio Case Study

AI-Powered Cheque Processing Automation | Brillio Case Study Read more  
Case-Study_How-a-100B-Auto-Finance-Leader-Unlocked-Productivity-with-Microsoft-365-Copilot-in-Just-12-Weeks

Case Study

  • Banking and Financial Services

AutoFinance Provider Boosts Productivitywith MS 365 Copilot

AutoFinance Provider Boosts Productivitywith MS 365 Copilot Read more  

You define the north star, We pave the digital path

Let's connect   
elements
elements