4 Hana Sap Bw

Summary

Having **+ years of experience in SAP BW applications, involved in different projects at phase of Implementation, Enhancements, Support & Maintenance in BW 3.5, BW 7.0, BW 7.3, BW 7.4.,7.5,and BW/4HANA, S/4 HANA Embedded,SAP Business Objects, SAP Datasphere .

Immense project Implementation experience in diverse industries including Retail,Pharmaceutical, FMCG and Manufacturing

Utilizing strong analytical and adaptive skills in implementing various business Reporting applications using SAP BW/4 HANA, BW HANA, Native HANA, S/4 HANA Technologies and Power-BI and Tableau.

Proficient in Enterprise Architecture, Project/Program Planning, Process analysis, Gap analysis, Solution implementation and Delivery.

Expertise in Native Hana: created SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical, SDA (Smart Data Access), and worked on different perspectives.

Working on SPS12 HANA Modelling, HANA studio, SQL Scripting, Table partitioning, SQL Stored procedure, Privileges, SLT replication), BW/HANA (Composite Provider, ADSO on LSA++ architecture).

Designed and optimized SQL queries for complex data extraction and analysis.

Implemented parameterized queries and filtering logic to support dynamic reporting needs.

Built advanced SQL-based Calculation Views for real-time analytics in SAP HANA.

Created SQL-based virtual tables and CDS views for seamless data integration.

Utilizing experience in enhancing Data Services jobs, HANA models and applying patches on HANA.

Using cloud tools like Microsoft Azure – Data Lake added to a Power-BI as a dataflow to build sematic models.

Got trained on Tableau and created dashboards along supporting the Reporting Issues.

Working with various phases of Software Development Life Cycle (SDLC) methodologies based on Agile, Scrum, and Waterfall Model.

Working to quickly learn and deliver solutions as an individual and as part of the team.

Utilizing expertise in supporting large user groups of different markets and zones.

Deep working knowledge in SAP ERP (MM/SD/ OTC /CS/PP/FI/AR/AP/H2R /P2P/RTR), SAP EWM, SAP HANA, SAP BOBI, and exposure to new analytical and reporting solutions.

Education:

B Tech - 2011 from Jawaharlal Nehru Technical University, Kakinada, India.

Technical Skills:

Data Warehouse : SAP HANA, BW/4 HANA, SAP BW 7.4,7.3,7.0,3.5, SAP SLT, S/4 HANA,

ERP : ECC 6.0, S/4 HANA

Design Environment : HANA Studio, Eclipse, Analysis Office,SAP BO(Webi ),Bex query Designer

Reporting Tools : SAP BEx, Web Intelligence, Power BI, Analysis Office

ERP Functional : SAP – SD, OTC,MM,CS, FI,CO

CPS Tools : Redwood, Ctrl-M,BMC Remedy

Ticketing Tool : Service Now, Jira

Dash boarding Tools : Xcelsius/Dashboards

Programming Language : SAP ABAP, SQL

Wal-Mart April 2022 to Till Date

SAP BW Consultant

Project scope is to develop and Maintain artifacts using SAP BW/4 HANA and Analysis for Office for (GL & AP,AR Modules ) on S/4 Data sets migrating for ECC.

1)Migration Project from BW HANA to BW/4 in aligning with source Migration from ECC to S/4 .

2)

SAP S/4: Worked with ACDOCA, ACDOCC, BKPF, BSEG and Master data tables KNA1, T009, CEPC etc.

SAP BW/4 : Involved in design, development and maintenance of following objects as part of project requirements

- Designed Data models using ( CP, Complex CV using SQL, ADSO, Open ODS Views, Open Hubs) for G/L Interfaces and Conversions

- Designed Complex Queries and Recon Models for Down streams

- Extensively worked on Conversions Models as part of the S/4 Migration

- Transports, UAT,SIT,FUT,TS

Lead and Involved in Design and development of BW models/Reports development for Fuel System and Manufacturing System .

Involved in source data feed validations in initial analysis phase as part of onboarding new source system to BW env.

OData: Involved in creating Sub Query’s from existing complex Bex Query’s with Multi structure to feed React services using OData

SAP BWHANA: Modified Complex Bex Query’s to source with OData to React Services,Made some custom changes as per changing Business needs.

Performed source system Swap and Data source and Data validation post source system upgrade.

System size analysis and fixing the system alerts and streaming lining cleanup activity along with data retention policy

Involved in source data feed validations in initial analysis phase as part of onboarding new source system to BW env.

Environment: SAP BW/4,,SAP S/4, SAP Fuel,BW on HANA, SAP ECC, AO, Power BI, Looker.

Hewlett- Packard Oct 2021 to April 2022

Sr SAP BW Developer

Project scope is to develop artifacts using SAP HANA, BW4HANA and Analysis for Office for General Ledger and Consolidation reports based on SAP S/4 datasets. Development project.

SAP S/4: Worked with ACDOCA, ACDOCC, BKPF, BSEG and Master data tables KNA1, T009, CEPC etc.

HANA: Involved in design, development and maintenance of following objects as part of project requirements

- Calculation Views

- Calculated and Restricted Columns, Input Parameters and Variables

