Power Bi Azure Data

Ujjawal Gupta

Data Analyst

**********@*****.*** 965-***-**** Nagpur, MH linkedin.com/in/ujjawal-gupta-033075113 Profile

Data professional with 5 years of hands-on experience in SQL, Power BI, Excel, Azure Data Factory, SSAS, Databricks, and Azure Cloud. Adept at developing interactive dashboards, driving data-driven insights, and delivering accurate reports aligned with business goals. Demonstrates strong analytical thinking, solution-oriented approach, and a commitment to upskilling in emerging technologies. Technical Skills

• Power BI - Desktop,

Service

Administration

• Azure Data Factory

• Microsoft Fabric

• Data Warehousing

• DAX

• Azure Databricks

• ETL

Extract, Transform, Load

• Microsoft Azure

Cloud

• Power Query / M

Language

• SSAS

• Data Modeling

• Kusto Query

Language

• SQL / T SQL

Indexing, Views, Stored

Procedures

• SSIS

• Advanced Excel

Pivot Tables, Vlookup,

Xlookup, Hlookup, Index

Match

Professional Experience

Infosys Ltd, Technology Analyst 04/2024 – Present Pune, Maharashtra

•Designed and delivered 15+ interactive Power BI dashboards by integrating SQL Server and Azure Databricks notebooks, enabling stakeholders to monitor KPIs, business trends, and operational metrics with 25% faster decision-making.

•Built and optimized complex data models using DAX, Power Query, and calculated measures, improving reporting accuracy and reducing data load time by 40%.

•Developed automated ETL pipelines in Azure Data Factory, streamlining real-time data ingestion and transformation across multiple sources, which increased data freshness by 60%.

•Collaborated with cross-functional teams to translate business requirements into scalable BI solutions, conducted performance tuning, and enhanced report efficiency, reducing average report load time from 12s to under 5s.

Sapalogy Pvt Ltd, Data Analyst 01/2021 – 03/2024 Nagpur, Maharashtra

•Engineered and maintained 10+ interactive Power BI dashboards and reports, transforming raw data into actionable insights that supported strategic decision-making across business units.

•Led end-to-end data validation and integration efforts, ensuring 100% accuracy and seamless flow of data from multiple sources into reporting platforms.

•Designed and executed ETL pipelines using SSIS to automate data processing tasks, reducing manual effort by 40% and improving data availability for reporting.

•Performed complex data analysis in Excel using pivot tables, macros, and advanced formulas, accelerating reporting cycles by 30% for key business stakeholders. Suntech Air-conditioning Pvt. Ltd, HVAC Design Engineer 11/2017 – 02/2020 Hyderabad, Telangana 1 / 2

Projects

MSS ACL (Advocate Competency Level) 05/2025 – Present Client: Microsoft

Role: Team Lead

Tech Used: Power BI, Spark SQL, Azure Databricks, DAX

•Led the design and development of a global Power BI dashboard to track performance metrics for 1,000+ service advocates across multiple vendors, enabling program managers to conduct targeted coaching sessions and improve service quality.

•Integrated and optimized data pipelines using Azure Databricks notebooks by writing efficient Spark SQL queries, reducing data load time by 30% and managing ADB job runs to automate pipeline refresh, improving both report reliability and performance.

•Implemented advanced DAX measures and dynamic KPIs to visualize real-time advocate efficiency, sales impact, and service metrics with 100% data accuracy, validated against source systems.

•Recognized by client for delivering a high-performing dashboard ahead of deadline, which contributed to a measurable increase in operational efficiency and decision-making speed. Dynamics for Microsoft-DFM UCI Usage & Performance 04/2024 – 10/2024 Client: Microsoft

Role: Power BI Developer

Tech Used: Power BI, SQL Server, Azure Data factory, DAX, KQL

•Architected a dynamic Power BI reporting solution to analyze Microsoft Dynamics UCI application usage, featuring visualizations for caseform load times, memory consumption, app traffic, and API/plugin trends— enhancing real-time monitoring and reducing incident resolution time by 30%.

•Enforced secure access through Row-Level Security (RLS) and compliance protocols, enabling customized report views for global teams while maintaining 100% data governance.

•Orchestrated data pipelines in Azure Data Factory and integrated external logs via Kusto Query Language

(KQL), enabling automated data ingestion and boosting report refresh reliability by 40%.

•Synthesized regional performance patterns and communication trends, including email traffic insights— leading to a 20% boost in system optimization initiatives and contributed to 15% faster project delivery through enhanced cross-team collaboration.

Certificates

Microsoft Fabric DP-600

Microsoft Power BI PL-300

Data Modeling for Power BI Workshop at Pragmatic Works DAX for Power BI Workshop at Pragmatic Works

Education

G.H Raisoni Academy of Engineering and Technology, Bachelor of Engineering, Nagpur University

2013 – 2017

2 / 2

Contact this candidate