SHEIK MOHAIDEEN ZAHIR

Microsoft SQL SERVER, ETL Technology and Azure Data Factory Showcased exceptional T-SQL developer skills, including expertise in crafting Stored procedures, Triggers, User Defined Functions, Indexes and Views resulting in efficient data manipulation and data consistency.Capable of troubleshooting common database issues such as integrity issues, performance issues, blocking and deadlocking issues, connectivity issues etc.Experience in using SQL Server Agent, Active Batch Directory andAzure Monitoring Developed Power BI Dashboards for clients to meet the businessneeds. Hands - on experience Azure Data Factory, Azure Monitoring, KeyVault, Azure Data Lake, Azure Storage Gen2 Good experience in tracking and logging end to end software application build using Azure DevOps.

Analysis of the requirements and designing the solution.
Used SSIS to load data from files and other sources to the mart
which facilitates the data to be populated on the report.
Cleansing of data extracted from various sources like Flat Files then transformed and loaded into Data Warehouse Targets using SSIS.
Loading the data into tables and verifying the correctness of data loaded.
Developed reports and dashboards from multiple data sources.
Store all source code in the Azure Devops and update development status.
Handling Database Objects like Tables, Stored Procedures, Views, Triggers and functions as per the project Requirement and creating the new tables, Indexes required for the new features and alteringthe tables for change request features

Design and implementation database solutions using SQL Server, SSIS
and Power BI. Ensuring efficient data management and
transformation processes

Writing stored procedures for Payroll and HRMS applications,
develops the performance reports, and automated the mail alert process for various purposes.
Implementing new features of Ramco Product for Ramco Internal & Ramco HCM Product Support
Work with all levels of development from analysis through
implementation and support.
Developing and Modifying SSRS reports based on the customer
requirements.
Provide support/clarification for existing applications.
Reporting bugs and Regression on Bug fixes.
Creating staging database for temporary processing of data,
consolidating data and Loading into Target database using Integration
services.