SAP BW

8/2009 – 9/2010

• Involved in production support and worked on change requests.
• Performed various performance tuning techniques (aggregates, statistics and partitioning) to optimize the query performance.
• Analyzed production load errors and rectified the same in stipulated time.
• Creation and maintenance of BW objects (Infocubes, ODS objects and Multiproviders).
• Point of Contact for technical issues involving support and design changes.
• Involved in analysis, design, and development of BW objects.

8/2007 – 6/2009

• Extensive discussions with client for modifications and enhancements in the reports and also conduct user training.
• Extensively worked on SAP Remote cubes which are country specific which are used for live-cache extractions of demands for APO system.
• Worked on creating aggregates, compressions, indexes, Multicubes and parallel setups for data loading to improve performance and utilize data effectively.
• Performed various tuning techniques (aggregates, statistics and partitioning) to optimize the query performance.
• Developed transfer rules, update rules and start routines using ABAP to incorporate business logic and perform data manipulation.
• Created Multiprovider on sales and plans cubes to assist reporting on sales and plans together.
• Created daily and monthly process chains (sales and plans) automate the data load and data target administration.
• Developed complex query definitions involving variables with replacement type and custom exits, CKF’s, RKF’s using the query designer.

6/2006 – 5/2007

• Involved in implementation of SAP BW for MM and PP modules.
• Identified the necessary business content and mapped the business process requirements with the available business content.
• Installed and activated the relevant business content for master data and transactional data.
• Involved in analysis, design, development, implementation of standard and customized Info Cubes, ODS objects.
• Generated and maintained transfer structures, communication structures, transfer rules and update rules for infosources, ODS objects and Infocubes.
• Created info packages and scheduled them in order to load master and transactional data from sap R/3 in to BW.
• Worked extensively on standard lO extractors, and data sources in Material Management and production planning to facilitate the data extraction to BW.
• Collecting objects and transports these from development to the quality environment.
• Developed flexible queries using filters, variables, conditions, calculated key figures, and restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Involved in validating data in development and quality (unit testing, integration testing).