Nijar
Power BI Developer / Data Analyst
About
Results-driven Power BI Developer / Data Analyst with 6+ years of IT experience, specializing in Power BI, SQL, data analysis, data modeling, and business intelligence solutions. Experienced in designing and developing interactive dashboards, reports, and KPIs using Power BI Desktop and Power BI Service. Strong knowledge of DAX, Power Query, data modeling, star schema, Row-Level Security (RLS), and report performance optimization. Proficient in writing and optimizing complex SQL queries using joins, CTEs, sub queries, aggregate functions, and window functions for data extraction, transformation, validation, and reporting. Experienced in troubleshooting data discrepancies, query performance issues, dataset refresh failures, and production reporting issues. Adept at understanding business requirements and translating them into reliable, scalable, and user-friendly BI solutions while collaborating effectively with business stakeholders and technical teams.
Skills & Expertise (21)
Work Experience
Software Engineer
Innova Solutions
Jul 2024 - Apr 2026
Developed and supported end-to-end Power BI reporting solutions for business and operational reporting requirements. Gathered reporting requirements from stakeholders and translated them into scalable Power BI dashboards and analytical solutions. Designed data models with appropriate fact and dimension tables, relationships, hierarchies, and calculated measures. Developed advanced DAX measures for YTD, MTD, previous-period comparisons, growth percentages, KPIs, and other business metrics. Designed star schema data models and complex DAX measures to calculate performance KPIs like per-member per-month (PMPM) cost and case closure rates. Used Power Query (M) for data cleansing, transformation, merging, appending, conditional logic, and data preparation. Integrated data from different sources and performed data validation before presenting information through Power BI. Created interactive dashboards using slicers, drill-through, bookmarks, tool tips, conditional formatting, and dynamic measures. Implemented Row-Level Security (RLS) and managed appropriate user access to reports. Published and maintained reports in Power BI Service, including workspace management, scheduled refreshes, dataset configuration, and report deployment. Enabled drill-through reports and slicer-based filtering for analyzing patient cohorts by age, region, and chronic condition flags. Troubleshot Power BI refresh failures, incorrect calculations, SQL/data issues, and report performance problems. Optimized Power BI solutions by reducing unnecessary columns, improving data models, simplifying DAX, and improving query performance. Collaborated with business users, analysts, and technical teams during requirement gathering, development, testing, deployment, and production support.
Power BI Developer
Likewize India Shared Services LLP
Jan 2021 - Dec 2023
Designed and developed interactive Power BI dashboards and reports to support business operations and management reporting. Connected Power BI with multiple data sources and transformed raw data using Power Query Editor. Developed complex DAX measures and calculated columns for KPIs, trends, variance analysis, and business calculations. Designed efficient data models using star schema, defining relationships between fact and dimension tables. Developed SQL queries involving joins, CTEs, sub queries, aggregate functions, CASE statements, and window functions for reporting and analysis. Created optimized SQL datasets to serve as reliable data sources for Power BI reports. Implemented Row-Level Security (RLS) to provide role-based access to reports and business data. Developed drill-down, drill-through, slicers, bookmarks, tooltips, and interactive report functionality to improve user experience. Improved Power BI report performance by optimizing DAX calculations, data models, relationships, and Power Query transformations. Published reports to Power BI Service and managed datasets, workspaces, refresh schedules, and report access. Worked closely with business stakeholders to gather requirements, understand KPIs, and convert business requirements into dashboards and reports. Performed data validation between SQL source data and Power BI reports to ensure reporting accuracy.
Analyst
Cognizant Technology Solutions
Apr 2018 - Apr 2020
Designed and developed interactive Power BI dashboards and reports to support business operations and management reporting. Connected Power BI with multiple data sources and transformed raw data using Power Query Editor. Developed complex DAX measures and calculated columns for KPIs, trends, variance analysis, and business calculations. Designed efficient data models using star schema, defining relationships between fact and dimension tables. Developed SQL queries involving joins, CTEs, sub queries, aggregate functions, CASE statements, and window functions for reporting and analysis. Created optimized SQL datasets to serve as reliable data sources for Power BI reports. Implemented Row-Level Security (RLS) to provide role-based access to reports and business data. Developed drill-down, drill-through, slicers, bookmarks, tooltips, and interactive report functionality to improve user experience. Improved Power BI report performance by optimizing DAX calculations, data models, relationships, and Power Query transformations. Published reports to Power BI Service and managed datasets, workspaces, refresh schedules, and report access. Worked closely with business stakeholders to gather requirements, understand KPIs, and convert business requirements into dashboards and reports. Performed data validation between SQL source data and Power BI reports to ensure reporting accuracy.
Education
B.Tech in Information Technology - Sri Eshwar College of Engineering
- 2017 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (21)
Click a skill to find developers with the same skill
