SAP BI/BW,SAP R/3,SAP BO,Bex

Nikita Sinha

Email: ******.********@*****.***

Mobile: +91-995*******

Career objective

Aspiring for a career in SAP Business Intelligence that is challenging

within a fast-paced and learning-oriented environment for enhancing my

technical and inter personal skills.

Profile Summary

. Having 3 years of experience in SAP BI/BW in Svam International

Inc., Noida, as a SAP BI Associate Consultant.

. Having exposure to Implementation, support and Development

projects.

. Having good technical knowledge on Data Extraction, Modeling, and

Reporting.

. Expertise in understanding R3 system and considerable experience

in BW development.

. Has ability to work independently and in team with good

knowledge.

. Has strong analyzing skills and able to handle critical Issues

. Excellent organizational, analytical, problem solving and

communication skills.

Educational Qualification

B.E. (IT), Thakral College of Technology, RGTU University, Bhopal (2006-

2010).

Technical Skills

. SAP Data Warehouse: SAP BI 7.0, SAP BI 7.3 and SAP BI 3.x.

. Operating system: Windows XP 2000, Windows 7.

. Reporting tools: SAP BEx(Analyser and Designer).

Professional Experience

Project 1:

Client: Avaya

Work duration: Nov 11 - Nov14

Project Type: Development and Production support

Role: Developer

Avaya is a leading global provider of next generation business

collaboration and communications solutions providing unified

communications, real time video collaboration, contact center, networking

and related services to companies of all sizes around the world. Avaya's

open standard -based platform accommodates customers with multi-vendor

environments seeking to use their existing investments, supplement their

existing solutions with specific collaboration products they need, rapidly

create and deploy applications.

Here we designed ETL for SD and FI R3 data extraction. We created a

custom flow using standard Data sources and Info objects and designed ETL

to pull data from non R3 system using UD connect.

Role and Responsibilities

. Worked on areas like sales,bookings,billings,backlog,etc.

. Worked extensively with Data Warehouse workbench(RSA1).

. Extensively involved in creating the Background jobs for the

Process chains (local and meta chains).

. Handled multiple change requests on repoting like creating

functional and technical vairables for various time periods.

. Extensively worked in Business Information Warehouse Infocubes,

DSO objects, Data- Sources, Info-objects, Transformations, DTP

Extractors, Data Sources, Infopackages, Data Extraction,

Characteristics and Key Figures, Process Chains.

. Have done initialization of corrupted data using delta

with/without data transfer.

. Deletion and Filling up of Set Up Tables.

. Experienced in creating Generic Data Source in SAP R/3 and

replicating them to BI in the process to load R/3 Data to SAP BI.

. Handled the tickets of different severities by following standard

operating procedures and never missed the service level agreement

(SLA).

. Monitoring periodic data loads from R/3, flat file to data

targets using RSPC, RSMO, SM37, and SM50.

. Created and modified queries based on user requirement using

restricted key figure, free characteristics, filters

conditions, formulas.

. Involved in creation of Transformations and DTP's.

. Finding the root cause of repeated chain failures and fixing it.

. Worked in many cutover activities (in BI as well as R/3 cutover).

. Worked extensively in Bex analyzer in building queries and saving

in workbooks and created custom queries using conditions,exceptions,variables and structures.

. Designed standard and virtual infocubes, infosources, info

objects, multiproviders, transformations, process chains using

DWB.

. Checking the daily, weekly, monthly data loads using process

chain and fixing the issues.

. Reconciling the daily booking, billing, devlivery and other

schdule lines data loads through custom program then updating to

the user's and auditing team for the data qualitiy.

. Undergone complete life cycle Implementation of BW, which

includes Data-Modeling, Data Extraction, Generic Extraction, Data

Loading, Scheduling, Monitoring, LO Cockpit, BEx Query.

. Worked in aggregates, re-partioning and compression of infocube

to improve query performance

. Involved in Data extraction from flat files for Master data and

Transactional Data, update/transfer rules creation, Business

Content Activation, Direct and Flexible update of Master data.

Implementation:

. Implemented a CR (There was one field item 0item_categ in column

and the user requirement was to have it in rows as well in the

report,so we created a copy of that info object and added to

multi-provider,because of this we were able to see 0item_categ

data in rows as well as columns).

. Implemented a fresh architecture for radvision (includes

creating)customised info objects, data sources creation of write

optimised and standard DSO)

. Added fields to technical cube ->modify the global MPR of

Billings, Bookings and Backlog.

Extracurricular activities

. Participated in various inter college quiz competitions.

. Participated in floor decorations during Deepawali celebration at

Svam International Inc.

. Got the consolidation prize in inter house level competition in

School.

. Participated in College level Antakshari event held in 2009 and

got 2nd Prize.

Personal Details

Date of Birth : 25th Aug, 1987.

Languages : English and Hindi.

Present Address : A-4, Mavanna Apartments,

Door No- 4B/54B,

4th Naidu Street, Kotturpuram

Chennai, Tamilnadu 600085.

Declaration:

I hereby declare that the above written particulars are true to the best of

my knowledge and belief.

Place: Chennai

Date:

(Nikita Sinha)

Contact this candidate