SQL Developer Available resume

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 and designed data conversions from w...

See full