Power Bi Developer

Akshay Kharate

**************@*****.*** +91-845******* linkedin.com/in/akshay-kharate-063067227 Professional Summary:

Power BI Developer with 3.2 years of hands-on experience in designing, developing, and deploying interactive dashboards and business intelligence solutions. Proven expertise in transforming complex datasets into actionable insights across domains such as Insurance and Banking. Skilled in MySQL, Snowflake, DAX, Power Query, and data modeling, with a strong focus on performance optimization and user-centric design. Experience:

Project 1: Hive Snowflake Migration for Power BI Reporting Technology Analyst Infosys Ltd Pune December 2024- Present

• Led Migration of Power BI reports from Hive to Snowflake ensuring seamless transition and validation.

• Established and validated Snowflake database connections within Power BI.

• Converted Hive SQL queries to Snowflake-compatible SQL syntax, trained AI model reduced manual effort by 90%.

• Ensured compatibility by executing transformed queries in Snowflake and validating results.

• Updated visualizations and data models to reflect Snowflake’s schema.

• Applied necessary filters and transformations to match the original Hive report behavior.

• Verified that all data transformations, filters, and visualizations work as expected after migration.

• Ensured the report is fully functional and aligned with business requirements. Project 2: Insurance claims and employee queries analytics dashboards. Technology Analyst Infosys Ltd Pune Aug 2023 - Dec 2024

• Collaborated with stakeholders to gather reporting requirements and define KPIs, translating business needs into actionable BI specifications.

• Executed ETL using Power Query from diverse sources such as SQL Server, Excel, SharePoint.

• Transformed and imported structured data from Excel into SQL Server databases.

• Developed efficient data models with relationships, hierarchies, and calculated columns.

• Implemented advanced DAX for dynamic calculations and KPIs.

• Designed and maintained interactive Power BI reports with drill-downs, slicers, and drop- down menus.

• Created rich visualizations using bar, line, pie, donut, map, matrix, and table visuals.

• Published reports to Power BI Service, configured scheduled data refreshes, and implemented row-level security (RLS).

Project 3: ServiceNow Ticket Performance Insights

Data Analyst Infosys Ltd Pune June 2022- July 2023

• Built Power BI reports using ServiceNow data Excel exports.

• Designed star schema models with fact tables and dimension tables.

• Cleaned and transformed data using Power Query for consistency and accuracy.

• Created dynamic KPIs using DAX measures.

• Published reports to Power BI Service and ensured scheduled refreshes and access control.

• Updated visualizations and schema mappings during data source migrations.

• Collaborated with IT managers and support leads to understand reporting needs and resolve issues.

• Provided ongoing support for report enhancements, bug fixes, and performance optimization.

Education:

Master of Engineering Shri Sant Gajanan Maharaj College of Engineering, Shegaon 2016 - 2018 Bachelor of Engineering Sant Gadge Baba Amravati University, Amravati 2010 - 2015

Contact this candidate