Suman11

Power BI Developer

Kolkata, West Bengal 5+ yrs exp 90 · Outstanding

About

Power BI Developer with 5 years of experience turning raw data from SQL Server, Azure SQL, and REST APIs into dashboards that executives actually use to make decisions. Recently piloted Microsoft Fabric — provisioning a Fabric Lakehouse and building Fabric Data Pipelines — as a proof-of-concept to modernise existing Azure Data Factory and Synapse Analytics workloads. Specialist in DAX modelling, ETL/pipeline design, and Role-Level Security — with a track record of cutting reporting cycle times by up to 60% and improving budget forecasting accuracy by 25% across banking, ERP (SAP Business One), and HRMS domains. Available immediately.

Skills & Expertise (35)

Power BI Desktop Advanced

8.3/10

Years Exp

DAX Advanced

8.0/10

Years Exp

Azure Data Factory Intermediate

7.5/10

Years Exp

Power BI Service Intermediate

7.0/10

Years Exp

ETL Pipeline Design Intermediate

7.0/10

Years Exp

SQL Server Intermediate

7.0/10

Years Exp

Azure Synapse Analytics Intermediate

6.5/10

Years Exp

Power BI Gateway Intermediate

6.0/10

Years Exp

Stored Procedures Intermediate

6.0/10

Years Exp

REST API Integration Intermediate

6.0/10

Years Exp

Data Accuracy T-SQL SQL Role-Level Security Data Validation Relational Database Design Performance Tuning SharePoint Excel SAP Business One SCCM Views CTEs OneLake MySql Azure SQL KPI Design Snowflake Schema Star Schema M Language Power Query Crystal Reports SSRS Report server Semantic Models

Work Experience

Power BI Developer

Neoquant Solutions

Aug 2024 - Present

Improved reporting efficiency by 40% across CMDB, SCCM, and operations teams by designing and deploying interactive dashboards that gave stakeholders real-time visibility into banking infrastructure health. Reduced average report load time by 30% by building optimised DAX measures, rewriting SQL queries, refactoring stored procedures and CTEs, and tuning Power BI data models across complex relational databases. Ensured 100% data accuracy and consistency across all live reports by implementing automated refresh schedules via Power BI Gateway and conducting systematic data validation checks against SQL Server and Azure SQL sources. Enforced data governance for 200+ banking users by implementing Role-Level Security (RLS) in Power BI Service, ensuring appropriate access controls across divisional hierarchies. Accelerated ETL delivery by 25% by designing Azure Data Factory pipelines — the same orchestration patterns (For Each, Get Metadata, Lookup, Set Variable) now used in Microsoft Fabric Data Pipelines — to ingest data from SQL Server, Excel, and REST API sources into Azure SQL. Translated complex stakeholder requirements into actionable visual analytics by collaborating directly with cross-functional banking teams to define KPIs, validate reporting logic, and iterate on dashboard design. Piloted Microsoft Fabric as a proof-of-concept for the team's next-generation data platform — provisioning a Fabric Lakehouse and building Fabric Data Pipelines to ingest and stage banking data, evaluating it as a path to consolidate existing ADF/Synapse workloads onto Fabric.

BI & Data Consultant

FairFax Solutions

Jan 2023 - Aug 2024

Reduced month-end reporting cycle time by 35% for SME clients by designing Crystal Reports with advanced formulas, grouping, dynamic parameters, and selection criteria across SAP Business One ERP. Improved SQL query response time by 50% by building and optimising stored procedures, triggers, functions, and views in SSMS and HANA Studio against relational databases spanning millions of transactions. Maintained data accuracy and consistency across client environments by validating report outputs against source ERP data and providing ongoing technical support for enhancements. Accelerated team delivery on complex builds by mentoring junior developers on SQL optimisation, report design, and data validation best practices. Reduced manual HR reporting effort by 60% by designing and deploying interactive HRMS dashboards in Power BI Desktop connected to SQL Server, giving HR managers self-serve access to headcount, attendance, and payroll KPIs. Improved dashboard reliability for 150+ HR users by automating data refresh schedules via Power BI Report Server and optimising underlying SQL queries for consistent, accurate outputs.

Data Engineer (Trainee)

RayMinds

Oct 2021 - Jan 2023

Enabled analysts to access clean, structured data 3x faster by designing ADF pipelines with Filter, For Each, Get Metadata, and Lookup activities to ingest data from multiple relational database sources into Azure SQL. Increased data transformation reliability by developing complex stored procedures, triggers, functions, and views, validated through SIT (System Integration Testing) with full documentation. Accelerated internal decision-making by developing Power BI reports connected to Azure SQL, transforming raw pipeline data into actionable insights for team leads and project stakeholders.