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
Garhwal01.2024
Intermediate - Maths
U.P. Board
Kanpur, Uttar Pradedsh01.2010
High School - Maths
U.P. Board
Kanpur, Uttar Pradesh01.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
Similar Profiles
Freddy GeorgeFreddy George
Associate Analyst at XL Dynamics India Pvt. Ltd.Associate Analyst at XL Dynamics India Pvt. Ltd.
Aneesh DugarAneesh Dugar
Associate Analyst at XL Dynamics India Pvt. LtdAssociate Analyst at XL Dynamics India Pvt. Ltd
Ramnaresh KabraRamnaresh Kabra
Manager at XL Dynamics India Pvt. Ltd.Manager at XL Dynamics India Pvt. Ltd.
Dr Krishnapal Dr Krishnapal null
Emergency Medical Officer at Regency HealthEmergency Medical Officer at Regency Health
Pragya DwivediPragya Dwivedi
Assistant Manager at Aditya Birla Fashion And RetailAssistant Manager at Aditya Birla Fashion And Retail