SAP BW HANA ARCHITECT with SAP BO/POWER BI/SAP Analytics Cloud

SAP BW 7.4, ECC6.0 - BW Support Project

Responsibilities:

* Monitoring data loads and restoration of failed loads. Resolving issues raised by End Users and fix any data
issues.
* Monitoring IB jobs on a daily basis and fixing IB Errors.
* Responsible for reconciliation of data.
* Involved in Month end and Quarter end activities.




* Loading Flat File data to ensure Non-SAP sales data is updated
* Involved in Month end and Quarter end activities
* Loading Flat File data to ensure Non-SAP sales data is updated.

SAP BW 7.3, ECC6.0 - BW Support Project

Responsibilities:

* Worked on CPS developments and scheduled process chains using CPS Job Chains and Sub Job Chains.
* Fixed long pending Nestle Incidents and responsible for updating Incident tracker to track the progress and
ensure accountability. Adhering to Nestle standards and processes using tools like Service Center, Nestool
and Service Manager.
* Involved in fixing archiving data using NLS in BIM Systems. Responsible for the BI Transports. Ensuring
successful execution of YCHECK and YIAAT. Making sure XRT environment is managed appropriately to
ensure smooth transportation. Regional BIM and Global BIG systems are maintained in sync with the latest
transports.
* Involved in testing objects in Hana environments. Worked on preparation of Test Scripts. Responsible for the
UAT and also identifying the showstoppers. Making sure Delta inconsistencies are removed and appropriate
steps taken to re-init and complete testing in RTE environment.

SAP BI 7.3, ECC6.0 - BW Implementation Project

Responsibilities:

* As part of the BI CRM Team and being the Team Lead, involved in reviewing the existing developments and
improving the design wherever necessary.
* Responsible for all the BI Transports. Involved in fixing up all the Transport Errors especially those arising due
to BW Adapters.
* Worked on preparation of Test Scripts. Responsible for the UAT and also identifying the showstoppers
(Especially getting data populated into the CRM Tables).
* Involved in discussions with the client about the upcoming CR's.
* Responsible for the successful delivery of all the BI-BO Reports. Involved in checking the BO Design with the
help of BO Team and conducting internal mock tests to examine the existing design.

SAP BI 7.0, ECC6.0 - BW Implementation Project


Responsibilities:

