Power Bi Sql Server

Venkatesh

Power BI Developer

ad5dqn@r.postjobfree.com 405-***-****

OBJECTIVE:

To become a successful professional in a highly competitive technological world where performance is rewarded with new challenging responsibilities and to serve a reputed growth-oriented industry in the field of Design, Development and Maintenance.

SUMMARY:

Having Around 5 years of experience in the IT Industry and 4 years relevant in Microsoft Power BI development. Involved in BI projects with extensive usage of reporting tools like Power BI desktop, Power BI service with SQL Server and Azure Data Factory.

Extensive experience in all the modules of Power BI (Power Query, Power Pivot, Power View, Power BI Service, Power Apps).

Working with Power BI report fetching data from sources like MS Excel, SQL Server, Azure, and other sources.

Created Rich visualized Pie & Line Charts, tree maps, Tabular and Matrix Reports and custom visuals Using Power BI.

Experience in gathering and translating end user requirements into effective and efficient PBIX reports and dashboards.

Writing SQL queries based on requirement and add filters as much as possible in querying and bringing data to Power BI.

Hands on experience in with Power BI Desktop and Designed Power BI data visualization Utilizing Tables, Drilldown, Drill through, Buttons, Bookmarks and tooltip page etc.

Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text.

Involved in implementing RLS.

Creating customized query in to view and connect that view from Power BI for Snowflake database.

Imported data from multiple data sources into BI Tools, created relationships between data.

Creating Calculated columns and measures using DAX.

Develop Visuals from both Power BI and SSIS/SSRS.

Develop Power BI PBIX reports, Custom Visuals, Groups Creation and effective dashboards, KPI Scorecards after gathering Client requirements.

Experience in implementing Row level security both Static and Dynamic.

Experience in creating different visualizations like line, bar, Stacked Bar Charts, scatter, waterfall, filled maps, tree maps, Funnel etc.

Involved in unit testing like functionality testing and data validation.

Experience in creating Dashboards over datasets and multiple reports and refreshing them using Data Gateway.

Able to handle Admin Activities in Power BI.

Can improve performance by minimizing data from Query level and removing unused columns and can monitor visuals with Performance Analyzer.

Independently perform troubleshooting, root-cause analysis.

Grasping new technical concepts quickly and utilize the same in a productive manner.

Technical Skills:

Domain: Health, Banking, Finance

Technologies: Microsoft Power BI, DAX, Tabular editor Power Apps, MYSQL, Snowflake DB, SQL, HTML, CSS

Tools: Power BI Desktop, DAX Studio, Power Automate, Share Point, Service-now, ERP (6.0) Azure DEVOPS, Tabular Edito

Cloud Services: Azure Data Factory

Operating System: Windows 7/8/8.1/10/11

PROFESSIONAL EXPERIENCE:

Client : AgFirst, Columbia - Jan 2023 – Till Date

Role : Power BI Developer with ADF

.

Roles and Responsibilities:

Gathering the requirements from the Business users and Participated in Requirement Meetings for understanding the functionality & business rules.

Utilized the Power Query in Power Bi for performing data transformations, data cleaning, data modeling, conditional columns, append and merge operations as per business needs.

Develop best practices for database design and development activities.

Used POWER BI Filter like visual Level filters, page level filters.

Used Slicers for Quick filters, Generated Report Level filters while handling huge volumes of data.

Created calculated columns, calculated measures and quick measures in Power BI Desktop by using DAX.

Experience in creating different visualizations using Bars, Lines and Pies, Maps Highlight tables, Matrix and Custom visuals based on business Requirement.

Generated Dashboards for different modules.

Involved creating effective reports, dashboards, and publishing into Power bi service.

Executed and tested required queries and reports before publishing the reports.

Visualize data, author reports, and schedule automated refresh of reports.

Building, publishing customized interactive reports and dashboards, report scheduling using Power BI services and we have published the reports into Power BI services.

Environment: Power query, DAX Studio, Power bi services, Power bi Desktop, Power bi Filters, SSMS, Power Pivot, PBIX Reports, MS Excel, Power View, Slicers, SSRS, RLS, Tabular Edito.

Client : Humana, Louisville - May 2021 to July 2022

Role : Power BI Developer with ADF

Roles and Responsibilities:

Collaborate with stakeholders from different departments within the bank to understand their reporting needs, key performance indicators (KPIs), and data analysis requirements.

Identify and integrate relevant data sources from the bank's databases, including transactional data, customer information, account details, loan data, and more. Design and implement efficient data models in Power BI to support complex analytical queries.

Perform data cleansing and transformation to ensure data accuracy, consistency, and compatibility with the Power BI platform.

Create visually appealing and interactive dashboards using Power BI that present complex data in a clear and intuitive manner. Develop data visualizations, charts, graphs, and tables to effectively communicate insights.

Implement appropriate security measures to protect sensitive banking data and ensure compliance with data privacy regulations.

Set up automated data refresh processes to keep the dashboard up to date with the latest information from the bank's systems. Ensure that the data refresh is reliable and timely.

Conduct rigorous testing of the Power BI reports and dashboards to identify and resolve any issues, ensuring that the data and visualizations are accurate and aligned with business requirements.

Environment: Power BI Platform, Power query, DAX Studio, Power bi services, Power bi Desktop, Power bi Filters, SSMS, Power Pivot, PBIX Reports, MS Excel, Power View, Slicers, Azure Data Factory, Tabular Edito.

Client : DXC Technology, India - May 2019 to April 2021

Role : BI Developer

Roles and Responsibilities:

Gathering the requirements from the Business users and Participated in Requirement Meetings for understanding the functionality & business rules.

Extracting data from multiple sources like Excel and validating data and loading it into Final Destination.

Good Experience on Power Query, Power pivot and DAX functions.

Creating a drill down and drill through reports.

Created charts like Lines, Pies, Bar, Scatter, Area, Tree map, Map, filled map, Gauge, Funnel, Single Card, Multi row card, Slicer etc.

Importing Custom Visuals from Microsoft Power Bi gallery as per client request.

Have good Experience to Implement RLS as part of security.

Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text.

Updating weekly status and keeping track of overall development status for the project.

Generated Dashboards for different modules.

Created Relationships for Customer Data and created reports.

Building, publishing customized interactive reports and dashboards, report scheduling using Power BI services and we have published the reports into Power BI services.

Environment: Power BI Platform, Power query, DAX Studio, Power bi services, Power bi Desktop, Power bi Filters, SSMS, Power Pivot, PBIX Reports, MS Excel, Power View, Slicers, Data & Time Functions, Implement RLS,Tabular Edito.

EDUCATIONAL DETAILS:

Master of Science Engineering from Oklahoma Christian University.

Bachelors of Electronics and Communication Engineering from Qis Institute Of Technology.

Contact this candidate