SUMMARY:

• A skilled software professional with over 7 years of experience as a SQL Server Developer in Finance, Insurance sectors
• Proficient in MS SQL Server 2008R2 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Proficient in merging data from heterogeneous data sources like Excel, MS Access to MS SQL Server by using Import Export Wizard, DTS, SSIS, and Bulk Insert utilities.
• Experienced in migrating DTS Packages to SSIS, Migrating databases from SQL 2005/2008 to SQL 2008 R2 troubleshoot migration issues, Importing and exporting packages to SQL Server and file system.
• Expert in development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008/2008 R2.
• Worked on administration tasks involving batch jobs, backup and Recovery, Maintenance tasks, upgrades, creating logins, user mapping, databases/File groups/files/Transaction logs.
• Expert in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages, Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expert in different kind of data modeling for new database and dimensional modeling for data warehouse according to the business requirements.
• Expert in logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008 R2
• Expertise in Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS as an ETL tool.
• Deployed and Scheduled the Reports in Report Manager using data driven subscription, Ad-hoc report using Report Builder.
• Proficient in developing Parameterized Reports, linked reports, Sub reports, Create complex Reports (ex: drill down reports using different objects), drill through reports using SSRS.
• Expert in designing Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Hands on experience in SQL Performance Tuning by Query Optimization and building Database Maintenance Plans.
• Ability to deliver high quality of work and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

SKILL SET: MS SQL Server Management Studio, DTS, SSIS, SSRS, MS SQL Server 2008 R2,2008, 2005, 2000, 7.0, MS-Access, SQL Profiler, Query Analyzer, XML, HTML, C, C++, T-SQL,, C#, Windows 7/Vista/XP/NT/2000, Erwin, Microsoft Visual Studio 2005/2008, SQL Lit speed.

PROFESSIONAL EXPERIENCE:

Confidential, Nashville TN

MS SQL Serve\SSIS Developer

RESPONSIBILITIES:

• Removes duplicates, bad data from existing tables using ssis transformations.
• Backup data from Production server to development server for testing
• Uses triggers,stored procedure for various tables.
• Create SSIS packages using SSIS and SQL SERVER MANAGEMENT STUDIO using sql server 2008r2.
• Worked for patient records applications using SSIS,
• Load all records in CSV file and made clean records for the production server
• Used several stages like flat file, Aggregator, Remove Duplicates, Merge, sort, and Lookup during the development process of the DataStage jobs.
• Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.

Environment: MS SQL Server2008 R2,SQL Server Integration Services,Business Intelligens Studio 2008.

Confidential, West Chester, PA

MS SQL Server/SSRS/SSIS Developer

RESPONSIBILITIES:

• Transferred data from various OLTP data sources, such as, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Created several SSIS packages in Microsoft SQL Server 2008 R2.
• Worked on error handling a module consisting of data from bank, transactions, and currencies, countries, master and static.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Debugged and deployed reports in SSRS.
• Used with team members SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Wrote several complex stored procedures for the ease of application.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Team member constructed Cubes based on data volumes mostly adhering to Star Schema.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Maintained the physical database by monitoring performance and integrity maximum efficiency using SQL Profiler.

Environment: Microsoft SQL Server 2008 R2/2008, Business Intelligence tools - SSIS, SSRS, DTS, MS Access, T-SQL programming.

Confidential, Philadelphia PA

SQL Server Developer/Report Developer

RESPONSIBILITIES:

• Performance tuning, and optimization of procedures and queries.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Worked extensively with complex T-SQL queries, created functions, views and stored procedures.
• Installed and configured SQL Server 2008 in Test environment with latest service packs and migrated few databases.
• Modified the existing stored procedures to get the new functionality depending on the client requirement
• Created many tables with the cluster and non clustered indexes on columns.
• Created triggers to update insert and delete the data into the history table
• Wrote SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Involved in extracting the data from flat files in the development server and loading the clean data into the production server using SSIS
• Used various types of tasks such as Conditional Split, Derived Column, Data Conversion to validating data and redirecting the data to insert and updating the data.
• Used the SSIS Script task, look up transformations, execute SQL task, for each loop container, Data flow task in control flow to create the package.
• Performed Documentation for all kinds of reports and SSIS packages
• With team members Configured and maintained Report Manager and Report Server for SSRS.
• With team member create Reports using SSRS
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Rebuilding indexes on various tables.
• Developed database monitoring and tuning strategies.
• Experience in installation, un-attended deployments, configuration and administration of Windows 2003, XP, and Vista servers in very large environments.

Environment: TSQL,Microsoft SQL Server 2008 Enterprise Edition, SSIS, SSRS

Confidential . NYC

SQL Server/ SSIS/ SSRS

RESPONSIBILITIES:

• Gather requirements and understand the specifications of wholesale access certification needs.
• Designed and built prototype for access certification challenge on the wholesale end to integrate with Enterprise access certification tool.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing and MERGE statement in T-SQL, Entity Framework and LINQ, and new date/time, FILESTREAM and spatial data types provide powerful and easy to use application development enhancements.
• Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Used SQL Server 2008 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, data center services.
• Managed the historical data in the data warehouse from various data sources.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance

Environment: SQL Server 2008, SSRS, T-SQL, SSMS, BIDS, Excel 2003

Confidential, Philadelphia, PA

MS SQL Server/ SSIS/SSRS

Responsibilities:

• Designed software interfaces, communication modules and developed transactional code in stored procedures and triggers using T-SQL, SQL Server databases/replication. Used SQL Server, T-SQL.
• Developed online, multithreading server that processed financial and gaming transactions and ensured system scalability, load balancing, improved speed
• Worked with business analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes ofdata extraction and reporting using SSIS and SSRS.
• Developed and deployed SSIS packages also upgrading DTS packages to SSIS.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Wrote various stored procedures for generation of Audit reports and used BCP (Bulk Copy Process).
• Created various clustered indexes and optimized various T-SQL queries and done performance tuning using execution plan. Created parameterized reports for the brokers and clients using SSRS.
• Performed data validation and created reports for managers and project lead to monitor the load process.

Environment: MS SQL Server 2005, SQL Server Reporting services (SSRS), SQL Server Integrating Services (SSIS), T-SQL

Confidential

MS SQL Server Developer

RESPONSIBILITIES:

• Creation of user Databases and managing security, created stored procedures.
• Involved in up gradation from MS SQL server 7.0 to 2000.
• Writing stored procedures, checking code for efficiency. Routine backups and restoration.
• Data Transfers between various servers using DTS.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Monitor and manage SQL Server Agent jobs to ensure successful completion.
• Testing stored procedures performance and path of execution using SQL Profiler
• Recovering the Backups of MS SQL Server production databases in test servers as part of regular maintenance activities.

Environment: MS SQL Server 7.0/ 2000, SQL, T-SQL.

Confidential

SQL Server Developer

RESPONSIBILITIES:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports

Environment: SQL Server 2000, Windows XP/2000, Crystal Reports, Excel.