SAP BW4HANA Consultant

Gathering customer requirements for new enhancement requests (Changes to existing report, new report build). Performing due diligence and impact analysis of existing data flow, and report model. Identifying risks and dependencies and capturing them in the solution documentation.
Preparing and executing the test cases with detailed test steps for Unit testing, UAT, and performance testing. Attaching evidence to Change request for a smooth release cycle.
Assisting the Basis team in SAP note implementation for smooth execution.
Daily Standup calls with Scrum Lead on the task assigned, discussion on the progress and dependencies in resolving tickets.
Job Monitoring in Production and analyzing and fixing the failure for a smooth business run
Working on a CDS-based extractor to fetch data in the SAP BW4H reporting tool and building BEX Query for the business team for operational and ad-hoc reporting needs.

Proposed blueprint plan for migration to BW4HANA 2021 from BWonHANA 7.5.
Approx ~340 Bex Analyzer report conversion to SAP Analysis for office report. Used RPA automation using UI Path.
System Technical analysis and identifying scope for object conversion to SAP BW4HANA compatible objects. Preparing solution proposal documents of incompatible objects to mitigate business risk and identifying alternatives for incompatible objects.
Migration of existing CMOD to BADI for a smooth transition for existing variable functionality.
Execution of SAP BW4HANA conversion tool to convert classical objects to BW4HANA-compatible objects.
Troubleshooting the scope conversion failure and identifying the root cause. Checking of available SAP Notes on a periodic basis and doing impact assessments.
Raising SAP incidents for the bug identified in the scope conversion tool and coordinating with the SAP team to resolve the incident.
Participated in BI Monthly calls with Customers on milestones achieved, conversion issues, fix, etc.
Created ABAP CDS View to expose financial data for Lumira Dashboard.
Knowledge of S/4HANA Analytics like building and extending CDS Views, Creating Query Views , or building KPIs.
Hypercare support for monthly and quarterly closure of IRDA reports.

• Extensively worked on administrative workbench for defining Info-Objects, Info-Cubes, Info-Sources, ODS/DSOs, ADSOs, Composite Providers, Multi-Providers, and Info-Sets, and Open ODS views.
• Built Business Warehouse components like Transfer Structures, Transformations, DTPs, Info-Packages, Process Chains, and Authorizations.
• Good knowledge of SAP BI/BW implementation with in-depth technical skills in various SAP-R/3 implementations, upgrades, and post-implementation support in LO Cockpit extractions and SAP ISU.
• Responsible for working with various phases of the projects such as Requirement gathering, Blue Printing, Configuration, Testing, Training, Documentation, and Go-live support.
• Worked on Extraction of data from SAP source systems using Standard Extraction, Generic Extraction, & Excel, and Third Party as well.
• Having experience in implementing LSA & LSA++.
• Having experience in migrating from SAP BW powered by Hana to SAP BW4HANA using Shell/In-Place conversion.
• Having experience in Data archiving using SAP NLS (Near Line Storage).
• Having experience in SAP Analysis for Microsoft Office
• Proficient in enabling, enhancing, delivering, and activating standard Business Content, performing data load management, Scheduling the Process Chains, background scheduling, event triggers and event chains.
• Good Knowledge of SAP HANA Modeler HANA Studio, Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytical Privileges, Procedures, SQL Script.
• Hands on experience in creating ABAP CDS views and Extracting data from SAP ECC to BW using SAP ODS Views.
• Experience in SAP HANA Data provisioning using SAP Landscape Transformation (SLT) and SAP Data Services, Flat File Upload.
• Extraction of Data using Data Provisioning method called SLT into SAP HANA.
• Extensively worked on Upgrade & Migration from SAP BW objects to SAP BW on HANA system.
• Good knowledge of data models such as Extended Star Schema and Star Schema.
• Used Flat files and other legacy data base systems to load data into BW system using Flat file interface or UD connect.
• Performed performance tuning by creating Compression, Indexes and Partitioning within the Info-cubes to improve the query performance.
• Upgrade experience in SAP BW 3.5 to BI 7.x and knowledge of migrating data sources from BW 3.5 to BI 7.x and maintaining Transformations and DTPs.
• Worked on Enhancements of data sources using Customer Exits.
• Developed ABAP codes at Transformation level (Start, End and Expert Routines).
• Expert in Report generation extensively worked on Bex Analyzer, Query Designer, and Ad-hoc queries and conducted training on Bex usage for business users and new features to end users.
• Expert in SAP Analysis for Microsoft Office exploring business data and making intelligent decisions with the help of data insight.
• Communicated effectively with team members, developers, clients, and end users in a diverse matrix environment.

SAP Data Services including CI-DS Skills:

• Hands-on experience in Data migration from SAP system to Non-SAP System or vice-versa
• Created Batch jobs for migrating Data from ECC to MS SQL Server 2008 for building a Data Lake for Client.
• Managing Local and Central repositories with updated job versions. Promotion of batch jobs to Quality and Production system.
• Restart of BODS Services, SDI agent
• Gathering requirements for Business and BRDS preparation, High-level and low-level technical documentation. ST, SIT & UAT plan preparation. Follow up with business on requirement clarification via Weekly Workshop.
• Exposing data from SAP ECC for 2LIS Purchase, Sales, and Billing module Extractors to SAP HANA/ MS SQL Server DB. Created DB procedure to load data from staging table in SQL Server to Reporting Data mart Tables further consumed in Power BI.
• Creation of SAP BODS job for loading data using ODP framework and loading to MS SQL server 2008.
• Optimizing Data flow using ABAP workflow to push down the operation in ECC to reduce job runtime.
• Creation or setup of a new data store and importing the table from ECC/BW and building Job workflow.
• Hands-on Experience in Lightweight CI DS tool to load data to IBP.
• Experience in scheduling the task to run on a daily, ad-hoc basis.

