Deval P Email & Phone Number

Columbus, Ohio Metropolitan Area

• Generated specifications for analysis reports by using SQL Server Reporting Services (SSRS) 2013/2012.
• Designed SSRS reports with sub reports, expressions and queries, and preparing Ad-Hoc reports through report builders.
• Creating several complex reports (sub reports,drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS
• Created reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Experience in providing Logging, Error handling by using Event Handler and Logging for SSIS packages.
• Expertise in generating reports using SQL Server Reporting Services

North Carolina, United States

• Worked with internal customers to gather and analyze business requirements in order to identity and solve problems.
• Generated specifications for analysis reports by using SQL Server Reporting Services (SSRS) 2012.
• Designed SSRS reports with sub reports, expressions and queries, and preparing Ad-Hoc reports through report builders.
• Expertise in generating reports using SQL Server Reporting Services, PerformancePoint services
• Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS 2012.
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.

Cincinnati, Ohio, United States

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008R2 using SSIS/DTS, SSRS.
• Extracted data from various sources like SQL Server 2008R2, Oracle,.CSV, Excel and Text file from Client servers and through FTP.
• Developed T-SQL Stored Procedures for SSIS packages. Performed query optimization and implementing good programming practices.
• Designed and implemented ETL job restart ability using Checkpoints and optimal package design techniques in SSIS
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.
• 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.

Stamford, Connecticut, United States

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008R2 using SSIS/DTS, SSRS.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Extracted data from various sources like SQL Server 2008R2, Oracle,.CSV, Excel and Text file from Client servers and through FTP.
• Developed T-SQL Stored Procedures for SSIS packages. Performed query optimization and implementing good programming practices.
• Designed and implemented ETL job restart ability using Checkpoints and optimal package design techniques in SSIS
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.

Chicago, Illinois, United States

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008R2 using SSIS/DTS, SSRS.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Extracted data from various sources like SQL Server 2008R2, Oracle,.CSV, Excel and Text file from Client servers and through FTP.
• Developed T-SQL Stored Procedures for SSIS packages. Performed query optimization and implementing good programming practices.
• Designed and implemented ETL job restart ability using Checkpoints and optimal package design techniques in SSIS
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.