Governed AI Assisted FP&A Architecture Using Cloud Data Warehousing and Semantic SQL Views

This work presents a governed AI-assisted Financial Planning and Analysis (FP&A) architecture integrating cloud-native PostgreSQL warehousing, semantic SQL analytics views, and large language model-based natural language querying using AWS Bedrock. The framework explores how enterprise financial reporting workflows can become more scalable, accessible, and conversational through governed semantic layers and AI-assisted analytics pipelines. The architecture emphasizes reusable business logic, scalable reporting workflows, semantic governance, and AI-assisted enterprise decision support. The proposed system architecture integrates synthetic financial data generation, cloud-native warehousing using Neon PostgreSQL, semantic SQL analytics views, AWS Bedrock AI services, and a natural language interface for conversational enterprise financial analysis. Associated implementation resources and architecture artifacts are included alongside this preprint.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-05-18
DOI
https://doi.org/10.5281/zenodo.20263655
Primary Topic
Big Data and Business Intelligence
Type
preprint
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
preprint

Governed AI Assisted FP&A Architecture Using Cloud Data Warehousing and Semantic SQL Views

Adinath Kadam
Zenodo (CERN European Organization for Nuclear Research)
Big Data and Business Intelligence
preprint

Governed AI Assisted FP&A Architecture Using Cloud Data Warehousing and Semantic SQL Views

Adinath Kadam
preprint en

Abstract

This work presents a governed AI-assisted Financial Planning and Analysis (FP&A) architecture integrating cloud-native PostgreSQL warehousing, semantic SQL analytics views, and large language model-based natural language querying using AWS Bedrock. The framework explores how enterprise financial reporting workflows can become more scalable, accessible, and conversational through governed semantic layers and AI-assisted analytics pipelines. The architecture emphasizes reusable business logic, scalable reporting workflows, semantic governance, and AI-assisted enterprise decision support. The proposed system architecture integrates synthetic financial data generation, cloud-native warehousing using Neon PostgreSQL, semantic SQL analytics views, AWS Bedrock AI services, and a natural language interface for conversational enterprise financial analysis. Associated implementation resources and architecture artifacts are included alongside this preprint.

Zenodo (CERN European Organization for Nuclear Research)
Big Data and Business Intelligence
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.