Power Bi/Data Analyst

Keshav Bhise

Pune, India +91-916******* **************@*****.*** LinkedIn

Professional Summary-

Result-driven Data Analyst with 6.3 years of experience in Business Intelligence and Data Reporting. Skilled in Power BI, SQL, and data transformation with a strong background in retail analytics. Delivered 10+ end- to-end dashboards driving actionable insights. Expert in designing data models, DAX measures, and KPI dashboards with a focus on business impact and performance optimization. Technical Skills-

BI Tools- Power BI (Desktop, Service, Report Builder), Power Query, Power BI Dataflows. Data Sources- SQL Server, Snowflake, Azure Data Factory, Big Query, SharePoint, Excel. Environment: Power BI Desktop, Power BI Service, SQL Server, Power Automate, Paginated Reports, Excel, ETL.

Methodologies: Agile, UT and UAT Testing, Data Modelling, Data Visualization Best Practices. Experience-

Quality Analyst in Data Reporting Everseen Infotech India Pvt. Ltd. Pune July 2023 - March 2025

- Led reporting and analysis of strategic KPIs using Power BI and SQL.

- Conducted UAT, unit testing of DAX measures, and validated business rules.

- Collaborated with cross-functional teams for dashboard development and optimization.

- Trained end-users and provided self-service reporting capabilities. Data Analyst Everseen Infotech India Pvt. Ltd. Pune Dec 2018 - July 2023

- Cleaned, transformed, and modelled large datasets using SQL and Power BI.

- Designed 10+ dashboards with real-time and historical analytics.

- Supported finance, operations, and supply chain with ad-hoc analysis and reporting.

- Designed and automated interactive dashboards for multiple retail clients. Projects-

Client- Walmart (US)

Project- Sales and Profit Performance Dashboard

Objective Developed an interactive dashboard for tracking sales, profit margins, and category trends. Tools - Power BI, SQL Server, Big Query

Roles and Responsibilities-

-Gathering requirements from business stakeholders and retail analytics team.

-Extracting data from SQL Server and Big Query sources.

-Data cleaning and transformations using Power Query to handle missing values, date formats.

-Data modeling in Power BI used Star Schema for better performance.

-Calculated DAX measures for QTD, YTD, YoY growth.

-Developed charts like bar chart, line chart, pie chart, slicers.

-Implemented row level security for region specific access.

-Published and deployed report to Power BI Service with scheduled refresh and data alerts. Client- Kroger (US)

Project- In Store Operational Efficiency and Loss Prevention Analytics Objective- Identified non-scan and cart-based loss patterns to improve operational efficiency. Tools- Power BI, Azure SQL, SharePoint

Roles and Responsibilities-

-Extracting Data from Azure SQL and SharePoint sources.

-Perform data cleaning and transformations on missing values, scan logs and non-scan events.

-Created one-to-many relationships and build data model using star-schema.

-Developed DAX measures to compute Loss% per store, Loss per basket and cart.

-Built drill-through pages for store managers to view loss events.

-Created custom visuals for Loss Pattern Heatmaps and Trendlines.

-Published dashboard to Power BI workspace and embedded in SharePoint. Client- Ahold Delhaize (Europe)

Project- Loss Recovery at SCO and Staffed Checkout Objective- Analyzed scan behaviour and voided transactions to identify checkout-based losses. Tools- Power BI, Snowflake, SQL Server

Roles and Responsibilities-

-Collaborated with loss prevention and operations teams to gather business requirements.

-Extracted data from Snowflake and SQL Server to integrate and transform data.

-Built star-schema for better performance.

-Built DAX measures to calculate loss per basket, scan accuracy, recovery%, and void rate.

-Designed custom visuals including heatmaps, comparative bar charts (SCO vs Staffed), and interactive drill-throughs to transaction-level details.

-Published report to Power BI Service with weekly scheduled refresh. Education-

Bachelor of Science Shivaji University, Kolhapur 2017 Certifications-

Mastering Power BI by Skillsoft.

Contact this candidate