Verified
IdentityExtensive experience on SQL Server programming, SSRS, SSIS and Oracle Programing.
Worked for western clients such as
https://www.encorecapital.com/
https://cmp.carematchpro.com/
Responsibilities Served:
Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
Created and optimized database objects such as views, functions and stored procedures as per requirement.
Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
Used SSIS to create ETL Packages to validate, extract, transform and load data to databases.
Using transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Database.
Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects.
Transferred data from various data sources systems including MS Excel, MS Access, flat files
to SQL Server using SSIS. Created SSIS packages and scheduled the jobs to run automatically.
Table renaming, splitting or merging columns and changing the data type or size of the column.
