# Assist in the collection and documentation of user's requirements, development of user stories, estimates and work plans alongside abiding the Agile and Scrum methodologies.# Creating, developing and maintaining SQL databases whilst also ensuring their performance and stability.# Developing SQL Server database objects to suffice the business needs.# Advise developers to improve the performance of poor performing queries by tweaking or modifying stored procedures, views and indexes.# Work with the Team and Business Analysts to create and modify our database structure.# Review peer database design and code.# Responsible for setting preferences for various ad-hoc requests and distribution of tasks.# Creating and automating the regular Jobs.# Tuned and Optimized SQL Queries using Execution Plan and Profiler.# Testing databases and performing bug fixes & fixing any issues related to performance.# SQL querying for best results, use of filters and graphs for better understanding of data.# Connecting Power BI with different data sources and performing data transformation operations using Power Query Editor.# Designing data models by building relationships and relationship cardinality.# Developing DAX measures and calculated columns.# Using Power BI, Power Pivot to develop data analysis prototype, and using Power View and Power Map to visualize reports. Building drill down visuals & drill through pages and using custom visuals to generate useful and meaningful insights.# Creating dataflows in Azure Data Lake (ADL).# Publishing Power BI reports into content containers like Workspaces and Apps and designing dashboards.# Installing gateways and implementing refresh option to keep dashboards and reports up to date.# Sharing and collaborating reports by implementing Row Level Security (RLS).# Establishing real time data streaming connection to design real time data dashboard.

# Interacted with team and analyzed, designed & developed database using ER Diagram, normalization and relational database concept.# Involved in design, development and testing of the system.# Developed SQL Server Stored Procedures, Tuned SQL Queries, Functions & Views.# Reviewed existing business procedures and recommended and implemented changes.# Identified and resolved bugs within different database objects.# Being a team player, worked directly with other development teams and analysts to support the prototype solutions, maintaining flexibility and accountability to keep project progressing.# Scheduled, developed, and published interactive Power BI reports as per requirements to generate enhanced insights for business development.

# Primary responsibilities involved development of SQL Objects such as Procedures, Functions and Triggers to Implement business logic.# Development Of SQL Scripts.# Analyzed, solved & corrected database issues in real time.# Designed the error log table for capturing and handling the errors encountered during execution of database objects.# Communicate effectively and proactively with Project Manager and project colleagues to identify opportunities to improve existing experience of the system.

# Assessed end-user requirements.# Created SQL scripts for validation.# Developed Test Plans and Test Cases.# Designed SQL code to validate report criteria.# Executed SQL scripts to validate all defined criteria.# Validated Data Warehousing reports.# Trained team members and end users.

# Understand the functionality of the application to be tested.# Requirement analysis and resolution of the open queries from the stake holders.# Initial estimate calculation for all the phases of the project.# Design and enhance the test script for execution of the test cases.# Test execution progress, Defect logging and Tracking in Quality center.# Daily Status and defect call with the stakeholders and discussion of open issues/risks/defects.# Preparation of Test Completion report for the final sign off.