SUMMARY

• 8+ years of IT experience with extensive expertise in SQL Server technologies like MS SQL Server 2005/2008 suite of products like SSRS, SSAS and SSIS including development, deployment, testing and support.
• Experience with software development life cycle (SDLC) and Project Management Methodologies.
• Performed Migration of databases from SQL 2012 to SQL 2014 using SSIS.
• Experience in SQL Server Programming, Analysis Services and Reporting services 2005/2008.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008 .
• Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experience in data Extraction, Transformation and Loading (ETL) processes using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Involved in logical design of database using ERWIN.
• Experience in mapping data into database objects.
• Very strong Transact - SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and Functions.
• Expertise in Creation and Maintenance of Procedures, Triggers and Functions.
• Experience in creating, maintaining and implementing SQL scripts.
• Involved in creation of MRP (Master Release Plan).
• Experienced in the migration and implementation from other databases to MS SQL Server.
• Experience in providing technical support to internal developers and external clients
• Experienced in Data Loading using T-SQL, Fine Tuning of Database and improving Performance, Creating new Database, Creating and Modifying Table space and Optimization.
• Experienced in DTS and BCP of SQL Server to populate the data from various sources in various formats
• Excellent Communication, Analytical skills and Interpersonal skills. Versatile team player with proven problem solving skills and ability to quickly learn new technologies.

TECHNICAL SKILLS

Programming Languages: T-SQL, C, C#, C++, Assembly, HTML, DHTML, HTTP, Shell Scripting

Databases Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services(DTS), ETL, Query Builder, BCP, Bulk Insert, SSIS,SSAS,SSRS, BIDS,VSS, Crystal Reports, ERWIN.

Databases\Data Access: SQL Server 2000/2005/2008 , Oracle 9i/10g, Sybase, MS Access.

Other tools: MS Word 2003/2007/2010 , MS Excel 2003/2007/2010 , MS Outlook 2003/2007/2010 , MS Visio, SharePoint Server 2007.

Operating Systems: Windows NT/ 2000/2003/2008/ XP/7

PROFESSIONAL EXPERIENCE

Senior SQL Developer

Responsibilities:

• Understand Business Requirements.
• Worked primarily on the request made by front end developer depending on the business need.
• Created and modified stored procedures, functions, views and indexes to provide best performance.
• Created table, views, columns and constraints as per Java developer’s request.
• Created Sql server script and managed its implementation.
• Manually maintained an Excel sheet with charge code, companies name and various Information to manage implementation of scripts.
• Worked with DBA and QA in development of MRP
• Was primarily responsible for making sure scripts ran according to the MRP.
• Provided technical support to internal developers and external clients.
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting.
• Worked closely with other DBAs in the design and implementation process for deploying, upgrading, managing, archiving and extracting data for reporting
• Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Worked on DTS and BCP of SQL Server to populate the data from various sources in various formats.

Environment: SQL Server 2005/2008, Windows XP,SQL Enterprise Manager, Query Analyzer, SSIS, SSRS, SSAS, T-SQL, Visual studio2005, MS Excel

Confidential, Statesville, NC

SQL Developer

Responsibilities:

• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Worked with SSIS to design the packages for ETL Support.
• Generated T-SQL scripts for application development.
• Created Stored Procedures and User Defined functions.
• Created Indexes to speed up the queries.
• Created roles and permissions for the data warehouse applications.
• Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures
• Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2005.
• Performed Migration of databases from SQL 2012 to SQL 2014 using SSIS.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
• Scheduled Jobs and Alerts using SQL Server Agent
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in logical design of database using ERWIN and mapping the data into database objects.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2012/2014, Windows 2000/XP Query Analyzer, MS Excel (pivot tables) SSIS, SSRS, SSAS, T-SQL, Visual studio2005, ERWIN

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• Working in upgrading the DTS process to SSIS in SQL Server 2012
• Designed ER diagrams and normalization of database
• Generated SQL Scripts to create tables, Views, columns and constraints as per the requirement.
• Created various stored procedures to implement the Business logic
• Monitored the database using the tools Database Engine Tuning Advisor and SQL Profiler
• Created SSIS Packages to Extract, Transform and Load data from different environments.
• Applied SSIS Data Conversion & Data mapping to Import data from heterogeneous systems into MS SQL Server.
• Involved in data cleansing process by using SSIS Fuzzy Lookup Transformation & Data Quality Services in MS SQL Server 2012.
• Converted Reports from Crystal Reports to SSRS.
• Created SSRS Reports using variety of features like Reports, Charts, Filters, Sub-Reports, Drill Down, Multi-valued parameters as per the requirements.
• Scheduled Jobs to fire SSIS packages by using SQL Server Agent

Environment: SQL Server 2000/2005/2012 , SQL Server Integration Services 2012, SQL Server Reporting Services 2012

Confidential, Irving, TX

SQL Server developer (Offshore)

Responsibilities:

• Extensively wrote T- SQL codes for the project.
• Created Stored Procedures for Batch Processing.
• Developed stored procedures, triggers and functions and manipulated tables for data extraction, transformation, and data loading (ETL).
• Developed and modified the SSIS packages for ongoing data support.
• Manipulated tables, columns, triggers using TSQL.
• Worked with Business Objects and SSRS.
• Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data.
• Developed, maintained and supported the enterprise data warehouse using SSIS and SSRS system throughout the SDLC.
• Delivered SQL server reports to SharePoint to enhance team collaboration
• Generated reports according to business requirements using crystal reports and reporting services 2005.
• Created monthly reports using reporting wizard with Visual Studio
• Involved in Scheduling backups and maintenance.
• Upgraded DTS packages to SSIS.
• Modified an Existing crystal reports and SQL Reporting Services Reports.
• Created indexes to improve the performance of the queries
• Created backups and restore of the databases.
• Used data conversions to convert different data types
• Created Views for Extracting Data using TSQL.
• Performed Migration of databases from SQL 2000 to SQL2005
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Created Distributed Partitioned Views.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSISand also used BCP and Bulk Insert.

Environment: MS SQL 2000/2005,Sharepoint Windows NT/2000/XP,SSAS,SSIS, SSRS, Crystal reports Visual studio 2005, ASP 3.0,Business Objects, ORACLE 10g, MS Excel(Creating reports), SQL Query Analyzer, Enterprise Manager, MS Access, MS Word.

Confidential

Sql Server Developer

Responsibilities:

• Installed and configured MS SQL Server on Advanced Windows 2003 server.
• Generated Script files for changes made to stored procedures or views or any other database objects.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managed the use of disk space, memory and connections.
• Ran DBCC consistency checks, and fixed data corruption in application databases.
• Installed SQL Server service packs based on the errors and flaws that are found in the application.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• CreatedSSISpackage to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Monitored MS SQL server forperformance and network issues.
• Created and Rebuild the Clustered & Non Clustered indexes at regular intervals for better performance.
• Generated MIS reports usingCrystal Reports.
• Installed SQL Server service packs based on the errors and flaws that are found in the application.
• Provided problem resolution, troubleshooting, tracked and resolved issues in the database environment.

Environment: SQL server 2000/2005, Windows 2000/2003, Windows Cluster Server2003 MS Office, Crystal Reports, Visual Studio.NET, C#.NET.