SUMMARY

• 8 years of experience in design, development & analysis of SQL Server 2005/2008/2008 R2/2012 and SQL Server Business Intelligence Tools (BIDS) - SSIS, SSRS and SSAS.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary Key, Foreign Key, Unique, Default), Indexes.
• Expertise in writing T-SQL Queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User- defined functions, views and cursors.
• Extensive experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed views, Functions, CTE's, Table Variables and stored Procedures.
• T-SQL Programming using DDL,DML,DCL commands for various business applications.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Proficient in usage of SSIS control Flow Items (For Loop, Execute Package/SQL tasks, Script task, send mail task) and SSIS Data Flow items ( Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS Packages (.Dtsx) involving ETL Process, extracting data from various Flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) ( 2005/2008/2012 ).
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import and Export Data.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drill down and Drill through reports using SQL SSRS 2005/2008/2012 , Cognos,Business Objects
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-reports, Drill Down, Drill- Through, Multi-valued parameters etc.
• Having good knowledge on HTML and Java Script and ability to implement those technologies in Cognos reports.
• VB.Net and other .NET languages C#,ASP.NET used for Script task.
• Built effective queries for high performance reports and rendered them to HTML,XML,PDF and Excel formats using SSRS. Supported team in resolving SQL Reporting Services and T-SQL related issues and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill down, summary, form, OLAP and Sub reports, and formatting them
• Experience in Designing, Creating, Deploying and Processing of cubes using SSAS.
• Knowledge in Designing Intelligence reports using Business Objects, Cognos, Power BI
• Expert in developing Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2012/2008R2

TECHNICAL SKILLS

BI & DW Tools: Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SQL Server Management Studio

ETL Tools: MS SQL Server Integration Services 2012/2008 R2/2005, DTS

Databases: SQL Server 2012/2008/2005 , Oracle,Teradata, Ms Access

Languages: SQL,PL/SQL,T-SQL,VisualStudio 2012/2010/2005 , C,C#,Asp.Net, VB.Net

OLAP/Reporting Tools: SQL Server Analysis Services, MDX, SQL Server Reporting Services (SSRS) 2012/2008/2005 , Crystal Reports, MS Excel, Business Objects 5.1,XI R3, Cognos 8/7.0,Power BI

Web Technologies: HTML,XML,CSS, MVC,WEB API, JavaScript

Operating Systems: Windows Server 2003/2008, Windows 7/vista/XP, NT, Unix

DB Modelling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, louisville, KY

Sr.SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and score card/ dashboards on SQL Server 2012 using SSAS, SSIS/DTS, SSRS .
• Developed, deployed and monitored SSIS packages for new ETL processes and upgraded the existing DTS packages to SSIS for the on-going ETL processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Extracted data from various sources like SQL Server 2008/2012,oracle,.CSV,Excel and Text file from Client servers and through FTP.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Developed T-SQL Stored Procedures for SSIS packages. Performed query optimization and implementing good programming practices.
• Analyzed and developed new reports using MVC 3 with C#/ASP.Net.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into data ware house.
• Implemented and maintain ETL processes & SSIS packages to consolidate data from other business units and departments (Excel, CSV, and text).
• Designed and developed SSIS packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Worked on different levels of ETL like Extract Data from source system to staging and then from staging to load data in Database Tables.
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.
• Implemented the Master child package Model for easier maintenance and better performance of SSIS packages.
• The packages created included a variety of transformations, for example slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Used various transformations in SSIS dataflow, Control flow using for loop containers, and fuzzy lookups.
• Implemented Event Handlers, Error Handling in SSIS packages and used package configurations to make packages available for deploying in different environments..
• Created SSRS reports based on requirement. Create Linked reports, sub reports, parameterized reports, drill down reports.
• Scheduled the ETL process using SQL agent Jobs Designed complex and Created email alerts for completed jobs.
• Involved in documentation of the Reports, Database, and SSIS packages.

Environment: Microsoft SQL Server 2012/2008 R2 Enterprise edition, SQL Server Integration Services(SSIS), SQL server Reporting Services(SSRS),BIDS, Microsoft Visual studio, C#, SQL profiler, MVC 3

Confidential, Dallas, Texas

Sr. SQL Server Developer

Responsibilities:

• Creating Database objects - Tables, views, and Functions and developing procedures on application functionality for performance improvement in database.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Creating and Modifying T- SQL Stored Procedures/Triggers for validating the integrity.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated packages using different Transformations like Lookups, Derived Column, Merge join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in providing Logging, Error handling by using Event Handler, and custom Logging for SSIS packages.
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.
• Developed Logical and Physical data models using Erwin.
• Experience in Designing Intelligence reports using Cognos.
• Implemented Java Scripts in reports.
• Developed Custom reports and deployed them on server using Cognos.
• Designed and developed Data mart using SSAS.
• Analyzed and created Multidimensional cubes in Facts and Dimension Tables using SSAS.

