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• Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS 2017/2013/2012.• Implemented and maintain ETL processes & SSIS packages to consolidate data from other business units and departments (Excel, CSV, and Text).• Involved in developing Packages for implementing business logic through Stored Procedures and Functions.•Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.•Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.•Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.• Experienced in SQL joins, sub queries, tracing and performance tuning for better running of queries.● Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, ● Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for fact and dimensions tables using Analysis Services●Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports

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.•Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.•Experienced in SQL joins, sub queries, tracing and performance tuning for better running of queries.●Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.●Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.●Created SSRS reports based on requirement. Create Linked reports, Sub reports, Parameterized reports, drill down reports.●Involved in writing MDX queries and performance optimization of the SSAS cubes.●Created score cards with executive summary dashboards using Performance Point Server 2013 Dashboard Designer that display performance monitoring measures and deriving data from a SQL Server 2000/2012 OLAP data source and deployed them to SharePoint sites. The dashboards also contain drill-down capabilities.●Created score cards with advanced set of dashboards using MS Performance Point Server 2010/2013 Dashboard Designer.●Key product areas utilized also include data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.

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.●Used various transformations in SSIS dataflow, control flow using for loop containers, and fuzzy lookups. ●Implemented Event Handlers, Error Handling in SSIS packages and used package configurations to make packages available for deploying in different environments.●Worked with internal customers to gather and analyze business requirements in order to identity and solve problems.●Optimized the query performance on cube by following the recommended best practices.●Created SSRS reports based on requirement. Create Linked reports, Sub reports, Parameterized reports, drill down reports.●Scheduled the ETL process using SQL Agent Jobs and Created email alerts for completed jobs.●Involved in documentation of the Reports, Database, and SSIS packages.●Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.●Monitored SQL Profiler and Database Engine Tuning Advisor●Worked on tuning the queries and fixing the stored procedures to get the data consistency.●Created tabular, matrix, chart, parametric, reports and dashboards and scorecards reports according to business requirement

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.● 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.● Used various transformations in SSIS dataflow, control flow using for loop containers, and fuzzy lookups. ● Implemented Event Handlers, Error Handling in SSIS packages and used package configurations to make packages available for deploying in different environments.● Validated daily, weekly, monthly grain transformed data by comparing with the source system.● Worked with internal customers to gather and analyze business requirements in order to identity and solve problems.● Optimized the query performance on cube by following the recommended best practices.● Created SSRS reports based on requirement. Create Linked reports, Sub reports, Parameterized reports, drill down reports.● Scheduled the ETL process using SQL Agent Jobs and Created email alerts for completed jobs.● Involved in documentation of the Reports, Database, and SSIS packages.● Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.

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.● 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.● Used various transformations in SSIS dataflow, control flow using for loop containers, and fuzzy lookups. ● Implemented Event Handlers, Error Handling in SSIS packages and used package configurations to make packages available for deploying in different environments.● Validated daily, weekly, monthly grain transformed data by comparing with the source system.● Worked with internal customers to gather and analyze business requirements in order to identity and solve problems.● Optimized the query performance on cube by following the recommended best practices.● Created SSRS reports based on requirement. Create Linked reports, Sub reports, Parameterized reports, drill down reports.● Scheduled the ETL process using SQL Agent Jobs and Created email alerts for completed jobs.● Involved in documentation of the Reports, Database, and SSIS packages.● Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.