SAP BI CONSULTANT
Stridely Solutions India Private Limited
Total years of experience :4 years, 2 Months
1. Working on the Support project which includes Process Chain Monitoring on daily basis. 2. Coordinating with the BI team for the delays and number of data loads happening in the system. 3. Creating and Scheduling the Process chains for loading the master data and transactional data into various DSO. 4. Mapping of the datasets from BODS side and sending it to the Business object team for reporting purpose. 5. Enhancement of the fields in the BW and B4 side and creating UAT for the changes applied
Worked on Bex Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information. Extensively created / used calculated key figure, restricted key figure, Exception, Condition and formula. Project: #1 Client Role Environment Duration April 2019 to December 2021 SAP BW 7.3 & 7.4, ECC6.0 Implementation& Support Project Trident Group RESPONSIBILITIES Involved in setting up of procedures for LO Extraction, which includes activating the data source, customizing the data source, generating the data source and deleting the setup tables Worked on BEX Query Designer. Created Info Packages for scheduling the data load process with Full and Delta update mode. Created aggregates and used line-item dimensions to increase the performance of the query Involved with performance tuning of queries by compression and creating Indexes of Info cubes. Scheduled DTP for loading Transactional Data from PSA to Info Provider using Process Chains. Extensively used calculated key figures, restricted key figures, new selection, formula, exceptionsand conditions. Project: #2 Role Environment Client Scania AB Support SAP BW 4 HANA Jan 2022 - February 2023 Duration RESPONSIBILITIES Worked on Advance DSO and open ODS view through HANA Studio. Developed various data extraction flows for Master Data for attributes, texts and hierarchies and transactional data (Full and Delta) using LO cockpit and generic extractors for customer-defined tables. Worked Extensively on Data Warehouse Workbench and customized info objects, Data Sources, DTPs, Transformations and Multiprovider. Set up Periodic Data loads through Automatic data loads. Involved in extracting the data from S4 Hana. Creating and managing dataflow using DTP, Transformations and Info Packages. Data Source Enhancement according to Customer requirements. Involved in Extraction from Flat files both Transaction data & Master data and EnhancingData sources to meet the business requirement.
Marketing management
Applied Electronics and Instrumentation Engineering