SAP BI/BW consultant
enzen technologies pvt ltd
Total years of experience :2 years, 3 Months
Responsibilities:
• Being an Associate BW/BI Consultant, responsible for support & maintenance of SAP BI 3.5 connected to ECC 6.0 system with the following SAP modules: PM, MM/SRM, FI, CO.
• Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains during various stages of project.
• Involved and developing different type of objects like Info objects, Info cubes, DSOs, DTP, Transformation & Multiproviders.
• Involved in initializing the LO Data source by Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source.
• Exposure to Performance Tuning measures like Aggregates, Compression, and Partition & Indexes.
• Enhanced the Data source by using customer exits to fill the data into the fields.
• Worked on Bex Query Designer in designing queries using Columns, Rows and Free Characteristics detailed drill down data analysis to required level of information.
• Reconciliation has been done between BW and various systems, within layers of BW system, SAP BW and Bex.
• Post processing of Data Sources to enhance extractors and coded user exit EXIT_SAPLRSAP_001 for Transactional Data using SAP Enhancement data source to extract this data to BW.
• Created Bex queries and InfoSet queries for reporting from the InfoCube and ODS Objects respectively. Used front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, conditions and Query Jump targets while formulating BEX queries
• Support the on boarding and training of BW Power Users. This includes providing technical training of key BW toolsets such as Bex web analyzers, query designers.
• Extensively involved in setting up of procedures for extracting data from SAP R/3 by using Generic Extraction, Flat file, LIS and LO Cockpit.
• Worked Extensively in Transports across the Landscape
• Ensure the data quality
• Aggregation of data at query/Cube level
• Reconciliation between BW and various systems used in Customer Reporting Solution
• Articulate and identify the SAP testing approach and methodologies in accordance to the project requirements
• Good amount of experience in SAP BW testing activities - Extensive testing tasks using preconfigured data extractors, Analysis and Reporting tools .i.e. Analyser, Query Designer, Report Designer. Through BW testing we have validated Objects, Rules, Connectivity, flow of data within BW and various connected Systems/Applications. Data is pulled from ECC; cleansed and aggregated data is stored in SAP BW system and pushed to external systems.
Experience Summary
• 2.5 years of experience in SAP BW/ BI Data modelling and reporting.
• Experience in SAP BW 3.5, BI 7.0, SAP ECC.
• Having Good experience in Production Support and development.
• Excellent communication, relationship management, strong analytical and leadership skills
2. NEF-Network Efficiency Factor.
Role: SAP BW consultant
Type: Development
Project Description:
The Network Efficiency Factors (NEF) Project is to maximise effectiveness and efficiency by creating comparative performance (cost & quality) measures for all operational managers, assets and geographies in WWU to expose opportunities and improve performance.
Responsibilities:
• Involved and developing different type of objects like Info objects, Info cubes, DSOs, DTP, Transformation & Multiproviders.
• Involved in initializing the LO Data source by Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source.
• Exposure to Performance Tuning measures like Aggregates, Compression, and Partition & Indexes.
• Enhanced the Data source by using customer exits to fill the data into the fields.
• Worked on Bex Query Designer in designing queries using Columns, Rows and Free Characteristics detailed drill down data analysis to required level of information.
• Reconciliation has been done between BW and various systems, within layers of BW system, SAP BW and Bex.
• Post processing of Data Sources to enhance extractors and coded user exit EXIT_SAPLRSAP_001 for Transactional Data using SAP Enhancement data source to extract this data to BW.
• Created Bex queries and InfoSet queries for reporting from the InfoCube and ODS Objects respectively. Used front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, conditions and Query Jump targets while formulating BEX queries
• Support the on boarding and training of BW Power Users. This includes providing technical training of key BW toolsets such as Bex web analyzers, query designers.
• Extensively involved in setting up of procedures for extracting data from SAP R/3 by using Generic Extraction, Flat file, LIS and LO Cockpit.
• Worked Extensively in Transports across the Landscape
Master of Computer Application From: St Joseph's College Of Engineering.