Summary
Overview
Work History
Education
Skills
Title
Education Certifications
Certification
Power BI Projects
Work Preference
Timeline
Generic
Open To Work
Verified
This profile is verified using an email address.

PAVAN V

Bangalore

Summary

Power BI Developer with 3+ years of experience in end-to-end BI solution development including requirement gathering, data modeling, DAX calculations, and Power BI Service deployment. Strong expertise in building high-performance dashboards using star schema, optimized DAX measures, and automated refresh pipelines. Proven experience in MIS automation, KPI reporting, and delivering executive-level insights across insurance, banking, and operations domains.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Associate Manager - MIS, Data Analytics & HR Operations

Axis Max Life Insurance Ltd.
Bangalore
09.2023 - 01.2025
  • MIS, Data Analytics & HR Operations
    Nov 2023 – Jan 2025
    Designed and developed 10+ interactive Power BI dashboards for sales performance, advisor productivity, branch KPIs, and leadership reporting.
  • Built optimized data models using star schema architecture, with fact and dimension tables.
    Created advanced DAX measures including MTD, YTD, YoY growth %, incentive calculations, productivity ratios, and variance analysis.
  • Optimized Power BI report performance by improving data model design and reducing high-cardinality fields and unnecessary columns.
  • Automated weekly and monthly MIS reports, reducing manual effort by 35% and improving reporting accuracy.
    Implemented Power BI Service deployment, scheduled refresh, gateway connectivity, and dataset management.
  • Developed HR analytics dashboards covering headcount, onboarding, attrition, attendance, incentives, and workforce productivity.
  • Supported UAT, post-deployment monitoring, and refresh failure resolution.
  • Collaborated with HR, Sales, and Operations stakeholders to gather business requirements and deliver actionable insights.

Closing Associate - MIS & Reporting

First Source Solutions
Bangalore
01.2021 - 09.2022
  • Prepared daily and monthly MIS reports for productivity, SLA, and quality performance metrics.
  • Cleaned and validated large operational datasets to improve reporting accuracy by 15%.
  • Supported leadership teams with dashboard insights and performance trend analysis.
  • Coordinated with US-based stakeholders to resolve data discrepancies and reporting issues.

Relationship Manager - MIS & Sales Analytics

Kotak Mahindra Bank
Bangalore
11.2019 - 12.2020
  • Developed branch-level MIS dashboards and sales performance reports.
  • Analyzed customer data and sales trends to improve cross-selling opportunities by 20%.
  • Delivered portfolio insights and business performance summaries to senior management.

Education

Bachelor of Commerce (B.Com) -

National College
Jayanagar, Bangalore

Diploma - Computer Applications

Swamy Vivekananda Institute
BOMMANAHALLI, Bangalore

Skills

  • Power BI
  • BI tools
  • Power BI Desktop
  • Power BI service
  • Data modeling
  • Star schema
  • DAX
  • MTD
  • YTD
  • YoY growth
  • Variance analysis
  • Power Query
  • ETL
  • Row level security
  • RLS
  • Scheduled refresh
  • Gateway dashboard deployment
  • Workspace management
  • Data
  • Reporting
  • Data cleaning
  • Data transformation
  • Mis reporting
  • Automation
  • KPI
  • Performance tracking
  • Data warehousing concepts
  • SQL
  • Excel
  • Basic queries
  • Joins
  • Views
  • Data extraction
  • Advanced Excel
  • Pivot tables
  • Lookups
  • Dashboards
  • CRM systems
  • Operational databases
  • MS Office Suite
  • Business intelligence
  • Data visualization
  • Dashboard development
  • Performance reporting
  • KPI tracking
  • Data analysis
  • Insights generation
  • Stakeholder communication
  • Process automation
  • Process optimization
  • Business requirements gathering
  • Decision support analytics

Title

Education Certifications

  • Bachelor of Commerce (B.Com), National College, Jayanagar (Autonomous)
  • Diploma - Computer Applications, Swamy Vivekananda Institute
  • Data Analytics, IRA EDU Skills

Certification

Microsoft PL-300: Power BI Data Analyst — In Progress

Power BI Projects

  • Sales performance dashboard: Built an end-to-end Power BI dashboard using star schema and DAX time intelligence to track year-over-year growth, target versus achievement, and regional performance.
  • HR analytics dashboard: designed headcount, attrition, and attendance dashboards with automated refresh and role-based access using RLS

Work Preference

Job Search Status

Open to work

Salary Range

₹800000/yr - ₹1000000/yr

Timeline

Associate Manager - MIS, Data Analytics & HR Operations

Axis Max Life Insurance Ltd.
09.2023 - 01.2025

Closing Associate - MIS & Reporting

First Source Solutions
01.2021 - 09.2022

Relationship Manager - MIS & Sales Analytics

Kotak Mahindra Bank
11.2019 - 12.2020

Bachelor of Commerce (B.Com) -

National College

Diploma - Computer Applications

Swamy Vivekananda Institute
PAVAN V