SUMMARY

• 9.5 years of industrial experience with Confidential SQL Server, SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Confidential Certified Technology Specialist in Business Intelligence and SQL Server 2008.
• Extensive Experience on SQL 2005/2008/R 2/2012/2014/2016 including Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• 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.
• Expert in defining Queries for generating drill down and drill through reports in SSRS.
• Expert in Developing reports on SSAS & SSRS on SQL Server (2005/2008/2008 R2/2012/2014).
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports, Sub Reports, Dashboards, Custom Code, Report Models and ad-hoc reports using SSRS
• Excellent written and verbal communication skills, good analytical and problem solving skills, result-oriented team player.

TECHNICAL SKILLS

Languages: T-SQL

Databases: MS SQL 2005, 2008/R2, 2012/2014

ETL Tools: SSIS 2005/2008/R2/2012/2014

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/2014

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

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Senior SQL BI Developer

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.
• Experience in creating and maintaining SSIS Package (ETL) to Extract and Transform data from Flat File or CSV and to load into Staging Database.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations like Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Created stored procedures, functions, to support web applications. Optimized slow SQL Queries.
• Worked on Deploying Packages and providing security while deploying.
• Optimized SSIS packages for processing large datasets by improving dataflow solutions (Datatype conversions & adjustments, buffer tuning, data filtering, parallel executions).
• Measured dataflow performance using Performance Monitor and log files.
• Experience in maintaining SQL Server jobs and involved in developing\maintaining SSIS packages.
• Developed SSRS reports and assisted on tracking subscription history and debugging.
• Experience in configuring and deployingSSRSreports onto Confidential Office SharePoint Server.
• Supporting customer ad-hoc requests.

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

Confidential, Redmond, WA

Sr MSBI Developer / Analyst

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.
• Experience in creating and deploying SSIS (ETL process) packages using variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Created stored procedures, functions, to support web applications. Optimized slow SQL Queries.
• Worked onChange Data Capture(CDC) and Change Tracking (CT) in SQL server.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Tuned, monitored and maintained SQL Server Jobs.
• Performed different kinds of transformations by using in-built components and customized script components for data clean-up and standardization, including regular expressions.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Optimized SSIS packages for processing large datasets by improving dataflow solutions (Datatype conversions & adjustments, buffer tuning, data filtering, parallel executions). Measured dataflow performance using Performance Monitor and log files
• Experience in configuring and deployingSSRSreports onto Confidential Office SharePoint Server.
• Developed SSRS reports and assisted on tracking subscription history and debugging.

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

Confidential

SQL Developer

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.

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

Confidential

DB Developer

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.

Environment: Windows Server 2008, SQL Server 2008, SSRS, SQL Server Management Studio

Confidential

DB Developer

Responsibilities:

• Conduct data profiling and analyze results to identify data gaps.
• Designed and developed aggregate, Join, Lookup transformation
• Analysis of the requirements and providing estimation.
• Unit Testing.
• 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.
• Created and manipulated many small and Complex packages to perform ETL operations.

Confidential

SQL Developer

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.
• Designed, developed and deployed SSRS Reports and providing security while deploying to Report Server.
• Tuned, monitored and maintained SQL Server Jobs.

Environment: Windows Server 2005, SQL Server 2005, SSRS