SUMMARY

• 9+ years of industrial experience with Microsoft SQL Server, SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Expertise with T - SQL scripting language SQL Server and DB Design and Management.
• Strong understanding of Business Intelligence and Data Warehouse concepts.
• Experience in Implementation and Maintenance with Data Warehousing, ETL, OLAP, SQL Server.
• Experience in all the phases of Software Development Life Cycle (SDLC).
• Experience in Business Requirements Analysis, meeting customer expectations.
• Experience in Power Pivot creation and fine tuning.
• Excellent written and verbal communication skills, good analytical and problem solving skills, result-oriented team player.

TECHNICAL SKILLS

Languages: TSQL

Databases: MS SQL 2005, 2008/R2, 2012

ETL Tools: SSIS 2005/2008/R2/2012

Reporting Tools: SSRS 2005/2008/2012, VSTO

Scripting Languages: HTML, VBA

Operating Systems: Windows 98/NT/XP/Vista/2000/2003

Source Control: Visual Studio TFS 2008/2010/2012

Servers: Windows Server, 2003,2005,2008,2012 Advanced Server

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Environment: SQL Server 2012, SSRS, SSIS, Power BI, T-SQL

Responsibilities:

• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Develop and monitor SQL Server Agent jobs to populate data from various Sources to Power View reports on a daily, weekly or monthly basis.
• Developed many small and complex packages to perform ETL Operations.
• Worked on Deploying Packages and providing security while deploying.
• Experience in maintaining SQL Server jobs and involved in developing\maintaining SSIS packages.
• Designing and deploying reports using SSRS.

Confidential, Redmond, WA

Environment: Windows Server 2012, SQL Server 2012, SSRS, SSIS, TFS

Responsibilities:

• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Created Database Objects - Tables, Indexes, Views, User defined functions, CTEs, Cursors, Triggers, Stored Procedure and Constraints.
• Worked on Deploying Packages and providing security while deploying.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Tuned, monitored and maintained SQL Server Jobs.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.

Confidential

Environment: Windows Server 2012, SQL Server 2012, SSAS, SSIS, TFS

Responsibilities:

• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Checking the coding standards using checklists.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Tuned, monitored and maintained SQL Server Jobs.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Involved in Query Optimization, Performance Tuning and rebuilding the indexes at regular intervals for better performance.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Developed many small and complex packages to perform ETL Operations.
• Worked on Deploying Packages and providing security while deploying.
• Experience in maintaining SQL Server jobs and involved in developing\maintaining SSIS packages and SSAS cubes.
• Used Dimensions, Measure Groups, Calculations, Key Performance Indicators (KPI), Partitions, Perspectives and Actions while developing SSAS Cubes.
• Supporting customer ad-hoc requests.

Confidential

Environment: Windows Server 2008, SQL Server 2008, SSRS

Responsibilities:

• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Checking the coding standards using checklists.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels
• Develop SQL Server Agent jobs and packages to populate data.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Created and manipulated many small and Complex packages to perform ETL operations.
• Supporting customer ad-hoc requests.

Confidential

Environment: Windows Server 2005, SQL Server 2005, SSRS

Responsibilities:

• Analysis of the requirements and providing estimation.
• Unit Testing.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Worked on Deploying Packages and providing security while deploying.
• Tuned, monitorred and maintained SQL Server Jobs.