Application development Team lead - Accenture
(2024-10)
Client: Dupont. Environment: SAP BW on HANA. Visualization Tool: MS Power BI.
- Creation of data flows related to BP and EHS from ECC
- Worked on complete cycles which involved different phases like Project definition -> BBP -> Technical design -> Extractors -> Modeling -> Reporting -> User Tests cases
- Involved in BIT and UT testing
- Creation of historical data flows using infocubes and multiproviders
- Creation of power bi dashboards
BW on HANA application team lead - Accenture
(2022-10 - 2024-09)
Client: Bridgestone. Environment: BW on HANA, SAP BO. The project is for rebuild of data models for Bridgestone.
- Creation of Calculation views based on ECC logic
- Creation of composite provider and integration with HANA data models
- Participated in on-calls during implementation and participated in baseline testing during cutover
- Enhancement of BW data flows and exposing HANA views to Alteryx reporting
- Extensively worked on BO data quality issues. Complete debugging of reports from reporting layer to source
Data Engineering consultant - Accenture
(2021-10 - 2022-09)
Client: Dupont. Environment: HANA, SAP BODS. The project is for Dante and Venus which included data migration between clients.
- Creation of BODS jobs based on ECC logic and transforming data to HANA
- Creating Calculation views in Hana based on org elements and loading data to client
- Participated in on-calls during project cutover and extended support for loading historical data based on client's requirements
SAP BW4HANA/HANA Developer - Tech Mahindra Limited
(2017-01 - 2021-09)
Client: Nestle. Environment: SAP Enterprise HANA 2.0, SAPBW4HANA.
- Extensively working on Hana Graphical calculation view, attribute view, ADSO's and Composite provider
- Creating Information Models (Calculation Views) as per the business requirements
- Creating Input Parameters and Variables for reporting based on business requirement
- Worked on inner join, left outer, right outer, text join, temporal join and referential join
- Extensively creating Calculation Views using node-Join, Projection, Rank, Union and Aggregation
- Transported HANA views from DEV, QA to PROD environment
- Worked on HANA activities such as setting up HANA environment – adding a system, creating schemas, Column Tables, packages, change request maintenance etc
- Experience with different types of joins/Union and cardinality
- Worked on creating calculated columns, filters in Calculation views, and input parameters for various business requirements
- As a key resource handled data load issues from ECC end and also reporting level issues from the users
- Handled change requests and new development requests as well
- Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and Composite providers
- Installing and creating BI objects like info objects, DSOs, Info cubes
- Data Source Enhancement according to customer requirement
- Creating and managing dataflow using DTP, transformations and info packages
- Experience in Data loading, Monitoring and Scheduling using Process Chain
- Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system
- Created Transfer rules, update rules using ABAP routines builder while creating Cubes and ODS
- Involved in creating Advanced DSO for Reporting Layer and Composite provider
SAP BW ON HANA Consultant - Tech Mahindra Limited
(2015-02 - 2016-12)
Client: Nestle. Tools: SAP-BW BI 7.0, BW 7.4, Service Centre, HP Service Manager. Nestle has implemented BI/BW classified widely under six business areas (Finance Control, Generating Demand, Demand Planning, Procure to Pay, Technical Production, Customer Service) in order to complete the business requirement of Nestle.
- Publishing business reports as per the market timings
- Extensively involved in the resource selection, induction and training programs for the project
- Monitoring data loads from various source systems like R/3, CRM, SEM, COM, and SDR by means of process chains, analyzing the errors in the data loads and fixing them
- Loading Master data, Transaction data and hierarchical data into the SAP
- Working with Offshore and onsite basis consultants to resolve the issues related to load failures with memory or table space
- Handling tickets raised by markets for the issues related to data discrepancy in BW reports
- Analyzing the data flow in BW via Update rules, Transformations
- Finding root causes for data discrepancies in BW reports
SAP BO Consultant - Tech Mahindra Limited
(2014-05 - 2014-12)
Client: Nestle. Environment/Tools: SAP BO 4.2 SP6 P13.
- Performing acceptance testing and sanity checks and post tests after tool upgradation
- Comprehensive tool testing which include IDT, UDT and WEBI rich client applications and client tools like BI launchpad and CMC
- Creation of Adhoc reports on Universe, Bex, Excel sources and validating the report functionalities like filters, rank, conditional formatting etc
- Creating sample universes based on Hana, BW and validating Hana connectivity etc, Creation of project, OLAP and single layer and multilayer Data foundation, defining joins, prompts LOV's and cascading LOV's
- Handled high OSS request with SAP and Co-ordinate with different teams like Basis for the implementation of hot fix
SAP BO Developer - Tech Mahindra Limited - Bangalore, India
(2013-03 - 2014-04)
Project: Nestle BO Development and Sustain. Client: Nestle.
- Promotion of Developed Universe(s), Webi Reports to the Production through BIAR file for end user access
- Managing security for applications
- Creation of users, user groups and managing security for users. Security is based on the user role/level in organization and which type of access the user has on the sensitive data of organization
- Assigning the restriction on the respected folders and AD groups
- Mapping the the AD groups to the respected folders
- Good in report analysis and design documentation
- Formatted Reports as per the User requirements using extensive functionalities in Business Objects, which allows the users to analyze the data
- Used Filters and Conditions to achieve report functionality
- Worked on creation of AFO and modification of AFO files based on requirements specified
- Providing support and development for SAP BO universe and reports
- Used different multiple functionalities like Breaks, Sections, Rank, Variables, Input Control, Filters, Charts etc
- Resolved the Loops by using Aliases and Contexts
- Resolved issues that were raised during the scheduling
- Schedule reports to run and refresh periodically
- Interacted with users for analyzing diverse reports and scheduling them
- Monitoring closely the defects fix turnaround time and work towards faster & effective closure of incidents
- Resolved data mismatch issues by comparing data with backend data
- Able to manage escalations, issues and risks
- Handled various tickets for business objects issues for the end users
