Academic Details

B TECH in Electronics & Communication

Technical Skills

Operating Systems Red Hat Enterprise Linux, Windows NT, Windows XP, Vista, Windows 7.
Data Warehouse and ERP SAP NetWeaver BI/BW 7.0(2004s), 3.5, R/3, ECC 6.
Reporting Tools Bex and Web Application Designer, BO

Experience Summary

Project 1

Confidential, , San Jose, CA Feb 2011- Aug 2012
SAP BI Consultant
SAP BI 7.0, SAP ECC 6.0

Cisco Systems, Inc. is an American multinational corporation headquartered in San Jose, California, United States that designs, manufactures, and sells networking equipment.

• Involved in the full life cycle implementation
• Extensively involved in installing and customizing the standard BW business
content to pull information from various source systems including SAP ECC
and flat files to load the data into InfoProviders.
• Worked in the areas of purchasing and extracted data from DataSources like
2LIS_02_ITM, 2LIS_02_SCL, and 0FI_AP_3
• Worked on LO-Cockpit Extraction for the Inventory Management i.e.
2LIS_03_BX, 2LIS_03_BF, and 2LIS_03_UM
• Involved with BW Data load Scheduling, Monitoring and Troubleshooting data
extraction/ load Problems.
• Worked with Info Package and Process chains for effective scheduling and
automation of various data loading processes.
• Performed detailed analysis to improve the Performance of Cubes using BW
Statistics, Aggregates and Involved in Query Building.
• Created aggregates that improve query processing time, compressions, and
other performance improving activities and monitored all the loads.
• Wrote SD Open sales Order report, which covers all organization levels,
delivery status, shipping figures in BEx analyzer to facilitate data analysis in a
drill down or summarized way to give detailed level of information.

Project 2

Confidential,MI Mar 2009- Nov 2010
Pharma/Manufacturing
SAP BI Consultant
SAP BI 7.0, SAP ECC 6.0

Perrigo Company is a leading global healthcare supplier that develops,
manufactures and distributes over-the-counter (OTC) and prescription
pharmaceuticals, nutritional products, active pharmaceutical ingredients (API)
and consumer products. The Company is the world\'s largest manufacturer of OTC
pharmaceutical products for the store brand market. The Company\'s primary
markets and locations of manufacturing facilities are the United States, Israel,
Mexico and the United Kingdom.

• Extensively worked on Data modeling and Reporting.
• Understanding the business challenges and translating them into
requirements and developed Analytics and Reporting Queries according to
Business Requirements.
• Data extraction involving LO and COPA critical objects and data modeling in
BW.
• Designed process chains for daily master data loading, transactional data
loading from SAP R/3.
• As a part of the production support, involved in the debugging and
monitoring load failures, update routines, transfer routines, process chains,
scheduling data loads, solving the high priority tickets like delta loads,
planning ECC outage for filling up of setup tables for Logistics (LO) extractors,
minimizing the Init load and setting the V3 jobs.
• Report development on manufacturing modules and integration experience
with FICO.
• Used RRI (Report-Report Interface) in order to get detailed information about
Sales orders.
• Reports like Confined Quantity and Item Purchase orders, Purchase Order
quantities delivered, Purchase order Values are created.
• Created Conditions, Exceptions, Structures, and Variables to use them in BEx
Reporting.
• Modified existing queries on various Info Cubes related to SD and HR-Payroll.
• Extensively worked on Query building, filtering, free Characteristics,
Restricted Key Figures and variables, Query variants using BEx Analyzer.

Project 3

Confidential,Mar 2007 - Dec 2008
SAP BI 7.0, SAP ECC 6.0
SAP BI consultant

Home Retail Group is the UK’s leading home and general merchandise retailer with sales of over £6bn in the last financial year. They sell products under two distinctive and complementary brands – Argos and Homebase – that are household names in the UK.

• Worked as a BI Operations Offshore Team Member, which has team of five.
• Actively involved in conducting fortnight meetings, maintaining incident reports as well as shift logs
• Involved in all types of tickets in load failures, performance, extraction and reporting phases of BW.
• Worked on Data warehousing workbench to create custom Info objects, Info sources, Info cubes, Data Store Objects, Transformations, DTP’s Created.
• Created reports in Bex according to the business requirement.
• Created the Process chains for Master data & transaction data and scheduled them according to the timings.
• Created delta load DTP & Full load DTP\'s and scheduled them as per business needs.
• Created Variables, Filters, Exceptions, Calculated key figures, restricted key figures, Global and Local structures and other features to meet user requirement.
• Daily Monitoring of Process Chains, Monitoring the daily as well as periodic data loads, Troubleshooting the process chains and keeping track of the issues that occur and trying to find long term solutions for them.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Maintaining Work History for all the tickets until it is closed down.
• Solving tickets raised by users according to their priority and requirements in time.
• Involved in solving the tickets regarding extractions and also load failures.
• Monitor performance on the system and inform onsite if load/build jobs take unusual amount of time.

Project 4

Confidential,India Nov 2005 - Jan 2007(
SAP BW Consultant
SAP BW 3.5, R/3

Suzlon Energy is Asia\'s strongest growing fully integrated wind power company and ranks amongst the top ten in the world. Suzlon integrates consultancy, design, manufacturing, operation and maintenance services to provide customers with total wind power solutions.

• Worked as a team Member in a team of five.
• Created Generic Data sources.
• Actively participated in designing the data flow from SAP R/3 to BW for Specific Functional areas, extraction using LO-Cockpit.
• Created Update rules, Transfer Rules as per requirements.
• Used BEx-Analyzer to cerate Reports. Used Restricted Key Figures, Variables, and Report to Report Interface (RRI).
• Involved in Performance tuning to improve DB, Front end and OLAP time.
• Created process chains for master data and transaction data loads.
• Was involved in Monitoring and providing necessary support for activities in production.
• Monitoring Process Chains.
• Actively involved in Rectification of Load Failure Errors like Master Data Loads, Transaction Loads.
• Daily monitoring of Info Cubes, Info Objects and ODS object requests.
• Creating Info packages to load master data and transaction data from R/3 and flat file.
• Daily Data Loading, Monitoring and Error Handling.