Post Job Free

Resume

Sign in

SAP BI/BW Consultant with ABAP

Location:
New Delhi, DL, India
Salary:
5.00 per annum
Posted:
June 04, 2014

Contact this candidate

Resume:

CURRICULUM VITAE

Tarun Gupta

SAP BW/BI Consultant

Contact #: +91-965*******

Email:

acefrw@r.postjobfree.com

Experience Summary

> 3 Years 6 Months of full time experience in SAP BW/ BI 7.0 & R/3

Technologies. I was involved in development, performance tuning and

maintenance of SAP BW and BI Systems. My strengths include highly

optimized development, good communication and technical skills, ability

to work in Co-ordination with large teams and disseminate knowledge

among the team.

> Areas of expertise in SAP BW / BI 7.0: Modeling, Business Content, Data

Extraction (SAP R/3, Flat Files), Data Loading, Scheduling, Monitoring,Reporting using BEx Analyzer and Performance Tuning with Different

Support and Implementation Projects.

. Modeling: Info Areas, Info Objects Catalogs, Info Object, Info Cubes,

DSO Objects, Info Sets, Multi Providers, Data Sources, Info Packages,

PSA, Transformations, Process Chains,Data Transfer Process (DTP), Open

Hub Destination, Transport Connection, BI Content etc.

. Extraction: LO Cockpit Extraction, Generic Extraction, Data Source

Enhancement, MM data loading, Content Extraction.

. Reporting: Restricted key figures, calculated key figures, Variables,

Processing Types, Condition reporting, Exception highlighting, Filter,

Free Characteristics, Structures, Workbooks and Replacement Path using

BEx Analyzer and Query Designer.

. Performance Tuning: Aggregates, Line Item Dimension, Compression,

Partition, Indexes, OLAP Cache and BI Accelerator Index.

. Support: Monitoring the process chains, Handling Data Load and Support

issues. Handle the tickets raised by the Customer. Handling Support

issues with Downtime of 24 hours or Less.

. ABAP: Creating Start Routines, Field Routines, End Routines, Info-

Package Routine using ABAP Code and Modifying the Same time to time as

per the Business Requirements .

Technical Credentials

> ERP: SAP BW/BI 7.0(3.5), SAP ECC (6.0).

> BW Skills: Modelling, Extraction, Reporting, Performance Tuning, Support

Activities

> Operating System: Microsoft Windows 98, Microsoft Windows Server

2000/2003.

> Database: SQL Server 2000 (2005), Oracle 9i, Oracle 10G.

Company Details

S.No. Company Name Designation Duration Client

1. JK Technosoft Associate 11th April 2011 Aricent Technology

Consultant till Present Holdings Private

Ltd

2. Aricent Training 26th July 2010 till Self

Technology 1st March 2011

Holdings Private

Ltd

Project Details

Project 1- Support

Client Aricent Technology Holdings Private Ltd - Gurgaon

Duration Nov 2011 - Currently Working

Team size 5

Position Associate Consultant

Environment SAP B.I 7.0, ECC 6.0

Contribution Support

Project iTrack

Roles and Involved with performance tuning of Queries by maintaining

Responsibili Aggregates, Compression, Partitioning, Indexing, and Line Item

ty Dimensions on Info cubes.

Monitoring daily, Weekly, Monthly the Data Loading Process

Chains and on demand Process Chains.

Data source Enhancements as per the Required Data Fields in the

SAP R/3 and Replicate it to SAP BW System in Reports.

Analyzing the reasons for frequent failures of Extractions and

correcting it to maintain the Load Schedule as per the

Requirements.

SAP MM Data Loads as per the Required Fields based on the MM

Data sources of R/3 and Extracting it to SAP BW .

Used delta upload mechanisms to upload SAP R/3 source system

data to SAP BW and also involved in uploading of Master and

Transaction data frequently.

Creating and Changing Routines (Start, End, Field) Routines as

per the Transformation Requirements for the Changed Data, info

package scheduling through Routines.

Data loading was monitored and the failed data packets were

