SAP BW4HANA Consultant
Admiral Group
Keywords
SAP NetWeaver Business Warehouse
SAP HANA
SAP Applications
Extract Transform Load (ETL)
Sap Business Objects
Integration Tests
Agile Methodology
Crystal Reports (Reporting Software)
Data Validation
Data Transmissions
Skills
Agile, BI Launch pad, Crystal Reports, Master Data, Data Mart, Data Extraction, Data Store, Data Flow, Data Transfer, Data Validation, Data warehouse, Eclipse, enterprise portal, ETL, Extraction, Transformation, Loading, front-end, Integration test, Integration testing, OLTP, SAP, SAP modules, SAP BI, SAP ERP, HANA, 4HANA, SAP LO, SAP BW, BW, business warehouse, SAP systems, SAP BO, Business Objects, BO, Single Sign On, design document, Reporting tools, Transactional data, Web Intelligence
Project history
09/2018
-
11/2020
Client : Admiral Group, UK
Environment : SAP BW4HANA
Duration : Sept 2018 - November 2020
Project : BW4HANA implementation and Support
Project description:
Admiral Group plc is a British financial services company headquartered in Cardiff, Wales
Roles and responsibilities:
Role: SAP BW4HANA Consultant
* Responsible for BW4HANA implementation in key SAP modules
* Main tasks include the requirements analysis, conception, implementation/development of
solution as per requirement
* Responsible for extraction from SAP and non-SAP systems, data modelling and reports delivery
* Work closely with different Cross-functional teams to develop solutions related to BW4HANA
* Responsible for delivering from offshore on time, on schedule, within scope and adopting
industry best practice and quality
* Ensured that the data model designs are adhere to architectural roadmap and support the
development, execution, and operations of solutions
* Delivered designed data model analytical solutions within the timelines
* Involved in unit and Integration testing and Developed Integration test scripts as part of the
ITC.
* Designed and developed various Process chains.
* Carried out Data Validation between the source system data and target data and analyzed
whether the values are populated correctly.
* Transported all developed objects in ECC and BW across the system landscape.
* Written Integration test scripts and fixed various defects raised by the business users.
* Performed cutover activities as part of the Cutover.
* Created various Webi Reports on top of the BEx queries.
Environment : SAP BW4HANA
Duration : Sept 2018 - November 2020
Project : BW4HANA implementation and Support
Project description:
Admiral Group plc is a British financial services company headquartered in Cardiff, Wales
Roles and responsibilities:
Role: SAP BW4HANA Consultant
* Responsible for BW4HANA implementation in key SAP modules
* Main tasks include the requirements analysis, conception, implementation/development of
solution as per requirement
* Responsible for extraction from SAP and non-SAP systems, data modelling and reports delivery
* Work closely with different Cross-functional teams to develop solutions related to BW4HANA
* Responsible for delivering from offshore on time, on schedule, within scope and adopting
industry best practice and quality
* Ensured that the data model designs are adhere to architectural roadmap and support the
development, execution, and operations of solutions
* Delivered designed data model analytical solutions within the timelines
* Involved in unit and Integration testing and Developed Integration test scripts as part of the
ITC.
* Designed and developed various Process chains.
* Carried out Data Validation between the source system data and target data and analyzed
whether the values are populated correctly.
* Transported all developed objects in ECC and BW across the system landscape.
* Written Integration test scripts and fixed various defects raised by the business users.
* Performed cutover activities as part of the Cutover.
* Created various Webi Reports on top of the BEx queries.
06/2017
-
09/2018
Team Member
Royal Bank of Scotland
Client : Royal Bank of Scotland, UK
Environment : SAP BW on HANA, ECC 6.0
Duration : June 2017 - Sept 2018
Project : Enhancements to the Existing Implementation and Support
Project description:
The Royal Bank of Scotland is a major retail and commercial bank in Scotland. It is one of the
retail banking subsidiaries of NatWest Group, together with NatWest and Ulster Bank.
Role: Team Member
Responsibilities:
* Understood the business and gathered the requirements from the business and functional users.
* Coordinating development with the Offshore/Onsite development teams.
* Involved in designing operational reports and monitoring reports.
* Created Multi-providers over the info cubes and used them in BEx queries according to the
requirements.
* Responsible for defining the BEx Queries used in BO environment.
* Involved in creating Single Sign On between SAP enterprise portal and BI and BO systems.
* Reviewed the developments done by Offshore and explaining the data models to Offshore
* Extensively worked on customizing Sales data sources like Sales Item, Contract Item.
* Extensively worked in defining Complex BEx Queries including Structures, Variables, and Jump
Queries in SAP BW 7.x Environment.
* Created Queries in the Query Designer by using Attributes, Variables, Filters, Calculated key
figures, Restricted key figures, different conditions, and exceptions.
* Worked with Business Explorer (BEx) and publishing the reports on Web using Web Reporting
tools.
* Worked on BO Explorer to analyze the required business information.
* Designed, developed, and managed Universes in Business Objects Designer for generating reports
against SAP BW.
* Created many WEBI reports over OLAP universes.
* Designed Complex Webi reports including Combined Queries and Drill down reports.
* Worked on Creating WEBI reports using Prompts, filters, Variables and various Manual cell
Calculations.
* Extensive experience in working on IDT (Information Design Tool).
* Created BICS Connection using IDT in SAP BI 4.0.
* Mainly contributed on the change requests.
* Incorporated the changes in Back end, BEx query level and BO reports.
* Involving daily base Tickets and Resolving U2, U3, and U4 Level tickets.
* Worked on Change Request Management, Incident Management and Problem Management.
* Involved in Cutover Activities whenever project moves to next release version.
* Taking KT from solution team to understand the Cutover in Better way.
* Involved in Enhancements, Maintain and Support Work Requests.
Environment : SAP BW on HANA, ECC 6.0
Duration : June 2017 - Sept 2018
Project : Enhancements to the Existing Implementation and Support
Project description:
The Royal Bank of Scotland is a major retail and commercial bank in Scotland. It is one of the
retail banking subsidiaries of NatWest Group, together with NatWest and Ulster Bank.
Role: Team Member
Responsibilities:
* Understood the business and gathered the requirements from the business and functional users.
* Coordinating development with the Offshore/Onsite development teams.
* Involved in designing operational reports and monitoring reports.
* Created Multi-providers over the info cubes and used them in BEx queries according to the
requirements.
* Responsible for defining the BEx Queries used in BO environment.
* Involved in creating Single Sign On between SAP enterprise portal and BI and BO systems.
* Reviewed the developments done by Offshore and explaining the data models to Offshore
* Extensively worked on customizing Sales data sources like Sales Item, Contract Item.
* Extensively worked in defining Complex BEx Queries including Structures, Variables, and Jump
Queries in SAP BW 7.x Environment.
* Created Queries in the Query Designer by using Attributes, Variables, Filters, Calculated key
figures, Restricted key figures, different conditions, and exceptions.
* Worked with Business Explorer (BEx) and publishing the reports on Web using Web Reporting
tools.
* Worked on BO Explorer to analyze the required business information.
* Designed, developed, and managed Universes in Business Objects Designer for generating reports
against SAP BW.
* Created many WEBI reports over OLAP universes.
* Designed Complex Webi reports including Combined Queries and Drill down reports.
* Worked on Creating WEBI reports using Prompts, filters, Variables and various Manual cell
Calculations.
* Extensive experience in working on IDT (Information Design Tool).
* Created BICS Connection using IDT in SAP BI 4.0.
* Mainly contributed on the change requests.
* Incorporated the changes in Back end, BEx query level and BO reports.
* Involving daily base Tickets and Resolving U2, U3, and U4 Level tickets.
* Worked on Change Request Management, Incident Management and Problem Management.
* Involved in Cutover Activities whenever project moves to next release version.
* Taking KT from solution team to understand the Cutover in Better way.
* Involved in Enhancements, Maintain and Support Work Requests.
11/2014
-
09/2018
SAP BI/BW Consultant
TCS
11/2014
-
05/2017
Team Member
GSK
Client : GSK, USA
Environment : SAP BW 7.x, ECC 6.0 and BO
Duration : November 2014 - May 2017
Project : BW 7.x Implementation and Support
Role: Team Member
Responsibilities:
* Worked on Stars (GSK) Blueprint design document.
* Completely involved in the requirements gathering and understand the client's business
requirements and preparing the functional specifications
* Identified the AS-IS and TO-BE Processes, performed the GAP Analysis.
* Designing technical specs, Data flow diagrams and coordinating with the offshore team members.
* Worked on LO, FI and Generic extractors
* Worked on Business Content Installation and activation, Migration of flows from BW 3.x to BI 7.0,
Customization as per the Gap analysis.
* Written various routines at Transformation level as per the requirements.
* Daily interacting with the offshore team members and delegate the work to them and coordinating
onsite and offshore teams effectively.
* Implemented all BEx Query designer options during design of the queries.
* Extensively worked on transportation for transporting the Objects across the land scape.
* Acted as an Integration coordinator.
* Designed and developed Process chains (Master Data and Transactional Data Chain).
* Involved in the cutover meetings and prepared the cutover plan.
* Acted as an Integration coordinator.
* Provided one-month Hyper Critical Care (HCC) support to the client.
* Process chains monitoring.
* Master data loads, transactional data loads monitoring.
* Daily data loads, weekly data loads and monthly data loads monitoring.
* Handling the tickets. Accepting the tickets and based on SLA (Service level agreements) resolving
the issues.
* Updating daily and weekly status sheets.
* Attending daily and weekly status calls.
* Resolving the issues and testing the reports.
Environment : SAP BW 7.x, ECC 6.0 and BO
Duration : November 2014 - May 2017
Project : BW 7.x Implementation and Support
Role: Team Member
Responsibilities:
* Worked on Stars (GSK) Blueprint design document.
* Completely involved in the requirements gathering and understand the client's business
requirements and preparing the functional specifications
* Identified the AS-IS and TO-BE Processes, performed the GAP Analysis.
* Designing technical specs, Data flow diagrams and coordinating with the offshore team members.
* Worked on LO, FI and Generic extractors
* Worked on Business Content Installation and activation, Migration of flows from BW 3.x to BI 7.0,
Customization as per the Gap analysis.
* Written various routines at Transformation level as per the requirements.
* Daily interacting with the offshore team members and delegate the work to them and coordinating
onsite and offshore teams effectively.
* Implemented all BEx Query designer options during design of the queries.
* Extensively worked on transportation for transporting the Objects across the land scape.
* Acted as an Integration coordinator.
* Designed and developed Process chains (Master Data and Transactional Data Chain).
* Involved in the cutover meetings and prepared the cutover plan.
* Acted as an Integration coordinator.
* Provided one-month Hyper Critical Care (HCC) support to the client.
* Process chains monitoring.
* Master data loads, transactional data loads monitoring.
* Daily data loads, weekly data loads and monthly data loads monitoring.
* Handling the tickets. Accepting the tickets and based on SLA (Service level agreements) resolving
the issues.
* Updating daily and weekly status sheets.
* Attending daily and weekly status calls.
* Resolving the issues and testing the reports.
Local Availability
Only available for remote work
