Summary
Overview
Work History
Education
Skills
Timeline
Generic

Bhaskar Reddy

Denton,TX

Summary

Experienced Senior Power BI Developer with 9+ years of expertise in developing, optimizing, and managing advanced business intelligence solutions to support data-driven decision-making. Skilled in creating dynamic dashboards, custom SQL queries, and integrating Power BI with Azure Data Factory for efficient data management. Proficient in utilizing DAX, Power Query, and M Language for data modeling, transformation, and visualization to enhance operational efficiency and insights. Knowledgeable in ETL processes, SSIS implementation, data integration, and reporting through SSRS and paginated reports. Collaborates with stakeholders and applies Agile methodologies to align BI solutions with business objectives.

Overview

10
10
years of professional experience

Work History

Sr. Power BI Developer

Eli Lilly and Company
08.2023 - Current
  • •Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications. Craft 75+ intuitive Power BI dashboards, improving usability and reducing load times by 25% for cross-functional teams.
  • • Transform over 100K rows of raw data using Power Query to uplift data accuracy and analytical quality by 20%.
  • • Optimize Snowflake views for direct-query Power BI dashboards, empowering 150+ users with real-time business intelligence.
  • • Deploy 30+ SSRS reports with advanced drill-down and drill-through capabilities, increasing user reporting flexibility by 35%.
  • • Streamline ETL operations via SSIS and Power Query/M, processing 200K+ daily records while halving load times.
  • • Architect over 50 data models, refining relationships, DAX calculations, and measures to enhance data integrity and boost analytical efficiency by 30%.
  • • Automate 100+ data pipelines by integrating Power BI with Azure Data Factory, slashing manual ingestion time by 40%.
  • Engineer scalable Snowflake data warehousing solutions, integrating 10+ sources and elevating query speed by 30%.
  • • Construct 20+ robust SSIS packages with built-in error handling, raising data accuracy to 95% across ETL tasks.
  • • Deliver 50+ interactive dashboards and ad-hoc reports, connecting to 10+ sources to power business unit decisions.
  • • Implement ETL pipelines for 5+ data warehouses, integrating 15+ diverse sources to drive 40% better data uniformity.
  • • Launch 30+ dynamic KPI dashboards, accelerating executive decision-making by 25% through improved data visibility.
  • • Configure 25+ SSIS packages to load data from SQL Server and Excel into warehouses with 100% accuracy in fact/dimension tables.
  • • Enforce Row-Level Security (RLS) on 100+ reports, safeguarding sensitive data and upholding compliance standards.

Power BI Developer

Inovalon Holdings, Inc
01.2020 - 08.2023
  • Extract data from diverse sources, including SQL Server, CSV, SharePoint, Data flows, and Excel, enabling impactful analyses and driving a 25% improvement in report accuracy in Power BI.
  • Utilize advanced DAX formulas to calculate custom metrics and KPIs, enhancing the analytical capabilities of Power BI reports and achieving a 20% improvement in insights clarity.
  • Assemble and maintain ETL pipelines using SQL Server Integration Services (SSIS), processing data from multiple sources with 30% increased efficiency.
  • Design Power BI dashboards to report KPIs and metrics, improving the reporting process by 25% and accelerating client data analysis.
  • Automate ETL workflows by designing and implementing Azure Data Factory (ADF) pipelines, reducing data processing time by 30%.
  • Create SQL scripts for data extraction, transformation, and loading into the Data Warehouse, cutting data load times by 30%.
  • Optimize data models by incorporating DAX in SQL Server and Agile methodologies, enhancing reporting quality by 20%.
  • Develop custom Tableau dashboards that boost data visualization effectiveness, increasing user engagement by 15% for data-driven solutions.
  • Manage schema objects, including tables, views, and indexes, meeting dynamic user requirements with 99% reliability.
  • Ensure data accuracy and consistency by extracting, transforming, and loading data from sources like flat files, Excel, and SQL Server, achieving 98% accuracy.
  • Collaborate with cross-functional teams to gather requirements and deliver BI solutions, improving project time-lines by 20%.
  • Implement advanced data modeling techniques like star and snowflake schemas, enhancing data warehouse accessibility and performance by 25%.

Power BI Developer

