نبذة عني
Having 5+ years of IT industry experience in Business Intelligence Tool on Power BI, SQL Server DAX, SSAS
الخبرة
Bi Developer
Worked in Power Bi Desktop and Power Bi Service
Having good experience in Microsoft Power BI Reporting Tool
Having good experience in DAX query Language
Having good experience on SQL Server Concepts Procedures and Functions
Good experience with SQL Server 2008/2014
Experience in working with SSAS tabular cubes
Involved in designing cubes in SSAS using Snowflake and Star Schemas
Created Rich visualized Pie & Line Charts, Tree Map, Tabular and Matrix Reports Using Power BI
Created, maintained & scheduled various reports in Power BI Desktop
Published Power BI reports from Power BI desktop to Power BI service
Extensive Knowledge in SSAS partitions, Roles and KPIs.
BI Developer
Create a Tabular SSAS Cubes which required for a Power bi Reports.
Created Cascading Reports, Drill down and Drill through Reports by Using Power BI.
Extensively worked on Power BI Personal Gateways and Enterprise Gateways.
Created rich visualized Dashboards in Power BI.
Create and manage the Power bi reports and Dashboards which are required for business analysis and to make new events.
Extensively involved on the SSAS storage, partitions and aggregations.
Created, maintained & scheduled various reports in Power BI Desktop.
Published Power BI reports from Power BI desktop to Power BI service.
Creating Actions, KPI’s etc.
Analyze the given requirement and convert into working reports and dashboards.
Train business users on how to use the report for pulling out data for their respective market/cluster and how-to pull-out pain areas to do easy validation.
Good Experience configuring gateways and scheduled Power BI Reports.
Implemented different types of filters in Power BI.
Expert in cleansing data from files by using Transformations, Calculated fields, Power Query’s and DAX Functions.
Having good experience in transform the data using Power BI Desktop
Created Database Objects like tables, Views, joins, functions, as per the Business requirements.
Code validation as per client requirement.
Wrote SQL Queries using Joins, Sub Queries and correlated sub-Queries to retrieve data from the database.
Published Power BI reports from Power BI desktop to Power BI service.
Creating Actions, KPI’s etc.
Analyze the given requirement and convert into working reports and dashboards.
Good Experience configuring gateways and scheduled Power BI Reports
BI Developer
Building, publishing customized interactive reports and dashboards, report scheduling using Power BI.
Analysis the requirement documents to develop the Reports and Dashboards.
Planning the estimates. Hence assigning the user stories to the team for development and unit testing.
Developed custom reports and deploying the PBI service to multiple clients’ organizations.
Designed Power BI data visualization utilizing Matrix tabs, maps, Trending, pie, bar and density charts.
Hands on experience of data mart scripts in SQL.
Explored data in a variety of ways and across multiple visualizations using Power BI.
Strategic expertise in design of experiments, data collection, analysis and visualization.
Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
Created Data Warehouse schema to deploy fact and dimension table and defined Referenced relationships with the measure groups and fact tables.
Write a required DAX query performance of Hierarchies and Fact Dimensions.
Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
Extensive SQL querying on Staging, Data warehouse and Data Mart.
Explored data in a variety of ways and across multiple visualizations using Power BI.
Store all source code in the Team Foundation Server (TFS) and update development status in the TFS timely.
Created Landing pages in PBI where it will redirect to multiple reports by one click
Implemented different types of filters in Power BI.
BI Developer
Interacted with end-users to collect requirements and acquire the necessary domain knowledge to become a subject matter expert.
Understanding source systems and customer requirements.
Worked with Dashboards style of reports using all the Power BI components.
Worked with Pages and Page Visualizations in Power Bi Desktop.
Created Dashboards style of reports using Power Bi Desktop Visualizations like Bar Chart, Line Chart, Area Chart and Slicer etc.
Created the reports using charts like Pie, Bar, Line, KPI Visuals, Custom visuals, etc.
Charts are used in making reports more user-friendly in analysis purposes.
Developed User Interactive Reports as business needs.
Published reports into Power BI publisher and schedule the data sets.
Shared dashboards to users through Office 365, Content Packs.
Developed complex SQL queries and create stored procedures to fetch data for reporting and to accomplish several computations.