SUMMARY

• 8 years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008/2005 , T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
• Experience in using Business Intelligence tools(SSIS,SSAS,SSRS) in MS SQL Server 2008
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008/2005/2000/7/6.5.
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000
• Hands on experience in using ProClarity to browse cubes, create views and books.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)..
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Experience in modifying MDX Cubes and Dimensions in SSAS.
• Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2012,2008,2005, 2000, 7.0, MS-Access

Language: C, C++, T-SQL, VB.Net

Operating System: Windows XP/NT/2000, DOS, Windows Server 2003

Tools: Erwin, Microsoft Visual Studio 2008/2005,Share Point Server 2007, Microsoft Project Server 2007, ProClarity, QTP

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports

ETL Tools: SSIS (SQL Server Integration Services), DTS

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

SQL BI Developer (SSIS/SSRS)

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, Parsippany

SQL Server BI developer (SSRS/SSIS)

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 2008.
• 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 Server2005/2008, 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, NJ

SQL BI Developer

Responsibilities:

• Involved in Migration of SSRS 2005 to SSRS 2008.
• Created subscriptions in SSRS to deliver reports to a shared file.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SQL Server Reporting Services 2008
• Created Triggers, Views for Audit and security purposes.
• Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Pro
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Involved in migration of crystal reports to SSRS 2008.
• Developed T-SQL queries and stored procedures with multiple parameters to created data Sets for reports
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Created mapping tables to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Used data profiling task in SSIS 2008 to identify poor data and repair it.
• Hands on experience in using different transformations like fuzzy lookup, derived column Transformation etc. using SSIS.

Environment: SQL Server 2005/2008, Microsoft SharePoint Server (MOSS), T-SQL, SQL Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Erwin, SQL Profiler, MS Excel 2003, MS Visio, Visual Studio, .Net

Confidential, Nashville TN

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

Sql Server Developer

Responsibilities:

• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Created and managed subscriptions for the reports.
• Implemented user based security in SSRS reports to limit the access of reports.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions and Responsible for defining calculated members
• Created SSIS packages to move data from oracle to SQL Server which involved using Various transformations, developing SQL queries.

Environment: SQL Server, SharePoint, DTS, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS.