Candidate's Professional Experience Summary
HANA:
- Hands on experience in HANA modeling. Experience in creating Attribute views, analytical view and calculated views.
- Configured and Extracted data from SAP ECC, SAP CRM and SAP BW on HANA Data Base using SLT, BODS and DXC methods of Data provisioning.
- Optimization of the modeling using Calculation Engine (CE) operators in SQL Script.
- Application of HANA In-memory concepts.
- Experience with Performance Tuning in HANA Database.
- Had created Technical Specifications.
- Had worked on HANA Security by creation of users, roles, creation of analytic privileges.
- Had compared Object Versions and validated information models.
- Had worked on Back-up and recovery.
- Transported SAP HANA content with Enhanced CTS (CTS+).
- Experience in sizing and scaling of SAP HANA
- Experience with integration of HANA with BO Components.
BW on HANA:
- Created HANA optimized DataStore Object and HANA-optimized InfoCube for faster reporting to accelerate data loads, simplify data modelling and to allow faster remodeling of structural changes.
- Had created Virtual,Transient Infoprovidersand Composite providersin BW on top of HANA Model, created DB Connect to load data from HANA to DW.
- Worked on Layered Scalable Architecture plus plus (LSA++) with SAP HANA
Data Modeling with BW 7.3:
- Design & Maintenance of Customized Infoobjects, Info Cubes, DSO Objects, Multi providers, Infosets, Data Marts, SPO’s, Hybrid, Transient and composite Infoproviders.
- Experience with SAP BW 7.3 on HANA,SAP BW 7.4 on HANA migration.
- Done functional upgrade /Migration of BW 3.5 data flow to BW 7.0.
- Worked on SAP BW Accelerator, Real Time Data Acquisition, Currency and Unit Conversion
- Created ABAP Routines in transformationsand maintained Process Chains.
- Good Working knowledge on Graphical Data Modelling.
Data Extraction to BW 7.3:
- Data extraction from BW content extractors and customer generated extractors) and cross application specific extractors (generic extractors), flat file.
- Maintenance &enhancements of data sources at SAP OLTP source system.
Performance Tuning:
- Worked on Aggregates, Indexes, partitioning and Compression/collapse.
Reporting:
Business Objects (BO):
- Experience with Installation/upgrading/maintenance of SAP Business Objects 4.x components.
- Experience withSAP BO Launch Pad and creation of interactive reports using Webi.
- Created BO Reports on top on BEx Queries using BICS Connection.
- Developed dashboards using Dashboards 4.1 /4.0/Xcelsius 2008.
- Had created reports inLumirato handle huge volume of data in real time.
- Worked on SAP BI 4.0 Mobility for usage of BO reports with iOS/Android Devices.
- Created Semantic Layer (Universe) using IDT,
- Created Crystal ReportsandBusiness Explorer reports for search and exploration.
- Has experience on SAP BO Design Studio.
BEX:
- Developed reports in front-end involving Calculated key figures, Restricted key figures, Structures, Variables, Conditions, Exceptions, Cell Editor, Formulas, RRI’s.
- Had created customized Workbooks.
- Had created web reports using Web Application Designerformatted reports using report designer.
- Had worked on Information Broadcasting for distribution of BI Data through different channels and in different formats.
- Had worked on integration of BW Reports to Enterprise Portal.