Gourav Halder

• Prepared 10+ power bi report for an Insurance domain operation project - SLA Report, Non-SLA Report, Quality Report, Monthly SLA, Performance Utilization Report, Volume Forecasting Report converting large raw data set to actionable insights for business.
• Integrated data from multiple sources, like SQL Server, Excel, CSV, SharePoint, and Azure SQL Database, into the Power BI environment.
• Created Advanced label reports using features like Bookmark, Tooltip, Drill trough filter, Calculation Group.
• Optimized Power BI performance for data models, queries, and reports to ensure performance and scalability.
• Ensured data security, accuracy, and adherence to compliance standards by applying row-level security (RLS), page-level security, and object-level security, and managing workspace permissions.
• Deployed and maintained reports in Power BI Service, managing scheduled refreshes and version control.
• Created complex SQL queries, stored procedures, functions, views, indexes and other database objects to extract and prepare data for reporting.
• Designed and developed paginated reports, including parameterized paginated reports, to deliver pixel-perfect, print-ready documents for operational reporting.
• Identified and resolved issues related to data, reports, and the Power BI environment.

• Designed and deployed interactive Power BI reports to track KPIs across Supply Chain, HR and operations.
• Prepared Supply Chain, Global HR Headcount, Attrition, ARC Report.
• Built and optimized SQL queries, stored procedures, and views to support reporting needs.
• Implemented data models and transformations using Power Query and DAX for advanced calculations.
• Implemented proper scheduling for data refresh and row-level, Page level and object level security in Power BI workspaces.
• Developed analysis reports and visualization using DAX functions like Calculate, Filter, All, AllSelected, AllExcept, RemoveFilter, Aggregation, Logical, Text, Date-time, and Iteration functions.

• Created database in SQL and prepared reports in Power BI for Banking Process.
• Prepared presentations, graphs, and analytical reports.
• Developing Power BI reports and dashboards from multiple data sources, and publishing them on Power BI Service.
• Create interactive dashboards and reports that drive business insights, and improve decision-making.