SUMMARY

• Over eight years of strong experience in SQL Server, Analysis, Testing with Data mart, Data warehouse, Data modeling and Business Intelligence Tools.
• Excellent command with MS SQL Server 2005/2008/2012 ; worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Assisted development stay with the application design to facilitate effective use of database languages, methodologies and establishes standards.
• Experience in writing complex Transact SQL (T - SQL) Queries, Sub-queries, Dynamic SQL to create database objects - stored procedures, triggers, user-defined functions, views, indexes, common table expressions (CTEs) and implementing constraints (primary key, foreign key, unique key, etc.).
• Performance Tuning in SQL Server - using SQL profiler, parameter sniffing, and DBCC commands, partitions and partitioning, Bulk Loading Data (BCP), indexed views and schema binding, STATS, clustered/non clustered indexes.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP and experience with working on Data analysis, and Data migration.
• Experienced in maintenance and production support for all Data Warehouse, SQL Server and SQL SSIS packages enhancement and issues.
• Experience in whole cycle of DTS/SQL server integration services (SSIS 2005/2008/2012 ) packages (Developing, Deploying, Scheduling, Troubleshooting and Monitoring) for performing data transfers and ETL purposes across different servers.
• Experience in implementing and managing Event handlers, Package configurations, Logging, system and User-defined variables, Check points and Expressions for SSIS packages.
• Creating SSIS packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, text format data) by using multiple transformations provided by SSIS such as Data conversion, Conditional Split, Bulk Insert, Merge and Union.
• Experience in designing enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012 ) generated tabular, matrix, Drill down, Drill through, Parameterized, cascaded parameterized, Cross tab, Adhoc reports, linked reports, Sub-reports, Charts and Distributed reports using Business Intelligence Development Studio (BIDS).
• Experience in Migration of SSRS reports from SQL 2008 to SQL 2012.
• Generated reports in various formats like table format and matrix format using Reporting services (SSRS).
• Used DUNDAS Dashboard, Charts, Gauges and Maps.
• Experienced in designing and deploying dashboards using Data visualization tools- Tableau, DUNDAS and Power BI.
• Experienced in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extensively used Ralph Kimball Methodology in designing the DataMart’s.
• Good knowledge of defining and deploying and developing Star Schema, Snow flake Schema and dimensional Data modeling, cubes using MS SQL Server Analysis Services (SSAS) on a data warehouse.
• Experience in developing OLAP cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations using multi-dimensional expression (MDX), perspectives and roles.
• Good knowledge in developing and implementing disaster recovery model, and replication models.
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, MDX, C# .NET, XML, VB Script.

RDBMS: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , MS Excel / MSWord / MS Access, DB2, Oracle 9i/10g.

SQL Server Tools: SSMS, Configuration Manager, Query Analyzer Profiler, Database Tuning Advisor, Erwin (Data Modeling), Bulk Copy Program (BCP), OLAP, OLTP.

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Data Transformation Services (DTS), Visual Studio, Business Intelligence Development Studio (BIDS), Data Tools, DUNDAS, Tableau, Power BI.

Operating System: Windows 2000/2003 Advanced Server, Windows XP/7/8/12, UNIX.

Application Packages: Microsoft Office Suite, Visual Source Safe, Team Foundation Server (TFS), Citrix.

PROFESSIONAL EXPERIENCE

Confidential, Southfield, MI

Sr.SQL/ BI Developer

Responsibilities:

• Responsible for Migration of SQL server 2005 to SQL server 2012 by writing Migration scripts and a clause that checks whether the migration script is valid for the version of the target database.
• Installed and Upgraded fromSQLServer2000, 2005, 2008R2 toSQLserver on Multiple DEV / QA / PRODServers.
• Experienced in improvingSQLServerusing windows performance monitor to improve theserver performance.
• 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 SSIS packages.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created complex Stored Procedures, Triggers, Functions (UDF), Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Package Configuration files and deployment wizard.
• Deployed and scheduled reports using SSRS to generate all daily, weekly and monthly reports.
• Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
• Tuning SQL query for better performance using SQL Profiler.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance Monitor and tuning SQL Server performance.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created and configured Data Source & Data Source Views, Dimensions, Cubes, Measures, using SQL Server.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Environment: SQL Server 2008R2/2012, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS EXCEL, SQL Server Profiler, Team Foundation Server (TFS), C#, VB Script.

Confidential, Shelton, CT

Sr.SQL/BI Developer

Responsibilities:

