Power Bi Sap Bw

Location:

Hoboken, NJ

Posted:

May 15, 2024

Contact this candidate

Resume:

Sathya Mobile: +1-332-***-****

SAP BW/* HANA Analytics Consultant Email: ad5p55@r.postjobfree.com

SAP BW/4 HANA Analytics Consultant with 11+ years of experience in modelling using SAP BW, HANA extensive knowledge of SAP Datasphere, SAP BTP Solutions and Enterprise reporting tools of BEx, AFO, BOBJ, MS Power BI with expertise in implementation, development, enhancement, migration, maintenance and support projects where as several SAP Analytics visualization using MS Power BI and SAC for different industries – Retail, Oil& Gas, Banking, Food and Manufacturing, etc..

Professional Summary:

Modelling: - Involved in developing different type of objects like Master, Transactional data Info Objects, Basic Infocube, DSO, MP, Infoset ADSO, CP, Info Packages and DTP.

Extractions: - Experience in Extracting data from ECC and S/HANA Extensively loaded statistical data using Technical Content, OLTP extraction data Loading (Full / Delta Up-Load), Extracting data using LO-Cockpit, CO-PA Extraction.

LSA & LSA++ Architecture: Involved in to design and modelling BW Powered by HANA Objects.

SAP BW ABAP: -Info Package routines, Field based Routine, Start Routine & End Routine Generic datasource using Extractions on CMOD logics using Function Modules, BADI Implementation and Creation & Enhancing Customer Exit Variables,

SAP BW/4 HANA: - Worked on SAP BW/4 HANA Info Models like OPEN ODS, ADSO, Composite Provider, ODP Frame work, HANA AMDP Transformation Routines.

SAP Native HANA Development :-Involving in Data Provisioning for SAP HANA DB through BODS, SLT and Smart Data Access(SDA), SDI with WEB IDE Cloud Analytics, Implementing stored procedures with SQL scripting, CDS Views.

Performance Tuning & Maintenance: - Performance Issues, Info Cube management using Compression, performance tuning using Aggregates, Rollup, Partitioning and generated Indices and Database Statistics and issues relating for Data Loading Sequence, Query Performance and HANA Info Views.

Scheduling: - Experience in creating Process chains, data load management, scheduling start process, batch scheduler. Monitoring process chains.

Bex Reporting: - Worked on BEx query designer and analyser in building Queries, Making global and local structures using Restricted key figures, Calculated Key Figures, Variables, Exceptions, Free Characteristics, Filters, Formulas, Conditions and Business analysis for Decision making.

MS Power BI: - Worked on Power BI Desktop to create various analytical dashboards that depicts critical KPIs such as Daily Sales, Daily Open Orders with slicers and dicers enabling end-user to make filters.

Worked on Power BI (Query Editor, Modelling, Data, Report tiers) with filters, DAX formulas, Measures, calculated columns, Charts the data model for data cleansing.

Generated ad-hoc reports in Power BI Desktop and sheared them using Power BI service to Nestle Sales Enable decision makers.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

SAP BOBJ & SAC : -Create Reports on SAP Business Objects 4.2 suite of products like WEBI, SAP Analytics Cloud(SAC)and Lumira Dashboard Reports.

Expertise in Integrate SAP Datasphere with SAP BW using SDI to development to support various analytics data models.

Worked on S4/HANA for real time reporting and positioning BW with S4 HANA CDS Views based on SAP best practices.

Good working knowledge of live data connections and import mechanisms within SAC strong in handling Data Actions and Advanced Designer (AD) scripts and Hands-on experience with SAP Business Technology Platform (BTP).

Technical Skills:

Business Warehouse : SAP BW/BI 7.3, 7.4, 7.5, BW/4 HANA.

ERP Application : SAP NETWEAVER 7.0, ECC 6.0, S/4 HANA.

Reporting tools : BEx, BOBJ, AFO, SAC, Power BI.

Functional Module : SD, MM, FI, QM, CRM, & HCM.

Data Base : SAP HANA, Oracle.

Programming Languages : SQL, ABAP/4 required in BW.

SAP Cloud platform : SAP BTP, SAP Datasphere

Education Qualification :

M. Tech (CN&IS) from Jawaharlal Nehru Technological University (JNTUH) – Hyderabad.

Project Details:

1. TD SYNNEX – SAP BW on HANA Development, Enhancement and Support project

Client : TD SYNNEX Corporation

Role : SAP BW/HANA Analyst

Duration : Aug 2019 to till April 2024

Organization : Cybage Software Pvt Ltd

Project Overview: TD SYNNEX is a leading global distributor and solutions aggregator for the IT ecosystem. TD Synnex access to the resources that meet the growing demand for the data analytics solutions that’s helping to maximise new revenue and margin Opportunities.

Roles & Responsibilities:

Gathered and analysed the requirement to replicate the ECC & S/HANA content using Data provisioning, Created Technical specifications and standard modelling documents for HANA models.

Created Analytical, Attribute and Calculation views (Script & Graphical) as per the requirement needs.

Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Developed different reports like Open Sales Orders, Prior day Billed, Daily Sales Orders, Invoiced Sales Orders, Sales View Report, Sales Details by Nestle Business Units (Sales Credits), Sales Baseline Reports, Summarized Sales Report

Monitoring the data loads from various source systems by means of HANA Load jobs.

Hands on experience in writhing SQL queries, Stored Procedures, DDL and DML statements, CE Windows’s functions.

Have been working extensively on enhancements dealing with CDS code logic changes, analysing the data discrepancies in CDS, Calculation views.

Worked on Composite provider, Transient providers, Advanced DSO (ADSO) and Open ODS view, ODP Frame works using SAP BW/4 HANA modelling tool in HANA studio.

Worked on SDI for replicating tables from different source systems

Experience in Importing, Exporting and Transporting BW objects and HANA models.

Good experience in HANA Expert routines in transformations (AMDP).

Analysis, design and implementation of SAP SLT for real time data transfer for Replication using Full, Replicate, Stop, Resume options.

Managing Incidents and Change requests using Easy Vista ticketing tool.

Monitoring the Data loads using Process chains.

Setup of Mass transfer ID for real time replication between SAP source system and target HANA system.

Used BW layer for consuming HANA models and reported using Advanced Analysis for Office and BOBJ WEBI reports.

Developed dashboard reports using SAP Bex, WEBI, AFO, SAC and Power BI to include all the required KPI’s using DAX functions.

Training and Documentation for domestic and global users.

Expertise in building restricted and calculated measures in SAP Datasphere.

2. TATA Power – SAP BW Development and Support

Client : TATA Power

Role : SAP BW/HANA Lead

Duration : Jan 2019 to May 2019

Organization : TATA Technologies Ltd

Project Overview: Tata Power Limited is an Indian electric utility company based in Mumbai, Maharashtra, India and is part of the Tata Group The core business of the company is to generate, transmit and distribute electricity. With an installed electricity generation capacity of 10,577 MW, it is India's largest integrated power company. Tata Power has been ranked 3rd in 2017 Responsible Business Rankings developed by IIM Udaipur. In February 2017, Tata Power became the first Indian company to ship over 1 GW solar modules

Roles & Responsibilities:

Maintained Info Cube, Transformations, DTP’s and Creation of Info Package and scheduling the data into the Data Targets.

Uploaded Transaction Data from the Flat Files as the Source System.

Extracting Master & Transaction Data using Generic Data Sources from OLTP.

Involved in Initializing the LO Data sources by Activating the Business Content Data Sources.

Maintaining the Extract Structure, generating the Data Source, Activating the Data Source.

Enhanced standard data flow by adding new fields to the standard data sources.

Created process chains using various processes to automate data loading, activation of DSO, drop and create indexes, attribute change run and DB statistics.

Extensively worked on BEx Designer for designing the reports using Conditions, Exceptions, and Variables & Structures.

Solving tickets related to various areas like load failures, report issues & data inconsistency problems.

Monitoring of data loading for master and transactional data on a regular basis.

Daily monitoring the Process chains and analysing the errors in data loads and resolved them.

Reconstructed the data requests from PSA in case of data load failure.

Monitoring of info packages and analysing the reasons for frequent failures of info packages.

Involved in solving different performance issues and analysed reasons for frequent data load failures.

Extensively worked on FI Data sources and COPA Data source Extractions.

3. UMOJA–OICT SAP BW on HANA Development and Support WEBI Dashboards & Reports for Analytics

Client : United Nations (UN)

Role : SAP BW/HANA Technical Programmer - Analytics

Duration : Oct 2016 to Jan 2019

Organization : Trigyn Technologies Ltd

Project Overview: Office of the Information and Communication Technology (OICT) Develop SAP BW HANA Development, WEBI Dashboards & Reports for Analytics.

Umoja is a single, global solution that is enabling efficient and transparent management of the United Nation’s financial, human and physical resources and improving programmatic delivery.

Roles &Responsibilities:

Importing the BW Models using in to HANA using HANA Studio and Developed the HANA Data Models like Attribute Views for master data, Analytic Views for Transaction Data, Calculation Views Graphical & SQL Script to Join/Union the various Attributes, Analytic Views for report consumption.

Extensively working on BW on HANA Create Calculations Views using inner filters like variables & Input parameters for calculated Columns.

Worked on HANA optimized Cube’s, Composite provider, SPO, Advance DSO, Open ODS view, Transient provider, Virtual provider, Imported BW models to HANA.

Created WEBI reports on top of BEx Queries and Calculation Views for data analytics.

Designed and Developed WEBI Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down and Formulae to analyse the data.

Created user Prompts, Input Controls, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and requirements of the end users.

Actively involved in root cause analysis to improve report Performance at report level & database level.

Resolve the Errors in the report using simple techniques.

4. C – MINE: Enhance SAP BW Models Development & Migration in to HANA Studio

Client : TASNEE – Crystal Global

Role : SAP BW Consultant

Duration : Dec 2014 to Feb 2016

Organization : Yash Technologies Ltd

Project Overview: Tasnee – Crystal Global Mining the Petrochemical & Titanium Products.

Load the data from flat file and standards data sources in to the Targets using Multidimensional modelling. Monitoring process chains and fix the data load failures. Migrate BW Objects in to HANA Studio for more Performance.

Roles & Responsibilities:

Involved in complete life cycle Implementation which includes analysis, data modelling, design specification, development, data extraction, reporting, performance tuning, and Technical unit testing.

Used new Delta Mechanism of BI, configured Full & Delta loads from single Data source to different Data targets.

Corrected Erroneous records in Error Stack and executed the Error DTP to continue the loading process as part of testing in Quality Box.

Used DSO objects to stage the data from different data sources and transferred the DSO contents into various data targets based on the requirement.

Collected and transported all objects into their target Systems like Test and Production Boxes.

Created process chains using various processes to automate data loading and Schedule the Job’s.

Involved in escalating high-prioritized tickets regarding extractions, performance issues and also loads failures.

Extensively worked on BEx Designer for designing the reports using Restricted Key figures, Calculated Key figures, Variables, Structures and provided them to BO Team as per requirement.

Creating Customer Exit and Formula Variables using Function Module based on Requirement.

Involved in Flat file loading sent by the user which is daily or weekly basis.

Involved in daily and weekly meetings as per new Change Requirement and close the issues.

Created different SAP HANA information modelling objects like Attribute views, Analytical Views and Calculation views as per business requirement.

Creating Input Parameters and variables for reporting based on business requirement.

Worked on SAP BW Powered by HANA Concepts like ADSO, OPEN ODS, Views, HANA optimized info cubes.

5. PGMS–POWER: Implementation & Support, SAP BI 7.0, SAP BEx Designer, BO-WEBI 4.0

Client : Kirloskar

Role : SAP BW Consultant

Duration : April 2013 to Dec 2014

Organization : Business Intelli Solutions India Pvt Ltd

Project Overview: PGMS – POWER Implementation& Support, Bex, BO-WEBI4.0

An Energy Audit Study helps an organisation to understand and analyse its energy utilisation and identify areas where energy use can be reduced. Extract the data from multiple data sources, tables load into targets, Implementing data models and design methodologies in to SAP BI system.

Roles & Responsibilities:

Loaded Data from multiple Data Sources to multiple Data Targets with different Transformations and DTP's by scheduling different updates.

Loaded data from PSA to Data Targets using Transformations and DTP's

Used new Delta Mechanism of BI, configured Full & Delta loads from single Data source to different Data targets.

Corrected Erroneous records in Error Stack and executed the Error DTP to continue the loading

Process as part of testing in Quality Box.

Involved in the Process chain monitoring on a daily basis in BI7.0 system.

Involved in resolving issues related to process chain errors and corrective action.

Involved in performance issues like Aggregates, Roll Up and Partitioning the Info cubes to improve the query response.

Worked on extracting data from SAP R/3 System using LO Data Source Enhancement.

Involved in Generic Extractors using Function Module based on the Requirement.

Handled the Data source Migration/Maintenance, created new Reports with BI functionality.

Designed the Queries using Structures, Cells, Variables, Static & Dynamic Filters, Free Characteristics, Restricted Key Figures and Calculated Key Figures in Query Designer.

Written Field, Start & End Routines at Transformations level.

6. Tate & Lyle – Implémentation& Support, SAP BEx Designer Tool

Client : Tate & Lyle

Role : Associate Consultant

Duration : Nov. 2011 to March 2013

Organization : Business Intelli Solutions India Pvt Ltd

Project Overview : Tate & Lyle – Retail BI 7.0 Implementation & Support, SAP Bex Designer Tools. Install Business Content and Replicate data sources in to SAP Business warehouse system and create Bex Quires using Multiprovider.