SAP Datasphere, SAC, BW/4HANA and BDC Consultant | Data Modelling, Migration and Analytics

Configure SAP Datasphere connections to S/4 HANA and BW systems using remote tables and replication flows. Data modelling using SQL and graphical views for external systems such as BigQuery and PowerBI. Integrate SAC with SAP Datasphere and BW4HANA for real-time analytics and planning data synchronization. SAC and Datasphere authorizations, user management, roles, and access controls. Build SAP BW composite providers, ADSOs, InfoObjects, process chains as well as data extraction and reporting using BW Queries or Analysis for Office. Design, build, and deploy SAC dashboards, reports, and KPIs for financial, operational, and management reporting. Develop SAC planning models with relevant dimensions, hierarchies, and measures to support forecasting and budgeting. Implement Data Actions, Multi-Actions, and advanced scripting for complex planning logic and automation. Requirement gathering, presentations and technical client playbacks and demos.

Client: Ministry of Finance (Zimbabwe). Environment: SAP BW4HANA, SAP Analytic Cloud. Building Composite Providers and exposing BW objects in SAP HANA Views, Operational Data Provisioning, ADSOs. Handling new enhancements and changes as per business requirements. Participating in data modeling, planning, and scheduling data extraction from source systems, interacting with users for customized and standard reports, gap analysis, calculation views, and associated solutions. Participating in the creation of stored procedures for complex and regular tasks. Creating and monitoring process chains to automate the loading process for master data and transactional data. Reporting: Analysis of Office, BW Queries, and SAP Analytic Cloud stories.

Client: Delta Corporation. Environment: SAP BW 7.x. Involved in the rectification of load failure errors like Master Data loads and Transaction data loads. Designed and developed process chains for Master data loads and Transaction data loads with the help of Info packages. Complex queries in Sales and Payment Reports using Analysis for Office. Query design and report development and testing. Activation of BI content and Data sources. Actualized various types of Bex query variables including User exit, Replacement Path, Text, and formula variables. Created Calculated Key Figures, Restricted Key Figures, and Structures. Installing standard BI Content for SD, MM, and FI-GL.