Upgrade Post project
SK
Bangalore
available

Last update: 06.09.2022

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

Graduation: Bachelor of Engineering
Hourly-/Daily rates: show
Languages: English (Full Professional)

Keywords

Attachments

Santhosh Kumar P HANA-BW4HANA Consultant_Latest9.docx

Skills

  • SAP Certified (BW/4HANA) Analytics Consultant with 9 years of experience in developing and implementing native HANA (HANA 2.0), BW (on HANA), Business Intelligence, ABAP for BW, BODS, SDI, SDA and SLT solutions. I have worked on various SAP BW and HANA projects.
  • I have extensively worked on BW/4HANA Development project and HANA information’s models such as attribute views, analytical views and calculation views (both scripted and graphical) and HANA procedures to deliver complex reporting requirements.
  • I have worked as a HANA Consultant on HANA 2.0, java and UI5 based application.
  • I have worked on ABAP on HANA project and involved implementation of Business Integrity Screening (SAP BIS) solution.
SAP BW and BW/4HANA
  • Expertise in modelling of BW objects such as extractors, ADSO, Composite providers, Open ODS views, Transformations, Data Transfer Process and process chains
  • Worked on ODP based extractors and loaded data into ADSO’s
  • Good knowledge on new HANA Analysis process and completed POC for the same
  • Expertise in building data models based on mixed scenarios
  • Expertise in Bex query designer and extensively worked on columns, rows, restricted key figures, calculated key figures, variables, exceptions, and conditions
  • Expertise in migrating DSO’s, info cubes into HANA optimized objects
  • Involved in migration of existing BW data flows into BW on HANA based data flows using Composite providers, Calculation views/Analytical views and Advanced DSO’s
  • Expertise in Start Routine, Field Routine, Expert Routine and End Routine
  • Capable to write ABAP routines for standard BW/BI data source enhancements
  • Worked on Scheduling and Monitoring the daily and weekly process chains, Data loads (Full /Delta Load)
  • Expertise in performance tuning of BW objects and worked on BW data archiving techniques
  • Expertise in installing Business content and transporting objects into quality and production systems
  • ABAP programming knowledge in BW areas such as standard/generic extractors     enhancement using customer exits (CMOD) and ABAP routines in BW transformations
SAP HANA - Native HANA development experienced in XSA environment
  • Good Experience in HANA XSA environment and working on HANA implementation project on XSA environment
  • Worked on HANA 2.0/UI5 based product and parallelly working on BW on HANA project
  • Implemented two full life cycle implementation projects and one HANA support project as SAP HANA/BODS consultant which involves Requirement analysis, Development, Testing, Documentation, End user documentation, Data extraction from BODS, HANA Data modelling, Data loading, Reporting and Production Support
  • Good knowledge on HANA data provisioning techniques such as SLT, SDI, BODS and SDA
  • Expertise in development of multiple schemas and table definitions in HANA
  • Expertise in creation tables, views and other HANA artifacts using CDS files
  • Expertise in creating various Information Models like Attribute, Analytic and Calculated Views
  • Expertise in creation of HANA Procedures, decision tables and calculated columns
  • Worked on Currency conversion in HANA
  • Expertise in flat files loading in HANA
  • Having good understanding about HANA modelling best practices
  • Ability to design HANA data modelling objects
  • Worked on multiple designs for performance tuning of information models to achieve best query runtime
  • Worked on Graphical and Scripted calculation view
  • Good knowledge on SAP HANA procedures enhancements and ability to create HANA procedures
  • Worked on SLT end to end solution to extract data from R/3 system
  • Expertise in loading data from third party system into HANA system
  • S/4HANA
  • Good experience on S/4HANA ABAP CDS view creation, CDS table function, CDS tables and AMDP procedures.
  • Extensively worked on S4/HANA Embedded analytics project.
  • SAP SDI - Good experience in SDI data extraction of data from third party source systems
  • Good experience in creating remote data sources and replicated/loaded data into HANA
  • Good experience in DP agent configuration and excel adapters configurations
  • Good experience in loading data from virtual tables into HANA tables using SDI flowgraphs
  • Created flowgraphs with business logic for data transformation and used replication task to schedule the flowgraphs.
  • SAP BODS - Expertise in BODS scripts and developing end to end BODS data flow with error handling
  • Expertise in BODS jobs, dataflows, workflows and BODS scripts
  • Good knowledge in BODS local and central repository maintenance
  • SAP SLT - Trained & worked on two ends to end SLT projects as replication tool to HANA
  • Worked on SLT system configuration and setup to connect with HANA
  • Worked on replicating tables from R/3 system to HANA
  • 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.
  • 2 full-cycle HANA implementations – Project planning through post go-live support
  • 3 full-cycle BW implementations – Project planning through post go-live support
  • I have been successful with mentor role and completed BW training for a team

Project history

05/2018 - Present
SAP Analytics Consultant - SAP HANA and BW or BW4HANA
Confidential (Internet and Information Technology, >10.000 employees)
  • 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
02/2016 - 05/2018
SAP HANA LEAD CONSULTANT
Confidential (Internet and Information Technology, 1000-5000 employees)
  • 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
02/2014 - 12/2015
SAP HANA TECHNOLOGY CONSULTANT
Confidential (Internet and Information Technology, 50-250 employees)
  • 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
01/2012 - 02/2014
SAP BW DEVELOPER
Confidential (Internet and Information Technology, 10-50 employees)
  • 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

Local Availability

Only available in these countries: India
Profileimage by Anonymous profile, SAP BW/4HANA, BW on HANA and HANA Consultant SAP BW/4HANA, BW on HANA and HANA Consultant
Register