Hi, I'm Koustav Paul
Transforming complex, multi-source raw data into high-impact dashboards and semantic models that drive enterprise-level business decisions.
Professional Summary
I am a results-driven BI & Analytics Engineer with 4+ years of experience designing and delivering end-to-end data solutions using **Power BI** and **Microsoft Fabric**.
Adept at working across the full analytics stack—from pipeline orchestration and data modelling to complex DAX development, row-level security implementation, and stakeholder reporting. I specialize in bridging the gap between raw data complexity and executive-level decision making.
Whether designing optimized star-schema dimensional models or writing T-SQL stored procedures, my focus remains on performance, scalability, and delivering actionable business insights.
4+
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
Associate Software Developer
Embee Software Pvt. Ltd.
- Fabric & Pipeline Engineering: Architected end-to-end data ingestion workflows using Microsoft Fabric—designing Lakehouses, Warehouse schemas, and orchestrating Data Pipelines to reliably process and transform large-scale enterprise data.
- Dimensional Modelling: Designed and implemented star-schema models in SSMS, building optimised fact and dimension tables that significantly improved query performance across Power BI reports and dashboards.
- DAX Development: Authored advanced DAX measures covering time intelligence, dynamic ranking, running totals, and KPI calculations, delivering accurate and flexible analytical capabilities to business users.
- Power Query & Data Transformation: Built reusable Power Query pipelines to cleanse, merge, and reshape data from multiple heterogeneous sources, reducing manual data-prep effort and improving report refresh reliability.
- Dashboard & Report Delivery: Designed and published interactive, executive-level Power BI dashboards aligned to stakeholder KPIs—enabling self-service analytics and data-driven decision-making across business units.
- Security & Governance: Configured Dynamic Row-Level Security (RLS) and managed on-premises data gateways, ensuring role-based data access and secure, compliant reporting for enterprise users.
- SQL Optimisation: Wrote and tuned T-SQL views, stored procedures, and queries to support efficient data extraction, improving report load performance and reducing processing overhead.
- Stakeholder & UAT Management: Led requirements-gathering sessions with business stakeholders, facilitated UAT cycles, and resolved data discrepancies promptly—ensuring high-quality, on-time deliverables.
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.