Achievements


 

• Received UKLINK Programme Recognition Award from Client.
• Received ENU Excellence Award.
• SAP HANA 2.0 Certified.
• SAP BW/4HANA 2.0 Certified.
• Received DXC Champ award (Sept 2023).
• Received DXC recognition award.

Project Details
Project Name 10Programmers IO SAP BW ConsultantTeam Size2
Start DateAug-2024End DateTill date
OrganizationProgrammer IO
RoleSAP BW4HANA Lead
ResponsibilitiesGathering customer requirements for new enhancement requests (Changes to existing report, new report build). Performing due diligence and impact analysis of existing data flow, and report model. Identifying risks and dependencies and capturing them in the solution documentation.
Preparing and executing the test cases with detailed test steps for Unit testing, UAT, and performance testing. Attaching evidence to Change request for a smooth release cycle.
Assisting the Basis team in SAP note implementation for smooth execution.
Daily Standup calls with Scrum Lead on the task assigned, discussion on the progress and dependencies in resolving tickets.
Job Monitoring in Production and analyzing and fixing the failure for a smooth business run
Working on a CDS-based extractor to fetch data in the SAP BW4H reporting tool and building BEX Query for the business team for operational and ad-hoc reporting needs.
    
TechnologiesSAP BW4HANA, SAP S4HANA, JIRA Tool




Project Name 9Owens-Illinois AccountTeam Size4
Start DateJan – 2024End DateSep-2024
OrganizationDXC Technology
RoleSenior BW consultant
ResponsibilitiesMonitoring of Process chain for 4 different regions (NA, LA, EU, and AP) and correcting the ad hoc failure. Supporting the BW landscape to run error-free. Creating documentation of existing data flow and model for future reference.
Resolution of incident and service requests within SLA. Assisting users via team call on issues or guidance, to gather additional information on the issue, etc.
Gathering customer requirements for new enhancement requests (Changes to existing report, new report build). Performing due diligence and impact analysis of existing data flow, and report model. Identifying risks and dependencies and capturing in the solution documentation.
Preparing and executing the test cases with detailed test steps for Unit testing, UAT, and performance testing. Attaching evidence to Change request for a smooth release cycle.
Assisting the Basis team in SAP note implementation for smooth execution.
Analyzing the EWA report to identify the recurring issue or potential system blocker.
Weekly call with customers regarding SLA Metrics, service improvement, Incidents, and Enhancement requests.
    
TechnologiesSAP ECC, SAP BW 7.5 on DB6, SAP Bex analyzer, SAP NetWeaver Portal

Project Name 8Life Insurance Corporation of India – BW4H MigrationTeam Size4
Start DateDec – 2022End DateDec – 2023
OrganizationDXC Technology
RoleSAP BW4HANA Conversion Lead
ResponsibilitiesProposed blueprint plan for migration to BW4HANA 2021 from BWonHANA 7.5.
Approx ~340 Bex Analyzer report conversion to SAP Analysis for office report. Used RPA automation using UI Path.
System Technical analysis and identifying scope for object conversion to SAP BW4HANA compatible objects. Preparing solution proposal documents of incompatible objects to mitigate business risk and identifying alternatives for incompatible objects.
Migration of existing CMOD to BADI for a smooth transition for existing variable functionality.
Execution of SAP BW4HANA conversion tool to convert classical objects to BW4HANA-compatible objects.
Troubleshooting the scope conversion failure and identifying the root cause. Checking of available SAP Notes on a periodic basis and doing impact assessments.
Raising SAP incidents for the bug identified in the scope conversion tool and coordinating with the SAP team to resolve the incident.
Participated in BI Monthly calls with Customers on milestones achieved, conversion issues, fix, etc.
Created ABAP CDS View to expose financial data for Lumira Dashboard.
Knowledge of S/4HANA Analytics like building and extending CDS Views, Creating Query Views , or building KPIs.
Hypercare support for monthly and quarterly closure of IRDA reports.     
TechnologiesSAP S4HANA, SAP BW/4HANA 2021, SAP BW 7.5 on HANA, SAP Analysis for Office

Project Name 8Novartis Pharma AG (Cognizant) – BW4HANA ConversionTeam Size12
Start DateDec – 2021End DateDec - 2022
OrganizationCognizant Ltd.
RoleSAP BW4HANA Consultant
ResponsibilitiesHaving experience in migrating from SAP BW powered by Hana to SAP BW4HANA using in-place and Shell conversion.
Worked End-to-End Implementation i.e., Project Planning, Business Blueprint, Realization, UAT, Go-Live Production, and Post go-live.
Having experience in implementing SAP BW4HANA specific modeling like Composite Providers, ADSO and exposing BW objects in HANA Views, Operational Data Provisioning, LSA++, etc.
System Technical analysis and identifying scope for object conversion to SAP BW4HANA compatible objects. Preparing solution proposal documents of incompatible objects to mitigate business risk and identifying alternatives for incompatible objects.
Preparing test plans for pre and post-conversion for Internal testing and UAT test.
Execution of SAP BW4HANA conversion tool to convert classical objects to BW4HANA-compatible objects.
Troubleshooting the scope conversion failure and identifying the root cause. Checking available SAP Notes periodically and doing impact assessment.
Raising SAP incidents for the bug identified in the scope conversion tool and coordinating with the SAP team to resolve the incident.
Sharing Weekly status updates on Object Conversion to Business and higher management.
Created HANA objects (CV) and Consumed in Composite provider for reporting.
End-to-end data load testing to converted objects and check the correctness of data in Quality.
Provided hyper care support in Production related to converted objects. Identified the root cause and took corrective steps to resolve the incident.