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