SUMMARY

• Over 6 years of profound IT experience in MS SQL Server 2012/2008 R 2/2008/2005/2000/7.0 in very Large Data bases, extensively worked on SSIS/SSRS/SSAS, OLTP and OLAP.
• Experience in installing, configuring, managing, upgrading, migrating, backup/restore, monitoring and troubleshooting SQL Server 2012, 2008 R2/2005.
• Strong experience with T - SQL (DDL & DML) in implementing and developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, creating and updating tables and checking the database consistency by executing DBCC Commands.
• Experience in handling various databases like SQL Server, Oracle.
• Expert in SQL Server tools like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• Hands on experience with performing various SSIS data transformation tasks like look-ups, fuzzy look-ups, conditional split, merge-join, joins, event and error handlers.
• Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports and Ad hoc reports in multiple formats using SQL Server Reporting Services (SSRS).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS).
• Experience in Managing Security of SQL Server 2008/2005/2000 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Good SQL server administration skills including, backups, disaster recovery, database maintenance, user authorizations, database creation.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Knowledge of various testing tools like Win Runner, Load Runner and QTP for testing Client /Server and Web based applications

TECHNICAL SKILLS

Database: MS SQL Server 2008/2012

Tools: SSIS, SSRS,SVN

Database Tools: SQL Profiler, SQL Query Analyzer, Performance Monitor

Database Administration: SQL Server

Languages: T-SQL, C

Operating Systems: Windows XP/Vista, Win 2000/2003 Server

Other Tools: MS Office Suite, Adobe Suite

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

SQL/BI Developer

Responsibilities:

• Played key role in Migrating GWF’s database from Oracle to SQL - Server 2012.
• Responsible to re-writing all the oracle packages, procedures and functions from PL/SQL to T-SQL
• Developed optimal stored procedures and queries to create data sets for reports
• Effectively implemented time zone and day light saving aware procedures as the application supports
• Defined and implemented Error Logging framework and working on implementing Auditing framework.
• Working on T-SQL procedures and functions required by the services layer for verifying data and do Business Rules validation.
• Redesigned and Developed Table Partitioning and Indexing Strategy on required tables for better performance of reports and UI.
• Responsible for creating and managing deployments scripts.
• Created SSIS packages to schedule the jobs to run daily/monthly/quarterly.
• Generated daily, weekly and monthly reports for the managers. Administered interface to organize reports and data sources, schedule report execution and delivery and track reporting history SSRS 2005. Tested the reports and fixed bugs in the stored procedures.
• Followed build and release process
• Worked closely with testing teams.

Environment: SQL server 2012, T-SQL, SQL Query Analyzer, SQL profiler, SSIS,SSRS

Confidential, East Greenwich, RI

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Actively involved as a part of a team for gathering and analyzing the User Requirement. Gathered Requirements from the users and checked the structure of the schema and data with the Data Modular.
• Create database objects inSQL Server including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes. Creating and managing schema objects such as tables, views, indexes, procedures, triggers and Maintained Referential Integrity.
• Extensively used SSIS for transferring data manually from DTS to SSIS packages using SSIS 2005. Create SQLServer Integration Services (SSIS) Packages. Generated reports using Global Variables, Expressions and Functions based on the requirements Using SSRS 2005.
• Design Reports Using SQLServer Reporting Services (SSRS) identified the database tables for defining the queries and defined datasets for report generation.
• Defined reports layouts including report parameters and wrote queries for drill down reports as per client's requirements using SSRS 2005. Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS.
• Generated daily, weekly and monthly reports for the managers. Administered interface to organize reports and data sources, schedule report execution and delivery and track reporting history SSRS 2005. Tested the reports and fixed bugs in the stored procedures.
• Maintained the physical database by monitoring performance, integrity and optimized SQLqueries for Maximum efficiency using SQLProfiler. Established backup and recovery of SQLreporting services.

Environment: MSSQL Server 2012/2008/2005, Integration Services (SSIS), Reporting Services (SSRS 2005), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Excel.

Confidential, Woburn, MA

BI Consultant

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created ETL packages with different data sources (SQLServer, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Performed incremental data load packages in SSIS.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Dynamically supported business users for given requirements and developed the reports accordingly..
• Created reports to retrieve data using stored procedures.
• Wrote queries to generate reports for analysis of data using SQLServer Reporting Services, Report Builder.
• Developed Ad Hoc reports and deployed it onto Reporting Server using Report Builder. Also, formatted the report layout for the requirement of the end users.
• Designed and created report templates, bar graphs and pie charts based on the financial data.
• Extensively used SQLReporting Services and Report Builder Model to generate custom reports.
• Developed various T-SQL stored procedures, triggers, views etc.
• Worked to improve the Performance tuning on the Stored Procedures.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for complex Databases.
• Monitored and modified Performance using execution plans and Index tuning
• Generated daily, weekly and monthly reports for the analysis of managers and end users.

Environment: MS SQL Server 2012/2008, SSIS, SSRS, Report Manager, SQL Server Profiler, Windows XP.

Confidential

SQL Server Developer

Responsibilities:

• Created Database as per the requirement to maintain the records using SQL server 2005
• Maintained and supported the SQL Server databases as a developer helping administrator
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, constraints, triggers and procedures
• Written Stored procedures and triggers to implement business rules
• Used DDL and DML for writing triggers, stored procedures, and data manipulation
• Maintained disaster recovery Backup and Re-Indexing was implemented to increase the performance
• Created user profiles and corresponding read, write and DDL and DML access properties were maintained on the database
• Created documentation as required

Environment: MS SQL server 2005, T-SQL, MS-Excel, MS-Office.