As a Power BI Developer and Data Analytics Professional with over 5+ years of experience, I specialize in delivering tailored business intelligence solutions across diverse industries. My expertise lies in building dynamic Power BI dashboards, designing and managing ETL pipelines, and delivering actionable insights using data modeling and visualization best practices.
From creating intuitive KPIs to automating complex data refresh workflows, I leverage Power BI Desktop and Service, SQL Server, SSIS, and C# to ensure scalable and high-performance analytics environments. Whether it's integrating diverse data sources or visualizing trends to support decision-making, I combine technical depth with a clear business understanding to deliver measurable results.
What I Can Do for You
- Custom Power BI development using advanced DAX, data modeling, and Power Query (M)
- Build and customize modern dashboards tailored to your business KPIs and brand aesthetics
- Integrate Power BI with Microsoft 365, Azure SQL, on-prem SQL Server, and external APIs
- Automate report distribution and business workflows using Power Automate + Power BI triggers
- Provide end-to-end support including dataset security, workspace governance, and report optimization
- Design and build robust ETL workflows using SSIS, SQL Server, and C# for data cleansing, transformation, and migration
- Develop custom ETL utilities for structured/unstructured data (XML, Excel, flat files) with validation, logging, and automation
- Optimize existing data pipelines for performance, scalability, and reliability
- Excellent knowledge of Business Objects architecture and metadata management.
- Skilled in defining BI strategy and roadmap to solve performance management issues.
- Strong knowledge of Business Objects SQL, Oracle, PLSQL, and SQL PLUS.
- Expert in SSIS transformations like Conditional Split, Lookup, Merge Join, Sort, and Derived Column.
- Experience in data migration using Data Import/Export, Bulk Insert, and BCP.
- Designed and developed ETL/SSIS packages for OLTP to data warehouse transfers.
- Proficient in creating report models and business-focused dashboards.
- Experience developing Power BI reports from multiple data sources and optimizing performance.
- Effective communicator with experience conducting project coordination meetings.
Notable Projects
Hotel Revenue Dashboard – Power BI Use Case
Developed dashboards and KPIs in Power BI to analyze and visualize hotel data globally. Helped business leaders make informed decisions based on revenue insights.
Dashboards / Reports
- Room Revenue by Hotel / Season / Month
- Week-wise comparison of Current & Last Year (Revenue, ADR, RevPAR, Occupancy)
- Revenue vs Budget vs Last Year
- Revenue Overview with ADR & RevPAR (drilldowns by fiscal period)
- Revenue by Market Segment
- Revenue Comparison across all Hotels
- Revenue by Week Start Dates
- Tree View: Season > Hotel > Month > Market Segment
- Total Rooms Available vs Rooms Sold
- Weekly Metrics: Room Revenue, ADR, RevPAR
Retail Analytics with Power BI
Designed interactive dashboards to analyze sales trends, product performance, and demand patterns across outlets.
Dashboards / Reports
- Daily Sales by Product/Category
- Most Demanding Item by Outlet
- Most Demanding Item Clockwise Visualization
Project Highlight – Custom ETL Utility with C#
Developed a robust ETL (Extract, Transform, Load) utility using Visual Studio and C# to automate the extraction and validation of XML-based data files. This tool efficiently parses XML data using custom schemas and performs validations to ensure data integrity before loading into SQL Server. The utility supports bulk processing, detailed logging, and exception handling for scalable enterprise-grade data operations.
Installed and configured the On-Premises Data Gateway to enable secure and reliable data refreshes between on-prem SQL databases and Power BI Service. This ensured seamless integration of dynamic reports and dashboards with enterprise data sources, boosting report delivery and decision-making.
Tech Stack
Data Visualization: Power BI, DAX, KPI Dashboards
ETL: SQL Server Integration Services (SSIS), C#, Custom XML Parser
Programming: C#, T-SQL, Power Query (M)
Databases: SQL Server, Oracle
BI Tools: Power BI Desktop, Power BI Service
Data Connectivity: On-Premises Data Gateway, ODBC, REST APIs
Others: Visual Studio, Git, Azure DevOps