Data Sap
Resume:
NIVASU
Email:**********@*****.***
SAP BI Consultant Contact no:
Professional Summary:
Having 3+ years of professional work experience as SAP Business Intelligence
Consultant, I Involved in Two Implementation and One support projects as a SAP BI
Consultant.
• Extensively worked on data modeling- Info cubes and DSOs, Data sources,
Transformations, Info packages, DTPs and Multiproviders, designing custom Info
objects.
• Expertise in Extraction, SAP Multi-dimensional/Extended Star Schema data models,
BW Customizing, BEx & Web Reporting and BO reporting using Web Intelligence.
• Extracted data from Logistics applications using LO Cockpit and performing
necessary procedures like Deleting Setup Tables, Filling up of Setup Tables and used
initialization & delta updates and Setting up of Queued Delta for deltas.
• Data load issues and Process Chain maintenance.
• Worked with PSA in monitoring the data transfer from source system into BI.
• Responsible for migrating data source for 3.x to 7.0.
• Involved in changing the Existing data model of an Info Cube by adding new
Characteristics and Key figures.
• Worked on BEx Query designer in designing reports using calculated key figures,
restricted key figures.
• Experience in installing the Business Content Objects depends on client
requirements.
• Experience in working in SAP BI Production Support Environment and Resolving the
Tickets based on Priority.
• Involved in transporting the objects.
SKILL SET:
• Modeling : Info Objects, Info Sources, Info Cubes, DSO/ODS objects, Multi
Providers, Virtual Providers, Data Sources, Transfer rules, Update rules,
Communication structures, Info packages, Info object catalogs and Process Chains.
• Extraction: Generic, LO cockpit, Activation and maintenance of data source in
source system, filling up and deleting setup tables, customizing and enhancement of
Extract Structures.
• Reporting: BEx-Analyzer, Condition reporting, Exception highlighting, restricted key
figures, Variables, filters, Free Characteristics and Structures in SAP BW.
• Performance :Aggregates, partitions and Compression, roll up.
Professional Experience:
• Presently working as a Netweaver BI Consultant for Arteria technologies from Sep
2013 to till date.
• Worked as Associate BW Consultant for Vivera IT from May 2012 to Aug 2013.
• Worked as Associate BW Consultant for Spectra Soft Technologies from Apr 2011 to
May 2012.
Educational Qualifications:
Bachelor of degree (B.com) from Acharya Nagarjuna University.
Technical Skills:
Operating System : MS-DOS, Windows
ERP : SAP R/3 4.6C, 4.7EE, ECC 6.0
Reporting Tool : BEx,
Data Warehouse : SAP BW 3.5, BI 7.0.
Application Programs: MS Word, MS Excel, MS Power Point.
Project #3:
Organization : Arteria technologies
Client : Flextronics International Ltd
Environment : SAP BI 7.0, ECC 6.0
Role : SAP BI Consultant
Type : Implementation
Duration : Sep 2013 to Till date
Client Description:
The Flextronics team spans 30 countries and four continents, and is over 200,000 people
strong. At Flextronics impossible is where breakthrough begins. As a socially-
responsible, global leaderin design, manufacturing, distribution and aftermarket services,
Flextronics is unique in its ability to provide end-to end solutions through its innovative
and proprietary systems-all to enhance customer competitiveness and success Working
across four business group and several business units, Flextronics is and success.
Working across four business groups and several business units, Flextronics is able to
unleash the full potential of the world’s most valuable brands and new ventures.
Roles & Responsibilities:
Involved in installing Business content Objects like Info Areas, Info Objects, and Info
cubes, Data Store Objects, Info packages and Data Transfer Process.
Involved in creation of Info cubes, Data store Object (standard DSO, Write Optimized
DSO) and Multi Providers.
I was also involved in writing start routine, end routines in building the
transformations to the different source objects.
Involved In Bex Query Designer and Bex Analyzer.
Created queriesby using Variables, Calculated key figures, restricted key figures,
Conditions and Exceptions, Filters according to end users requirement.
Involved in Jump Query using RRI (Report to Report Interface).
Involved in Performance tuning like Creation of aggregates, Partitioning, Indexes and
Compressed the Info Cube to improve the query Performance.
Project #2:
Company : Vivera IT
Client : Burberry
Project Type : Support
Role : SAP BI consultant
Duration : May 2012 to Aug 2013
Client Description:
Burberry Group is a British luxury fashion house, distributing clothing, fashion
accessories fragrances and cosmetics, Burberry is most famous for its trench coat, which
was designed by founder Thomas Burberry. The company has branded stores and
franchises around the world
and also sells through concessions in third-party stores. The company is listed on the
London Stock Exchange.
Responsibilities:
Schedule Daily/Weekly/Monthly data loads schedule new jobs
Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or
not after the data loads
Monitoring master data loads and transaction data loads.
Monitoring process chains and handling problems
Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW is same.
Data loading was monitored and the failed data packets were analyzed and if possible
manually edited in PSA (mostly for invalid characters) and re-loaded to ODS.
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
Project #1:
Organization : Spectra Soft Technologies
Client : GBL (Godavari Bio Refineries Ltd)
Project Type : Implementation
Role : SAP BI consultant
Duration : Apr 2011 to May 2012
Description : GBL is one of the largest producer and manufacturer of Sugar, Alcohol
Based Chemicals and
Energy.
Responsibilities:
Worked on administrator workbench, and customized info objects, and created Info
Cubes and loading data into that by using transformations and DTP. Identifying
the key figures and attributes.
Worked on queries using Selections, Structures, Calculated Key Figure, Restricted
Key Figure and Used Variables.
Maintaining Reconciliation's to verify the data in SAP R3 and SAP BW are same or
not after the data loads.
Data loading into SAP BW Info Objects, DSO and Info cubes.
Involved in creation of info set and multi provider.
Extensively worked in many Performance issue improvements in both loading and
Execution activities by maintaining aggregates, Indexes.
Designed and developed Process Chains for Master and Transaction data loads and
scheduled for periodic loads.
Created Meta chain and Process Chains.
Contact this candidate