SUMMARY

• Around 7 + Years of MS SQL SERVER Development experience in Insurance, Homebuilder Utility and telecom domains with expertise in Software Analysis, Design, Development, Testing and SQL server Business MS SQL Server 2008/ 2010/2012/2013 suite of products like SSIS, SSAS, and SSRS.
• Experienced in TSQL (DDL, DML), Documenting, and Coding, modifying and implementing Business Intelligence solutions using SQL Server 2012/2010/2008 R2.
• Experienced in relational database design, SQL queries, stored procedures, Functions, Triggers, Performance tuning, Backup / Restore.
• Expertise in creating Complex Stored Procedures, Queries for the application team and for the end users based on the business requirement.
• Extensive Experience and Knowledge on SQL SERVER Reporting Services.
• Experience in developing different types of Tabular Reports, Matrix Reports, Drill - Down, parameterized, drill through reports, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in creating SQL Server Reports using SSRS 2010/2012 in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc reports.
• Experience in writing T-SQL, working on SSRS, SSAS,SSIS Data Cleansing, Data Scrubbing and Data Migration
• Involved in Migrating Cognos Reports to SSRS Reports in SQL server 2010/2012.
• Experienced in using tools like Data Transformation Services (DTS) and SSIS with MS SQL Server 2008/2008r2.
• Experience in developing and monitoring SQL Server Integration Services (SSIS) Packages and Data Transformation Services (DTS).
• Experienced in High Level Design of ETL DTS & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, flat file, .CSV file, Oracle,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Lookup, Derived Column, Sort, merge and union all.
• Experience in using Fuzzy Lookup and Fuzzy grouping transformations for data cleansing.
• Experience in defining logging for packages to record the error records, updated records, and inserted records.
• Good knowledge of Normalization/De-normalization, data design methodology, building Referential Integrity, RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Implemented logical and physical Data Modeling with STAR and SNOWFLAKE techniques using Erwin in Data Mart.
• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Worked on SSRS Reports using SQL Server cubes.
• Experienced working with Version control tool Team Foundation Server (TFS).
• Expertise in Unit and Integration Testing and preparing combined developer Testing document.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

Data Warehousing/BI Tools: SQL Server Business Intelligence Studio - SSAS, SSRS, SSIS.

RDBMS/DBMS: MS SQL Server 2005/2008 R 2/2010/2012/2014 , MS Access.

Tools: Management Studio, Enterprise manager, SQL, Performance Monitor, Power Pivot, SQL Server Agent, MS Visio/Excel., Team Foundation Server 2010/2012/2013

Web Technologies: HTML, DHTML, XML, XSLT, IIS.

Programming Languages: TSQL,C#.net, VB.net, VBScript

Protocols / Middleware: HTTP, FTP,ODBC

PROFESSIONAL EXPERIENCE

Confidential, MI

MS SQL Server BI Developer

Responsibilities:

• Developing Stored Procedures, Functions, Tables, Views, Triggers, Cursors, User Defined Functions and other T-SQL code and SQL joins for applications to handle large amount of data manipulation.
• Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.
• Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2014/2012.Monitoring, Identifying and troubleshooting SQL Server performance issues using SQL Server Performance monitor, profiler .
• Responsible for creating a trace to identify and analyze the Poorly Performing Queries Identified by Profiler in SQL Server 2014/2012.
• Creating and deploying various Reports like Drill Down, Drill Through, Chart, Linked and Parameterized reports using SSRS.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developing Cascading Reports for Analytics Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2012/2010.
• Generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Performing Unit and Regression tests for Developed Reports and Deployed into the Server.
• Involving in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.

Environment: Business Intelligence Development Studio (BIDS 2012/2010) Visual Studio 2013/2012/2010 , Team Foundation Server 2013/2012/2010 , SQL Server 2014/2012, Microsoft SharePoint Server (MOSS), T-SQL, (SSRS) SQL Server Reporting Services.

Confidential, Bloomfield Hills, MI

MS SQL Server BI Developer

Responsibilities:

• Used agile methodology for requirement gathering and specification.
• Interact with Development Teams and Managers to analyze business needs. Provide software product design and develop a technical roadmap for the solution through the project lifecycle and Confidential .
• Experienced in gathering business and technical requirements and creating requirement documents in the development perspective.
• Created Tablix, Drill-down, Drill-through, Matrix, Tabular, Multi Parameterized, Stepped, Linked, Chart and data driven and burst reports using SSRS 2010/2012
• Deployment of reports to Staging and Production and Created Report level security and assign user permissions on Report Manager.
• Created the Complex Subscriptions and scheduled the published reports from Report Manager.
• Involved in Migration and Modification of existing Cognos Reports to SQL Server Reporting Services (2012).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Designed integrating diagrams using MS Visio 2010
• Generated Dynamic Reports from Cubes (SSAS) using SSRS 2012.
• Highly involved in performing Unit Test, Regression Test, Functional Test, Integration Test, and Stored Procedure Performance Test on Test server and preparing combined Developer Testing document.
• Provided QA and UAT Support by actively fixing and updating issues via SharePoint.
• Experienced in creating several Deployment documents for different applications.

