04/15/2024 updated

**** ******** ****
100 % available

Hana Senior Consultant, SAP BW Sr Consultant, SAP BW Consultant

Bangalore, USA
Worldwide
mca
Bangalore, USA
Worldwide
mca

Profile attachments

CV - kuppani kishor

Query PerformanceAdobe InDesignComponent-Based Software EngineeringSoftware ApplicationsUnit TestingDatabasesData ValidationData TransmissionsExtract Transform Load (ETL)Data ManagementData MiningData WarehousingEclipse (Software)LinxMicrosoft SQL ServersSAP ERPPerformance TuningSAP ABAPSAP ApplicationsSAP BISAP NetWeaver BISAP HANASAP R/3SQL DatabasesData StreamingTransaction DataRollupIntegration TestsBuild ProcessReporting Tools
in design, ABAP, ABAP programming, Build Process, Application components, Master Data, data extraction, data flows, Data Transfer, data validation, Data Warehouse, data base, Database, Eclipse, ETL, ETL tools, data loading, InfoTech, integration testing, Linx, Excel, SQL server, Performance Tuning, Query performance, Roll-up, SAP, SAP BI, SAP-BI, SAP ECC, SAP ECC 6.0, S4HANA, HANA, SAP S/4HANA, SAP HANA, 4HANA, SAP BW, BW, SAP R/3, SQL, Computer Applications, Reporting Tools, transaction data, Transactional Data, unit testing

Experience

Professional experience10+ years
Freelancer since2024

Languages

EnglishFluent

Project history

SAP-BI Team Member

KGISL
PROJECT # 2

Company : KGISL
Client : Sony
Task : Migration,Implementation & Supporting.
Role : SAP-BI Team Member
Environment : BW 7.5 on HANA
Period : Aug 2020to Dec2021.

Responsibilities:
* Involved in BW on HANA migrations.
* Worked on post migration and pre migration activities include synchronizing the system.
* Implemented accelerated approach of SLT continuing standard BW system as standalone.
* Application of HANA In-memory concepts for converting Cubes and DSOs to HANA optimized.
* Creating Composite Providers with HANA published Information models like Attribute Views,
Analytical Views and Calculation Views.
* Creating Hybrid Providers, Composite Providers ,Transient Providers and Virtual Providers,
Open ODS Views, Advanced DSOs depending on the requirement.
* Publishing Info cubes to HANA studio and analyzing the fact and dimension tables for direct
reporting purpose.
* Optimizing the Info cubes and DSOs.
* Creation of Attribute view, Analytical view, and Calculated view.
* Info Cube conversion to HANA Optimized Info cubes using RSMIGRHANADB transaction code
* NLS Archiving.
* Created Data sources using SLT from SAP ECC R/3
* Experienced in building SAP BW/4HANA and SAP BW solutions, including data modelling using
LSA/LSA++ methodologies, extract-transformation-load (ETL) processes, BW query creation.
* Interacted with the management and to identify the business requirements and developed the
reports according to the functional requirements.
* Installed Business Content for standard Info objects, ADSO, Composite providers etc.
* Discussed the solution for ETL tools like SLT, SDI, SDA, or some mixed scenario with Hana
modeling to import data in Hana.
* Responsible for planning cut-over activities for the go-live support for the development work.

SAP-BI Team Member

Mahindra Satyam
PROJECT # 8

Company : Mahindra Satyam,
Client : Ironwood.
Task : Supporting
Role : SAP-BI Team Member
Environment : BI 7.0
Period : Jan 2013to Dec 2013.

Responsibilities:

* Involved in monitoring and production support. Monitored Daily Chains, Weekly Chains, and
Monthly Chains.
* Handling tickets with different priority, and working on never missing the SLA.
* Participating in submitting the ticket status (Open/ Close) report.
* Reload the data requests from PSA in case of data load failure.
* Maintaining work history for all the tickets until it is closed down.
* Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction
loads.
* Monitoring and Managing of ODS object, Info Cubes and PSA requests.
* Created and scheduled the Error DTP to handle the error records in the Error Stack.
* Participating in load monitoring using RSPC, RSMO, SM37, and SM50.
* Participating in validated data consistency in reporting with data target against PSA after
loading them to data targets.
* Solving many data mismatch tickets by doing back fills. Monitoring and Managing of ODS object,
Info Cubes and PSA requests. Monitoring of data loading through process chains.
* Involved in designing the BEx reports according to the user requirements.
* Configured the use of filters, restricted key figure, calculated key figure, variables,
structures, conditions, exceptions, and drill-down functionality as per client's requirement.
Creating Process chains for both master data & Transaction data.
* Involved in Managing of Info Cubes, which involves Info Cube Content, Performance issues like
Line Item Dimension, Partitioning, Compression of Info Cube and Rolling up the data to the
Aggregates.
* Maintain Aggregates, Rollups, and Compression for improving query performance.

Hana Senior Consultant

KGISL

SAP-BI Team Member

KGISL
PROJECT # 3

Company : KGISL
Client : Sony
Task : Implementation & Supporting.
Role : SAP-BI Team Member
Environment : BI 7.3, BW 3.5
Period : May 2019 to July 2020.

