Profileimage by Viha Dakshayane SAP BW Consultant, SAP BW/BO Consultant, SAP BW/BO Consultant from Chennai

Viha Dakshayane

available

Last update: 06.09.2022

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

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional)

Skills

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.

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

10/2015 - 01/2016
SAP BI Consultant
Customer Ranbaxy

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
Profileimage by Viha Dakshayane SAP BW Consultant, SAP BW/BO Consultant, SAP BW/BO Consultant from Chennai SAP BW Consultant, SAP BW/BO Consultant, SAP BW/BO Consultant
Register