PROFESSIONAL SUMMARY:

• Over 7 years of extensive experience in the IT industry as a MS SQL Developer/BI Developer (SSRS, SSIS, SSAS) in MS SQL Server 2012/2008R2/2008/2005/2000 with various domains like Financial, Banking and Pharmaceutical.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, stored procedures, Indexes, CTE (Common Table Expressions) and triggers using SQL Servers to facilitate efficient data manipulation and data consistency.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as proactive team member.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Familiar in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server 2000 to 2005 and 2008 to 2008 R2 and 2008R2 to 2012.

TECHNICAL SKILLS:

RDBMS/DBMS: MS-SQL Server 2012/2008, R2/2005, Oracle 11g/10g, and MS Access 2010/2007/2005

Database Technologies/Tools: SSMS, SQL Profiler, Visual Studio 2010, Data Transformation Services (DTS), OLTP, BCP, SSIS, SSRS, SSAS

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems: Windows 7, XP, 2000, NT, Windows Server 2003 and 2008

Programming Languages: HTML, CSS, C#.Net, VB.Net, C++, T-SQL, SQL, PL/SQL, Dynamic SQL.

Design Technologies/Tools: Erwin, MS Visio

Data Warehouse / Business Intelligence Tools: SQL Server Analysis Services 2012/2008,Business Intelligence Development Studio

PROFESSIONAL EXPERIENCE:

Confidential - IL

MS SQL SSIS Developer

Roles and Responsibilities:

• Gathered user requirements for database solutions.
• Developed packages in SSIS for aggregating data files and database sales information and consolidating for reporting & cubes.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used multiple transformations in SSIS such as Conditional Split, Bulk Insert, Merge and Data Conversion.
• Created reports using Reporting Services 2008 R2 to retrieve data using database code objects such as stored procedures, views and multiple T-SQL queries.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Auto dispatching of simple and complex reports with parameters to different business users using Data driven subscriptions all across the organization based on defined schedules.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Documented all the reports such as technical specifications which include test cases, parameters involved and report running time and so on.

Environment: MS SQL Server 2008 R2/2012, Excel 2010, Visual Studio 2008, VBScript, Profiler SQL Server Management Studio 08/2012, SQL Server Business Intelligence Development Studio, SSIS.

Confidential, NJ

MS SQL SSIS/SSRS Developer

Roles and Responsibilities:

• Gathered user requirements, analyzed and designed of software and database solutions.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Improving query / stored procedure performance for fast generation of reports.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
• Monitor daily Jobs to ensure they are Running/Working as expected.
• Perform Quality Checks on Reports and the output files.
• Involved in the special project as assigned.

Environment: MS SQL Server 2008 R2, Excel 2010, Visual Studio 2008, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 08, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.

Confidential, NY

MS SQL Server Developer SSRS/SSIS/SSAS

Roles and Responsibilities:

• Gathered user requirements, analyzed and designed of software and database solutions.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports as well as interactive reports according to business requirements in time restricted environment.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Wrote SQL scripts to Insert,Update and Delete data in MS SQL database.
• Dropped and recreated the Indexes on tables for performance improvements.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Createddatabase, tables and procedures to update and cleanthe old data.
• Worked withthe front end application developers with theirqueries.
• Created SSIS Packages to import and export data from Excel, XMLand Text files.
• Documented all the reports such as technical specifications which include test cases, parameters involved and report running time and so on.
• Designed, developed and deployed reports, Drill down reports, Drill through reports and Parameterized reports in MS SQL Server environment using SSRS and also configured the Cache execution, report execution time out and scheduled Snapshot reports to increase performance.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.

Environment: MS SQL SERVER 2005, MS SQL Server 2008, SSIS, SSRS, DTS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access, Oracle, Microsoft Visio, Erwin, MS Office 2003, Excel 2003, Oracle10g, Visual Studio 2005/2008/2010, SQL profiler, Windows NT/2003, .NET framework 3.5

Confidential

MS SQL Server Developer SSRS/SSIS/SSAS

Roles and Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updatedfunctional specification and technical design documents.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
• Designed an OLAP with the help of ERWIN to visualize data structure.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using MS SQL Server Integration Services (SSIS) 2005.
• Generated reports using SSRS 2005 as per business requirements.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Developed measures and dimension members using multidimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment:MS SQL Server 2008 Enterprise Edition, SSRS 2008, SSIS 2005, DTS, T-SQL, VB Script, Windows Server 2008