SUMMARY:

• Have 6 years of professional software development experience in the areas of Microsoft Business Intelligence (MSBI)covering integration (SSIS), analysis (SSAS), reporting services (SSRS) and SQL server.
• Highly motivated, quick learner and extremely versatile. Accepts responsibilities and job duties eagerlywith strong communication skills and role playing capabilities.
• Hands on experience in Extract, Transform & Load(ETL)development usingSQL ServerIntegration Services(SSIS) and installation, configuration and updates of SQL server.
• Experience inBI DevelopmentandDeploymentofDTS, SSISpackages from MS - Access, Excel, and SQL server.
• Good knowledge on Subqueries, Joins, triggers, functions and stored procedures using SQL server.
• Experience in providingError handling by using Event Handler, and Custom Logging for SSIS Packages.
• Designed and mapped using various SSIS Transformations like OLEDB command, Conditional Split, Aggregate, Multicast and Derived Column.
• Skilled in Precedence Constraints, Break Points, Check points and Logging.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Working experience designing STAR, SNOW FLAKE Schemas.
• Knowledge at data transformations like derived column, conditional split and aggregate, multicast, sort, execute SQL task to load data into data warehouse.
• Maintaining the log and audit information in the SQL tables.
• Experienced in designing and developing large amounts of enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in generating reports usingSQL Server Reporting Services and MS Excel Power View.
• Expertise in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports and AdHoc reports using SSRS.
• Expert in creating and deploying SSRS reports and report models on the report manager for user accessibility.
• Experienced in writing Parameterized Queries for generating reports, Formatting report layout, reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.

TECHNICAL SKILLS:

SQL server tools: SQL Server 2012/2008/2005/2000,SQL server tools for visual studioSQL Enterprise Manager, Query Analyzer, SQL Server Management StudioImport Export Data, Transact SQL,OLE-DBData Transformation Services (DTS)

BI tools: SQL Server Integration Services (SSIS)SQL Server Analysis Services (SSAS),OLAPSQL Server Reporting Services (SSRS)

Operating systems: Windows 97/98/2000/XP

Databases: MS SQL server, MS-access

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer /SSIS/SSRS - New Jersey

Responsibilities:

• Experience in creating tables, Views, Triggers, Stored procedures, User defined functions, Views, TSQL scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• 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.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Confidential

SQL Developer

Responsibilities:

• Created various T-SQL database objects such as tables, views, stored procedures, user defined functions, cursors, indexes and triggers.
• Debugged the processes, triggers and views, monitored the system and SQL server job schedule and recorded errors.
• Maintain and enhance the existing data warehouse, exports, and reports.
• Monitored processes for different data loads and resolved issues.
• Analyzed the performance, tuned, optimized and supported database objects to migrate to production, executed stored procedures and index sizing.
• Prepared presentations for end user training and manuals to perform operations using database.
• Debugging to fix existing issues in the system and writing code for enhancement.
• Enhancement to address issues within the functionality of the product without affecting the other functional areas.
• Experience with full software development cycle of a data warehouse, including requirements gathering, design, implementation, and maintenance.

Confidential

SQL server/SSIS

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application javascript:void(0);Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Responsible for creating, deploying and scheduling new SSIS packages.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints