SAP BW/4HANA, BW on HANA and HANA Consultant

• Worked data replication from R/3 system to HANA system using SLT replication.
• Worked SLT system configuration and setup.
• Worked on loading data/replicating data from R/3 system to HANA and created calculation views on top of these tables
• Replicated all tables related Financial P&L like BKPF, BSEG etc.
• Worked on basic and advanced replication settings based on field edit/delete and routines for event-based calculations.
• Created BW4HANA objects like aDSO’ s, composite Providers for reporting
• Created native HANA calculation view by consuming BW objects.
• Implemented complex business logic using HANA table function
• Created data model to support historic master data with time dependency.
• Worked on HANA sequence key generation
• Created process chains for daily and weekly data loads
• Performance optimization of HANA views using Plan viz output.
• Integration of BW and HANA models for reporting
• Performed the BW activities for data extraction
• Report creation using BW4HANA query designer

• Responsible to gather requirements from product owner and business user and create functional specification documents
• Responsible to create HANA DB and Java applications and

deploy into XSA system

• Created database tables, views, HANA procedures,

synonyms etc

• Worked data replication from R/3 system to HANA system using SLT replication.
• Worked SLT system configuration and setup.
• Worked on loading data/replicating data from R/3 system to HANA and created calculation views on top of these tables
• Replicated all tables related Financial P&L like BKPF, BSEG etc.
• Worked on basic and advanced replication settings based on field edit/delete and routines for event-based calculations.
• Created SDI flowgraphs to load data into HANA tables
• Worked on DP agent configurations for excel adapters and third-party source systems
• Responsible for performance tuning of HANA procedures/HANA Views
• Developed HANA fuzzy search functionality for this product and that’s the main functionality of the application
• Involved in creation of complex dynamic stored procedures
• Responsible to develop Java services to read data from
• HANA layer and pass to UI layer
• Implemented new instance-based authorization concept called Data Control Language (DCL) for application
• Worked on SAML based authorization to provide application access to users
• Worked with business user to complete UAT and moved HANA objects into production system on successful completion of UAT
• Worked on HANA objects transports using Delivery units

• Responsible for defect analysis and solution proposal
• Involved in daily scrum meeting to discuss about open defects
• Responsible to create defect analysis document, UAT document and unit test results
• Responsible to review (Peer review) the defects which were resolved by team members
• Load data from third party system data into HANA using BODS jobs
• Worked on BODS dataflows, workflows, BODS scripts to load HANA tables
• Worked on table/view enhancements and procedure enhancements
• Worked on the creation of HANA procedures which will be scheduled from BODS job
• Worked on BODS framework functions and will be used in other projects which will reduce development duration
• Worked on XSJS services debugging process to analyse and resolve issues in application
• Worked with team on performance tuning of application runtime/response time
• Worked with team to provide different design approaches to meet user’s requirement
• Responsible to load flat files using BODS into HANA
• Worked on BODS solution to extract data from COBOL copybook and DB2 system and load into HANA
• Worked on HANA wrapper procedure which was used to call other procedures to load data into HANA tables
• Worked on HANA information models like attribute view, analytical View and calculation view
• Worked on different approaches to improve the performance of information models
• Worked on Calculation view with SQL script and calculation view with star join to improve performance
• Worked exception handling in procedures to recover table data if any error happened while inserting into tables
• Involved in UAT process and resolved issues which were raised in UAT

• Responsible for requirements gathering and create functional and technical specifications document
• Involved in delivering four Bex reports to customers
• Involved in data flow modelling for billing and Shipping reports
• Created complex Transformation start and end routines to derive the calculations based on user requirement
• Involved in sales order item data source enhancement and written ABAP logic in CMOD customer exits
• Created info objects, data sources, DSO’s, Info cubes, transformations and DTP’s
• Involved in creation of Process chains for four Bex reports
• Responsible for daily process chain monitoring and fixing data load failures
• Worked on production Change Request (CR) based on the new enhanced requirements from the customer
• Bex report enhancements as per end user need
• Ticket closing (Incidents raised by Business Users) and CR managements
• Responsible to transport new enhancement objects to the quality system
• Responsible for creating and rescheduling process chains as per requirement
• Created email alerts for daily loads in production systems
• Worked on performance tuning of info cube and DSO and applied archiving solutions for COPA DSO
• Applied Hash solution in R/3 system to recover corrupted delta queue records from LBWQ
• Effectively worked on many solutions to provide better support to customer
• Came up with many proposals and best recommendation to improve system performance
• Responsible for cut-over activities during deployment of new data flows and objects into production system