Deep Tomar

Powerbi Developer @Scotiabank

Toronto, ON, CA

Designed user-friendly and performance-focused Power BI dashboards, managing Power BI gateways.• Installed and configured Enterprise and Personal Gateways in Power BI Services.• Collaborated with Data Architects, DBAs, and BI teams for end-to-end data solutions.• Developed diverse solution-driven views and dashboards in Power BI, utilizing various chart types.• Implemented DAX functions for efficient data visualization and enriched data models.• Managed advanced reporting, data cleaning, analytics, and BI solutions such as Tableau.• Planned and balanced team resources, communicated updates, and automated workflows with Python scripts.• Integrated Power BI reports with Power Apps and Power Automate flows for cross-platform data access.• Contributed to web parts, apps, layouts, workflows, and content types in SharePoint.• Leveraged Azure Data Lake Analytics, Azure Data Factory, and Azure Databricks for data analysis and transformation.• Designed custom visuals and functions for Power Apps and Power Automate.• Conducted predictive analysis with Python and utilized Power Query, Power Pivot, and Power View for scorecards and dashboards.• Created complex Power BI data models with multiple fact tables and dimensions.• Developed and optimized SQL queries, stored procedures, and SSAS models for data performance.• Implemented Power BI Security using Privacy Level, Row Level Security, and Office 365 Security labels.• Created data transformations and pipelines in Azure Data Factory.• Published interactive data visualization dashboards from Power BI Desktop to Power BI servers.• Environment: Power BI, SQL Server, SSIS, SSRS, SSAS, TSQL, ETL, Azure, DAX, Oracle, Visual Studio, Windows.

AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD

Bachelor of Technology - BTech, Electrical and Electronics Engineering