Professional Summary:

• Over 8 years of IT Experience in Analysis, Database Design, development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.
• Extensive programming, installing, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2000/2005/2008/2008 R2/2012 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation.
• Extensive knowledge of normalization and relational database management systems.
• Proficient in Logical and Physical database design development using normalization, dimension modeling, Data Modeling and SQL Server Enterprise manager .
• Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
• Expertise in Analyzing Query Plans, Using Extended Stored Procedures, Managing Indexes and Locks, Troubleshooting Deadlocks.
• Experience in developing front-end for the site written in ASP.NET, MS Visual Studio .NET, C , VB.NET, XML, VBScript, HTML, DHTML, JavaScript, Dreamweaver.
• Expertise in creating Reports with complex formulas and to query the database for business Intelligence using SSRS.
• Proficiency in creating different types of reports such as Table Reports, Cross-Tab, List Reports, Conditional, Pie Chart Reports, Drill-down, Drill through reports, Group reports, sub-group reports, Adjacent group reports, Total Reports, Sub-total Reports, Grand Total Reports.
• Expertise in Integrated SQL Server Reports with SQL database using views and stored procedures.
• Expertise in developing Reports like Standard parameter Reports, cascading Reports for each and every Departments.
• Experience in developing ad-hoc reports using Report Builder.
• Experienced in Data Extraction, Transforming and Loading ETL between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services DTS , Bulk Insert, BCP, and XML.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
• Experienced using in FTP and SFTP servers to upload files.
• Extensively worked in creating and integrating Micro strategy reports and objects Attributes, Filters, Metrics, Facts, Prompts, etc with the data warehouse.
• Created and maintained Databases, creating Roles and managing user permissions, resolving deadlocks.
• Experience in MS SQL Server configuration, performance tuning, query optimization, back-up/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects SDLC and capable of handling responsibilities independently as well as a proactive team member.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Expertise in Debugging, Optimizing and Performance Tuning of MS SQL SERVER 2005/2008/2012 Dashboards / Reports.
• Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008 R2.
• Good Knowledge in Physical and Logical Data Modeling.
• Highly motivated and a conceptually strong individual with exceptional analytical and design skills.
• Excellent professional written and verbal communication and interpersonal skills. Proficient in technical writing and presentations.

Technical Skills:

Professional Experience

Confidential

Sr.SQL Server BI Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Used Sub queries, joins, CTE's and Analytical functions for data retrieval.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.
• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services SSIS .
• Created SSIS packages for Uploading of different formats of files Excel, Access, dbf and databases SQL server, Flat files into the SQL Server data warehouse using SQL Server Integration Services SSIS .
• Used Script task to write custom code using Vb.net
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Creating Reports as per user requirements using MS Reporting Services 2005/2008/2012.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through,OLAP and Sub reports, and formatting them using both SSRS 2005/2008
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Created data driven subscriptions for different users using Report Manager.

Environment: MS SQL Server2008/2012, Team Foundation Server, Microsoft SharePoint Server MOSS 2007 , Crystal Reports, SSIS SQL Server Integration Services, SSRS SQL Server Reporting Services, Visual Studio 2005, Windows XP, T-SQL

Confidential

Role: SQL Server BI developer SSRS/SSAS

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .
• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services SSIS .
• Created SSIS packages for Uploading of different formats of files Excel, Access, dbf and databases SQL server, Flat files into the SQL Server data warehouse using SQL Server Integration Services SSIS .
• Used Script task to write custom code using Vb.net
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Environment: MS SQL Server 2012, Team Foundation Server, Microsoft SharePoint Server, Crystal Reports, SSIS SQL Server Integration Services, SSRS SQL Server Reporting Services, Visual Studio 2005, Windows XP,VB.Net

Confidential

Role: MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Involved in the tuning of the existing Database Objects.
• The task involved writing a lot of TSQL Code, including use of complicated joins and cursor loops.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various Web applications, maintained referential integrity and implemented complex business logic.
• Involved in translating business requirements into technical design specifications.
• Involved in managing data sources from other sources to SQL Server.
• Designed and deployed various complex reports using MS Reporting Services.
• Excellent report creation skills using Microsoft Reporting Services SSRS .
• Created and generated reports to display data.
• Used Query Profiler to optimize SQL queries.
• Managing the Clustered environment databases and was fixing the errors when they arose.
• Involved in execution and creation of SSIS packages using Business Intelligence Development Studio
• Involved in Deployment and Administration on SSIS packages
• Performed ETL operations to support the data loads and transformations.
• Developed and designed DTS packages for importing the data from MS Access and MS Excel.
• Loaded data from flat files into SQL Server 2005.
• Developed and executed several optimized queries in SQL.
• Setup and installation of databases including test, development environments
• Involved in DBA activities such as Backup, Recovery, Performance tuning and User administration
• Developed highly scalable report automation system utilizing SSIS, T-SQL, stored procedure, cursor, Query Analyzer.
• Fine tuning of database objects and server to ensure efficient data retrieval.

Environment SQL Server 2005/2008, SSIS, VBScript, XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services SSIS , MS SQL Server Reporting Services SSRS , MS SQL Server Analysis Services SSAS .

Confidential

Role: SQL Server SSIS Developer

Responsibilities:

• Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Extract Transform Load ETL development using SQL Server 2005, SQL 2008 Integration Services SSIS .
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Migrating SQL Server 2000 databases into SQL Server 2005.
• Conducted Data Analysis and did Data Modeling and Created the ER diagrams using Logical Schema and Star Schema.
• Generated ad-hoc reports using MS-Excel and Crystal Reports.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Environment: SQL Server 2005/2008, SSIS, VBScript, XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services SSIS , MS SQL Server Reporting Services SSRS , MS SQL Server Analysis Services SSAS .

Confidential

Role: Sql Server Developer

Responsibilities:

• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Performed Database code Migration from SQL Server 2000 to 2005 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe VSS and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Experience in development of extracting, transforming and loading ETL , maintain and support the enterprise data warehouse system and corresponding marts
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic VB scripts. .
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: MS SQL Server 2005, T-SQL, DTS, Windows XP, 2005, MS Visio 2005, MS Projects 2005.