• I’m a professional with over 9 years of experience in SAP BI/BW.
• Has gone through two full design and implementation cycles and 2-support projects as a Team Member & Team Lead for different modules and having knowledge in Enterprise Portal 6.0. Also involved in in-house as well as client training in the area of Business Information Warehousing.
• Having Client facing skills and having good exposure in onsite .
• Undergone complete life cycle Implementation & on Production Support of 3.0B, 3.1C,3.5 & 7.0 which includes Data Modeling, Master data modeling, LO Cockpit Extraction, CO-PA Extraction, Info Cubes, ODS Objects, Info Source and Info Objects.
• Having Extensive Knowledge in SAP MDM SAP BIBO Reporting, Data Services and Rapid marts
• Strong Knowledge in SAP Console, SAP Import Manager, SAP Data Manager and SAP Syndicator.
• Strong Knowledge in SAP Console, SAP Import Manager, SAP Data Manager and SAP Syndicator.
• Strong Knowledge in SAP BIBO Reporting (Crystal Reports, Xcelsius,Web Intelligence,Webi Rich and Polestar),Data Services and Rapid marts
• Extensive Knowledge on BEx Analyzer, BEx Browser Query.
• Worked Performance issues like Maintaining Aggregates, Compression of Info Cube and Partition of InfoCube.
• Worked on maintenance of Info Objects, Info Cubes, ODS, PSA, Info Source, Data Source, Communication Structure, Transfer Structure, Transfer rules, Update rules, info Packages.
• Strong Knowledge in SAP BI 7.0 such as Transformations, DTP, DSO, RDA Report Designer, WAD, Process Chains.
• Modeling - Involved in managing of Info Objects, Info Cubes maintenance, DSO, Data Sources, Info Sources, ODS, Communication Structure, Transfer Structure, Update Rules, Info Packages.
• Extraction - Expertise in LO Cockpit Extraction, Generic Extraction, Flat file data Extraction for Master data and Transactional data.
• Reporting - Expertise in Creation of Bex-Analyzer, Conditions, Exceptions, Restricted Key Figures, calculated Key Figures, Free Characteristics, Filters, variables, structures.
• Performance Issues - Rolling Up the data to the Aggregates, Compression of Info Cube, Indexes, Repartitioning, Re-Modeling.
• Open Hub Services Info Spokes, Extracting data from SAP BW to other systems.
• Expertise in Process Chains.(RSPC) for Master data loads and Transaction loads with the help of info packages and these process chains are scheduled for periodic loads

Educational Background

BE CIVIL) From College Of Engineering GITAM (Andhra University).

Experience Summary

Confidential, (02/2009 10/2009)

• Apple Inc. is an American multinational corporation that designs and manufactures consumer electronics and computer software products. The company\'s best-known hardware products include Macintosh computers, the ipod and the iphone. Apple software includes the Mac OS X operating system, the iTunes media browser, the life suite of multimedia and creativity software, the iWork suite of productivity software, Final Cut Studio, a suite of professional audio and film-industry software products, and Logic Studio, a suite of audio tools. The company operates more than 250 retail stores in nine countries and an online store where hardware and software products are sold
• Role: SAP BI Consultant Duration:

Responsibilities/Deliverables:

• Created custom Data store objects to load History Data.
• Performed HRBW Business Content gap analysis.
• Identified the SAP integration points HR & FI/CO.
• Created custom Data store objects to load Historical Data.
• Installed HRBusiness Content for PA, PD, OM, BN.
• Responsible for the creation of BI Naming Convention document.
• AuthoredData Modeling documents and process flows.
• Actively involved in BW standard business content installation & enhancement of structures.
• Collected & Imported BW objects from Development to Quality Assurance environments and subsequently to Production environment using Transport Connector.
• Consulted on all aspects ofsecurity solutions forBI and ECC reports.
• Created custom DSOs for Education Assistance and Recurring Payments and deductions.
• Worked with security team to define the new Analysis Authorization concept.
• Extensively used ABAP Routines in Transformations to load and update data into Data Targets
• Responsible for creating Technical Design Documents based on the Functional Design Documents recreating by the Functional Analyst
• Worked Analyzed HR Reports in Benefits and Personal Administration Category
• Created 11 Reports in Benefits and Personal Administration Category.
• Worked on SAP BI/R3 Reports, Portal and Forms Test Scripts.
• Tested the developed Reports.
• Tested and corrected the Test Scripts in Reports, Portal and Forms. SAP Netweaver 2004s BI 7.0, ECC 6.0

