Professional Summary:
- 7+years of IT experience as a MS BI SQL Server Developer.
- Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL *** R2.
- Extensive experience with different phases of Software Development Life Cycle(Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
- Excellent knowledge in creating Databases, Tables, Stored Procedure, SQL Joins, DDL/DML Triggers, Views, User defined data types, Cursorsand Indexes using T-SQL.
- Experienced in using recursive CTEs, temp tablesandtable variables.
- Worked with T-SQL, DBCC, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys
- Ability to write complex Transact SQL (T-SQL) queries, Sub queries, Co-related and Non-correlated sub queries, Dynamic SQL queries etc.
- Good knowledge in Normalizingand De-normalizingthe tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
- Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
- Experience in using Profilers, Index Tuning Wizardand performance monitor to monitor SQL Server.
- Good experience working on TFS for creating work items and checking in/checking out code.
- Highly experienced in complete cycle of SQL Server Integration Services(2005/2008R2), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP),Data Transformation Services (DTS)and SQL Server Integration Services (SSIS *** ).
- Used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS an...
