Power BI Architect with 7+ Years Enterprise Experience

PAVAN CHEKURI

**********.****@*****.***

PROFESSIONAL SUMMARY

Power BI Developer with 7+ years of experience delivering enterprise Business Intelligence and analytics solutions across banking, insurance, finance, and risk domains. Strong expertise in designing scalable Power BI architectures, building optimized data models, and developing advanced DAX-based KPI frameworks for executive reporting and operational analytics.

Hands-on experience working with Bank of America (current) on financial risk and performance dashboards, and Standard Insurance on claims, underwriting, and policy analytics solutions. Previously worked with Ernst & Young (EY) delivering enterprise BI systems for finance, compliance, and risk reporting.

Experienced in integrating data from SQL Server, Oracle, Azure Data Lake, APIs, and enterprise systems using SSIS and Azure Data Factory. Proven ability to improve reporting performance, reduce manual effort, and deliver secure, automated, and scalable BI solutions for business decision-making.

CORE SKILLS

Business Intelligence

Power BI (Desktop, Service, Gateway, Dataflows, RLS), Advanced DAX, Power Query, KPI dashboards, executive reporting, drill-through analytics, performance tuning

Databases and SQL

SQL Server, Oracle, PostgreSQL; Advanced T-SQL (window functions, CTEs, joins, subqueries, optimization techniques)

ETL & Data Integration

SSIS, Azure Data Factory, API integration, Excel/flat file ingestion, data transformation pipelines

Cloud & Data Platforms

Azure Data Lake, Azure ecosystem, enterprise reporting architecture

Data Modeling

Star schema, Snowflake schema, semantic models, data governance, Row Level Security (RLS)

Domains

Banking, Insurance, Finance, Risk Management, Compliance, Operations

PROFESSIONAL EXPERIENCE

Power BI Developer

Bank of America (BOA) – Financial Risk & Banking Analytics

USA (Remote/Hybrid) Jun 2025 – Present

Project: Enterprise Banking Risk & Financial Performance Reporting

Designed and delivered enterprise Power BI dashboards for financial performance, risk monitoring, and operational KPIs used by senior leadership.

Built scalable data models integrating SQL Server and internal banking systems to provide unified reporting across multiple financial domains.

Developed advanced DAX measures for credit exposure, transaction monitoring, revenue trends, and risk indicators, improving decision-level insights.

Implemented Row Level Security (RLS) to control access to sensitive financial and customer data across business units.

Optimized Power BI datasets and query structures, improving dashboard performance and reducing refresh delays.

Automated Power BI Service refresh schedules ensuring consistent and near real-time data availability.

Collaborated with finance, risk, and compliance teams to refine reporting logic and improve data accuracy across enterprise systems.

Power BI Developer

Standard Insurance – Claims, Policy & Underwriting Analytics

USA / Global Delivery March 2023 – May 2025

Project: Insurance Analytics Platform (Claims, Underwriting & Policy Management)

Designed and implemented enterprise insurance analytics dashboards covering claims, underwriting, policy performance, and risk exposure tracking.

Integrated multiple data sources including Azure Data Lake, SQL Server, and REST APIs to build a unified reporting platform.

Developed optimized Power BI data models using star schema architecture for large-scale insurance datasets.

Built advanced DAX KPIs including claim ratios, policy lapse rate, renewal trends, and premium revenue tracking.

Automated reporting pipelines using Power BI Service, reducing manual reporting effort and improving data refresh reliability.

Implemented data validation checks ensuring consistency across underwriting, claims, and finance datasets.

Worked closely with actuarial, underwriting, and finance teams to translate business requirements into dashboards.

Delivered executive dashboards improving visibility into insurance portfolio performance and risk trends.

Sr. Power BI Developer

Ernst & Young (EY) – Finance, Risk & Compliance Analytics

Bangalore, India Apr 2020 – Aug 2022

Project: Enterprise Finance & Risk Reporting Platform

Delivered end-to-end Power BI solutions for financial reporting, risk analytics, and compliance dashboards for global clients.

Designed scalable BI architecture with optimized data models and advanced DAX logic for enterprise reporting needs.

Built interactive dashboards with drill-down and KPI-based analytics for executive decision-making.

Integrated data from Azure Data Lake, Oracle, SQL Server, and APIs using SSIS and Azure Data Factory.

Developed optimized SQL queries for large datasets improving performance and data processing efficiency.

Standardized BI reporting templates used across finance, compliance, and operational reporting teams.

Collaborated with finance, risk, and operations stakeholders to gather requirements and deliver analytics solutions.

Junior Power BI Developer

Ernst & Young (EY) – Reporting Automation & Data Engineering Support

Bangalore, India May 2018 – Dec 2019

Project: BI Reporting Automation & Data Integration Support

Supported development of Power BI dashboards for financial and operational reporting use cases.

Built ETL workflows using SSIS and Azure Data Factory for structured data ingestion and transformation.

Developed SQL queries for data extraction, cleaning, and validation from Oracle and SQL Server systems.

Assisted in migration of SSRS and Excel-based reporting systems into Power BI dashboards.

Automated Power BI report refresh processes improving data availability and reporting consistency.

Supported senior developers in building data models and optimizing dashboard performance.

STRENGTHS

Strong expertise in enterprise Power BI development for banking and insurance domains

Ability to design scalable dashboards with optimized performance and Data Modeling

Experienced in translating complex business requirements into actionable BI solutions

Strong understanding of financial, risk, and operational analytics

Proven experience working in global enterprise environments with cross-functional teams

EDUCATION

Master of Science in Information Technology

Franklin University – Columbus, OH

09/2022 – 12/2023

Contact this candidate