Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Gaurav Maggu

Gaurav Maggu

BI Professional

Summary

I'm an experienced Power BI and Power Platform expert with over 8 years of hands-on experience in building data-driven solutions, creating intuitive reports, automating workflows, and designing scalable data models. I have a proven track record of optimizing BI processes to enhance organizational efficiency and support data-informed decision-making. My goal is to help businesses leverage data to drive strategic growth and improve performance.

Overview

8
8
years of professional experience
2
2
Certifications

Work History

Advisor - Power BI and Power Platform

Dell International Services
Bangalore
12.2021 - Current
  • Developed a centralized semantic model powering 13 Direct Query reports and 12 Live self-service BI dashboards serving 375+ users,, enabling reusable data models and user-centric, scalable in Power BI.
  • Mentored 3 junior analysts and led the adoption of modern BI practices , including CI/CD pipelines, version control (Sharepoint/Drive), and semantic modeling in Power BI.
  • Built and optimized ETL pipelines using Power Query, SQL, SSIS , and integrated data from APIs, Snowflake, SharePoint, Teradata , and cloud/on-prem platforms.
  • Migrated reports from Tableau to Power BI by providing end-user same level for functionalities
  • Applied tools like DAX Studio, Tabular Editor, Measure Kill, Power BI Helper for optimization, performance tuning, documentation , and metadata management .
  • Automated workflows using Power Automate and Power Shell , significantly reducing manual effort and improving operational efficiency and Maintaining Active Directory for Data Security.
  • Built chatbots POCs on Power Virtual Agent and Copilot AI Agent to easy daily mentoring tasks
  • Helped team in licenses procurement and cybersecurity approvals for Tabular Editor/Power Automate Desktop

Consultant- Power BI

Fractal Analytics
12.2020 - 12.2021
  • Gathered and Documented business requirements for analytical reports, Participated in requirement meetings and data mapping sessions to understand business needs.
  • Worked with Procter and Gable team to develop Market share analysis using Nielson/Kantar competition Data
  • Enhanced performances in existing reports and incorporated incremental refreshes.
  • Integrated custom visuals based on business requirement and also developed two three visuals options for each report for discussion with product owners and leaderships.
  • Developed views in SQL Queries ( SQL 2014 ) to analyze and support power bi reporting solutions.
  • Worked with Microsoft Team on product limitations and communicate tool capabilities to business stakeholders.
  • Provided continuous maintenance, change requirements & bug fixes for existing reports.

Senior Executive- Business Excellence

Snowman Logistics Limited (Adani Ports)
03.2018 - 12.2020
  • Aligned organizational objectives with company mission to increase business growth and integrate work strategies.
  • Assisted Supply chain analysts with automating reporting functionality using Power BI tools Power BI reporting, Dashboards & Scorecards (KPI) and SQL server & other data sources.
  • Used various sources to pull data into Power BI such as SQL Server, Content Packs & O-Data & created Jobs using SQL Server agent.
  • Auto emailing exception to concerned department & made relevant use of Q&A.
  • Development of various scorecards, exceptions report & inventory management to control W Ops for our key QRC such as IKEA India,, Baskin Robins, Parag dairy ltd, Subway etc.

Techno-Functional BI Consultant

Prudence Technology Pvt Ltd
02.2017 - 03.2018
  • Project 1 For Survey Insights: My Gov, Delhi. My Gov is a citizen engagement platform founded by the Government of India to promote the active participation of Indian citizens in their country's governance and development.
  • Project 2 Retail: My Fab, Noida. The main aim of this project is to generate reports to analyze online purchase/demand for future sales and daily sales at their Noida shopping & online outlets. Analyzing transportation of all trucks IN/OUT. Dashboard development for sales head. Major issue like minimizing delivery time by analyzing the complete process.
  • Project 3 Automobile: Napino Auto & Electronics Limited. The main aim of this project is to generate reports for different Business Units like Sales Head, Field Sales Director, BM's and for the handing of mechanical parts shelf life, Manufacturing Dates, expires of major electronics items.
  • Gather requirements from end-users in excel.
  • Connect to multiple datasets to bring all of relevant data together in one place and create reports that provide a consolidated view of the different sources.
  • Created/Analysed sentiments that used to appear upon MY GOV forum.
  • Scheduling of Power BI reports in online version and Create relevant use cases of Q&A feature.
  • Design reports which end users uses in day to day activities and showcasing outputs to top management.
  • Used Filters and provided Customized prompts appropriately to avoid excessive data showing up reports.
  • Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.

Education

B.Tech - Computer Science

DPG Institute of Technology & Management
Gurugram
03.2014 - 2017.03

High School Diploma -

DPG Institute of Technology & Management
Gurugram
03.2010 - 2014.03

Skills

MS SQL Server, SSIS (SQL Server Integration Services), Teradata, Power BI, Power Query, DAX (Data Analysis Expressions), Data Modeling, Power BI Service, Power BI, Power BI Report Server, Power Automate, Data Integration, Data Governance,Power Virtual Agents, Copilot AI Agent, Chatbots, Lexalytics Sentiment Analysis, AI & Machine Learning in Power BI, Business Intelligence (BI) Solutions, Self-Service BI, SQL, ETL, Data Warehousing, Navcube, MS Navision ERP, Data Visualization, Data Analytics, Advanced Analytics, Oracle DVCS, Cloud-Based Analytics, Active drectory, Report Automation,Research & Analytical Skills, Data Architecture,DAX, Report Performance Tuning, Data Automation, Data Storytelling

Certification

SQL & Relational Databases, IBM, 03/01/20

Timeline

Advisor - Power BI and Power Platform

Dell International Services
12.2021 - Current

Consultant- Power BI

Fractal Analytics
12.2020 - 12.2021

Senior Executive- Business Excellence

Snowman Logistics Limited (Adani Ports)
03.2018 - 12.2020

Techno-Functional BI Consultant

Prudence Technology Pvt Ltd
02.2017 - 03.2018

B.Tech - Computer Science

DPG Institute of Technology & Management
03.2014 - 2017.03

High School Diploma -

DPG Institute of Technology & Management
03.2010 - 2014.03

Similar Profiles

CREATE PROFILE
Gaurav MagguBI Professional