SAP BI/BW
Resume:
Vivekananda. K
*****.*********@*****.***
PROFESSIONAL SUMMARY
* ***** ** ********** ** SAP as BI/BW Consultant Involved in SAP Support Maintenance
Projects. Able to demonstrate high attitude, dedication towards any project working
along with Senior Teams and Project Leads in a pro-active disciplined manner.
EDUCATION
Bachelor of Technology, B.Tech -- JNT University.
PROFESSIONAL SAP EXPERIENCE
Working as SAP BI Consultant in CGI since May'10 to till date.
AREA OF EXPERTISE
Extraction Tools : SAP BI 7.0, BW 3.5.
Reporting Tools : WEBI, Crystal reports, XCelsius, Live Office, and QAAWS.
Packages : BO XI R3,4.0
BO Reporting: Creation of Universe, OLAP Universe, and XCelsius reports, Desktop
Intelligence, Webi reports, Dashboards.
PROJECTS Profile
Project 1:
Client : SSC UK
Duration : July' 14 - till date
Designation : SAP BI Consultant.
Location : Bangalore
Role and Responsibilities:
Involved in support activities for multiple customers at a time.
Daily monitoring data loads and sending status reports to customer before 8AM CET and
Making all the BI reports ready before start of business hours.
Handled data load issues during monitoring and solved them while respecting SLA's.
Involved in resolving technical incidents without breaching SLA's
Involved in system patching activities and taken care of delta loads before and after
patching.
Worked as 24*7 supports to different customers in SSC UK and given strong support to
the
Project and customer.
Actively involved in monthly activities for BWW customer and worked 24*7 with
different
Teams to resolve data load issues during month ends.
Prepared documentations on all issues from time to time and made it available for all
team
Members by parking it in BI work space.
Involved in Transferring & Replicating the Transfer Structure, Applying Transfer
Rules, assigning
Data Source to Info Source.
Installing the relevant Cubes & Info Sources in Business Content, Creating Data
Targets,
Maintaining Update Rules, Creating Info package, uploading the data.
Monitoring the errors and handling them manually when needed.
Worked extensively on LO COCK-PIT extractors for Loading Data into the Standard and
custom developed Cubes
Worked extensively on BEx Query Designer, BEx Analyzer, and Web application
Designer. Used Navigational attributes, Filters, Structures, Exceptions, Conditions,
And Cell Definition.
Involved in extracting Data Source for SD, Billing and General Ledger using the
following
Data Sources 2LIS_11_VAITM, 2LIS_13_VDITM and 0FI_GL_4.
Activating the Business Content Data Sources and Info Cube for MM Report requirement.
Deletion of Setup Tables and filling up the same.
Created a custom cube for the market analysis as per the client's requirement.
Used aggregates on various cubes for the performance tuning according to the
technical
Specifications.
Used BEX Analyzer for Query Designing using Filters, Exceptions and conditions.
Done the base work for the performance tuning which includes fact table partitioning,
PSA partitioning, buffering number ranges etc.,
Scheduled the data packet size in the SAP R/3 according the business requirements.
As a part of Info cube administration has monitored the Roll UP's and Compressions
While loading the data in the info cube.
Applied SAP technical notes to solve the bugs in the system and have good track
record
in solving those kind of issues
Provided the client with alternative solutions and applied a performance technique
which
Includes both loading and reporting to stabilize the system.
Project 2:
Client : Plexxus
Duration : Jan' 14 - June'14
Role : SAP BI Consultant
Location : Bangalore
Role and Responsibilities:
Extensively worked in Business Information Warehouse Info Cubes, ODS Objects,
Info sources, Info objects, Transfer rules, and so on
Extraction: Experience in extracting data from SAP R/3 using LIS, LO Cockpit, FI-SL,
and generic extractors. Also from new dimensional products SAP PP, QM, SAP CRM, SAP
SRM. OLTP Extraction (Transaction Data, Master Data Attributes, Text, Hierarchies).
Working in changing the Existing data model of an Info cube by adding
New Characteristics and Key figures.
Worked in creation of info source, info objects maintenance, transformations.
Good understanding of Data Modeling using BW Extended Star Schema.
Worked in creation of Basic cube, Remote cube, Transaction cubes and DSO.
Involved in managing of Info cube, which involves Info cube content, performance
issues
Like Indices, Statistics, compression of Info cube and rolling up the data to the
aggregates.
Worked in Business Explorer Analyzer for Reporting and Web Application Designer.
Worked in Generic Extraction of Table, Views and function Module
Involved in submitting the Ticket Status (Open/Close) report.
Maintain Work History for all the tickets until it is closed down.
Performance tuning by maintaining Aggregates, Compression, Partition, indexing of
info cubes and use of statistics for the same.
Interacted with Clients to get the inputs from the user to close the tickets.
Involved in performing Production Support activities like Ticket Analysis report,
Resource Utilization Report, Time sheet maintenance of the support team.
Involved in maintaining lot of documentation for all the Support Activities.
Managed and monitored several data loadings, captured the errors and
corrected the bugs and applied several OSS notes for the errors encountered
While loading the data.
Worked on load monitoring on daily, weekly, and monthly data loads using process
chains.
Involved in ticket handling and maintaining the work history for all the tickets
until it was closed
down
Monitoring of InfoPackages and analyzing the data loads.
Analyzed the errors in the data loads and reported to the corresponding resolution
groups.
Involved in data validation checking and maintained the Reconciliation's.
Roll up data from infocubes to aggregates, edit and maintain the aggregates.
Re-initialization of business area in case of inconsistency in data targets.
Good Knowledge in Business Content objects and creation of multi providers and info
set.
Expertise in Performance Tuning Concepts like Compression, Aggregates, Partitioning,
Indices And Line item Dimension.
Experience in Building and enhancing BI objects that include Info Objects, Data
Sources,
Transformations, DTP, DSO, Info Cubes, Multi-providers, and Info set and Open Hub.
As part of Quality management standards to deliver the objects in quality performed
Unit testing and recorded the test results in unit test cases documents in Quality
Center
Tool Extensively worked on ETL from Customer generated application specific
Generic extractors LIS, LO, CO-PA and SAP BW/BI 7.0 content.
Worked on BEx Reports providing insight of Business Intelligence for Business
Analyst for Decision making using Formulas, Selections, Structures, Calculated Key
Figure, Restricted Key Figure, Variables with User Entry/Default Value, Replacement
Path and Customer Exit.
Project 3:
Client : BELL Canada/ EDF Project
Duration : Sep' 12 - Jan '14
Designation : SAP BI Consultant.
Location : Bangalore
Role and Responsibilities:
Created necessary documents for the project during kick off and made it available for
the
New comers.
Maintained consistence in time booking in three different tools at a time like Gama
Web for
Customer, TMS for Logica and LPS for internal purpose.
Worked on reporting extensively for resolving the customer issues and have solved 80
tickets
in 3 months which includes Incident management, Change management
Capable of handling errors while extracting from SAP R/3 and loading the data into
Data Targets.
Worked and have excellent experience on standard and customer defined LO extractions
&
Installed relevant BW business content.
Created transformations and used DTP's to update the data into their respective info
providers
Installed the technical content in BI and scheduled the process chains to fill the
same
Used write optimized DSO to stage large amount of data and also used for reporting
purpose
Loaded master and transactional data from SAP R/3 into BW and worked extensively on
Administration workbench and modeled according to our client requirement.
Provided support to the colleagues in solving number of problems related to both
loading
as well as reporting issues
Handled Data Loading (Full /Delta Up-Load) to Info cubes, ODS objects.
Involved in BI object transports and have handled successfully till production
Done ODS reporting to give details of delivery items and schedule line items.
Project 4:
Client : AIRBUS
Duration : Jan' 11 - June '11
Designation : SAP BI Consultant.
Location : Bangalore
Role and Responsibilities:
Developed Master Data Info Objects, DSO, Info cubes, Multi Provider, Info Sets
In Procurement application and different areas like Spend analysis, Rejection rate
and Schedule
Adherence.
Involved in writing Field routine, Start routine, End routine to populate data as per
business rules.
Created Separate transport requests for different applications and collected
developments.
Involved in loading data to various data targets, reconciliation of data in source
and target and
Unit testing activities.
Worked extensively on standard and custom defined LO extractors. Installed relevant
SAP business Content.
Used LO structures for extracting sales order, delivery information. Logistics
Cockpit
Configuration, Customization and enhancing Extract Structures.
Data Source enhancements, generic extractors, User Exits and customized delta built
up
For the data sources, V3 Updates, controlled by pull/push principle from OLAP system.
Created Transformations and applying routines for restricting and transforming data.
Involved with PSA in monitoring data transfer from source system into BW.
Involved in performing unit testing in development server and transporting to Quality
server.
Performance tuning using Aggregates, Statistics, Indexes and Compression.
Extensive experience in data design, data modelling, extended star schema, setting
customized
Info Cubes, SAP BI delta load, Info package creation,
Involved in creation of reports using Query Designer. Created Free Characteristics,
Restricted Key figures, Calculated key figures, Conditions and Filters.
Resolve and implement BI Query changes (Day to Day) and collected in the change
requests.
Installing Business content workbooks Order quantities - management.
Maintained the work books for order quantity wise.
Involved in the creating the reusable objects, such as variables, global structures.
Involved in the creating the New Restricted key figures & New calculated key figures.
Involved in the designing the web applications.
Designing and maintained the print version, PDF formatted web templates.
Installation of Business Content Data Sources
Migration of 3.x Data Sources to 7.0 Data Sources
Involved in developing of Unit Test scripts, System Test scripts and Integration
Testing.
Personal Details:-
DOB :- 16/09/1985
Languages Known:- English, Telugu, Hindi
Nationality :- Indian
[pic]
Contact this candidate