SAP Planning Dev

**Standard Bank Job Description - SAP Analytics Cloud Planning Developer**

**Identifiers**
- Functional Job title***SAP Planning Developer**

**Key Responsibilities**

**SAP Analytics Cloud development**
- Development of SAC Planning models and dimensions
- Import jobs from various source systems into SAC
- Maintain and develop of data actions including advanced formulas
- Ability to create processes of integration within SAC planning models using cross model copy
- Assist with security build and issues experienced using teams/roles and data access control within SAC
- Understand business requirements and translate to a technical build within SAC
- Solutioning designs and various options with business in order to provide optimal output
- Monthly maintenance of master data and loading of actual data set into models
- Build and maintenance of FX currency models and tables
- Reconciliation build between A4O and SAC
- Support during planning cycles with assisting users build input templates and successfully report

**BPC and BW skills (Experience and Skill is advantageous)**
- Ability to work in SAP BW and understanding of technical objects and data flow within BW
- Output group 1***System Support**
- Outputs and measures*

**SAC Modelling**:

- Creating, Updating, Amending the user interface/screens
- Amending model designs and structures
- Understanding of model preferences and output of each setting
- Maintain data locks within model with mínimal impact on users
- Use of multiple hierarchies (BW and custom hierarchies)
- Data access control (security) setup on dimensions
- Ability to create models with optimal performance benefit
- Ability to work closely with the source system (BW/SQL) and integrate into SAC
- Able to work with complex structures and high volumes of data
- Setting up import jobs in an adequate and best practice manner
- Scheduling and automation of import jobs into BW
- Resolution of technical issues is necessary

**SAC Data Actions**
- Creation of cross model copy with best ways to integrate across models including mappings of different hierarchies between source and target model (detailed model to aggregated model)
- Copy within models
- Allocation processes build process and rules and maintain
- Advanced formula
- using scripting functionality and ability to script advanced calculations is required (eg. Float variables, link formulas, member set declaration, for each loop etc)
- Ability to resolve complex errors is required
- Usage of embedded data actions and multi-actions (automate processes)

**SAC Predictive**
- Creation of SMART predict scenarios and models
- Automation of the scenarios to run
- Integrating them into multi-actions

**Input templates**
- Creation of input templates using stories and the functionalities of a story
- Support and resolve any technical issues users experience on inputting data

**SAC Security**
- Ability to create security for users within SAC using data access control set on public dimensions
- Familiar with creation and maintenance of teams/users and roles
- Model privacy is advantageous

**BW Eclipse/bex queries (advantageous)**
- Creation of queries based on composite providers in BW
- Maintenance and testing of queries
- Creation of structures and filters to meet the custom hierarchies created in SAC
- Ability to reconcile the development of the queries to the SAC data

**Finance Knowledge & Experience**
- Some financial background and experience required, preferably in the banking sector.
- Output and measures *- Output group 2***Change and Governance**
- Outputs and measures *- Perform change in accordance with Group IT Governance and policies- Perform System Functionality Configuration/Customization/Coding- Solution Design for new functionality- Analyse Epics, Features and based on business requirement- Documentation of Functional Specifications for Development work and assisting with Functional understanding for the scope of Development work.- Provide high level consulting and expertise to provide direction and leadership on projects and changes- Ensure integration with upstream and downstream systems/processes- Optimise the environments in support of the ‘Always On’ and ‘Resilience’ IT strategy- Output group 3***Adhere to Agile Methodologies and Follow Agile Principles**
- Outputs and measures *- Develop stories in conjunction with business- Determine Effort estimation of stories to be developed- Continuously finding ways to improve own and teams’ delivery- Assisting with Feature identification- Works in partnership with Product Owner- Collaboration with Business and IT representatives (Daily stand-ups, Workshops, Meetings and other Agile Ceremonies etc.)- Output group 4**Testing of Configuration and Development Work for Enhancements or Projects**
- Outputs and measures- Testing of Code and Config for Dev work in all cycles:
- Unit Testing - Dev System, Testing config and dev changes.- Facilitate User Acceptance (UAT) and Integratio