Responsibilities:
* Involved in data load monitoring and Production Support.
* Involved in High-prioritized tickets regarding extractions, Performance issues and load
failures.
* Actively and regularly involved in load Monitoring of Daily, Weekly, and Monthly, Data loads
using Process chains.
* Involved in development of various Data targets and Info providers like DSO, Info cubes, Info
objects, Multiproviders& Info set.
* Involved in Creating and managing the ADSOs, Composite providers and open ODS views on BW
modeling in ECLIPSE.
* Involved in creating, Scheduling, Monitoring and resolving the Process chains failures like
Erroneous PSA records, TRFCs failure, DTP failure etc.
* Involved in Managing Info-cubes, which involves info cube content, performance issue like
indexes, compression of info cube and rolling up the data to the Aggregates.
* Involved in Creating and managing attribute views, calculation views and Analytic View.
* Involved in resolution of data load failures. Data load & job monitoring during testing.
Taking Proactive actions to correct them and stop its reoccurrence.

* Involved in data loading (Initial/full/delta/repair full), Scheduling and Monitoring.
* Worked on creation of workbook based on multiple queries and Broadcasting.
* Extensively Worked on LO Cockpit (LBWE) and performed necessary procedures like deleting setup
tables, filling up of setup tables and loaded data from ECC to BI system.
* Worked on the data reconciliation issue in BW and in different module of ECC likeSD, MM, FI
and CO-PA. Have good understanding of standard T-codes and tables of R/3 system which help in
analyzing the issue.

SAP BW Sr Consultant

Stridely Solutions

SAP-BI Team Member

Stridely solutions
PROJECT # 4

Company : Stridely solutions.
Client : Evoqua Water Technologies.
Task : Implementation & Supporting.
Role : SAP-BI Team Member
Environment : BI 7.3& BW4HANA
Period : July 2017 to Apr 2019.

Responsibilities:
* Involved in creating and maintaining Info Cubes, DSO, PSA, Info Objects, Info Areas,
Multiproviders, Data Sources, Transformation, Info Packages and DTP.
* Maintained Info Cube, Creation of Info Package and scheduling the data into the Data Targets.
* Extensively worked on SD, MM,FI, PM, PS, HR&COPA Modules.
* Worked on activating the Standard Business Content object like Info Cubes, ODS Objects, Info
Objects etc.
* Worked extensively on LO Cockpit Loaded the data from R/3 to BW and used Initialization with
Delta Update and Full Update methods.
* Data Extracting from the Source system using LO Cockpit and Generic Extractions for all the
logistics data.
* Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction
Loads.
* Involved in Creation of View, Info set Query and customized Data sources as per our client
Requirement.
* Extracting SQL server data into Sap BW and flat file data into BW system.
* Transporting the requests from Development to Quality and then to Production.
* Designed and created Process Chains for master and transaction data load.
* Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads
using Process Chains.
* Involved in writing ABAP Code as part of Enhancing standard Data Sources, Start&End Routine in
BW Transformation.
* Involved in front-end BI elements like Queries, Formulae, Variables, Calculated Key figures,
restricted key figures, Structures, Selection, Exceptions, and Conditions.

SAP BW Consultant

CLSS

SAP-BI Team Member

Client Linx software pvt ltd.
PROJECT # 5

Company : Client Linx software pvt ltd.
Client : Hatsun.
Task : Implementation
Role : SAP-BI Team Member
Environment : BI 7.4
Period : Sep 2016 to May 2017.

Responsibilities:
* Worked extensively on Data warehouse workbench and customized Info Objects, Info Cubes, DSOs,
Data Sources, DTPs, Transformations, and Multi Providers.
* Activated Standard data sources of application areas.
* Installation of standard BI content Info cube.
* Extensively worked on LO Cockpit and performing necessary procedures like setting up of Update
Mode, deleting set up tables, filling up of set up tables and loaded the data from SAP ECC to
SAP BI and used Initialization update and delta update.
* Created Custom Info Objects, DSO, DTPs and Info Cube - Sales data.
* Scheduled DTP for loading Transactional Data from PSA to Info Provider using process chains.
* Implemented and involved in performance tuning of Queries by maintaining Aggregates,
Compression, Partition and indexing of Info cubes.
* Involved in creation of reports using Query Designer such that by using Conditions,
Exceptions, Free Characteristics, Restricted key figures, calculated key figures, User entry
Input Variable and Formula variables
* Created Generic Data sources using Tables and Views for extracting Transaction Data
* Extensively worked on SD, Purchasing, FI and QM Modules.
* Created aggregates for the info cubes to access the data in an efficient and ordered level
* Thorough understanding of installation, configuration and customization of BI objects
including Info Cubes, ODS/DSO, Info Objects, Info Packages, Transformations, Process Chains,
ETL jobs, etc.
* Designed and developed process chains for master data loads and transaction data loads and
these Process chains are scheduled for periodic loads
* Involved in writing ABAP Code as part of Enhancing standard Data Sources

SAP-BI Team Member

