SAP BW, Data, Analysis, Design, Development, Implementation, and Testing & Debugging, Data Services, Business Objects, Office, Design Studio, WebI, data modeling, SAP, requirement gathering, HANA, Web Services, SQL, data consistency, SAP BI, R/3, formula, BEx Query Designer, legacy system, Sybase, CMS, Database, MySQL, Sybase IQ Services, Interfaces
Project history
08/2018
-
05/2019
SAP BW Consultant
UST Global; OSRAM
Project Development
Role SAP BW Consultant
Responsibilities / Deliverables
* Done requirement gathering for new Change Requests
* Implemented the CRs, documented and explained the solution to client.
* Worked in SAP BW 7.5 by using HANA studio and Lumira Designer 2.1 for Reporting.
* Created new ADSO (DSO & Info cubes property), Composite Providers, Time Dependent display and
navigation attributes, BEx queries as per the requirement.
* Worked on retrieving data from Sales Force to BW by creating Web Services Data source and the
subsequent data flow objects in BW.
03/2018
-
06/2018
SAP BW Consultant
No.2 : Datamatics Global Services Ltd
Employer No.2 : Datamatics Global Services Ltd, Bengaluru, India
Client Robert Bosch - India & Germany
Duration Mar'18 to Jun'18
Project Development
Role SAP BW Consultant
Responsibilities / Deliverables
* Done requirement gathering for new Change Requests
* Implemented the CRs, documented and explained the solution to client.
* Worked in SAP BW 7.5 by using HANA studio and Lumira Designer for Reporting.
* Created new ADSO (DSO & Info cubes property, Composite Providers, Time Dependent display and
navigation attributes, BEx queries as per the requirement.
12/2017
-
03/2018
SAP BW/BO Consultant
EIM Solutions India (P) Ltd
Project Development
Role SAP BW/BO Consultant
Responsibilities / Deliverables
* Involved in Documentation work during Blueprint phase of the project.
* Client Interaction & Requirement Gathering for new report development.
* Installed and activated BI Content objects for all master and transaction objects and handled data
load from various source System to BW.
* Created new DSO, Info cubes, Multi Providers, Routine, Data source & BEx queries with CKF, RKF, as
per the requirement.
10/2016
-
11/2017
SAP BW/BO Consultant
Olam Information Services Ltd
Project Development & Support
Role SAP BW/BO Consultant
Responsibilities / Deliverables
* Worked as a business analyst for Inventory Report - US Black Line Project and Coffee Project.
* Enhanced the Material Revaluation data flow as per business requirement to get the Standard Price
and Moving Average Price based on Plant and Material.
* Created Generic Data source based on Function Module (to fetch Mat Price) and handled data load
from various source System to BW.
Reports Developed
* Sales and Operations Report.
* Black Line Report for Singapore and US origins.
* US Coffee Position Report.
02/2016
-
09/2016
SAP BW Consultant
Sun Pharma
Project Development & Support
Role SAP BW Consultant
Responsibilities / Deliverables
* Involved in Requirement Gathering for new reports development.
* Created iViews, Work set and Role and published BEx Queries in Portal.
* Worked on providing authorization to users to view reports in Portal.
* Created and automated Process Chain for the newly created info providers.
* Generated Data source and handled data load from SQL System to BW.
* Enhanced Info cube and Multi provider by adding Cal week information.
* Reloaded history data for newly enhanced objects and validated data consistency.
Project Development & Support
Role SAP BI Consultant
Responsibilities / Deliverables
* Data extraction from SAP-R/3 (LO-cockpit and Generic extractors)
* Analyzed the required data availability in existing data flow and reused it.
* Included various Routines in Start Routine, Field Routine & End routine for Lookup and Data
Manipulations.
* Involved in transport activities.
* Involved in performance tuning of queries in modeling level, query-designing level, Compression,
Creation of aggregates, and Sequence of data loading.
02/2015
-
09/2015
SAP BW Consultant
Albatha
Project Development & Support
Role SAP BW Consultant
Responsibilities / Deliverables
* Created Info providers combining Sales Cube (to combine Actual and Plan data which is loaded
through flat file) and Inventory Cube.
* Worked on deriving the logic for Stock Quantity and Stock Value and created formula in BEx Query
Designer to achieve the same.
* Re run of data load from PSA to Inventory Standard Cube and other data targets. The process
involves deleting the previous requests from both the cubes till a particular date and pulling data
from BF and UM data source to PSA and then to the corresponding targets.
* Enhanced the Inventory Standard cube (0RT_C01) by including new fields (Material Doc No., Storage
Location, Posting Date) and mapped these fields in Transformation and loaded data to the Standard
Cube.
Reports Developed
* Daily Sales Margin Report.
* Top Seller Report.
* Stock Ageing Report.
09/2014
-
02/2015
SAP BODS, BOBJ Consultant
Customer
Project Implementation
Role SAP BODS, BOBJ Consultant
Responsibilities / Deliverables
* Created BODS jobs to load data from legacy system to Sybase.
* Scheduled all the BODS jobs to run automatically by establishing connection with CMS (Central
Management Server).
* Created new user and assigned their rights and privileges to access the BO System.
* To take back up of the objects (BODS, WEBI Reports, Database - MySQL and Sybase) developed in one
server and restore the same in another.
* Created Ad-hoc query to combine data from 3 different source systems (LAIFOMS, Riverbank &
Strathmore) and show the Overall Revenue collected.
* WEBI Reports Developments including User Friendly Layout designing, Variance, Exceptions,
Conditions, Filtering, Sorting, Drill Down, Dynamic change in Report data based on User Input.
* Startup BODS and Sybase IQ Services after unexpected power failure or System Restart after Upgrade
(Planned or Unplanned).
* Enabled WEBI Reports in Mobile Category to view them in Mobile or IPad.
* Created Interfaces between Database and Reporting Tool WEBI.
Reports Developed
* Property Outstanding Balance
* Housing and Stall Detail and Summary Report
* Kiambu Overall Revenue Report
* Market Book Value Report
Local Availability
Only available in these countries:
India
SAP BW Consultant, SAP BW/BO Consultant, SAP BW/BO Consultant
Follow profile
You need our Enterprise membership to view this information.