Verana Health
09.2018 - 11.2019
  • Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, Testing, and implementing in the production server.
  • Redesigned and tuned stored procedures, triggers, UDF, views, indexes, and was successfully able to increase the performance of the slow running queries.
  • Experience in Developing and Publishing Reports in SQL Server 2013 using SSRS (SQL Server Reporting Services).
  • Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports, and Ad-hoc Reports.
  • Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.
  • Involve in designing and publishing visually rich and intuitive Power BI dashboards for executive decision making.
  • Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients.
  • Experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI
  • Expertise in writing complex DAX functions, queries in Power BI for the visualization.
  • Experience on publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for upcoming data in power BI server.

SSRS/ Power BI Developer

Navistar Inc
07.2017 - 08.2018
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-users to make filters.
  • Designed Power BI visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Involved in Power BI Maintaining, Monitoring Datasets, Performance tuning for reports/dashboards and control capacities in Power BI Service Experience on publishing Power BI reports on dashboards in Power BI server.
  • Integrated Custom Visuals based on business requirements using Power BI desktop.
  • Designed BI database (star schema, snowflake schema), built fact table, dimension tables, cube, attribute relationship, did deduping, calculates & KPI and data mapping. Coordinated feedback and recommended appropriate training and scheduling as system was deployed.
  • Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2016.

Junior BI Developer

Pycube
11.2015 - 07.2017
  • Generated multiple enterprise reports using SSRS from SQL Server Database, incorporating drill-downs, sub- reports, and bookmarks, fulfilling 100% of reporting requests.
  • Mastered data modeling, DAX, and Power Query, optimizing data performance and visualizations, resulting in a 25% reduction in report generation time.
  • Developed data warehousing concepts, enabling accurate data extraction and improving operational efficiency by 10%.
  • Architected a cloud-based BI solution using Azure, enhancing data retrieval times by 40%, thus supporting timely strategic decision-making across the organization.
  • Contributed to the development of a comprehensive data warehouse using SSIS, improving data storage efficiency and supporting a 50% growth in data analytics capacity.
  • Conducted performance tuning on SQL queries and ETL processes, resulting in a 20% improvement in overall system performance.
  • Designed complex reports and dashboards in Power BI Desktop with dynamic features like filters, drilldown reports, and sub-reports, improving user interaction and engagement by 30%.
  • Designed intuitive dashboards using Power BI for comprehensive data analysis.

Education

Bachelor’s - computer science

JNTU
India
04.2013

Masters - computer science

SFBU
Fremont, CA
05.2015

Skills

  • Visualization & BI Tools: Power BI Desktop, Power BI Service, Power BI Report Server, Power BI Data flows, Paginated Reports, Power Pivot, Excel, SSRS, Tableau (basic), Power Automate (Flow)
  • Databases & Storage: MS SQL Server, Azure SQL Database, Azure Synapse Analytics, Oracle, PostgreSQL, MySQL, Azure Data Lake, Flat Files, Excel, CSV, JSON, REST APIs
  • Programming & Query Languages: SQL, T-SQL, DAX, M (Power Query), Python (for data analytics), R (basic), API scripting (JSON/XML), MDX (basic understanding)
  • Data Integration & ETL: Power Query, SSIS, Azure Data Factory, Data Wrangling, Data Cleansing, Data Transformation, ETL Automation, Incremental Refresh
  • Data Analysis & Modeling: Star & Snowflake Schema, Relationship Management, Measures & KPIs, Time Intelligence, Calculated Columns & Tables, RLS (Row-Level Security), Data Governance, Master Data Management, Report Performance Optimization
  • Other Tools & Platforms: Azure Portal, Power Automate, Power Apps (basic exposure), SSAS (Tabular Model), Visual Studio, ServiceNow (basic)

Timeline

Sr. Power BI Developer

Eli Lilly and Company
08.2023 - Current

Power BI Developer

Inovalon Holdings, Inc
01.2020 - 08.2023

Power BI Developer

Verana Health
09.2018 - 11.2019

SSRS/ Power BI Developer

Navistar Inc
07.2017 - 08.2018

Junior BI Developer

Pycube
11.2015 - 07.2017

Bachelor’s - computer science

JNTU

Masters - computer science

SFBU

Similar Profiles

CREATE PROFILE