Data System

SAP BI CONSULTANT

Vasu Gorla

Email: - acs13t@r.postjobfree.com Ph: +91-879*******

Experience Summary:

Having total 8.4 years of IT experience in SAP BW/BI Area.

Business Objects and Data Services:

Created dashboards by using Xcelsius, dashboard designer and design studio tool for high end data Visualizations.

Implemented webi Report for analysis purpose and Created Universe for R/3 and other data base models

Performed Data Extraction from different sources to HANA data base using the BODS interface Tool.

SAP HANA:

Well versed with creation and maintenance of the Attribute view, Analytical view and calculation views.

Worked with different types of joins Imported the data from Flat Files, ECC and Bex Snapshot solution.

Created a high level dash board in Lumira and published to Lumira server

Migration Upgrade and Archiving Activities:

Automated the Reports testing Functionality before and after BI System Upgrade comparisons with help of RSTT Tool

Data archiving process activities performed to save the system space.

Implemented year wise Data models to save the system space BI

Accelerator space and also for better reporting and loading performance through the customer exits.

Implemented flat file data sources to pass the delete image across the data models for deleted records.

BI Related ABAP, Integrated Portal and BIA:

Implemented dynamic code enable concept in transformation level as per the need.

Created and maintained planning books for the business requirement.

Implemented Generic Delta queue mechanism to improve the generic extractor data load performance and changed safety interval for various objects.

Self-transformation concept being applied to avoid the data refresh and save the data load time with regular transformations.

Applied customer exit variables at Report and DTP level to avoid Repeated Report level changes.

Housekeeping and Performance tuning:

Implemented the Info provider Dynamic Restriction concept for better Reporting performance.

Deleted unused objects and Data to save the space and deleted the system logs like DTP runtime buffer, DSO activation, error logs to improve load performance.

To Save the Daily data loads applied Regionalization concept to save the data load time.

Implemented generic setup table fill program to allow the multiple selection.

Maintained DSO secondary index for better lookup and save the load time.

Prepared reports to identify the long running reports, DTP, IPs and auctioned accordingly .And also prepared reports to analyze the for BIA and BI space .

Maintained semantic group filters, processing mode, SID Uncheck, Info package Skip to improve data load performance.

PSA and change Log deletion activities performed

Long running transport issues fixed by maintaining the entry at Table.

Tools:

Solution Manager, Mercury, Visual Composer, web application designer,

Report designer, Business Objects, Remedy, Xcelsius, Bex query Designer, BODS, and analyzer.

Academic Qualification:

MCA from KakaTiya University University

Career Path:

Oct 2015 to till date – working as BI Consultant for Teklink

Oct 2007 to Sep 2015 - Working as BI Consultant for TaTa Consultancy Service

April 2007 to Oct 2007 - Worked as BW Consultant for ASM Technologies.

Company : TCS

Client : Honeywell

Duration : Feb 2011 – Sep 2015

Resolved different priorities (Critical, High, Medium and Low) of remedy tickets with in the SLA By maintaining the proper work logs.

Handled the different issues occurred during the BI System Upgrade and Automated the pre and post updated process.

Worked with Information Broadcasting where we distribute BI information to different users in different formats and also in different schedules.

Pre archiving process design techniques applied for better reporting and data load process.

Production System cleanup activity performed for unused objects (DSO and CUBEs).

Performed the data reconciliation for missing/Not visible/ incorrect data records and auctioned accordingly

Imported the developed objects to quality and production system by maintaining the proper test evidence in Mercury tool.

Worked with Information Broadcasting where we distribute BI information to different users in different formats and also in different schedules.

Extensively worked on the Performance Tuning of the System.

Maintaining Reconciliation to verify the data in ECC 6 and SAP BI are same or not after the data loads.

Designed Dashboards using the Xcelsius Dashboard designing tool

Worked on Start Routine, End Routine, DTP, IP, Expert Routine, variables at DTP.

Used BW Statistics for various objects to keep track of the usage of the BW System and thereby increasing the Performance.

