Naveen Jujaray | Microsoft Fabric & BI Systems Architect

Hi, I'm Naveen Jujaray.

"Data isn't just numbers. It's human decisions transformed into meaningful outcomes."I engineer pipelines, semantic schemas, and automated AI agents driving true enterprise decisions.

Scroll to read
01 / Professional Timeline

My Journey Through Data

A linear progression from building localized visualizations to scaling global fabric migrations and governance architectures.

Chapter 1

Finding the Power of Analytics & Logic Modelling

Early Evolution

My career kicked off with a foundational fascination: how data pathways influence human decision-making. Studying computer engineering led me deeper into model orchestration, relational query compilation, and mapping star-schemas which laid the groundwork for enterprise analytics architectures.

Chapter 2

Transforming Higher Education Analytics

Brillio LLC | June 2021 – July 2024

Partnering with Ruffalo Noel Levitz (RNL), I re-engineered student enrollment forecasting pipelines. I took fragmented manual processes and deployed a highly optimized, single-template Power BI Premium dataset supporting 110+ university clients.

Star-Schema ModelDynamic RLSAdvanced DAX
35% LessManual Reporting Time
Chapter 3

Scaling Enterprise Analytics Support at Microsoft

Sonata Software | Oct 2024 – Jan 2025

Ensured operational high-availability across global reporting domains inside Microsoft's core ecosystems. Supporting large-scale BI infrastructure, I integrated Microsoft Copilot Studio to allow ad-hoc conversational data queries, optimized Star-schema relationships, and handled Composite models to bypass traditional memory lags.

Copilot StudioComposite ModelsVertiPaq Audit
15% BoostDashboard Loading Speed
Chapter 4

Leading Clinical Intelligence and Patient Health AI

Sonata Software | Feb 2025 – Aug 2025

Acted as BI Team Lead for the pharmaceutical leader Kyowa Kirin to deliver their unified European Clinical Trial Management System. I engineered strict GDPR/EMA isolation security, managed high-performance star models mapping clinical Dataverse staging, and integrated Microsoft Data Activator for proactive exception alerts.

Medallion ArchitectureData ActivatorGDPR Isolation
10+ CTMSDashboards Delivered
Chapter 5

Reimagining Legacy ETL Migration & Compiling Code

Kanerika Inc. | Aug 2025 – Oct 2025

Within the FLIP product engineering module, we developed an automated pipeline to migrate complex Informatica PowerCenter XML pipelines into clean Microsoft Fabric. I co-designed compilers converting proprietary XML schema elements into functional, performant M Query scripts and optimized SQL blocks.

XML CompilerPower Query M CodesFabric REST APIs
40% LessManual Re-creation Labor
Chapter 6

Automating Governance & Continuous Integration

Koch Industries (Consultant) | Mar 2026 – Apr 2026

Revolutionized Power BI governance at Molex (Koch Industries). Using Python, the Fabric CLI, and PBIP metadata, we engineered scripts programmatically updating bookmarks and filters, integrating with Git. We built Snowflake-to-Power BI cross-reconciliation logic using PySpark and SemPy (Semantic Link) to detect drift on 11 critical KPIs automatically.

Python ScriptingSemantic LinkCI/CD Git Flow
180+ReportsAutomated programmatically
Chapter 7

Next-Gen Analytics & Intelligent Orchestration

PUMA Group (via Texplorers) | Jun 2026 – Present

Building next-generation solutions with Microsoft Fabric, Power BI, and Databricks. Designing and implementing MCP (Model Context Protocol) Servers, custom AI integrations, autonomous Data Agents, and Operational Agents. Crafting interactive Fabric Apps to drive streamlined business automation and visual intelligence.

Microsoft FabricPower BI & DatabricksMCP Servers & AI AgentsFabric Apps
AutonomousData & Operational Agents
02 / Executive Indicators

Measurable Enterprise Impact

I focus on quantitative business outcomes—saving thousands of engineering hours and deploying highly performant datasets.

0+Universities EnabledDynamic tenant database integration on unified reporting templates
0+Reports AutomatedProgrammatic bookmark adjustments mapped to version control using Git
0%Manual Effort SavedOverhauled manual ad-hoc reporting pipelines into structured star-schemas
0 GlobalEnterprise LandscapesDelivered custom architectures across healthcare, higher-ed, and heavy manufacturing
Microsoft Fabric & AIInnovative DeliveryProgrammatically connected Copilot Studio querying models and alert notifications via Data Activator
Executive Endorsements

