• Chennai TamilNadu

Balamurugan K

SAP BW/BI ABAP Consultant

Summary

  • 2+Years of SAP BW/BI experience, which includes Data-Modelling, Data Extraction, Data Loading, Scheduling, Monitoring, Reporting and Performance Tuning.
  • Extensively worked on designing/creating InfoObjects, InfoSources, Transfer structures, Communication structures, Standard and Custom InfoCubes, Data Store Object (DSO).
  • Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using BExAnalyser.
  • Performed LO Cockpit extraction, Knowledgeable in LIS, Generic and CO-PA extraction.
  • Expertise in Report Generation. Worked extensively on BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
  • Knowledge On WEB Reporting, Reporting Agent, Open Hub Concept.
  • Experience in Data loading, Monitoring and Scheduling using Process Chain.
  • Having ability to communicate effectively at all levels of Application Development phases in the Company.
  • An excellent team player as well as an individual contributor with good communication and interpersonal skills.
  • Quick learner and stronger desire to master in new Technologies.

Work History

Work History

SAP BW Consultant

Aug 2013 - Present
IBM India Pvt. Ltd

Experience

Client: ALSTOM, Environment: SAP BI 7.4, BI 7.0, ECC6.0 Business Areas: All Major Modules

Role: SAP BW/BI Consultant 

Accomplishments

  • Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multiproviders
  • Set up periodic Data loads from legacy system (flat files)
  • Involved in extracting the data from External Source system like Informatica.
  • Installing and creating BI objects like info objects, DSOs, Info cubes.
  • Creating and managing data-flow using DTP, transformations and info packages.
  • Data Source Enhancement according to customer requirement.
  • Designed and developed queries to generate reports in BEx Analyzer.
  • Worked extensively on query designer.
  • Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.
  • Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.
  • Created ODS, Infocubes, Multi-providers and info-sets and extracted SD data (Data sources Like 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit(LBWE) extraction. Extensively worked for Sales Order Review.
  • Setup and monitored collective run jobs for SD module in LO Cockpit.
  • Monitored loads for SD module from R/3 source system.
  • Corrected delta load failure for SD module.
  • Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains.
  • Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions.
  • Involved in frequent client meetings to discuss project status.

Education

Education

Bio-Medical (Masters in Engineering)

Aug 2011 - Jun 2013
CEG, Anna University, Chennai


Computer science (Bachelor in engineering)

Jul 2007 - Apr 2011
Apollo Engineering College