SAP BW HANA ConsultantSAP BI SKILLS:
Worked extensively on Administrator Workbench (AWB), BEx Analyzer, ABAP codes for BW.
Involved in creating and maintaining Info Cubes, Data Store Objects, PSA, Info Objects,
Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.
Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA and reloaded to Data targets.
Data Extracting from the Source system using LO Cockpit and Generic Extractions for all the logistics data.
Involved in Info Cube maintenance i.e., Compression, Roll-up for Aggregates.
Complete automation of all BI Daily, Weekly and monthly loads (Info Package Scheduling) using Process Chain
Have worked on various automation & housekeeping of various tables.
Providing daily Production Support from Offshore.
Have got number of appreciations from CLIENT.
Created aggregates to improve the query performance.
Maintain list of all the activities for all the tickets until it is closed down
Extensively involved in creation of BEx Reports. Worked on Calculated
Key Figures Restricted Key Figures, Free Characteristics, Filters and Customer Exists.
SAP HANA:
Data Modeling using Attribute views, Analytic views and Calculation views (both Graphical & SQL script based).
Created Stored Procedures and Table function for implementing business logic.
Worked on creation of XS jobs and scheduling of them via Web interface.