PROFESSIONAL SUMMARY:

• Over 7+ Years of working experience in SQL Server and BI Stack (SSRS, SSIS, SSAS) in various domains
• Involved in business to develop Entity Relationship/data models, requirements document, and ETL specifications.
• AdvanceknowledgeinRDBMSconcepts,conceptual/logical/physicaldatamodels&Dimensional/Star/Snow Flakeschemas.
• Experienced inETL design, developmentandimplementation.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Proficient in working with SQL statements to extract data from data tables and verify the output data of the reports. Good at Creating tables, Sub queries, Correlated Sub queries, Joins, Views, Indexes, SQL Functions, Set Operators and other Functionalities.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, SPROC, Views, Cursors and Triggers.
• Expert in T - SQL Programming, query optimization and performance tuning using Execution Plan and SQL Server Profile.
• Experienced in using ETL tools to design SQL Server Integration services (SSIS) packages for Data Management applications.
• Expert in using transformations like Aggregate, Multicast, Data conversion, Merge Join etc.
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
• Involved in Data Modeling using Erwin 7.0/6.5 and Visio
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), and MDX interactive Reporting.
• Developed reports on SSAS & SSRS on SQL Server (2008/2008r2/2012). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Developed Drill through and Drill down reports using SQL Server Reporting Services (SSRS).
• Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
• Expert inPerformance Tuning and Optimization ofSQL Server.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Excellent analytical and communication skills to present points precisely and solve problems efficiently.
• Detail-oriented multi-tasking with strong technical concepts and organizational abilities.

TECHNICAL SKILLS:

Languages: T-SQL, SQL, Dynamic SQL, .NET Framework, C, C++, C#, ASP.NET, VBScript, XML, HTML, DHTML, HTTP.

RDBMS: SQL Server 2012/2008/2005, Oracle 11g/10g/9i/8i and MS Access 2003Database

Design Tools and Data Modeling: Red gate, MS Visio, ERWIN, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio.

Tools & Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Web Services, SOAP,TFS

Operating Systems: Unix, Windows NT/XP/2003/2008

PROFESSIONAL EXPERIENCE:

Confidential, Sioux Falls, SD

Senior SQL BI Developer

Responsibilities:

• Designed ETL architecture for daily incremental loads to data warehouse from source system.
• Worked with Changed Data Capture (CDC) tasks to achieve incremental loads.
• Worked on creating logical and dimensional modeling for various subject areas.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• 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 ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Created package configuration using environment variables.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Used data compression techniques for Back Up.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Designed SSAS cubes for all the developed DataMart models and identify measures with proper aggregate functions applied
• Created Linked Servers for data retrieval using OLE DB data sources and providers
• Created Customized Reports Using .Net

Environment: MS SQL Server 2008R2/2014, TSQL, SSIS, SSAS, SSRS, Business Intelligence Development Studio, Visual Studio 2008/2013, Team Foundation Server 2013.

Confidential, Winston-Salem, NC

Sr. SQL BI Developer

Responsibilities:

• Developed SSIS packages for data transfer between OLTP system to staging area and processed data to the data warehouse.
• Responsible for creating and coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, CSV and OLEDB Sources.
• Created batch files and developed ETL’s to extract the data from FTP server into the data base and vice versa.
• Used various SSIS control flow tasks such as Execute SQL task, Execute Package Task, FTP Task, Script Task, File system task, for each loop and sequence containers
• Worked on SSIS data flow tasks such as lookup, conditional split, derived column, Merge, Merge Join, Union All and multicast.
• Used SQL Server Agent to schedule the jobs to run SSIS Packages on daily, weekly and monthly basis.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally loaded into the Database.
• Created dimension and fact tables and developed the ETL’s to load dimension and fact tables for SSAS cube.
• Created relationships between measure groups and dimensions in a cube using MS SQL Server Analysis Services (SSAS).
• Designing and developing Database, Tables, Indexes, Stored procedures, Views, Triggers using SQL Server 2012.
• Extensively used joins, CTE’s and subqueries for complex queries involving multiple tables from different databases.
• Created SSRS reports like drill down, drill through, exception and ad-hoc for the finance, marketing and operations groups.
• Created SSAS multi-dimensional cube to summarize weeks of supply of our products.
• Developed ETL’s to extract the data from list to database and vice versa using SharePoint list source and destinations.
• Using Team Foundation Server 2008 and 2013 as the source version control system in order to handle complex changes for SSRS reports and ETL Packages.
• Involved in managing Clustered indexes and Non Clustered indexes and optimized queries.

Environment: MS SQL Server 2008R2/2012, TSQL, SSIS, SSAS, SSRS, Business Intelligence Development Studio, Visual Studio 2008/2013, Team Foundation Server 2013.

Confidential, Naperville, IL

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Played key role in gathering requirements for better understanding of business rules to successfully implement the project design.
• Developed SSIS packages to transfer data from OLTP systems to DataMart on hourly basis.
• Worked on customizing default Microsoft Dynamics GP reports with SSRS.
• Worked on Erwin Tool to create logical and Dimensional Modeling.
• Perfectly introduced and implemented Always on Availability Groups for the replication nodes and was successful in keeping the transactional system up and running in case of failover.
• Actively participated in the knowledge transfer sessions with Dynamics CRM 2011 integration into the system.
• Worked on creating necessary workflows and run the background plug-ins within Dynamics CRM to obtain required views.
• Constructed and deployed OLAP cubes under Visual Studio Analysis Services project.
• Worked on designing reports against OLAP cubes in PerformancePoint Server and deployed them to the SharePoint Site.
• Also worked on SSRS design for various reports including, drilldown, and drill through, dynamic cascade, graphical reports and dashboards.
• Written complex MDX queries and constructed named query dimensions with calculated members as per requirements for the reports.
• Responsible for complex store procedures, CTE’s, adhoc queries with dynamic SQL.
• Extensively worked on performance tuning to render faster results for the reports.
• Involved in disaster recovery plan design for the failover situations.
• Developed and executed several SQL server jobs as part of database maintenance using SQL Job Agent.
• Done lot of database documentation including ER diagrams for databases and also data dictionary with each column definition granularity.
• Worked on designing graphical reports with Performance Point Server.

Environment: MS SQL Server 2012, Microsoft CRM Dynamics, SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services, Visual Studio 2010, Performance Point Server, Erwin, C#, Microsoft Visio.

Confidential, Bridgewater, NJ

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Extensively worked on SSIS Import/Export Wizard, for performing the ETL operations.
• Developed SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Created the SSIS packages and deployed them to respective environments.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Involved in developing logical and physical modeling of the database using Erwin.
• Created and managed the databases in development environment.

Environment: MS SQL Server 2008, MS SQL Server 2008 R2, SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services, BIDS, Enterprise Architect, Erwin, Microsoft Visio, VB.Net, C#, Visual Studio 2010.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Actively participated in gathering the required information for the project.
• Involved in different stages of Project Life Cycle.
• Modified current database by adding tables, indexes and constraints.
• Created stored procedures for implementing the business logic.
• Responsible for Performance Tuning / Optimization
• Worked with complex T-SQL queries
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Proposed triggers on events to insert, update and captured the data
• Defined constraints, rules and defaults to ensure data integrity and relational integrity.
• Scheduled jobs by DTS, and created alerts for Error reporting.

Environment: SQL Server 2005, T-SQL, SQL Server 2005 Reporting Service, VSS, Windows 2003 Server, Enterprise Manager, Query Analyzer, SQL Profiler.