Job Summary :

We are looking for an experienced SAP BW/HANA Consultant with strong analytical and assessment skills to design, develop, and optimize enterprise data warehousing and reporting solutions. The ideal candidate will have deep expertise in SAP BW, SAP BW on HANA, and SQL, along with experience in data modeling, reporting, and performance optimization.

Must-Have Skills :

- Excellent assessment and analytical skills to understand complex reporting requirements.

- Strong experience in SAP BW.

- Hands-on expertise in SAP BW on HANA.

- Strong knowledge of SQL for data analysis and validation.

Key Responsibilities :

- Analyze reporting requirements and identify relevant tables and views from source systems such as SAP ECC, Oracle, and SAP SRM.

- Perform SAP BW modeling on HANA using Composite Providers and Advanced DSOs.

- Review functional specifications for BW queries and data models.

Design and create :

- Info Objects

- Info Sources

- Transfer Structures

- Standard & Custom Info Cubes

- Data Store Objects (DSO)

- Create and enhance Data Sources (Generic & FI Data Sources) for BW and BW on HANA.

- Monitor and troubleshoot Process Chains and resolve critical production issues.

- Develop BW Queries using BEx Query Designer, Customer Exit Variables, and Hierarchy Variables.

- Perform front-end reporting and data visualization activities.

- Conduct SQL-based analysis in source systems for validation and reconciliation.

Preferred Skills :

Exposure to reporting tools such as :

- Power BI

- SAP Analytics Cloud

Experience in ABAP for BW object enhancements including :

- User Exits

- Function Modules

- Start Routines

- End Routines

- Good exposure to SAP Data Services (BODS), especially for integration with cloud systems such as SuccessFactors.