Creation of transformation and data transfer forces to load data from PSA to data targets involved in creating aggregates partitions indexes rollup and compression to improve the query performance creation of a DSO and composite providers process chains maintenance ,monitoring issues and resolving them .extensively worked on creation of queries in bex query designer multi providers in info cubes DSOs, transformations ,dtps , in order to meet the end user reporting requirements.