Summary
Overview
Work History
Education
Skills
Projects
Languages
Core Skills
Timeline
Generic

Akshay Mogarkar

Pune

Summary

Business Intelligence Analyst with 3.5+ years of experience in Power BI, Azure SQL, ETL, and business analysis. Skilled in data extraction, cleansing, transformation, and visualization to deliver actionable insights. Strong background in data modeling, KPI tracking, and reporting automation. Adept at working as an individual contributor, collaborating with stakeholders, and driving business value through analytics and BI solutions.

Overview

7
7
years of professional experience

Work History

Business Intelligence Analyst (Power BI Developer)

Pine Labs
Pune
07.2024 - 07.2025
  • Developed Power BI dashboards from POS & transaction data, improving financial reporting accuracy.
  • Built ETL pipelines (SSIS, SQL Server, Azure SQL) for automated reporting and real-time analytics.
  • Applied data profiling & cleansing to ensure accuracy in large datasets.
  • Partnered with stakeholders to deliver transaction insights & business KPIs supporting management decisions.
  • Monitored BI analytics results, validated data, and enhanced methodologies for anomaly detection.

BI Analyst (Power BI Developer)

Paytm
Pune
05.2023 - 04.2024
  • Designed & deployed real-time merchant dashboards using Power BI & Azure SQL.
  • Wrote complex SQL queries & optimized stored procedures for high-performance reporting.
  • Automated KYC & transaction analytics, reducing manual workload by 50%.
  • Conducted data analysis & anomaly detection to improve loan & payment monitoring.
  • Worked closely with IT teams on deployment & system optimization for BI reporting.

SQL & BI Analyst

Nobrokerhood
Pune
02.2022 - 04.2023
  • Developed BI dashboards for visitor management & online payment tracking.
  • Performed data cleansing, profiling, and validation to ensure report accuracy.
  • Improved reporting efficiency by 25% through automation & SQL optimization.
  • Collaborated with business teams for requirement gathering & reporting insights.

MIS & Reporting Analyst

Aassanjobs Pvt Ltd
Amravati
12.2018 - 07.2020
  • Built Excel-based dashboards & automated daily POS performance reports.
  • Ensured data accuracy with SQL queries & validation checks.
  • Provided business reports & performance analytics for senior management.

Education

Bachelor of Engineering - Mechanical

SGBAU
Amravati
01.2018

Skills

  • MS Power BI (Advanced)
  • DAX
  • Power Query
  • Data Modeling
  • Azure SQL
  • MS SQL Server
  • SSIS
  • Data Cleansing
  • Data Profiling
  • Requirement Gathering
  • Stakeholder Management
  • KPI & Trend Analysis
  • Reporting Automation
  • SQL queries
  • Stored Procedures
  • Azure SQL Database
  • Excel (Advanced)
  • JIRA
  • Confluence
  • Python (Basic)
  • R (Basic)
  • Problem Solving
  • Critical Thinking
  • Communication (Verbal & Written)

Projects

POS Transaction Dashboards: Developed BI dashboards integrating SQL + APIs with Power BI. Real-Time Merchant Analytics: Built SQL + DAX models for transaction monitoring & KYC workflows. Payment & Visitor Insights: Automated data pipelines & dashboards to track operational KPIs.

Languages

  • English–Advanced
  • Hindi–Proficient
  • Marathi-Native

Core Skills

MS Power BI (Advanced), DAX, Power Query, Data Modeling, Azure SQL, MS SQL Server, SSIS (ETL packages with Visual Studio), Data Cleansing, Data Profiling, Requirement Gathering, Stakeholder Management, KPI & Trend Analysis, Reporting Automation, SQL queries, Stored Procedures, Azure SQL Database, Excel (Advanced), JIRA, Confluence, Python (Basic), R (Basic), Problem Solving, Critical Thinking, Communication (Verbal & Written)

Timeline

Business Intelligence Analyst (Power BI Developer)

Pine Labs
07.2024 - 07.2025

BI Analyst (Power BI Developer)

Paytm
05.2023 - 04.2024

SQL & BI Analyst

Nobrokerhood
02.2022 - 04.2023

MIS & Reporting Analyst

Aassanjobs Pvt Ltd
12.2018 - 07.2020

Bachelor of Engineering - Mechanical

SGBAU

Similar Profiles

CREATE PROFILE
Akshay Mogarkar