Project based in Australia.

·         Involved in BI 2004s & BI Accelerator Sizing

·         Involved in the Pre Upgrade Activities (3.5 to BI 2004s)

·         Involved in the post-Upgrade activities (BI 2004s)

·         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

·         Extensively worked on SAP NW2004s (Transformations & Data Transfer Process)

·         Worked on Data Store Objects and Rebuilding of the Info Cubes.

·         Created Dashboards and web Reports Using Web Application Designer

·         Actively involved in Transports, Troubleshooting and Data Validation

·         Performance tuning of Queries by maintaining Aggregates, Compression, Partition of info cubes.

·         Involved in Business Content Activation, Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BW

·         Developed Warranty Parts Per Million and Shop floor Parts per Million Reports with drill down for material, Vendor , Purchasing Group & Time Characteristics

·         Developed Aged Inventory Report for calculating age of the Finished product with Drill down for Plant, Storage Loc, Material and material Type

·         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.

·         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

·         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

·         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

Project based in USA.

·         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

·         Extensively worked on Creating Dashboards & Web Reports Using Web items Like Tables, charts, Drop down Box, Radio button Check Group, Label, Filters and Text Elements

·         Created Process chains for Master data and transaction data loads

·         Developed Inventory Stock Statement Report with Drill down for material, Plant Material Type, Material Group and Storage

·         Installed Business Content Sales Overview Cube (0SD_C03), 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

·         Created Data Sources using the Function Module, Views & Tables

·         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

·         Developed Report for Project System report with Comparison Actual Cost and Planned Cost with drill down for WBS Element

·         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

·         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

·         Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multi Providers, Info Sources, Data Sources, and Info Packages

·         Involved in solving performance-related issues

·         Uploaded master and transactional data from flat files, SAP BW and SAP R/3

·         Involved in the preparation of End User Training documentation

·         Extracted data from Oracle database by using DB connect and generated reports as per user requirements

·         Developed Functional and technical Specifications

·         Build Aggregates to improve query performance

·         Participated in Post Go Live and Production support programs