Expertise in creating Power BI Dashboard to indicate the Trends,KPI’s,Management Analysis.
Monitoring and reviewing the status of reporting incidents and enhancements.
Good knowledge in analyzing, gathering, managing and documenting business needs and functional requirements
Proven ability in data cleaning and validation for quality reports
Experienced in creating the reports by the application of Power BI.
Experience in writing, optimizing T-SQL Objects like Stored Procedures, User Defined Functions, Indexes, views, CTE, Constraints, functions, joins.
Experience in creating packages by using SQL server integration service.
Experience in Creating Checkpoints, Breakpoints.
Experience in scheduling jobs through SQL Server Agent.
Creating the Business requirement documents, doing the research and development and documenting the assumptions, decisions related to the reports and projects.
Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats and Power View Reports with multiple views featuring tiles, and a number of visualizations, using Power BI desktop.