Post Job Free

Resume

Sign in

Power Bi Sql Server

Location:
Nashua, NH, 03062
Posted:
October 05, 2023

Contact this candidate

Resume:

Kv. Subba Reddy

Power BI Developer

+1-978-***-**** adz6pn@r.postjobfree.com / LinkedIn

Summary

With over 7 years of diverse and accomplished experience in the realm of IT, I am a seasoned and highly skilled Power BI Developer. My career has been marked by a continuous commitment to excellence in data analysis, BI development, and data security. Adept at clear client communication and meticulous documentation, I have successfully reduced misunderstandings by 25%, ensuring seamless project alignment. My expertise in SQL optimization has consistently delivered a 25% improvement in query efficiency, facilitating rapid access to critical information. In the realm of data visualization and analysis, I have harnessed the power of Power BI to enhance data insights by an impressive 20%, empowering organizations with valuable insights. My professional journey has been defined by robust analytical and communication skills, both as a self-reliant contributor and a collaborative team player. My unwavering commitment to excellence positions me as a formidable asset ready to excel in any data-focused role.

Skills

Reporting Tools: Power BI Desktop (2.68), Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop. SQL Server Analysis Services (SSIS), Azure Data Factory

ETL Tools: SQL Server Integration Services (SSIS)

Databases: MS SQL server 2014/16, Azure SQL DB

Operating System: Windows, UNIX, Mac OS

Languages: C, C++, SQL, PL/SQL, T-SQL, R

Experience

POWER BI DEVELOPER 01/2023 - Current

Meduit - Charlotte, NC

Diligently analyzed complex datasets, resulting in a significant 20% reduction in data errors. Proactively initiated data quality improvement measures.

Collaborated closely with business users to analyze their requirements and translate them into precise technical specifications, reducing communication gaps by 15%.

Demonstrated proficiency by creating and managing a diverse portfolio of over 50 Power BI reports, utilizing the SSAS Tabular Model for enhanced data analysis.

Crafted tailored visualizations, including Stacked Bar Charts, Scatter Charts, and more, resulting in a 30% improvement in data comprehension and actionable insights.

Implemented dynamic filtering options, including Page Level Filters, Report Level Filters, and Visual Level Filters, driving a 40% increase in user engagement and interaction with reports.

Implemented dynamic filtering options, including Page Level Filters, Report Level Filters, and Visual Level Filters, driving a 40% increase in user engagement and interaction with reports.

Hands-on experience in utilizing DAX functions, including Aggregation, Counting, Logical, Information, Text and Date Functions.

Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATED TABLE.

Created complex DAX formulas for calculated columns, measures, and calculated tables to perform data transformations, calculations, and aggregations.

Successfully led the end-to-end maintenance and delivery of scheduled releases, consistently achieving a 100% on-time delivery rate, and ensuring timely access to critical data.

Leveraged expertise in SQL and SSIS to streamline data processing, resulting in a 20% improvement in data-driven decision-making across the organization, enhancing overall efficiency and accuracy.

POWER BI DEVELOPER 08/2018 - 11/2021

Accord Solutions PVT LTD - India

Designed and implemented ETL processes, resulting in a substantial 30% reduction in data retrieval time, improving overall data processing efficiency.

Developed and deployed SSIS packages, achieving a remarkable 40% improvement in automation efficiency, reducing manual intervention and errors.

Proactively optimized query performance, leading to a significant 20% reduction in report execution time, ensuring faster access to critical data for decision-making.

Automated File Transfer Processes and email notifications, successfully reducing manual effort by an impressive 50%, enhancing operational efficiency.

Developed custom DAX measures to meet specific business requirements such as creating Key Performance Indicators (KPIs) and aggregations.

Used DAX functions for data cleaning, transformation, and data enrichment, ensuring high data quality for reporting.

Optimized DAX calculations by reducing model size and utilizing best practices for efficient data processing.

Implemented robust error handling mechanisms, resulting in an outstanding 90% reduction in errors during data processing, ensuring data accuracy and reliability.

Demonstrated expertise in data migration by designing high-performance ETL packages, achieving a remarkable 30% increase in data migration speed, and expediting data transfers.

Leveraged advanced Power BI visualizations, enhancing data understanding and facilitating informed decision-making, leading to data-driven insights that drove 90% of business improvements.

Efficiently managed report subscriptions and scheduled SSRS reports, consistently achieving on-time delivery rate, ensuring stakeholders received timely insights.

SQL/ BI DEVELOPER 06/2015 - 07/2018

Northeast Systems PVT LTD - India

Developed and maintained clear technical specification documents for clients, reducing project misunderstandings by 25% and ensuring seamless alignment with project goals.

Demonstrated expertise in developing reports using Microsoft BI tools, including SSIS and SSRS, resulting in a 30% increase in reporting efficiency.

Leveraged Power BI to create custom columns and implement effective filters, leading to a 40% improvement in data analysis capabilities and data insights.

Applied a wide range of Power BI visualizations, including line charts, pie charts, and maps, resulting in a 45% enhancement in data presentation and understanding.

Developed complex SQL queries that improved data retrieval efficiency by 25%, allowing for quicker access to critical information and reports.

Proactively resolved performance issues, leading to a significant 30% enhancement in database performance, ensuring smoother operations and reduced downtime.

Crafted visually rich Tableau dashboards for executives, increasing data-driven insights by an impressive 50%, thereby aiding in more informed and data-backed decision-making.

Played a pivotal role in data modelling using Erwin, ensuring data integrity through T-SQL triggers, contributing to a 20% reduction in data discrepancies and enhancing data quality.

Environment

T-SQL, MS SQL Server 2012/2014/2016/2019, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Tableau, SQL Server Analysis Services (SSAS), Visual Studio 2013/2015/2017/2019, OLAP, Microsoft Power BI 2.68/3.0, SSIS, SQL Server 2016/2017/2019, Azure SQL Database, Azure Data Factory, Data Warehousing.

T-SQL, MS SQL Server 2012/2014/2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Tableau, SQL Server Analysis Services (SSAS), Visual Studio 2013/2015/2017, OLAP, Microsoft Power BI 2.68/3.0, SSIS, SQL Server 2016/2017, Azure SQL Database, Azure Data Factory.



Contact this candidate