YOUR
PRODUCT
PARTNERS
YPP
top of page
Download CV

Power BI, Power Query, Power Pivot, DAX formulas, Power Automat, MS-SQL, Excel

true

AK

Anuj K.

Mid

Mid

Power BI Developer

* Zero Evaluation Fee

Summary
Technical Skills
Projects Worked On
Anuj K.
00:00 / 00:42
Anuj K.
00:00 / 01:04
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.
Social Share

How it Works

KNOW

SEND

LIKE

SEND

ON BOARD

How it Works

1.

SEND

2.

MATCH

3.

TRIAL

4.

ON BOARD

icons8-speech-to-text-90.png
Whatsapp
bottom of page