Blog

Role – SAP BW Consultant with Data Modeling

Location – Princeton, NJ

 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 accessto accurate data.? System Monitoring: Regularly monitor system performance and resolve any issuesrelated to data loads, process chains, and system health.? Documentation: Help with detailed documentation of processes, configurations, anduser 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 planningprocesses.? Experience with SAP S/4 Hana? Any experience with Embedded BPC, SAC Planning and Analytics will bepositive? Technical Skills:? Proficiency in SAP embedded BW, including data extraction(DTP),transformation, and loading (ETL).? Create/Manage BW Infoproviders – Multiproviders, Composite providers, ADSO,DSO, Info Cube etc.? Create/Manage Data sources within BW and how they can be leveragedCreate/Maintain Master data objects – Info objects(hierarchy & attributes) andother 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,CompanyCode, Profit Center, Cost Center, Location, Allocation.? In Depth Knowledge on SAP Transport mechanism and Charm knowledge isplus.? Ad Hoc Reporting using BW SAP Tables and Analysis for Office Front EndReports? Create/maintain Transformation Files and Conversion files and Performed DataLoading relates to Master data Attributes or text, Hierarchies and Transactiondata.? 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 workwith 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 andConsolidation.? Experience in supporting planning sequence, planning function.