Environment: Microsoft SQL Server 2008/2012, SQL Server Business Intelligence Development Studio(SSIS,SSRS), MS Visio, Microsoft Share Point Server, T-SQL, Database Engine Tuning Advisor, Team Foundation Server 2012.

Confidential, Pittsburgh, PA

MS SQL Server BI Developer

Responsibilities:

• Developing Stored Procedures, Functions, Tables, Views, Triggers, Cursors, User Defined Functions and other T-SQL code and SQL joins for applications to handle large amount of data manipulation.
• Creating ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted data into destination tables.
• Responsible for transferring the data using SSIS packages from excel/flat file sources to database.
• Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
• Creating Logging and Error Handling in SSIS Packages using BI Xpress.
• Dealing with SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.
• Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2008/2008R2.Monitoring, Identifying and troubleshooting SQL Server performance issues using SQL Server Performance monitor, profiler and Performance dashboards
• Responsible for creating a trace to identify and analyze the Poorly Performing Queries Identified by Profiler in SQL Server 2008 R2.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developing Cascading Reports for Analytics Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2008 R2
• Creating and deploying various Reports like Drill Down, Drill Through, Chart, Linked and Parameterized reports using SSRS and C# Wrapper
• Generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Performing Unit and Regression tests for Developed Reports and Deployed into the Server
• Involving in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Creating multidimensional cubes using the SQL Server Analysis Services (SSAS).
• Creating MDX Queries to retrieve data from SSAS Cubes and to generate reports from Cubes
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users.

Environment: Business Intelligence Development Studio (BIDS 2008 R2), Visual Studio 2010/2008, Team Foundation Server 20012/2008, BI Xpress V4.0.0, .NET Framework, SQL Server 2008/2005, Microsoft SharePoint Server (MOSS), T-SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL,MDX, Erwin, SQL Profiler, Team foundation server 2008.

Confidential, Schaumburg,IL

MS SQL Server Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Designed the Entity Relationship(ER) models and logical data (LDM), physical data (PDM) models based upon the design documents.
• Extensively worked on full Software Development Life Cycle (SDLC) of the project from Database Design and Modeling to implementation and maintenance.
• Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server Source Database
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and Developed Complex SSIS Source to Intermediate Packages to load the data into Intermediate Databases
• Developed Complex SSIS Parent-Child Packages for different Counties with Common Source to Intermediate rules.
• SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.
• Experience in performance tuning of SSIS Packages using row transformations.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.
• Created complex Stored Procedures for validation process & for loading data from the staging area to the product database in SQL 2008.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS)
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Client.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Reports migrations from Actuate to SharePoint/SSRS technology.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008,2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Microsoft Access 2007, SharePoint 2010,Visual Studio 2008,2010.

Confidential, Green Bay, WI

SQL Server Developer

Responsibilities:

• Involved in complete life cycle of SDLC and also responsible for designing of Logical as well as Physical database.
• Responsible for building Temp Tables, Fact Tables and also monitoring the Database.
• Maintaining and managing tables and procedures with SQL Server Management Studios SSMS.
• Involved in installing and configuring SSIS, SSRS and SSAS Services on Dev, QA and Production environments.
• Created Complex Packages using Slowly Changing Dimension.
• Designed Complex SSIS ETL packages to load the massaged data from sources like OLEDB, EXCEL, FLAT Files, RAW Files and DB2 etc into various Data warehousing system.
• Successfully migrated old data from legacy system into SQL Server using SSIS Packages.
• Data migration (Import & Export using BCP) from text to SQL Server.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Responsible for building various Database Diagrams using Star schema and Snow Flake schema depending on the Business needs.
• Involved in mapping customer requirements to Microsoft Dynamics CRM.
• Configuring& Troubleshooting MS CRM Outlook Client
• Experience in Loading Data using SSIS in Dynamics CRM.
• Built MDX queries and DMX (Data Mining Expression) queries for Analysis Services & Reporting Services.
• Designed and created cubes and optimized application performance and created dynamic rules based security model to customize data/report access for multiple users.
• Responsible for generating various Tabular reports, complex Matrix Reports and Sub Reports using SSRS to generate maintenance and transaction reports.
• Build and Published the SSRS environment for both Dev and Test servers based on the individual client needs.
• Documentation for all kinds of Reports and SSIS ETL Packages.
• Expertise in Handling TFS for files check-in and check-out.

Environment: MS SQL Server 2008/2005/2000 , Business Intelligence Development Studio 2005(BIDS), VB.Net, VB Script, C#.Net, SQL, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio 2005, CSS, IIS 6.0,Team Foundation Server (TFS),MS Dynamics CRM.

Confidential

MS SQL Server Developer

Responsibilities:

• Complete analysis, requirement gathering and function design document creation.
• Written various T-SQL Statements for the purpose of application development.
• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Also created, modified, maintained and optimized SQL server database.
• Maintained the documents and create reports for the business analysts and end-users.
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Coordinating user acceptance testing amongst business users.
• Developed many T-SQL stored procedures, views, indexed views, UDF for business reporting.

Environment: SQL Server 2005, T-SQL, MS Excel.