Software Engineer MI

- Negotiable

Shell

Bangalore, India

Job detail

General Business
Analyst
Information Technology
Description:

The SAP BW on Oracle data warehouses, supported by the Shell Downstream MICC (Management Information Competency Center), deliver critical Reporting & Analytics capabilities across most of the businesses and processes in Shell Downstream (DS). In addition a Native HANA system is used to enable more advanced and real-time analytics. The MI Designer/Developer is responsible for the MI design and where relevant build of solutions of low and medium complexity in one of the Downstream sub-processes. The solution scope covers all tools (both back-end and front end) which have been made operational for use in new solutions. With DS moving away from a pure SAP BW on Oracle landscape to a mixed Native/BW HANA landscape with multiple front-end tools (a.o. SAP BI4), it is key to make sure that we design the right solution based on a selection of all the available tools.


Key responsibilities

  • Works under guidance of the Senior MI Designer to clarify low and medium complexity MI and analytical requirements from a technical solution design perspective.
  • Contributes to Prototyping in support of requirements definition or technical design questions
  • Develops Functional Specs/Technical Specs from business requirements
  • Develops the design for new solutions/enhancements of low and medium complexity (extraction logic, data modeling, DSO/Cube/Update rule creation, reports)
  • Works with Business Analyst and Senior MI Designer to develop technical design specification for solutions with high complexity
  • Supervises Build activities of MI Developers and ensures that Build standards are adhered to
  • Prepares test scenarios, contributes to end-user documentation and user manuals
  • Executes/leads Unit Test, and Integration Test for the applicable solutions
  • Resolves defects during test cycles and hypercare
  • Creates runbooks
  • Supports the resolution of Production issues in meetings with the Run & Maintain organisation.
  • Maintains the technical documentation according to agreed procedures


Requirements

  • Experience with Native HANA modelling:
  • Detailed Design experience with the SAP HANA technology
  • Minimum of 5+ full life cycle implementations in SAP HANA
  • SAP HANA modeling and scripting experience which includes ability to write complex stored procedures and scripted HANA views using SQL.
  • Implement data models with SAP HANA using analytical and calculation views. Monitor, investigate and optimize these models and reporting performance on SAP HANA.
  • Administer data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models.
  • Evaluate the impact of different implementation options such as table joins, aggregation, or filters and understand the implication on performance of the various reporting tools and connection types.
  • Apply advanced data modeling techniques, including currency conversion, variables and input parameters. Implement decision automation using business rules.
  • Working knowledge of various data loading and replication methods so to load data into SAP HANA from different data sources (e.g. SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC)) is desirable.
  • Apply SQL Script to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL
  • Understand and implement HANA Security model.
  • Good working knowledge of SAP BI4
  • Building reports using the various tools in the SAP BI4 suite (AOLAP, Web) and Analysis for Office
  • Build WeBi reports and Dashboards
  • Build Dashboards using dash board designers, SAP Lumira, SAP Design Studio.
  • Experience of BW on HANA design is a plus.
  • Experience of designing and building SAP BW data-flows and data-models.
  • Excellent knowledge of key technical objects used in the creation of a SAP BW data model and proven experience in building these BW objects
  • Technical background and experience in ABAP would be a plus.
  • Good knowledge of query development on SAP BW info-providers using the query designer.
  • Experience with Rev- Trac/CTS+ transport management tool
  • Able to perform in-depth problem analysis across BI solutions
  • Experience of using Microsoft Office Products


Key (functional) competences

  • Good knowledge of (some of the) SAP ECC6 and functional modules, relevant for Downstream (SD, MM, FICO, …)
  • A good understanding of Oil & Gas industry is a plus
  • Strong analysis and communication skills
  • Able to engage with various stakeholders
  • Must be a well-motivated team player
  • Organized and methodical, eye for detail
  • Uses his experience to raise improvement suggestions to agreed design
  • Must be ready and willing to learn as new opportunities and skills become available
  • Able to work with limited supervision
  • Experienced virtual team worker