Ravindra Raju 
510 248 4101


	Seasoned IT professional with Over 6+ Years of Information Technology Experience.
	Nearly 5+ years of SAP BW ( 7.0, 3.1C, 3.0B), SAP R/3 (4.7, 4.6C) experience which includes data extraction process Using administrator’s workbench, Bex analyzer and WAD
	Good planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability   
	Motivated and focused team player with Strong analytical and problem solving skills with excellent interpersonal and communication skills.

Summary of Technical Expertise

	Experienced in BW implementation lifecycle from requirements gathering, solution design, architecture, readiness assessment, customization, and rollout.
	Applied and implemented ASAP methodologies(Project Preparation, Business Blueprint phase, realization, Final Preparation, Go-live and Support) 
	Extensively Worked on SAP NW2004s BI (Transformations & Data Transfer Process)
	Good functional knowledge of Sales & Distribution (Sales Orders, Deliveries, Billing , Retail & Warranty), MM (Purchasing & Inventory Management), PM, FI and general business process of SAP R/3.
	Worked on BI Up gradation Project from Version BW 3.1C to Version BI 7.0
	Involved in Managing of Info Cubes, which involves Info Cube Content, Performance issues like Indexes, Statistics, and Compression of Info Cube, Creation and Rolling up the data to the Aggregates.
	Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, update rules, Extractors, Info sources, Info packages, Info objects Catalogs, Data Sources, Data Extraction, Characteristics and Key figures, Business Content, Data Marts, Process Chains, specific to SD, MM, PP, PS, PM, QM, FI/CO, AR, AP, and GL.
	Expertise in Creating Web Reports & Dashboards Using Web Application Designer.
	Expertise in LO (SD, MM, PP, PM, QM), FI and Generic data extraction mechanisms.
	Expertise in creation of Bex Analyzer Queries, Workbooks, structures, variables, calculated key figures, restricted key figures, and RRI reporting, Ad-Hoc Queries, Authorization and role maintenance.
	Extensively Worked on the Reporting Agent and BW Archiving.
	Working knowledge on SEM BPS, CPM & SRM.
Technical Skills:
     Data warehousing tools                   :           SAP BW 3.0B/3.1C/3.5/7.0.
     Languages 	     		:	ABAP, C, and C++.
     Databases	      		:  	Oracle 8i, MS-Access.
     Operating systems             	    	: 	Windows NT/2000/XP.
     ERP Package 	 		:           SAP R/3 4.7, 4.6C

Project 1: 
Hewlett Packard (Upgrade & Enhancement)        Houston, TX                 Jun’06 to Mar’07
SAP BW Consultant

1.	Requirement gathering for Project Preparation, Business Blueprint phase, realization, Final Preparation, Go-live and Support
2.	Extensively worked on SAP NW2004s (Transformations & Data Transfer Process)
3.	Worked on Data Store Objects and Rebuilding of the Info Cubes.
4.	Created Dashboards and web Reports Using Web Application Designer
5.	Actively involved in Transports, Troubleshooting and Data Validation
6.	Performance tuning of Queries by maintaining Aggregates, Compression, Partition of info cubes.
7.	Involved in Business Content Activation, Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BW
8.	Developed Warranty Parts Per Million and Shop floor Parts per Million Reports with drill down for material, Vendor , Purchasing Group & Time Characteristics
9.	Developed Aged Inventory Report for calculating age of the Finished product with Drill down for Plant, Storage Loc, Material and material Type
10.	Developed Days of Supply Report for measuring of the number of days of shipping can last with the current level of inventory with drill down for Plant, Material, Cal day and Material Type.
11.	Developed Safety Stock Days of Supply Report for measuring the number of days of shipping we can last with the standard level of safety stock. With drill down for Plant, Material Type, Cal Day, Cal Month & Material
12.	Developed Days Sales Outstanding report for measuring of the average delay to get paid, from the invoicing date with drill down for Plant, Company, Customer and Cal day
13.	Developed Days Payable Outstanding report for measuring the average delay to pay our suppliers, from the date of the payable. With drill down for Plant, Company, Vendor and Cal Day
14.	Created Reports in Bex and Web Reports for Capturing SLAs by Fetching Help Desk Data from the SAP Solution Manager 4.0
15.	Involved in BI 2004s & BI Accelerator Sizing
16.	Involved in the Pre Upgrade Activities (3.1C to BI 2004s).
17.	Involved in the post-Upgrade activities (BI 2004s).
18.	Involved in the Pre Upgrade & Post Upgrade Activities for BI Plug-In Upgrade on the R/3 from 2003.1 SP 10 to 2004.1 SP 12

Project 2:
Armstrong (Implementation)                     Lancaster, PA                         Apr’05 to May’06                
SAP BW Consultant


1.	Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements. 
2.	Extensively worked on Creating Dashboards & Web Reports Using Web items Like Tables, charts, Drop down Box,  Radio button Check Group, Label, Filter & Text Elements.
3.	Created Process chains for Master data and transaction data loads.
4.	Developed Inventory Stock Statement Report with Drill down for material, Plant Material Type, Material Group and Storage
5.	Installed Business Content Sales Overview Cube (0SD_C03) and designed and activated Customer service cubes to meet user needs. Created several ODS objects which acts as data staging. Configured data sources in R/3 by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for periodic loads.
6.	Created Data Sources using the Function Module, Views & Tables.
7.	Gathered reporting requirements and designed the data flow from SAP R/3 to BW for specific functional areas like, FI-CO, Sales Distribution, MM, PS and QM.
8.	Developed Report for Project System report with Comparison Actual Cost and Planned Cost with drill down for WBS Element.
9.	Developed report for Plant Maintenance for comparison of the cost incurred on material and labor Cost with drill down for Material, Functional Location, Plant & Cost Center
10.	Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of Info Packages. And these Process chains are scheduled for periodic loads.
11.	Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, MultiProviders, Info Sources, Data Sources, and Info Packages. 
12.	Involved in solving performance-related issues.
13.	Uploaded master and transactional data from flat files, SAP BW and SAP R/3.
14.	Uploaded hierarchies using Flat Files.
15.	Involved in the preparation of End User Training documentation
16.	Extracted data from Oracle database by using DB connect and generated reports as per user requirements.
17.	Developed Functional and technical Specifications.
18.	Transporting the objects from Dev Server to QA Server.
19.	Build Aggregates to improve query performance
20.	Participated in GO LIVE and Production support.


