Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Bhavana Gangireddigari

Ontario

Summary

Experienced Business Intelligence Developer with around 7 years of professional expertise in Power BI and SQL Server. Proficient in Power BI Data Modeling, DAX expressions, and creating effective reports and dashboards using Power Query, Power Pivot, and Power View. Skilled in Row Level Security, incremental Refresh, and custom visualizations. Demonstrated capability in creating various report formats, including tables, matrices, charts, and custom visuals. Experienced in drill-down and drill-through reports, calculated measures, and sharing reports through App Workspaces. Familiarity with Power BI Service, SQL Queries, Stored Procedures, and requirement analysis. Additionally, adept in Power Apps, Power Automation, SharePoint Sites, and creating canvas, model-driven, and (Web)-portal applications. Knowledgeable in Automated, Scheduled, and Instant Flows, handling errors, and implementing on-premises gateways in Power Automate.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Power BI Developer - Sr. Software Engineer

Tech Mahindra
08.2024 - Current
  • Scotia Bank – Banking Domain
  • Collaborated directly with business users and product owners to gather dashboard requirements and define reporting KPIs.
  • Utilized Power BI Dataflows connected to IBM DB2 to streamline ETL and resolve in-memory constraints in Power BI Desktop.
  • Performed advanced data shaping using Power Query Editor parameterization, conditional logic, and data normalization.
  • Built robust star schema data models by defining relationships between fact and dimension tables for banking operations.
  • Designed a comprehensive Lead Dashboard displaying total leads by stage (unactioned, in-progress, deferred, closed), segmented by location, campaign, and advisor.
  • Created dynamic DAX measures using aggregate, time intelligence, filter, and mathematical functions (e.g., YTD, MTD, rolling averages) to track lead performance trends.
  • Implemented both static and dynamic Row-Level Security (RLS) for role-based access using user attributes.
  • Used Performance Analyzer to identify slow visuals and optimized DAX measures by replacing calculated columns.
  • Reduced report load times by removing unnecessary columns and filtering data at the source before importing.
  • Applied incremental refresh for large datasets to avoid full dataset reloads during scheduled updates.
  • Managed scheduled refreshes through enterprise gateways and published reports to Power BI Service for department-wide access.

Power BI Developer – Senior Consultant

Capgemini
06.2021 - 02.2024
  • HPE Hewlett Packard Enterprise - Sales Domain
  • FMR (CCEP Coca Cola) - Sales Domain
  • Ascot Underwriting Limited – Insurance
  • Led Power BI development across multiple domains, delivering tailored reports aligned with sales and underwriting KPIs.
  • Extracted and transformed large datasets using SQL queries and built optimized views for seamless integration with Power BI.
  • Created forecasting dashboards and performance trend reports using advanced DAX and calendar tables.
  • Translated detailed report specification documents into interactive reports with filters, drill-throughs, and summary views.
  • Set correct cardinality (one-to-many or many-to-one) between fact and dimension tables to ensure relationships worked properly and avoid duplicate or incorrect totals.
  • Managed deployment pipelines, ensuring seamless transitions between development, test, and production environments.
  • Provided business users with training and reusable templates to encourage adoption of self-service reporting.

Power BI Developer

Cognizant
04.2018 - 03.2021
  • Well Mark Health Insurance
  • Engaged business analysts to understand reporting needs, define metrics, and estimate development timelines.
  • Built reports with interactive features like Sync Slicers, bookmarks, and drill-throughs to improve usability.
  • Focused on report performance tuning using techniques such as query folding, column pruning, and aggregate tables.
  • Innovatively crafted customized, interactive reports, and dashboards within Power BI, fostering data-driven insights.
  • Published reports to Power BI server, facilitating access for relevant stakeholders and enabling informed decision-making.
  • Designed usage and performance monitoring dashboards to support governance and refresh reliability.

Education

Bachelor of Commerce - Computer Applications

Sri Venkateswara University
India
05.2017

Skills

  • Power BI Desktop
  • Power BI services
  • ETL processes
  • Data modeling
  • DAX calculations
  • Row-level security
  • Performance optimization
  • Dashboard design
  • Data visualization
  • Data flows
  • Gateways
  • SQL
  • Power Apps
  • Power Automate

Certification

DA-100, PL-300

Timeline

Power BI Developer - Sr. Software Engineer

Tech Mahindra
08.2024 - Current

Power BI Developer – Senior Consultant

Capgemini
06.2021 - 02.2024

Power BI Developer

Cognizant
04.2018 - 03.2021

Bachelor of Commerce - Computer Applications

Sri Venkateswara University

Similar Profiles

CREATE PROFILE
Bhavana Gangireddigari