AKSHAY BODKE
POWER BI DEVELOPER
Email: *************@*****.***
Mobile: +91-957*******
Professional Summary
3.6 years of experience analyzing source documents and creating ETL packages to move data
from various sources to destinations.
Expertise in creating Power BI dashbords and reports, data cleaning and transformations,
advanced DAX, and publishing and collaboration workflows.
Experienced in connecting Power BI to various data sources such as SQL database, EXCEL,
cloud services, and APIs to centralize and harmonize data.
Proficient in Power BI report creation including Matrix, Drilldown, Drill-through, and Sub
Reports.
Experience in scheduling Power BI reports based on weekly/monthly client requirements.
Expertise in writing complex DAX formulas to implement advanced calculations,KPIs,and metrics
that align with business objectives.
Strong command over SQL Server including Joins, Views, Indexes, Stored Procedures,
Functions, and performance tuning.
Experience in working with sub-queries, CTEs, temporary tables, triggers, and advanced T-SQL
programming.
Well-versed in implementing error handling and transaction control in SQL.
Learning Japanese Language and I have Certified N3 Level in Japanese language.
Technical Expertise
Category Tools/Technologies
Operating Systems Windows 8, 9, 10, 11
Database Tools MS-SQL Server 2012,
2016
Reporting Tools Power BI (2012, 2016)
Language N3 level certified in
Japanese Language
Education
BE (Electronics & Telecommunication) – 2019
Pune University
Professional Experience
Company: Cognizant
Designation: Power BI Developer
Duration: mar 2022 – Present
1 of 3
Roles & Responsibilities:
Design and develop interactive and insightful dashboards and reports using Power BI to meet
client business needs.
Collaborate with business analysts and stakeholders to gather and translate requirements into
technical specifications.
Perform data extraction, transformation, and loading (ETL) using SQL Server and SSIS
packages.
Create custom DAX expressions and measures to calculate key performance indicators and
metrics.
Design user-friendly visualizations including KPIs, heat maps, bar/line charts, tables, and matrix
reports.
Implement report interactivity using slicers, drill-throughs, filters, bookmarks, and dynamic
visuals.
Schedule and automate report refreshes and subscriptions as per client schedules
(weekly/monthly).
Conduct performance tuning and optimization of SQL queries and DAX calculations.
Perform report testing, validation, and troubleshooting to ensure data integrity and accuracy.
Collaborate with cross-functional teams including DBAs, testers, and deployment teams for
smooth delivery.
Projects
Project 01: Data Quality Analysis and Reporting in Power BI
Client: DeltaCore Solutions Inc.
Industry: Data Services / Business Analytics
Objective: To monitor and visualize data quality metrics such as completeness, consistency, accuracy,
and timeliness for business-critical applications.
Responsibilities:
Designed Power BI dashboards to track key data quality KPIs across departments.
Developed custom DAX measures to identify and monitor missing values, duplicates, and data
inconsistencies.
Implemented drill-down and drill-through functionality to allow data analysts to perform
granular root-cause analysis.
Conducted report testing, validation, and optimization to ensure real-time insights and accuracy.
Project 02: Healthcare Analytics and Reporting with Power BI
Client: Medivia Health Systems.
Industry: Healthcare / Hospital Network
Objective: To provide detailed analytics on healthcare operations, patient demographics, clinical
outcomes, and financial performance.
Responsibilities:
Developed comprehensive Power BI dashboards to monitor hospital KPIs such as readmission
rate, bed occupancy, treatment cost, and staff utilization.
Designed and implemented healthcare-specific metrics using DAX (e.g., average length of stay,
recovery rate, operational efficiency).
2 of 3
Created intuitive visualizations (KPIs, pie charts, line graphs) for medical administrators and
clinicians.
Enabled interactivity using slicers, filters, and dynamic bookmarks for better operational
decision-making.
Personal Details
Date of Birth: 28 June 1995
Nationality: Indian
Gender: Male
Marital Status: Unmarried
Present Address: Pune
Languages Known: English, Hindi, Marathi, Japanese (JLPT N3 Certified)
Declaration
I hereby declare that the above-mentioned information is correct to the best of my knowledge and belief.
Akshay Bodke
3 of 3