Vignya S

Designed and developed enterprise Power BI dashboards, reports, and semantic models for portfolio risk analytics, forecasting, operational reporting, and executive KPIs. Built 15+ interactive dashboards using advanced visualization, reusable measures, calculation groups, and field parameters. Engineered scalable dimensional and semantic models (star/snowflake) and implemented Direct Lake and Import models in Microsoft Fabric with performance tuning (VertiPaq optimization, incremental refresh). Managed Power BI Service activities including workspace organization, semantic model deployment, scheduled refreshes, gateway configuration, and production monitoring. Implemented RLS and OLS for sensitive financial data and supported Medallion architecture (Bronze/Silver/Gold) across Fabric, Azure Data Factory, and Azure Synapse. Developed ETL/ELT pipelines and SSIS packages with source-to-target validation, reconciliation, and discrepancy resolution; authored complex T-SQL queries, stored proce

Developed Power BI dashboards, interactive visualizations, and healthcare/insurance analytics reporting including KPI dashboards, measures, calculated columns, and drill-through experiences. Built dimensional star schema repositories to support scalable reporting and analytical workloads. Wrote complex T-SQL queries, stored procedures, and transformations using CTEs, window functions, and advanced joins. Built SSIS ETL workflows to integrate flat files and relational database and third-party healthcare system data into centralized data warehouse environments, with error handling, logging, and exception processing. Performed data validation and reconciliation across source systems, staging, data warehouse layers, and Power BI reports to resolve missing/duplicate/mapped incorrectly and transformation rule inconsistencies. Optimized SQL performance and applied incremental refresh to efficiently manage growing historical datasets; supported Power BI and SSRS through development, testing, d