Jun 2012 – Jul 2013 · 1 yr 1 mo · Bangalore

• Working in Philips project under Lighting sector.

Jan 2012 – Jun 2012 · 5 mos

• Environnent : SAP R/3 4.6 c-4.7EE, BW 3.5, BI7.0; Involved in solving high priority incidents and never breached the SLA.
• Involved in MEC (Month End Closure) activities which includes Data loading and Monitoring, fixing the loading issues.
• Extensively involved in extracting data using flat file interface.
• Extensively worked in analyzing and fixing issues related to start routine, update rules & transfer rules.
• Responsible for analyzing and resolving BW Production issues.
• Involved in the development of BW objects as per CRs.
• Worked on reports using Bex Analyzer. Created calculated/restricted key figures, structures & variables using authorization objects and user exits.
• Worked in the conversion of full loads into delta load both for master data and Transaction data.
• Worked on performance related issues to reduce the load timings..

Jan 2011 – Dec 2011 · 11 mos

• Environnent : SAP R/3 4.6 c-4.7EE, BW 3.5, BI7.0; Involved in solving high priority incidents and never breached the SLA.
• Involved in MEC (Month End Closure) activities which includes Data loading and Monitoring, fixing the loading issues and refreshing the reports using PPA tool
• Extensively involved in extracting data using flat file interface.
• Extensively worked in analyzing and fixing issues related to start routine, update rules & transfer rules.
• Responsible for analyzing and resolving BW Production issues.
• Involved in the development of BW objects as per CRs.
• Worked on reports using Bex Analyzer. Created calculated/restricted key figures, structures & variables using authorization objects and user exits.
• Worked on BPS (Business Planning and Simulation) related issues.

Jan 2008 – Dec 2010 · 2 yrs 11 mos · Bengaluru Area, India & London

• Environnent : SAP R/3 4.6 c-4.7EE, BW 3.5, BI7.0; Description
• Shell is a global group of energy and petrochemicals companies, operating in over 145 countries and employing more than 119, 000 people. Shell is best known to the public for service station and for exploring and producing oil and gas on land and at sea. GSAP will replace Shell's fragmented Enterprise Resource Planning systems with a harmonized global platform, critical to the delivery of OP-One benefits. Shell aims to reduce the number of Enterprise Resource Planning systems in oil products from 123 to less than 10.
• Responsibilities:
• Extensively worked on Supporting and Development Projects.
• As an onsite coordinator involved in the design meeting with the business by taking the requirements & analyzing them for StBC area.
• Involved in the regression testing for the various bundles in the project

Oct 2006 – Jan 2008 · 1 yr 3 mos · Bengaluru Area, India

• FUSION is a SAP data warehouse implemented for HLL for its sales and distribution system. HLL needed to analyze sales data from disparate systems to understand the performance of their stores and the effectiveness of their promotions.
• Responsibilities:
• Worked in supporting the users for resolving the tickets rose in Reporting and also involved in developing new reports according to Client requirement.
• Involved in the testing phase for the update and start routines for ODS & Infocubes to improve the performance of the data loads.
• Involved in the code optimization of the code related to the ODS & Info-cube to improve the performance of data loads.
• Data extraction from R/3 and Flat file, Creating Info Packages, Event Scheduling; Monitor settings.
• Supported up-gradation of SAP BW server from SAP 3.5 to SAP BI 7.0.
• Performed Pre upgrade activities like clearing delta queue on R3 & BW.,Post upgrade activities like testing all the process chain(data loading) , and tested reports on the upgraded server to ensure data quality.
• Worked on a business process called COMMON EXTRACT. This process updates the sales and stock for products everyday upon which the next day production cycle depends on. In this task, I managed five team members, did data quality analysis, documented the process, and provided post-production support.
• Scheduled data loads to BW from SAP R/3, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when errors occurred.
• Reviewed performance bottlenecks and tuned inefficient queries using Aggregates, Compression, and Partitioning.
• Used PSA for checking data quality before loading and BW monitor for trouble shooting.
• Participated in BW Report Analysis design, development, quality control testing, deployment and Integration.
• Involved in End User Training for Hindustan Lever Limited and modified and enhanced existing queries to match the new business requirements.

Oct 2006 – Jan 2008 · 1 yr 3 mos · Bengaluru Area, India

• Environment : SAP BI Ver 7.0 on IBM AIX with Oracle 10g as database.
• Description
• HLL being an FMCG (Fast Moving Consumer Goods) Company produce their goods from 40 different factories located across India. Once they produce the goods, these goods are moved into depots across India to distribute to the redistribution stockiest from where the goods are delivered to the end consumers. HLL presently have 80 depots across India, 110 Factories have been migrated to SAP. So this project deals with the new reports to be developed in SAP for the users according to the requirement.
• Responsibilities:
• Worked on the Project as per the end-user requirements for developing the reports on SD, MM related modules.
• Knowledge in the concepts for developing dashboards where users can view various related reports (historical data via graphs, Monthly performance of the depots and so on) using Visual Composer.
• Involved in the testing of the Start and Update Routines for the Infoproviders inorder to increase the performance of the data loads.
• Involved in the testing of the FI, SD, Stock Reports & also Warehouse reports.
• Involved in training of the End-users to make them understand the reports designed on Transportaion and also on Warehouse.