• Strong knowledge in SQL Commands like (DDL, DML).
• Experience in SQL Server and T-SQL in constructing Procedures, Tables, Table variables, user functions, views, indexes, CTE, temp tables.
• Good Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Good knowledge in working with System Views and Tables.
• Good knowledge in creating and deploying SQL Server Integration Services (SSIS) packages, using different types of tasks and transformations.
• Experience in Integration of various Data Sources like Excel, Flat Files, and OLEDB Sources into the Staging Area and Load Target data into Data warehouse.
• Worked on Data Flow Items Like Sources, Transformations and Destinations.
• Created various types of Reports using SSRS (Table, Matrix, and Chart).
Developed Drill down and Drill through, Cascading reports, Sub reports Using SSRS