Summary:

• Worked with supporting large customer base and worked directly with end-users and supported all the requirement changes, issues tracking systems request and data related issues.
• Hands on experience with Testing Life Cycle Component testing, Unit testing, and System/Integration testing, User acceptance testing etc.
• Good knowledge of web development technologies such as HTML, XML, DHTML.
• Experience in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning SQL Server performance.
• Extensive experience creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Functions, Triggers and Cursors on Microsoft SQL Server 2005/2008/R2.
• Experience in creating/deploying Reporting Services SSRS 2005/2008/2008R2 , Data Transformation Services DTS and MS SQL Server Integration Services SSIS packages.
• Strong experience in MS SQL Server Business Intelligence 2005/2008 in Reporting Services and Integration Services.
• 7 years of experience in the IT industry as a MS SQL Developer 2005/2008/R2.
• Experienced in using tools like Bulk Copy BCP and Data Transformation Services DTS and SSIS with MS SQL Server 2000/2005.
• Excellent command over managing Alerts, Operators and Jobs through SQL Server Agent.
• Expert in developing T-SQL DDL, DML statements, Data Integrity constraints , Rules, Performance Tuning, Query Optimization and Validation issues.
• Hands on experience in troubleshooting database issues.
• Experienced in Database Backup and Recovery procedures.
• Excellent experience in designing and developing Reporting System using Business Objects.
• Experience in creating and deploying SSIS packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Expert in Data Extraction, Transforming and Loading ETL using various tools such as Data Transformation Services DTS , SQL Server Integration Services SSIS 2005/2008, Bulk Insert/ BCP utility.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Tabular, Top N, Summary, Sub reports, Charts and Graphs and formatting them using SSRS 2005/2008.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

Software/Hardware:

MS SQL Server 2005/2008/R2/2012, MS SQL Server Reporting Services, Integration Services, Analysis Services 2005/2008, MS Access, FrontPage, C, C , Erwin 5x/7x, Windows9x /2000/XP/Server 2003/2008, T-SQL, PL/SQL, HTML, XML, Crystal Reports, ODBC.

Confidential

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Involved in database designing using Normalization techniques. Involved in designing 4-N normalized database.
• Involved in migrating the data from legacy database to the newly designed normalized database.
• Created the migration scripts to migrate the data.
• Involved in using migration techniques like BCP, SSIS, and regular stored procedures and scripts.
• Created a Visual Studio database project on the new normalized database and included these migration scripts. This build is used to create entire database and migrate data from legacy DB.
• Created dedicated databases exclusively for adhoc reporting. Extensive use of indexes to increase the reports performance.
• Used the reporting tools MS SSRS 2008 R2 and Logi XML to build the reports.
• Expertise at using SSRS 2005/2008 to build various kinds of reports based on requirements. Developed Drill-through, Drill-down, Sub reports, and Cascading reports.
• Applied multi-tenant feature to the reports to provide security of data from user to user.
• Involved in installing and maintaining MS SQL Server 2005/2008/R2 and Logi XML instances in Dev environment.
• Developed Report Models to the end users to develop adhoc reports.
• Designed Database Models, Entity Relationship diagrams using Toad data modeler and MS Visio 2010.
• Developed new processes to facilitate import and normalization, including data file for counterparties.
• Extensive use of dynamic SQL, to increase the performance, efficiency and quality of code.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Created the cluster/non-cluster indexes on tables. Trace out for any table required any indexes and determine the type of index on it.
• Efficient use of joins and sub-queries in queries that retrieve data from multiple tables.
• Optimized indexes to improve queries and analyzed database performance with SQL Profiler.
• Created analysis services cube using SSAS 2008 based on the Star flake schema model.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment:

MS SQL Server 2008/R2, SSIS 2008, SSRS 2008, T-SQL, OLAP Service, Visual Studio 2005, ASP.NET, SQL Server Profiler, Team Foundation Server, Toad Data Modeller, Windows Sever 2005/2008/R2, Internet Information Services 6.0/7.0

Confidential

MS SQL Server/SSIS Developer

Responsibilities:

