SAP BI Architecture & Hands-on Development
Own the hands-on architecture, design, and implementation of SAP BW/4HANA and SAP Analytics Cloud (SAC) solutions. Develop and optimize ADSOs (Standard, Write Optimized, Corporate Memory), Composite Providers, Open ODS Views, and InfoObjects, leveraging HANA-optimized modeling patterns. Apply LSA++ principles to ensure scalable, reusable, and future-proof BI architectures.
Code-Level Data Transformation & Modeling
Design and implement complex transformation logic using BW Transformation Framework, HANA SQLScript, AMDP (Managed Database Procedures), and ABAP routines. Optimize data flows using push-down techniques to SAP HANA for improved performance, reduced data latency, and efficient processing of large financial datasets.
Source System Integration & Data Acquisition
Lead data acquisition from common source systems including SAP S/4HANA (FI, CO, AA, ML, Group Reporting) using ODP, CDS Views, and Extractors, as well as SAP ECC, SAP BPC, and SAP BusinessObjects Universes where applicable. Integrate non-SAP sources such as flat files, databases (via DB Connect), APIs, and cloud-based sources using Open ODS Views and SDA.
Process Chains & Data Load Orchestration
Design, build, and optimize BW Process Chains, including delta management, error handling, reprocessing strategies, and monitoring. Ensure robust scheduling, dependency management, and recovery mechanisms to support business-critical reporting cycles.
Analytics, Queries & Visualization
Develop BW Queries (BEx/Query Designer) with optimized calculations, restricted/key figures, hierarchies, variables, and exits to support enterprise reporting. Design and deliver SAC models, stories, and analytic applications, leveraging live and acquired connections, calculated measures, and advanced analytics features while ensuring query and story performance.
Testing, Validation & Performance Tuning
Perform unit testing, SIT, and UAT with a strong focus on data validation, reconciliation, and financial accuracy. Conduct performance tuning at query, transformation, and model levels—using aggregations, partitioning strategies, and data volume optimization techniques. Validate authorization concepts using BW Analysis Authorizations and SAC role models.
System Optimization & Best Practices
Continuously evaluate BI solutions to identify opportunities for code simplification, automation, and performance optimization. Drive adoption of SAP BW/4HANA and SAC best practices, reduce data redundancy, and ensure high availability, security, and system stability.
Governance, Documentation & Compliance
Maintain detailed technical documentation covering architecture designs, data models, transformation logic, SQL/AMDP code, process chains, queries, and SAC content. Ensure compliance with ABB enterprise architecture standards, transport governance, and audit/regulatory requirements.
Troubleshooting & Technical Leadership
Act as the hands-on SAP BI Subject Matter Expert, leading deep-dive analysis and resolution of complex issues related to data inconsistencies, load failures, performance bottlenecks, and integration defects. Collaborate closely with functional architects, BASIS, security teams, and external vendors to deliver durable, high-quality solutions.
License to Operate
Ensure compliance with ABB's integrity, data privacy, GDPR, and safety standards and the core values of ABB in the assigned area.
