Pratap Reddy Email and Phone Number

Project1 :- ARP-ITSCLIENT:- WARNER BRO'SDURATION :-JAN 2013 to NOV 2013TECHNOLOGIES USED IN THIS PROJECT :-SQL SERVER 2008 R2,SSISROLE :-Sr.MSBI DEVELOPERTEAM SIZE :- 8----------------------------------------------------------------------------------Project2 :- ARP-HP3000CLIENT:- WARNER BRO'SDURATION :-DEC 2013 to SEP 2014TECHNOLOGIES USED IN THIS PROJECT :-SQL SERVER 2008 R2,SSISROLE :-Sr.MSBI DEVELOPERTEAM SIZE :- 11----------------------------------------------------------------------------------Project3 :- ARP-ITS&ITDCLIENT:- WARNER BRO'SDURATION :-OCT 2014 to TILLDATETECHNOLOGIES USED IN THIS PROJECT :-SQL SERVER 2008 R2,SSISROLE :-Sr.MSBI DEVELOPERTEAM SIZE :- 10----------------------------------------------------------------------------------ROLES:Designing and developing the SSIS packages.Creating SSIS packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Merge, Union, Sort, Multicast, Data Conversion and Execute SQL Task to load into Database.Working with Dataflow Task, Execute SQL Task, For each loop container frequently.Implementing Data viewers, Logging, Checkpoints, Package configurations.Implementing Performance Tuning at various levels.Working with Lookup, Conditional Split, Data Conversion, Derived Column frequently.Unit Testing of packages.Validate the data in between SQL and archival applications.Doing checksum operations for data validation purpose.Prepared high level and low level documentation about the project for future usage.Designed low level logical diagrams about the project flow.

Project1 :- ICDW(Integrated Customer Datawarehouse)CLIENT:- JPMCDURATION :-DEC 2011 to DEC 2012TECHNOLOGIES USED IN THIS PROJECT :-SQL SERVER 2008 R2,SSISROLE :-Sr.MSBI DEVELOPERTEAM SIZE :- 8Description: The aim of the project (ICDW) is to build and support a data environment in an efficient to improve the efficiencies and gain greater accessibility specifically around party subject area with involved party, organization unit, customer etc. dimensions. This data Is further useful to the analytical and reporting people for two and multi-dimensional analysis.ROLES:Designing and developing the SSIS packages.Creating SSIS packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Merge, Union, Sort and Execute SQL Task to load into Database.Working with Dataflow Task, Execute SQL Task frequently.Implementing Logging, Checkpoints, Package configurations.Implementing Performance Tuning at various levels.Working with Lookup, Conditional Split, Multicast, Derived Column frequently.Process the data in dimensions & facts based on granularity.Implemented KPI’S and Action’s on cube.Worked with Partitions, calculations.Worked with Simple and Complex MDX queries.Connected cube and generating Reports.As per client requirements generate the reports in the form of Table, Matrix, Charts.Unit Testing of the packages.