Wipro Technologies | Project - Severn Trent Waters | July 2019 – August 2021 | Technical Lead | BW/4HANA Consultant
BW/4HANA Shell Conversion (Greenfield Approach)
Worked on shell conversion process with the analysis and understanding of General Sequence. o System Requirements, Maintenance Planner, Pre-Checks, Custom Code Checks, System Provisioning, Shell Conversion, Post Conversion Tasks. o SAP Notes: Understood the procedure to create program Z_SAP_BW_NOTE_ANALYZER, which is used to update the tools for converting a system from SAP BW to SAP BW/4HANA. Operational Data Provisioning (ODP) Framework
Worked on Extraction and Replication Scenarios for various target applications.
Worked and understood how it supports delta mechanism. Advanced Data Store (ADSO)
Worked on ADSO and understood various types (Standard, Staging, and Data Mart) Composite Provider
Implemented mixed modelling in composite provider considering Infoset in BW system. BEx Queries:
Worked on Query Designer which is eclipse-based tool set. Created RKF, CKF, Formula variables.
Understood query technical properties and compared this feature against the earlier versions of query designer. Customer Exits:
Worked on Conversion of Customer Exit to Enhancement Spots.
Created Function Module and Implemented BADIs for 28 customer exit variables.
Roles and Authorization: Understood Authorization required for the BW/4HANA transfer toolbox.
Understood Authorization impact once the BW system is converted to a SAP BW/4HANA. ABAP Routines:
Worked on implementation of Routines Post conversion in BW/4HANA. Virtual Time Hierarchies:
Worked on Virtual time Hierarchy based on Time Char. Required for some reporting scenarios.
Wipro Technologies Ltd | Project - KAO USA Inc | Jan 2018 – June 2019 | Senior SAP BW HANA Consultant
Worked on BW on HANA modelling objects like Advance DSO, Composite Provider.
Experience in creating HANA Information views Modelling: Attribute, Analytical and Calculation Views.
Experience in BW Support during BW HANA Migration.
BEx Worked Extensively in BEx Analyser in building Queries, saving it in Workbooks (Excel work Sheets).
Responsible for Onsite – Offshore coordination and Customer interfacing during weekly meetings and giving regular updates to all stake holders involved. Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.
Involved in Status Reporting: Provided status reporting to both the client and the internal stakeholder over the Weekly Status Meeting (WSR) and Monthly Status Review (MSR).
Quality Control / Approvals: Responsible for the overall quality of deliverables and will provide approvals if necessary.
Participated in the ticket management and resolution processes, including receiving, resolution monitoring and customer satisfaction
Provides direction, training, and guidance for less experienced. Defines metrics and monitors Service Level Agreements (SLAs) for systems being developed.
Wipro Technologies Ltd | Project – AREVA | May 2016 – April 2017 | Senior SAP BW Consultant
Involved in creating and maintaining Info Cubes, DataStore Objects, Info Objects, Info Areas, Data Sources, Transformations, Data Transfer Process, and Info Packages.
Migrated DataSources from 3.x version to BI7.0 version and created several DSO objects which act as data staging engine.
Involved in creation of Info Cubes, DSO, Data Sources, Info sources, PSA for data Extraction, Transformation and Loading from SAP R/3 to SAP BW.
Extensively used MultiProvider for reporting using various InfoCube combinations to suit business needs
Data extraction from R/3 to BW by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for periodic loads.
Worked in extractions, LO-Cockpit extraction and others using V3 updates.
Wipro Technologies Ltd | Project – AREVA | May 2016 – April 2017 | Senior SAP BW Consultant
Involved in creating and maintaining Info Cubes, DataStore Objects, Info Objects, Info Areas, Data Sources, Transformations, Data Transfer Process, and Info Packages.
Migrated DataSources from 3.x version to BI7.0 version and created several DSO objects which act as data staging engine. Involved in creation of Info Cubes, DSO, Data Sources, Info sources, PSA for data Extraction, Transformation and Loading from SAP R/3 to SAP BW.
Extensively used MultiProvider for reporting using various InfoCube combinations to suit business needs
Data extraction from R/3 to BW by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for periodic loads.
Worked in extractions, LO-Cockpit extraction and others using V3 updates.
Wipro Technologies Ltd | Project – AREVA | May 2016 – April 2017 | Senior SAP BW Consultant
Involved in creating and maintaining Info Cubes, DataStore Objects, Info Objects, Info Areas, Data Sources, Transformations, Data Transfer Process, and Info Packages.
Migrated DataSources from 3.x version to BI7.0 version and created several DSO objects which act as data staging engine.
Involved in creation of Info Cubes, DSO, Data Sources, Info sources, PSA for data Extraction, Transformation and Loading from SAP R/3 to SAP BW.
Extensively used MultiProvider for reporting using various InfoCube combinations to suit business needs
Data extraction from R/3 to BW by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for periodic loads.
Worked in extractions, LO-Cockpit extraction and others using V3 updates.
Wipro Technologies Ltd | Project – AIRBUS | Jan 2014 – April 2016 | SAP BW Consultant
Designed Developed and Modified Info Objects, Info Sources and Info Cubes and loaded these objects with Master data and Transactional data from SAP R/3 and flat files by creating Info Packages.
Installed relevant SAP business content for SD, Vehicle Management System, and Warranty.
Worked on standard and custom defined LO extractors. Used LO structures for extracting sales order, delivery, and billing information.
Involved in BW cutover activities, this includes production system build up, configuration, transport fix, master, transaction data loads, setup tables, initialization, delta loads.
Created Variables, Filters, Exceptions, calculated key figures, restricted key figures, Global and Local structures, and other features to meet user requirement.
Wipro Technologies Ltd | Project - Origin Energy | June 2012 – Jan 2014 | SAP BW Consultant
Responsible for Development of BW Data Model as per the Business Functional Requirements (BFRs).
Designed Technical Specification Document of the Reports.
Designed and Customized InfoObject, Info source, created transfer structures, transfer rules, update rules, DTP, and Transformations, Routines for DSO, InfoCubes.
Uploaded master and transactional data from files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1)
BEx Query Reporting, using Business Content, Generic extraction. Designed Three Info cubes with daily and Monthly Granularity, extraction from PSA.
Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system
