SAP BW4HANA Consultant

Description: Arcelor Mittal is the world's largest Steel producer headquartered in Luxembourg.
Environment : SAP BW 3.X and 7.5 systems, BEx Analyzer and SAP Business Intelligence Analyser Tool
Role: SAP BW Team Member

Activities:
* Scheduled multiple Process chains based on Frequency requested by the business using event
parameters.
* Performed data refresh from R/3 systems to BW systems for every 3 months into different landscapes of
quality systems.
* Involved in Data Modeling by creating Info providers, Info-Objects, Info-areas and maintained them after
going live.
* Used BEx Query Analyzer of versions 3.X and 7.5 for generating Queries and Reports which gives data for
BI Reporting Tool through which we connected to OLAP data sources. It helped business managers to
analyze business data and make further decisions.
* Performed Data Load from an Excel Flat File to the BW service system.
* Assigned necessary roles to the business users to provide access to the transactions which they use, by
maintained roles using the transactions SU01 and SU10, for the requests which we receive through
Service Management Tool.
* Generated reports from the SAP Business intelligence Analysis Tool which is on SAP BO-BI platform that
gets data from HANA based FI.RE system.

Description: Nestle is the world's largest Food and Beverage production company headquartered in
Switzerland.
Environment : SAP BW SEM and BIM and BIG systems and Central Processing Scheduler
Role: SAP BW Team Member
Activities:
Worked in 2 different roles in this Project.

QA Team
* Worked in RTE (Regression Testing) and PP (Pre-Production) environments for monitoring and correcting
Process chain failures.
* Identified critical development defects in Process chains and collaborated with respective teams for
correction/removal.
* Identified risk factors to stabilize the loads and performed modifications as per the requirement from
the business.

Production Team
* Managed data loading by scheduling/de-scheduling Process chains (data loads from source systems) via
CPS (Central Process Scheduling) tool, and Extraction & APD jobs in BW as per data flow needs.
* Managing and correcting failures in dataflow using DTP (Created and scheduled the Error DTP to handle
the error records in the Error Stack) , Info Packages and worked with transactional data sources to load
data from SAP R/3 and Flat Files into SAP BW. Created reports using Bex Queries.
* Worked on Routines in transformation of data for extraction.
* Regularly monitored System Performance for Runtime Errors, Response Time, Duration & Delay of Jobs,
Availability of Process Servers for background & dialog job execution.
* Responsible for 100% report availability to each individual market in GC before respective Go Live of
markets.

HANA Migration Team
* Worked on BW HANA Migration for AMS (American Zone) System, worked on Pre and Post-checks for
migration.
* Involved in developing on BW on HANA objects such as Composite providers, ADSO, Open ODS Views,
ODP Extractors.