SUMMARY

• Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQL tools like SSIS, DTS, Bulk Insert and BCP.
• Good working knowledge of SSIS Control Flow items (For Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items.
• In - depth knowledge of Transact-SQL (T-SQL DDL, DML), Indexes, Views, Stored Procedures and User defined functions, Triggers to facilitate efficient data manipulation and data consistency.
• Experienced in using multiple transformations provided by SSIS such as script component,Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.
• Good Knowledge of SQLServer Database Backups, scheduling Jobs and Performance tuning.
• Experience in Performance Tuning in SSIS packages by using Partial Transformations, Block and non-block Transformations.
• Hands on experience in using SSRS to create reports like Drill down, Drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports and formatting.
• Experience in using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Experience in scheduling of SSRS reports to refresh and run on daily, weekly and monthly basis
• Expertise in deploying SSRS reports using direct deployment and Uploading files using the Report Manager.
• Hands on experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Experience in using global variables and expressions for the reports.
• Expertise in Error handling and debugging coding issues. Troubleshoot production problems.
• Involved in Query Optimization and Performance Tuning using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC).
• Expertise in creating Cubes and Dimensions using SSAS.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions with SSAS.
• Good Working knowledge in creating Aggregations, partitions in cubes using SSAS.
• An Excellent Team Player possessing good communication skills, commitment and hard­working attitude.

TECHNICAL SKILLS

Database Management System: MS SQL SERVER 2012/2008R 2/2008/2005/2000 , Oracle, MS-Access

Database Utilities: Enterprise Manager, query analyzer, SQL Profiler, SQL Server Management Studio.

Data modeling: ERWIN, Microsoft Visio 2010/2007

ETL Tools: SQL Server Integration Services(SSIS), DTS

Reporting Tools: SQLServer Reporting Services (SSRS)

Programming Language: TSQL, C, C++, C#, SQL

Web Technologies: HTML, XML, IIS

Operating Systems: Windows Server 2000/2003/2008/2008 R2/2012

Utility Tools: MS Office, Visual Studio, Excel, PowerPoint, outlook

PROFESSIONAL EXPERIENCE

Confidential, Woodbridge, NJ

SQL SSIS/BI Developer

Responsibilities:

• Followed the Microsoft recommended best practices in designing, developing, implementing and testing of the ETL using SQL Server Integration Services(SSIS).
• Used DDL/DML to code triggers, stored procedures, and data manipulation for automating tasks.
• Created Complex Stored Procedures for implementing the business rules, also worked on SQL joins, CTEs (Common Table Expressions), Pivot and Unpivot tables, Materialized Views, Aggregate Conditions.
• Built up high performance ETL packages, migrated data from SQL Server Database, Flat Files and MS Excel, cleaned and backed up data, and synchronized daily transactions by using SSIS
• Used SQL Profiler and Query Analyzer to optimize DTS/ETL package queries and stored procedures.
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures.
• Migrated data from Heterogeneous Data Sources to a Staging SQL Server DB with ETL packages using the combination of BCP and SSIS
• Monitor the Sql server Agent jobs and fix the jobs on failure.
• Responsible for working on performance tuning of reports.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Wrote queries for drill down reports. Identified and included report parameters.
• Formatted the reports using Global variables and expressions.
• Deployed generated reports on to the server
• Created Aggregations, partitions and calculated members in the cube using SSAS.
• Migrated DTS packages from SQL Server R2/2012 SSIS packages.

ENVIRONMENT: MS SQL Server 2012/2008R2/2005, Business Intelligence Development Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Visual Studio 2013, T­ SQL, .Net Framework 4.5

Confidential, Somerset, NJ

SQL SSIS/SSRS/BI Developer

Responsibilities:

• Involved in gathering requirements, systems design for the new applications, coordinate the enhancements to the applications and deliver them in time
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, oracle, SQLserver).
• Created Configurations to make packages portable and created Event handlers for handling package error.
• Created SSIS Packages to perform filtering operations and to import data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to fulfill business needs.
• Created tables, relationships, triggers and indexes for enforcing Business Rule
• Involved in SSIS packages to bring data from Excel and Flat Files using MS Business Intelligence (BI) tool.
• Created Fact tables and relations with the dimensions in SSAS.
• Created Aggregations, partitions and calculated members in the cube.
• Extensively involved in the SSAS storage and partitions calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Developed the end-user documentation and performed periodic updates of the design documents.
• Created Single Value Parameters, Multi-value Parameters to control data in the report.
• Extensively used Joins and Sub-Queries to simplify Complex Queries involving multiple tables.
• Wrote complex SQL queries using joins, stored procedures and user defined functions to verify the data from the database to generate reports based on the business requirements.
• Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV, generate reports with parameters, sub reports, cross tabs, charts using SSRS.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer andReport Builder.

Environment: SQL Server 2008R2/2008/2005, SSIS, SSRS, SSAS, SQL Server 2005 DTS, MS Access 2003, MS Excel 2003, OLEDB, Visio 2003, Microsoft Outlook, Windows 2003/2008 Server.

Confidential, Roseland, NJ

SQL SSIS/SSRS/BI Developer

Responsibilities:

• Created packages inSSISwith error handling and logging inSSIS.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• UsedSSISto createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records
• CreatedSSIS packages to Export data from Flat files to SQL Server Database.
• Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge using SQL Server 2008 R2.
• Created SQL Server Reports and developed query for generating drill down reports using SSRS 2008.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Involved in creating Dataset in the MS Reporting services (SSRS)
• Involved in creating Sub reports in MS Reporting services (SSRS)
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: SQL Server 2005/ 2008/ 2008 R2, SSIS, SSAS, BIDS, C#.Net, .Net Framework 3.5, ASP.Net, Erwin, Profiler, MS Excel.

Confidential, Springfield, MA

SQL BI Developer

Responsibilities:

• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File and vice versa.
• Used various control flow tasks like for Loop, Execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Involved in Job scheduling and alerts.
• Maintained report models for ad hoc reports and deployed on report server.

Environment: SQL Server 2000/2005/2008 , Visual Studio 2000/2005, DTS packages, BCP, SQL Management studio, SSIS, SSRS