Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic

Harshal Khairnar

Pune

Summary

Experienced Power BI developer with 4 years of expertise in managing end-to-end Power BI projects, including gathering requirements, preparing BRDs, and performing ETL operations. Proficient in data modeling and establishing relationships between tables, writing DAX measures, and utilizing tools like JSON themes, Bravo, and DAX Studio to enhance project outcomes.

Overview

4
4
years of professional experience
1
1
Certification

Work History

BI Developer

Kale logistics Solutions
Pune
06.2023 - Current
  • Responsible for managing end-to-end Power BI projects, including gathering requirements, preparing BRDs, and performing ETL operations.
  • Proficient in data modeling and establishing relationships between tables, writing DAX measures, and utilizing tools like JSON themes, Bravo, and DAX Studio to enhance project outcomes.

Assistant BI Developer

Torm Shipping India
Mumbai
02.2023 - 05.2023
  • Worked as an Assistant BI Developer, setting up gateways and RLS. Experienced with Power BI Service administration, including workspace management, sharing dashboards, and ensuring data security

Power BI Developer

Maestro Intellect
Pune
09.2020 - 02.2023
  • Collaborated with junior team members on a migration project, converting MicroStrategy reports to Power BI reports.
  • item Integrated Power Apps and Power BI using Microsoft databases for a BMC project dataset, and created reports using Iframe view in Power BI

Education

MBA - Project Engineering Manangement

NICMAR University
Pune
04-2021

Bachelor of Engineering - Mechanical

Sinhgad Institue Of Technology
Lonavala
06-2018

Skills

  • Predictive Analytics
  • Data Quality Management
  • Project management
  • Problem-solving abilities
  • Data preparation
  • Identifying key performance indicators (KPIs)
  • SQL
  • Report Design
  • Power BI
  • ETL
  • DAX

Projects

GMR Tonnage

  • Developed the GMR Air Cargo Tonnage dashboard, utilizing data sources such as SQL databases and SharePoint lists.
  • Applied RLS to ensure secure data access and configured daily data refreshes. Implemented a subscription feature to automatically email daily reviews.
  • The dashboard not only tracked cargo tonnage but also displayed adoption rates. Created multiple bookmarks and page navigators for enhanced user experience, maintained a star schema, and worked deeply on data modeling to ensure efficient data organization and retrieval

Adani Revenue

  • Developed a Power BI report focused on revenue analysis.
  • Created MTD, YTD, and QTD visuals to track performance over different time periods. Designed visuals for budget vs. actual revenue comparison to monitor financial goals.
  • Incorporated key revenue KPIs to provide insights into business performance. Utilized SQL database as the primary data source for accurate and up-to-date information.
  • Developed a comprehensive Power BI dashboard and created an accompanying app for streamlined access..

Certification

  • Microsoft Certified: Power BI Data Analyst Associate
  • Microsoft Certified: Azure Fundamentals
  • Power BI Training by Intellipaat

Timeline

BI Developer

Kale logistics Solutions
06.2023 - Current

Assistant BI Developer

Torm Shipping India
02.2023 - 05.2023

Power BI Developer

Maestro Intellect
09.2020 - 02.2023

MBA - Project Engineering Manangement

NICMAR University

Bachelor of Engineering - Mechanical

Sinhgad Institue Of Technology
Harshal Khairnar