04/15/2024 updated


100 % available
Hana Senior Consultant, SAP BW Sr Consultant, SAP BW Consultant
Bangalore, USA
Worldwide
mcaQuery PerformanceAdobe InDesignComponent-Based Software EngineeringSoftware ApplicationsUnit TestingDatabasesData ValidationData TransmissionsExtract Transform Load (ETL)Data ManagementData MiningData WarehousingEclipse (Software)LinxMicrosoft SQL Servers
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
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.
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.
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.
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.