SUMMARY

• Over 8 years of experience in the area of Data Warehousing in Analysis, Design and Development of software applications using Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS), Pentaho kettle(ETL) tool and BIRT Reporting Tool.
• 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 SQL Server 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.
• Experience in development of mappings using needed transformations using Pentaho Kettle tool.
• Good knowledge on Data warehousing concepts like Star schema, Dimension and Fact tables.
• Extensively used Pentaho, BIRT client tools - Pentaho scheme workbench, Pentaho design studio, Pentaho kettle, Pentaho BI server, BIRT Report designer.

TECHNICAL SKILLS

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

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, Pentaho Kettle tool

Reporting Tools: SQL Server Reporting Services (SSRS), BIRT Reporting

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, 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, SQL server).
• 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.
• Worked on Pentaho Data Integration to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, oracle, MySQL).
• Created Kettle Jobs to perform filtering operations and to import data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
• Created Fact tables and relations with the dimensions in Kettle using different Transformations.
• Used different utility tools, scripting tools and look ups to transform data into the required form.

Environment: SQL Server 2008R2/2008/2005, SSIS, SSRS, SQL Server 2005 DTS, MS Access 2003, MS Excel 2003, OLEDB, Visio 2003, Microsoft Outlook, Windows 2003/2008 Server, Pentaho Kettle(ETL).

Confidential, Woodbridge, NJ

SQL SSIS/SSRS/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.
• Performance tuning of ETL scripts and DB stored procedures.
• Data migration from one environment to another environment using kettle ETL tool.
• Created ETL mappings using kettle 5.1.0 to move data from multiple sources like ISO links, URL\'s, CSV files etc.
• Involved in creating ad-hoc reports using BIRT Report Designer-Eclipse.
• Used Aggregations and grouping and parameter functionality to create sub reports / drilled reports as per the requirement.
• Used Java script as conditions in BIRT reports.

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, IDE Eclipse for Java EE developers 1.2.2, BIRT designer 2.5.2

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)

Environment: SQL Server 2005/ 2008/ 2008 R2, SSIS, 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