SQL BI Developer

SQL BI Developer

Extensive knowledge and experience in working with RDBMS, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Views, Cursors, UDF and Data integrity.

Strong ability in defining query for generating drill down/drill thru reports, handling parameterized reports, Cascade type reports and Ad-hoc Reports in SSRS.

Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML /SQL/ Oracle) to different targets (DB/Files).

Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005.

Extensively worked with the Business Users for creating Reports from Different Data Sources on MS SQL Server Reporting Services and MS Access with a focus on timely, accurate and consumable information that enables key decision making.

Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans.

Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery.

Used tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as a proactive team member.

Extensive knowledge and experience in working with RDBMS, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Views, Cursors, UDF and Data integrity.

Strong ability in defining query for generating drill down/drill thru reports, handling parameterized reports, Cascade type reports and Ad-hoc Reports in SSRS.

Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML /SQL/ Oracle) to different targets (DB/Files).

Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005.

Extensively worked with the Business Users for creating Reports from Different Data Sources on MS SQL Server Reporting Services and MS Access with a focus on timely, accurate and consumable information that enables key decision making.

Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans.

Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery.

Used tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as a proactive team member.

Extensive knowledge and experience in working with RDBMS, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Views, Cursors, UDF and Data integrity.

Strong ability in defining query for generating drill down/drill thru reports, handling parameterized reports, Cascade type reports and Ad-hoc Reports in SSRS.

Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML /SQL/ Oracle) to different targets (DB/Files).

Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005.

Extensively worked with the Business Users for creating Reports from Different Data Sources on MS SQL Server Reporting Services and MS Access with a focus on timely, accurate and consumable information that enables key decision making.

Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans.

Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery.

Used tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as a proactive team member.

Extensive knowledge and experience in working with RDBMS, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Views, Cursors, UDF and Data integrity.

Strong ability in defining query for generating drill down/drill thru reports, handling parameterized reports, Cascade type reports and Ad-hoc Reports in SSRS.

Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML /SQL/ Oracle) to different targets (DB/Files).

Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005.

Extensively worked with the Business Users for creating Reports from Different Data Sources on MS SQL Server Reporting Services and MS Access with a focus on timely, accurate and consumable information that enables key decision making.

Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans.

Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery.

Used tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as a proactive team member.

Contact this candidate