Power Bi Developer

VARUN REDDY

Senior BI Developer

PROFESSIONAL

SUMMARY

Results-driven data professional prepared for this role with solid foundation in report development and analysis. Proven ability to translate data into meaningful reports that support business strategies. Recognized for collaborative team efforts and adaptability in dynamic environments. Proficient in SQL, data visualization, and problem-solving. ACCOMPLISHMENTS 1. Redesigned and Enhanced Enterprise Sales Dashboards.

2. Automated Reporting Workflows

Using Power Automate

3. Created KPI-Driven Reporting for

Revenue and Sales Monitoring

4. Enabled Write-Back Functionality

using Translytical Workflows

5. Led Fabric Lakehouse and Data

Warehouse Initiatives

WORK HISTORY SR. BUSINESS INTELLIGENCE DEVELOPER 04/2023 to Current Charles Schwab, San Francisco, CA

Tech Stack: Power BI, SQL Server, SSRS, Azure, ADF, T-SQL, Python, Power Automate, Fabric Core Skills & Responsibilities

● Power BI Development: Designed and developed interactive dashboards and data visualizations using Power BI Desktop and Service, including pie charts, bar graphs, tree maps, scatter plots, and KPI cards. Delivered business-critical insights for Sales and Finance stakeholders.

● ETL & Data Integration: Built and optimized robust ETL pipelines using SSIS, Azure Data Factory, and T-SQL. Developed incremental load strategies and integrated data from sources including D365, Azure SQL, and on-prem SQL Servers.

● Database Design & Performance: Wrote advanced T-SQL (DDL/DML), stored procedures, and managed Slowly Changing Dimensions (SCDs) to preserve historical accuracy in data. Tuned SQL queries and SSRS reports for improved performance and efficiency.

● Modern Azure Solutions: Migrated legacy data warehouse workloads to Azure SQL. Converted ADF v1 pipelines to ADF v2 with Integration Runtime (IR) and implemented monitoring, diagnostics, and scaling in Azure environments.

● Advanced Power Platform Usage: Leveraged Power Automate to streamline report distribution workflows. Developed embedded solutions with Power Apps and configured on-premise gateways to support hybrid scenarios.

● SSAS & Dimensional Modeling: Designed star schemas, created dimensions and cubes using SSAS, and wrote MDX to define calculated members and KPIs. Worked closely with data architects to model facts and dimensions for finance analytics.

● Data Quality & Profiling: Conducted data profiling and cleansing using SSIS and custom scripts before migrations. Used transformations such as Fuzzy Lookup, Conditional Split, Irving, TX 75060 682-***-****

and Derived Columns to enhance data integrity.

● DevOps & Agile Delivery: Followed Agile methodologies, participated in sprint planning, and used Azure DevOps and TFS for source control, automated deployments, and collaboration.

● POCs & Cross-Platform Reporting: Delivered POCs for Power BI, Spotfire, and Fabric

(Lakehouse, Pipelines). Supported both ad hoc and enterprise-level reporting requirements from diverse data sources.

BI DEVELOPER 05/2022 to 03/2023

GAIG, Cincinnati, OH

Environment: SQL Server 2012, SSIS, SSRS, SSAS, T-SQL, Power BI, MDX, Oracle, SQL Profiler Core Responsibilities & Highlights

● Collaborated with business users to gather requirements and analyze workflows as part of the full Software Development Life Cycle (SDLC).

● Designed and developed ETL packages using SSIS to extract, clean, and load data from diverse sources including Oracle, Excel, and flat files into SQL Server.

● Created data mapping documents for SSIS migration jobs and implemented robust data validation and error-handling frameworks.

● Built and deployed complex SSRS reports and dashboards, including ad-hoc, parameterized, and chart-based reports using filters, sorting, and expressions.

● Designed and implemented T-SQL queries, stored procedures, triggers, views, and user-defined functions in both development and production environments.

● Developed and maintained SSAS cubes, hierarchies, and KPIs to support multidimensional analysis; authored MDX queries and deployed mining models for deeper insights.

● Configured and managed on-prem Power BI gateways to refresh datasets and enable real-time reporting capabilities.

● Created Power BI reports and dashboards with interactive slicers and visualizations like bar charts, line charts, scorecards, and KPI cards.

● Used SQL Profiler to monitor, troubleshoot, and optimize database performance and T-SQL statements.

● Delivered dashboards and reporting models using both SSRS and Power BI, enabling data-driven decision-making across finance and operations teams. REPORT DEVELOPER 01/2020 to 12/2021

Daxinsoft Technologies, Hyderabad, India

Environment: Power BI, SQL Server, T-SQL, Excel, Agile Key Responsibilities & Achievements

● Designed and developed interactive Power BI dashboards and reports to track operational KPIs and audit compliance metrics for internal teams.

● Collaborated with business users, analysts, and IT leads to gather reporting requirements and transform them into user-friendly, insight-driven visuals.

● Created data models in Power BI using star schema concepts, ensuring optimized relationships, accurate aggregations, and clear reporting logic.

● Built automated daily audit and operations reports, delivering visibility into server configurations, job statuses, and user access — supporting monthly compliance processes.

● Implemented data refresh strategies and schedules using Power BI Service and SQL-backed queries, ensuring up-to-date and accurate reporting.

● Migrated legacy Excel and Access-based reporting processes into modern Power BI solutions, improving scalability and usability.

● Created parameterized and dynamic reports using slicers, filters, and drill-through pages to enhance user interactivity.

● Collaborated on data cleansing and transformation logic using SQL and Power Query to prepare source data for analysis and reporting.

● Followed Agile delivery processes — contributing to sprints, peer reviews, and production deployments as reporting needs evolved.

● Worked closely with the team to create self-service reporting tools, reducing ad-hoc requests and empowering business teams with accessible data. EDUCATION REVA University, Bengaluru, India

Bachelor of Science, Computer Science

SKILLS Advanced SQL queries Python programming

Power BI proficiency ETL development

Report development Performance tuning

Fabric Development Fabric Administration

Contact this candidate