Summary

• Having 4+ years of experience in Business Intelligence and Data Analytics.
• As a Power BI Developer, I am a skilled professional with expertise in designing and implementing business intelligence solutions using Microsoft Power BI and Power Bi Report Builder.
• I possess a strong background in data analysis, data visualization, and data modeling, allowing me to transform complex datasets into insightful reports and dashboards.
• With proficiency in querying databases and extracting meaningful insights from data, I excel in delivering actionable information to help organizations make informed decisions.
• I am adept at collaborating with cross-functional teams, communicating technical concepts effectively to stakeholders, and continuously enhancing my skills to stay updated with the latest industry trends.

Professional Expertise

• Worked on Power BI development of reports. Good exposure to Power BI, used different DAX's, Power Query, Power pivot, visualizations to create reports as per client requirements.
• Worked on Power BI transformations that are available in the Power BI query editor Investigate new technologies, tools, and processes and Make recommendations for adoption.
• Contribute to the design and development of application features.
• Proficient in writing complex DAX formulas for data manipulation and calculations.
• Ability to analyze large datasets to extract meaningful insights and trends.
• Understanding of BI concepts and how to apply them to support data-driven decision-making.
• Ability to work effectively in cross-functional teams.
• Proficient in Power BI, Power Automate, SSRS, BI Report Builder, SQL Server, and MS Excel with a strong command of Power Apps.
• Expertise in Creating Paginated reports and connect to Power BI dashboard using Drill though Function to export the data more than 150000 rows

Technical Skills

• Power BI Desktop
• MS-SQL
• Excel
• Power BI Report Builder
• Power Apps
• Power Automate
• DAX
• Power Query
• Power Pivot

Work Experience

Role: Power BI Developer

Time Period: 20 Jan 2020 – 15 Jan 2023
Domain: Pharma
Tools: Power BI

Responsibilities:

• Experience for analyzing the data and creating dashboard on the project
• Imported data from MS Excel, Web API, PDF, CSV and SQL Server to Power BI to generate reports.
• Performed data transformation for required information.
• Implemented conditional formatting in the report.
• Implemented different types of filters visual, page level and report level.
• Build custom master calendar table, used it in the report.
• Used DAX function like Aggregate function, Time intelligent function, Filter function etc.
• Perform RLS for the report.
• Apply Incremental Refreshed On the Report.

 

Role: Power BI Developer

Time Period: 09 Feb 2023 – 31 Oct 2024
Domain: Healthcare
Tools: Power BI, SQL, Power BI Report Builder, Power Apps, power Automate
Responsibilities:

• Imported data from MS Excel, SQL-Server CSV to Power BI to generate reports.
• Performed data transformation and Data Profiling for required information.
• Implemented conditional formatting in the report.
• Implemented different types of filters visual, page level and report level and creating bookmarks for the report.
• Used DAX functions to create “measures” and “calculated columns”.
• Apply Incremental Refreshed On the Report.
• Used Power Apps to created Data-flows.
• Create Canvas App for the Time Tracker of the Team.
• Using Power BI Report Builder to create Paginated Reports.
• Apply Drill-Through Function on the paginated Report. So that we can download More than 30 thousand Row for the raw data.

Projects Worked On

ARMS (Ascent Revenue Management Service):
Client: United Urology Group, Healix, Armstrong, Concord, Spire, CVM and CVR.
Role: Power BI Developer.
Description: ARMS is a comprehensive platform that enables tracking and analysis of client-specific revenue, denials and employee production, allowing for actionable insights and tailored responses based on client requirements.
Roles and Responsibilities:

• Created and Managed for 10 client-specific BI Dashboards, including Inventory Summary, Allocation Summary, Production Summary, Denial Summary, Touch Count Summary, Forecast for Next 3 Months, Routing Report, Inflow/Rollover Summary, and Manager PPA.
• Created Calculated Columns and Measures based on Requirements.
• Created and optimized SQL Server views and queries to support dashboard data.
• Fixed bugs and improved data accuracy over time.
• Published dashboards to Power BI Service, connected to gateways, and scheduled data refreshes.
• Embedded dashboards into the website using REST API, ensuring seamless integration and real-time data updates.

Power Automate & Paginated Reports:
Client: UUG, Healix, Spire, Concord, Armstrong
Role: Power BI Automate, Data analyst, Power BI Report Builder
Description: Using Power Automate, need to gather the data from client server to local server from 3 distinct locations as it is daily work.
Roles and Responsibilities:

• Using power Automate, worked to transfer the data from client FTP server to local storage in Power Automate Desktop flows.
• Worked to download the data from Client Website to local storage using UI elements and image filters.
• Worked to download the data from RDP server to our local Server.
• Created Variables, UI elements, Loop functions
• Worked on scheduling time for workflow by importing the desktop flow in scheduling cloud flow.