Summary:

• Results-driven Senior Power BI Developer with over 10 years of experience in designing, developing, and implementing Business Intelligence (BI) solutions.
• Strong expertise in data visualization, modeling, and analysis to drive strategic business decisions.
• Skilled in creating automated dashboards and reports using Power BI, SQL Server BI Stack, Power Query, and DAX.
• Proficient in ETL processes, data warehousing, and real-time analytics using Azure, Snowflake, and SAP HANA.
• Experienced in connecting and transforming data from multiple sources including SharePoint, OData, and Azure APIs.
• Adept at requirement gathering, stakeholder communication, and presenting analytical insights to business users.
• Demonstrated ability to deliver end-to-end BI solutions, from database architecture to dashboard deployment and automation.
• Passionate about leveraging Power BI and Azure analytics to enhance business efficiency and decision-making.

Skills:

• BI Tools: Power BI (Power Query, Power Pivot, Power View, Power Map), Tableau
• Databases: Microsoft SQL Server, Azure SQL Database, SAP HANA, Snowflake
• Data Processing / ETL: SQL Server BI Stack, Power Query, SSIS, Azure Data Factory
• Data Modeling: Star Schema, Snowflake Schema, Dataflow, DAX, M Query
• Cloud Platforms: Microsoft Azure (Event Hubs, Stream Analytics, Data Verse)
• Visualization & Reporting: Dashboards, KPIs, Reports, Automated Data Refresh
• Programming / Query Languages: SQL, DAX, KQL, M Query, VBA
• Version Control / Tools: JIRA, SharePoint, Power BI Service
• Office Tools: MS Excel, MS Office Suite
• Other Expertise: Data Analysis, Predictive Analytics, Real-time Data Streaming, Stakeholder Reporting

Projects:

Maserati Net Profit Status

Technologies used: SQL DB, Azure, Power BI, OData

Project Description: Developed automated weekly net profit reports and dashboards for Maserati. Ensured business requirements were translated into effective reporting solutions using Microsoft BI technologies.

Responsibility:

• Designed and developed interactive Power BI dashboards for profit tracking.
• Automated data extraction and report refresh processes using Power BI Service.
• Collaborated with stakeholders to define functional and technical specifications.
• Utilized MS SQL Server BI Stack, Power Query, and DAX for data transformation and visualization.

Nissan Sales Analysis

Technologies used: SharePoint Data Verse, Dataset, Dataflow, Power BI, JIRA

Project Description: Created dynamic daily sales analysis dashboards for Nissan, integrating multiple data sources including SharePoint and Data Verse.

Responsibility:

• Designed interactive sales dashboards and performed deep data analysis using Power BI.
• Converted business requirement documents (BRDs) into technical specifications.
• Developed and optimized DAX queries and data models for better performance.
• Created charts, reports, and documentation explaining models, parameters, and relationships.
• Integrated SharePoint and Data Verse datasets for centralized reporting.

Azure SQL Database Status

Technologies used: SAP HANA, Azure, Power BI

Project Description: Built real-time reporting for Azure SQL Database activity tracking using Azure APIs and KQL-based data transformation.

Responsibility:

• Connected Azure API Data Sources with Power BI for automated data refreshes.
• Transformed and optimized data using KQL and M Query in Power BI.
• Implemented user-based access control for customized dashboards.
• Monitored daily performance metrics of SQL Databases and visualized employee data views.

Comparison Analysis Dashboard

Technologies used: Snowflake, SQL, Power BI, Azure Event Hubs, Azure Stream Analytics

Project Description: Developed a real-time comparison dashboard using Azure streaming technologies to visualize live business performance data.

Responsibility:

• Designed and implemented real-time dashboards using Azure Event Hubs and Stream Analytics.
• Collaborated with clients to gather and analyze reporting requirements.
• Modeled data in Power BI using Snowflake datasets for fast querying.
• Conducted requirement analysis and data modeling for live data visualization.

TWD Rolling Report

Technologies used: SQL, VBA, Power BI, Power Query, Azure

Project Description: Architected and optimized database processes for TWD’s rolling reports, enhancing ETL performance and report generation speed.

Responsibility:

• Designed database architecture and tuned SQL queries for performance improvement.
• Imported and transformed data from SQL Server and Azure SQL DB to Power BI.
• Created computed columns and tables using DAX for analytical insights.
• Developed and optimized stored procedures for faster data retrieval.

O2C Collection Dashboard

Technologies used: SQL, SSIS, Power BI, Power Query, Azure, Tableau

Project Description: Developed and deployed automated financial dashboards for O2C collection performance tracking and business reporting.

Responsibility:

• Created Power BI workspaces and content packs for business reporting.
• Implemented automated data refresh schedules in Power BI Service.
• Built calculated measures, KPIs, and DAX expressions to enhance reporting accuracy.
• Conducted weekly presentations to business stakeholders on report updates.
• Delivered Yearly, Quarterly, Monthly, and Daily financial reports.