PROFESSIONAL SUMMARY:

• Over 7 years experience in Database design, development and administration using MS SQL Server 2008, 2005 and 2000 in Production, Test, Development environment.
• Strong working experience in SQL Server and T-SQL in constructing triggers, tables, Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Upgrade DTS packages to SQL Server Integration Services SSIS .
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services DTS and SSIS, Bulk Copy Program BCP and Bulk Insert.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Expertise in Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clustered indexes on tables
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Sub reports and filters, charts in SSRS 2005/2008.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication, Mirroring, DTS Packaging, SQL Server clustering.
• Experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications Database systems using MSSQL 2000/2005/2008 for both OLTP Batch Processing, Online Processing Business Intelligence SSIS, SSRS applications.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations, Suggested backup strategies.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role and 24x7 on call Production support.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: MS SQL/BI Developer

Responsibilities:

• Worked closely with client to understand the business requirements, data analysis and identify final deliverables
• Identified a clear set of project milestones and the required timelines.
• Maintaining and Managing SSIS batch jobs for Development, Test and Production Environments
• Support daily work request from different environment groups requesting Modifications and creating new stored procedures, tables, and SSIS packages.
• Design, Development, configure and Support of new databases, tables, jobs, SSIS Packages and Other Database Objects
• Troubleshoot and resolve issues reported by the groups
• Developed and Optimized Stored Procedures, View, and User-Defined Functions for the Application
• Created complex Stored Procedures for better performance to generate reports.
• Wrote complex queries using join to extract data from different servers.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS.
• Involved in the daily meetings of the project design and development using Scrum project methodology.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in debugging SSIS Packages to maintain data efficiency.
• Deployed SSIS packages in both Development and Test environments. Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Responsible for report generation using SQL Server Reporting Services SSRS based on business requirements.
• Build ad-hoc reports using SQL Server Reporting Services SSRS , Excel.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services SSRS .

Environment: MS SQL Server 2005/2008, SQL Server Integration services SSIS 2008, SQL Server Reporting services SSRS 2008, SQL Server Management Studio, VB, BIDS, DTS, T-SQL, Windows Sever XP/2007, SQL Profiler, VB.NET, Query Analyser, Erwin 7.0

Confidential

Role: SQL Server Developer

Responsibilities:

• Involved in migration of SQL 2005 to SQL 2008.
• Checking database integrity, Creating new databases, tables, views and Stored Procedure.
• Developed complex T-SQL code, stored procedures, functions, views and triggers for the application.
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source Oracle , Excel spreadsheet to SQL Server 2008.
• Migrated DTS packages to SSIS packages by modifying those packages.
• Designed ETL packages dealing with different data source and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Created ETL SSIS packages both design and code to process data to target databases.
• Design, deploy and maintenance of various SSRS Server 2008.
• Hands on Job Scheduling of SSIS Packages through SQL Server Agent.
• Done some Data Validations for the existing Procedures and SSIS Packages.
• Excellent in High Level Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, flat file, Text file by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Designed and implemented parameterized and cascading parameterized reports using SSRS
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers
• Responsible for writing T-SQL code for creating cursor and handling data validations.

Environment: MS SQL Server 2005/2008, SQL Integrations Services SSIS , SQL Server reporting services SSRS , TSQL, FTP, C scripts, TFS.

Confidential

Role: Sr SQL Server Developer /SSIS/SSRS

Responsibilities:

• Gathered business requirements from users and translated them as technical specification for development.
• Identified various data sources, formulated data dictionaries, design and develop data models based on the given specs and requirements.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Migration of stored procedures and database objects between development and test environments

Environment: MS SQL Server 2005/2008, SSIS, SSRS, DTS, Windows Server 2003, Windows XP.

Confidential

Role: SQL Server Developer

Responsibilities:

• Created Stored Procedures and Database objects.
• Involved in implementation and scheduling of the backup and maintenance strategy on the development server.
• Responsible for backups/restores, designing DTS packages and maintenance.
• Reviewed and optimized SQL queries, Stored Procedures, Views and Triggers to achieve maximum efficiency and scalability.
• Daily Database backups and integrity checking.
• Data Transfer using DTS from Development to Testing and to Production Servers.
• Designed and created Stored Procedures, Tables Views and DTS packages for existing SQL Server Databases.
• Involved in Data Migration and used DTS to import and export data into tables using SQL Server 2005/2008, creating tables, views and Stored Procedures using SQL Server.
• Wrote Stored Procedures for Reporting purposes and developed various reports using SQL Server Reporting Services.
• Used T-SQL to create various queries.

Environment: SQL Server 2005/2008, Windows NT/2000 server.

Confidential

Role: SQL Developer/ETL/Reporting Analyst

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services SSRS
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Created scheduled jobs to execute DTS and SSIS packages.
• Transferred/Rewrote DTS packages to SSIS programs. Hands on working experience with configuring every aspects of SSIS 2005.
• Updated functional specification and technical design documents.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Designed an OLAP system with the help of ERWIN to visualize data structure.
• Generated daily, weekly and monthly reports using SSRS 2008.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Environment: SSIS, SSRS, MS SQL Server 2005/2008, C , SharePoint, Visual studio 2008, MS Access, MS Excel, Crystal Reports, MS Office Access 2007.