SAP BW Consultant, SAP BW/BO Consultant, SAP BW/BO Consultant

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.

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.

Reports Delivered
* Direct Price Report
* Indirect Price Report
* Accounts Receivable Report
* Accounts Payable Report

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.

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.

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