5 to 7 years of experience in design and development in Business Intelligence for simple/complex data Reporting, Analytics, Extracts, Data Analysis.
Should have extensively for most of the professional tenure on Administrator Workbench (AWB), BEx Analyzer, BEx Query Designer, Bex Web Application Designer, Lumira, BO,HANA.
Involved in creating and maintaining Info Cubes, Classic/Advanced Data Store Objects, PSA, Info Objects, Info Areas, Multi provider, Info Sources, Data Sources, and Info Packages, Analysis Process Designer,queries, workbooks, process chains
Monitoring knowledge for Data loading, process chains, automated jobs and able to handle all the issues related to it.
Data Extracting from the Source system using LO Cockpit, FI Extractors and Generic Extractions for all the types of data.
Involved in Info Cube maintenance i.e. Compression, Aggregates maintenance, Roll-up for Aggregates.
Complete automation of all BI Daily, Weekly and monthly loads (Info Package Scheduling) using Process Chain/jobs /Improved designs.
Should have fair knowledge about BO in which have idea about WEBI Reports creation and scheduling and delivery of ADHOC BO reports as well.
Providing production Support to already developed applications for debugging, Root cause analysis for failures/issues.
Expertise on Delta Data Management, ODP extraction, connection to SAP/Non SAP Data sources, Open Hubs, Outbound, Inbound Data Uploads.
Should have good knowledge on BW-ABAP for development around routines, ABAP transformation codes, extractor level codes.
Should have worked extensively on SAP BW versions 7.x and BW4HANA
Should have knowledge on system stability BW tasks like partitions creation, SPO, BW statistics, Performance tuning of jobs, housekeeping, data retention, ABAP programs optimization, redesign of solutions needing improvements.
Should have worked on Roles and Authorization along with integrating reports to Enterprise portals