• Change management process through approval process and prioritization of issues and show stoppers.

• Managing go live support and post go live activities and warranty support. Design presentation, system architecture, sizing ( Servers based on DB size transaction volume). Naming conventions based on functional areas, company standards, company policies etc,. Managed several KT sessions to support teams in regions NA, EMEA, APJ and business user training for reports execution. Managed off shore teams in India, China and Mexico to get the project deliverables on time across geographies, advantage of getting work done round the clock to meet the SLAs in time to the partners.

• Worked extensively as a Techno Functional Analyst evaluating user requirements, converting business requirement documents (BRD) to Application design document (ADD), designed, developed end to end application by leveraging expertise in BI7.0/BW3.5 in functional areas SD, MM, CS and FI-CO.

• Architecting and implementing ETL/EDW concepts to acquire data from R/3 and partners by using external scheduling tools like TIDAL for incoming data to BI and from BI to partners by leveraging the Open hub technology in BI. Experienced in writing Technical specifications from Functional Specifications with good interactive skills with Business Analysts and users.

• Scheduling of data loads like critical master data, non critical master data, transaction data with respective to staging, transformation and data mart layers, based on dependencies to meet SLAs of the customer.

• Experienced in enhancing the business content extractors, Generic extractors for Transaction data, Master data extracts in SD, PM, PP and CS. Loading data from R/3 system from application specific data sources, generic data sources for master data, transaction data and flat file from third party systems to info cubes and DSO.

• New Extract structures using LO Cockpit which includes the functionalities like maintaining the extract structures, data sources, activating updates and Controlling V3 updates. Installing and Activating of Business Content wherever necessary as per the requirement. Experienced in coding for Generic data extractors, Customer exits and SAP Enhancements. Involved in the technical upgrade from BW 3.5 to SAP BI 7 like PREPARE and R3UP. Involved in MTP Activities and Production Support for several releases. Experience in creating Test Scripts/ Mercury QA tools and End User Documentation.

Worked as a Techno functional consultant, evaluated user requirements, converted the Business requirement documents (BRD) to Application Design Document (ADD), designed and developed application by leveraging ABAP/4 programming skills and functional expertise.

• Designed and developed Enterprise Data Warehousing concepts in all areas of BW/BI7.0 to maximize the efficiency of loading cycle and meeting the SLAs of HP partners.

• Implemented Data Warehousing concepts in all areas of BW/BI7.0 to maximize the efficiency of loading cycle and meeting the SLAs of HP partners. Worked on remodeling of info cubes BI to add the characteristics & key figures etc. Coded ABAP/4 wherever necessary in extractor enhancements and BI DTP transformations like start routine, end routine.

• Good exposure WAD for dashboards by using analysis and planning services.

• Designed and developed the modeling for Backorder processing (Order management) and extract for Loan Management tool for HP. Presented several KT sessions to the Global support teams.

BW Purchasing:

• Configured the Info cube Purchasing Groups (0PUR_C04) to analyze the buying activities of purchasing (buyer) groups by obtaining how many documents, document items, and document schedule lines have been created by the purchasing group.

• Loaded data through different levels of ODS for Purchase order and deliveries. Loaded data into Cube with auto update from different levels of ODS to which data is fed from flat files for sales order and deliveries. ABAP code was incorporated in update rules to check the conditions like status of the delivery completion, sales order quantity and overall status of the sales order.

• Developed code for a custom extractor for Pricing master data delta extraction to ODS by modifying the function module RSA3_GEN_GET_DATA. Dealt extensively with ROOSGEN, ROOSFIELD and ROOSOURCE tables while creating the Generic data source. Developed result set queries for pricing queries.

• Worked extensively on evaluating user requirements in the areas like Absenteeism management, payroll, postings, auditing and coming up with appropriate design, which sometimes involved mixing data from SAP and non-SAP sources.

• Used update rules extensively to convert the business rules of Delphi, e.g. to group the personnel areas to company codes.

• Used ABAP/4 code in transfer rules extensively to convert the company code to clients naming conventions etc.

• Experienced in loading data from flat file to cube.

• Created process chains for scorecard processing various applications to monitor the productivity.

• Experienced troubleshooting in areas like loading data, doubling of data in cubes regarding the applications like PFEP, Scorecard, Absenteeism management system etc.

• Created ODS to solve the data doubling issue. Developed a report for COPA in profitability analysis.

International Paper, Memphis, TN BW developer Sept’03 to Apr ‘04

Modules : PS, MM, SD and FI

Environment : BW 3.1O, R/3 4.7

Project profile:- Implementation of BW covering client’s world wide operations. Major customization of Project systems extractors for BW requirements involving mainly on the back end (R/3) and BW 3.1O development and customization to cater the business requirements.

Tasks performed in BW:

• Developed code, tested and delivered for the following Transaction data extractors.

• Created respective update rules with necessary update routines. ABAP code written for certain condition to be depicted in the cube like statuses. ABAP code incorporated in different stages like Global routine.

• Created the Info sources and scheduled several data uploads like initialization with delta updates. Monitored the scheduled background jobs.

• Worked extensively on BEX Analyzer. Created queries using BW-Reporting Variables, Navigational attributes and filters. Developed several queries and workbooks using BEX Analyzer according to end users requirement.

Project profile: This is an off shore project by IBM to one of the BM customers, which is the worlds largest petroleum products company having world wide operations, implemented logistics and IS-oil in SAP for their global business applications. My role in 3 tier support team involves gathering requirements, creating requirement analysis documents, business documents, technical documents and coding in ABAP/4 for the CCR’s or PIR’s or TIR’s based on the client’s business.