Industry: ConfidentialCity: Stamford CT State (10/2008 12/2008)

Project Description/Scope

Pitney Bowes is a manufacturer of software and hardware and a provider of services related to document shipping, collectively referred to as mail stream. SAP Netweaver 2004s BI 7.0, ECC 6.0 (FIAR Performance Improvement)

Role: SAP BI Consultant Duration:

Responsibilities/Deliverables:
The objective of this project is to improve the performance of FIAR Reports by following the
below Options.

• Logical partition is a good option by splitting the data into yearly and creating a multiprovider.
• Creating secondary indexes on ODS ZUSARMO1 (FIAR Line Item ODS Pitney Bowes)
• Pre-Calculated Web Templates
• OLAP Caching
• Modifying Aggregates
• BI Accelerator can be used for improving the performance
• Analyzed FIAR DSO and Info cubes for improving the Performance
• Created ppt and metrics for improving the performance of the FIAR Report.
• Created secondary indexes on ODS ZUSARMO1 (FIAR Line Item ODS Pitney Bowes) for 0customer: (0Debitor) and Document No: (0AC_DOC_NO) in BID for improving the performance of FIAR Reports.
• Created a query AR Aging Report: Details RAJ_AR_AGING_DETAILS_6 for testing the Performance of the query.
• Physical partition is done on ODS ZUSARMO1 (FIAR Line Item ODS Pitney Bowes) with the help of DBA.
• Tested the AR Aging Reports.

Industry: Confidential City: Saint Louis Missouri State

Project Description/Scope

Confidential,is an agricultural company. We apply innovation and technology to help farmers around the world produce more while conserving more. We help farmers grow yield sustainably so they can be successful, produce healthier foods, better animal feeds and more fiber, while also reducing agriculture\'s impact on our environment

SAP Netweaver 2004s BI 7.0, ECC 6.0 (Sales & Distribution)

Role: SAP BI Consultant Duration: May 2008 Oct 2008 5 Months

Responsibilities/Deliverables: Analyzed & developed Shipments and Transports Cube & DSO
according to clients requirement.
Achievements:

• Analyzed the requirement for creating a new Shipments and Transports Cube & DSO.
• Discussed with the user for better understanding of requirement.
• Created new DSO & Cube for Shipments and transports then converted Shipments item level cube into header level.
• Added some fields in the new cube for the changed requirement.
• Written some logics in the update rules as per client requirement
• Loaded data into the cube.
• Tested the data in the cube.

Industry: Confidential: Baltimore Maryland state

Project Description/Scope Foundation Coal is ranked in the top five of the nation\'s largest coal producers. With 14 mines offer one of the most diverse product portfolios of any U.S. coal producer. This is a BI 7 end-to-end implementation engagement for Foundation Coal to replace the existing third-party ERP and BI systems.

SAP Netweaver 2004s BI 7.0, ECC 6.0 (Purchasing, Inventory Management)=

Role: SAP BW Consultant Jul 2007 Jan 2008 Duration: Seven Months

Achievements:

Industry: Confidential City: Omaha Nebraska State
Project Description/Scope: Armour Eckrich is a leading Food Provider in USA. It has bought a part
of ConAgra’s Meat business. It has developed a system, which captures the data related to this
new business as well as data Coming from various legacy systems.
SAP R/3 (MM, FI, CO) SAP BW 3.1C.
Role: SAP BW Consultant Duration: Aug 2005 - Jul 2007 Duration:One year Eleven Months
Responsibilities/Deliverables: Technical Lead, Support & Maintenance. Led 4 BW consultants to p
Support and maintain the systems.

Achievements:

• Worked extensively on the job scheduler tool Control M.
• Worked as a production support analyst wherein worked closely with the business users, analyzed the root causes of the problem, provided efficient solutions and modified several queries and info providers in a timely manner according to SLA.
• Monitored all administrator workbench schedules, aggregate loads, realignment runs, ODS loads, and batch jobs in BW
• Created info packages, background jobs, and process chain
• Loaded the history data and tested the various kinds of reports for inventory.
• Initialized the various data sources feeding to different data targets from different source systems.
• Loaded master and transaction data using Full and Delta Update Method
• Worked extensively onstandard LOS for inventory initialization.
• Involved in Re-conciliation of data with R/3 and BW Reports.
• Got some appreciation mails from onsite coordinator & users.

