Sap Business Intelligence Consultant (BI/BO)

B.Tech./BE/ MCA/MBA/Graduation or equivalent

Notice Period- 15 Days Maximum

• Should have a minimum of 7 years of experience in respective module working with SAP in client environments
• Certification in SAP BW/4HANA for respective module or should have a minimum of 1 year of experience in SAP BW/4HANA Platform with BO
• To carry out GAP analysis and Data Mapping exercises as per management requirements
• Creation, maintenance of InfoCubes, InfoObjects, ODS Objects, DataSources, InfoPackages, Process Chains, Transfer, Updates rules, transformation Characteristics and Key figures.
• Activating and Enhancing Business Content, Data source Enhancement and Data Extraction.
• Carrying out ETL activities like extracting data from applications of LO cockpit, SD, MM, FI-CO, Business Contents, Generic Data Extraction from Views, Functional Modules, DB connect and Flat Files.
• Design, operate & maintain front-end Business Warehouse components, BEx Analyzer, Query Designer, Workbooks, Calculated key Figures, Restricted Key Figures, Structures, Variable, Exceptions, Conditions, Jump to Query, Ad-hoc Queries, Web Application Designer, Exception Reporting and Pre-Calculated web templates.
• Develop and publish BI reports in Web Reporting using WAD Report Designer, BEx Broadcaster.
• Carryout BI systems performance tuning and using BW Statistics. Improve data load and query performance by creating Aggregates, Compression, Indexes and Data Transfer Settings.
• BI Dashboard designing
• Carry out complete life cycle implementation (from project preparation, business blueprint, realization, final preparation and go- live) of SAP BW reports in SAP functional modules.
• Create process chains for data loading, delta uploading and periodical PSA deletion of existing data or new requirements.
• Manage and monitor several data loads, captured errors and corrected bugs.
• Design Generic Data Extractors to extract/ cleanse and transform the data to suit Business Warehouse model.
• Coordinate with ABAP programmers in creating start and end routines, dynamic DTP filters, Z programs, Function Modules.
• Manage the Transport Management System, creating transport proposals, importing proposals, resolve failed transports and fix them.
• Debugging of ABAP routines, read ABAP dumps, long query executions, and failed data loads, failed process chains, authorization issues, check job logs, sizing, tablespace issues.
• Maintain all report development technical documentation.
• Experience with latest Netweaver data modeling, reporting features, migration and issues.
• Ensure 100% adoption of relevant BI reports across all identified, authorized BI users of units, including extensive user training handholding.
• Working with EP Portal, publishing of queries and linking of workbooks to the portal, using WAD.
• Working with Basis team to resolve short dumps related to tablespace.
• Plan and carry out BI system upgrades as per best practices.
• Imparting training to end users.
• Updating end user training manuals.
• Assisting in implementing new reports in the existing process or new process in SAP landscape with best practices.
• Assist in troubleshooting of functional/ technical issues, if required.
• Visit various business units of SPMCIL for capacity building and change management, migration support, resolution of any technical issues at these locations etc.
• Any other work assigned pertaining to BI Module.
• Provide inputs as and when required relating to different aspects of the respective module like any report for senior management/
• ministry, any risk mitigation plan etc.