Role Overview:The SAP HANA and BW/4HANA consultant is responsible for designing, developing, and implementing enterprise data warehousing and reporting solutions. This role focuses on utilizing SAP HANA Modeling, SAP BW/4HANA, Smart Data Integration (SDI)/ETL, ABAP, and SQL to build scalable data models, integrate data from multiple source systems, and enable high-performance analytics and reporting for business users.
Key Responsibilities:- Work with business stakeholders to understand reporting, analytics, and data integration requirements.
- Architect end-to-end SAP BW/4HANA and SAP HANA solutions aligned with business and technical needs.
- Develop and optimize SAP HANA calculation views, CDS views, and SAP BW/4HANA data models such as ADSOs, Composite Providers, and Open ODS Views.
- Design and implement SDI/ETL processes for extracting, transforming, and loading data from SAP and non-SAP systems.
- Write and tune complex SQL queries, procedures, and scripts for data processing and performance optimization.
- Monitor and improve query performance, data load efficiency, and system scalability.
- Enable reporting tools and dashboards by providing clean, reliable, and well-structured data models.
- Perform unit testing, integration testing, and data validation to ensure data accuracy and consistency.
- Prepare technical design documents, data flow diagrams, and support documentation.
- Experience in BW 7.5 on HANA to BW/4HANA migration.
Required Skills:- Strong experience in SAP HANA Modeling
- Expertise in SAP BW/4HANA modeling
- Hands-on experience with Smart Data Integration (SDI) and ETL processes
- Experience on ABAP
- Advanced knowledge of SQL
- Knowledge on BODS
- Understanding of data warehousing concepts, performance tuning, and reporting architectures
- Ability to collaborate with cross-functional teams and business stakeholders
Qualifications:- 10-12+ years of experience BW4HANA, SAP HANA and SAC
- Demonstrated ability to communicate effectively across the different levels in the organization.
- Pharma or Manufacturing experience is highly desired.
Preferred Skills: 
