BI Reporting for Business Operations Data

Operations Data in my last company
Collaborate with business stakeholders to gather functional requirements and translate them into scalable BI reporting solutions.
• Designed and implemented robust data integration workflows by consolidating data from Excel, SharePoint, Salesforce, and SQL Server into a centralized reporting model.
• Performed comprehensive data profiling, cleansing, transformation, and modeling using Power Query (M) to deliver high-quality, analysis-ready datasets.
• Designed and developed dynamic dashboards using custom visuals, hierarchical drill-down structures, geo-maps, and drill-through features to enhance analytical depth and improve strategic business decisions.
• Proficient in advanced DAX (YTD, QTD, MTD, YoY, MoM), performance optimization using DAX Studio, incremental refresh, aggregations, and RLS implementation.
• Experienced in Power BI Service, Gateway configuration, scheduled refresh, workspace management, and multi-source data integration (SQL Server, Excel, SharePoint, Salesforce, CSV).
• Delivered domain dashboards across HR, Finance, and Profitability analysis, enabling leadership visibility into key metrics.
• Streamlined recurring reporting processes through Excel VBA automation, minimizing
• Built customized Excel/VBA tracking solutions to standardize reporting, improve version control, and increase operational efficiency.