• Demonstrated leader ship abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Collected business requirements from users and translated them as Business Requirement Document.
• Created Stored Procedures, Common table expressions (CTE’s), Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Created Excel including pivot tables, macros, and lookup functions to format a data set from the various SQL sources.
• Involved in partitioning of databases to improve query performance and reduce downtime.
• Created ETL packages with different data sources (SQL Server, Teradata, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages, notified process results to various user communities and scheduled the SSIS jobs using SQL server agent.
• Implemented the concept of Incremental Data Load and Slowly Changing Dimension (SCD) Type 2 for dimension packages to move data from staging to dimension tables in SSIS.
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Deployed SSRS reports onto Microsoft Office SharePoint Server and SQL Server Report Server.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Created Snapshots to improve the performance of slow running reports in SSRS.
• Worked on Tableau Desktop, Public and Tableau Server.Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing SSAS Cubes.

Environment: SQL Server 2008 R2/2012 Enterprise Edition,SSIS,SSRS, SSAS, SharePoint, PL/SQL, C#, Visual Studio 2010 & 2013, MS Visio 2007, Tableau Dashboards, Team Foundation Server (TFS).

Confidential, Omaha, NE

Sr. SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Created database objects like Tables, Views, Stored procedures, Functions, Joins, Indexes and Triggers in T-SQL based upon the functional specifications.
• Implemented performance tuning of slow running queries and stored procedures using Sql Profiler and Execution plan.
• 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.
• Implemented Package Configurations, Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Scheduled SQL jobs to run SSIS packages on a daily, weekly, monthly basis using MS SQL Server Integration Services (SSIS).
• Responsible for Gathering/Refining requirements from the customer for developing reports.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio.
• Developed and deployed different reports such as drill down, drill through, parameterized reports and implementing different visualization like bar chart, Pie charts, tabular presentation using SSRS.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports, Matrix Reports.
• Wrote hundreds of stored procedures and function on numerous SQL server to use in SSIS package andPowerBI.
• Involved in development & Deployment of SQL Server Analysis Services (SSAS) Cubes and Monitor Full and Incremental loads and support any issues.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a SSAS cube.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Environment: MS SQL Server 2008R2/2012, Business Intelligence Development Studio (BIDS), Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS EXCEL, SQL Server Profiler, Team Foundation Server (TFS).

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to Data warehouse databases, Data mart databases.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created a Template generator stored procedure for creating migration scripts and Unit Test scripts.
• Creating Indexes (Clustered/Non-Clustered) and partitioning of Very Large Data Bases for improving the Database performance.
• 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 SSIS packages.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Worked on SSIS performance tuning using counters, Error handling, Event handling, re-running of failed SSIS packages using Checkpoints.
• Designed high level ETL architecture for data transfer from the OLTP to OLAP with the help of SSIS.
• Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, Parameterized Reports in SSRS.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2008, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Access, Visual Studio, T-SQL, Windows XP.

Confidential, Overland Park, KS

MS SQL Server /SSIS /SSRS Developer

Responsibilities:

• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Constraints and Roles.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing Stored Procedures.
• Assisted in migrating de-normalized report Database into a Star Schema design.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Worked with various SSIS Data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc.
• Used various Control flow tasks like for Loop, execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Created Linked Servers to connect OLE DB data sources and providers.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL, SSRS, SSIS, MS SharePoint, MS Access, Windows 2003 platform, VB.NET, ERWIN, SQL Server Management Studio, Visual Studio.

Confidential

SQL Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Implemented different types of constraints on tables. Designed and applied entity and attributes description and definition for the models.
• Used query optimizer to enhance the ETL architecture performance.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Used various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations in the SSIS Packages.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic package configuration in SSIS.
• Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS.
• Snapshot Replication was being used to synchronize the data between their Different Stores.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: SQL Server 2008, BIDS, SSIS, SSRS, VB Script, Visual Studio, T-SQL, Windows XP.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Installed and configured SQL Server 2005 in the Window environment.
• Actively involved in Normalization & De-normalization of database.
• Created database objects like tables, views, synonyms, procedures, functions and data base triggers to meet the business requirements.
• Created and Modified Triggers and Dynamic Cursors in T-SQL for maintaining SQL server databases and assigned permissions to a role for Stored Procedures for Application Developers.
• Backing up master & system databases and restoring them when necessary.
• Created T- SQL queries for data retrieval.
• Taking DatabaseFull Backup, Transaction log backup & differential backupin daily routine.

Environment: SQL Server 2005/2008, T-SQL, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Visual Source Safe, SQL Server Management Studio (SSMS).