SAP BW Consultant

SAP BW Consultant

We are seeking an experienced SAP BW Consultant to join our team. The ideal candidate will be responsible for providing technical functional support and oversee the offshore team for SAP BW applications ensuring data integrity, reporting accuracy, and seamless planning and consolidation processes.

Key Responsibilities

• Support Troubleshooting: Provide technical support for SAP BW including troubleshooting issues, resolving system errors, and ensuring smooth operation.
• Data Modeling: Design, develop, and maintain data models in SAP embedded BW ensuring optimal data flow and reporting capabilities.
• Reporting: Create and enhance reports using BW Query Designer, Hana Studio Business objects report, and SAP Analysis for Office ensuring stakeholders have access to accurate data.
• System Monitoring: Regularly monitor system performance and resolve any issues related to data loads, process chains, and system health.
• Documentation: Help with detailed documentation of processes, configurations, and user guides for BW systems.
• Collaboration: Work closely with cross-functional teams including finance, operations, and IT to gather requirements and deliver solutions.

Required Skills and Qualifications:

• Education: Bachelor or master’s degree in Computer Science, Information Technology, Finance, or a related field.
• Experience: Minimum 4-7 years of experience in SAP BW support or consulting roles.
• Strong understanding of SAP data warehousing concepts and financial planning processes.
• Experience with SAP S4 Hana. Any experience with Embedded BPC, SAC, Planning, and Analytics will be positive.

Technical Skills

• Proficiency in SAP embedded BW including data extraction, transformation, and loading (ETL).
• Create, Manage BW Info providers, Multiproviders, Composite providers, ADSO, DSO, Info Cube, etc.
• Create, Manage Data sources within BW and how they can be leveraged.
• Create, Maintain Master data objects, Info objects, hierarchy, attributes, and other BW technology.
• Create, Maintain dimensions, BW hierarchies, Bex queries, BADI, Hana Views, CDS Views including integration with ABAP classes.
• In-depth knowledge on SAP COFA code and maintain them like GL, Company Code, Profit Center, Cost Center, Location Allocation.
• In-depth knowledge on SAP Transport mechanism and Charm knowledge is plus. Ad Hoc Reporting using BW SAP Tables and Analysis for Office Front End Reports.
• Create, Maintain Transformation Files and Conversion files and Performed Data Loading relates to Master data Attributes or text Hierarchies and Transaction data. Knowledge of ABAP, SQL, and data modeling principles. Experience with SAP BPC configuration and usage will be positive.
• Analytical Skills: Strong analytical and problem-solving skills with attention to detail.
• Communication: Excellent verbal and written communication skills, ability to work with diverse teams and stakeholders.
• Certifications: SAP BW and/or BPC certification is a plus.
• Good to Have: Able to assist in the maintenance of BPC applications supporting financial planning, budgeting, and consolidation processes.
• Experience in configuration of Environment Models and Dimensions for Planning and Consolidation.
• Experience in supporting planning sequence, planning function allocation process.
• Experience on Configuration of Works status and Data Auditing.
• Worked on various period open activities.
• Validation of Version dimension ownership data, rates, work status, and business process flow activities.

Work Environment: This is an onsite position. Flexibility in working hours may be necessary to accommodate global teams.