05/19/2025 updated
100 % available
SAP BW BO Consultant
India
Worldwide
BE In Computer EngineeringAnalytic ApplicationsData AnalysisComputer EngineeringData ValidationExtract Transform Load (ETL)Data WarehousingDesign StudioInformation ManagementLaboratory Information Management SystemsOpenDocumentPerformance TuningMicrosoft Power BISAP LumiraSAP ApplicationsSAP BI
backend, analytical tools, Computer Engineering, data analysis, data flows, Data validation, Enterprise Data warehouse, Design Studio, ETL, Information Manager, LIS, Lumira, excel, Open Document, performance tuning, Power BI, SAP, SAP BI, SAP Hana, HANA, SAP BW, BW, Business Warehouse, SAP BO, SAP Business Objects, business Objects
Experience
Professional experience5 - 10 years
Freelancer since2022
Languages
EnglishGood
Project history
- Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains also involved in monthly closing activity.
- Development of CDS View based on the requirement for Sales, Procurement and Production in S4Hana.
- Spearheaded the development of SAP Analytics Cloud solutions, focusing on live connections to SAP S/4HANA through CDS Views.
- Collaborated with cross-functional teams to understand business requirements and translate them into effective data models and visualizations.
- Designed and implemented dashboards and reports to facilitate data-driven decision-making processes.
- Excellent knowledge in both functional and technical domain of SAP BW Modelling and handling various types of SAP extractors in modelling like LIS, FI, Generic etc.
- Providing technical support for existing reports and developing new reports in SAP Business Objects (Webi, Design Studio).
- Troubleshooting of reports using HANA Studio, Query Designer and Business Warehouse Work in ETL processes by extracting data from multiple source systems (ECC, CRM, SRM and Supplier Self Service) to and from BW System.
- Gathered requirements from User and Prepared Business Blue Prints & Technical Specs for each module.
- Designed Test Script of each report for users to validate report with ERP System.
- Development of SAP BW models, data flows and queries.
- Developed SAP Analytic Cloud (SAC) solution involving data wrangling, model development, story development, KPI dashboarding for multiple streams of reporting and business units.
- Created different measure and dimension based on calculated and restricted dimension.
- Live Connection of SAP BW with SAC.
- Imported data from SAP BW to Power BI to generate report with DAX Function like table function, aggregation function and iteration functions.
- Worked on all types of transformations that are available in Power bi query editor.
- Used Power BI, Power Pivot to develop data analysis prototype, and used Power View to visualize report.
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
- Scheduled Automatic refresh and scheduling refresh in power BI service.
- Created Webi Report with BEx and IDT Universe.
- Preparing the dashboards for the ongoing projects using Lumira Designer 2.4 backend as BEx Report.
- Preparing MOM for all the meetings organized by SME/Major and DGOS.
- Involved in SAP BO performance tuning, maintenance and troubleshooting. Also monitoring the system health.
- Upgraded of SAP BO System with Pre and Post activity. Also, migration of Report / Dashboard to SAP BO 4.3 SP1.
* Active participation in analysis, development, implementation and maintenance / support of company
solutions based on SAP BW technologies.
* Implement better work practices to achieve high standards of work and maintain established work
procedures.
* Development of SAP BW models, data flows and queries
* Build and Enhance BI/BW objects such as InfoObjects, Transformations, DTPs, InfoProviders (DSOs,
InfoCubes, and MultiProviders), and Process Chains.
* Designs, develops and enhances BI Reports using BeX Query Designer and BeX Report Designer tools.
* Created Webi Report with Bex, SAP Hana Views and IDT Universe in SAP BO.
* Scheduling the Webi Report using publication send mail to the user base on the Pharma level hierarchy.
* Creating Universe using IDT with different concepts like Aggregate Awareness, Row level Security, prompts, filters,
LOV in SAP BO.
* Developing the Graphical report using Lumira Designer 2.4 backend as BEx Report and Data validation
against source systems.
* Created the Open Document link with Bypassing the Login from 3rd Party Portal for accessing the SAP
BO Report.
* Perform SAP BO transport jobs.
* Troubleshoot reporting issues raised on all platforms.
* Training to the in-house support team along with training for the business users.
solutions based on SAP BW technologies.
* Implement better work practices to achieve high standards of work and maintain established work
procedures.
* Development of SAP BW models, data flows and queries
* Build and Enhance BI/BW objects such as InfoObjects, Transformations, DTPs, InfoProviders (DSOs,
InfoCubes, and MultiProviders), and Process Chains.
* Designs, develops and enhances BI Reports using BeX Query Designer and BeX Report Designer tools.
* Created Webi Report with Bex, SAP Hana Views and IDT Universe in SAP BO.
* Scheduling the Webi Report using publication send mail to the user base on the Pharma level hierarchy.
* Creating Universe using IDT with different concepts like Aggregate Awareness, Row level Security, prompts, filters,
LOV in SAP BO.
* Developing the Graphical report using Lumira Designer 2.4 backend as BEx Report and Data validation
against source systems.
* Created the Open Document link with Bypassing the Login from 3rd Party Portal for accessing the SAP
BO Report.
* Perform SAP BO transport jobs.
* Troubleshoot reporting issues raised on all platforms.
* Training to the in-house support team along with training for the business users.