BALAJI M Email: acea2k@r.postjobfree.com

Phone: +91-959*******

CAREER OBJECTIVE

To excel in the challenging profession of SAP BI as a thorough professional by implementing and

upgrading my skills and knowledge base and to be a part of an enterprise firm where I can gain

exposure to the cutting edge technologies and effectively contribute towards the goals of the

organization.

PROFESSIONAL SUMMARY

• Over 3+ years of IT experience in design, development and implementation of business

applications.

• Involved in 2 life cycle implementations (including upgrade from BW 3.5 to BI 7.0) from

blue-print to Go-Live stages.

• Well versed with ASAP Methodology and all the phases involved in Project implementation.

• Hands on experience in SAP BI7.0, focused on Data Modelling, Reporting and Extraction

• Worked on Info Objects, Data Sources, MultiProviders, DSO, Info Cubes, Info Packages,

PSA, Transformations and DTP.

• Worked on extracting master data and transactional data from flat files and SAP R/3

• Expertise in report generation-worked on BEX-Query Designer and Analyzer in building

Queries using Conditions, Exceptions, Calculated key figure, Restricted key figures, Filters

and Variables

• Worked on Extraction of data from SAP source systems using LO Cockpit Extraction,

Generic Extractions and including installation of Business Content.

• Extensive experience in Production Support. Created and Scheduled process chains to load

master/transaction data for daily, weekly and monthly intervals

WORK EXPERIENCE

Working as a SAP BI Consultant in Cognizant Technology Solutions India Pvt Ltd, Bangalore

from May’10 to Till Date.

PROJECT# 3

• Client : Woolworths

• Organization : Cognizant Technology Solutions India Pvt. Ltd, Bangalore

• Type : Implementation

• Role : SAP BI Technical Consultant

• Duration : May20th 2013 to till date

• Environment : SAP ECC 6.0 and SAP BI 7.0.

Responsibilities

Involved in gathering Business Requirements and preparation of Information template used

for identifying data elements for future reporting needs.

Involved in analysis of data requirements & translation of these requirements into

dimensional data models using star schema and extended star schema, with an

emphasis on actual implementation in BW.

Worked with the Data management group during the process of Data Analysis & Data

Mapping exercise.

Installed and extended standard Business Content based on client requirements for enhancing

DataSources for transaction data and master data.

Created Info Objects, DataSources, InfoSources, Data targets, InfoPackages and

InfoProviders to load Master and Transactional data from SAP R/3 system into BW system.

Involved in customizing LO-Cockpit extract structures (2LIS_11_VAHDR,

2LIS_11_V_SSL) and data sources in sales and distribution, and material management to

facilitate the data extraction to BW and to reporting using classification of various data

elements.

Created Info package groups to automate the data transfer when and what intervals the data to

be extracted from R/3 to BW.

By using Open Hub Service the data, which is in Info, cube and ODS is passed to Flat files

and db tables.

Enhanced the Communication Structures to add new fields for Purchase Orders.

Developed Transfer Rules to extract data from various DataSources to transfer structures.

Created Custom InfoCube for Key Performance Indicators (KPIs) defined by business.

Created a generic structure to extract data from the custom tables.

Designed and created an ODS object which gets data from the generic structure.

Worked on performance tuning of Queries by creating aggregates, indexing and cube

Compression.

Created variables restricted, calculated Key Figures for the Queries. Created Conditions,

Exceptions, Structures and Variables that are used in BEx Reporting.

Provided help in end-user training and documentation.

PROJECT# 2

• Client : Kimberly Clark Corporation

• Type : Implementation

• Role : SAP BI Consultant

• Environment : SAP BI, Bex, ECC

• Duration : July 20th 2012 to April 2013

Responsibilities

As a part of the BW implementation team, involved in gathering user requirements and data

modeling using ERM, star schema concepts.

Analyzed Business and Query Requirements, designed data model.

Worked extensively on administration workbench and business content.

Worked on flat file extraction of master data and transaction data of Non-SAP R/3 systems

into BW. Used extended star schema for data modeling.

Worked on configuration of BW by identifying the needs of customer, modeling the data,

defining data sources at OLTP and reporting data by using Administrator Workbench’s

Business explorer.

Installed and extended standard Business Content based on client requirements for enhancing

DataSources for transaction data and master data.

Worked on standard cubes (sales orders, billing and delivery orders).

Modified data sources for certain Info cubes (0SD_C01, 0SD_C03).

Used purchasing cube 0PUR_C01 for purchasing information. Designed and created a

Custom ODS object for purchasing line item level details.

Involved in developing extract structure in R3 and communication structures in BW to

incorporate the changes for the end user acceptance.

Developed reports on InfoCubes/ODS objects using BEx Analyzer to facilitate summarization

of data. Created local workbooks, global workbooks, Infoset queries and template workbooks

using Calculated Key figures, Restricted Key Figure, Filters, Exceptions, Variables,

Conditions and Structures. Created and maintained roles.

Involved in end-user training and documentation.

PROJECT# 1

• Client : Blue Shield of California

• Type : Support

• Role : SAP BI Consultant

• Environment : SAP BI, Bex, ECC

• Duration : June 22nd 2011 to May 2012

Responsibilities

Involved in monitoring the info package groups and process chains

Resolving the tickets related to extractions and monitoring of info Packages

Interfacing with the customer for clarifying queries regarding tickets posted.

Generated documentation for Meta Data Objects like Info cubes and InfoObjects

performance Tuning

Monitored the performance of the aggregates using BW Statistics InfoCube

Involved in delta and full upload of Transactional and Master Data.

EDUCATIONAL DETAILS

B.E., May 2009, Anna University, Chennai.

Major in Computer Science (66%)

HSC, April 2005, State Board, Tamil Nadu

Major in Maths and computer science (86%)

SSLC, April 2002, CBSE, Tamil Nadu (63%)

PERSONAL INFORMATION

• Age : 26 years

• Sex : Male

• Marital Status : Married

• Citizenship : Indian

• Language Fluency : English, Malayalam, Hindi, Tamil

Contact this candidate