RAGHAVENDRA B SHETTY
BANGALORE,Karnataka
Summary
SAP Analytics Lead Consultant with Over 11+ Years of SAP BW, BW4HANA experience emphasizing on Data Warehousing skills - Data Modeling, Extraction and Reporting and predominantly worked on Implementation and Support engagements.
Excellent Skills in Project Management and Data Analysis & expertise with working on Data Warehouse Workbench – Data sources, DSOs, Advanced DSOs, Composite Providers, Info Cubes, Info Objects, Transformations, Calculation Views.
Overview
11
11
years of professional experience
Work History
Analytics Lead Consultant
DormaKaba
07.2018 - 07.2024
- Involved in planning and defining stages of Project
- Gather information from the core team of DormaKaba and create Technical Documents
- Worked on Service Now based ticketing system to solve issues related to multiple and critical Reports
- Created Data Models from scratch and helped the Team in defining Data Modeling Landscapes and creating Naming Conventions for Dormakaba Objects for Global Users
- Involved in Process Chain Monitoring to check Daily/Weekly loads of critical Data
- Worked on designing Roles for Global Users
- Implemented Data Transfer from and to BW systems from multiple Non-BW Systems like Salesforce/ServiceMax
SAP BW Consultant
Tate & Lyle
05.2017 - 06.2018
- Created Data Model for Data Extraction from SAP BW to Salesforce Systems
- Worked with Business Users in gathering Requirements, creating Technical Specification Documents
- Worked with Business Users regularly in understanding the challenges and provided Solutions based on the inputs received
SAP BW Consultant
Stanley Black and Decker
01.2016 - 04.2017
- Onshore Ticket monitoring & workorder Creation for Developments
- An analyzer program finds out warnings in the ABAP Codes used that need to be corrected before migrating to HANA
- Made changes to the code used and corrected code that might cause issues after migration
- Tested the code change and the impact on the data
- Involved in running Process Chains through BW and Autosys and testing issues with the loads
- Tested for data consistency issues by running various loads in both BW and HANA Systems
- Worked on UAT Data Providers Analysis
- Worked on BW& BW on HANA Process chains performance Comparison of testing
- Created documentation of all the activities related to migration, operation regarding testing
SAP BW Consultant
Vertellus
01.2014 - 12.2016
- Supported the client with BW Production system monitoring and issue resolution
- Added fields to pivot tables with calculations and filters for existing workbook report
- Involved in the creation of workbook reports using the BEx analyzer in which pivot tables and Dashboards are built
- Created process chains for open orders and actual and forecast data for the user to run on demand basis to see new updates
- Monitored meta chains and process chains during the daily load run and validated the data in the reports broadcasting
- Fixed the pre-calculation server issues during the broadcasting of report via portal
- Developed direct update DSO’s to load data using APD’s
- Developed APD’s for loading data from flat file to direct update DSO using routines
- Developed standard DSO’s and Cubes with transfer rules according to logic
- Created process chains to load data to APD and other data targets
- Developed Generic Data Source based on table
- Creation of Master Data Process chains for Attributes & Text
- Involved in the selective deletion and reloading of data to inventory cubes
- Worked on the APO system and modified existing Process Chains and created new Process Chains as per the Request
SAP BW Consultant
GE Aviation
08.2015 - 12.2015
- Created Standard and Custom Reports as per Client requirement
- Integrated PPM with BW
- Extracted data from Solman system to BW to fetch PPM data
- Installed BI content and created Custom Objects for Data Extraction
- Developed standard DSO’s and Cubes with transfer rules according to logic
- Developed Generic Data Source based on Table and View
- Created Process Chains to automate the daily loads for Master and Transactional Data
- Created BEx Queries and created Workbooks with Pivot Tables
- Monitored Process chains during the daily load run and validated the data in the BEx reports
Education
Bachelor’s - Computer Science and Engineering
Visvesvaraya Technological University
Skills
- SAP Analytics
- SAP BI/BW
- SAP BW4HANA
- SAP SAC
- Data Warehousing
- Data Modeling, ETL
Languages
English
First Language
Kannada
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Timeline
Analytics Lead Consultant
DormaKaba
07.2018 - 07.2024
SAP BW Consultant
Tate & Lyle
05.2017 - 06.2018
SAP BW Consultant
Stanley Black and Decker
01.2016 - 04.2017
SAP BW Consultant
GE Aviation
08.2015 - 12.2015
SAP BW Consultant
Vertellus
01.2014 - 12.2016
Bachelor’s - Computer Science and Engineering
Visvesvaraya Technological University