Designing the Reports and Dashboards as per client requirement and created the reports using Excel files and SQL(SSMS) as a data source.
Imported data from SQL Server DB, SSMS & Excel to Power BI application to generate reports and dashboards
Familiar with the JIRA and Zendesk to create and maintain workflow of the project.
Having hands on experience in writing SQL queries to extract the data from SQL Server database
Troubleshoot and debug automated processes and workflows
Monitor and maintain the performance of automated processes and workflows
Develop and maintain documentation for Power Automate processes and workflows
Created and modified various Stored used in the application using T-SQL.
Blended data from multiple databases into one report by selecting primary keys from each database for data validations.
Engagement with Metrics, Analysis, Reviews and QC