* Involved in Designing and Implementing New Reports for SD, MM.As part of BI implementation team,
involved in gathering user requirements and Perform Gap Analysis.
* Involved in identifying the reports to be developed from BW which are critical and caters to the needs of top
management and creating reports from areas such as Purchasing (Purchase Vat Report, Invoice Lifecycle
time & Payment metrics report etc.) and SRM (Fast Track & Gated Report etc.)
* Responsible for preparing and reviewing the TD (Technical Design) Documentation of the BI Team. Acted as
a Point of Contact for the BI Development Team and the Client to get the Sign off from the Users for the
relevant developments.
* Extensively worked on BI report Variables. Extensively worked on RRI (Report-Report Interface to provide
flexibility to jump from BI Reports to SAP ECC System.
* Performed UAT and Involved in Performance Tuning measures to improve the overall Performance.
* Involved in implementing BI Authorizations for the Client as per the requirements.
* Designed and Deployed Process Chains to Automate the Data Loads.
* Worked on Generic Extractors with views and Function Modules.
* Involved in Design & Activation of Data Sources, Info Cubes, DSO, and Transformations.
* Worked in BI-IP Reports. Experienced in BI-IP (Integrated Planning) tool - development of Real time Info
cubes, Multiproviders, aggregation levels, filters, planning functions

SAP BI 7.0/BW 7.3, ECC6.0 - BW Support Project

Responsibilities:

* Handling all the BI Responsibilities for Shell Serp and tracking all the BI Activities assigned to the BI
Resources in the Team and making sure the SLA's aren't breached. Responsible for the Approvals of TAFA
Documents and implementation of the Enhancements.
* Handling Month End/Quarter End/Year End Activities and responsible for the two hourly
communications during QE/YE Schedule along with resolving any escalations in quick time.
* Daily Support activities include monitoring data loads and restoration of failed loads. Handling Incidents
raised by End Users. Responsible for handling Sev2 Incidents and resolving them in Quick Time. Involved
in BCS-BI Data Sync Activities.
* Responsible for driving communications with the End Users, PFP's and all the involved stakeholders to
mitigate risks in day-to-day operations.




* Experience with CTRL M for monitoring Data Loads. Handling all the new Process chain/InfoPackage
Changes going into CTRL M Tool.
* Involved in Reconciling Data between BO, BI and ECC and ensuring proper communication between BO-
BI Teams. Involved in Handling Upgrade Issues Post Upgrade to BI 7.3.
* Enhanced the Existing Data Flow to meet Client Requirements and Coordinated Testing Activities with
the Client. Involved in monitoring BIA Landscape and handling all the related BIA Activities.
* Involved in improving the performance of GL Extractors by having Indexes created at the Table Levels.
* Work with SAP NetWeaver BW data sources in BusinessObjects reporting tools.
* Worked on seamless integration of SAP BusinessObjects Business Intelligence (BI) solution and the SAP
NetWeaver Business Warehouse platform.
* Designed BO WEBI Reports using formulas & variables based on User requirements.
* Worked on SAP BO Dashboards and crystal reports.

SAP BI 7.0 ECC6.0 - BW Implementation Project

Responsibilities:

* Worked on BI-IP Templates. Changed the Design of Existing IP Templates to improve the Performance of the
Template. Enhanced the Existing Data Flow to improve the Performance of Reports.
* Coordinated Testing Activities with the Client. Prepared Test Scripts and Configuration Documentation.
* Enhanced the Existing Data Flow to improve the Performance of Reports.
* Coordinated Testing Activities with the Client.
* Prepared Test Scripts and Configuration Documentation.

SAP BI 7.0, ECC6.0 - BW Implementation Project

Responsibilities:

* Involved in Activation of Data Sources, Data Modeling which includes Design of Info Cubes, DSO, and
Transformations.
* Involved in Designing and Implementing New Reports for SD, MM and IM and EC-CS (Consolidation).
* Extensively worked on RRI (Report-Report Interface to provide flexibility to jump from BI Reports to SAP ECC
System.
* Performed UAT and Involved in Performance Tuning measures to improve the overall Performance.
* Involved in implementing BI Authorizations for the Client as per the requirements.




* Designed and Deployed Process Chains to Automate the Data Loads.
* Worked on Generic Extractors with views and Function Modules.

SAP BI 7.0, ECC6.0 - BW Support Project

Responsibilities:

* Daily Support activities include monitoring of data extraction (Data Extraction from R/3, SRM), and
restoration of failed loads. Handling Notifications raised by End Users.
* Extensively worked on Generation and Maintenance of Roles, Authorizations and User Profiles using
Transactions RSECADMIN. Involved with both Reporting Roles and Authorization Roles and also involved in
Enterprise Portal.
* Experience with ECC Tables, BAPI , Program & Function modules.
* Worked on Development of New Reports. Worked on Generic Extraction to meet client requirements.
Involved in Data Modeling which includes Development and Activation of Info Providers, Info Sources and
Info Objects.
* Involved for Generating Reports using Query Designer Tools and WAD.
* Worked on Merger of two BW Production Systems. As part of this activity, we have brought in all the BW
Objects from Two different BW Production systems (Europe and North America) into one Production System,
thus reducing the costs for client drastically.
* Working on Functional upgrade of BI system to SAP BI 7.0 Version.
* Involved in change of existing design to meet current requirements of the user.
* Involved in Client meetings and updating them to rectify their mistakes which cause data extraction problems
especially with the invalid characteristics.
* Updating the documentation if any changes were carried in production. Also documenting the list of tickets
with the problem, Cause for the problem and with the resolution followed.
* Extensively worked with basis team for the database issues during Testing Phases (Maintenance Testing,
Regression Testing etc.)Involved in testing throughout the system landscape during the Support Package
upgrade.