Summary
Overview
Work History
Education
Skills
Websites
Personal Information
Projects And Portfolio
Timeline
Generic

Abhay Dwivedi

Kanpur

Summary

Over 9.5 years of experience in data analytics, including 6+ years as a Power BI Developer at XL Dynamics India Pvt. Ltd. Designed and implemented over 50 interactive dashboards, significantly enhancing data visualization and user engagement. Proficient in DAX and SQL optimization, with a strong focus on automating reporting processes to improve efficiency. Conducted training sessions that increased user adoption and improved decision-making capabilities across teams.

Overview

9
9
years of professional experience

Work History

Power BI Developer

XL Dynamics India Pvt. Ltd.
04.2021 - Current
  • Designed & deployed 50+ interactive dashboards with optimized data models.
  • Created advanced DAX measures and implemented complex business logic.
  • Conducted end-user training sessions to drive adoption of BI solutions.
  • Automating reporting process.
  • Email automation using Power Automate.
  • Paginated reports using SSRS.
  • SQL Optimization.
  • Power BI Dashboards Optimization.

Senior MIS Executive

Creative Hitech Pvt. Ltd.
11.2020 - 04.2021
  • Automated reporting workflows using Power BI & Power Query.
  • Built real-time dashboards integrated with Google Sheets.
  • Designed visual reports supporting management decisions.

MIS Executive

VRS Foods Ltd.
11.2018 - 06.2020
  • Developed & automated MIS dashboards (daily, monthly, quarterly).
  • Built custom Power BI reports for sales & inventory.
  • Coordinated with cross-functional teams for data accuracy.

SAP Operator

Vinayak Clearing Agency
06.2016 - 01.2018
  • Maintained billing records and generated SAP reports.
  • Handled payment tracking & discrepancy resolution.

Education

B.Com -

Maharaja Agrasen Himalayan Garhwal University
Garhwal
01.2024

Intermediate - Maths

U.P. Board
Kanpur, Uttar Pradedsh
01.2010

High School - Maths

U.P. Board
Kanpur, Uttar Pradesh
01.2007

Skills

  • Power BI - DAX
  • Power BI - M code
  • Power BI – Dataflows
  • Power BI - ETL
  • Power BI - data modeling
  • Power BI - performance optimization
  • Power BI - RLS and advanced RLS
  • SSRS - paginated reports
  • SSRS - 3D visualization
  • SSRS - RLS
  • SSRS - User Friendly Reports
  • SQL Server - Joins
  • SQL Server - CTEs
  • SQL Server - query optimization
  • SQL Server - case statements
  • Power Automate – email automation
  • Power Automate - Data export/import
  • Power Automate: desktop automation
  • Power Automate - web scraping
  • Excel - Power Query
  • Excel - Power Pivot
  • Excel - pivot tables
  • Excel - charts
  • Excel - custom formulas

Personal Information

Title: Power BI Developer | Data & Reporting Professional

Projects And Portfolio

  • Airline Delay Analysis, 2015, Insights on flight delay trends using Power BI & advanced DAX., https://lnkd.in/eejtJDD8
  • Global Store Dashboard, Sales, profit & customer segmentation with interactive filters., https://lnkd.in/epDGJPnN
  • Sales Dashboard, Region/category/time-based breakdown with auto-refresh schedules., https://lnkd.in/e2dXNPsJ

Timeline

Power BI Developer

XL Dynamics India Pvt. Ltd.
04.2021 - Current

Senior MIS Executive

Creative Hitech Pvt. Ltd.
11.2020 - 04.2021

MIS Executive

VRS Foods Ltd.
11.2018 - 06.2020

SAP Operator

Vinayak Clearing Agency
06.2016 - 01.2018

B.Com -

Maharaja Agrasen Himalayan Garhwal University

Intermediate - Maths

U.P. Board

High School - Maths

U.P. Board
Abhay Dwivedi