SAP BW/HANA, Native HANA
Resume:
DILIP DAMODHAR
Bangalore •
*************@*****.***
SAP BW/HANA Consultant with 7 years of experience
Experienced SAP Business Intelligence Consultant with a demonstrated history of working in the information technology and services industry. Skilled in SAP ERP, Consulting, SAP BI/BW, Enterprise Resource Planning (ERP). Strong information technology professional with a Bachelor of Engineering (B.E.) focused in Computer Science from Dr.M.V.S.I.T Mangalore. Highly motivated SAP BW consultant with 7 years of experience in BW 7.3, BW 7.4 and BW 7.5 versions & HANA. SAP BW/Hana
Extensively worked in applications like SD, MM and FI. Extensively worked on SAP BI 7.0 and 7.3 & 7.4.
Expertise in Creating and Maintenance of PSA, InfoObjects, DSO, and Info Cubes.
Expertise in creating Application Component, Data Source. Worked on Info Set, Multi Provider.
Worked on Generic Data Sources using Views and Function Module.
Expertise in filling setup tables in R3.
Good Knowledge in Business Content objects and creation of multi providers and info set.
Expertise in creating transformations and Data Transfer Process.
Experience in installing Standard Objects from BI Content which includes Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set, BEx Variables and Standard BEx Reports.
Involved in managing of Info cube, which involves Info cube content, performance issues like compression of Info cube and rolling up the data to the aggregates.
Worked on reports in BEx Query Designer and Query
Analyzer.
Worked on Conditions, Exceptions, Variables, Structures, Restricted Key figures, and Calculated Key figures, Formulas in BEX, Queries, Filters, Free Characteristics, and Navigational attributes.
Knowledge on Line Item Dimensions and High cardinality. Expertise in Transporting of Objects from different systems. Involved in end-to-end data validation.
Knowledge in creating Webi reports in BOBJ 4.0, Dashboard. Implemented SAP BW on HANA specific modelling like Composite Providers, ADSO and exposing BW objects in HANA Views.
Developed and handled hybrid scenarios - BW data models and HANA views as per the requirement.
Worked on Fiori CDS view, Configuring standard Tcodes and custom Tcodes as fiori tiles.
Creating catalogs, groups, assigning tiles to group, assigning groups and catalogs to roles.
Knowledge on Embedded BW (S/4HANA)
Open SAP certifications on Modern Data Warehousing with SAP BW/4HANA & Freedom of Data with SAP Data Hub Currently working as SAP BI consultant at MSG Global Solutions India Pvt Ltd Bangalore since 1st FEB 2018 till date. Worked as SAP BI consultant at Mesprosoft pvt.ltd. Bangalore since 9th MAY 2015 to 12th JAN 2018. Summary
Skills
Certifications
Career History
Worked as junior Software Tester at Espina Software Solution LLP from 11th FEB 2013 to 07th APR 2014. 2008 - 2012 Bachelor of Engineering, Computer Science Dr.M.V.S.I.T Mangalore
V.T.U
Operating Systems
Windows
Linux
UNIX
Reporting Tools
BEx Analyzer
BEx Analyzer,
Query Designer
Webi
ERP
BW 7.0, 7.3, 7.4,7.5
SAP R/3(ABAP/4)
ECC6
S/4 Hana
Basic Knowledge in SD, MM, FI modules.
Skill Sets
InfoObjects, DSO, Info Cubes
Application Component, Data Source,Info Set, Multi Provider. Generic Data Sources using Views and Function Module Filling setup tables in R3.
Business Content objects
Creating transformations and Data Transfer Process Managing of Info cube, which involves Info cube content, performance issues like compression of Infocube and rolling up the data to the aggregates.
BEx Query Designer and Query Analyzer
Conditions, Exceptions, Variables, Structures, Restricted Key figures, and Calculated Key figures, Formulas in BEX, Queries, Filters, Free Characteristics, and Navigational attributes. Line Item Dimensions and High cardinality.
Transporting of Objects from different systems
HANA specific modelling like Composite Providers, ADSO and exposing BW objects in HANA Views.
Developed and handled hybrid scenarios
Embedded BW (S/4HANA).
Knowledge on BW/4HANA.
Hana Modelling
2020 - Present SAP Native HANA Consultant
COMPANY -MSG Global Solutions
Client: PLRE ( Pacific Life RE)
Responsibilities:
Worked on tickets, solving issues in HANA views that were raised. Working on CR as per user requirement.
Created Calculation views as per reporting requirement / defects. Worked on performance improvements of HANA views.
2020 - present SAP BW/HANA Consultant
COMPANY – MSG Global Solutions
Client: NSGI ( Nan Shan General Insurance Taiwan) ( Greenfield Implementation) Responsibilities:
End to End implementation of General insurance module in BW. Installation of Business content objects in BW.
Activating DataSources in ECC.
Created DataSource from Tables, Views & Function Modules. Enhanced Datasource using CMOD and Events.
Created Calculation Views from Tables on Operational Portal on DB2. Created Virtual tables in BW/HANA database using SDA from ECC tables. Created Calculation Views integrating OP Tables and ECC tables (Created using SDA) in BW/HANA system.
Created staging Layer for CD, PM, CM & ICM modules. Created Core Layer for CD, PM, CM & ICM modules.
Education
Technical Summary
Work experience
Integration of BW models with OP data models(CV) using Composite Providers. Created Bex queries on top of Composite Providers as per requirement. 2019 - 2020 SAP BW/HANA Consultant
COMPANY – MSG Global Solutions
Client: MSIG Singapore (Support + Development)
Responsibilities:
Working on tickets assigned and solving it within SLA. Making changes in BEx queries as per the defects and new requirements. Analyzing the new requirements and making changes in the CP and the CV that is present in the current model.
Creating BW models for the new reports after thorough analysis and understanding of the functionality. Created ADSO, CP and CV (using the active table of ADSO). Created Reports on Claims, FS-CD, FS-RI, FS-PM modules. Data reconcilation done for the reports from FS-CD, FS-RI, FS-PM system. 2018 - 2019 SAP BW/HANA Consultant
COMPANY - MSG Global Solutions
Client: GIC Re (General Insurance Corporation of India) (Implementation) Responsibilities:
End to end implementation of Life reinsurance module in BW. Created Data models as per reporting requirement.
Extraction of data from ECC LRM and FSRI basic system for Life. Created BEx queries for Treaty related, Accumilation, Claims, Premium, UPR and Non propotional treaty reports. Created CKFs, RKFS, Selection and formula variables to be used in the query. Implemented virtual characteristic in the report for dynamic values for age calculation based on user input date.
Worked on Start routine and field routines.
Data reconcilation done for the reports from LRM system. Good understanding of LRM and Basic system.
Job monitoring and scheduling Process chains and fixing Process chain failures during data extraction. Reconstructed the data requests from PSA in case of data load failure. 2016 - 2018 Associate BW Consultant
Company - Mesprosoft
Client: GOCL(Gulf oil corporation Limited) (Implementation) Responsibilities:
Extensively worked on LO applications like SD, MM and PP. Extensively worked on standard Info objects, Data source, and Info provider. Worked on creating View and created Data Sources based on View and Function Module. Created Transformation and DTP’s.
Worked on Installing Standard Objects from BI Contents. Created Data Sources, DSO’s and InfoCubes.
Worked on MultiProviders.
Involved in performance issues like creating aggregates, compression of Info cube and rolling up the data to the aggregates.
Created BEx Query reports in Designer and checked in Analyzer. Worked on Variables, Restricted Key figures, and Calculated Key figures, selections and Formulas in Query Designer, Filters, Free Characteristics, and Navigational attributes. Designed and created Process chains.
Involved in Scheduling jobs based on Hourly, Daily and weekly. Analyzed the errors in Data loads
Job monitoring and scheduling Process chains and fixing Process chain failures during data extraction. Reconstructed the data requests from PSA in case of data load failure. 2015 - 2016 Associate BW consultant
Company : Mesprosoft
Client: JYOTI CNC ( Implementation + Support)
Responsibilities:
Extensively worked on LO applications like SD and MM. Extensively worked on standard Info objects, Data source, and Info provider. Worked on creating View and created Data Sources based on View and Function Module. Created Transformation and DTP’s.
Created with
Worked on Installing Standard Objects from BI Contents. Created Data Sources, DSO’s and InfoCubes.
Worked on MultiProviders.
Involved in performance issues like creating aggregates, compression of Info cube and rolling up the data to the aggregates.
Created BEx Query reports in Designer and checked in Analyzer. Worked on Variables, Restricted Key figures, and Calculated Key figures, selections and Formulas in Query Designer, Filters, Free Characteristics, and Navigational attributes. Designed and created Process chains.
Involved in Scheduling jobs based on Hourly, Daily and weekly. Analyzed the errors in Data loads.
Job monitoring and scheduling Process chains and fixing Process chain failures during data extraction. Managing Transports.
Involving in monitoring Query Designer as per client requirement. Schedule data loads to BI from SAP R/3, monitoring data loads which are running hourly, daily, weekly and monthly loads.
Reconstructed the data requests from PSA in case of data load failure.
Contact this candidate