Integrated SAP BW queries developed using BEx with Web Application Designer (WAD) and converted BEx Reports into Web Reports.

Created Flexible Reports using Filters, Calculated and Restricted Key Figures, Exceptions, Variables and Conditions.

Designed the Dash boards using the Visual Composer tool.

For better reporting performance modified existing reports by having mandatory variables,

Suppress the subtotals, keeping most detailed objects in free char Area, user training to apply the conditions, exceptions in report output, RSRT properties

Replaced standard DSOs with write optimized

Company : TCS

Client : Bekaert

Duration : Oct 2009 – Jan 2011

Integrated SAP BW queries developed using BEx with Web Application Designer (WAD) and converted BEx Reports into Web Reports.

Used BW Statistics for various objects to keep track of the usage of the BW System and thereby increasing the Performance.

Created Flexible Reports using Filters, Calculated and Restricted Key Figures, Exceptions, Variables and Conditions.

Worked on Start Routine, End Routine customer exit variables, data source enhancements.

Worked with Information Broadcasting where we distribute BI information to different users in different formats and also in different schedules.

Involved in Monitoring and Handling tickets raised by the end user.

Resolved different priorities (Critical, High, Medium and Low) of remedy tickets with in the SLA By maintaining the proper work logs.

Maintain list of all the activities for all the tickets until it is closed down.

Extensively worked on the Performance Tuning of the System.

Involved in creating and maintaining Info Cubes, Operational Data store, PSA, Info Objects, Info Areas, Multiprovider, Info Sources, Data Sources, and Info Packages.

Worked on Open Hub Destination.

Modified existing queries as per the enhancement requests received from the end user and also provided Ad-Hoc Reports for their temporary use.

Performed the Full Repair loads for specific orders by filling the setup tables and Well versed with R/3 Transaction codes like VA03, MM03, XD03

Transported the modified objects to the Quality and production system by maintaining the proper test evidence By Using the Mercury Tool.

Worked on BEx Query Designer in designing queries using RKFs, CKFs, Formulae, filters, variables, and navigational attributes to facilitate flexible, detailed drill down data analysis to required level of information.

Educated the End users in using the BI Reports functionality efficiently

Implemented Customer Exit variables to meet the client requirement and enhanced the Standard data sources

Company : TCS

Client : ABN Amro

Duration : Oct 2007 – Oct 2009

Designed and developed Process Chains (RSPC) for Master data loads Transaction data loads and these Process chain are scheduled for periodic loads.

Query designing designing techniques for better Reporting performance.

Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables and Characteristics Value with Customer Exit etc.

Created several ODS objects which acts as data staging. Configured data sources in R/3 by using LO Cockpit (LBWE), Initialized the Set-up tables. Scheduled and Implemented delta mechanism for periodic loads.

Created, Scheduled and Monitored Info packages and load processes.

Uploaded master and transactional data from flat files and SAP R/3.

Involved in Unit testing and maintained the results in Unit test case document.

Involved in Transportation of the objects.

Improved back-end data loading performance and front-end query performance by maintaining Aggregates, Compression, Partition, and Indexing of Info Cubes.

Involved in creating and maintaining Info Cubes, Operational Data Store, Info Objects, Info Areas, Multiprovider, Info Sources, Data Sources, and Info Packages.

Company : Cap Gemini

Client : Essent

Duration : April 2007 to Oct 2007

In BI Installed Business Content Objects as and when required.

Installed necessary Business Content Data Source in R/3 as per the guide lines.

Extensively involved in creating a Generic Extractor

Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting using Bex query designer.

Collected the objects and transported to QA and after testing moved to Production.

Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info Sources, Info objects, Transfer rules, update rules, Extractors, Info Sources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Characteristics and Key figures, Business Content, Process Chains.

Designed and maintained technical specs and functional Specs for the developed queries and BI Data Models and R/3 objects.

Involved in changing the Existing data model of an Info Cube by adding new

Characteristics and Key figures.

Created navigational attributes to display the required attributes in generated reports and performed drill down operations on it.

Contact this candidate