analyzed and if possible manually edited in PSA (E.g-Invalid

characters) and re-loaded to DSO.

Creating - SAP SD Reports Creation - Data extraction from R/3,Modeling like creation of DSO's, Cube, Multiproviders, Creation

of Queries in Query Designer using Calculated Key figures,

Variables, Free Characteristics, Structures

Data Load - Extracted from R/3 and Flat File, Scheduling and

Monitor settings and Correcting the Data load Errors from PSA To

Target and Target to Targets.

Involved in Validated data consistency in reporting with Data

Target against PSA

Creating - SAP QM Reports based on R/3 data like Extraction,

Modeling, Reporting for certain Quality Reports and providing

various reports for the Managers.

Project - 2 Implementation

Client Aricent Technology Holdings Private Ltd - Gurgaon

Duration May 2011- Oct 2011

Team size 10

Position Associate Consultant

Environment SAP B.I 7.0, ECC 6.0

Contributio Implementation

n

Project iTac

Roles and Involved in creating and managing of Info Areas, Info Object

Responsibil Catalogs, Info Objects, Application components, PSA, DTP, Info

ity package, transformation.

Involved in creating Cube, DSO's, Multiproviders, Info sets, Open

Hub Destination.

Involved in creating Aggregates, Partitioning, Indexes, Roll-up

and Compression to improve the Query performance.

Very Good Hands on experience in BW reporting using BEx Query

designer, BEx Analyzer and creating Queries.

Involved in front-end BI Components like Queries, Formulae,

Variables, Calculated Key figures, restricted key figures,

Structures, Selection, Exceptions, and Conditions.

Involved in creating Variables like Characteristic, Text, Formula

used in Reporting

Worked on Generic and LO extractors for SD, MM & QM Module.

Worked on Data Source Enhancement for SD Module.

Uploading master data and transactional data both from flat files

and SAP R/3.

Creation of Process Chains, Meta Chains for upload of Transaction

Data and Master Data on Regular Basis .

Monitoring and Error handling in PSA like modifying the error

records and reloading the data from Flat files,Different Modules

from R/3 and Legacy Applications.

Installed objects from business content for SD,MM,QM Modules.

Involved in transportation objects from development to quality

and production.

Corporate Trainings

> Corporate Training in SAP BI 7.0 in Aricent Technologies Holding

Private Limited from 26th July 2010 till 1st March 2011.

Educational Qualifications:

COURSE YEAR BOARD/UNIVERSITY PERCENTAGE

M.C.A. 2010 IGNOU 65

B.COM (H) 2007 DELHI UNIVERSITY (SGND KHALSA 54

COLLEGE)

A.I.S.S.C.E. 2004 C.B.S.E. (MAPS - ASHOK VIHAR) 80

A.I.S.C.E. 2002 C.B.S.E. (MAPS - ASHOK VIHAR) 72

Certifications

DIPLOMA/CERTIFICATIONS YEAR INSTITUTE Details

ORACLE 9i (IZO-07) - SQL 2010 Oracle prometric Certified

center

ORACLE 9i (DBA-1,DBA-2) 2010 NIIT Learning

Programme

D(NIIT) 2009 NIIT Learning

Programme

SQL SERVER 2000 2008 Microsoft prometric Certified

center

Achievements (Extra Curricular)

> Awarded certificates for Dramatics and Yoga in school.

> Secured merit at senior secondary level

> Represented College in chess competition at University Level

> Best presentation in NIIT on the topic Technological Growth.

Interests

> Keeping myself abreast with latest trends and innovations in

software industry.

> Playing chess and listening soft music.

> Participating in debates and attending meaningful seminar

Personal Details

Address: 1998/ 156, Tri Nagar Delhi-110035

Date of Birth: 9th September 1986

Nationality: Indian

Marital Status: Single

Languages Known: English, Hindi

Gender: Male

Passport: Available

Validity: 10 Years

PLACE: Delhi/NCR

Tarun Gupta

DATE:

Signature



Contact this candidate