Hi, I'm Koustav Paul
Architecting enterprise data solutions across Microsoft Fabric, Power BI, and Azure. Proven expertise in Enterprise Data Ontologies, Medallion Lakehouses, and deploying GenAI architectures using Microsoft Copilot Studio, Microsoft Foundry, and MCP Servers.
Professional Summary
I am a results-driven BI & Data Analytics Engineer with 4.5+ years of experience architecting enterprise data solutions using Microsoft Fabric, Power BI, and Azure.
Proven expertise in designing Enterprise Data Ontologies, building scalable Medallion pipelines (Bronze/Silver/Gold), and deploying GenAI analytics utilizing Microsoft Copilot Studio, Microsoft Foundry, and autonomous Data Agents via Model Context Protocol (MCP) servers.
Expert in advanced DAX, Python, SQL, and semantic modeling, transforming raw data into high-performance executive architectures. Holds Microsoft certifications PL-300, DP-600, and DP-700.
4.5+
Years of Experience
3x
Microsoft Certified
100%
End-to-End Delivery
Technical Skills Workspace
Select a category to query my proficiency metrics in real-time.
BI & Visualization
● LIVEImplementation Context:
Authoring complex dashboards with clean UX/UI, configuring gateways, and deploying Fabric capacity workspaces to support self-service analytics.
Work Experience & Architecture Projects
BI & Data Analytics Engineer
Embee Software Pvt. Ltd.
Project 1: Enterprise Lakehouse & Medallion Analytics Platform
Microsoft Fabric • Lakehouse • Warehouse • Synapse • T-SQL • Power Query- Lakehouse Architecture & Pipelines: Architected enterprise Medallion Lakehouses (Bronze/Silver/Gold) and Data Warehouses in Microsoft Fabric, orchestrating automated pipelines to ingest and process multi-source enterprise data reliably.
- Dimensional Modeling & SQL Tuning: Designed star-schema models in SSMS/Fabric and optimized complex T-SQL views and stored procedures, accelerating report execution speeds by 45% and cutting database processing overhead.
- Security & Access Governance: Configured Dynamic Row-Level Security (RLS) and managed On-Premises Gateways, securing role-based access and achieving 99.9% scheduled report refresh reliability.
Project 2: GenAI Autonomous Data Agent & Copilot Assistant Ecosystem
Copilot Studio • Microsoft Foundry • MCP Server • Fabric Semantic Models- Autonomous Agent Architecture: Engineered and deployed custom Data Agents and conversational assistants using Microsoft Copilot Studio and Microsoft Foundry over Fabric semantic models.
- MCP Server & NLQ Integration: Integrated Model Context Protocol (MCP) servers and AI-assisted data tools to connect LLMs securely with live analytical schemas, enabling non-technical leaders to execute Natural Language Queries (NLQ) and slashing dashboard delivery cycles by 35%.
- Enterprise Data Ontologies: Designed structured Enterprise Data Ontologies unifying cross-departmental entities into an AI-ready single source of truth for reliable business analysis.
Project 3: Executive Intelligence & Advanced DAX Semantic Layer
Power BI Service & Desktop • Advanced DAX • Tabular Editor- Advanced DAX Calculations: Authored high-performance DAX measures for time intelligence, dynamic ranking, running totals, and strategic KPIs across enterprise semantic models, delivering flexible, sub-second analytics.
- Executive Reporting & Stakeholder Leadership: Designed interactive, executive-grade Power BI dashboards aligned with C-suite KPIs; led discovery and UAT cycles delivering high-impact BI deliverables on schedule.
Certifications & Credentials
Click on any card to view the official certificate.
Microsoft Certified: Fabric Data Engineer Associate
Validates expert-level capabilities in building and deploying scalable enterprise-level data integration pipelines, warehouses, and lakehouses using Microsoft Fabric.
Microsoft Certified: Fabric Analytics Engineer Associate
Demonstrates proficiency in designing, creating, and deploying analytics solutions using Microsoft Fabric and Power BI—from data prep to semantic models.
Microsoft Certified: Data Analyst Associate
Core certification validating fundamental capability in building clear reports, advanced DAX modeling, data shaping, and administration in Power BI.
Get In Touch
Let's Collaborate
Interested in data orchestration, dashboard design, or enterprise BI solutions? Feel free to reach out using the details below or download my details directly.