PROFESSIONAL SUMMARY:

• Over 8years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2008/2008R 2/2012/2014.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Good Exposure to entire Software Development Life Cycle (SDLC), documentation of software products with Agile Scrum methodology and also experienced in working with waterfall model.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Expertise in generating reports using SQL Server Reporting Servicesand MS Excel spreadsheetsfor the claims department.
• Experience in maintaining SQL Server security by assigning logins, server, database roles and server permissions.
• Expert in designing Enterprise reports using SQL Server Reporting Services generateddrill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2010/2012.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Writing MDX,DAX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP

Databases: MS SQL Server 2014,2012,2008R2,2008,2005

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)2016, SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual StudioPackages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Microsoft Office(MS), Excel Power Pivot, Excel Data Explorer, Cubes(tabular).

PROFESSIONAL EXPERIENCE:

Confidential, Omaha,NE

Sr. SQL BI /MSBI (SSIS,SSRS

Responsibilities:

• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Created the deployment scripts after the development is done for every project.
• Automated theSSISPackages using the SQL Server Agent Jobs and Octopus.
• Created tabular, matrix, chart, drilldown reports and parameterized, cascaded reports, MDX, DAX scripts in SSRS Reports also deployed into report builder.
• Trouble shoots theSSIS/SQL job Agent whenever necessary.Working in the agile environment and used Tortoise SVN to commit the code and share point for the tickets.
• Worked with the different teams from the offshore and onshore for the production support and maintain the SQL data and SSIS packages and SQL agent jobs with 24/7 on call tech support and resolved the issues. Involved in demoing the reports to the business in making a good decisions.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, 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.

Environment: SQL Server 2008/2012, SQL Server Business Intelligence Development Studio, 2013,2015,SSIS,SSRS 2014/ 2016, T-SQL, .Net, Share Point, VSTS Dashboard, T-SQL.

Confidential, New York

Sr. SQL BI /MSBI (SSIS,SSRS

Responsibilities:

• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Created the deployment scripts after the development is done for every project.
• Automated theSSISPackages using the SQL Server Agent Jobs and Autosys.
• Created tabular, matrix, chart, drilldown reports and parameterized, cascaded reports, MDX, DAX scripts in SSRS Reports also deployed into report builder.
• Trouble shoots theSSIS/SQL job Agent whenever necessary.Working in the agile environment and used Tortoise SVN to commit the code and share point for the tickets.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, 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.
• Involved in Documentation for all kinds of SSRS reports andSSISpackages into the Confluence Page and wrote PL SQL Queries and joints by using TOAD for creating the reports.

Environment: SQL Server 2008/2012, SQL Server Business Intelligence Development Studio 2010,2013,SSIS,SSRS 2014/ 2016, T-SQL, .Net, PL SQL, Share Point, Jira Dashboard, T-SQL.

Confidential, Atlanta, Georgia

Sr. SQL BI /MSBI (SSIS,SSRS).

Responsibilities:

• Worked as a Reverse Engineer in this project based on the existing project created the new SSIS Packages and SSRS Reports.
• Designed and developed SSIS Packages to import the data from multiple flat files located on the FTP site to theSQLServer database using various SSIS transformations like script task, Derived Column, Data Conversion etc, For each loop container, ExecuteSQLtask and Execute Process task.
• Worked with the different teams from Canada and Troy for 24/7 On call Production support and maintenance for SQL agent jobs and ssis packages scheduled.
• Involved in designing the schemas for new database and migrated the data using SSIS Packages.
• Expert on creating multiple kinds ofSSRS Reports like Tablix, Matrix, Drill Down, Drill Through, Sub Reports, Main Reports using Store Procedures and Direct SQL and also MDX Queries in data.
• Published reports on to the Share point and created Web pages in Share-point to show various reports generated from Excel andSSRSin one web part pagealso customized the report using CSS.
• Used Temporary tables, Table variables and Common Table Expressions (CTE) depending on the requirement.Transferred data from various sources like MS Excel, Flat File and SQL Server using SSIS and then created reports using this data using SSRS.
• Wrote complex T-SQL queries for data extraction, loading the Data in RDB (Relational Database) Landing through SSIS Packages.
• Worked on Team Foundation Server (TFS) for version controlling.

Environment: MS SQL Server 2016/2014 SQL Server Integration Services, SQL Server Reporting Services 2016, Team foundation server (TFS) 2010,PL SQL,T-SQL,C#,.NET Frame work 4.5,MS Excel, Windows 2008 Server.

Confidential

Sr. SQL BI /MSBI (SSIS,SSRS)

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• 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 in SQL Server 2000, 2005, 2008.
• Designing Tabular Models for Data Analysis of Summarized and Operational Data
• SQLDevelopment, stored procedures, views, tables, triggers, functions, synonyms etc.Performance Tuning: Indexing, query tuning, monitoring, optimization
• Designed the architecture of Content Management System and involved in making a Rich Interface Application, Developed ASP.NETUser Controls adding component reusability, Implemented SSIS Package (DTS) to Import data fromSQLServer, MS-Access.
• Coordinated with front-end for implementing logic in stored procedures and functions.Strong experience increatingandpublishingpackagesin Framework Manager.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Developed third party Advanced reporting components for the storage, retrieval and querying of a database across multiple servers. Also served as the administrator ofSQLclient/server for applications.

Environment: SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tabular, Excel 2013, XL-Cubed, Power view, Power pivot, Performance Point, C#,.NET,ASP.NET 2.0,MDX, Report Builder 3.0

Confidential

Sr. SQL BI /MSBI (SSIS,SSRS)Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• 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.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, truncatetables, and views and other SQL joins and statements for applications.
• Generated SSRSReports using Store Procedures, direct SQL, MDX, DAX Scripts for the various Drill-through reports, parameterized reports and linked reports using SSRS.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Windows2008 Advanced Server, MS SQL Server 2005/20, TSQL, Pl/SQL, Visual Studio 2008,Oracle 11g, SharePoint 2007/2010SSRS, SSIS.

Confidential, Dallas, TX

SQL/BI (MSBI-SSIS, SSRS Developer)

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Worked with a Business Analyst to explain about the SSRS Reports and SSIS packages and achieved the business requirements.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communitiesand Slowly Changing Dimensions.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables

Environment: Windows2007,2008 Advanced Server, MS SQL Server 2005/2008/2012, TSQL, PL/SQL 11g, Visual Studio 2008, SharePoint 2007/2010 Oracle, SSRS, SSIS, Erwin.

Confidential

SQL / BI(MSBI-SSIS, SSRS Developer)

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created MDX, DAX scripts to create database schema and database objects.
• Worked on Different Kinds of SSRS Reports Like Tablix, Matrix, Drill Down, Drill Through, Linked Reports, Sub Reports, Main Reports
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, SQL, Flat Files, Excelwith the help ofSQL Server 2005, 2008Integration services.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential

SQL/ BI (MSBI-SSIS, SSRS Developer)

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future .
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T - SQL code and SQL joins for applications.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.

Environment: MS SQL Server 2008R2/2008, T-SQL, MS Access, MS Excel,& Windows 2003 server, PL/SQL, Business Intelligent technologies like SSIS, SSRS, SSAS.