Industry: Confidential, France

Project Description/Scope: Total Fina ELF that is the 4th largest oil and gas exploration company in the world having business in oil and chemicals, and operates in more than 130 countries and has over 111,000 employees.

SAP R/3 (MM, FI, CO, PP), SAP BW 3.1C

Role: SAP BW Consultant & Team Leader Jan 2003 - July 2005 Duration: Two years seven months
Responsibilities/Deliverables: Led 3 BW consultants to support & maintain the systems.

Achievements:

• Working for this client that as France’s largest corporation, recorded the highest growth rate among the major oil companies while maintaining a high level of profitability
• Performing primary responsibility of supporting BW module for MM, FI, and PP modules
• Providing development support for all countries and new implementations along with IBM France
• Achieving a high strike rate and quick response time for issue resolution
• Analyzing different tickets according to the different client requirements
• Solving different loading problems
• Testing and solving different tickets according to client requirement
• Preparing documentation for the solved tickets
• Solving errors in the process chains
• Rectifying the loading errors

Industry: Confidential, in Canada

Project Description/Scope: Domtar Papers is into the manufacture and marketing of uncoated freesheet paper in North America, and operates through four segments: Paper, Paper Merchants, Wood, and Packaging wherein the Packaging segment produces corrugated boxes and containers; and specialty products, such as die-cut irregular size boxes, moisture resistant wax-coated and wax impregnated boxes, corrugated pallets, protective packaging products, and litho-laminated point-of-purchase products

SAP R/3 (SCM, SD, MM,), SAP BW 3.10

Role: SAP BW Consultant Sep2002 Dec2002 Duration: Four Months
Responsibilities/Deliverables: Analyzed & developed the ODS & changes in the reports according to
the requirement
Achievements:

• Analyzed different KPIS according to the client requirement
• Added some fields in communication structure and mapped fields to InfoSource
• Loaded data into ODS by running delta load
• Tested the data in the query

Industry: Confidential, Hazira India
Project Description/Scope:Essar Global Limited (EGL) is a diversified business corporation with a
balanced portfolio of assets straddling the manufacturing and services sectors: Steel, Energy,
Power, Communication, Shipping & Logistics, and Construction. EGL, through its six sectoral
holding companies, has an enterprise value of over USD 20 billion (INR 80,000 crores) and
Employs20,000 people worldwide

Role: SAP BW Consultant Aug2000 July 2002 Duration: One Year Eleven Months
Responsibilities/Deliverables: ImplementationProject, Analyzed developed different Cubes, Ods &
reports for SD & MM modules according to client requirement.

SAP R/3 (SD, MM, LIS) SAP BW 3.0B

Achievements:

• Worked as BW Team Member and SAP BW Consultant on phase II implementation for the development and maintenance of MM and SD modules
• Extensively worked on developing BW objects using data modeling, data extraction, generic extraction, data loading (full/ delta upload), scheduling, monitoring, InfoCubes, InfoSource, Logical Information System (LIS), MultiCubes, ODS objects, BEx Analyzer, BEx Query, Workbooks, and web reporting/ publishing
• Participated in complete life cycle of SAP Business Information Warehouse implementation
• Responsible for configuration of BW by identifying the requirements of customer InfoObjects, InfoSources, InfoCubes, ODS, and business contents
• Identified the standard SAP business content and custom objects according to requirements
• Responsible for activating, loading, and testing the business content objects, and troubleshooting the problems
• Worked on creating new data targets including InfoCubes and ODS (custom)
• Performed data extraction using LIS, LO, and CO-PA extraction and OLTP/ generic data extraction
• Created exception evaluations for queries
• Designed multiple drill-through reports from BEx Queries to ODS objects
• Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals
• Worked on Web Application Designer for creating templates
• Generated reports of Top N Customers from 0SD_C01cube (Customer), Customer: Deliveries per month (Customer), and Customers: Payment History from 0FIAR_C05 (FIAR: Payment History)