TVS InfoTech Ltd
PROJECT # 6
Company : TVS InfoTech Ltd,
Client : Nelcast ltd.
Task : Implementation
Role : SAP-BI Team Member
Environment : BI 7.3
Period : Apr 2015 to May 2016.

Responsibilities:

* Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects,
Application components, PSA, DTP, Info package, transformation.
* Involved in creating Info Cubes, DSO's, Multiproviders, Info sets, Open Hub Destination.
* Involved in creating Aggregates, Partitioning, Indexes, Roll-up and Compression to improve the
Query performance.
* Involved in front-end BI elements like Queries, Formulae, Variables, Calculated Key figures,
restricted key figures, Structures, Selection, Exceptions, and Conditions.
* Hands on experience in BW reporting using BEx Query designer, BEx Analyzer and creating
Queries.
* Resolved month end and quarter end issues.
* Involved in creating Variables like Characteristic, Text, Formula, using Processing Types.
* Worked on Generic and LO extractors for SD, MM, PP, QMand FI/CO Module.
* Worked on Data Source Enhancement for SD Module.
* Designed and developed process chains for master data loads and transaction data load.
* Uploading master data and transactional data both from flat files and SAP R/3.
* Creation of Process Chains, for upload of Transaction Data and Master Data.
* Monitoring and Error handling in PSA like modifying the error records and reloading the data.
* Installed objects from business content like Info Cubes, Multi Provider, DSO, Queries.
* Involved in transportation objects from development to quality and production.
* Checking data consistency, aggregates and hierarchies through RSRV.
* Created the Data Source and Replicate the Data Source
* Involved in creating Generic Extractors using Database tables and Views

SAP BI Consultant

TVS InfoTech ltd

SAP-BI Team Member

TVS InfoTech Ltd
PROJECT # 7

Company : TVS InfoTech Ltd,
Client : Hexpol compounding.
Task : Supporting
Role : SAP-BI Team Member
Environment : BI 7.3
Period : Jan 2014 to Mar 2015.


Responsibilities:

* Responsible for creating, scheduling and monitoring process chains.
* Resolving Data load issues.
* Build Process chains for Info cubes, ODS and Master Data loads.
* Involved in full life cycle implementation of BI project and provided key services such as
data Modeling, data Extraction and Reporting, etc.
* Created Process Chains to automate the data load and data target administration and monitored
the processes.
* Extracting and scheduling the Bex queries to the end user directories.
* Involved in creating Aggregates, Partitioning, Indexes, Roll-up and Compression to improve the
Query performance.
* Involved in front-end BI elements like Queries, Formulae, Variables, Calculated Key figures,
restricted key figures, Structures, Selection, Exceptions, and Conditions.
* Hands on experience in BW reporting using BEx Query designer, BEx Analyzer and creating
Queries.
* Involved in creating Variables like Characteristic, Text, Formula, using Processing Types.
* Worked on Generic and LO extractors for SD, MM, HR, PP, PMand FI/CO Module.
* Worked on Data Source Enhancement for SD Module.
* Monitoring and Error handling in PSA like modifying the error records and reloading the data.
* Involved in transport activities and involved in checking the system after the transport
* Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction
Loads

SAP BI Consultant

Mahindra Satyam

SAP BI Associate Consultant

HCL

SAP-BI Team Member

HCL Technologies
Project #9
Company : HCL Technologies,
Client :BPR
Task : Implementation
Role : SAP-BI Team Member
Environment : BI 7.0 & BW 3.5
Period : Sep 2011 to May 2012.

Responsibilities:
* Configured Data sources in R/3 by using LO Cockpit (LBWE) deleted and initialized setup
tables. Scheduled and implemented delta mechanism for periodic loads.
* Involved in creating and maintaining Info Cubes, ODS Objects, PSA, Info Objects, Info Areas,
Multiprovider, Info Sources, Data sources, and Info Packages.
* Uploaded master and transactional data from flat files, SAP BI and SAP R/3.
* Worked on Generic and LO extractors for SD, MM, HRand FI/CO Module.
* Installation of standard BI content Info cube and DSO for as per client Requirement.
* Creation of Transformation and DTP for Transferring the Data to the Targets in the BI 7.0
environment.
* Involved in creating User Exists, Start Routine and End routine.
* Worked in transporting the objects through the landscape and involved in unit testing in
Development box and integration testing in Production box.
* Maintained BW Statistics for performance tuning of Queries. Solved performance related issues
by maintaining Aggregates, Compression, Partition and indexes of Info cubes.
* Extensively worked on process chains for sequential background scheduling of Master Data,
Transactional data and several subsequent processes.
* Reload the data requests from PSA in case of data load failure.
* Monitoring data loads of daily, weekly and monthly process chains.
* Resolving the issues and reporting it to the user as per the severity.
* Defined queries and structures using Restricted Key Figures, Calculated Key Figures,
Structures, Exceptions, Conditions, Variable Offsets, RRI, Free characteristics and Filters to
fulfil the reporting needs.
* Involved in extracting MM and Sales and Distribution data from R/3 using LO-Cockpit and
enhanced the Data sources as per the user requirement.
* Transported developed objects from development box to quality box.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in