Client & Partner Testimonials

Direct insights from enterprise platform directors, clinical operations leads, and intelligence managers who have collaborated with me.

03 / Technology Universe

Enterprise Skills Constellation

I don't just collect certifications. I understand how specific features resolve processing locks, accelerate queries, and secure regulatory structures.

Business Intelligence & Visualization

Microsoft Fabric Ecosystem

AI, Agents & Automation

Scripting & Data Languages

Skill Diagnostic
Architect / Elite

Microsoft Fabric

End-to-end cloud-native orchestration unifying OneLake, Lakehouse/Warehouse staging layers, Fabric CLI, and SemPy semantic integrations for 100% data consistency.
Hover/Click other items to audit Naveen's capabilities in specific domains of data engineering, BI modeling, and orchestrating analytical cloud engines.
04 / In-Depth Engineering Narratives

Featured Case Studies

Explore in-depth technical breakdowns of system architectures, transformation mappings, and business outcomes engineered across global client projects.

June 2021 – July 2024Brillio LLC

Ruffalo Noel Levitz (RNL)

Overhauling student lifecycle analytics for 110+ universities with a unified semantic layer and dynamic multi-tenancy.

Power BI PremiumSQL Server Star SchemaAdvanced DAXPower Query (M)
2 min read
Reduced manual reporting overhead by 35% across all institutional clients.
Architected a single dynamic Row-Level Security (RLS) template serving 110+ university tenants.
Role: Power BI DeveloperRead Case Study
October 2024 – January 2025Sonata Software Limited

Microsoft

Supporting and scaling a global reporting ecosystem, resolving performance bottlenecks, and pioneering Copilot Studio integrations.

VertiPaq Engine OptimizationComposite Data ModelingOn-Premises GatewaysMicrosoft Copilot Studio
2 min read
Delivered Level 2 technical support and incident resolutions for massive-scale enterprise reporting environments.
Improved dashboard performance by 15% through DAX optimization, Composite Models, and pre-aggregation Tables.
Role: Senior Power BI Developer L2Read Case Study
February 2025 – August 2025Sonata Software Limited

Kyowa Kirin

Leading cross-functional pods to deploy a secure, AI-driven, and highly regulated European clinical analytics workspace.

Microsoft FabricOneLake LakehousePower BI PremiumMicrosoft Data Activator
2 min read
Led visualization delivery for a unified European Clinical Trial Management System (CTMS).
Delivered 10+ clinical dashboard suites resolving enrollment, site monitoring, and multi-million-euro trial budgets.
Role: Senior Power BI DeveloperRead Case Study
August 2025 – October 2025Kanerika Inc.

Kanerika Inc.

Programmatically parsing legacy ETL XML files to auto-generate Power Query (M) scripts and T-SQL pipelines on Fabric.

Microsoft Fabric MigrationInformatica PowerCenterXML Parser EngineeringPower Query (M) Generation
2 min read
Co-engineered FLIP's XML parsing mechanism, converting legacy Informatica XMLs into modern Fabric pipelines.
Programmatically generated complex Power Query (M) scripts to automate row-level transformations.
Role: Microsoft Fabric Analytics EngineerRead Case Study
March 2026 – April 2026Koch Industries (via Consulting)

Koch Industries

Unifying Molex's Snowflake and Fabric layers, automating metadata scripts on 180+ reports, and launching zero-trust automated testing.

Microsoft Fabric CLIPower BI PBIR MetadataPython Automation ScriptsPySpark
2 min read
Programmatically updated report bookmark and filter properties on 180+ Power BI dashboards via Fabric CLI and Git.
Achieved a 60% reduction in developer release timelines by treating reporting templates as version-controlled code.
Role: BI ConsultantRead Case Study
05 / SIMULATION COMMAND CENTER

Live Sandbox Processing Dashboard

Test and trigger Naveen Jujaray's enterprise pipeline routines and model calculations in real time. Choose an operations sector below.

