SAP BI Manager : SAC BI HANA S4 Embedded Analytics and BPC

Project Handled :
Client : Dassault Reliance Aerospace Limited
Designation : SAP BI Manager
Project Type : Implementation
Environment : Analytics Cloud, Fiori KPIs, S4 Hana 1909

Roles & Responsibilities:
? Conduct workshops with COO, CEO and Team
? Requirements gathering, solution and design
? Identify KPIs and prepare design documents
? Guide team members on development and testing
? Guide team members on test scripts



Project Handled :
Client : Mylan
Designation : SAP BI Anlytics Lead
Project Type : Implementation and support
Environment : Analytics Cloud S4 Hana 1911

Roles & Responsibilities:

? Developed Stories / Dashboards, Geo Maps, Hierarchies, Smart Discovery, Smart Insights and
Linked Analysis.
? Data Visualization, Deep understanding of data designed and storage in OLTP(ECC/S4).
? Understand the Gap and provide the solutions




? Manage internal application owners and external business partners.
? Worked on Design Studio, Smart Business KPIs , Custom Analytical Queries , Report Modeler
and Query browser.
? Used CDS views in Custom Analytical Query App
? perform drill-down by selecting row & columns and performed filtration and sorting
? Make settings for display options: key and description, key figures in thousands etc.
? Display in table, chart or both views
? Export to Excel
? Save as Tile in some user defined Fiori Tile Groups
? View of hide subtotals
? Save variant of report
? Add fields in table to data-source ,Business Context and Fiori App
? Worked on S4HANA 1911 Embedded Analytics powered by UI which are tightly integrated
with Concur, Ariba, Field Glass and Success factor.

Project Handled

Client : McKesson Corporation
Role : SAP BW BPC Consultant
Project Type : Migration and Implementation
Environment : SAP BPC 10.0, ECC 6 & BW 3.5 -BI 7.1



Roles & Responsibilities:

? BW Sandbox, Dev and QA systems testing after refresh and Data center migration
? Involved in Migration Activities
? Backup and Restore
? Maintain Global parameters in SPRO
? Worked with users and functional teams to gather requirements
? Creation of ADSO , Cubes and Multi providers
? Creation of transformations and DTPs
? Creation DM Packages to load data from ECC to BW
? Creation of DM Packages to load data from BW to BPC models
? Creation of Transformation and conversion files




? Define Versions of EPM and Analysis tools
? Developed reports on EPM
? EPM Addins installations on user machines
? BPC House keeping and Archiving.
? BPC processs chain triggering from front end(BPC) & back end(BW)
? BW & BPC Load Monitoring.
? BW & BPC Optimization
? Worked on BW and BPC transports to move objects across the Dev, QA and Production systems

Project Handled

Client : Estee Lauder, Melville, NY
Role : SAP BW BPC Consultant
Project Type : Implementation and Support
Environment : SAP BPC 10.0, ECC 6 & BW 7.1

About Client: The Estée Lauder Companies Inc.is an American manufacturer and marketer of high-end
skincare, makeup, fragrance and hair care products. The company owns a diverse portfolio of labels,
distributed internationally in up-market department stores, and has its headquarters in Midtown
Manhattan, New York City.




Responsibilities:

Consolidation:

? Created Environments and models
? Created Dimensions and maintained the master data.
? Worked on BW - BPC integration.
? Worked on master data and transaction data loading from BW to BPC
? Business rules setup like Intercompany eliminations and Ownership
? Created legal reports and management reports.
? Worked on complex logic scripts to achieve the business requirements
? Created DM packages


BW Implementation and Support:

? Enhancement of standard Data Sources
? Creation of Generic Data Sources from table, view, Function Module
? Loading data into data targets from source system
? Transportations
? Created routines in transformation layers
? Performance Optimization (Aggregation , Compression of info cube, PSA Deletion)
? Developed simple user interface to load data from flat-file (Special Requirement)




? Creation of New Reports and modification in existing reports
? Data Load Monitor and Fix of loads
? Data reconciliation
? Unit and System Testing of own work and as required within the team.
? Review of technical specifications within the Team
? Involved in the design of new change requests (New development requests)
? Work on the production issues
? Documentation of the work done, Unit test cases etc.
? Worked on Collecting Transport requests of the objects like
Infocubes,ODS,InfoObjects,InfoPackages,Process Chains and its variants,Bex Queries,Web
Templates and Web Items and transporting these collected objects into their target Systems
like Test and Production Boxes.
? Involved in creation of OSS message to SAP for any critical issues, which requires the solution
from SAP.
? Well experienced in automation of broadcasting the Bex queries using Information
Broadcasting.
? Involved in creation of Process chains and also involved in transportation of created process
chains and its variants.
? Checking for the missing indexes for Infocube and as well as for Aggregates and recreating the
missing indexes, once the data is loaded successfully.
? Performance tuning at Query level and as well as at the Data Target level.
? Worked in performance aspects like Secondary index creations, Aggregates, Rollups and BW
Statistics.
? Worked both on Global and Local Structures, Conditions, Exceptions, Free characteristics,
Filters in Reporting.
? Worked extensively on all the monitoring and production support activities and also involved
in all data load and data maintenance activities and also involved in analysis of short dumps
and job logs etc.
? Worked in Reconciliation of data between SAP BW and with its source systems using the excel
features.
? Worked extensively on system refresh activity (FHOP) and Data Disaster Recovery.