SUMMARY:

• 6+ years of SQL Server / BI Developer with IT experience, most of which is in Development on Microsoft SQL Server 2012/2008R2/2008, T - SQL, Performance Tuning, Troubleshooting, SSIS, SSRS.
• Experience in using Business Intelligence tools(SSIS,SSRS) in MS SQL Server 2014/2012/2008 R2/2008
• Extensive experience with T-SQL in constructing Triggers, Queries, implementing stored Procedures, Functions, Views, and Data Integrity
• Hands on experience on various SQL Server Services like Integration Services (SSIS), and Reporting Services (SSRS)
• Expert in creating complex reports such as drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational databases
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• Great ability to create and manage various database objects like tables, views.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008/2008r2/2012
• Experience creating jobs using Control-M tool.
• Experience in developing Parallel data warehouse solutions(PDW), Massively Parallel Processing(MPP)
• Experience in Extracting, Transforming and Loading (ETL) data using SSIS and ELT massive load file process using Dwloader and BCP
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS packages. Expertise in design heavy load process and partitions in Parallel Data Warehouse.
• Data Loading Experience in SQL Server 2012/2008R2/2008 using SSIS ETL and Experience in developing packages in SSIS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Proficient in developing / debugging SSIS Packages using SSIS designer in Business Intelligence Development Studio (BIDS) for integrating data from heterogeneous sources (MS Excel, Flat Files etc.).
• Expertise in database optimization on fine tuning the stored procedures and SQL queries.
• Exceptional skill in Agile Development and Test Driven Development
• Expert in scheduling and managing jobs using Control-M tool
• Good knowledge and understanding of Object Oriented Design Principles.
• Good knowledge on OLAP cubes.
• Good Knowledge in SQL Server 2014, SSIS and ETL process.
• Extensive knowledge of the software development life cycle (SDLC) from requirements gathering to programming, testing and maintenance.
• Strong Knowledge on TFS version control.
• Willing to adapt to new technologies and work environments.
• Ability to rapidly absorb new concepts and apply them effectively; innovative problem solving skills and expert trouble-shooter.
• Effective in working independently and collaboratively in teams with exemplary analytical and problem solving skills.
• Experience in working with Qlikview 12.0. Designed, developed and supported Dashboards and various Reports using Qlikview.

TECHNICAL EXPERTISE:

Programming Languages: T-SQL, SQL, PL/SQL

Microsoft Technologies: SSRS 2014/2012/2008 R2/2008, SSIS 2014/2012/2008 R2/2008, Report Server

RDBMS: SQL Server 2008/2008R 2/2012/2014/2016 , Oracle10g/11g and MS Access

Dash boarding / Analytics: QlikView 12.0

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

Other Tools: MS Office 2007/2010, MS Visio 2008/2010

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• Great ability to create and manage various database objects like tables, views.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008/2008r2/2012
• Experience creating jobs using Control-M tool.
• Experience in developing Parallel data warehouse solutions(PDW), Massively Parallel Processing(MPP)
• Experience in Extracting, Transforming and Loading (ETL) data using SSIS and ELT massive load file process using Dwloader and BCP
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS packages. Expertise in design heavy load process and partitions in Parallel Data Warehouse.
• Data Loading Experience in SQL Server 2012/2008R2/2008 using SSIS ETL and Experience in developing packages in SSIS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Proficient in developing / debugging SSIS Packages using SSIS designer in Business Intelligence Development Studio (BIDS) for integrating data from heterogeneous sources (MS Excel, Flat Files etc.).
• Expertise in database optimization on fine tuning the stored procedures and SQL queries.
• Exceptional skill in Agile Development and Test Driven Development
• Expert in scheduling and managing jobs using Control-M tool
• Good knowledge and understanding of Object Oriented Design Principles.
• Good knowledge on OLAP cubes.