Environment status: Operations Sandbox Live
Adjust Database Properties
Active Rows Under Analysis:35.0 Million
Column Key Cardinality:
Bidirectional Filter SecurityIncreases cross-table memory cost
Pre-Aggregation Caching CacheMaps large matrices to memory sheets
VERTIPAQ RECALCULATOR OUTPUT
Dictionary memory size0.1 MB
Relationships index size0.2 MB
Total Model Cache Size0.2 MB
Compression Ratio72.5%
Estimated Query Latency:195 ms (High Server Load)

Pre-aggregating tables and resolving bidirectional filters shrinks categorical footprint inside the physical VertiPaq memory frame.

05 / Interactive Career Blueprint

Professional Credentials

I pair certifications and higher education with direct enterprise experience. Click a section or review my complete resume layout directly on the screen.

Active Certifications

PL-300: Power BI Data Analyst Associate

Microsoft Certified

DP-600: Fabric Analytics Engineer Associate

Microsoft Certified

SAFe 6: Certified Agile Practitioner

Scaled Agile, Inc.

Academic Background

University of Arizona, USA

Master of Science in Data Science (2022 – 2024)

Tucson, AZ
GITAM (Deemed to be) University

Bachelor of Technology in Computer Science & Engineering (2017 – 2021)

Hyderabad, IN
Career HistoryRequest Resume PDF

Data Analyst

PUMA Group (via Texplorers)

Jun 2026 – Present
  • Building next-generation solutions with Microsoft Fabric, Power BI, and Databricks.
  • Designing and implementing MCP Servers, custom AI integrations, autonomous Data Agents, and Operational Agents.
  • Crafting interactive Fabric Apps to drive streamlined business automation and visual intelligence.

BI Developer (Consultant)

Koch Industries (via Consulting)

Mar 2026 – Apr 2026
  • Built cross-model reconciliation framework between Power BI metrics and Snowflake using Fabric notebooks, achieving 100% data consistency.
  • Coded automated Python CLI routines updating bookmark variables across 180+ reports, reducing release cycles by 60%.

Microsoft Fabric Analytics Engineer

Kanerika Inc.

Aug 2025 – Oct 2025
  • Automated ETL migrations (Informatica to Fabric) using XML parsing logic compilers, generating Power Query (M) and SQL codes automatically.
  • Mitigated redevelopment workloads by 40% using reusable pipeline templates.

Senior Power BI Developer / Team Lead

Sonata Software Limited (Client: Kyowa Kirin)

Feb 2025 – Aug 2025
  • Led clinical analytics visualization suites (CTMS) for regulatory EU medical trial programs.
  • Automated alert exception thresholds using Microsoft Data Activator, and linked natural-language models inside Copilot Studio.

Senior Power BI Developer L2

Sonata Software Limited (Client: Microsoft)

Oct 2024 – Jan 2025
  • Provided Level 2 technical support, debugging refresh failures on gateway clusters and optimizing large tabular models.
  • Boosted loading performance by 15% through pre-aggregation models and VertiPaq analyzer audits.

Power BI Developer / BI Engineer

Brillio LLC (Client: RNL)

Jun 2021 – Jul 2024
  • Designed analytical dashboards covering forecasting and student metrics across 110+ universities.
  • Constructed high-speed Star Schema structures, reducing reporting overhead by 35%.
06 / What I Believe

Engineering Code of Conduct

Preemptive Answers

"Data should answer questions before people think to ask them." True analytics models exceptions and forecast trends interactively, predicting points of interest.

Decisions Over Decoration

"Dashboards should guide decisions, not decorate screens." Visual metrics are worthless unless they trigger direct action, automate pipelines, or save workloads.

Clarity Over Complexity

"Technology is meaningful only when it creates crystal-clear clarity." A complicated pipeline or multi-layered query code is useless if users can't derive direct values.

07 / Collaboration Initiate

Let's Build Something Meaningful.

Are you migrating legacy databases, scaling enterprise-scale Power BI environments with Microsoft Fabric, or looking to integrate smart conversational AI layers? Let's connect.

Launch Enterprise Conversation

You can reach out directly via LinkedIn or email to coordinate interviews or discuss enterprise business intelligence consultations.

Available for global role proposals
Licensed fabric DP-600 & PL-300 certification
Relocation ready & remote scheduling expert
© 2026 Naveen Jujaray. All Rights Reserved.
Built with