Environment: MS SQL Server 2012/2008R2,Cognos 8,SQLServer Analysis Services(SSAS)SQL Server Integration Services (SSIS), Business Intelligence development Studio(BIDS),MDX MS Visio, Erwin, JavaScript

Confidential, Pittsburgh, PA

SQL Server BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Gathered user requirements, analyzed and designed of software and database solutions.
• Developed T-SQL stored procedures for SSIS packages. Performed query optimization and implementing good programming practices.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning and optimizing indexes by using performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Developed applications using ASP.Net, C# with SQL Server at the back end.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Migrated DTS packages using DTS editor Wizard in SSIS, validated and tested all packages on development server.
• Implemented and maintain ETL processes & SSIS packages to consolidate data from other business units and departments (Excel, CSV, and Text).
• Designed and developed SSIS packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Developed PL/SQL parameterized stored procedure in oracle package from SSIS.
• Used Script component in the dataflow task to execute oracle PL/SQL code.
• Worked on different levels of ETL like Extract Data from source system to staging and then from staging to load data in database tables.
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.
• Created SSIS/DTS packages for application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Used various transformations in SSIS dataflow, Control flow using for loop containers, and fuzzy lookups. .
• Implemented Event Handlers, Error Handling in SSIS packages and used package configurations to make packages available for deploying in different environments.
• Worked with Data Modeling and handling OLTP Databases and ability to design databases upon requirements.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Created and Configured OLAP cubes (star schema and snow flake schema modeling) using SSAS 2008 and created calculated members using MDX and dimensions design and scaling to large numbers of users.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing dimensions, Hierarchies and adding the aggregations to the cube.
• Expertise in writing complex MDX queries for calculated members and measure groups (SSAS).
• Created reports using stored procedure and experience in building reports on analysis services cubes (SSAS).
• Created different graphs like Pie charts, Bar charts, line charts.
• Wrote the queries for the drill down reports, identified and added the report parameters.
• Created Report subscription and Data Driven Subscription using SSRS 2008.
• Formatted the reports using the global variables and expressions, deployed the generated reports on to the server.
• Created SSRS reports based on requirement. Create Linked reports, sub reports, parameterized reports, drill down reports.
• Organized and performed code reviews for the SSIS packages, SSRS Reports and the objects involved.

Environment: Microsoft SQL Server 2005/2008 R2 Enterprise edition, SQL Server Integration Services(SSIS),SQL Server Reporting Services(SSRS),BIDS, Microsoft Visual studio, Internet information Server (IIS), ERWIN, C#,ASP.net, PL/SQL, SQL profiler.

Confidential, Jersycity, NJ

MS BI Developer

Responsibilities:

• Created new Stored Procedures, functions and database triggers according to the complex business logic.
• Migrated Organization Orders, Adjustments, Objectives and Callidus data in various format like text based files, Excel spread sheets to SQL server databases using SQL Server Integration Services (SSIS) to overcome the transformation Constraints.
• Using the update Statistics in the case of change in indexed columns for optimized performance.
• Performed the query tuning to optimize the procedures and triggers to be used in production.
• Used multiple transformations in SSIS to pull data from SQL Server and exported to Excel spreadsheets and vice versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services(SSIS).
• Performed the Migration the Existing DTS packages to the SSIS Batch jobs.
• 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.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS..
• Deployed and generated reports on to the server using the Reporting Services Report Manager..
• Developed logical and physical data models using Erwin.
• Scheduled and Maintained jobs for data messaging from development server to test server for generating daily reports.
• Developed and executed SSIS packages to extract and populate the data from the various data sources.
• Created and managed the databases in development environment.

Environment: SQL server 2008/2005, SSIS,SSRS, Windows Server 2003, C#.Net,VB.Net, MS Access 2003, Erwin.

Confidential

SQL/BI Developer

Responsibilities:

• Created tables, views, stored procedure as per design needs..
• Maintained data integrity by performing validation checks.
• Optimized queries tuned and monitored server performance.
• Involved in fine tuning of database objects and server to ensure efficient data retrieval.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the users.
• Developed, monitored and deployed SSIS packages.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Identified the database tables for defining the queries for the reports..
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Deployed the generated reports on the server.

Environment: MS SQL Server 2005, MS SQL Server 2000, MS SQL Server Integration Services (SSIS), Server Analysis Services (SSAS),Server Reporting Services (SSRS).