• Created Technical design specification documents based on the functional design documents and the physical data model.
• Upgraded MS SQL Server Reporting Server, which hosted around 200 reports, from 2005 to 2008 R2 in Production.
• Involved in installing and maintaining MS SQL Server 2005/2008/R2 in Production and Dev. environments.
• Designed Database Models, Entity Relationship diagrams using Erwin 7.2 modeler and MS Visio 2010.
• Created Database Projects in Visual Studio 2008 Team System/2010 for production databases, and deployed incremental changes using VSDBCMD.
• Created dedicated databases exclusively for adhoc reporting. Extensive use of indexes to increase the reports performance.
• Designed and implemented database which comprises of loading, monitoring, and alerting. The monitoring jobs checks for the missing data and retries to load data.
• Involved in database designing using Normalization techniques.
• Developed new processes to facilitate import and normalization, including data file for counterparties.
• Extensive use of dynamic SQL, to increase the performance, efficiency and quality of code.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Used Try-Catch and error for exceptional handling.
• Created the cluster/non-cluster indexes on tables. Trace out for any table required any indexes and determine the type of index on it.
• Efficient use of joins and sub-queries in queries that retrieve data from multiple tables.
• Created update, and insert triggers on the tables in order to restrict the garbage data entering into the tables.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Optimized indexes to improve queries and analyzed database performance with SQL Profiler.
• Extensive use of SSRS to build various kinds of reports based on requirements.
• Expertise at using SSRS 2005/2008 to build various kinds of reports based on requirements. Developed Drill-through, Drill-down, Sub reports, and Cascading reports.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using SSIS 2005.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Worked extensively on SSIS Package designs for Import/Export from various Data Source Flat file, Excel, to MS SQL Server databases and vice versa.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Responsible for performance tuning of the SSIS packages, used methods like execution trees and memory buffers

Environment:

MS SQL Server 2008/R2, SSIS 2008, SSRS 2008, T-SQL, OLAP Service, Visual Studio 2005, ASP.NET, SQL Server Profiler, Team Foundation Server, Toad Data Modeller, Windows Sever 2005/2008/R2, Internet Information Services 6.0/7.0

Confidential

MS SQL Server Developer

Responsibilities:

• Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from MS SQL Server 2005 to 2008.
• Penned various stored procedures for the purpose of application development.
• Tuned SQL statements and Stored Procedures.
• Held responsibility for disaster recovery and database maintenance plan.
• Performed replication of data.
• Performed data conversion from Text File into SQL Server Table.
• Maintained Data Integrity Validation.
• Designed and implemented data access stored procedures and triggers for automating tasks.

• Participated in issue research and resolution for production defects.

• Provided technical assistance during development and testing.
• Coordinated between the client and the other developers.

Environment:

MS SQL Server 2005, MS SQL Server 2008, T-SQL, Win NT v4, Win 2003, Crystal Report 8.5.

Confidential

MS SQL Server Developer

Responsibilities:

• Performed Installation, Configuration and Maintenance of MS SQL Server 2005.

• Extensively Involved in Designing models of Database.
• Involved in designing and implementing databases for various SQL staging areas.
• Performed extensive database scrubbing in application to bring the database into consistency by removing duplicate records, removing marked for deletion records, and correcting various referential keys between multiple entities through extensive use of T-SQL scripts.
• Applied business intelligence to perform extensive Data Scrubbing on existing data to meet new business requirement automated the process for new records with exception report generation to maintain data quality and consistency.
• Created a batch processing to prepare data in staging area for final migration of application by applying various business logics into stored procedures, functions, and other SQL objects.
• Analyzed data for quality and consistency, as well as troubleshoot data errors.
• Rigorously tested and debugged all the scripts to test the validity of the data after the export/import/delete was completed.
• Performed intensive Data Quality Testing on various Data Migration processes and wrote various post scripts to perform data correction using T-SQL.
• Extensively used running jobs in Enterprise Manager using job-scheduling tool.
• Tested the data and data integrity among various sources and targets.
• Associated with Production support team in various performances related issues.

Environment:

MS SQL Server 2005 Enterprise Edition, MS Access, DTS, Query Analyzer, BCP, SQL Profiler, Erwin 7.1, Import Export Data, Windows 2003 Server.