• 8+ years of IT experience developing robust Business Intelligence solutions with strong expertise in Oracle PL/SQL, SQL Server databases, and BI reporting tools. • Extensive experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop • Experience in Power BI to design Interactive Reports using Power Query, Power Pivot and Power View. • Experience in implementing physical data model (Databases, Schema Tables, Views & Virtual Data Warehouse) • Utilized Microsoft Excel as a critical tool for advanced data analysis, leveraging Power Query for data extraction and transformation, Power Pivot for in-memory data modeling, and complex VBA automation to streamline repetitive tasks. • Implemented AI-powered Power BI Copilot features to auto-generate insights from large datasets, providing business users with actionable suggestions and recommendations for quick decision-making. • Designed and developed robust MS Access databases to streamline departmental data collection and reporting workflows. Automated complex forms, queries, and VBA-driven macros to reduce manual data entry errors. • Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot. • Published reports to Azure-based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps). • Optimized SSAS data models by implementing hierarchies and attribute relationships to improve query performance. • Integrated SSRS reports with SharePoint and implemented subscription-based report delivery via email and file share. • Designed and deployed Multidimensional OLAP cubes with complex measures and calculated members using MDX for enterprise-level data analysis. • Implemented Tabular models in SSAS with DAX queries to optimize data retrieval performance in large datasets exceeding 10 million rows. • Developed partitioning strategies in SSAS cubes to enhance processing efficiency and reduce data refresh times by 40%. • Created advanced MDX calculated members and named sets to enable dynamic, business-specific KPIs and metrics. • Implemented Fivetran connectors for automated data extraction and replication from SaaS platforms to Azure Data Lake. •