• Production Performance Report: This report gives at glance information of Production Quantity and raw material consumption’s and product cost per ton of finished product.

• Delivery due List Report: This report gives the detailed information orders to be delivered in due.

• Equipment down Time Report: This report gives the detail list of Equipment down time with full details of total period and description of the down time.

• SAP-Script: Worked with the SAP Script From with multiple potions such as creating, manipulating and formatting documents. Modified SAP Script Styles and layout sets as required by the client. Designed a SAP Script according the client requirement by using paragraphs, pages, windows and page windows. Designed variable windows on a page according to the client requirements. Worked on SAP Script with graphical Format.

• BDC: Worked with BDC in different Methods like Call Transaction and Classical Session Method to up load the following. Material Master: Upload the records of general stores materials. Vendor Master: Changed the addresses and other details of vendors using Session Method. Customer Master: Upload the records of costumer master details.

• ALE: Worked with ALE interfaces to transfer the IDOCs from one client to another client.

• BW MM: Worked on procurement cube (0PUR_C01) to enhance the BC with specific requirement to the client’s business process. Enhanced the master data to include attributes.

• BW Purchasing: Configured the info cube purchasing groups (0PUR_C04) to analyze the buying activities of purchasing groups by obtaining documents, document items and document scheduling lines that have been created by the purchasing group.

• Coded the update routine to count the different purchasing groups per month as no BEX formula can be used as the purchasing group is a characteristic.

• Report program developed for billing block (single/consolidated invoice) removal, which is Pre dependent of Manual invoice program for sub module Manage orders in sales and distribution.

• Developed an Auto invoicing report program to depict the details of orders due for invoicing.

• Created User exit for Credit check before delivery which checks credit limit for the order in another system via RFC Call.

• An inbound interface program developed to take the details of Heart order (from HP legacy System) from a Unix file and update the customized tables in SAP. Validation of the sales order, its items and the related heart order is done and the customized table will be updated accordingly based on the ‘transaction type status’ of the order in Unix file. The user status is also updated in the Sales order at item level.

• Inbound Program for Service items updating: -

An inbound interface program was developed to update the service items in the sales order.

This program reads the status of a trigger table (which is customized table) and updates another customized table (another customized table) based on statuses it has, either Auto Shipping or Auto Delivery.

This program is the interface between two other programs like TT10 and TT52.

• User exit: - This is basically a function exit which was added in an include program in main program.

This will update the customized table if the user presses push button ‘PGI’ to save the Delivery in ‘Vl02’ transaction. Upgrade experience from 4.5B to 4.6C.

• Used LSMW extensively for batch input of sales orders, material master with different plant and different purchase organizations, customer master and purchase order.

GMAC, PA, USA. ABAP/4 Programmer Jun’00 to Dec’01

• BDC for purchase order: Uploaded data from legacy system into SAP system using a combination of session and call transaction methods, so as to manage the error records easily.

• Work center productivity report: Productivity report for each center based on the selection criteria of work centers, date and plant. Monthly closing WIP, recoveries and late entries.

• Report for monthly late entries details, recoveries, WIP based and production order numbers based on the selection pf department, Sales order numbers, Sales Organization, Plant, Profit Center and Period.

• BDC for material master: Transferred data from legacy system to SAP system using a Session method. The program included creation of all-material master views and special features for error handling.

• Sales Order costing details: Report for output of actual and planned costs, Revenues and Gross profit, month to date, actual to date closing WIP and recoveries, Warranty and reservations based on the selection criteria of department, sales organization, sales order number, date.

• BDC for purchase order: Uploaded data from legacy system into SAP system using the combination of session method and call transaction method so that to manage the error records easily.

• Work center productivity report: Report for productivity of each work center based on the selection criteria of Work centers, date and plant.

• Monthly closing WIP, Recoveries and Late entries: Report for Monthly Late entries details, recoveries, WIP based and Production Order numbers based on the selection of department, Sales Order numbers, Sales Organization, Plant, Profit center and Period.

• BDC for material master: Transferred data from legacy system to SAP system using a Session method .The program included creation of all-material master views and special features for error handling.

• Sales Order costing details: Report for output of actual and planned costs, Revenues and Gross profit, month to date, actual to date closing WIP and Recoveries, Warranty and Reservations based on the selection criteria of department, sales organization, sales order numbers, date.

• Material & Labor Variance: This program generates an output for planned cost, actual cost & variances for material; Labor & Overhead costs based on the select-criteria production Orders, Material, and WBS Element.

• Upload Customer's RFQ into SD Quotation from Excel Format File: This program uploads the customer's RFQ from an Excel file to create SD Quotation. Stock with price will be printed in one report. Stock without price or no available stock will be printed in another report.

• Display selected purchase orders and amounts interactively: This program picks PO item details interactively upon user Selection. It also displays graphics for the list output.

• Packing List: This report program explodes the material BOM of the header material identified for packing & transportation in SD and prints out a packing list.

• Material Sales text report: This report gives the material sales text for all items where there is material sales text. This report has the option of being printed directly without display.

• Outward shipment report: This report gives details of the pending shipments for a month. Some details are taken from the shipment notification in the document.

INDUSTRIAL EXPERIENCE Dec ’88 to Oct’97

TATA Egg. and Locomotive Company Ltd, Pune. Production Engineer

• Lead a team of 10 supervisors & 250 work forces to meet stiff targets of automobile components by coordinating Materials Planning department as per the machine capacities and bottlenecks in India’s largest automobile company.