Project 3:
  Delphi Automobiles (Development & Support)        Detroit, MI                Sep’04 to Mar’05       
  SAP BW Consultant

1.	Creation and Monitoring of the Process Chains Regularly.
2.	Worked on Authorizations and Role Maintenance.
3.	Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures.  
4.	Developed Reports for Capturing COGI with drilldown for Material, Cal Day and Plant.
5.	Developed Reports for Warranty with drilldown for Vendor, Material, Code Group, catalog Type, Problem Code, Chassis No, Production Month, and Claim Settlement Month.
6.	Developed Reports for Sales Operational Planning. With drilldown for SKU, Plant and Cal Day.
7.	Developed Vendor Turnover (Share of Business) Report based on the Rate Amendment. With drilldown for Purchasing Group, Vendor, Plant, Cal month and Material.
8.	Developed the Fixed Cost Report for Comparison between the Planned Cost for the Recurring Activities with Actual Cost Incurred with drill down for material, Vendor, Purchasing Group, WBS Element, Project Type and Project.
9.	Created Aggregates, Compressed Info Cubes, Updating DB Statistics Regularly and rebuilding missing indexes for increasing the Query Response.
10.	Involved in POC for Archiving Data in BIW.
11.	Generated reports using BEx (Business Explorer) with variables, exceptions, restricted key figures, calculated key figures, conditions, formulas, RRI interfaces, filters, drilldown methods.
12.	Worked on Reporting Agent for Running Reports in Background.
13.	Developed Web Reports & Dashboards Using Web Application Developer.

Project 4: 
Dom Tar (Implementation)                      Toronto                                     May’03 to Aug’04
SAP BW Consultant
 
1.	Worked extensively on Web Reporting tools, designed and developed Web templates and BW Dashboards 
2.	Worked extensively with Business Content for modified existing Sales and Financial Info Cubes to meet the End-User Requirements
3.	Installed the technical content cubes to update the BW Statistics data
4.	Enhanced the Standard extractors 0FI_AP_4 and 0FI_AR_4 with the Business Area 
5.	Developed Pending Order Status Report to display pending Purchase Orders (PO) with drilldowns for material and vendor
6.	Modified several existing BEx. Reports to improve performance. To improve the performance of the reports reorganized the Dimensions. Provided Line Item dimensions.
7.	Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements. 
8.	Installed Business Content as and when required.
9.	Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of Info Packages. And these Process chains are scheduled for periodic loads.
10.	Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, MultiProviders, Info Sources, Data Sources, and Info Packages. 
11.	Involved in solving performance-related issues.
12.	Uploaded master and transactional data from flat files, SAP BW and SAP R/3.
13.	Involved in Transporting the BW objects from development server to Quality server for Integration testing and Unit testing.
14.	Created MultiCube for specific queries of MM. Incorporated transfer rules for Info Cubes and customized update rules using ABAP/4. Extended standard Business Contents based on client requirements using USER Exit and Function Module


Project 5:
Hitachi Electronics                             Tokyo, Japan                                   	Jun‘02 to Apr‘03
SAP   ABAP Consultant

Reporting:
1.	Generated an interactive report that Displays Vendor Output Status based on Company code, Purchasing Organization, account group, document type and output type in ALV (ABAP List Viewer). Purchase Order Stability – Correction and Minor enhancement.
2.	Sales Order Report: In this interactive report, sales order details of a customer are displayed, delivery details for a sales order are displayed for that customer and finally the billing details of that particular delivery are displayed.
3.	Developed ALV and Interactive reports that generate monthly summary of sales. The report displays customer, amount, and document number, invoice number and other details.
BDC (Batch Data Communication):
1.	A data transfer programs that changes address information for a vendor. There are two screens in this transaction that we’ll be using. Here the program supplies the vendor numbers that are to be changed and the address check box is selected.
2.	A program, which uploads the quotation from the flat file into the SAP System using Recording. Transaction Code VA21 is used and Tab delimiter separates data.

Project: 6 
Startec Communications        Maryland                                      Jan 01 to May 02
Oracle developer

1.	Extensively used PL/SQL Stored Procedures, Functions, Form Triggers and Packages.
2.	Wrote scripts for indexes and Database Objects as per the Oracle Standards.
3.	Created SQL, Object Views and PL/SQL database objects.
4.	Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
5.	Created generic scripts to dynamically compile database objects in their Dependency order.
6.	Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
7.	Involved in performance tuning and monitoring.
8.	Designed and developed backend PL/SQL packages in the database layer, stored procedures, functions and triggers.
9.	Established methods to migrate databases, objects and jobs to new servers.
10.	Tuning of stored procedures & developed business logic in database layer using PL/SQL.

Environment: Oracle 8i, UNIX, SQL, PL/SQL, SQL*Loader and Toad, Windows2000/XP, SQL Server 2000.

Education:
•	Bachelor of Engineering [Electrical & Electronics] 
      Madras University, Chennai, TN, India.    
•	Master in Engineering (Advanced Engineering)
             Dublin Institute of technology, Dublin, Ireland.