- Transports, Import/Export, Delivery Units and Application Life Cycle Management

- Worked with the objects Aggregation, Union, Join, Projection, Star Join, Currency

and Unit conversions

SLT: Configurations for HANA and SAP S4/ECC, Table Replication and Maintenance, Performance, Data filtration and addition of new columns

SAP BW4HANA: Composite providers, Info Objects based on HANA views and Hierarchies, Transporting the objects across the landscape, Queries and Web Intelligence and Analysis for office reports

Cut over activities, Production readiness and Go-Live

Documentation and knowledge transfer

Environment: SAP S/4, SAP BW/4 HANA 2.0,SAP SLT,SAP ECC, AO

VIATRIS Inc Aug 2020 to Oct 2021

Sr SAP BW Developer

Project scope was to develop new artifacts, support and work on enhancement related activities on the landscape of SAP HANA, SAP BW and SAP Business Objects. Implementation project

Project scope was to develop new artifacts for Advanced planning system for feeding data to Rapid response on the landscape of SAP HANA, SAP BW and SAP Business Objects. Implementation project

Worked closely with client counterparts and internal teams to analyze business problems, gather requirements, testing and delivery estimations, solution modelling and project plan layouts

Involved in Developed and Enhanced of APS flows if feeding data to rapid response

Prepared Technical Specs for Enhancements/CRs

Developed information views including Calculation views and used rank function.

Worked on stored procedures for HANA table loads, Upsert and Update of data

Converted Standard info cubes to HANA Optimized cubes

Technical analytical capability for SAP HANA

Object modelling: Calculation’s view (graphical and script based), Procedure, Table Functions, Analytical View and Flowgraphs, etc.

HANA Data Extraction/replication, SLT/SDI

Version: SAP R/3, BI 7.3,NATIVE HANA,SAP BW/4,S/4

Mylan. Inc May 2018 to Aug 2020

SAP BW Consultant

Project scope is to add the new line of Business and new markets in the existing reporting system .

S4 HANA CDS Views Modelling with annotations

Designed end to end HANA data flows with Foundations, Attribute, Analytical and Calc Views

Created HANA model for BW objects consuming data from BW in HANA

Worked on eclipse BW modelling tools for objects creation including Open ODS view, ADSO and

Composite provider using joins and unions

Involved in transport of delivery units to quality and production

Go-Live support and hyper care activities.

Got trained on Power BI and created dashboards along supporting the Reporting Issues.

Involved in migration of CPS tool -Redwood to Control-M systems (System for Scheduling the data loads in BW)

Version: SAP S/4, SAP BW on HANA,NATIVE HANA

Nestle Feb 2016 to June 2017

SAP BW Functional Consultant

Project scope is to maintain and support the existing models and provide support to business on Reporting issues, by supported global user group, mainly focused on enhancement and maintenance activities of SAP BW and handling incidents and Bug fixes

Functional BW consultant for GD and CS and P2P

Analyzing report functionalities, scope and working on report functional issues

Collaborate working with the functional teams, in issue tracing and fixing

Worked on investigating data related issues in BW to compare the data with ECC, helped users to understand the issues and fixed them.

Analyzing user stories (requirements delivered in User stories) and functional view of BW solution Approach

Data treatment in transformation through routines (Include Programs)

Creation of info providers according to LSA guidelines.

Assessing size of data targets for Analysis purpose

Working on complex transformations and routines (Start, Expert and End routines ), De bugging Standard extractors

User training and taking part in new BR requirements with functional owners and RBS teams

Involved in the reconciliation of the data between BW and R/3 during source system upgrade.

Assisting the Monitoring and CM teams when implementing new CR and recoveries

ARGAS, Saudi Arabia July 2013 to Jun 2016

SAP BW Consultant

Project Scope is to develop new reports and to fine tune the existing query’s and data flows to optimize the performance it’s a Development and support Project, where I have created reports and optimized queries for better performance and Enhanced sales data flows

Ensure the loads are completed as per the SLA and help the offshore team for any issues when required

Involved in solving performance related issues. Analyzed query performance to

suggest optimization as per the observations.

Working on reports in the areas of Sales and Distribution, Material management, Financials etc.

Created variables at Query level for user-inputs or being processed with customer-exits .

Working on start, end & field routines used for data manipulations in BW side

Developed user exits for variables at report level for assigning default values & for validation of inputs entered by the user.

Enhanced the ABAP code at the start routine level in the update rules to avoid frequent failures of the data loads due to special characters.

AIG (Astra Industrial Group) May 2011 to June 2013

SAP BI Developer

Project scope was development and support of SAP BW system. Activities included development, post Go-Live support and day to day data load monitoring and maintenance Activities.

Environment: SAP BW 7.0/7.3, SAP ECC 6.0

Responsibilities:

Involved in Developing Custom Info Objects, Basic Cubes for specific Customer requirements.

Involved in Extracting Master Data and Transactional data from ECC to data targets in SAP BI system.

Loaded objects with Master data and Transactional data from flat files by creating Info packages.

Worked extensively on standard and custom defined LO-Cockpit. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information.

Installed number of Info Objects, Info Sources, DSO and Info Cubes from Business Content and later customized some of these objects to meet the business requirements.

Contact this candidate