Worked on different types of connection managers,Tasks -like Execute SQL,Send mail also on Control Flow tasks like File System Task,FTP,XML,Data profiling,Execute package,Execute process task, in Data flow tasks - using Excel,Flat File,OLE DB,XML,RAW file both sources and destination,worked on all transformations- including pivot,unpivot,merge,lookup,using expressions and variables,scripting,Breakpoints,Logging and using Utilities- like DTExecUI, Data Cleansing process,improving the package performance,Deployment- using Import into MSDB,Creating the SSIS Catalog,Executing a Package with DTExec. On SSRS part worked Tablix,Matrix Grouping,Using Expressions,Using parameters,Data Visualization- (charts,data bar,Spark line,Gauge),Adding Interactive features -such as sorting,Fixed headers,Tool Tip,Embedding HTML,Book Marks. On SSAS Worked on Dimension Development (Attributes,browsing a dimension,Date Dimension,User-defined Hirarchies,Cube Development(measure properties,Aggregate functions,Role-Playing dimensions,Perspectives,Translations),Calculations,Deployment - BIDS Deployment,Processing,security - User and Dimension Security,worked on Writeback(dimension and cell),Partitioning Strategy