Power Bi Developer || Business Intellegence
Current• Analyze, design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data models, reports, dashboards, and other BI solutions for analytics based on business requirements and technical specifications using the Microsoft BI Platform (MS SQL Server, Power BI)• Gathering Business Requirements and Designing a Fact and dimensional Table to initialize a star schema for creating a physical KPI store database with MS SQL Server using the Erwin Data Modeling… Show more • Analyze, design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data models, reports, dashboards, and other BI solutions for analytics based on business requirements and technical specifications using the Microsoft BI Platform (MS SQL Server, Power BI)• Gathering Business Requirements and Designing a Fact and dimensional Table to initialize a star schema for creating a physical KPI store database with MS SQL Server using the Erwin Data Modeling tool.• SQL Development - Writing SQL queries like CTE (Common Table Expression), Views, and Stored Procedure.• Created, modified, and troubleshoot paginated reports using both SSRS and Power BI Report Builder. • Design, build, and deploy Power BI solutions (e.g., datasets, reports and dashboards, visualizations) and Power Apps.• Assist with the enhancement of existing high-visibility dashboards and provide technical support and troubleshooting of Power BI reporting and Power App solutions.• Power BI Administration- Creating role-level security, subscribing users to the report page, giving access to users, and embedding reports in the Azure active directory app.• Developing KPI reports based on business requirements, creating intuitive dashboards using Power BI for quick reviews to be presented to Business and IT users for enhanced business decision-making.• Experience in the design and development of Reports and dashboards, Sub-Reports, drill-down reports, drill-through reports, Parameterized reports, and Chart reports using SSRS. • Used Power BI Gateways to keep the dashboards and reports up to date. Show less