Sr. SAP BI BW Analytics Consultant

Responsibilities/Deliverables:
* Managing and supporting analytics team from the BI/BW projects and supported the various
deliverables by providing functional and technical design to the team to meet customer requirements
* Developed S/4Hana HR CDS views and Created Fiori reports and BO reports respectively integrated in
Fiori tiles for the analytics
* Developed FI, MM & PP data models in Data sphere from content and integrated them into the SAC
reports
* Design and development of S/4HANA API along with custom fields and provided the ODATA source for
Power BI reporting
* Created custom CDS views using the Integration views from content in s/4hana on-premise and
developing sales and financial planning stories/dashboard POCs in the SAP analytics cloud for the
Marketing team.
* Worked on existing BW enhancements and support projects
* Worked on end to end BW migration project from BW 7.3 on oracle to BW 7.5 on HANA activities
including all pre and post migration steps

Environment: Data sphere, S/4HANA on-premise, S/4HANA cloud, Fiori, SAP SAC, SAP BW, WEBI

Responsibilities/Deliverables:
* Creating functional and technical documents based on BRD and providing the estimations to the
business
* Analysis Nota Fiscal Tax report requirement from the business to understand the Nota Fiscal tax
system from the key business users and designed the data model to meet the various tax components
for the Nota fiscal reporting and designed the data model to meet the requirement in SAP Business
data-ware house from the requirement and developed the technical requirement.
* Worked from requirement gathering, business blueprint, realization and unit testing.
* Developed new Power BI queries to switch from WEBI queries for Leadership reports
* Done the Analysis of the existing Universe flows based on cubes and using advanced dso as source
by consolidating the relevant objects and migrated to Hana views and the WEBI reports respectively
* Optimized the existing Hana views and developed currency translation in the Hana views
* Designed many new flows from the Data source enhancement using delta till the WEBI reports
* Supported the designed the new WEBI reports during the failures for the distribution to the
business
* Designed new Power BI reports using source as Hana view and Denodo views

Environment: SAP BW 7.5 on HANA, SAP ECC, BO 4.2

Responsibilities/Deliverables:
* Supported completed project from off-shore with a team of 8 resources and done the estimation as
per the requirement and provided technical requirement s to the team. Prioritized the work within
resources to support 4 different regions to meet the deliverables.
* Integrated Sales CDS views from S/4Hana to BW/4Hana using analytics category with delta
functionality based on Timestamp
* Support provided to BPC models for the data loads
* Developed and migrated Analysis for Office report workbooks
* Provided completed end user training on Analysis for Office
* Analysis of the requirement for sales analysis, done the development and integration of store,
sales and inventory models and optimized models into Hana DB push down to support huge data
extraction
* Developed calculation views using sales data and done the integration of invoice and delivery
consolidation of sales model in native Hana using AMDP script
* Developed end to end models in BW on HANA with mixed Scenarios using calculation views and AMDP
scripts to push down the model into HANA DB
* Worked on Support activities and done new developments and performance tuning
* Supported the data issues and optimizing the data models
* Supporting major enhancements for Europe, Australia and US regions in BW
* Extensively developed APD's & OHD's to support the data for planning in various sectors
* Involved in the blocked Invoices process automation based on region in BW
Environment: SAP BW 7.5/7.4, SAP BW/4HANA 2.0, SAP HANA studio, SAP ECC with Hana DB & Oracle,
S/4HANA